Want a Free Budget Planner Spreadsheet?
Building and maintaining a workable personal budget is essential for anyone looking to get out of debt, stay out of debt, and figure out what kind of cash flow they have available for investments. I have decided to post my own free personal budget spreadsheets in two formats, for free! I think you will find these versions to be clean, simple, and functional
Recently, I posted an article about how to create a personal budget, which gave the theory behind creating an easy to use personal budget. The spreadsheets included in this post have brought theory full circle and will give you the functional tool to do it. I have also included an easy-to-follow tutorial on how to use these spreadsheets.
Free Budgeting Spreadsheet – Excel or Google Sheets
For the 20somethingfinance.com free Google Drive personal budget planner spreadsheet:
- Follow this link: 20somethingfinance.com personal budget planner (Google Drive)
- Sign in to your Google account (if you aren’t already)
- Select ‘File’ and ‘Make a Copy’, or ‘File’ and ‘Download’
You’ll notice that you cannot edit this spreadsheet. In order to save and edit your own version of this spreadsheet, you’ll need to first log in to your Google account, select ‘File’, and ‘Make a Copy’. If you do not have a Google account, create one here. Now you should be able to edit your own version in Google Docs. Do not request to share as that will not do anything – just make a copy and use the copy for your personal use.
If you prefer an offline Excel (.xlsx) file or .ods or .csv spreadsheet file, you can also select ‘File’ and ‘Download’ to download the spreadsheet in the format of your choice.
How to Use your Free Personal Budget Planner Spreadsheet
Everyone’s personal income and expense lines are going to vary slightly from what you will find in this personal budget planner. Feel free to delete and/or add in rows. However, make sure that the formulas in the ‘Total’ rows compensate for your alterations. Here is a step-by-step process for filling out your budget.
1. First, grab your W2 so that you can input all of your income rows, in the section as shown below:
2. Next, collect your credit card and bank statements to fill out your regular expenses. If you have consistent one-time expenses (e.g. auto insurance) that you only pay once per year, pro-rate (divide by 12) to get a monthly budgeted amount, and then fill out the cell for the month the expense was paid. All months in which you don’t pay that expense should have $0 posted. The expenses section is highlighted below.
3. Now, you will want to account for one-off income and expenses for each month. First, click on the tab (at the bottom) for the corresponding month:
Next, you will want to fill out your one-time items:
Finally, add your totals on the corresponding rows (12 and 45 in the original) on the ‘Total Budget’ sheet:
You should really only need to update your sheet periodically as an income or expense item changes in amount, or at the end of every month as you you receive your statements. Ideally, this personal finance budget planner will allow you to predict how much cash flow you have available to spend during a given month so that you can plan throughout the year.
Now that you know what your budget looks like, the fun work begins – optimizing your monthly budget. It will be a lot of hard work and a challenge, but completely worth it. Check out a list of money saving products I use, in order to drive your costs lower on things like cell phones, internet, energy, water, insurance, and much more.