That is, the total amount of income must match the total amount of expenses in order for it to work. (Note that this term also has another meaning, see Wikipedia, but that's not what I'm talking about). This spreadsheet is based around the idea of a Zero-Based Budget In order to use this spreadsheet you'll have to decide what accounts you want to track with it and how you'd like to categorize your spending. transfer: money moving from one account to another.checking account, wallet / envelopes, mortgage, credit card, etc.) account: something that can contain money/debt (e.g.Compare projected costs with actual costs to hone your budgeting skills over time. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. If you feel like helping out please improve it and submit a pull request!)īefore we dive in, I want to define some terms that I'll be using: This Excel template can help you track your monthly budget by income and expenses. ![]() ( Note: This documentation is incomplete. If you get stuck feel free to post a question in the "Issues" section of the Github repository. Read the instructions in the blue text boxes and try it out. Use our Excel spreadsheet version if you want to access your budget. (It does not contain any VBA scripting so might work in other spreadsheet software, but I have not tested this.) Our free online budget planner helps you track, plan and prioritise where your money. How do I use it?ĭownload the financial-plan.xlsx file and open it using Microsoft Excel. I use it and find it helpful so I've shared it with the public for you to do with as you please. They're designed to be hard / impossible to mess up and usually include free technical support.Īlthough I've tried to make this spreadsheet pretty robust (shouldn't be able to get wrong answers without intentionally disabling the worksheet protection feature) and easy to tailor to your needs, I make no guarantees about the accuracy of its calcuations, its reliability, or any other concern. If you're not comfortable working with an Excel spreadsheet and aren't interested in learning that, I recommend using a budgeting app like EveryDollar instead. I think it is a good compromise between a full-blown accounting system (I had been using GnuCash for years)Īnd pencil and paper (if you do this by hand, props to you for your patience and organization!).ĭISCLAIMER: Although it works great for my purposes, I'm an engineer and enjoy numbers, spreadsheets, formulas, source code, etc. that will help you keep track of your household expenses. Always have a professional spreadsheet ready for special occasions, weddings, household purchases, etc. When my wife and I took Dave Ramsey's "Financial Peace University" course in late 2012 we created this spreadsheet to plan and track our spending. Monthly income and expense excel sheet free download Now Monthly expense Excel template can help you improve your personal and household planning. Excel-based monthly spending planner Introduction
0 Comments
Leave a Reply. |