Google Sheets Budget Template: Build or Choose One

A Google Sheets budget template is a spreadsheet that organizes income, planned spending, and actual spending so you can compare your plan with what happened. To start, open the Google Sheets template gallery and choose a suitable budget layout, or create a blank sheet with columns for category, planned amount, actual amount, and difference.

What a budget template does

A budget template gives recurring money decisions a consistent place to be recorded. Instead of keeping expense figures in scattered notes, you can list income and spending by category, total the amounts, and see whether your actual outflows are above or below the plan. In Google Sheets, formulas recalculate totals when you change a number, while the file can be opened in a web browser and shared with other people.

A useful monthly budget distinguishes three things that are easy to confuse:

Planned amount: what you expect or intend to allocate to a category.
Actual amount: what you actually spent or set aside during the period.
Difference: the gap between the plan and the recorded amount. Decide whether a positive figure means under budget or over budget, and label it clearly.

Templates can also track bills, savings goals, debt payments, or irregular costs. They are organizational tools, not a guarantee that a plan will fit your circumstances. A template is most useful when its categories reflect your own transactions and you update it regularly.

How to find and choose a template

In a browser, open Google Sheets and look for the Template gallery on the Sheets home page. Browse the available templates and open one whose structure suits your needs. Gallery choices can change, and a template that is not visible in your account may not be available to you. To keep an editable copy, use File > Make a copy and give the copy a recognizable name, such as Monthly budget 2026.

Before entering personal figures, inspect the sheet rather than assuming every label or formula is right for you. Check what period it covers, whether it records planned and actual spending separately, and whether its totals include every relevant row. Some layouts are designed for a household, while others focus on a single person, a project, or a particular pay cycle.

Choose monthly tracking if most bills and income are monthly and you want a straightforward overview.
Choose a pay-period layout if you are paid weekly or every two weeks and timing is important to your cash flow.
Choose a detailed tracker if you want to enter transactions one by one and summarize them by category.
Choose a simple plan if you will maintain only a few broad categories. A complicated workbook can be harder to keep current.

Check whether the template uses formulas, dropdowns, charts, or multiple tabs, and whether you understand how to change them. A polished chart is less useful than a clear sheet you can reliably update.

Build a simple monthly budget

To make a basic version, create a blank Google Sheet and use the first row for these headings: Category, Planned, Actual, and Left. Put expense categories in A2:A8, with planned amounts in B2:B8 and actual amounts in C2:C8. For example, the categories might be housing, groceries, utilities, transport, debt payments, savings, and personal spending. Treating savings as a planned allocation makes it visible in the same plan, though you may prefer a separate savings section.

Use row 9 for totals, and put a label such as Monthly take-home income in A11 with the amount in B11. Keep the period consistent: do not compare a full month of planned spending with only a few days of actual transactions. If income varies, you can record the amount you expect to use for this month and revise it when the figure becomes clearer.

In Google Sheets, enter the category names and amounts as plain data, not as part of a merged title block. A tidy table is easier to sort, filter, extend, and read on a small screen. Format money values by selecting the relevant cells and choosing Format > Number > Currency. The exact currency symbol may depend on the spreadsheet’s locale; check File > Settings if the displayed format does not match your needs.

Use formulas to total and compare amounts

With categories in rows 2 through 8, planned amounts in B2:B8, actual amounts in C2:C8, and row 9 reserved for totals, enter =SUM(B2:B8) in B9. This illustrative example returns 3,700 when the planned values are 1,500, 500, 250, 300, 400, 500, and 250. The arithmetic is 1,500 + 500 + 250 + 300 + 400 + 500 + 250 = 3,700.

With the same layout and actual amounts of 1,500, 465, 270, 280, 400, 500, and 220, enter =SUM(C2:C8) in C9. It returns 3,635, the sum of those seven actual figures. These numbers are illustrative only; replace them with values appropriate to your own records.

With planned values in column B and actual values in column C, enter =B2-C2 in D2 to calculate the amount left for the first category. In this example it returns 0 for housing because the planned and actual amounts are both 1,500. Copy the formula down through D8 using the fill handle. Under this definition, a positive result means actual spending is below the plan, while a negative result means it is above the plan; the heading Left makes that interpretation easier to remember.

With the category differences in D2:D8, enter =SUM(D2:D8) in D9 to total the difference. For the example above, it returns 65 because the planned total of 3,700 is 65 greater than the actual total of 3,635.

With monthly income in B11 and actual expenses in C9, enter =B11-C9 in B12 to calculate income remaining after the listed actual outflows. If B11 is 4,000 and C9 is 3,635, the result is 365. This only reflects the categories entered: missing cash purchases, pending bills, or other accounts will make the figure incomplete. Spreadsheet calculations do not determine whether a budget or debt strategy is suitable for you; check actual loan terms with the lender or consult a qualified professional for financial, tax, or legal questions.

Make the sheet easier to maintain

A template works better when routine updates take little effort. Freeze the heading row using View > Freeze > 1 row so column labels remain visible as you scroll. You can use Format > Conditional formatting to highlight negative values in the Left column, making categories that exceeded their plan easier to spot. Apply the rule to the relevant cells and choose a formatting style that remains readable.

Keep category names stable from month to month if you want to compare periods. If you change a category, update any formulas or charts that refer to it. A separate tab for each month can be easy to understand, but copying tabs repeatedly can create formula and maintenance problems. Another option is to keep one transaction table with a date, description, category, and amount, then use a separate summary. Choose the structure you are actually prepared to maintain.

For shared expenses, agree on what counts as an entry and who updates it. For example, decide whether a credit-card purchase is recorded on the purchase date or when the card bill is paid. Recording both as spending can count the same outflow twice. A short note at the top of the sheet describing the period and recording method can prevent confusion later.

Sharing, privacy, and access

Google Sheets is designed for browser-based collaboration, so more than one person can work in a shared file when access allows it. Use the Share button to add collaborators or adjust general access. Give edit access only to people who need to change the budget; view access is more appropriate for someone who only needs to read it. Access options may be controlled by a work or school account administrator.

A budget can contain sensitive information even if it does not include account numbers. Avoid putting passwords, full payment-card details, or other credentials in the sheet. Share only with intended people, review who has access when circumstances change, and consider whether a shared file is appropriate for the information you plan to record. Google Sheets is not a substitute for secure account storage or a formal accounting system.

Common template problems and fixes

The total looks wrong: Check that every amount is entered as a number and that the SUM range includes all intended rows. A number stored as text may not behave like a numeric value.
The difference has the opposite sign from what you expected: Confirm whether the formula is planned minus actual or actual minus planned, then rename the column or change the calculation consistently.
A new category is missing from totals: Extend the formula range to include the new row, or insert the category within the range that the formula already covers.
The currency symbol is unfamiliar: Check the cell’s number format and the spreadsheet locale. Changing number formatting does not convert one currency into another.
The monthly result seems too high: Look for duplicate entries, transfers counted as expenses, or a card purchase recorded both when charged and when paid.

Also distinguish a budget from a bank statement. A budget is a plan and a tracking method; it will not automatically include every transaction unless you add or import data and verify it. If you copy a template that contains existing sample figures, remove or clearly label them before relying on the totals.

Costs and alternatives

Google Sheets is available through a Google account, and creating a basic budget in a spreadsheet does not require buying a dedicated budgeting template. Some third-party creators sell spreadsheet files or offer paid services, but check what is included, how updates are delivered, and whether the file works in Google Sheets before paying. A paid design does not by itself ensure accurate formulas or a good fit for your needs.

Alternatives include a paper budget, a spreadsheet in another program, or budgeting software that offers features such as transaction importing. A paper plan can be enough for someone who wants a short monthly checklist. Dedicated software may reduce manual entry if its account connections are supported and appropriate, but it can involve subscriptions and additional data-sharing considerations. Google Sheets is a practical middle ground when you want an adaptable layout and are comfortable entering or reviewing figures yourself.

Frequently Asked Questions

Does Google Sheets have a free budget template?
Google Sheets provides a Template gallery that may include budget-related layouts. Available templates can change, so browse the gallery from the Sheets home page. You can also make a basic budget in a blank sheet without purchasing a template.

How do I make a copy of a Google Sheets budget template?
Open the template and choose File > Make a copy. Name the new file and save it to the appropriate Drive location. Review the copied formulas and sample figures before using it as your own budget.

Can I use a Google Sheets budget template on my phone?
You can open Sheets files on a phone using Google Sheets, though editing a wide or formula-heavy table is usually easier on a larger screen. Keep headings concise and avoid relying on tiny charts or complicated layouts if you expect to update the budget on mobile.

How often should I update a monthly budget?
Choose a routine you can sustain, such as recording transactions weekly and checking totals at the end of the month. If bills or balances change quickly, more frequent updates may help. The important point is to use the same period and method when comparing planned and actual amounts.

Can a Google Sheets budget connect to my bank?
A basic spreadsheet does not automatically reflect every bank transaction just because it is a budget template. Some third-party tools or services may offer imports or connections, but availability and access vary. Review permissions and privacy terms carefully, and verify imported entries against your actual records.

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.