I received an inheritance of $30k. One year later, I had blown it all.
I used the money to move out, get a new car, eat out constantly — all while telling myself I’m going to be making $10k a month before I know it as freelance marketer.
Every month I knew I was spending more than I was making, but I was too scared to look at my bank account or my credit card statement. *Just click pay*
It wasn’t until I could only afford one more month’s rent that I accepted I needed a full-time job and a budget.
It’s been five years since then and I’ve learned a few tricks along the way. The most important thing is to understand the difference between a good budget system and a bad one.
A bad budget system only shows you where your money is going. A good budget system will create a change in your behavior.
How My Google Sheets Budget Template Can Improve Your Spending Habits
Most importantly, it forces you to enter your expenses manually. Although this seems crazy with today’s tools that can link to your accounts and do this automatically, doing it manually is crucial to improving spending habits.
Manually recording your expenses every week will force you to review every transaction, to feel the pain of every dollar spent, and make you think “was that really necessary?”
Another reason to manually record expenses is you can fine-tune the expense category for each transaction, or even split a transaction into two categories.
This gives you way more options for using and tailoring categories exactly to your needs.
For example, here’s one of my favorite charts where you can see how you’ve been spending vs your budget by each category over time.
View and Start Using My Google Sheets Budget Template
Open the link below and click ‘make a copy’ to start using it in your Google Drive.
I highly recommend reading on to learn how to set the budget template up for your finances and learn how to use it.
Besides the initial set up and ongoing expense recording, everything is automated.
Instructions: How to Use The Budget Template
I included easy-to-follow prompts to make it simple and quick to get set up.
You can learn how to use the template in this video tutorial, or by reading the below guide if you prefer.
I. Enter your income
In the top left box on the Dashboard tab, enter your income. Follow the orange colored cells as cues for which part to fill out. If you don’t have a 401k or a Recurring Income #2 (additional income), you can leave those sections blank.
Any income entered here will be added to your available budget. If you do receive any kind of extra income, you may either be putting it all in savings, part of it in savings, or you need all of it for your expenses. Unless you’re comfortable with Google Sheets and spreadsheet formulas, this budget template is only made for two sources of income. If you have more than one additional income source, you can sum them and enter the total as one number in the Recurring Income #2 cell.
If you need all or a portion of that extra income, you need to add it to the Recurring Income #2 cell. If you save all of it, you can still add it if you wish (and offset it later by increasing how much of your income is sent to savings) or you can omit it.
Once this section is completed, you’ll get your Net Total Income, which is how much net income you have left over to spend, put in savings etc.
II. Enter Monthly Recurring Expenses
Below the Income box is the Monthly Recurring box.
The first item is Savings to help you prioritize setting money aside for savings to help you “pay yourself first”, a very effecitve wealth building strategy.
“The goal [of pay yourself first] is to make sure that enough income is first saved or invested before monthly expenses or discretionary purchases are made.”
Then you can start adding recurring monthly expenses. These are monthly expenditures that are typically the same amount every month. Examples include rent and utilities, car payment and insurance, phone bills, gym memberships, Netflix/Spotify, etc.
After this, you’ll be left with your Net Spendable Income, which tells you how much you have left for discretionary spending for food, shopping, going out, and other expenses. But first, there’s one more step before we get to creating our actual budget: annual expenses.
III. Enter Annual Expenses
The strategy behind including annual expenses is to set aside a monthly amount of money to prepare for when these big expenses come up. Start by adding in things you pay once a year for in the Annual Recurring box. Some examples are car registration, vacations, gifts, car maintenance, credit card annualy fees, Amazon Prime, etc.
After you entered in all the annual expenses you can think of, the budget template will divide the total into a monthly amount as a line item back in the Monthly Recurring box. Now you have your final Net Spendable Income amount you can use to start budgeting.
IV. Create Your Budget
Now that you know how much money you can comfortably spend after savings, monthly recurring expenses, and planning for future annual expenses, you can create your budget. In the Monthly Budget box, enter categories of expenses and an allotted amount. Some examples include eating out, groceries, going out, shopping, coffee, alcohol, personal care, gas, etc.
Thanks to some clever conditional formatting in Google Sheets, the budget template will sum your Total monthly expenses. If the Total is green, your expenses are under your Net Spendable Income. It will be red if it’s over and you will need to readjust your Monthly Budget or consider eliminating or reducing some of your monthly or annual recurring expenses.
Note: Before we can get into the Summary, Spent vs Budget, and Expenses Last 7 Months boxes, we need to run through the other tabs in the Google Sheet budget template first.
V. Recording Expenses
One of the presumably biggest downsides of a doing your personal budget in Google Sheets is that you have to enter your expenses in manually, but this is a blessing in disguise. Entering your expenses manually will have a big psychological effect on you to spend less. It forces you to “feel the pain” of every dollar you spend.
So on the Expenses tab you’ll enter each of your expenses - one row per one expense.
You’ll see some instructions in red at the top for more information. Across the blue row heading, the budget template auto populates your Monthly Expenses categories from the Dashboard tab. When you enter an expense, start with the date in Column A, the name of the place you spend the money in Column B, and then tab over to the column with the expense category that best matches how this expense should be categorized. If it’s an annual expense, it’s the same exact process - just make sure you’re in the right annual expense column.
Note: It’s important you don’t change the order of your items in the Monthly Expenses box on the Dashboard tab because the column you entered the expense under isn’t locked to the expense category.
Why are the expense categories in different columns instead of writing in/choosing the expense category in a single category column? For two reasons. One, it’s much faster to just ‘tab’ over to the right expense category column than writing it in or switching from keyboard to mouse to choose the right category from a dropdown. Second, it allows for less process-heavy formulas making the spreadsheet more smooth to use.
Note: When choosing the date, it doesn’t matter whether you choose the transaction date or the posted date (if pulling from a credit card), but you should stick to one or the other. I prefer posted date.
VI. Tallying Up Assets and Liabilities in the Balance Sheet
Now onto the Balance Sheet tab of the budget template. This is where you will add up all the money you have and owe in your accounts. This will ultimately tell you if your wealth/net worth is increasing or decreasing. Make sure you’ve filled out the preliminary Dashboard steps first (see points 1-4 above).
Note: Because this is counting the actual numbers in your account, you don’t necessarily have to record every expense. Sometimes there are expenses that don’t quite make sense to include that could throw off measuring your spending. But don’t worry, as long as the Balance Sheet is accurate, measuring your cash balance and net worth over time will still be accurate.
To start, name the accounts in Column A (mostly the savings accounts and assets). Examples of savings accounts can include primary, emergency fund, and vacation fund. Assets can be your car, credit card miles, 401k, IRA, stocks, etc.
Note: Unless your comfortable with Google Sheets formulas, this spreadsheet doesn’t support changing the purpose of the accounts that are listed there. It’s okay to not use any of them, but not okay to add or change the purpose of an account.
Once you’ve named your accounts, follow the below steps:
- Enter your starting date in cell B1. Dates are entered in the format of 1/1/2018 (the formatting will display the month’s name and year). In cell B1, enter the date of the oldest month you want to start your budget. In most cases, you’ll enter the 1st of the current month or the 1st of last month. You can start further back if you wish, but it will take extra work to calculate historical balances of your accounts. Then in cell C1, enter the 1st of the following month. Then continue adding the 1st of every subsequent month until you reach the end of row 1. Once completed, the orange instructions in cell A1 should disappear.
- Now you’ll have a header row in row 1 with the month and year. The numbers you will fill out in the column beneath a month must be the balances at the end of that month. So forget that you used the first of the month in the heading - the reason for that was just to get the month and year to display and to make some formulas work. Just remember, the numbers under a month’s column in the Balance Sheet represent where those accounts stand at the end of that month.
Note: If you’re starting your budget this month, you don’t need to fill out the numbers in the Balance Sheet yet. It’s easiest to do this soon after the month ends, either one the 1st of the following month or at least within a few days of it ending. Then all you need to do is pull up your online banking and fill out the balances for all your accounts, credit cards, loans, retirement accounts, etc. Remember, the numbers in these columns represent how you stand at the end of the month.
- Any row that has a - in the cell means these numbers are auto calculated with Google Sheets formulas. Grey shaded cells are intentionally left blank due to the nature of what it’s calculating (for example you need 3 months of data before it can calculate a 3 month rolling average). Here’s what the Assets & Income section will look like once you have some data in there:
- For Rent Due in row 30, I always set to $0. Rent should be paid on the 1st and I don’t like to include it as money owed. If I’m filling out the Balance Sheet for a month where rent hasn’t yet been deducted from my checking account, I’ll subtract it from my current checking balance for a more accurate representation of my month’s finances. I do the same thing for credit card payments when it applies - pay my credit card and if it hasn’t been reflected in my credit card or checking balance, I manually subtract the amount from my credit card balance and the amount I paid from my checking account. Here’s what the Liabilities section looks like with sample date.
- The categories under Monthly Expenses starting in row 36 are auto populated from the Dashboard tab. The sums of each category are then auto calculated from the Expenses tab so you don’t need to do anything here. The same is true for Annual Expenses starting at row 50. If you spend in an annual expense category, it won’t count towards your monthly budget and instead will pull from the future “pool” of money set aside for annual expenses you decllare in the Annual Reccuring box on the Dashboard tab.
- The last section is the Totals section that brings everything together to calculate your net checking balance (money in checking minus current credit card balances) and your net worth. In row 72 you can leave notes for yourself if something unusual occurred in a given month. The word “Notes” will auto populate in each month, but to leave a note, right-click the cell and select “Insert note.”
And that’s all you do the Balance Sheet at the end of each month. As you use this Google Sheets budget template each month, more data on the Dashboard tab will start to populate and be useful.
VII. Net Worth Summary
Back on the Dashboard tab, the Summary box will show an overview of the most recent balances you entered on the Balance Sheet tab compared to the previous completed month. Then it also compares your Latest with the previous 3 Month Average, which makes it easy to see if your money is increasing or decreasing. You’ll need at least 4 months of completed data for the Summary box to completely work. Don’t worry or change any of the formulas here if it throws an error.
VIII. Spent vs Budget
Further down the Dashboard tab, you’ll see the Spent vs Budget box. This is a graph that compares your spending in each category to the budget you set for that category in the Monthly Budget box. Use the dropdown selector in cell P30 to change the category or choose ‘Total.’
Note: This graph shows the previous seven months of data so it won’t be fully complete until you have at least seven months of complete data. And it won’t show any data at all until you have data from at least one previous month in your Expenses and Balance Sheet tabs (It doesn’t show current month). Again, don’t change any formulas or the chart as it will still work fine if you don’t have all seven months yet.
IX. Expenses Last Seven Months
Below the Spent vs Budget box is the same data but in a table format in the Expenses Last 7 Months box. This is another way to compare your spending vs budget by category. Amounts will be red where you overspent.
Bonus Budgeting Tips
A budget is only good if you update it consistently, keep it accurate, and spend time analyzing your spending. That’s why I made it a point to make this budget template in Google Sheets look nice, be easy to use, and be rewarding to use.
But sometimes that’s still not enough. There’s definitely been times where I don’t do it for a few weeks at a time and the more you wait, the more work you’ll have to do, and the more you won’t look forward to doing it. I‘ve made it a habit to log my expenses every Sunday vs once every month.
If you believe a budget will help you get control of your spending, read this guide on how to stick to new habits:
Another tip is to use a credit card for all transactions when possible. Using a credit card makes it much easier to keep track of your spending and at the same time protects your bank account from fraud, builds your credit, and you can earn points and rewards.
Let me know what you think of the spreadsheet. If you found some places where I messed up or have ideas for new functionality, let me know on Twitter.
You might also enjoy
Never Miss an Article
Get notified by email when I publish a new article.