Google Sheets Budget Tutorial: Build a Monthly Plan

To make a monthly budget in Google Sheets, enter your take-home income, list spending categories, and add columns for planned and actual amounts. Use =B6-C6 to compare a category’s plan with its spending, then sum the columns to see whether you stayed within your total budget.

What a spreadsheet budget can show

A budget sheet is a simple way to compare the money you expect to receive with the money you plan to spend. It can also show what you actually spent, which makes it easier to spot differences between a plan and real life. Google Sheets works in a web browser and saves changes to Google Drive when you are online, so you can revisit or share the same file across devices.

A spreadsheet does not automatically know your financial picture. You supply the figures and decide how to classify them. A useful first version is deliberately small: one month, a short list of categories, and a clear total. You can add detail after you have used it for a while.

Set up the monthly budget layout

Open a blank Google Sheet and use the first column for category names and the next three for planned spending, actual spending, and the difference. Put monthly take-home income above the table. For example, enter 4200 in B3 and use this layout:

A3: Monthly take-home income; B3: 4200.
A5:D5: Category, Planned, Actual, and Left in plan.
Rows 6–14: Housing, Utilities, Groceries, Transport, Insurance, Debt payments, Savings, Dining, and Other.
Row 15: Total.
A17: Income after listed spending.

Enter each category’s planned amount in column B and, as the month goes on, record spending in column C. Use a consistent period: if the sheet is a monthly budget, enter monthly amounts rather than mixing weekly and monthly figures. For irregular bills, you can either list the amount due in that month or set aside a monthly portion; make the choice clear in a note so the totals are interpretable.

For this example, the planned amounts in B6:B14 are 1500, 180, 500, 300, 220, 250, 600, 250, and 200, respectively. They add up to 4000. The sample actual amounts in C6:C14 are 1500, 165, 540, 280, 220, 250, 600, 310, and 180, adding up to 4045. These are illustrative figures, not recommended spending targets.

Add formulas for category differences and totals

With categories in A6:A14, planned amounts in B6:B14, actual amounts in C6:C14, and the difference column in D, enter this in D6 and fill it down through D14:

With planned values in B6:B14 and actual values in C6:C14, =B6-C6 in D6 returns 0 for the housing example. A positive result means actual spending is below the plan; a negative result means it is above. The formula is relative, so filling it down changes the row references for each category.

With the totals on row 15 and the planned, actual, and difference values in columns B, C, and D, enter =SUM(B6:B14) in B15. It returns 4000. Enter =SUM(C6:C14) in C15; it returns 4045. In D15, =SUM(D6:D14) returns -45, matching planned total minus actual total.

With income in B3 and actual spending total in C15, enter =B3-C15 in B17. The example returns 155: 4200 minus 4045. This is the amount left after the categories listed in the sheet, not necessarily a complete account balance. For instance, an omitted bill or a purchase not yet entered would change the real-world picture.

Format the sheet so it is easy to read

Format amounts as currency by selecting the relevant cells and choosing Format > Number > Currency. Choose a currency appropriate to your figures; the displayed symbol does not change the underlying values. Bold the header row and total row, and consider freezing the header with View > Freeze so category names remain visible when you scroll. You can resize columns by dragging the divider between their letters.

Conditional formatting can make overspending easier to notice. Select D6:D14, then choose Format > Conditional formatting. Set a rule that formats cells less than 0 with a contrasting text or fill color. A negative value is not automatically an error: it is a signal to review the category and confirm that the entries and plan are accurate.

To reduce entry mistakes, use a dropdown for categories if you record transactions in a separate list. Select the category cells, choose Data > Data validation, and create a dropdown containing the category names. Menu labels can change over time, but Data validation is the Sheets feature for setting rules such as dropdown choices. Keep the list of allowed categories aligned with the categories in your summary.

Track actual spending during the month

There are two common ways to fill the actual column. You can update one monthly total per category, or keep a transaction log with one row per purchase and summarize it by category. The first is faster to maintain. The transaction log takes more effort but makes it possible to review dates, merchants, and individual purchases later.

If you use a transaction log, give it separate columns for date, description, category, and amount. Enter each transaction once, then total amounts by category in the budget summary. Google Sheets includes functions such as SUMIF for adding values that meet a condition, but the transaction data and category labels must be organized consistently for a summary formula to work. Check that refunds, transfers, and credit-card payments are classified in a way that avoids counting the same expense twice.

Reconcile the sheet against bank or card activity periodically. A budget is only as useful as its inputs: a missed subscription, duplicate entry, or pending transaction can make the displayed difference misleading. If you prefer not to import or store transaction details in a spreadsheet, entering category totals manually is a reasonable simpler approach.

Choose categories and a useful level of detail

Start with categories that match the way you make decisions. Broad headings such as housing, food, transportation, bills, debt payments, savings, and discretionary spending can be easier to maintain than dozens of tiny categories. On the other hand, if you want to understand a particular area, splitting a broad category can reveal useful differences—for example, groceries and dining out.

A category should be specific enough to answer a real question, but not so narrow that keeping it updated becomes a chore. You might also include a notes column for unusual one-time costs or a separate section for annual expenses. Keep one-off purchases visible rather than quietly changing the usual monthly plan; otherwise, comparing one month with another becomes harder.

Income can vary. If yours does, make the assumption behind the income figure explicit and avoid treating an uncertain amount as guaranteed. You can also add a row for each income source and sum them, rather than hiding several sources inside one number. The purpose is clarity, not false precision.

Review the plan and adjust it carefully

At month-end, compare the planned and actual columns and ask what explains the largest differences. Some may be timing issues, such as a bill paid a few days earlier than expected. Others may reflect a recurring cost that was underestimated or a category that needs to be split. Use the review to improve the next plan rather than assuming that every difference signals a mistake.

It can help to make a copy of the sheet for each month, or keep a single workbook with a separate tab for each period. A single tab is simpler to maintain and compare if you use the same categories each month; separate copies can keep periods distinct but may make year-to-year review less convenient. Name tabs clearly and avoid overwriting a finished month if you want to preserve a record.

A spreadsheet is a planning and tracking tool, not financial, tax, investment, or legal advice. For decisions involving loan terms, taxes, or other specialized questions, check the relevant documents and consult a qualified professional. Use the lender’s actual terms when recording loan payments; do not infer fees or interest from an example budget.

Google Sheets versus other budgeting options

Sheets is useful when you want flexible categories, editable formulas, and a file you can share with chosen collaborators. Its main trade-off is that you maintain the data and layout yourself. A dedicated budgeting app may offer transaction syncing or automated categorization, depending on the product, but its features, availability, and costs vary. Check its current terms, privacy practices, and supported financial institutions before connecting accounts.

Excel can also handle a budget with similar tables and formulas, but its menus and sharing workflow differ from Google Sheets. This tutorial uses the Sheets web interface; do not assume that a menu path shown here is identical in Excel. A basic spreadsheet budget does not require a paid template or special add-on. Google account and Workspace plans can have different features and terms, so check Google’s current plan information if those details matter to you.

Sharing and protecting budget information

A budget may contain personal details, so check sharing before sending a link. In Sheets, use the Share button to choose specific people or adjust general access; do not assume that a link is private simply because it is difficult to guess. Give collaborators only the access they need and remove access when it is no longer appropriate.

Google Sheets can protect a sheet or range through Data > Protect sheets and ranges, which can help prevent accidental edits to formulas. Protection is not a way to hide sensitive information from people who can access the spreadsheet. Avoid including account passwords, full payment-card details, or other information that does not belong in a household budget. If you use a shared device, sign out when finished and follow the device’s normal security practices.

Frequently Asked Questions

Is Google Sheets free for making a budget?
A basic budget can be made in Google Sheets without buying a budget template. Google account and Workspace offerings may have different storage, administration, or other plan features, so check Google’s current terms for your account.

How do I make a monthly budget in Google Sheets?
List income and spending categories, enter a planned amount for each category, record actual spending, and use subtraction and SUM formulas to compare the totals. Review the figures regularly and update the plan when your circumstances or costs change.

Can Google Sheets automatically track my bank transactions?
A blank spreadsheet does not automatically know your bank activity. You can enter transactions yourself or explore a separate service that supports account connections, but check the provider’s current features, security, and privacy terms before sharing financial access.

What does a negative number in the difference column mean?
In the example, the formula subtracts actual spending from planned spending. A negative result means actual spending is higher than the plan for that category; confirm that the amounts and entries are correct before drawing conclusions.

Can I share a budget sheet with another person?
Yes. Use the Share button to invite specific people and choose an access level. Remember that protecting formula cells helps prevent edits but does not conceal the sheet’s contents from someone who can view it.

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.