Family expense tracker template for a month

Updated October 6, 2026 5 min read By The EvenOut team

Quick answer

A family expense tracker template groups the month's costs as fixed, variable and irregular, with a paid-by column for each family member so every row can be checked. Irregular costs such as school fees and insurance get a yearly total divided by 12. In the example, a household of four has $3,917 of costs plus $425 set aside for yearly bills.

Key points

Group costs as fixed (same every month), variable (changes monthly) and irregular (once or twice a year).
A paid-by column for each parent lets you check every row: the paid-by amounts must add up to the month total.
Irregular costs are divided by 12. In the example, $5,100 of yearly bills becomes $425 set aside each month.
At the end of June, six months at $425 is $2,550 against $2,480 paid so far, which leaves $70 in the pot.
The sheet tracks who paid. It does not work out who owes whom between people.

On this page

How to use this template
The template
What to agree on
Frequently asked questions

How to use this template

Fill in one monthly grid, check that the paid-by columns add up, then update the yearly table so irregular costs are covered before they arrive. The tables copy into Excel or Google Sheets, or print as they are. Work in this order.

Sort every cost into a group. Fixed costs are the same every month. Variable costs change. Irregular costs come once or twice a year, such as school fees, insurance and car service.
Fill in the month total and who paid. Each row has a Month total and a Paid by column for each parent. For every row, the two Paid by columns must add up to the Month total.
Set aside for the irregular costs. Take last year’s yearly bills, add them up, and divide by 12. That monthly figure goes into the set-aside row of the grid.
Add up the columns at the end of the month. The Month total column equals the two Paid by columns added together.
Check the yearly table. Compare what has been set aside so far with what has been paid.

The example is a hypothetical household of four, two adults (Dana and Chris) and two children, in June.

The template

One month, grouped by cost type

The sample month totals $4,342, of which $3,917 is spending and $425 is the set-aside. Dana paid $2,972 and Chris paid $1,370. Most row labels are EvenOut’s built-in category names, with what goes in each in brackets.

Category	Month total	Dana paid	Chris paid
Fixed costs
Home (rent)	$1,650	$1,650	$0
Internet	$70	$0	$70
Phone	$140	$0	$140
Subscriptions	$42	$42	$0
Education (after-school care)	$320	$320	$0
Total fixed	$2,222	$2,012	$210
Variable costs
Groceries	$880	$410	$470
Utilities	$265	$0	$265
Transport	$185	$85	$100
Kids (clothes, activities)	$160	$100	$60
Health	$85	$85	$0
Food (eating out)	$120	$55	$65
Total variable	$1,695	$735	$960
Irregular costs
Set aside for yearly costs	$425	$225	$200
Month total	$4,342	$2,972	$1,370

Irregular costs, year to date

Each yearly amount divided by 12 gives the monthly set-aside. The $5,100 yearly total divided by 12 is $425, and the Paid so far column tracks what has already left the account.

Cost	Yearly amount	Paid so far	Per month (yearly divided by 12)
Education (school fees, supplies)	$2,160	$1,080	$180
Insurance (car and renters, yearly premiums)	$1,200	$600	$100
Transport (car service, registration)	$660	$330	$55
Health (dental, glasses)	$480	$120	$40
Kids (camp, birthday party)	$600	$350	$50
Total	$5,100	$2,480	$425

At the end of June, six months of set-aside is 6 times $425, or $2,550. Paid so far is $2,480, so $70 should still be in the pot. The $2,620 still to come ($5,100 minus $2,480) is covered by the next six months of set-aside plus the $70 already there: 6 times $425 is $2,550, and $2,550 plus $70 is $2,620.

What to agree on

Which costs go where

The three groups only work if the family uses the same rule each month. A cost that repeats at the same amount is fixed, and anything that comes once or twice a year goes in the irregular table, even if it feels like a surprise when it arrives. Write the rule at the top of the sheet. Rent lives in Home, and school fees sit under Education.

Who updates the sheet

Pick one person to update it each week, and have everyone else send receipts or screenshots to that person. Two people editing the same rows is how a Paid by column ends up not adding up.

Matching the sheet to EvenOut

The row labels use EvenOut’s category names (Home, Utilities, Groceries, Kids, Education, Health, Insurance, Transport). A Household group in EvenOut uses the same categories, and its “Spending” charts show any month by category, so a month’s chart and this sheet can be compared category by category. Fixed bills such as rent can be set to “Repeat” monthly. The sheet tracks who paid, and nothing more.

Where to go next

For splitting shared costs between two adults, see how to split bills as a couple and the couple budget template. If you only want the bill lines across twelve months, the household bills spreadsheet is built for that, and the best family expense tracker apps compares what each app does.

Frequently asked questions

Where does a yearly bill go in the month I pay it?

Record it in the Paid so far column of the irregular table and leave it out of that month's variable total. The monthly set-aside already carries it, so counting the payment in both places would count it twice.

Can a teenager have their own paid-by column?

Yes. Add a column with their name next to the two parent columns and fill it when they pay for something, such as a phone plan or a gym fee. Keep the check the same: every row's paid-by amounts must still add up to its month total.

Does this sheet work out who owes whom?

No. It records who paid, which is useful for seeing the month, but it does not split costs between people. If two adults pay unequally and want to even it out, add the same costs to a Household group in EvenOut, where the Balances block shows your balance with each person.

What if a bill changes a little each month, like a phone plan?

Put it in whichever group you want to compare month to month. A phone plan with a stable price works as fixed, and any extra charge can go on its own row in the variable table. Pick one rule and keep it, so the months stay comparable.