Skip to content
Search/
CyberMax › Answers

How to make a chore chart that adds up each child's allowance

Updated 2026-11-17 · Planners and templates · by CyberMax

Short answer

Keep one log of chores done (date, child, chore, amount). A weekly chart and each child's balance can then be calculated from that log with SUMIFS, so nobody has to tick two places, and payouts reduce the balance.

  1. Make a chores list with an amount per chore.
  2. Log each chore done in one table.
  3. Sum each child's earnings per week with SUMIFS.
  4. Record payouts as negative rows so the balance stays right.

Copy-paste code

Google Sheets / Excel: one child's total for one week

=SUMIFS(Log!D:D, Log!B:B, "Maya", Log!A:A, ">="&B1, Log!A:A, "<"&B1+7)
Chorewren Family Chore Chart + Allowance Tracker icon

Chorewren Family Chore Chart + Allowance Tracker: Chores done, allowance sorted, no more arguing

from $7

Chorewren ($7) does this in Excel and Google Sheets: the weekly chart ticks itself, allowances add up and you always know what you owe.

Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)

Free: the Free Planner Sampler

4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.

You get one email to confirm first. Then the kit, and 5 short emails over two weeks. One-click unsubscribe in every email; we never share your address.