Weekly Budget Template (Excel)
A free Excel weekly budget with a column for each day, a budget for every category, status flags and a budget-vs-spent chart.
What is in this template
This is a one-sheet weekly planner called Week, plus a How to use tab. It is made for people who get paid weekly or who want to see their spending in short, repeatable cycles.
Week
Set the week start date and your income for the week. List up to 20 categories with a weekly budget. Then type what you spend each day under Mon to Sun. Spent, Left and Status are calculated: the status shows OK, Close when you have used 90 percent or more, or Over. The total row adds up each day, so you can see which day cost the most. Under the table are total budgeted, total spent, income left after spending and income not yet budgeted, plus a chart of budget against spent per category.
How to use
A short list of steps with links back to the main sheet.
The sample data
The sample week has $900 of income and nine categories with $835 budgeted. Spending so far totals $356, so $544 of income is left. The budget leaves $65 of income unassigned. Groceries are $115 of a $120 budget, which shows as Close. Change every number to match your own week.
How to use it
- Enter the week start date and your weekly income.
- Write your categories and a weekly budget for each.
- Each day type what you spent in that day column.
- Watch the Status column. Move money between categories before you go Over.
- Next week copy the sheet or clear the daily cells and start again.
Tips
- Treat savings as a category so the money you set aside is part of the plan.
- Fixed bills such as rent can be entered on the day they leave your account.
- If income not yet budgeted is above zero, give those dollars a job.
- Check the sheet at the same time every day. Two minutes is enough.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
Can I use it every week?
Yes. Copy the sheet for each new week or clear the day columns and change the date.
What does Close mean?
You have used 90 percent or more of that category budget.
Does it include a chart?
Yes, a bar chart compares budget with spent for each category. It has no data labels.
Are the amounts real?
No. The sample numbers are invented for illustration.
Need a custom calculator or spreadsheet built for your business?
Talk to usMore free tools: All free calculators · Budget template for Excel · 50/30/20 budget calculator · How to make a weekly budget