Excel personal budget spreadsheet free#

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. (It does not contain any VBA scripting so might work in other spreadsheet software, but I have not tested this.) 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. 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. Drop down menus are available for easy data entry in these fields (Type, Category, SubCategory, Account).Īfter you enter your transactions, the Transactions worksheet would look like this image below.Excel-based monthly spending planner Introduction.Examples of Transfers are Credit Card Payment (transfer from Bank account to Credit Card account) and ATM withdrawal (transfer from Bank account to Cash).

‘Transfer’ type with positive amount for the account you are depositing the money into.‘Transfer’ type with negative amount from the account you are taking the money from.Transfer: When money is transferred from one account to another, create two records.If, a few days later, you returned the item to the store for some reason and get a refund, then you should enter the refund as a new Expense transaction with negative value. Special case (Refund): If you purchased an item at a store, you would enter an Expense transaction with positive amount.Income and Expense: By default, all the Income and Expense transactions should be entered as positive amounts.How much am I saving every month? How does that add to my net balance?.Am I spending more on any specific expense category over time?.How are my expenses trending over time?.Am I exceeding my monthly budget? If so, in which categories?.On what items am I spending my money on?.How much money is in my different bank accounts?.Specifically, the template helps you in knowing the following: With simple data entry, the template provides you instant access to actionable information in a consumable form that can answer key questions regarding your personal financial situation. This Excel Budget template also helps you set budgets and see how you are actually doing against your budget. This is a simple free Personal Finance management excel template that focuses on making it easy for you to know what’s happening with your financial situation especially when you have multiple bank accounts, credit card accounts and cash. Personal Finance Manager 2021 (Free Excel Budget template)