Weekly Budget Spreadsheet: Build a Clear Excel Plan

How-to basics · Updated November 21, 2026

A weekly budget spreadsheet is a simple way to compare the money you expect to receive with the amounts you plan to spend or set aside during a week. In Excel for Microsoft 365 on Windows, create columns for categories, planned amounts, actual amounts, and the difference; add totals and compare actual outflows with weekly take-home income.

What a weekly budget spreadsheet is for

A weekly budget organizes cash flow around a seven-day period. It can help you see whether spending is tracking to plan, make room for bills that fall on different dates, and notice small purchases that accumulate. It is a planning and record-keeping tool, not a guarantee that every expense will be predictable.

“Weekly” can refer to the week in which money arrives, the calendar week, or a personal pay cycle. Choose one definition and use it consistently. A Monday-to-Sunday week is easy to compare over time, while a Friday-to-Thursday period may fit someone paid every Friday. The important thing is to record each transaction in the same period as the corresponding budget.

A weekly sheet is especially useful for costs that happen often, such as groceries, transit, fuel, or meals. It can also account for monthly bills by assigning part of each week’s income to them. The sheet should make clear whether it tracks actual spending only or also savings transfers and bill reserves. Those are different kinds of outflows, even though both reduce money available for other uses.

Set up the worksheet in Excel

Open a blank workbook in Excel for Microsoft 365 on Windows. Give the first worksheet a descriptive name such as Weekly Plan. Put the week’s start and end dates near the top, then list the take-home income available for that period. A compact layout might use these columns: Category, Planned, Actual, and Difference. Under Category, include the items that matter in your own situation rather than copying a generic list uncritically.

For example, place weekly income in B3, the headings in A6:D6, categories in A7:A13, planned amounts in B7:B13, actual amounts in C7:C13, and differences in D7:D13. Add a total row in row 14. Possible categories include housing allocation, groceries, transportation, utilities, personal spending, savings, and irregular expenses. Housing and utility amounts can represent the portion assigned to this week, not necessarily a bill paid during the week.

To format the range as a table, select the headings and category rows, then choose Insert > Table and confirm that the table has headers. Tables make it easier to maintain consistent formatting as rows are added. Use Home > Number to apply a currency format to the money cells. On Mac, the Excel ribbon is similar, although window layout and some keyboard shortcuts differ; menu names and formulas described here are for Microsoft 365 on Windows.

Choose categories and a time period

Useful categories are specific enough to explain where money went but not so numerous that tracking becomes a chore. If a broad “shopping” line combines groceries, household supplies, and clothing, it may conceal the reason spending changed. Conversely, separate lines for every small purchase can take too long to update. Start with a manageable set, then split a category only when the extra detail would help you make a decision.

Separate planned amounts from actual amounts. Planned is what you expect or allocate before the week begins; actual is what was received, spent, or transferred once it happens. A budget is easier to interpret when you decide in advance how to record refunds, reimbursements, cash purchases, and shared expenses. For example, you might record a refund as a reduction in the original category’s actual spending instead of as new income, provided you apply that method consistently.

For irregular income, avoid treating a possible payment as money already available. Record income when it is received or clearly label an estimate as an estimate. If pay dates do not match the week boundaries, use the date of each deposit and decide which budget period it funds. The spreadsheet can show the timing, but it cannot determine what funds are legally or contractually available.

Use formulas to calculate totals and remaining money

Suppose the layout uses planned amounts in B7:B13, actual amounts in C7:C13, and a total row in row 14. In B14, enter =SUM(B7:B13) to total planned allocations. In C14, enter =SUM(C7:C13) to total actual outflows. For the example below, planned amounts of 250, 140, 60, 45, 70, 150, and 185 total 900. Actual amounts of 250, 132, 52, 43, 61, 150, and 184 total 872.

With planned values in B7:B13 and actual values in C7:C13, enter =B7-C7 in D7 and fill it down through D13. A positive result means actual outflow is below the planned amount for that row; a negative result means it is above. This arithmetic shows a difference, not whether the spending was necessary or whether the plan was realistic. In the example, groceries show 8 remaining against plan, while the total actual outflow is 28 below the planned 900.

With weekly take-home income in B3 and total actual outflows in C14, enter =B3-C14 in B15 to calculate the amount left after the listed outflows. If B3 is 900 and C14 is 872, the result is 28. This number is meaningful only if the actual column includes all the outflows you intend to compare with income. If the sheet leaves out a bill, debt payment, or cash withdrawal, the displayed remainder will overstate what is actually available.

All three formulas use standard Excel functions or arithmetic and work in Microsoft 365. When you copy a formula down, check that the row references change as intended. Format the results as currency, and use a clear label such as Amount left rather than a vague heading like Balance.

Handle monthly bills and savings in a weekly plan

A monthly obligation does not become a weekly bill simply because a sheet is organized by weeks. One common planning approach is to allocate a portion of the monthly amount in each weekly period, then track the actual payment separately when it is paid. For a regular monthly amount, dividing by four is only an approximation because a year has 52 weeks, not 48. Dividing by 4.33 gives a closer average weekly allocation, but actual due dates and pay timing still matter.

For a simple annualized conversion, suppose the monthly net income is in B2. The formula =B2*12/52 returns an average weekly equivalent. If B2 is 3,900, the calculation is 3,900 × 12 ÷ 52, or 900 per week. This average does not mean a monthly deposit arrives weekly; it is just a way to compare amounts over a common period. For a specific budget, using actual deposit dates and bill due dates may represent cash flow more accurately.

Savings can appear as its own planned allocation. If money is transferred to savings, record the transfer once and do not also count it as spending in another category. Similarly, if you set aside money for an upcoming bill, make clear whether the reserve is being tracked as an allocation or whether the eventual payment is the outflow. Counting both the reserve and the payment as separate uses of the same money can make totals misleading.

Review the sheet and make it easier to maintain

A spreadsheet is only as useful as the routine behind it. One workable process is to enter the plan at the beginning of the week, update actual amounts as transactions occur, and review totals at the end. Frequent updates reduce the effort of reconstructing small cash purchases later. If exact daily tracking is not practical, choose a regular time to enter transactions from account records and receipts.

  • Keep the same category names from week to week so comparisons remain meaningful.
  • Enter expenses as positive amounts if the formulas subtract actual from planned; do not mix positive and negative conventions.
  • Record the transaction date and a short note in an additional log if you need an audit trail of individual purchases.
  • Use a separate worksheet for each week, or maintain a transaction log with a date column and filter it by week.
  • Save the workbook in a location that is backed up, and avoid putting account passwords or full payment-card details in it.

For visual cues, select the difference cells and use Home > Conditional Formatting > Highlight Cells Rules to flag values below zero. Conditional formatting changes appearance; it does not repair an incorrect formula or explain why a category exceeded its plan. Recheck the formula range when you insert or remove rows, particularly if the total is not included in the intended categories.

Common mistakes and useful comparisons

A frequent misconception is that a weekly budget should divide every monthly bill by four and treat the result as exact. That can leave an annual shortfall because 12 months contain about 52 weeks. Another mistake is to compare a full month of income with one week of expenses, or to compare gross pay with spending funded by take-home pay. Align the period and the type of income before interpreting the remainder.

Also distinguish a budget from a transaction log. The budget describes intended allocations; a log records what happened, often with dates, descriptions, and amounts. A small weekly sheet may be enough if the goal is a quick overview. If you need to reconcile purchases, a separate log feeding totals into the weekly summary is more informative. Avoid manually adding the same transaction in both places unless the summary is clearly an independent total rather than another record.

A spreadsheet is flexible and can be customized without adopting a fixed template, but it requires manual setup and consistent entry. A banking app may import transactions automatically, though its categories or timing may not match the way you plan. A paper worksheet can be convenient for a short list but is less suited to automatic totals. The best option depends on whether you value customization, automatic transaction importing, or a simple offline record.

Frequently Asked Questions

How do I make a weekly budget spreadsheet in Excel?
List weekly income, then create columns for categories, planned amounts, actual amounts, and differences. Add totals with SUM formulas, compare actual outflows with income, and update the sheet on a regular schedule.

What should I include in a weekly budget?
Include the income available for the week and the spending or allocations you want to track, such as housing, food, transport, bills, savings, and irregular costs. Choose categories that fit your circumstances and avoid counting the same money twice.

How do I convert monthly income to weekly income in Excel?
If a monthly amount is in B2, =B2*12/52 calculates an average weekly equivalent. A monthly income of 3,900 gives 900 per week. This is an average, not a statement that the income is paid every week.

Should savings count as an expense in a weekly budget?
That depends on what you want the sheet to measure. You can list a savings transfer as an allocation or outflow to show that the money is no longer available for other spending, but keep the treatment consistent and do not count the same transfer twice.

Can I use one spreadsheet for multiple weeks?
Yes. You can duplicate a weekly worksheet or keep transactions in one dated log and summarize each week separately. Duplicated sheets are straightforward, while a single log can make longer-term comparisons easier if dates, categories, and formulas are maintained consistently.

Related

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.