Weekly Budget Worksheet: Free Google Sheet and PDF
Weekly Budget Worksheet: Free Google Sheet and Printable PDF
A monthly budget can feel too far away. By the time you notice you overspent, the month is over. A weekly budget worksheet fixes that: you plan one week at a time, check your spending every few days, and correct course before small leaks become big ones.
This free weekly budget template comes in two versions:
- Google Sheets version with automatic formulas and a Daily Log: Open the weekly budget worksheet
- Printable PDF version if you prefer pen and paper: Download the weekly budget worksheet PDF
For the Google Sheet, open the link and choose File > Make a copy to get your own editable version. To use it in Excel, choose File > Download > Microsoft Excel (.xlsx).
Why use a weekly budget?
- Faster feedback. You see problems in days, not weeks.
- Matches how many people are paid. Weekly and bi-weekly paychecks are easier to budget week by week.
- Smaller numbers are easier to manage. Controlling $90 of dining out this week feels more doable than controlling $360 this month.
- Builds the habit. A five-minute weekly review is easier to keep than a long monthly session.
What is inside the weekly budget template?
The Google Sheet has two tabs.
Tab 1: Weekly Budget
Step 1: Income this week. List each income source (paycheck, side income, other) with the expected amount and the actual amount. The sheet shows the difference, so you can see right away if side income came in lower than planned.
Step 2: Plan your week. Each spending category has a group and a planned amount:
- Needs: housing or rent share, utilities, groceries, transportation, insurance, other needs
- Wants: dining out, entertainment, shopping, subscriptions, other wants
- Savings: emergency fund, savings goals, investing or retirement
- Debt Payoff: extra debt payments
The Actual column fills itself from your Daily Log, and the Difference column shows what is left or over. The Unassigned line shows how much of your income is not yet given a job. In a zero-based budget, the goal is $0.
Where your money goes. A table compares your plan and your actual spending with the 50/30/20 guideline: 50% needs, 30% wants and 20% for savings plus debt payoff. You can edit the yellow target cells to use your own split.
Weekly review. A short checklist and three prompts: your biggest overspend and why, one change for next week, and your win of the week.
Tab 2: Daily Log
Record each purchase here as it happens. The totals flow back into the Weekly Budget tab, so you never have to type the same number twice.
Colour guide: blue cells are your inputs, black cells are formulas, green cells are pulled from the Daily Log, and yellow cells are assumptions you can change.
How to use the weekly budget worksheet: 6 steps
- Make your copy. Open the Google Sheet and choose File > Make a copy (or print the PDF).
- Enter the week. Type your week-start date.
- List your income. Put in what you expect to receive this week.
- Plan every dollar. Fill in the Planned column until Unassigned reaches $0. If you have money left, give it to savings or debt.
- Log purchases. Add each purchase to the Daily Log, ideally the same day. Two minutes a day is enough.
- Review on the same day each week. Compare planned and actual, then fill in the three review prompts.
Example: a $1,000 week (from the sample sheet)
The sheet includes sample numbers so you can see how it works. Replace them with your own.
| Group | Planned | Share of income |
|---|---|---|
| Needs | $500 | 50% |
| Wants | $300 | 30% |
| Savings | $160 | 16% |
| Debt Payoff | $40 | 4% |
Savings plus debt payoff come to $200, which is 20% of income, exactly the 50/30/20 target. In the sample, the actual week shows less spent than planned on entertainment and transportation, a small overspend on shopping and utilities, and an Unassigned amount of $234. That leftover is a prompt to move money to savings or debt before it disappears into everyday spending.
Using this as a bi-weekly budget worksheet
The sheet is built for one week at a time, but it works well for bi-weekly pay:
- Option 1: two weeks, two copies. Make one copy for each week of the pay period and plan each separately.
- Option 2: one pay period. Enter your whole paycheck as the income, and plan two weeks of spending in the Planned column. Then log the whole period's purchases in the Daily Log.
- Bills that land once per pay period: put them in the week they are due, and spread flexible costs (groceries, transport) evenly.
To convert a monthly amount to a weekly one, divide by 4.33. For example, a $650 monthly grocery budget is about $150 a week.
Weekly vs monthly budget: which is better?
Neither is better for everyone. A weekly budget gives you tighter control and faster feedback, which helps if you overspend on variable categories like food and fun. A monthly budget is simpler for fixed bills like rent. Many people use both: monthly for the big picture and weekly for everyday spending. Read our comparison: Weekly Budget vs Monthly Budget: Which Is Better.
Tips to get the most from your weekly budget
- Start with bills and savings. Cover needs and pay yourself first, then plan wants.
- Be realistic. A plan you can follow beats a perfect one you ignore.
- Add a buffer category. Small surprises happen; give them a few dollars.
- Track cash too. The Daily Log works only if it includes every purchase.
- Adjust, don't quit. If you overspend, change next week's plan instead of abandoning the budget.
- Keep your copy private. It will hold your personal numbers, so don't share it publicly.
Frequently asked questions
Is this weekly budget worksheet free?
Yes. You can copy the Google Sheet or download the PDF at no cost.
Can I use it in Excel?
Yes. Download the Google Sheet as an .xlsx file with File > Download > Microsoft Excel. Check that formulas and formatting look right in your version of Excel.
Is there a printable version?
Yes. The PDF is made for printing, and you can also print the Google Sheet with File > Print.
Does it work for weekly paychecks?
Yes. That is what it is designed for. Enter your paycheck in the income section and plan the week.
Does it work for bi-weekly pay?
Yes, see the section above. Use one copy per week, or plan a two-week period in one copy.
What does Unassigned mean?
It is your income minus everything you have planned. At $0, every dollar has a job.
Is this financial advice?
No. It is an educational template. The sample figures are examples only.
Keep learning
- How to Budget Your Money Wisely
- Zero-Based Budgeting Explained
- How to Budget for a Family
- How to Create a Grocery Budget
- Free e-book: Personal Finance 101
About the Author
Montu Das is the editor and founder of Smart Money Guide. He worked as a financial associate at MetLife in Sylhet, Bangladesh. Verify his MetLife Bangladesh advisor profile.
