Spreadsheets

Baby expense budget sheet for the first year in Excel

A baby expense budget sheet for the first year in Excel: one-time buys, recurring items projected by units per week, a gift-received flag and a month grid.

Editorial illustration for Baby expense budget sheet for the first year in Excel

A first-year baby budget sheet has two blocks: one-time purchases like a cot or stroller, and recurring items like diapers, formula and check-ups that repeat every month. Put them in separate tabs, add a gift-received flag so you do not budget for things relatives already bought, and a 12-month grid then shows when the money is needed.

How do I set up the one-time block?

Use a tab named One-time with a row for each purchase.

ColumnHeadingNotes
AItemCot, stroller, car seat, bottles
BMonth needed1 to 12 (month 0 for before the birth)
CEstimate (₹)What you expect to pay
DActual (₹)Fill after buying
EGift received?Yes or No
FCost to you=IF(E2="Yes",0,IF(D2="",C2,D2))

The formula in F uses the actual price if you have entered one, the estimate if not, and zero when someone has gifted the item. Total one-time cost is =SUM($F$2:$F$60). Say a cot is estimated at ₹9,000 and bought for ₹8,500, and a stroller of ₹7,000 is a gift from the grandparents. Together they cost you ₹8,500, not ₹16,000.

How do I project recurring items by units per week?

Recurring items change with how much the baby uses, so project them with a rate. On a tab named Recurring:

ColumnHeadingNotes
AItemDiapers, formula, wipes, medicines
BUnits per weekHow many you expect to use
CPrice per unit (₹)From your last purchase
DMonthly cost=B2*C2*52/12
EStart monthFirst month you need it
FEnd monthLast month you need it

The 52/12 converts a weekly figure into an average month. Say you use 35 diapers a week at ₹12 each: 35 x 12 = ₹420 a week, and 420 x 52 / 12 = ₹1,820 a month. These are invented inputs; use your own after the first fortnight, when you know actual use.

How do I build the 12-month grid?

On a Summary tab, put months 1 to 12 across B1:M1. For recurring cost in month 1:

  • =SUMPRODUCT((Recurring!$E$2:$E$30<=B$1)*(Recurring!$F$2:$F$30>=B$1)*Recurring!$D$2:$D$30)

This adds the monthly cost of every item active in that month. For one-time purchases in the same month: =SUMIFS('One-time'!$F$2:$F$60, 'One-time'!$B$2:$B$60, B$1). Add the two rows for a monthly total and sum across for the year. Items like solid food that start later simply have a later start month.

What about check-ups and vaccines?

Ask your paediatrician for the visit and vaccine schedule, and enter each visit as a one-time row with the month it falls in. Do not guess costs from the internet; clinic fees and the choice between available vaccines vary, so use the quote you were actually given. If a hospital package covers some visits, say so in a notes column.

How should I use the gift flag well?

  • Before the baby arrives, mark items as Yes only when someone has confirmed the gift, not when they might.
  • Keep a note of who gave what, to write thank-you messages.
  • Review the sheet each quarter and drop items you never needed.
  • Move unused estimate rows to a second-hand list if you plan to buy pre-loved.

Where can an app fit in?

Most baby spending is by card or UPI. SpendixAI can import your statement, let you add a baby category, and keep a photo of the receipt with the transaction, which is handy for warranties on a stroller or a car seat. The sheet remains the plan; the app shows what actually happened.

Quick start

  1. List the one-time items and mark gifts
  2. Fill recurring items with a units-per-week guess
  3. Set start and end months
  4. Review actual use after a month and change the guesses
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports