How to Make a Monthly Budget Planner in Google Sheets

To make a monthly budget planner in Google Sheets, create one tab for your budget and another for transactions, then use categories and SUMIFS formulas to compare planned amounts with actual income and spending. You’ll need a Google account, a browser, and a few estimates for your monthly income and expenses. The steps below build a reusable planner that updates when you change the month or add transactions.

What You’ll Need

A Google account with access to Google Sheets.
Approximate monthly income, expense categories, and planned amounts. You can refine these as you collect real figures.
Transaction details such as dates, amounts, and categories. A bank statement or receipts can help, but don’t share sensitive account information in the sheet.

This guide is for Google Sheets in a web browser. Excel has similar spreadsheet concepts and supports many of the same formulas, but its menus and some interface details differ; follow the Google Sheets menu paths here rather than Excel ribbon instructions.

Step-by-Step

Create the file and tabs. Open Google Sheets and choose Blank spreadsheet. Rename the file with a clear name, such as “Monthly Budget Planner.” Rename the first sheet tab Budget, then click the plus button at the bottom to add a second sheet and call it Transactions. Keeping entries separate from the summary makes the planner easier to maintain and reduces the risk of overwriting a calculation.
Set up the month selector. On Budget, enter Month in A1 and enter the first day of the month you want to plan in B1—for example, November 1, 2026. Format B1 as a date using Format > Number > Date. Use the first day even if you are building the planner partway through the month. The formulas below use that date to include transactions from the first day up to, but not including, the first day of the next month.
Build the income table. In A3:C3, enter the headings Income, Planned, and Actual. Put income categories in A4:A6, such as Paycheck, Side income, and Other. Enter your planned amounts in B4:B6. Leave C4:C6 ready for formulas. In row 7, enter Total income in column A. You can add more income rows later, but keep the total row below them and adjust the formula ranges accordingly.
Build the expense table. In A9:D9, enter Expenses, Planned, Actual, and Left. Add expense categories in A10:A19, for example Housing, Groceries, Utilities, Transport, Insurance, Phone, Health, Entertainment, Savings, and Other. Enter a planned amount in column B for each category. “Left” will mean planned amount minus actual spending: a positive value means you are under the plan; a negative value means spending has passed it.
Set up the transaction log. On Transactions, put Date, Type, Category, Description, and Amount in cells A1:E1. Enter one transaction per row beneath the headings. Use a real date in column A, exactly Income or Expense in column B, a category that matches the Budget tab in column C, an optional short note in column D, and a positive number in column E. For example, a rent payment might have type Expense, category Housing, and amount 1200. Record income as a positive amount too; the Type column distinguishes it from spending.
Add an actual-income formula. On Budget, C4 should show the total income for the category named in A4 during the month in B1. With the transaction layout above and data in rows 2 through 1000, enter this formula in C4, then copy it down through C6:
=SUMIFS(Transactions!$E$2:$E$1000,Transactions!$B$2:$B$1000,"Income",Transactions!$C$2:$C$1000,$A4,Transactions!$A$2:$A$1000,">="&$B$1,Transactions!$A$2:$A$1000,"<"&EDATE($B$1,1))
For an illustrative November sheet with a 3,200 paycheck entry, this returns 3,200 in the Paycheck row. If you copy it down, the category reference changes to A5 or A6 while the month and transaction ranges stay fixed.
Calculate actual spending by category. In C10, enter the expense version of the calculation, then copy it down through C19. With categories in A10:A19, the month start in B1, and transaction records in rows 2:1000, this formula sums only matching expenses within that month:
=SUMIFS(Transactions!$E$2:$E$1000,Transactions!$B$2:$B$1000,"Expense",Transactions!$C$2:$C$1000,$A10,Transactions!$A$2:$A$1000,">="&$B$1,Transactions!$A$2:$A$1000,"<"&EDATE($B$1,1))
If the November transaction log contains a Housing payment of 1,200, the Housing actual cell returns 1,200. Copying the formula changes the category reference for each row, so the Groceries row sums groceries rather than housing.
Work out the remaining amounts and totals. With planned amounts in B10:B19 and actual spending in C10:C19, enter this in D10 and copy it through D19:
=B10-C10
For planned Housing of 1,200 and actual Housing of 1,200, the result is 0. In row 20, enter Total expenses in A20. With the expense table in rows 10:19, use these formulas in B20, C20, and D20 respectively:
=SUM(B10:B19)
=SUM(C10:C19)
=B20-C20
For a sample plan of 2,130 and actual expenses of 2,087, the totals show 2,130 planned, 2,087 actual, and 43 left.
Finish the income and net totals. With the income rows in 4:6, enter =SUM(B4:B6) in B7 and =SUM(C4:C6) in C7. If planned income is 3,400 and the recorded income is 3,450, those cells return 3,400 and 3,450. Label A22 Net and use =B7-B20 in B22 and =C7-C20 in C22. With the sample totals above, planned net is 1,270 and actual net is 1,363: 3,450 minus 2,087. These are arithmetic summaries, not a recommendation about how to use the remaining money.
Format the sheet and make it easier to use. Select the amount cells and choose Format > Number > Currency. Select the header row and apply bold text or a fill color. To keep headings visible while scrolling, use View > Freeze > 1 row on each tab. On Transactions, select the Type cells you plan to use and choose Data > Data validation to create a dropdown with Income and Expense. A dropdown reduces spelling differences that would prevent the formulas from matching.
Test the planner before relying on it. Add a small, clearly labeled test transaction with a date in the selected month and a known category. Check that the matching actual cell increases by exactly that amount, while other categories stay the same. Remove the test row afterward if it was not a real transaction. Change B1 to the first day of another month and confirm that transactions from the earlier month no longer appear in the monthly totals.

Common Mistakes

Using inconsistent category names: “Groceries,” “Grocery,” and “Food shop” are different text values to the formula. Choose a label once and use it consistently on both tabs. Dropdowns can help, especially for transaction types and frequently used categories.

Entering amounts as text: A value copied with a currency symbol or extra characters may not behave like a number. Enter numeric amounts in the Amount column, then apply currency formatting to the cells. Formatting changes how a number looks; it does not require typing a currency symbol into every entry.

Using a date outside the intended month: The month selector must contain a real date, and the transaction date must also be a real date rather than text that only looks like one. The selector should be the first day of the month. A date later in the month can unintentionally exclude earlier transactions.

Mixing positive and negative transaction amounts: This setup expects positive values in Amount and uses Type to distinguish income from expenses. If expenses are entered as negative numbers as well as marked Expense, totals will be misleading. Use one consistent method; for this guide, enter all amounts as positive numbers.

Overwriting formulas or leaving out categories: Typing over a formula cell removes its calculation. Also, a transaction in a category not listed in the budget will not be included in one of the category rows. Keep categories aligned, and check that the total rows include every category row you add.

Tips

Start with a manageable list of categories. Too many tiny categories make logging slow, while one broad “Other” category can hide useful patterns. If you regularly need to review what is inside Other, split it into a few meaningful categories. Keep the labels clear enough that you can choose one quickly while entering a transaction.

Make a fresh copy of the planner for a new budgeting period if you want to preserve a clean snapshot. If you prefer one ongoing file, change the month in B1 and continue adding dated transactions; the monthly formulas will filter the log. Either approach can work, but avoid deleting older records if you want to review past months later.

Use conditional formatting to make unusually high spending easier to spot. Select the remaining-amount cells, then choose Format > Conditional formatting and set a rule for values less than zero. Choose a visible text or fill color. Because the remaining calculation is planned minus actual, a negative number signals that actual spending is above the planned amount; it does not explain why or prescribe what to do.

Protect the formulas from accidental edits by identifying the calculation cells and limiting who can edit them, particularly if several people share the sheet. Google Sheets provides sheet and range protection under Data > Protect sheets and ranges. Keep the transaction area editable for the people who enter records, and make a copy before changing the layout or formula ranges.

Enter transactions regularly rather than waiting until the end of the month. A short description such as “weekly food shop” can help you recognize an entry later, but avoid storing full card numbers or other private credentials. Check the totals against your own records periodically; a planner is only as complete as the information entered.

Troubleshooting

An actual total stays at zero: Check that the transaction date is a valid date within the month shown in B1, the Type value exactly matches Income or Expense, and the category spelling matches the Budget tab. Also confirm that the amount is numeric and that the transaction is within rows 2:1000. If you expect more than 999 transactions, extend each formula’s ranges together so they cover the additional rows.

The formula displays an error: Make sure it was pasted into the intended cell and that quotation marks and parentheses remain intact. Google Sheets normally uses commas between function arguments in the examples here, but spreadsheet locale settings can require semicolons instead. If Sheets rejects the commas, check File > Settings for the spreadsheet’s locale and use the separator required by that locale. Do not replace the function names with Excel-only instructions; these formulas use functions available in Google Sheets.

The monthly total includes the wrong transactions: Confirm B1 is the first day of the month and that each transaction has the correct year as well as month and day. The formula includes dates on or after B1 and excludes dates on or after the next month’s first day. This boundary handles months of different lengths, including February.

A total does not change after adding a row: Check whether the new transaction is inside the formula’s row range, and make sure it is on Transactions rather than Budget. If a cell that should calculate a total was accidentally replaced, restore the appropriate formula from a working row or use the formulas above in the specified cells. If the sheet has been rearranged, update all affected references consistently before relying on the result.

Frequently Asked Questions

Can I use this planner for more than one month?
Yes. Keep adding dated transactions and change B1 to the first day of the month you want to view. The actual totals recalculate for that month. Save a copy each month if you want separate snapshots or a simpler archive.

Can I add more categories or income sources?
Yes. Add a row in the appropriate table, copy a nearby formula into the new actual or remaining cell, and expand the total formulas so they include the added row. Keep the transaction category text identical to the new budget label.

Should I enter expenses as negative numbers?
No, not with this setup. Enter income and expenses as positive amounts and identify each transaction with the Type column. This keeps the SUMIFS calculations straightforward and avoids subtracting expenses twice.

Why is my actual spending different from my bank balance?
The planner totals only transactions you have entered that match its month, type, and category criteria. It may not include pending charges, fees, transfers, or transactions you have not recorded. Review the log and compare it with your financial records; the sheet is not a live bank connection.

Can I use this for shared household budgeting?
Yes. Share the file with the people who will enter or review information, and agree on category names and how to record transactions. Use Google Sheets sharing permissions thoughtfully, since anyone with access may be able to see the amounts and descriptions in the file.

Does this planner give financial or tax advice?
No. It organizes figures you provide and performs basic arithmetic. For decisions involving financial, tax, investment, or legal questions, check the relevant terms and consult a qualified professional where appropriate.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.