Google Sheets Budget Template: Build a Monthly Plan

A Google Sheets budget template is a spreadsheet for listing income, planned expenses, and actual spending in one place. In a browser, open Google Sheets, choose Blank or a suitable template from the Template gallery, then add category, planned, and actual columns; simple SUM formulas can total the month and show what remains.

What a Google Sheets budget template does

A budget template gives your money a consistent structure. Instead of keeping income in one note and purchases in several accounts, you record the amounts you expect and compare them with what actually comes in or goes out. A monthly layout is a useful starting point because many household costs recur each month, while the same design can be copied for later months.

Google Sheets runs in a web browser and saves changes to Google Drive when you are signed in and online. That makes it convenient to open a budget on different devices or share it with someone who helps manage the household. It is still a spreadsheet, not an automatic view of your bank account: unless you use a separate integration, you enter or import transactions yourself.

A template can be as simple as a list of categories and totals. A more useful version distinguishes planned amounts from actual amounts, so you can spot changes such as a higher grocery bill or a smaller-than-expected paycheck. You can build one from scratch or adapt an available template; the gallery’s options may differ by account, language, or time.

Set up a practical monthly layout

Create a blank sheet and put the month near the top. One compact design uses an income table in A3:D8 and an expense table in A11:D22. In both tables, use columns A through D for Category, Planned, Actual, and Variance. Put income categories in rows 4–7 and the income total in row 8. Put expense categories in rows 12–21 and the expense total in row 22.

For example, income categories might be salary, freelance work, interest, and other income. Expense categories could include rent, utilities, groceries, transport, insurance, phone and internet, debt payments, savings, entertainment, and other. Add a small summary in columns F and G: labels in F4:F9 and corresponding totals or balances in G4:G9. Keep category names specific enough to be meaningful, but not so detailed that entering every purchase becomes a chore.

Here is one illustrative set of planned amounts: $4,500 salary and $500 freelance income, for $5,000 planned income. Example planned expenses are $1,600 rent, $250 utilities, $600 groceries, $250 transport, $200 insurance, $100 phone and internet, $400 debt payments, $700 savings, $250 entertainment, and $200 other expenses, totaling $4,550. These are sample figures only, not recommended budget amounts.

Enter formulas and check the example

With planned income in B4:B7 and actual income in C4:C7, place this formula in G4 for planned income: =SUM(B4:B7). With the example amounts, the result is $5,000. In G5, with the same income rows and actual amounts in C4:C7, use =SUM(C4:C7). If actual salary is $4,600 and actual freelance income is $300, the result is $4,900.

With planned expenses in B12:B21, enter =SUM(B12:B21) in G6. The ten example expenses total $4,550. With actual expenses in C12:C21, enter =SUM(C12:C21) in G7. If the actual amounts are $1,600, $230, $645, $210, $200, $100, $400, $700, $310, and $180 in that order, the result is $4,575.

With planned income total in G4 and planned expenses total in G6, put =G4-G6 in G8 to calculate the planned remainder. The example gives $5,000 minus $4,550, or $450. With actual income total in G5 and actual expenses total in G7, put =G5-G7 in G9. The example gives $4,900 minus $4,575, or $325. A positive remainder means the listed income exceeds the listed expenses; it does not prove that every bill or irregular cost has been included.

To make the Variance column useful, define its meaning in the header or a note. For income, Actual minus Planned shows whether income came in above or below expectations. For expenses, Planned minus Actual shows whether spending was below or above the plan. Those two calculations use different directions so that a positive result has a favorable meaning in both tables. You can enter the appropriate subtraction in the first row and fill it down, adjusting the row references.

Format the sheet so it is easy to read

Format money amounts as currency by selecting the relevant cells and choosing Format > Number > Currency. The currency symbol and available formats can depend on the spreadsheet’s locale. To review or change the locale, use File > Settings. Apply bold formatting to table headers and totals, and use borders or a background color to distinguish the income and expense sections.

Freeze the title and column headings if the sheet becomes long: select the appropriate row, then use View > Freeze. For a basic layout, freezing the first three rows keeps the income-table headings visible while scrolling, though the expense table has its own headings farther down. You can also use Format > Conditional formatting to highlight expense variances or a negative remainder. Set a rule that matches the value and range you want to flag rather than relying on color alone; labels and readable contrast help make the sheet understandable.

Use consistent number entry. Decide whether you will enter expenses as positive amounts and subtract their total from income, as in this layout, or use negative numbers. Mixing the two conventions can make totals misleading. If you need a percentage, format the result as a percentage instead of typing a percent sign into the underlying amount.

Choose categories that match how you spend

A template is most useful when its categories reflect real decisions you want to make. Broad categories reduce data-entry effort; detailed categories can make patterns clearer but take longer to maintain. Start with a manageable list and adjust it after you have used the sheet for a month or two.

Separate fixed and variable costs. Rent or a regular subscription is usually predictable; groceries and transport may change from month to month.
Include irregular costs. Car repairs, annual memberships, gifts, and seasonal bills can be easy to overlook in a monthly view. You could add an irregular-expense category or set aside a monthly amount for them.
Show savings deliberately. Listing savings as a planned category can make it visible in the same way as other planned outflows. The sheet records your plan; it does not move money between accounts.
Use a notes column if it helps. A short note can explain a one-off charge or a changed estimate without creating a new category for every exception.

Do not treat a category as a rule that can never change. If a broad “other” total becomes large, review its transactions and split it into a few meaningful groups. If a category repeatedly has no entries and provides no useful insight, combine or remove it.

Use a transaction log or a simple monthly summary

For a low-maintenance budget, enter one actual total per category at the end of the month. For more detail, create a second tab named Transactions with columns for Date, Category, Description, and Amount. Record each purchase once, then compare the category totals with the budget summary. Keeping a separate log makes it easier to find what contributed to a total, but it also requires more regular entry.

If you maintain a transaction log, use the same category spelling in the log and summary. Inconsistent labels such as “Groceries,” “Grocery,” and “Food shop” can split what should be one category if you later summarize entries. A dropdown can reduce these variations: select the category cells and use Data > Data validation to configure permitted entries. The exact options shown in the side panel can change as Google updates Sheets, so check the validation rule after changing category names.

For a monthly-only file, one tab per month is straightforward, but it can become cumbersome over a year. Another option is one transaction log with dates and a separate monthly summary. That design needs date-aware formulas or a pivot table to group transactions, so it is worth using only if the extra reporting is useful to you. Whichever approach you choose, keep a clear record of whether amounts are planned, entered transactions, or final totals.

Google Sheets compared with other budget options

Sheets is a good fit when you want a customizable budget, browser access, and straightforward collaboration. You can share a file with another person and choose whether they can view or edit it. A spreadsheet also makes it easy to add categories or change the layout without being limited to a budgeting app’s predefined screens.

A dedicated budgeting app may offer bank connections, transaction categorization, alerts, or reports that a basic Sheets template does not provide. Those features may depend on the app, account, or region. A spreadsheet gives you more control over what is recorded, but manual entry can be less convenient and formulas can be changed accidentally. Compare the setup effort and privacy practices of any service before deciding where to keep financial information.

Excel can open many spreadsheet files, but menus, sharing behavior, and some formatting may differ. If you download a Sheets file for use in Excel, check the totals and number formats after conversion. For a shared budget that several people update in a browser, keeping the working copy in Sheets avoids the confusion of multiple downloaded versions.

Common problems and sensible safeguards

A total that seems wrong is often caused by a blank or misplaced number, an omitted row in a formula range, or a value entered as text. Check that the formula covers all category rows and that amounts are numeric. If you insert new categories outside the range used by a SUM formula, update the range so the total includes them.

Another common issue is comparing unlike periods. A monthly budget should not compare a full month of planned costs with only two weeks of transactions. Record the period covered by the actual totals, and wait until the month closes before treating the comparison as complete. Irregular bills also need context: an annual charge can make one month look unusually expensive even when the cost was expected.

Think about access before sharing. Use the Share button to give specific people the access they need, and avoid publishing a budget with a public link if it contains personal financial details. Do not put bank passwords, full account numbers, or other credentials in spreadsheet cells. If several people edit the file, agree on who enters transactions and who changes formulas; consider keeping an untouched copy of the original layout.

Frequently Asked Questions

Does Google Sheets have a free budget template?
Google Sheets may show budget-related options in its Template gallery, and you can also create a blank sheet and build a simple budget yourself. The gallery’s available templates can vary. A personal Google account can generally create and use Sheets without buying a separate budget template; access and features for managed Workspace accounts can depend on the organization.

How do I find a budget template in Google Sheets?
Open Google Sheets in a browser and look for Template gallery on the Sheets home page. Browse the available templates and choose one that suits your needs, or select Blank to make your own. If you start from a template, review its categories and formulas before entering real figures.

Can Google Sheets automatically track my bank spending?
A plain budget spreadsheet does not automatically read bank transactions. You can enter totals manually or maintain a transaction log. Any separate bank-connection service is distinct from the basic template, so check its permissions, security practices, and terms before linking an account.

How do I calculate what is left in a monthly budget?
Add the income for the period, add the expenses for the same period, then subtract expenses from income. In the example above, actual income of $4,900 minus actual expenses of $4,575 leaves $325. Confirm that the figures cover the same dates and that all relevant categories are included.

Can I share a Google Sheets budget with someone else?
Yes. Use the Share button to invite people and select an appropriate access level, such as viewer or editor. Give editing access only to people who need to change the budget, and review the sharing settings if the file contains personal information.

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.