Skip to content
Kids Allowance and Savings cover: a sample sheet with earned so far, spent and moved to savings and a column chart, beside the Dashboard and Children tabs

Kids Allowance and Savings

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Parents who give a regular allowance and chore pay can use this sheet to show children where their money goes. The Children tab holds one row per child with a weekly allowance and a savings goal, and it totals what each child has earned, spent and moved into savings. The Ledger tab records each payment or purchase on its own row. The Dashboard shows the totals, a column chart for each child and the average progress toward goals.

Hand out the allowance every Saturday, say, and log it straight away, so the wallet figure stays right. Record the savings move on the day the money goes into a jar or bank account, and treat Wallet now as cash in hand. Talk through goal progress with each child, since a visible target keeps saving interesting. Add a new child to both name lists before logging anything for them.

Useful for

  • Give a weekly allowance and log each payment
  • Save toward a bike, a game console or an art set
  • Check each child's balance before a shopping trip

What's included

  • 4 tabs: Dashboard, Children, Ledger, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Children: a table
  • Ledger: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Children tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What does Wallet now mean?

Wallet now is the earnings minus what was spent and what went into savings. It is the cash a child should have in hand. If it shows a negative number, a payment is missing from the Ledger or a purchase was logged twice.

Can I track chores separately?

Yes. Log each chore on the Ledger with its pay in the Earned column and the chore name in the item column. The Children tab adds it into the earned total automatically, so chore pay shows up in the child's wallet and goal progress.

How do I add a child?

Type the name on a new row of the Children tab, then type the same name into the Child list on the Ledger tab. Give the new child a place in the Dashboard breakdown too, so the chart shows them.

  • #savings-tracker
  • #kids-savings-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…