A weekly budget spreadsheet template is a simple table for comparing planned income and expenses with what actually happened. In Excel for Microsoft 365 on Windows, set up columns for category, planned amount, actual amount, and remaining or over-budget amount, then use SUM formulas to total each week.
What a weekly budget template should track
A weekly budget focuses on the money expected to come in and go out during one defined seven-day period. That can make it easier to notice a grocery overspend or an upcoming bill than a monthly view alone. It is especially useful when pay arrives weekly, spending varies from week to week, or you want a short review cycle.
A practical sheet separates income from expenses instead of mixing them in one list. Income can include wages, side work, reimbursements, or other money you expect to receive. Expenses might include groceries, transport, bills, subscriptions, and savings contributions. The planned amount is your estimate or limit; the actual amount is what you record after a transaction clears or you otherwise confirm it.
Decide what “week” means before entering numbers. A Monday-to-Sunday week is easy to compare, but a pay-period week may fit your circumstances better. Put the start date near the top and use the same rule consistently. A budget is a planning and tracking tool, not a guarantee that bills will arrive on a particular day or that an estimate will match the final amount.
A copyable weekly budget layout
Create a worksheet with the following sections. The row numbers are useful because the formulas below refer to them; category names can be adjusted to match your spending.
| Cell or range | What to enter |
|---|---|
| A1 | Weekly Budget |
| A2 and B2 | Week starting; enter the week’s start date in B2 |
| A4:D4 | Income | Planned | Actual | Difference |
| A5 | Paycheck |
| A6:A7 | Other income; use one source per row |
| A8:D8 | Total income |
| A11:D11 | Expenses | Planned | Actual | Left |
| A12:A20 | Housing, groceries, utilities, transport, debt payments, subscriptions, personal, savings, and other |
| A21:D21 | Total expenses |
| A23:C23 | Estimated remainder | Planned remainder | Actual remainder |
Put the corresponding amounts in columns B and C: planned in B and actual in C. The expense list is a starting point, not a required set of categories. If a category does not apply, rename it or remove it; if one category hides too many different purchases, split it into clearer rows. The “Left” column for expenses shows planned amount minus actual amount, so a positive result means some of the plan remains.
Set up totals and formulas
Enter amounts as numbers, not text with currency symbols typed into the cell. You can apply a currency format using Home > Number. That keeps values usable in calculations while displaying the currency style you choose. Format the date in B2 as a date as well.
With income planned amounts in B5:B7, enter this in B8 to total planned income: =SUM(B5:B7). With actual income in C5:C7, enter this in C8 to total actual income: =SUM(C5:C7). For the income difference, with the total planned and actual amounts in B8 and C8, enter this in D8: =C8-B8. A positive difference means actual income was higher than planned; a negative difference means it was lower.
With planned expenses in B12:B20, enter this in B21: =SUM(B12:B20). With actual expenses in C12:C20, enter this in C21: =SUM(C12:C20). For an expense’s remaining amount, with its planned figure in B12 and actual figure in C12, enter this in D12: =B12-C12. Copy that formula down through D20. For example, if groceries are planned at $150 and actual spending is $132, D13 returns $18 when those values are in B13 and C13. A negative result means actual spending exceeded that category’s plan.
For the planned remainder, with total planned income in B8 and total planned expenses in B21, enter this in B23: =B8-B21. For the actual remainder, with actual income in C8 and actual expenses in C21, enter this in C23: =C8-C21. For example, planned income of $900 and planned expenses of $850 produce a planned remainder of $50. If actual income is $920 and actual expenses are $812, the actual remainder is $108. These are illustrative numbers; the formulas simply subtract the expense total from the income total.
Build the sheet in Excel
- Open a blank workbook and name the first worksheet something recognizable, such as “Weekly Budget.”
- Enter the labels and categories in the cells shown in the layout. Keep headings in row 4 and row 11 so the example formulas match.
- Enter planned values before or at the start of the week. Leave actual amounts blank until you have a figure to record; a blank actual cell is not the same as proof that nothing was spent.
- Type the totals and category formulas into their stated cells. To copy the D12 formula down, select D12 and drag its fill handle to D20, or copy and paste it into the range.
- Make headings bold, widen columns so labels are readable, and use consistent number formatting. A border or fill color can distinguish totals from entries without making the sheet difficult to scan.
- Save the workbook as an Excel workbook (.xlsx). For the next week, either duplicate the sheet and update the start date or clear only the previous week’s input cells while preserving formulas.
Excel for Mac has the same basic worksheet cells and formula approach, though ribbon placement and some shortcuts can differ from Windows. The formulas above work in current Microsoft 365 desktop Excel on both platforms. If Excel uses a different regional list separator, it may display or require a separator other than a comma in formulas; follow the separator convention used by that installation.
Choose categories and a useful level of detail
Categories should answer a question you actually want the sheet to answer. “Food” may be enough if the goal is to keep a weekly total in view. If you need to distinguish groceries from restaurant meals, create separate lines. Too few categories conceal patterns; too many create extra entry work and can make weekly review feel burdensome.
- Include recurring costs thoughtfully. A monthly bill may not be paid every week, but setting aside a portion weekly can help you plan for it. Label this as a weekly set-aside rather than suggesting the bill itself is paid every week.
- Separate savings if it is part of your plan. Recording a planned transfer as an expense or allocation can make the amount visible. Use one consistent method so you do not count the same transfer twice.
- Keep irregular costs visible. Gifts, repairs, or annual renewals may not occur in a typical week. A dedicated “irregular expenses” line or a separate note can make room for them when relevant.
- Use notes for exceptions. A short note such as “annual charge” or “reimbursed next week” explains an unusual number without requiring a new category.
A weekly sheet is not automatically better than a monthly one. Some expenses are billed monthly, and a weekly view can make them look absent in three weeks and unusually large in the fourth. A weekly set-aside can smooth planning, but the total and timing still need to reflect the real bill. Keep the original bill amount and due date somewhere reliable rather than treating the spreadsheet as a substitute for a statement or reminder.
How to use it during the week
Enter planned income and spending before the week begins if possible, then update actual amounts on a regular schedule. A brief daily entry may suit someone who pays mostly by cash; a weekly review may be enough for someone whose transactions are already easy to check. Whichever routine you choose, use a consistent source for actuals, such as receipts, account activity, or a transaction record you maintain.
At the end of the week, check that the actual amounts include the whole period and that transfers or refunds have not been counted twice. Compare the category differences and the actual remainder with your expectations. If one figure is surprising, investigate the transactions rather than assuming the formula is wrong. A useful review asks what changed—such as a one-time purchase, a price increase, or an estimate that was too low—and whether next week’s plan should be adjusted.
For a longer view, keep a separate worksheet for each week or create a summary table that collects weekly totals. Separate sheets are straightforward for beginners, while a single transaction log can be more flexible for filtering and comparing categories over time. Avoid overwriting earlier weeks if you want a record of how estimates changed; save a fresh copy or duplicate the worksheet instead.
Common problems and how to avoid them
- Typing over a formula: If a total stops updating, select the cell and check whether its formula is still present. Keep formulas in their own total or calculation cells and enter transactions only in the input columns.
- Mixing planned and actual amounts: Use clear headings and avoid entering an actual purchase in the planned column. Otherwise, the comparison can look better or worse for the wrong reason.
- Inconsistent weeks: Switching between calendar weeks and pay periods makes comparisons misleading. Record the date range or start date and follow the same definition each time.
- Double-counting transfers: A transfer from checking to savings is not necessarily a new purchase. Decide whether the sheet tracks cash leaving a particular account or spending and allocations, then apply that approach consistently.
- Assuming a negative number is always an error: A negative amount in an expense “Left” cell usually indicates an overrun under this layout. It can be a real result, not a broken calculation.
- Using the sheet as a live bank balance: Planned and recorded amounts may omit pending transactions, fees, or timing differences. Confirm account balances and payment details with the relevant financial institution.
When a spreadsheet is the right choice
A spreadsheet is useful when you want a customizable, transparent view and are comfortable entering or checking amounts yourself. It costs nothing extra if you already have access to Excel, but Microsoft 365 access may involve a subscription depending on how you obtain the software. A spreadsheet does not automatically know whether a transaction is valid, categorize it correctly, or reflect a bank’s current balance. Protect the file appropriately if it contains sensitive information, and avoid storing account passwords or full payment-card details in it.
Alternatives include a paper budget, a banking app’s spending tools, or a dedicated budgeting application. Paper has little setup but makes totals and comparisons manual. Apps may automate some transaction imports, but availability, fees, privacy practices, and account connections vary by provider. Choose based on the time you want to spend entering data and the level of control or automation you need; verify any product’s terms and security information directly.
Frequently Asked Questions
Can I use this weekly budget template in Google Sheets?
Yes. The basic layout and SUM formulas are also supported in Google Sheets. Menu names and formatting steps differ, so the Excel ribbon directions in this page may not match Sheets.
Should I budget by calendar week or payday?
Use the period that makes planning and review easiest, then keep it consistent. If your pay schedule does not line up with Monday through Sunday, a pay-period week may be more practical; label the dates clearly.
What should I put in the actual column if I spent nothing?
Enter 0 when you have confirmed there was no spending in that category. Leaving the cell blank can mean the amount has not been checked yet, which is different from a verified zero.
How do I handle monthly bills in a weekly budget?
You can record the bill in the week it is due or plan a weekly set-aside toward it. Choose one method that matches your goal, label it clearly, and avoid counting both the set-aside and the full payment as separate spending in the same total.
Why is my remaining amount negative?
In this template, an expense’s remaining amount is planned minus actual. It becomes negative when actual spending is greater than the plan. Check that both figures are entered in the correct columns, then decide whether the estimate or the plan needs revisiting.
Is a weekly spreadsheet enough to manage every bill?
Not by itself. It can help organize a weekly plan, but it may not include payment timing, pending transactions, or every account obligation. Use statements, due-date reminders, and the relevant provider’s current information alongside the spreadsheet.
Related
- Food Inventory Spreadsheet: Free Template and Setup
- Wedding Budget Spreadsheet: Track Every Cost in Excel
- How to Add Custom Transitions to PowerPoint
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Project Tracker Spreadsheet Template: Excel Setup GuideA project tracker spreadsheet template is a structured worksheet for recording tasks, owners, dates, status, and progress in…
- Embed a Stream Video in PowerPoint: Step-by-Step GuideTo put a Microsoft Stream video in PowerPoint, first make sure your audience can access it, then try…
- Excel Find and Replace Asterisk: Find * Literally in CellsTo find a literal asterisk in Excel, press Ctrl+H, enter ~* in Find what, and choose Find All…
- Excel Jungle Data Analysis: A Practical Field GuideYes. Microsoft Excel can organize jungle or rainforest survey records, summarize species observations, compare sites and dates, and…
- Google Sheets QUERY ORDER BY: Sort Query ResultsIn Google Sheets, use the order by clause inside a QUERY formula to sort the rows it returns.…
- Excel vs. Google Sheets: Key Differences ExplainedMicrosoft Excel is generally stronger for advanced analysis, large or complex workbooks, and specialist business features; Google Sheets…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.