The Ultimate Budgeting Spreadsheet

I love spreadsheets for all facets of life and this next spreadsheet is for budgeting, and to help you get a grasp of your finances. This spreadsheet is for those looking to record their incomes and expenses by categories using a spreadsheet.

Here is a list of my other spreadsheets that may help you in your path to financial success!

 

Why use a spreadsheet to track your monthly budgeT?


Having a firm grasp on your budget is the first step to financial success and freedom. When I first started working coming out of university, I was all over the place with my finances. Between racking up credit card debt, student loans, high cost of living in New York, and just a general sense of YOLOing (before it was a thing, I was in a terrible financial state.

Over the years, I’ve managed to get a grip on my finances by following a close budgeting schedule. This means really looking after how much money comes in and how much money goes out. The one and only secret to maintaining a budget is to be consistent. This means always following your plan and sticking to it. Do not get the urge to deviate.

There are so many apps to track budgeting but I always found that a spreadsheet is the way to go. This is because services like mint.com will track all of your expenditures that you make with a credit card or debit card but there are other expenses that it doesn’t pick up on like the ones you make with cash.

 

When is a monthly budget tracking useful?

Tracking your budget is particularly useful if you are starting out your financial journey. This means you need to keep track of how much money comes in via salary, side hustles, stock dividends etc, vs how much money you spend.

Read Also On Johnny Africa:  Ultimate Covered Call Strategy Guide: Passive Income Generator

A lot of people spend so much of their lives living paycheck to paycheck even with a high salary because they just don’t have a good grasp of what their money is being spent on. If you don’t have the wherewithal to know exactly how your money is being spent and why you can’t save money, then this spreadsheet is for you.

 

When budget tracking is not so useful

Monthly budgets are a good way to make sure you know exactly how much money you’ve made and how much you’ve spent. However, I don’t find it particularly useful because I am already very observant of my spending habits, and my spending changes month to month depending on what big things I may purchase. In addition, I’ve saved and invested so much over the years that I’ve already achieved financial independence. You can’t get to this stage without having a good grasp of your finances.

In addition, my monthly expenditures is something like a few thousand dollars a month. However, due to the size of my portfolio, market moves means my portfolio can move in a day what I spend in a month. Therefore, tracking expenses down to the very dollar is not so useful because I have enough money to cover my day to day expenses.

It’s only when I need to spend a lot of money on a big purchase where I need to be cognizant of where I am with my finances. If I know I have to make a large expense of say many thousands of dollars, this means I might lower my spending in the next month to compensate.

 

Income vs expenses is the main thing

When it comes to budgeting, the main thing to understand is that there are only two inputs to the equation: your income versus your expenses. Your income is made up of your salary, bonus, side hustles, stock dividends etc. Your expenses are everything that goes out of your accounts like rent, restaurants, utilities, entertainment etc.

That’s all it is.

It’s just a matter of making your sure your income is greater than your expenses so you end up with savings at the end of the month. With this savings, you can invest it into the stock markets and build up your net worth.

 

Budgeting Spreadsheet


The spreadsheet I created focuses on budgeting by breaking out the spending into numerous categories.

It is not something that makes you list all your transactions on a granular level however. I find that it is a bit pointless to track every transaction you make but rather just combining them by category at the end of the month.

It is not an extremely meticulous spreadsheet that breaks down every single transaction you make, but more of an aggregation tool to help you summarize everything. I am big into charts and think that tracking your finances is best done through a trend of your spending and earning habits. That is why I’ve added numerous charts to the mix.Net Worth and Budget Spreadsheet

Read Also On Johnny Africa:  The Ultimate Net Worth, Budgeting, And FIRE Spreadsheet

 

The spreadsheet is simple, yet effective. Just make sure you update it on a regular basis. I would recommend spending 5-10 minutes updating the spreadsheet once a month with your figures. I don’t always do the exact amount for different expenses because it takes a lot of time but that is also up to you. You can use this spreadsheet if you’re a single person as well as if you’re a couple (just add everything up!).

Keep in mind that this spreadsheet is also what I use to track my own expenses. I will be making updates live and will add additional features to this spreadsheet as time goes on so make sure to check in for updates!

 

Download Budget Tracker Spreadsheet

 

 

The spreadsheet is in Google Sheets because if I update it in the future, it will be easy to access from anywhere with an internet connection. I prefer this to Microsoft Excel. It’s easy to download it and use with Microsoft Excel as well.

To download offline, click the red button above, then click file > download as > Microsoft Excel

To use it with your own Google profile, just click file > make a copy

 

Using my ultimate budgeting spreadsheet


As someone that works with spreadsheets regularly, I’ve included some functionality like conditional formatting and formulas that an Excel novice might not understand. I will explain everything necessary for those wanting to get the full use out of the spreadsheet. For the most part, anyone with any excel experience should just follow my spreadsheet and populate accordingly. Do not touch cells with formulas because everything is intricately linked. All cells that you should update have been color coded with gray cells.

 

Cash Flows Sheet

This is where you record all of your month to month data. This sheet makes up the crux of the top three tables on the “Dashboard” sheet. In summary, this is where you record how much money you earned over the month, as well as your expenses. I’ve split the expenses into categories that mint.com uses to keep it simple for those that are also using Mint to track their finances.

Do not touch the cells with formulas which are the cells with bold text. Record your taxes as well as this will help organize what is your gross income and net income. There is no formula to calculate taxes because everyone will have a different tax situation depending on their withholdings, state taxes and the like. Just look at your pay stubs and record them accordingly. This is important as you can need to take your net income (salary after taxes) in order to compute the expenses.

Read Also On Johnny Africa:  The Ultimate Stock And Investments Portfolio Tracking Spreadsheet

For expenses, record your amounts by expense category to the best of your ability. Again, it doesn’t have to be an exact number but just needs to be accurate. You can add more categories if the expenses don’t into these categories. Simply insert a new row in the red section for expenses.

 

Dashboard Sheet

This is the high level summary for all your information. This is also the tab for all your charts and trends. There is not much to manually change in this sheet so just leave it alone to keep it simple. It will update as you populate the other sheets.

You will see a chart for Average monthly expenses. This will take all the months of data you’ve inputted in the cash flows sheet under expenses and average them out. I find that it is useful to look at expenses over a long period of time since you might have larger one off expenses in one month that doesn’t carry over to the next.

If you want, you could change the charts so it only picks up averages by a certain year. I find that it is helpful to look at my expenses on a yearly basis. Simply change the source data of this chart to only pick up the columns in the “cash flows” sheet that correspond to the year you want. You can copy and paste multiple charts and select the years you want accordingly.

 

Net Worth Tracking


This spreadsheet that I made is actually a consolidation of multiple themes. Budgeting is only one of them. On top of budgeting, I use this spreadsheet to track my net worth which is especially helpful for those that are looking to achieve Financial Independence. I achieved financial independence (or FIRE) in 2020 with the help of this spreadsheet.

Once you’ve become comfortable with managing your budget and see yourself saving and investing consistently, the net worth portion of the spreadsheet is really the next step in financial management.

Continue Reading:

LEAVE A COMMENT OR ASK A QUESTION. BLOGGING IS NOT THE SAME WITHOUT YOU, THE READERS!

Start typing and press Enter to search

covered call example option
1 Shares
Tweet
Pin1
Share
Reddit