How to make a chore chart that adds up each child's allowance
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.
- Make a chores list with an amount per chore.
- Log each chore done in one table.
- Sum each child's earnings per week with SUMIFS.
- 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: Chores done, allowance sorted, no more arguing
from $7Chorewren ($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.