Free Budget Spreadsheet in Google Sheets?

Yes. You can make a budget spreadsheet for free in Google Sheets using a blank sheet or a template, then track planned and actual income and expenses with built-in formulas. You need a Google account to create and save a sheet; some Google Workspace services or account features may have separate terms or costs.

What “free” means for Google Sheets

Google Sheets is available in a web browser, and people can create and edit spreadsheets with a personal Google account without buying a desktop spreadsheet program. The file is saved to Google Drive, so you can open it from a supported browser when signed in. A paid Google Workspace plan is not generally required just to make a personal household budget, although an organization may manage accounts and access differently.

Free does not mean every possible feature or service has no limits. Google account storage is shared across Google services and subject to the account’s storage allowance, and Workspace subscriptions can add organizational features. For an ordinary budget with a manageable number of rows, those distinctions usually do not change how the spreadsheet itself works. Check your account’s current plan and storage details if you expect to store many large files.

A spreadsheet is also not automatically a bank account tracker. Unless you choose to import or enter transactions, a budget sheet only contains the information you put in it. A simple manual budget can be useful without connecting the sheet to a bank or sharing financial login details.

Start with a template or a blank sheet

To start from a template, open Google Sheets in a browser and look through the Template gallery. Available templates can vary by account, region, and time, so a specific personal budget template may not appear for everyone. Review any template before relying on it: check what its categories mean, whether formulas cover the rows you plan to use, and whether any sample figures are just examples.

A blank sheet gives you more control and can be quicker than removing fields you do not need. To create one, open Google Sheets and choose Blank. Give the file a clear name, such as “Household budget — 2026,” and decide whether each tab will represent a month or whether one tab will hold the full year. A monthly tab is easy to understand; a yearly transaction list can make comparisons across months easier.

Choose a template if you want a prearranged layout and are willing to adapt it.
Choose a blank sheet if you want a small, transparent budget with only your own categories.
Before entering real information in a template, remove sample transactions and check formulas for assumptions that do not fit your situation.

Set up a practical monthly budget

A useful first version separates the amount you expect to spend from the amount you actually spend. In a blank sheet, put “Category” in A1, “Planned” in B1, “Actual” in C1, and “Planned minus actual” in D1. Add expense categories in rows 2 through 4, for example Housing, Groceries, and Transport. Use consistent categories from month to month so that your comparisons remain meaningful.

For an illustrative month, suppose planned expenses are $1,500 for Housing, $600 for Groceries, and $250 for Transport. Suppose actual spending is $1,540, $575, and $210 respectively. In a separate area, enter “Monthly take-home income” in F1 and 3000 in F2. These figures are examples only, not estimates of what anyone should earn or spend.

Keep categories specific enough to help you make decisions, but not so detailed that recording each purchase becomes a chore. “Food” might be sufficient for one person; another may find it useful to split groceries and restaurant spending. The best level of detail is the one you can maintain accurately.

Use formulas to total and compare amounts

With planned expense amounts in B2:B4, put this formula in B5 to total the plan: =SUM(B2:B4). The example returns $2,350 because $1,500 + $600 + $250 = $2,350. With actual expenses in C2:C4, put this formula in C5 to total spending: =SUM(C2:C4). It returns $2,325 because $1,540 + $575 + $210 = $2,325.

With planned amounts in B2:B4 and actual amounts in C2:C4, enter this formula in D2 and fill it down through D4: =B2-C2. A positive result means actual spending is below the plan for that category; a negative result means it is above. For the Housing example, the result is -$40 ($1,500 minus $1,540). For Groceries, it is $25. Add a label to D1 that makes this direction clear, because other budgets may prefer actual minus planned.

With monthly income in F2 and total planned expenses in B5, enter this formula in F3 to calculate income left after planned expenses: =F2-B5. The example returns $650 ($3,000 minus $2,350). With actual expenses in C5, enter this formula in F4 to calculate income left after recorded spending: =F2-C5. It returns $675 ($3,000 minus $2,325). These calculations assume the income figure is take-home income and that the expense rows include all spending you want to count; they do not determine what you can afford.

Google Sheets recalculates formulas when their referenced cells change. If your sheet uses a different locale, formula argument separators or number and date display can differ. The examples above use standard English-language Sheets syntax and do not use a specialized budgeting function.

Make the sheet easier to maintain

A budget is only useful if figures are entered in a consistent way. Record actual purchases on a regular schedule, such as once or twice a week, rather than waiting until the end of the month. If you use a transaction log, give it columns for date, description, category, and amount, then summarize its amounts by category. A small sheet with reliable entries is usually more informative than a complicated one with missing transactions.

Use one row per category in the summary and one row per purchase if you keep a transaction log.
Enter amounts as numbers, not text with manually typed currency symbols, so totals can calculate correctly.
Use the same spelling for categories every time; “Transport” and “Transportation” may be treated as different labels in a summary.
Check that totals include every row you intend to count, especially after adding categories.
Use a new monthly tab or a clearly labeled date column so older figures are not mistaken for the current month.

Formatting can make exceptions easier to spot. For example, select the difference cells and use Format > Conditional formatting to highlight values below zero. Choose a formatting rule that matches the number range, then select a color. Formatting does not change the calculation; it only draws attention to results. If the sheet will be printed or viewed on a phone, keep the number of columns modest and use clear headings.

Sharing, privacy, and access

Google Sheets supports sharing through the Share button. Depending on the account and sharing settings, you can grant particular people access as viewers, commenters, or editors. For a personal budget, consider whether another person needs to edit figures or only view them. Check the people and general-access settings before sending a link, since a broadly accessible link can expose the sheet beyond the intended recipient.

Do not include information that is unnecessary for the budget, such as full account numbers, passwords, or security answers. A category total and transaction description are often enough for household tracking. If a sheet is shared with a partner, agree on who enters transactions and how categories are used; otherwise, duplicated or inconsistently labeled entries can make the totals misleading.

Sharing a spreadsheet does not itself connect it to a bank. Be cautious of third-party add-ons or services that request access to files or account data, and read the permissions before granting access. For a simple budget, manual entry may be an adequate choice when minimizing data sharing matters to you.

Google Sheets versus other budgeting options

Google Sheets is a good fit if you want a flexible, editable budget that can be opened in a browser and shared with selected people. It is not the only option. Excel offers spreadsheet tools and can work offline in its desktop application, but licensing and included features depend on the version or plan. Basic formulas such as SUM work in both programs, though menus, sharing behavior, and some functions differ.

A dedicated budgeting app may categorize transactions or offer account connections, depending on its provider and plan. That convenience can involve different costs, privacy choices, and terms, so review those details before signing up. A paper budget or a simple notes document avoids spreadsheet setup but may require more manual arithmetic and makes month-to-month totals harder to compare.

There is no single best format for everyone. Choose based on whether you value automatic features, offline access, collaboration, privacy, or control over the layout. You can also begin with a basic Google Sheet and move to another tool later; keep an export or copy if you want a record independent of the original file.

Common problems and fixes

If a total seems wrong, first check that every amount is numeric and that the SUM range includes all the intended rows. A value pasted with an unexpected character or stored as text may not behave like a number. Also check for a category accidentally omitted from the formula range after you add a new row.

If a difference appears to have the wrong sign, confirm the order of subtraction and the column heading. Planned minus actual makes overspending negative; actual minus planned makes overspending positive. Neither convention is inherently required, but the label and your interpretation must agree.

If a template has unfamiliar calculations, select a formula cell and inspect the formula bar to see which cells it references. Do not assume a polished layout guarantees that the formulas match your budget. Make a copy before changing a template you want to preserve, and test the altered formulas with small, known values.

Frequently Asked Questions

Is Google Sheets free for a personal budget?
Google Sheets is available for personal use with a Google account, so you can create a budget without purchasing a spreadsheet program. Account storage and some Workspace services have their own limits or plan terms.

Does Google Sheets have a free budget template?
The Template gallery may include budget or finance layouts, but the available choices can vary. If you do not see a suitable one, a blank sheet with category, planned, actual, and difference columns is enough to get started.

Can Google Sheets automatically connect to my bank?
A basic Google Sheet does not automatically connect to a bank account. You can enter transactions manually or investigate a separate service or add-on, but check its permissions, privacy terms, and any charges before using it.

How do I calculate money left in my budget?
Subtract total expenses from take-home income. For example, if income is in F2 and actual expenses total in C5, the Sheets formula is =F2-C5. With the illustrative amounts above, $3,000 minus $2,325 leaves $675 in the calculation.

Can I share a budget sheet with someone else?
Yes. Use the Share button and choose access appropriate to the person, such as viewer or editor. Review the access settings and remove sensitive details that the other person does not need to see.

For money calculations, treat example figures as illustrations rather than financial advice. Check actual account, bill, and lender terms with the relevant provider, and consult a qualified professional when you need financial, tax, investment, or legal guidance.

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.