Free Monthly Budget Template for Google Sheets: Setup

Yes—Google Sheets can be used for a free monthly budget, either by choosing a budget template from the Sheets template gallery or by building a simple one in a blank spreadsheet. A useful template tracks planned amounts against actual income and spending, calculates what remains, and lets you copy the layout for each new month.

What a free Google Sheets budget template includes

A monthly budget template is a spreadsheet layout, not a special paid feature. It gives you places to enter income, spending categories, planned amounts and real transactions. Formulas can total the entries and show whether you are below or above the plan. Google Sheets is available through a Google account; basic spreadsheet use does not require buying a separate budget-template product.

In Sheets, open the template gallery from the Sheets home page and browse the available personal or budget templates. The gallery’s selection and template names can change, so do not assume a particular file will always appear. You can also start with a blank spreadsheet and use the setup below. A self-made sheet is often easier to adjust if you want specific categories, a particular pay schedule or a compact view on your phone.

A template is a tracking aid, not a financial plan that knows your circumstances. You decide which income and expenses to include, when to record them and how to treat irregular costs. The numbers are only as complete as the information you enter.

Set up a simple monthly budget sheet

In a new Google Sheets file, name the tab for the month, such as “November 2026.” Put a small summary near the top and create a transaction log and category budget underneath or beside it. One practical layout is:

Summary: planned income, actual income, planned expenses, actual expenses and money remaining.
Transaction log: date, category, type, description and amount.
Category budget: category, planned amount, actual amount and amount left.

For a concrete arrangement, use A10:E10 for the transaction-log headers: Date, Category, Type, Notes and Amount. Enter transactions in rows 11 through 100. Use “Income” and “Expense” consistently in the Type column. Put category-budget headers in G10:J10: Category, Planned, Actual and Left. List spending categories in G11:G20, enter planned amounts in H11:H20, and reserve the top rows for the summary.

Use one row per transaction, rather than entering only a single monthly total for each category. For example, two grocery purchases of $186 and $214 can be recorded separately. That makes it easier to check the source of a total, correct a mistaken entry and see when spending occurred. If you prefer less detail, you can enter weekly totals instead, as long as you apply the same approach consistently.

Choose categories that fit your real spending

Start with enough categories to make the budget useful, but not so many that recording purchases becomes a chore. A first version might include housing, utilities, groceries, transportation, insurance, debt payments, personal spending and savings. Add categories that matter to your household, and combine ones that rarely need separate tracking.

Keep category names identical in the budget table and transaction log. “Dining out,” “Restaurants” and “Eating out” will be treated as different text by a category-matching formula, even if you mean the same thing. A dropdown list can reduce spelling differences: select the category cells in the transaction log and use Data > Data validation to create a dropdown based on the category list. Menu labels may shift as Google updates Sheets, but Data validation is the relevant feature.

It also helps to distinguish planned costs from actual entries. A monthly insurance bill may be predictable, while heating costs or groceries may vary. For an irregular annual bill, you could either record the full payment in the month it is paid or set aside a monthly portion in your plan. Pick a method that reflects how you want to monitor cash flow, and label it clearly so the planned figure is not mistaken for a bill already paid.

Add formulas to total the budget

Formulas save time, but they depend on the layout and exact category labels. In the layout above, place the following in I11, then fill or copy it down through I20. With transaction categories in B11:B100, amounts in E11:E100 and the category name for that budget row in G11, this formula totals the actual transactions for the category; if groceries in G11 has entries of $186 and $214, it returns $400.

=SUMIF($B$11:$B$100,G11,$E$11:$E$100)

In J11, subtract actual spending from the planned amount. With the plan in H11 and the actual total in I11, this returns the amount remaining; for a $500 grocery plan and $400 spent, the result is $100.

=H11-I11

For the summary, suppose A3:A7 contains the labels Planned income, Actual income, Planned expenses, Actual expenses and Actual remaining, with corresponding values in B3:B7. Enter planned income manually in B3. With the transaction type in C11:C100 and amount in E11:E100, put this in B4 to total rows marked Income. For example, entries of $3,000 and $1,000 return $4,000.

=SUMIF($C$11:$C$100,"Income",$E$11:$E$100)

With planned expense amounts in H11:H20, put this in B5 to add them. Plans of $1,500, $500, $400 and $600 total $3,000.

=SUM(H11:H20)

With transaction types and amounts in the same ranges described above, put this in B6 to total rows marked Expense. If those expenses add to $2,200, the result is $2,200.

=SUMIF($C$11:$C$100,"Expense",$E$11:$E$100)

With actual income in B4 and actual expenses in B6, put this in B7 to show the difference. With $4,000 income and $2,200 expenses, it returns $1,800.

=B4-B6

These figures are illustrative, not financial advice. Check that your ranges include all the rows you use; entries after row 100 will not be included unless you extend the formulas. In Google Sheets, use Format > Number > Currency for money cells and an appropriate date format for transaction dates. Formatting changes how values display, not the underlying arithmetic.

Use the template throughout the month

At the beginning of the month, enter expected income and planned amounts for each category. The plan can be based on your expected take-home income and known bills, with flexible categories estimated from your own records. As income or spending occurs, add a transaction with its date, category, type and amount. Review the summary and category balances periodically rather than waiting until the last day of the month.

For instance, if the grocery plan is $500 and the sheet shows $400 spent, the category has $100 left according to the entries recorded. That is a tracking result, not a guarantee that the amount is available in a bank account: pending transactions, bills not yet entered or a mistaken category can make the sheet differ from your actual balance. Reconcile important totals against account records if accuracy matters to your decisions.

When the month ends, keep that month’s data and make a copy of the tab or file for the next month. In Google Sheets, you can use the tab menu to duplicate a sheet, then rename the copy. Clear old transaction entries from the new month without deleting formulas, headings or validation rules. A separate tab per month makes historical comparisons easier, while one rolling tab is simpler but requires you to archive old records another way.

Make the sheet easier to read and maintain

Basic formatting can make errors easier to spot. Freeze the header row with View > Freeze > 1 row so column names remain visible as the transaction list grows. Use bold text for totals, and apply a consistent currency format to all money columns. Avoid merging cells in the transaction table; merged cells can make sorting and filtering difficult.

Conditional formatting can flag categories that are over plan. Select J11:J20 and choose Format > Conditional formatting, then set a rule that highlights values below zero. A negative value means actual spending exceeded the planned figure under this layout. You can also use the sheet’s filter controls to view transactions by category or date, which is useful when a monthly total seems unexpectedly high.

Keep formulas separate from manually entered values. If you overwrite a formula cell with a number, the sheet may look correct temporarily but stop updating when new transactions are added. If totals suddenly fail, check for deleted formulas, extra spaces in category labels, amounts entered as text, or transactions below the formula’s final row. A quick test is to enter a clearly labeled sample transaction and confirm that the relevant category and summary totals change as expected; remove the sample afterward.

Common limitations, costs and privacy

A free template will not automatically know every purchase unless you import or enter the information. Manual entry gives control but takes attention; imported bank data, where available through a separate service or workflow, can introduce its own access and privacy considerations. Do not assume a third-party template or add-on is made by Google just because it opens in Sheets. Check its provider, requested permissions and privacy information before sharing account access or sensitive data.

Sharing is another setting to review. Use the Share button to choose who can access the file, and avoid “Anyone with the link” access for a budget containing private details unless you deliberately want that exposure. A Google account may offer free access to Sheets, while organizational Google Workspace arrangements can have different terms. The spreadsheet layout itself does not require a paid budgeting app, but available account features and storage policies can vary.

Google Sheets is useful when you want browser access and straightforward collaboration. Excel can also hold a monthly budget, but its menus and template options differ; these steps describe Google Sheets in a web browser. A paper worksheet or dedicated budgeting app may suit someone who does not want to maintain a spreadsheet. Compare convenience, data handling and any subscription cost before choosing another service.

Frequently Asked Questions

Does Google Sheets have a free monthly budget template?
Sheets has a template gallery with templates that may include budget options, though the exact selection can change. You can also make a free monthly budget in a blank spreadsheet using categories, a transaction log and formulas such as SUMIF.

How do I find budget templates in Google Sheets?
Open the Sheets home page and browse the template gallery for budget or personal-finance options. If none fits, create a blank spreadsheet and add the tables described above rather than relying on a particular template name being available.

Can Google Sheets calculate how much I have left in each category?
Yes. If a category’s planned amount is in H11 and its actual spending total is in I11, the formula =H11-I11 returns the amount left. A negative result means recorded spending is above that plan.

Should I make a new tab for every month?
That is a practical choice, not a requirement. Separate monthly tabs preserve each month’s records and make them easier to revisit; a single rolling sheet is simpler but needs a reliable way to archive prior transactions.

Can I use an Excel budget template in Google Sheets?
You can upload many Excel files to Google Drive and open them in Sheets, but formatting or features may not transfer perfectly. Review formulas, dropdowns and conditional formatting after conversion, and use Sheets’ own menus when following Google Sheets instructions.

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.