2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Using Forms to Streamline date to Personal Finance Book project.

I am currently creating a Personal Finance workbook using Microsoft Forms and Excel.

My main question before I explain the build is. Am i wasting my time using Forms? Is there a better method to streamline information into Excel? I tend to forget to do things so I wanted the fastest easiest method to log data.

Also has anyone else done something like this using Forms? I’m aware there’s millions of Finance books on the web. I’m using some as inspiration. I honestly just wanted to create my own because I enjoy using Excel.

The goal here is to make everything on the Excel sheet automatic.

Current Build-
1- Input Data using Forms survey.
2- Data is imputed to a Raw Transaction sheet
3- Filters into a Clean Transaction sheet
4- Filters into multiple sheets from here ranging from Accounts, Bills, Bill status (this sheet tracks due dates, amounts, paid or not paid), Monthly summary, and debt visibility. (Long story short Clean transactions filters all the data into separate dedicated sheets for different type of transactions.)
5- Dashboard where everything is cleanly viewed.

Overall it takes 5-10 seconds to input data through the Forms. Created a Shortcut on my Phone to create easier access. As of right now it is fully automated with only 1 source of input.

I’m not posting the build yet because it’s in very early stages still. Overall the input system and formulas work.

Future features that are in the works but not completed or not started are:
1: Bank CSV import system.
this should use a helper sheet to map each merchant by bank statement names, auto bill recognition in case i forget to submit something, Auto account balances (I would be thinking of inputting the CSV files monthly?)
2: Mortgage readiness
3: Emergency fund goals
4: Debt-To-Income analysis

Overall do yall have any advice for this project? Is forms the best choice for this long term?

submitted by /u/steelerswins
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#data analysis tools
#big data management in spreadsheets
#Excel compatibility
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data cleaning solutions
#natural language processing for spreadsheets
#google sheets
#rows.com
#automated anomaly detection
#financial modeling with spreadsheets
#real-time collaboration
#Personal Finance