A weekly budget breaks money into short cycles, so you see a problem on Wednesday instead of at the end of the month. This guide shows how to set one up in Excel. The free weekly budget template has everything below built in.
Updated November 2026
Step 1: Start with the week’s income
Write down what you expect to receive this week. If your pay comes every two weeks or monthly, split it into weekly amounts so each week stands alone. The example uses $900.
Step 2: Choose categories and amounts
Use a short list: rent, groceries, transport, utilities, dining out, phone, health, fun and savings. Give each a weekly amount. In the example the budgets total $835, which leaves $65 not yet assigned. If that number is negative you have planned more than you earn.
Step 3: Add a column for each day
Put Mon to Sun across the top. Each day type what you spent in the matching category. Add them up with =SUM(C8:I8) for the spent column and subtract from the budget with =B8-J8 for what is left.
Step 4: Flag categories that are running out
A status formula helps: =IF(J8>B8,"Over",IF(J8>=0.9*B8,"Close","OK")). In the example groceries are $115 of $120, so they show Close. Colour Over red with conditional formatting.
Step 5: Review the week
Total spent is $356 and income left is $544 in the example. Savings were set at $100 and are already in the total. Look at the daily totals along the bottom to see which days cost the most, and whether a pattern like weekend dining is worth changing.
Why weekly works
- It matches weekly pay and weekly shopping.
- Corrections are small because you see them early.
- A copied sheet for each week gives you a record you can compare later.
These are illustrations to help you plan, not financial, legal or tax advice.
Frequently asked questions
How do I make a weekly budget?
List your income, give each category a weekly amount, record daily spending and compare spent with budget.
What if my pay is monthly?
Divide the monthly amounts by about four and a third, or plan the month in weekly blocks.
Should savings be a category?
Yes. Treating it as a category makes it part of the plan.
Is there a free template?
Yes. The weekly budget template on this site has the formulas and chart ready.