How to Make a Weekly Budget in Google Sheets Easily

To make a weekly budget in Google Sheets, create columns for planned and actual income and expenses, then use SUM formulas to calculate totals and the money left over. You’ll need a Google account, a browser, and a rough list of the income and spending you expect for one week. The example below uses an illustrative week; change the categories and amounts to fit your own situation.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
Your expected weekly income and expense categories. Recent bank or card statements, receipts, or pay information can help you estimate amounts.
A few minutes to enter the figures and update actual spending as the week goes on.

Step-by-Step

Create a new sheet and label the week. Open Google Sheets, choose Blank spreadsheet, and rename the file with a clear name such as Weekly budget. In cell A1, type Week starting; enter the first day of the budget week in B1. Use the same definition of a week each time, such as Monday through Sunday, so that your comparisons are consistent. To format the date, select B1 and choose Format > Number > Date.
Set up the income table. In A3:D3, enter the headings Category, Planned, Actual, and Difference. In A4 and A5, enter income sources such as Pay and Other income. Put your expected amounts in B4:B5, and leave C4:C5 ready to record what you actually receive. Use row 6 for Total income. Keeping planned and actual figures in separate columns makes it easier to see whether the week matched your expectations.
Add an expense table. In A9:D9, enter Category, Planned, Actual, and Remaining. Add your expense categories in A10:A15, such as Groceries, Transport, Bills, Eating out, Health, and Other. Enter a realistic planned amount for each category in B10:B15. Record purchases or payments in C10:C15 as they happen. Row 16 will hold total expenses. If a category does not apply, replace it with one that reflects your spending rather than leaving a category you will not use.
Format the money columns. Select B4:D6, then choose Format > Number > Currency. Repeat for B10:D16 and B19:D19 after you create the balance section. Currency formatting changes how values appear; it does not convert one currency into another. If the default currency is wrong, select the relevant cells and use Format > Number > Custom currency to choose the appropriate symbol and format. Keep the same currency throughout the sheet.
Calculate total income. Enter the formulas below in the total row. The sample assumes planned income is 800 and 50, while actual income is 800 and 20. The difference is actual income minus planned income, so a negative result means less income arrived than expected.
With planned income in B4:B5, enter this in B6: =SUM(B4:B5). The illustrative result is 850.

With actual income in C4:C5, enter this in C6: =SUM(C4:C5). The illustrative result is 820.

With total planned income in B6 and total actual income in C6, enter this in D6: =C6-B6. The illustrative result is -30.
Calculate total expenses and remaining category amounts. Use the next formulas to total the expense columns and calculate how much of each category’s plan remains. For the example, planned expenses are 150, 60, 200, 50, 30, and 60, which total 550. Actual expenses are 140, 55, 200, 35, 25, and 70, which total 525.
With planned expenses in B10:B15, enter this in B16: =SUM(B10:B15). The illustrative result is 550.

With actual expenses in C10:C15, enter this in C16: =SUM(C10:C15). The illustrative result is 525.

With planned and actual expenses in columns B and C, enter this in D10: =B10-C10. Copy or fill the formula down through D15; each row will show that category’s planned amount minus its actual amount. For Groceries, 150 planned minus 140 actual gives 10 remaining. A negative result means spending exceeded the plan.

With total planned expenses in B16 and total actual expenses in C16, enter this in D16: =B16-C16. The illustrative result is 25 remaining across the expense categories.
Show the weekly balance. In A18:D18, enter the headings Weekly balance, Planned, Actual, and Difference. Use row 19 for the figures. This balance is income minus expenses, not a prediction of your bank balance; it only reflects the numbers entered in this weekly sheet.
With planned income in B6 and planned expenses in B16, enter this in B19: =B6-B16. The illustrative planned balance is 300.

With actual income in C6 and actual expenses in C16, enter this in C19: =C6-C16. The illustrative actual balance is 295.

With planned balance in B19 and actual balance in C19, enter this in D19: =C19-B19. The illustrative difference is -5, because the actual balance is five less than planned.
Make the sheet easier to scan and reuse. Bold the header rows and total rows, and widen columns A:D by dragging the borders between their letters. For a visual warning when an expense category goes over plan, select D10:D15 and choose Format > Conditional formatting. Set the rule to format cells if less than 0, then choose a noticeable fill color and select Done. To use the budget again, choose File > Make a copy, change the week-start date, and clear only the previous week’s actual entries. Keep the category names and formulas intact.
Update actuals during the week and review the result. Enter income received and expenses paid in the Actual column, using numbers rather than typing currency symbols into each cell. If you make multiple purchases in a category, add them together before updating that category, or keep a separate transaction list and enter its weekly total. At the end of the week, check that the totals and remaining amounts reflect all the entries you intended to include. Adjust planned amounts for the next week based on what you learn, rather than changing the past week’s actual figures to make the plan look better.

Common Mistakes

Mixing weekly and monthly amounts: A monthly bill can distort a one-week plan if you enter the whole amount without deciding how you want to handle it. You can set aside a consistent weekly portion for that bill or include it in the week when it is due, but use the same approach from week to week and make the choice clear in the category name or a note.

Overwriting formulas: Typing a number into a total cell replaces its formula. Keep manual entries in the planned or actual input cells, and leave total and balance cells for formulas. If a total stops updating, click the cell and check whether the formula bar still shows a formula beginning with an equals sign.

Counting a purchase twice: If you enter a purchase in a separate transaction list and also add it directly to the category total, it will be counted twice. Decide which method you are using and reconcile the category total against your transaction records before drawing conclusions.

Leaving out small or irregular costs: Occasional charges, cash purchases, and small subscriptions can add up. Include useful categories such as Other or Personal, and review them later to see whether they should become distinct categories. Avoid treating a blank actual cell as proof that no spending occurred.

Tips

Keep category names specific enough to guide decisions, but not so detailed that recording every purchase becomes a chore. A short list is more likely to be updated regularly.
Use a consistent week start and enter the date in B1 each time. A clear date makes it easier to tell which copy of the budget you are viewing.
Record transactions on a regular schedule, such as after a purchase or once each evening. Waiting until the end of the week can make it harder to remember cash spending and small charges.
Leave a small amount in a flexible category if your expenses vary. The example’s Other row can absorb genuinely miscellaneous items, but review it rather than letting it hide a recurring expense.
Protect the formulas from accidental edits by keeping input cells visually distinct. For example, use a light fill for cells where you type amounts and a different fill for calculated totals.
Google Sheets saves changes automatically when you are online. If you need to work without a connection, offline access must be enabled in your Google Drive settings beforehand, and availability depends on your device and browser setup.

Troubleshooting

A formula displays as text or does not calculate: Check that the entry starts with = and that the cell is not formatted as plain text. Choose Format > Number > Automatic, then re-enter the formula. Also check for a stray apostrophe before the equals sign, which makes Sheets treat the entry as text.

The total seems too high or too low: Click the total and inspect the formula’s cell range. For example, =SUM(C10:C15) includes only C10 through C15; it will not include an amount typed in C16 or another column. Look for a missing row, a duplicate transaction, or a number entered in the wrong category.

A currency symbol or decimal format is unexpected: Select the affected cells and use Format > Number to choose the appropriate currency or number format. Formatting will not repair an incorrectly entered value. If your sheet uses a locale with different decimal or formula separators, check File > Settings; Sheets may display separators differently depending on the spreadsheet’s locale.

The conditional formatting color does not appear: Select D10:D15 and open Format > Conditional formatting. Confirm that the rule applies to the intended range and uses the condition less than 0. A zero means the planned amount exactly matches actual spending, so it will not trigger a less-than-zero rule.

You accidentally deleted a formula: Use Edit > Undo promptly, or restore the formula by entering it again in the correct total cell. If you have already made several edits, use File > Version history > See version history to inspect earlier versions before restoring one. Be careful: restoring a full earlier version can also discard later changes you want to keep.

Frequently Asked Questions

Can I make a weekly budget in Google Sheets for free?
Google Sheets is available at no charge for personal use with a Google account, subject to Google’s current account and service terms. Open Sheets in a browser and create a blank spreadsheet to start.

How do I change the budget for a new week?
Use File > Make a copy to preserve the previous week. Update B1, clear the old actual income and expense entries, and leave the category names, planned amounts, and formulas in place. Adjust planned amounts when your expectations change.

What is the difference between planned and actual spending?
Planned spending is the amount you intend or expect to spend in a category. Actual spending is the amount you recorded as spent. In this template, Remaining is planned minus actual, so a positive number is still available and a negative number is over plan.

Can I use this sheet for monthly bills?
Yes. Decide whether to include a bill in the week it is paid or spread a planned portion across weeks, then use that method consistently. The weekly balance is only a summary of the amounts entered, so it will not automatically account for bills or transactions you have left out.

Can I share the budget with someone else?
Yes. Select Share in Google Sheets and choose whether the other person can view, comment, or edit. Give edit access only to people who should be able to change amounts or formulas, and avoid entering sensitive account credentials or payment details in the sheet.

This is a practical tracking template, not financial, tax, investment, or legal advice. For questions about payment obligations, account terms, or other specific commitments, check the relevant provider’s terms or consult a qualified professional.

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.