Weekly Budget Template for Google Sheets (Free, 2026)

Most budgets are planned by the month, but money isn't spent by the month — it's spent every few days, in trips to the store and fill-ups at the pump. That gap is why a monthly budget can look healthy on the 1st and be in pieces by the 12th. A weekly budget template closes the gap by breaking the month into seven-day chunks, so overspending shows up while you can still do something about it. This guide walks through building one in Google Sheets — and keeping it current without daily data entry.

What a weekly budget actually is

A weekly budget has the same three moving parts as any budget, just on a shorter clock:

1. Income — the money you have to work with this week.
2. Limits — how much you intend to spend in each category this week.
3. Actual — what you really spent this week.

The difference is the horizon. A monthly budget asks you to ration one big pile of money across 30 days in your head. A weekly budget gives you a smaller pile and a shorter deadline — and a smaller pile is far easier to feel. Spend $90 of a $100 weekly grocery limit by Wednesday and you know immediately. Spend $360 of a $430 monthly limit by the 10th and it's invisible until the damage is done.

That's the whole pitch: tighter feedback. You catch problems in days, not weeks, and the correction is small — eat from the freezer for two nights, not "rebuild the entire month."

Weekly vs monthly budgeting

This is the question most people land on, so let's settle it: you don't have to choose, and the best setup usually uses both.

Some spending genuinely happens monthly. Rent, insurance, a car payment, most subscriptions — these leave your account once a month in a fixed amount. Slicing them into weekly pieces is pointless because you don't pay rent a quarter at a time.

Other spending happens continuously. Groceries, gas, dining out, coffee, fun money — these dribble out all month, and they're exactly the categories where people overshoot. This is where weekly limits earn their keep.

The practical answer: keep your fixed bills on a monthly view, and put the spending that fluctuates on a weekly view. The template is built to do both at once — fixed bills sit on the monthly side, and groceries, gas, and fun money get their own weekly columns.

When to lean weekly

• You're paid weekly or every two weeks and want your budget to match the rhythm of your pay.
• You live paycheck to paycheck and the real question is "will the money last until Friday?"
• Your monthly budget keeps blowing up mid-month and you can't tell why until it's too late.

When monthly is enough

• You're on a steady monthly salary with a comfortable buffer.
• Your spending is mostly fixed and doesn't fluctuate much week to week.
• You'd rather check in once a month than every few days.

If you're firmly in the monthly camp, the Monthly Budget template is the better starting point. If you want maximum flexibility over categories and formulas, the Budget Spreadsheet template is the most customizable option.

How to make a weekly budget in Google Sheets (step by step)

You can build one from scratch, but starting from the template means the weekly columns and formulas already work. Here's the full process either way.

Step 1: Figure out your weekly income

If you're paid weekly, this is easy — it's your weekly take-home pay. If you're paid every two weeks, split each paycheck across the two weeks it has to cover so the money lasts until the next deposit. If you're paid monthly but still want weekly control over spending, divide your monthly take-home by 4.33 (the average number of weeks in a month) to get a steady weekly figure.

If your income changes week to week, budget against your lowest recent week. Build the plan on what you can count on, and treat anything above that as a bonus for savings or debt.

Step 2: Choose your weekly categories

A weekly budget works best on the categories that actually fluctuate day to day. Keep it short:

• Groceries
• Gas / transport
• Dining out
• Fun money / entertainment
• Personal & household

Leave fixed monthly bills — rent, insurance, subscriptions — off the weekly side. They aren't spent a little each week, so tracking them weekly just adds noise. The template keeps them on a separate monthly section.

Step 3: Set a limit for each week

Give every category a weekly cap. The simplest way to set one is to take what you want to spend in a month and divide by 4.33. A $400 monthly grocery budget becomes roughly a $92 weekly limit. Round to a clean number you'll remember.

Most months have four full weeks plus a short fifth one. The template handles this with four or five weekly buckets, so a partial fifth week doesn't throw off your monthly total.

Step 4: Track spending by week

You have three options, in increasing order of "set it and forget it":

1. Manual entry — add each purchase to the current week as it happens. Most accurate, most effort — and with a weekly cadence that's a lot of small entries.
2. Weekly catch-up — sit down at the end of each week with your statement and enter everything. Ten minutes, once a week.
3. Automatic sync — connect Avery and your transactions import and categorize themselves into the right week.

Option 3 is the one that survives a busy week — which, with a weekly budget, is most weeks.

Step 5: Do the end-of-week check-in

A weekly budget lives or dies on the weekly check-in. Put five minutes on your calendar — Sunday evening works well — to compare each category's limit to what you actually spent. Overspent on groceries this week? Trim next week's fun money to balance it. The whole point is that the correction is small and immediate, not a month-end reckoning.

What to do with leftover (or overspent) weeks

The best part of a weekly budget is what happens at the boundary between weeks.

If you came in under your limit, you have three good options:

• Roll it forward into next week's limit as a buffer.
• Sweep it to savings the moment the week closes.
• Put it toward debt while the win is fresh.

If you went over, don't scrap the budget — pull the overspend from next week's limit and move on. A single bad week is a small, contained problem in a weekly system, which is exactly why the weekly horizon works. The template tracks the difference between your limit and your actual spending in every category, so you always know how much is free to move.

A worked example: one week on a weekly budget

Numbers make this concrete. Say your weekly take-home is $700 and you're running a weekly budget for the variable categories. A reasonable set of limits might look like this:

• Groceries — $110
• Gas / transport — $50
• Dining out — $40
• Fun money — $40
• Personal & household — $25

That's $265 of variable spending. The rest of the $700 is doing other jobs — a slice toward this month's fixed bills, a savings transfer, maybe a debt payment — which live on the monthly side of the sheet rather than in the weekly buckets.

Now play the week forward. Monday you do a big grocery run for $85, leaving $25 in groceries for the rest of the week. On a monthly budget that $85 would vanish into a $475 monthly grocery line and feel like nothing. On a weekly budget it's immediately obvious that you've used most of the week's groceries on day one — so you cook what's in the fridge Thursday and Friday instead of grabbing more. Wednesday you overspend fun money by $15. No drama: you trim next week's fun money to $25 and the system self-corrects. By Sunday you're $30 under across all categories, and you sweep it to savings.

The point isn't the exact dollars — it's the speed of the signal. Every decision happens against a small, visible number with a deadline a few days away, not a big abstract number due at month-end.

Common weekly budgeting mistakes

A weekly budget is simple, but a few habits quietly undermine it:

• Tracking fixed bills weekly. Rent and insurance don't leave your account a little each week, so splitting them into weekly pieces just adds noise. Keep them monthly.
• Setting limits too tight. If you blow the same category every week, the limit is wrong, not you. Raise it and trim somewhere else — a budget you constantly fail isn't disciplined, it's discouraging.
• Skipping the end-of-week check-in. The weekly horizon only helps if you actually look. Miss two weeks and you've lost the fast feedback that made the weekly approach worth the extra effort.
• Ignoring the fifth week. Most months have a short fifth week. Plan for it with a fifth bucket so it doesn't ambush you, rather than pretending every month is exactly four weeks.
• Letting overspend snowball. Pull a bad week's overspend from next week and move on. The whole advantage of weekly is that one rough week stays contained instead of sinking the month.

How to split monthly bills across your weekly budget

The most common stumbling block with a weekly budget is the big bill that lands once a month. Rent of $1,300, a $180 car payment, a $120 insurance premium — none of these spend "a little each week," so dropping them straight into a weekly column would blow that week apart and leave the other three looking artificially flush.

The fix is a sinking fund: instead of paying the bill out of the week it's due, you set aside a slice of it every week so the money is already waiting when the bill arrives. Take the monthly amount and divide by 4.33. A $1,300 rent becomes about $300 set aside each week; a $120 insurance premium becomes about $28. You're not spending that money on rent each week — you're parking it so the rent week doesn't feel like a cliff.

There are two clean ways to handle this in the sheet:

• Keep bills monthly, fund them weekly. Leave rent, insurance, and the car payment on the monthly section, but add a single weekly line called "Bills set-aside" equal to the sum of those monthly bills divided by 4.33. Each week you move that amount to a separate account or a savings bucket. The weekly side stays focused on variable spending; the monthly side still shows the real bills.
• Average everything into the week. If you'd rather see one number, fold the weekly slice of every fixed bill into your weekly total so a "normal week" already accounts for its share of rent. This is tidier but hides which dollars are committed versus discretionary, so it suits people who keep bills on autopay and never touch them.

Either way, the principle is the same: smooth the lumpy bills into level weekly contributions so no single week has to absorb a month-sized payment. The template's monthly section is built for exactly this — fixed bills live there, and the weekly buckets stay clean for the spending you actually steer day to day.

Weekly budgeting on variable or weekly pay

A weekly budget shines for the people whose pay doesn't fit neatly into a calendar month: hourly workers, servers and bartenders living on tips, gig and rideshare drivers, freelancers, and anyone paid weekly. For these incomes, "what's my monthly budget?" is the wrong question — the real question is "what can I spend this week without running short before the next deposit?" That's the question a weekly budget answers directly.

If your income swings week to week, budget against a floor, not an average. Pull your last eight to twelve weeks of take-home pay and find the lowest one. Build your weekly limits so they fit inside that worst recent week. It feels conservative, and that's the point: a plan that only works on a good week isn't a plan, it's a hope. Anything you earn above the floor becomes a clear, named job — top up next month's bills set-aside, push it to savings, or knock down a debt — rather than quietly leaking into extra spending.

A practical rhythm for variable pay looks like this:

1. Set conservative weekly limits based on your floor week.
2. At the start of each week, confirm the cash is there. If you under-earned, you already know exactly which category to trim before you overspend, not after.
3. When you over-earn, sweep the surplus the same week so it never gets counted as spendable. The surplus has a destination before it has a chance to disappear.

This is also where automatic categorization earns its keep. When income is irregular, you're checking the sheet more often, and a budget that's two weeks out of date can't tell you whether this week is a good one or a tight one. Connecting Avery keeps every deposit and purchase landing in the right week, so the floor-vs-actual picture is always current — which is the only way budgeting against a floor works in practice.

Weekly vs biweekly: matching the budget to your paycheck

"Weekly" describes how often you review and reset the budget; it doesn't have to match how often you're paid. The two most common mismatches are worth handling deliberately.

If you're paid every two weeks, you'll get a deposit roughly every other Friday — 26 paychecks a year, not 24, which means two "extra" paychecks land in the months with a fifth payday. You have two sensible options. You can keep reviewing weekly but plan in two-week blocks: split each paycheck across the two weeks it has to cover so the money lasts until the next deposit. Or you can budget each paycheck on its own, treating "the money from this check" as the pool you ration across the next 14 days. Both work; pick the one that matches how you actually think about your money. When the two bonus paychecks arrive, treat them the same way you treat a surplus week — give them a job up front rather than letting them feel like free money.

If you're paid monthly but still overspend mid-month, you don't need to abandon the monthly view — you just add weekly limits on top of it for the categories that fluctuate. Keep the full monthly salary and fixed bills on the monthly side, then divide your variable categories by 4.33 to get weekly caps. The monthly view answers "am I on track for the month?"; the weekly caps stop you from spending three weeks of grocery money in the first ten days.

The quick rule of thumb:

Pairing weekly limits with a monthly view

A weekly budget answers "am I okay this week?" It's less suited to "am I on track for the year?" For that, you still want a monthly roll-up: the template totals your weekly buckets into a monthly figure automatically, so you get both horizons in one sheet.

A common, durable setup looks like this:

• Monthly section — rent, insurance, car payment, subscriptions, savings transfers.
• Weekly section — groceries, gas, dining, fun money, with a limit per week.
• Roll-up — the monthly total of every weekly bucket, so nothing slips through the cracks.

If you find you only ever look at the monthly total, you've probably outgrown weekly tracking — switch to the Monthly Budget template. If you keep blowing the weekly limits, they're set too low; adjust them rather than abandoning the system.

Keeping the weekly budget current (the part that matters)

Here's the uncomfortable truth about a weekly budget specifically: it asks more of you than a monthly one. More weeks means more check-ins, and more check-ins means more chances to fall behind. A weekly budget you stop updating is worse than a monthly one, because the whole value was the fast feedback.

That's the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports every transaction automatically and drops it into the correct week.
• Categorizes each one with AI, learning your corrections over time.
• Keeps every week live, so your weekly limits-vs-actual are always accurate.

You go from "log a dozen purchases by Sunday" to "spend five minutes confirming categories." The weekly budget stays current, which is the only way a weekly cadence is sustainable past the first month.

Related templates and guides

• Weekly Budget template — the free Google Sheet this guide is built around.
• Weekly budget Q&A — quick answers to the most common weekly budgeting questions.
• Monthly Budget template — a month-by-month layout if you'd rather plan a whole month at once.
• Budget Spreadsheet template — the most customizable option, with full control over categories and formulas.
• Expense Tracker template — a dedicated spending log to pair with your weekly limits.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• How to use a monthly budget template — a practical guide to the monthly workflow.
• Browse all free templates — the full Avery library.

A weekly budget gives you tighter control; automation keeps it alive. Start with the free template, set your limits, and let Avery handle the data entry so you're still budgeting by the week in month six — not back to guessing.