Every parent knows kids are expensive, but few know exactly where the money goes. The monthly after-school program is easy to remember; the school supplies, shoes, pharmacy runs and birthday presents disappear into the general budget. Here's a light way to see child-related spending on its own.
1. Add two columns to your budget
There's no need for a separate file. Add two columns to the spending sheet you already keep:
- Child: the child's name, or Shared
- Kid category: one of the names below
| Kid category | Examples |
|---|---|
| School | Tuition, field trips, supplies, lunches |
| Activities | Sports fees, lessons, camps |
| Medical | Doctor, dentist, pharmacy, glasses |
| Clothing | Clothes, shoes, uniforms |
| Childcare | Daycare, babysitters, after-school care |
| Fun | Toys, books, outings, birthday parties |
| Allowance | Regular pocket money |
Don't try to split whole-family costs like groceries or rent between children. Leave the Child column blank for those, or the habit won't last.
2. Collect the receipts
Photograph child-related receipts into your receipts album as you get them. Once a month, add them to the receipt tool to get dates, stores and totals, then fill in Child and Kid category while looking at the store names. The same school or clinic shows up every month, so it goes quickly.
Costs paid by bank transfer, such as tuition or a babysitter, have no receipt, so add them with "Add row" from your bank records.
3. Totals by child and category
On a Summary sheet, lay out children down the side and categories across the top, then fill it with SUMIFS. Assume amounts are in column D, Child in column G and Kid category in column H of the Spending sheet:
=SUMIFS(Spending!D:D, Spending!G:G, $A2, Spending!H:H, B$1)
| Child | School | Activities | Medical | Clothing | Total |
|---|---|---|---|---|---|
| Maya | 420.00 | 150.00 | 38.50 | 72.00 | 680.50 |
| Leo | 180.00 | 90.00 | 64.20 | 31.00 | 365.20 |
A PivotTable with Child in Rows, Kid category in Columns and amount in Values gives the same table. After a year or two, you'll see how spending shifts as each child grows.
4. Flag receipts you may need later
Some child-related costs can matter beyond your budget. Depending on where you live, childcare, education and medical costs may affect taxes, and employer benefit accounts for dependent care or health expenses typically need itemized receipts to reimburse you. Add a Tax / claim note column and mark those rows as you go. See Receipts worth keeping all year for tax season for a checklist, and confirm the rules that apply to you.
5. If two people share the costs
When parents alternate paying, or parents living apart share child costs, add a Paid by column. Totals by person keep the conversation about numbers rather than feelings, and a shared folder of receipt photos means both of you can check the details.
Summary
Tracking what kids cost takes two extra columns in your existing budget, a monthly batch of receipt photos turned into rows, and a note on anything you might need to claim. After a year you'll have a clear number instead of a vague feeling.