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.
| Column | Heading | Notes |
|---|---|---|
| A | Item | Cot, stroller, car seat, bottles |
| B | Month needed | 1 to 12 (month 0 for before the birth) |
| C | Estimate (₹) | What you expect to pay |
| D | Actual (₹) | Fill after buying |
| E | Gift received? | Yes or No |
| F | Cost 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:
| Column | Heading | Notes |
|---|---|---|
| A | Item | Diapers, formula, wipes, medicines |
| B | Units per week | How many you expect to use |
| C | Price per unit (₹) | From your last purchase |
| D | Monthly cost | =B2*C2*52/12 |
| E | Start month | First month you need it |
| F | End month | Last 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
- List the one-time items and mark gifts
- Fill recurring items with a units-per-week guess
- Set start and end months
- Review actual use after a month and change the guesses
Useful ideas start with a clearer picture of your own spending.
Explore your reports


