Google Sheets Monthly Budget Template: Build One That Works

A Google Sheets monthly budget template is a spreadsheet for listing planned income and expenses, recording what you actually spend, and comparing the two. You can start with a template in Google Sheets or build a reusable one with a budget table, a transaction log, and a few formulas; the setup below works in Google Sheets in a web browser.

Start with a template or build your own

From the Google Sheets home screen, open the Template gallery and review the available personal finance templates. Google can change the gallery and the templates shown, so do not assume a particular template name or layout will always be available. A gallery file is a starting point: check its categories, date range, and formulas before entering personal information. If it does not suit your needs, create a blank spreadsheet and follow the setup here.

A useful monthly budget answers three questions: how much money do you expect to receive, how much do you plan to spend or set aside, and how does actual spending compare with that plan? Keep the first version straightforward. A detailed sheet is not automatically a better budget if maintaining it takes more time than you can spare.

Use one tab for the monthly plan and another for transactions. The plan gives you a quick overview; the log holds the individual purchases and deposits behind the totals. Separating them makes it easier to check a category total without crowding the summary with dozens of rows.

Set up the monthly budget tab

Name the first sheet Budget. In A1:D1, enter Category, Planned, Actual, and Remaining. Use rows 2 through 15 for expense categories, row 16 for totals, and cells F2:F6 for a small summary. For example, enter these categories in A2:A15: Rent, Utilities, Groceries, Transportation, Insurance, Phone and internet, Health, Debt payments, Dining out, Household, Personal, Entertainment, Savings, and Other. Change the list to fit your situation; savings can be a planned allocation even though it is not a purchase.

Enter your planned amount for each category in column B. In F1, write Monthly summary; use E2:E6 for Take-home income, Planned expenses, Actual expenses, Planned unassigned, and Actual remaining. Enter your expected monthly take-home income in F2. This is a planning figure, not a statement about how much income will arrive on a particular date.

Format the money columns by selecting the relevant cells and choosing Format > Number > Currency. Apply the same format to F2:F6. To keep the category names and headings visible as you scroll, select the row below the headings and use View > Freeze; the available freeze choices depend on the selected row. Clear formatting or merged cells in a copied template if they make it difficult to sort or edit.

Add a transaction log

Create a second tab named Transactions. In A1:D1, enter Date, Category, Description, and Amount. Add each expense as a positive number in column D, choose a category that matches the Budget tab, and enter the purchase date in column A. For this simple design, record expenses only in the log; put take-home income in Budget!F2 instead. If you want to track income transactions, build a separate income section rather than mixing deposits into an expense total.

For example, a grocery purchase of $46.20 on March 4 would have a date in A2, Groceries in B2, a short description such as Weekly shop in C2, and 46.20 in D2. If you enter three grocery purchases of $46.20, $38.50, and $25.30, their combined actual spending is $110.00. A consistent category spelling matters because the summary formula looks for an exact category match.

Set a date format for column A with Format > Number > Date, and a currency format for column D. You can make category entry more consistent with a dropdown: select the category cells in the transaction tab, choose Data > Data validation, and set a dropdown from a range containing the budget categories. Google Sheets may label or arrange validation options differently as its interface changes; verify that the chosen range covers all categories you use.

Connect the log with formulas

With expense categories in Budget!A2:A15, transaction categories in Transactions!B2:B, and positive expense amounts in Transactions!D2:D, enter this in Budget!C2, then fill it down through C15: =SUMIF(Transactions!$B$2:$B,A2,Transactions!$D$2:$D). SUMIF adds the amounts whose category matches the category in A2. If the three grocery entries above are the only grocery transactions, the Groceries actual cell returns $110.00. The dollar signs keep the transaction columns fixed as you copy the formula; A2 changes to A3, A4, and so on.

With planned expenses in B2:B15 and actual expenses in C2:C15, enter this in D2 and fill it down through D15: =B2-C2. If the planned grocery amount is $500 and the actual total is $110, the result is $390 remaining. A negative result means spending exceeded the plan: a $520 actual total against a $500 plan returns -$20.

With planned amounts in B2:B15, enter this in B16 to total the plan: =SUM(B2:B15). For a worked example, if those categories total $2,700, B16 displays $2,700. With actual amounts in C2:C15, enter this in C16: =SUM(C2:C15). If the logged expenses total $2,450, C16 displays $2,450. In D16, use =B16-C16; those example totals return $250 remaining.

With take-home income entered in F2 and planned expenses totaled in B16, enter this in F3: =F2-B16. With income of $3,400 and planned expenses of $2,700, the result is $700 not assigned to those categories. With actual expenses totaled in C16, enter this in F4: =C16, and in F5 enter =F2-C16. In the same example, actual expenses of $2,450 produce $2,450 in F4 and $950 in F5. That last figure is a simple income-minus-logged-expenses calculation; it does not account for transactions you forgot to enter or other accounts and obligations.

Choose categories and a budgeting style

Categories should be detailed enough to make decisions, but not so narrow that every purchase needs a debate. A person who wants to control food spending might split Groceries and Dining out. Someone who only needs a broad monthly overview could combine them as Food. Choose categories based on the questions you want the sheet to answer, then keep them stable for a few months so comparisons remain meaningful.

It also helps to distinguish predictable bills from variable spending and periodic expenses. Rent is usually predictable; groceries vary; car registration or annual insurance may arrive only once or twice a year. You can create a monthly category for a periodic bill by setting aside part of its expected cost each month. For example, a $600 bill due in six months implies a planning allocation of $100 per month, if that amount fits your circumstances. This is an organizational example, not financial advice; check actual bills, account terms, and obligations before making decisions.

A monthly budget is not the same as a bank statement. The budget records intentions and a chosen view of spending; the transaction log records entries you supply. It will not automatically know about cash purchases, pending card transactions, refunds, or bank fees unless you add them. Decide how to handle refunds and reimbursements, and apply that rule consistently. For instance, you might record a refund as a negative expense in the matching category, while recognizing that the basic SUMIF setup allows negative amounts.

Make the sheet easier to read and maintain

Use simple visual cues to spot differences rather than relying on color alone. Select D2:D15 and choose Format > Conditional formatting. You can create a rule to highlight values less than zero, then choose a noticeable fill color. This flags overspending, but it does not explain whether the plan was unrealistic, the month had a one-time cost, or a transaction was categorized incorrectly.

Freeze the header row, use bold formatting for the totals, and keep notes about unusual entries in the Description column. Avoid inserting blank rows inside the transaction data if you plan to filter it. To review entries, select the data range and choose Data > Create a filter. You can filter by a category or date range without deleting other rows. At the end of each month, check that the dates, categories, and amounts look reasonable before using the totals to plan the next month.

For a new month, a practical approach is to duplicate the Budget tab, rename it with the month, and clear only values that should not carry forward. Decide whether to keep the transaction history in one tab with a date column or use a separate transaction tab for each month. One continuous log is easier to filter across months, while separate logs can be simpler for beginners. If you keep one log, the basic SUMIF formula shown here will total every transaction with a matching category, not just the current month. You would need a date-aware formula or a month-specific log to separate monthly totals.

Common problems and useful checks

A category shows zero: Check for spelling differences, trailing spaces, or a category that is absent from the log. Dropdowns reduce typing variations.
The total is too high: Look for duplicate transactions, expenses entered in more than one place, or an incorrect amount. Avoid adding the same expense manually to the Actual column if the formula already calculates it from the log.
A negative remaining amount appears: This is not necessarily a formula error. It means actual spending exceeded the plan for that category, or an entry needs review.
A date does not sort correctly: Check that the cell contains a date value rather than text that only looks like a date, and apply a date format.
The monthly summary includes old entries: The sample SUMIF formula covers the full transaction columns. Use separate monthly logs or add date criteria to the design if you need month-specific totals.

Protect the structure by making a copy before changing a complicated template. In Google Sheets, File > Make a copy creates a separate file you can use as a backup or a fresh monthly version. Formula cells can also be protected through Data > Protect sheets and ranges, but protection is mainly an editing control; it should not be treated as a guarantee that sensitive information is secure.

Sharing, privacy, and cost

Google Sheets is available through a Google Account, and personal use is generally available without a separate Sheets purchase; paid Google Workspace plans may apply in organizational settings. Check Google’s current plan and storage terms for your account rather than assuming every feature or account type has the same conditions. A budget does not require linking a bank account. Manual entry offers more control over what is stored, though it takes time and can omit transactions.

Before sharing a budget, use the Share button to review who can access it and whether each person is a viewer, commenter, or editor. Avoid placing account passwords, full card numbers, or other credentials in cells. If you use a shared household sheet, agree who enters transactions and how corrections are made. In a work or school account, an administrator may control sharing options. Do not assume that a link is private just because it is difficult to guess; review the link access setting explicitly.

Google Sheets compared with other options

A Google Sheets budget is useful when you want a flexible spreadsheet, browser access, and the option to collaborate. It requires you to maintain categories and enter or import transactions yourself. A dedicated budgeting app may offer automatic account connections or built-in reports, but its features, data handling, and fees depend on the provider. A paper budget avoids account setup and works offline, but calculations and month-to-month comparisons are manual.

Most basic spreadsheet formulas such as SUM and SUMIF are also familiar to Excel users, but the menu locations and some features differ. This guide uses Google Sheets in a browser: for example, currency formatting is under Format > Number > Currency. Do not assume an Excel template will behave identically after copying it into Sheets; inspect formulas, formatting, validation rules, and any features specific to one program. Choose the tool you can update consistently, not just the one with the most features.

Frequently Asked Questions

Does Google Sheets have a monthly budget template?
Google Sheets has a Template gallery with ready-made spreadsheet options, but the templates displayed can change. Open the gallery from the Sheets home screen and inspect the available files. If none fits, a blank sheet with a plan tab and transaction log can provide the same core functions.

How do I make a monthly budget in Google Sheets?
Create columns for categories, planned amounts, actual amounts, and remaining amounts. Add a transaction log with dates, categories, descriptions, and expense amounts; use SUMIF to total transactions by category. Include income and summary totals, then check entries regularly.

Can Google Sheets automatically track spending from my bank?
A basic budget template does not automatically track bank activity. You can enter transactions manually or use a bank export if you choose, but check the format and reconcile imported entries so you do not include duplicates. Any third-party connection has its own availability, security, and privacy terms.

Should I use one spreadsheet for every month?
You can use one file with a separate budget tab for each month, or keep one continuous transaction log and filter by dates. Separate monthly logs are easier to set up; a continuous log makes it easier to review history but needs date-based calculations to produce month-specific totals.

How do I fix a Google Sheets budget formula that returns zero?
Confirm that the category text in the transaction log exactly matches the budget category and that amounts are numeric values. Also check that the formula points to the intended columns and that the transaction is included in the referenced range. A dropdown list can prevent many category mismatches.

Can I share a budget template with someone else?
Yes. Use the Share button and grant only the access level the person needs. Review link access before sending it, and keep passwords and payment credentials out of the sheet. For a reusable blank version, make a copy and remove private entries before sharing.

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.