Budget Spreadsheet in Google Sheets: Setup and Tips

Yes—Google Sheets can work as a budget spreadsheet: start with a template or a blank file, list your planned amounts by category, and compare them with expenses you record during the month. A simple SUMIF formula can total spending by category, so you can see what remains without adding each purchase by hand.

How a Google Sheets budget works

A budget spreadsheet is a structured record, not an automatic financial account. You decide what income and spending categories to track, enter the amounts, and use formulas to summarize them. In Google Sheets in a web browser, the file is saved in Google Drive and can be updated from different devices when you have access to the internet.

Most monthly budgets answer three questions: how much money is expected, how much is assigned to different uses, and how much has actually been spent. A plan can be as straightforward as rent, groceries, transport, utilities, and savings. Comparing planned and actual figures helps you spot a category that is running over budget while there is still time to adjust future spending.

A spreadsheet does not know whether a purchase is affordable or whether a particular budget is right for you. It organizes information and performs arithmetic; your entries, assumptions, and decisions still matter. Treat any example amounts here as illustrative rather than financial advice.

Start with a template or a blank file

To look for a ready-made option, open Google Sheets in a browser and choose Template gallery on the Sheets start page. The available templates can change, and a gallery template may include sections or charts you do not need. Make a copy before replacing sample data, then review its formulas and categories rather than assuming every part fits your situation.

A blank spreadsheet gives you more control and is often easier to understand. Choose Blank to create one, then give the file a clear name such as Monthly budget. You can organize one month per tab, duplicate a monthly tab, or keep a transaction log for the whole year and filter it by date. Pick a structure you will maintain; a detailed system is not useful if entering purchases becomes too tedious.

Before adding numbers, decide what the budget period means. A calendar month is easy to review, but people paid weekly or every two weeks may prefer to note each payday and still summarize by month. If income arrives on different dates, record when it is expected rather than treating all monthly income as available on the first day.

Choose categories and a layout

Separate the plan from the transaction record. For example, create a tab named Summary with columns for Category, Planned, Actual, and Remaining. Put categories in A2:A5, planned amounts in B2:B5, actual totals in C2:C5, and remaining amounts in D2:D5. In a second tab named Transactions, use columns A, B, and C for Date, Category, and Amount. Add one purchase per row and use the same category names on both tabs.

Start with categories that make decisions easier, not with the longest possible list. One household might distinguish groceries from restaurant meals; another may prefer a single food category. Regular bills, flexible spending, debt payments, and savings goals can each be separated if seeing them individually helps. Avoid making categories so narrow that ordinary purchases are hard to classify.

Use a consistent naming style, such as Transport every time rather than switching between Transport, Travel, and Transit.
Keep an uncategorized or review category temporarily if you are unsure where a transaction belongs, then resolve it during a weekly check-in.
Decide how to handle refunds and reimbursements. You can enter a refund as a negative amount in the original category, as long as you apply that rule consistently.

Record spending and calculate category totals

Enter expenses as positive amounts in Transactions. If a grocery purchase is 38.50, enter 38.50 in the Amount column and Groceries in Category. Using positive expenses makes the transaction log easier to read; the remaining calculation subtracts actual spending from the planned amount. Enter the date as a date value, not just text, so sorting and date-based filters behave as expected.

With Summary categories in A2:A5 and Transactions categories in column B and expense amounts in column C, enter this in Summary!C2 and copy it down through C5:

With those columns, the formula =SUMIF(Transactions!$B$2:$B,$A2,Transactions!$C$2:$C) adds every transaction whose category matches A2. If groceries total 412, C2 returns 412 when A2 contains Groceries. The dollar signs keep the transaction columns fixed as you copy the formula down, while the category reference changes from A2 to A3 and so on.

With the planned amount in B2 and the category total in C2, enter this in D2 and copy it down through D5:

The formula =B2-C2 returns 38 when the grocery plan is 450 and actual spending is 412. A positive result means that amount remains in the category under this method; a negative result means actual spending is above the plan. This is a comparison, not a measure of money in a bank account.

With the four category rows in rows 2 through 5, enter =SUM(B2:B5) in B6 to total planned spending and =SUM(C2:C5) in C6 to total recorded spending. In an illustrative example with plans of 1,200 for rent, 450 for groceries, 150 for transport, and 200 for utilities, B6 returns 2,000. If actual amounts are 1,200, 412, 138, and 186 respectively, C6 returns 1,936. With B6 and C6 in place, =B6-C6 in D6 returns 64. These totals are only as complete as the transactions entered.

Make the sheet easier to read and maintain

Use number formats so amounts are recognizable. Select the relevant cells, then choose Format > Number > Currency. The currency symbol and decimal display should match the currency you are budgeting in; formatting changes how a value appears, not its underlying amount. Use bold text for column headings and totals, and freeze the heading row with View > Freeze if the transaction list grows long.

For a visual warning when a category is overspent, select D2:D5 and choose Format > Conditional formatting. Set a rule for values less than zero and choose a contrasting format. A negative remaining amount then stands out without changing the calculation. You can also use Data > Create a filter on the transaction headings to find a date range or category. Filters hide rows from view; they do not delete them or change the total formula.

A chart can help show the relative size of categories, but it is optional. Select category names and actual totals, then choose Insert > Chart and review the chart type in the Chart editor. A chart based on only four categories may be useful at a glance, but it will not explain why spending changed. Keep the underlying table as the source of truth.

Choose a routine that fits real spending

The budget is most helpful when updates are frequent enough to catch mistakes. A practical routine is to enter transactions once or twice a week, compare the sheet with receipts or account records, and review totals near the end of the month. If you wait several months, missed purchases are harder to reconstruct and category totals become less dependable.

For irregular expenses, consider setting aside a planned monthly amount in a category such as annual bills or car maintenance. The spreadsheet can show the amount you intend to reserve, but it does not move money into a separate account. Similarly, if income varies, you can budget from a conservative estimate and update it as actual income arrives. Whether that approach suits your circumstances is a personal financial decision.

When you begin a new month, either duplicate the summary tab and clear only the appropriate input cells, or retain a transaction log and change the period being summarized. If you duplicate a tab, check that formulas still point to the intended transaction data. A useful test is to enter a small sample transaction, confirm that its category total changes, and then remove the test row.

Common problems and how to prevent them

The most common error is a mismatch between a transaction category and the summary label. SUMIF compares text, so Groceries and Grocery are not the same category. Copying category names or using a dropdown list can reduce spelling differences. To create a dropdown, select the category cells and choose Data > Data validation; review the current Sheets options shown in the side panel, since interface labels and available controls can change.

A blank or unexpectedly low total can also mean that amounts were entered as text, a formula references the wrong column, or a transaction was left out. Check that the amount cells contain numbers and that the category is in the column named in the formula. If a formula displays as text, check whether the cell was formatted as plain text or whether an apostrophe was entered before the equals sign.

Do not confuse the planned amount with a bill that has already been paid. The plan is an intention; the transaction is a record of what happened. Likewise, a positive total remaining across categories does not necessarily equal spare cash: the sheet may omit income timing, pending transactions, account balances, or future bills. Reconcile the spreadsheet against reliable records rather than treating a formula as proof that the numbers are complete.

Cost, privacy, and sharing

Google Sheets is available through a Google account, and personal use is generally available without a separate Sheets purchase. Google Workspace plans are paid options for organizations and may include additional administrative features. Product terms and availability can change, so check Google’s current account and Workspace information for details that apply to you.

A budget contains sensitive information. You usually do not need to put full account numbers, passwords, payment-card details, or identity documents in the spreadsheet. To control access, use the Share button and check General access. Restricted access limits the file to people who have been given access; choose Viewer, Commenter, or Editor according to what each person needs. Avoid public or broad link access for a personal budget.

Sharing with a household member can make joint tracking easier, but an Editor can change cells and formulas. Keep a copy or use File > Version history > See version history to review earlier changes and restore a prior version if needed. Version history is useful for recovering edits, but it is not a substitute for careful sharing settings or a separate record of important financial information.

Google Sheets compared with Excel and other options

Google Sheets works well when browser access, collaboration, and a straightforward shared file matter. Excel offers a familiar spreadsheet alternative, including desktop use and a different set of features depending on the edition. Core tasks such as entering a table and summing amounts are possible in both, but menus, formula support, and file behavior can differ. This guide uses Google Sheets menu paths and syntax, not Excel-specific instructions.

A dedicated budgeting app may be more convenient if you want built-in account connections, reminders, or transaction categorization. Those capabilities depend on the app, country, financial institution, and its terms; check its privacy and pricing information before connecting accounts. A spreadsheet gives you direct control over its layout but usually requires manual entry or importing a file. You can also download transactions from a financial institution and import or paste them, then review dates, categories, duplicates, and signs before relying on the totals.

Frequently Asked Questions

Is there a free budget spreadsheet in Google Sheets?
Google Sheets has a Template gallery with templates that may suit budgeting, and you can also create a blank spreadsheet. Availability and template designs can change. Review the formulas and sample content before using a template for real records.

How do I make a monthly budget in Google Sheets?
Create a planned-amount table by category and a transaction log with dates, categories, and amounts. Use a category-total formula such as SUMIF to compare actual spending with the plan, then update the log regularly and review it against your records.

Can Google Sheets automatically track my bank transactions?
A standard blank Google Sheets budget does not automatically collect transactions from every bank account. You can enter purchases manually or import transaction data, while third-party services may offer connections subject to their own availability, terms, and privacy practices.

What formula adds spending for one category?
SUMIF can add amounts when a category column matches a chosen category. For the layout above, the formula in the Actual column is =SUMIF(Transactions!$B$2:$B,$A2,Transactions!$C$2:$C); confirm the sheet name and column references match your file.

Can I use a Google Sheets budget offline?
Offline access may be available after you configure Google Drive offline access for your account and supported browser or device. It is not guaranteed simply because the file is in Sheets. Check Google’s current offline requirements and confirm changes have synced before relying on them across devices.

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.