How to Make a Budget Tracker in Google Sheets

Make a monthly budget tracker in Google Sheets by listing expense categories, entering planned and actual amounts, and adding formulas to calculate what remains. You will also add an income summary, so the sheet shows whether your actual income covers your spending. Start with a Google account and a rough list of your monthly income and expenses; you can refine the numbers as you go.

What You’ll Need

A Google account and a web browser with access to Google Sheets.
Estimated monthly income and spending amounts, plus actual figures as they become available. Recent bank or bill records can help you estimate, but enter figures carefully and keep sensitive account details out of the sheet.
About 20–30 minutes to set up the tracker. You can build it with one worksheet and no add-ons.

Step-by-Step

Create a new spreadsheet and name it. Open Google Sheets in your browser and create a blank spreadsheet. Click the document name at the top left and give it a recognizable title, such as Monthly Budget Tracker. Rename the first sheet tab at the bottom to Budget by double-clicking the tab name. If you want to preserve a clean template for future months, you can later use File > Make a copy and enter a different month in the copy.
Add a heading and expense table. In A1, enter Monthly Budget Tracker. In A2, enter Budget month, and in B2 type the month you are tracking, such as November 2026. In row 3, enter these headings: Category in A3, Planned in B3, Actual in C3, and Remaining in D3.

Enter one expense category per row in A4:A13. For example: Rent, Utilities, Groceries, Transport, Insurance, Debt payments, Savings, Healthcare, Subscriptions, and Personal spending. Adjust these to fit your situation. Keep categories distinct enough to explain your spending, but not so numerous that routine entries become a chore. Row 14 will hold your totals.
Enter planned expense amounts. Type your monthly target for each category in B4:B13. Enter numbers only, such as 1400, rather than typing a currency symbol into every cell. Leave the cells in C4:C13 empty until you know your actual spending. If you already have expenses for the month, enter the actual amount in the matching row. Use the same currency throughout and do not mix weekly amounts with monthly ones.

For a worked example, suppose planned expenses are 1400 for rent, 180 for utilities, 500 for groceries, 250 for transport, 200 for insurance, 300 for debt payments, 400 for savings, 100 for healthcare, 70 for subscriptions, and 100 for personal spending. These planned amounts total 3500. They are examples for demonstrating the sheet, not a recommendation for how to allocate money.
Calculate the remaining amount in each category. With planned amounts in B4:B13 and actual amounts in C4:C13, enter =B4-C4 in D4. This shows the budget left when the answer is positive and an overspend when it is negative. For example, if groceries are planned at 500 and actual spending is 560, the formula returns -60. If actual spending is 500, it returns 0.

Copy D4 down through D13 using the small square at the lower-right corner of the selected cell, or select D4:D13 after entering the formula and use Ctrl+D on Windows or Command+D on Mac. Check the references in a couple of rows: D5 should calculate B5 minus C5, not keep pointing to row 4. In Google Sheets, the formula syntax shown here works in the browser. Excel uses the same basic subtraction formula, although its menus for formatting differ.
Set up totals. In A14, type Total. With planned expense amounts in B4:B13, enter =SUM(B4:B13) in B14; with actual expense amounts in C4:C13, enter =SUM(C4:C13) in C14. In the example, B14 returns 3500. If the actual entries are 1400, 195, 560, 220, 200, 300, 400, 80, 75, and 190, C14 returns 3620. Those actual figures add up to 3620.

With total planned and actual expenses in B14 and C14, enter =B14-C14 in D14. The example returns -120, meaning actual expenses exceed the planned total by 120. This total is a quick overview; the individual rows show which categories account for the difference.
Add an income summary and monthly balance. Use columns F and G so the income summary sits beside the expense table. Type Income in F3 and Amount in G3. Enter Planned income in F4, Actual income in F5, Planned balance in F7, and Actual balance in F8. Enter your estimated income in G4 and the income received so far, or the final actual amount, in G5.

With planned income in G4 and planned expenses in B14, enter =G4-B14 in G7. With actual income in G5 and actual expenses in C14, enter =G5-C14 in G8. If planned income is 4000 and planned expenses total 3500, G7 shows 500. If actual income is 3900 and actual expenses total 3620, G8 shows 280. These balances are simple comparisons; they do not account for timing, account balances, or every possible obligation.
Format amounts and headings. Select B4:D14 and G4:G8, then choose Format > Number > Currency. Choose a suitable currency if the default does not match your spreadsheet locale. You can also use the toolbar’s currency-format button. Select row 3 and apply bold text or a fill color so the column labels stand out. Bold A14:D14 and F7:G8 to make totals and balances easier to locate. Google Sheets uses Format > Number; in Excel for Microsoft 365 on Windows, use Home > Number for number formats.

To flag category overspending, select D4:D13 and choose Format > Conditional formatting. Under Format cells if, choose Less than, enter 0, select a noticeable text or fill color, and click Done. A negative remaining amount will then stand out. In Excel, the comparable path is Home > Conditional Formatting; the menu labels and dialog are not identical.
Make the sheet easier to use and read. Widen column A so category names fit, and adjust columns B:D and F:G so amounts are visible. In Google Sheets, drag the boundary between column letters to resize a column. You may freeze the headings by choosing View > Freeze > 3 rows; this keeps the top three rows visible as you scroll. Use sensible decimal places and consistent date or month labels. Avoid excessive colors: one accent for headings and one warning style for overspending is usually enough.
Check the figures and use the tracker consistently. Confirm that the example planned total is 3500 and, if you used the example actual amounts, that the actual total is 3620 and the actual balance is 280 with 3900 of actual income. Replace the example figures with your own. Record purchases in the correct category as they happen, or set a regular time each week to update them. Keep planned amounts separate from actual amounts; changing the target to match a purchase hides the difference you are trying to track.

This is an illustrative budgeting worksheet, not financial, tax, investment, or legal advice. If a figure depends on loan terms, check the current terms with the lender. For individual financial, tax, or legal decisions, consult a qualified professional.

Common Mistakes

Entering currency symbols as text. Typing values such as $500 into cells can make totals harder to calculate if Sheets treats them as text. Enter 500, then apply currency formatting.
Leaving out irregular expenses. Annual fees, repairs, gifts, and seasonal costs can make a monthly plan look more accurate than it is. Include a suitable category or divide an irregular planned cost across the months you are tracking.
Recording a transaction twice or in the wrong category. Duplicate entries inflate the actual total, while inconsistent categories make comparisons less useful. Check transactions against your source records and apply the same category rules each time.
Overwriting formulas. Typing over a cell in column D or a total cell replaces its calculation. If a result stops updating, click the cell and inspect the formula bar before entering a replacement.
Treating a blank actual amount as a confirmed zero. A blank may mean you have not updated the category yet. Update actuals consistently so an apparently positive remaining amount does not create false confidence.

Tips

Use categories you can maintain. Start with the broad categories in the example, then split a category only when the extra detail will help you make sense of your spending.
Keep a copy for each month. Once the layout and formulas are correct, use File > Make a copy, change the month, and clear only the prior month’s input cells. Preserve formulas in D4:D14 and G7:G8. Check the copy before relying on it.
Make entries easy to audit. If you need transaction-level detail, add a separate sheet with date, description, category, and amount. Keep the monthly summary on the Budget sheet, and compare the detailed entries with the actual category totals.
Review both the total and the categories. A positive overall balance can hide a category that is over budget, while one overspent category may be offset by lower spending elsewhere. Look at the remaining column as well as the actual balance.
Protect access to personal information. Avoid storing full card numbers, passwords, or other login details in the spreadsheet. Review sharing permissions before sending a link, especially if the sheet includes personal spending information.

Troubleshooting

A total shows zero or misses some entries. Check that the values are numeric, that they are in the expected rows, and that the formula covers the full range. For example, the expense total should include rows 4 through 13. Text such as a typed currency symbol or an extra space can prevent a value from being treated as a number.
A formula displays as text or gives a parse error. Make sure the entry starts with an equals sign, has balanced parentheses, and uses ordinary cell references. If the cell shows the formula characters instead of a result, change its format to Automatic using Format > Number > Automatic, then re-enter the formula. Google Sheets locale settings can affect number and separator conventions; use the separator appropriate to the spreadsheet’s locale if a formula with multiple arguments fails.
Negative values appear unexpectedly. For a remaining amount, the formula subtracts actual spending from the plan. A negative result means actual is greater than planned. Check that the planned and actual columns have not been swapped and that both values use the same time period.
The conditional formatting color does not appear. Select D4:D13 and review the rule under Format > Conditional formatting. Confirm that the condition is Less than 0, that the rule applies to the intended range, and that the formatting style is visible against the cell background.
Totals change after copying the sheet. Check that formulas still refer to the correct rows and that clearing old figures did not delete formula cells. Re-enter the missing formula from the steps above and copy it down or across as appropriate.

Frequently Asked Questions

Can I use this tracker for more than one month?
Yes. The simplest approach is to make a copy for each month, update the month label, and clear the previous actual entries while preserving formulas. If you want year-long comparisons, keep each month on a separate tab or build a separate summary sheet.

Can I change the categories?
Yes. Replace the example category names with ones that reflect your spending. If you add or remove rows, update the SUM ranges and copy the remaining formula through the new category rows so totals still include every expense.

Should I enter income before or after deductions?
Choose a consistent income figure that makes sense for the expenses you are tracking, and label it clearly. For a practical month-to-month comparison, many people use the amount actually available to spend, but individual circumstances differ. This template does not determine the right treatment for taxes or other deductions.

Why is my remaining amount negative?
The formula is planned amount minus actual amount. A negative result means actual spending is higher than the plan for that category. Review the entries and the category target, then update the plan only if the target itself needs a genuine revision.

Can I share the budget with another person?
Yes. Use the Share button in Google Sheets and choose the access level carefully. Give editing access only to people who should change entries or formulas; use viewer access when someone only needs to see the sheet.

Will the formulas work in Excel?
The basic SUM and subtraction formulas in this guide also work in Excel. However, the menu paths described are for Google Sheets in a browser. Excel uses different formatting and conditional-formatting menus, and sharing or copying files may behave differently.

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.