How to Make a Monthly Budget Plan in Google Sheets

To make a monthly budget plan in Google Sheets, create columns for spending categories, planned amounts, and actual amounts; add formulas to total spending and show what remains from your income; then update the actuals as the month goes on. You will need a Google account, a browser, and approximate monthly income and expense figures. The example below uses illustrative amounts, not financial advice.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
Your estimated take-home income for one month. If your income varies, use a cautious estimate and review it as you receive income.
Recent bills, bank or card statements, receipts, or another source for estimating expenses.
A short list of spending categories that reflects your situation, plus a few minutes each week to update actual spending.

This guide is for Google Sheets in a browser. Excel has similar spreadsheet concepts, but its interface uses a ribbon and some menu paths differ. If you later need an Excel file, Google Sheets offers File > Download to export a copy.

Step-by-Step

Create a new sheet and name it. Open Google Sheets, select Blank, and click the Untitled spreadsheet name near the top left to rename the file, for example, Monthly Budget. Rename the first sheet tab at the bottom to the month you are planning. If you want to reuse the plan, create a separate tab for each month or make a copy of the file before changing the period. Keeping months separate makes it easier to compare plans without accidentally replacing last month’s figures.
Set up a simple table. In cell A1, type a heading such as Monthly Budget. Put your monthly take-home income in A3 and its amount in B3. In row 9, enter four column headings: Category in A9, Planned in B9, Actual in C9, and Remaining in D9. Starting in A10, add categories such as Rent, Utilities, Groceries, Transport, Insurance, Debt payments, Savings, and Personal. Put your planned amount for each category in column B. Leave columns C and D for tracking and calculation. The example uses rows 10 through 17, one row per category.
Enter a realistic income and plan. For the worked example, enter 4000 in B3 as monthly take-home income. Enter planned expenses of 1450 for rent, 220 for utilities, 500 for groceries, 280 for transport, 180 for insurance, 300 for debt payments, 500 for savings, and 250 for personal spending in B10:B17. The figures are illustrative; replace them with your own estimates. Decide whether your plan is monthly and keep all figures on the same time basis. For a bill paid quarterly, for example, you can set aside one-third of its amount each month rather than treating the entire bill as a monthly cost.
Add a remaining-amount formula for each category. With categories in A10:A17, planned amounts in B10:B17, actual amounts in C10:C17, and remaining amounts in D10:D17, enter =B10-C10 in D10 and fill it down through D17 using the small square at the cell’s lower-right corner. A positive result means actual spending is below the plan; a negative result means it is above. If rent is planned at 1450 in B10 and actual rent is 1500 in C10, the formula returns -50. Enter actual amounts as numbers, not text with currency symbols typed in, so the subtraction works.
Calculate total planned and actual expenses. Choose a clear place for summary figures, such as A4:B7. Type Planned expenses in A4, Actual expenses in A5, Planned remaining in A6, and Actual remaining in A7. With the planned amounts in B10:B17, enter =SUM(B10:B17) in B4. The example returns 3680. With actual expense amounts in C10:C17, enter =SUM(C10:C17) in B5. For the example, suppose the actuals are 1500, 210, 540, 260, 180, 300, 500, and 300; the result is 3790.
Show what is left after expenses. With monthly income in B3 and planned expenses in B4, enter =B3-B4 in B6. The illustrative result is 320, because 4000 minus 3680 equals 320. With income still in B3 and actual expenses in B5, enter =B3-B5 in B7. Using the example actual total of 3790, the result is 210. These figures are simple cash-flow summaries, not a recommendation about how to use any remaining money. If you have income sources or expense types that need separate treatment, add clearly labeled rows rather than hiding them in a total.
Format the sheet so it is easy to read. Select the money cells, then choose Format > Number > Currency. Select row 9 and use the toolbar’s bold control to distinguish the headings. You can widen columns by dragging the boundary between their letters at the top. To keep headings visible while scrolling, select row 9 and choose View > Freeze > Up to row 9. Formatting changes appearance only; it does not change the underlying calculation. Use the currency format that matches your needs, and avoid mixing currencies in one total.
Make overruns easier to spot. Select D10:D17, then choose Format > Conditional formatting. In the side panel, set the rule to Format cells if: Less than, enter 0, choose a noticeable text or fill color, and select Done. Negative remaining amounts will then stand out. To flag categories that are close to their limit, you could add a separate rule, but choose a threshold that makes sense for your plan rather than assuming one universal cutoff. If you do not want color rules, the positive and negative values still work normally.
Update actual amounts during the month. Add up spending for each category from your records and enter the current total in column C. Keep the planned amounts in column B unchanged if you want an honest comparison with the original plan. For example, if groceries are at 310 halfway through the month, enter 310 in C12 rather than replacing the planned 500 in B12. The remaining amount and summary totals recalculate automatically. If you prefer transaction-level detail, make a second tab with date, description, category, and amount columns, then total those records into the main budget; check that each transaction is counted only once.
Review and adjust at month-end. Compare planned with actual amounts, check that the income figure and expenses cover the whole period, and note any unusual one-time costs. Use what you learn to make a more realistic plan for the next month. If you change a category or add a row, check that your formulas and conditional-formatting range include it. Keep a copy of the original month if you want a record of the plan you actually followed.

The example totals are consistent: planned categories add to 3680, leaving 320 from 4000 income; the listed actuals add to 3790, leaving 210. In this setup, the Remaining column is planned minus actual, so a negative number is an overspend relative to that category’s plan.

Common Mistakes

Mixing monthly and annual amounts. A yearly subscription entered as if it were a monthly bill can distort the total. Convert occasional costs to a monthly set-aside or clearly label them as one-time expenses.
Overwriting formulas. Typing over a total or remaining-amount cell replaces its calculation with a fixed value. If a result stops changing, click the cell and check the formula bar for a formula.
Changing the plan when recording actuals. If you replace a planned figure with what you spent, you lose the comparison. Keep planned and actual amounts in their own columns.
Forgetting irregular costs. Medical costs, gifts, repairs, and annual renewals can be easy to omit. Review several months of records and add categories or a clearly named irregular-expense line when appropriate.
Counting the same transaction twice. If you use both a transaction tab and manual category totals, make sure you are not including the same purchase in both places.
Treating a budget as a precise forecast. Estimates can change as bills arrive or income varies. Label assumptions, update figures, and avoid presenting a rough estimate as a guaranteed balance.

Tips

Start with a small set of useful categories. Split a category only when the detail helps you make a decision; too many lines can make regular updates harder.
Use consistent labels, such as Groceries every month, so you can compare tabs without wondering whether two differently named rows mean the same thing.
Set a recurring weekly reminder to update actuals. Short, regular check-ins are usually easier than reconstructing a full month from memory.
Protect the original plan by duplicating a monthly tab before editing it. Right-click the sheet tab and choose Duplicate, then rename the copy.
Share carefully. Use the Share button and choose the access level you intend. Someone with editing access can change figures and formulas, so consider sharing a view-only version if collaborators only need to see the plan.
Make a small note beside unusual entries, such as a one-off repair, so an unexpectedly high month does not become a misleading baseline for every future month.
Keep a backup if the sheet is important. Google Sheets saves changes online, but a separate copy or download can help preserve a snapshot before a major restructure.

Troubleshooting

A total shows zero or does not include a new row: Check that the amount cells contain numeric values, and inspect the formula’s range. If you added a category below row 17, expand the relevant SUM range and the remaining-amount or formatting ranges to include the new row.
A formula appears as text: Click the cell and check whether the entry starts with an apostrophe or whether the cell is formatted as plain text. Change the format using Format > Number, then re-enter the formula beginning with an equals sign.
The remaining amount has the wrong sign: This guide uses planned minus actual. A negative value means actual spending is higher than planned. Confirm that planned and actual values have not been swapped and that the formula references the correct row.
The result looks wrong after copying a formula: Click a copied cell and inspect its references. When filling down, D10 should change to D11, D12, and so on. If you pasted a value rather than the formula, restore the formula from a neighboring row and fill it down again.
Currency formatting looks incorrect: The displayed symbol depends on the selected format and spreadsheet locale. Select the cells and choose Format > Number > Currency, then check the spreadsheet’s locale under File > Settings if decimal and date conventions seem unexpected. Do not change the locale casually if the sheet contains dates or formulas you depend on.
Someone accidentally changed the sheet: Use File > Version history > See version history to review earlier saved versions. Restore a version only after checking what changes it contains; you can also copy needed values from an earlier version instead of replacing all current work.

Budget figures are for organizing and tracking, not financial, tax, investment, or legal advice. For decisions that depend on a loan, verify the lender’s actual terms; for tax, investment, or legal questions, check with a qualified professional.

Frequently Asked Questions

Can I use this budget plan for more than one month?
Yes. Duplicate the sheet tab for each month, rename it, and update the planned and actual figures. Check that copied formulas still refer to that month’s cells and that you are comparing equivalent periods.

Should I enter take-home pay or gross income?
For a simple spending plan, use the income amount that is actually available to spend, and label it clearly. If you include gross pay, account separately for deductions so the remaining figure does not overstate available cash.

What if my income changes from month to month?
Use an estimate that reflects the income you reasonably expect for that month, then update it when the amount is known. You can add separate income rows if that makes different sources easier to track, and sum them in a clearly identified total.

Can Google Sheets automatically pull my bank transactions?
This basic template does not connect to a bank. You can enter totals manually or import records using a method you trust, then review categories and duplicates yourself. Avoid sharing account credentials in a spreadsheet.

How do I add another spending category?
Insert a row within the category list, type the category name and planned amount, and copy the remaining-amount formula from a nearby row. Expand the summary formula and conditional-formatting range if the new row falls outside them.

Is this better than using a budgeting app?
It depends on how you want to work. Sheets gives you control over categories and calculations, while an app may automate transaction imports or reminders. Choose a method you can maintain and check any app’s privacy and account-linking details before using it.

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.