Forum Discussion
Excel Table Compatible Formulas and Recommendations for Budget Spreadsheet
Any Tips For This Math Wiz/Technology Noob Would Be Great!
An interesting combination. And from what you've written, it sounds like:
- you're hoping to create a budget sheet for others to use, not just for yourself
- you may be an accountant/financial whiz who hitherto has helped people with paper-based budgets
- you know a few basics about Excel and maybe GoogleSheets or other spreadsheet apps (just enough to know there's a LOT more to be learned)
So let me just say that you might want to begin by creating as much of that "ideal multifunctional budget calculator" as you can, perhaps by building off pre-exiting templates--though frankly a lot of them are deeply flawed. Go as far as you can, and then come back with that work-in-progress and ask for comments, suggestions, revisions.
In case you're not aware of it, Microsoft actually has a semi-official app called Money-in-Excel that links with some (not all) banks and credit-cards. It did not link with my bank (Fidelity) so I never went very far with it. But to that extent, you needn't invent the wheel; it's already rolling along.
Creating something for others to use--which it does sound like you're wanting to do--is VERY difficult, especially if you're creating it for novices at both math AND Excel. I have a pretty robust budget sheet that I've created for myself; it relies on monthly downloads and imports from each bank and credit card, and then the somewhat tedious task of going through and categorizing the various transactions into the appropriate budget category. Once all the work is done, the Excel Pivot Table does wonders in summarizing both expenses and income....but I'd never pretend that I could just hand that to a client (not that I have any) with the expectation that they'd know even where to begin.