Who paid for the last box of diapers? If you have to think about it, that's the gap a good baby budget spreadsheet is meant to close. It shouldn't just total purchases. For couples or family members splitting costs, it has to show who paid, what counts as shared, and what still needs repaying. Otherwise small buys turn into fuzzy conversations two months down the road. A stroller is a one-time hit. Diapers, child care, and pharmacy bills keep coming back. Start with a blank workbook or a free layout, then put the split rules in plain sight. The target is a record either of you can read in two minutes.
Agree on the shared-cost rule first
Decide what counts as a shared baby expense before anyone types in a price. Mundane, sure. It also prevents the backtrack that happens after somebody has already paid for something solo. Fair doesn't always mean half, either. A 50/50 split is the easiest rule to run, but a different one may fit your household better.
| Rule | Works better when | What to enter in the spreadsheet |
|---|---|---|
| Equal split | Both adults want to share most baby costs evenly | Enter 50% for Partner A's share on shared rows |
| Income-based split | You both voluntarily use an agreed income ratio | Enter the agreed percentage, such as 60% and 40% |
| Usage-based split | A cost follows a documented arrangement, such as scheduled child care days | Note the basis for the split beside the expense |
| Personal or gift item | One adult takes responsibility for an item, or a third party gives it | Set the payer's share to 100%, or log a $0 inventory item for a gift |
Thing is, the running total is only half the problem. A written rule tells you whether a purchase actually changes what somebody owes.
Put your method in a note at the top of the sheet where it can't be missed. Exceptions happen. When one does, give that row its own percentage and write a line about why. Date any major rule change too, so older expenses don't get quietly recalculated under new terms.
Build a free baby budget spreadsheet
You don't need anything fancy here. A basic workbook in Google Sheets or Excel handles it fine. Make three tabs and name them Expenses, Settlement, and Summary. For a two-person household, the Expenses tab wants these columns:
| Date | Item | Category | Timing | Planned | Actual | Paid by | Partner A share | Partner A fair share | Partner B fair share | Variance | Receipt or note |
|---|---|---|---|---|---|---|---|---|---|---|---|
Timing gets marked One-time or Recurring. Type the estimate into Planned. Actual stays empty until money has actually left somebody's account.
In row 2, use these formulas:
- Partner A fair share:
=IF(F2="","",F2*H2) - Partner B fair share:
=IF(F2="","",F2-I2) - Variance:
=IF(OR(E2="",F2=""),"",F2-E2)
An equal split means 50% goes in the Partner A share column. If Partner A covers 60% of a shared purchase, enter 60% and the Partner B formula figures out the rest. If you already know your household will argue about whether a wipes subscription counts as shared, that argument is exactly what the receipt or note column is for, so settle it in writing while you're both calm.
The Settlement tab shows whether either person has paid more than their agreed share. Swap "Partner A" in the formulas for whatever name you actually use in the Paid by column.
| Cell | What it shows | Formula |
|---|---|---|
| B2 | Total actually paid by Partner A | =SUMIF(Expenses!G2:G500,"Partner A",Expenses!F2:F500) |
| B3 | Partner A's agreed share | =SUM(Expenses!I2:I500) |
| B4 | Partner A's net position | =B2-B3 |
A positive number in B4 means Partner A has paid more than their share. A negative one means they still owe toward shared costs.
Summary is where total actual spending and category totals live. This formula adds up everything actually spent on diapering:
=SUMIF(Expenses!C2:C500,"Diapering",Expenses!F2:F500)
If more than two people contribute, give each one a separate fair-share column. Grandparents, relatives, and gift-givers don't belong inside a two-person settlement calculation.
Use categories that make decisions easier
Start broad. Forty categories means you'll quit updating the sheet by week three.
Gear and sleep. Car seat, stroller, bassinet or crib, monitor, nursery furniture. Mostly one-time purchases, so keep them away from the monthly stuff.
Diapering and feeding. Diapers, wipes, formula if you use it, bottles, replacement parts, baby food once that stage starts. This is where you'll spot a recurring cost creeping up.
Health and recovery. Log real out-of-pocket costs: checkups, prescriptions, vitamins, recovery items. Tag each one as the baby's, a parent's, or the household's.
Child care. Deposits, recurring charges, and missed or adjusted payments stay out of the general supplies category. Due dates matter here, and burying them under wipes is how they get missed.
Clothing and household supplies. Clothes, laundry supplies, skin care, the steady drip of small purchases. Keep an inventory note for gifts and hand-me-downs so you don't buy doubles.
One caution: an expected insurance payment, gift, or assistance award is not money you have. It lives in the notes until the amount is confirmed.
Review the first-year plan in short cycles
A single annual estimate hides when money actually leaves. A yearly total says nothing about which week the child care deposit lands, so build the first version in stages:
- Before birth, list gear, initial supplies, and any child care deposits you already know about.
- At the beginning of each month, add recurring needs and upcoming bills.
- During the month, enter the actual amount, payer, and receipt note for shared purchases.
- Near month-end, compare actual spending with the plan and update the next month.
- Settle the net amount only after both people have checked the entries.
Leave an unknown price as TBD rather than entering zero. Zero reads as "no cash needed," and that's exactly how a bill sneaks up on you.
To be