Household Budget Template for Google Sheets (Free, 2026)

A household budget is harder than a personal one for a simple reason: it has more moving parts. Two paychecks instead of one. Joint bills and personal spending. Kids' costs that show up in a dozen places. And two people who both need to see the same numbers to make decisions together. Most budget templates quietly assume one person, one income, one set of categories — which is why they fall apart the first time a couple tries to share them. This guide fixes that with a free Google Sheets household budget template built for real families, plus a way to keep it current without either partner doing daily data entry.

What makes a household budget different

A personal budget answers one question: where did my money go? A household budget answers a harder one: where did our money go, who's responsible for what, and are we still on the same page? That means three things a solo template doesn't have:

1. Multiple incomes. Two (or more) earners, often paid on different schedules, sometimes with variable or side income on top.
2. Shared and personal spending. Joint bills both partners fund, plus a personal line each person controls without justifying every purchase.
3. Family costs. Childcare, school, activities, kids' clothing, and family healthcare — expenses that don't exist in a single-person budget and tend to be larger than couples expect.

Get those three right and the budget stops being a source of friction and starts being the thing that keeps two people aligned.

Why Google Sheets is the right home for a household budget

For a household specifically, Google Sheets has one feature that beats almost every budgeting app: both partners can edit the same file at the same time.

• Real-time shared editing. One source of truth, not two phones running two apps that never agree.
• Free and cloud-based. No per-seat license, and it auto-saves so neither of you loses work.
• Works on every device. Check it on a laptop at home or update it from the Sheets app at the store.
• Automatable. It connects to Avery, which imports and categorizes transactions from every household account, so the budget stays current without either partner typing.

Most apps charge per user or force a "primary" account holder and a passenger. A shared Google Sheet treats both partners as equals — which is usually the whole point of budgeting together.

How to set up your household budget in Google Sheets (step by step)

You can build one from scratch, but starting from the template means the formulas already work and the shared and personal groups are already structured. Here's the full process.

Step 1: Copy it and share it with your partner

Copy the template to your Drive, then share it with edit access. Do this first. A household budget that only one person can open is just a personal budget with extra steps — the shared access is the feature. Both of you should be able to add income, log spending, and see the dashboard.

Step 2: Add every income source

List each earner's take-home (after-tax) pay on its own row, then add any side or variable income below. The template combines them into one household income figure automatically.

If either income changes month to month, budget against your lowest recent combined month. Build the plan on income you can both count on, and treat anything above that as a bonus for savings or debt — not as money to spend.

Step 3: Split categories into shared and personal

This is the step that makes a household budget work. Group your categories into two:

Shared household costs — funded jointly:

• Rent or mortgage
• Utilities (power, water, internet)
• Groceries
• Transport (gas, transit, car payments)
• Insurance
• Childcare and school
• Kids' activities and clothing
• Family healthcare
• Joint savings and debt payments

Personal spending — one line each partner controls:

• Partner A personal money
• Partner B personal money

The shared group is where you make decisions together. The personal lines exist so neither person has to explain every coffee or hobby purchase — they get a fixed amount and spend it however they like. That single design choice prevents most money arguments couples have.

Step 4: Track your spending

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

1. Manual entry — each partner logs expenses as they happen. Most accurate, most effort, and the hardest to keep up when two people share several accounts.
2. Weekly catch-up — sit down together once a week and enter everything from your statements.
3. Automatic sync — connect Avery and transactions from every household account import and categorize themselves.

For a household, option 3 is the difference between a budget that survives and one that doesn't. Coordinating manual entry across two people and multiple accounts is exactly the kind of chore that breaks down — and it breaks down fastest in a busy month, which is when you most need the budget.

Step 5: Review the dashboard together each week

A household budget only works if you both look at it. Put a recurring 15–20 minutes on the calendar — a weekend morning works well — to compare budget vs. actual together. Over on groceries? Decide as a pair where to pull it from. The point is a shared, factual conversation, not one partner policing the other.

Budgeting as a couple: combining incomes without combining everything

The hardest part of a household budget usually isn't the spreadsheet — it's agreeing on how two financial lives fit together. The template is deliberately neutral on this so you can pick the arrangement that fits your relationship.

One joint account, fully merged

Both incomes land in one account, all spending comes out of it, and personal lines are just guardrails. Simplest to track, and the template's combined income total maps directly onto it.

Yours, mine, and ours

Each partner keeps a personal account and contributes to a shared joint account for household bills. The template's shared group covers the joint account; each personal line covers an individual account. This is the most common setup for couples who want togetherness without losing autonomy.

Proportional contributions

If one partner earns more, you might split shared costs by income share rather than 50/50 — say 60/40 if that's how your paychecks compare. Set each earner's income in the template, and fund the shared categories in the same proportion. The dashboard still shows one combined household picture.

There's no correct answer — the best arrangement is the one you both agree to and will actually maintain. What matters is that the budget reflects it accurately, so neither person is guessing about who paid for what.

Splitting shared vs. personal expenses fairly

"Fair" is the word that derails more household budgets than any spreadsheet error. Two people earning different amounts almost never agree that a straight 50/50 split feels fair, and forcing it usually breeds quiet resentment. The template stays neutral so you can encode whatever split you actually believe in — but it helps to see the three common approaches with real numbers.

Say the household brings in $8,000 a month after tax: Partner A earns $5,000 and Partner B earns $3,000. Shared household costs come to $4,800.

• Equal-dollar split. Each partner puts in $2,400. Simple, but Partner B is contributing 80% of their take-home to shared costs while Partner A contributes 48% — the same dollar amount feels very different on each paycheck.
• Proportional split. Each partner funds shared costs in line with income share — 62.5% / 37.5%. Partner A puts in $3,000, Partner B puts in $1,800. After shared costs, each is left with the same proportion of their own income for personal spending and savings, which most couples experience as fairer.
• Full pooling. Both incomes land in one account, shared costs come out, and what's left is divided into equal personal lines regardless of who earned it. This treats the household as a single economic unit and is common once people are married or have kids.

In the template, set each earner's income on its own row and fund the shared categories in whatever proportion you've agreed. The dashboard always rolls everything up into one combined household picture, so the split is a decision you make once — not a calculation you redo every month. Write the agreed percentages into a note cell next to the income rows so neither partner has to remember the deal six months from now.

A sample family budget walkthrough

It's easier to trust a structure once you've seen it filled in. Here's a worked example for a two-income family with one child in part-time daycare. All figures are monthly and in USD.

Combined income

• Partner A take-home — $5,000
• Partner B take-home — $3,000
• Total household income — $8,000

Shared household costs

Personal and goals

Income of $8,000 minus $6,500 shared minus $1,500 personal and goals leaves $0 to allocate — a zero-based plan where every dollar already has a job. Notice how much daycare moves the picture: at $900 it's the third-largest line in the whole budget, larger than groceries. That's the single most common surprise for new families, and it's exactly the kind of number that's invisible in a single-person template.

When the real month plays out, you fill the actual column beside each line. If groceries land at $940 against an $850 plan, the dashboard flags it, and you decide together where the extra $90 comes from — trim next month's dining, or pull it from the personal lines. The plan above isn't a prescription; it's a shape. Drop in your own rent, your own daycare bill, and your own paychecks, and the template does the same math.

Budgeting with kids: family-specific categories

Kids don't just add one "childcare" line — they thread cost through the whole budget, and the costs move as children grow. A household budget that doesn't name these categories tends to absorb them silently into groceries and "miscellaneous," which is how families end up $300 short every month with no idea where it went. Add explicit lines for the ones that apply to you:

• Childcare or daycare. Usually the biggest family expense after housing while kids are young, and the one most worth its own row so you see it clearly.
• School costs. Fees, supplies, uniforms, field trips, lunch money, and the after-school care that fills the gap between the school bell and the end of the workday.
• Activities and sports. Registration, equipment, lessons, and recitals — lumpy spending that spikes at the start of each season rather than spreading evenly.
• Kids' clothing. Children outgrow clothes on a schedule that ignores your budget; a small monthly line smooths out the back-to-school and growth-spurt jumps.
• Healthcare and copays. Pediatric visits, dental, prescriptions, and the inevitable urgent-care trip — predictable in aggregate even when any single month is a surprise.
• Birthdays, gifts, and family outings. The "fun" category that quietly compounds across parties, holidays, and weekend trips.

A practical trick for the lumpy ones — activities, school fees, holidays — is to budget them as a monthly average rather than waiting for the bill. If sports cost roughly $1,200 across the year, set aside $100 a month into a sinking-fund line so the registration month doesn't blow up the whole budget. The template treats that line like any other category, and Avery will route the real charges to it automatically once you've categorized a few, so the sinking fund stays honest without manual tracking.

The monthly money meeting

Every couple has money disagreements. The ones who stay aligned aren't the ones who never disagree — they're the ones who have a regular, low-stakes place to disagree before it becomes a fight. A short recurring money meeting is that place, and a shared Google Sheet is what makes it possible, because both partners are looking at the same numbers instead of two competing memories.

Keep it short and structured so it doesn't turn into a tribunal:

1. Look back (5 minutes). Open the dashboard together and read budget vs. actual by category. Name the overages factually — "groceries ran $90 over" — without assigning blame. The sheet is the referee, not either partner.
2. Look ahead (5 minutes). Scan the next few weeks for anything unusual — a birthday, a car service, an annual insurance bill — and make sure there's room for it before it arrives.
3. Decide one thing (5 minutes). Make exactly one adjustment: move a category, raise the personal lines, redirect a windfall to debt. One decision per meeting is sustainable; a full overhaul every month is not.

Fifteen to twenty minutes, once a month, on a recurring calendar invite. Pair it with something pleasant — coffee on a weekend morning — so it reads as a date, not a chore. The goal isn't a perfect budget; it's two people who never get blindsided by the numbers, because they looked at the same screen together. When Avery is doing the data entry, the meeting can be purely about decisions — you're not spending the first ten minutes arguing about whether the transactions are even entered correctly.

Household budget template vs. a budgeting app

Couples leave apps like Mint, YNAB, and Copilot for reasons that hit households especially hard:

The historical trade-off was sync: apps imported transactions automatically, spreadsheets didn't. Avery closes that gap — you get app-style automatic bank sync, across every household account, inside a sheet you both own. If you're comparing tools, see Avery vs Mint and Avery vs Tiller.

Keeping a household budget current (the part that actually matters)

Here's the uncomfortable truth about every household budget: it dies the moment the data stops coming in — and in a household, that happens faster than anywhere else. There are more accounts, more transactions, and two people who each assume the other is keeping up with entry. February is where most family budgets quietly go to rest.

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

• Imports every transaction from every household account automatically into the budget.
• Categorizes each one into your shared or personal groups with AI, learning your corrections.
• Keeps the dashboard live, so budget-vs-actual is always accurate for both partners.

You go from "did you log the grocery run?" to "spend five minutes confirming categories together." The budget stays current, which means it's still working for your household in month six — not gathering dust while two people go back to guessing.

Related templates and guides

• Household Budget template — the free Google Sheet this guide is built around.
• Household budget Q&A — quick answers to the most common couples and family budgeting questions.
• Monthly Budget template — a fixed month-by-month layout if you prefer that view.
• Budget Spreadsheet template — a flexible do-it-yourself budget you can fully customize.
• Expense Tracker template — a dedicated spending log to pair with your household budget.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• How to use a monthly budget template — habits that keep any budget alive.
• Browse all free templates — the full Avery library.

A household budget gives a family a shared plan; automation keeps that plan honest. Start with the free template, set it up together, and let Avery handle the data entry across every account — so the budget is still keeping you both on the same page long after the new-year motivation wears off.