Spreadsheets

Pocket money tracker sheet for kids in Google Sheets

A pocket money tracker for kids in Google Sheets: allowance and gifts in, save, spend and give jars with running balances, printable or fillable on a tablet.

Editorial illustration for Pocket money tracker sheet for kids in Google Sheets

A pocket money tracker for a child is a log with date, note and amount, plus three labelled jars: save, spend and give. Each time money comes in, it is split between the jars by percentages you set, and every expense comes out of one jar. The child sees balances at a glance and learns to choose before spending.

How is the sheet laid out?

Keep it as simple as a school notebook. A child should be able to read it without help.

ColumnHeadingExample
ADateSunday, 8 Nov
BWhat happenedWeekly allowance, birthday gift, sticker book
CJarSpend, Save or Give
DAmount (₹)Plus for money in, minus for money out

Put the split percentages in a corner, say F1 for Spend, F2 for Save, F3 for Give, such as 50%, 30% and 20%. These numbers are only an example; the family sets its own, and you can change them as the child grows.

How are balances worked out?

Add a small box on the right with the jar names in H2:H4. Then in I2:

  • =SUMIFS($D$2:$D$500, $C$2:$C$500, H2)
  • Total money across all jars: =SUM($D$2:$D$500)

Because money out is typed with a minus sign, the SUMIFS gives the current balance in each jar. In Google Sheets, add a drop-down to column C using Data, then Data validation, with the list Spend, Save, Give, so spelling never breaks the formula.

What does a week look like?

Say the weekly allowance is ₹200 and the split is 50, 30 and 20. The child enters three rows on Sunday.

DateWhat happenedJarAmount
SundayAllowanceSpend100
SundayAllowanceSave60
SundayAllowanceGive40
WednesdaySticker bookSpend-80

After this the Spend jar holds ₹20, Save holds ₹60 and Give holds ₹40, a total of ₹120. To avoid typing the split each week, put the allowance in one cell and let the three rows calculate: for Spend, =$H$6*F1, where H6 holds the weekly allowance. Then 200 x 50% = 100, 200 x 30% = 60 and 200 x 20% = 40.

How do I show a savings goal?

Pick one thing the child wants, say a cycle at ₹3,000, and put the goal in K1. Saved so far is the Save jar balance. Weeks to go is =ROUNDUP((K1-I3)/weekly saving, 0), where I3 is the Save balance and weekly saving is the Save part of the allowance. If ₹600 is saved and ₹60 goes in each week, the formula gives (3,000 - 600) / 60 = 40 weeks. A goal in weeks is much easier for a child to understand than one in rupees.

How do we make it printable or tablet-friendly?

  • For paper: set the print area to the log and the jar box, use large fonts and print a fresh page every month.
  • For a tablet: share the file with the child's account and use the Google Sheets app, with large rows and a frozen header.
  • Colour the three jar cells differently so the child connects colour with purpose.
  • Keep the sheet in a folder you can both open, and look at it together once a week.

What happens when the child starts using UPI?

Once a teenager has a payment account of their own, the log still works, but real balances come from real statements. For the family's own spending, SpendixAI can import a statement and keep the categories in one place; the jar idea is a teaching tool and sits alongside it.

Weekly routine

  1. Enter the allowance and gifts as soon as they arrive
  2. Record every spend with the jar it came from
  3. Read the three balances together
  4. Check how many weeks are left for the goal
SPENDIXAI JOURNAL

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

Explore your reports