Follow a credit to its source.
A fictional family balance with each movement linked to its source row and applied rule.
Review adjustmentsSample closing balance · 31 Oct 2026
USD 20.00
Credit remainingAvailable against future charges in the sample school’s records.
See balance movements →Select a balance movement. Then open its source and rule.
1–31 Oct 2026 · Fictional records only
Selected: Cancellation credit. Reduces amount owed: USD 40.00. School canceled the 21 Oct lesson; the sample rule credits its full charge.
| Balance movement | Amount |
|---|---|
| Amount owed | USD 20.00 |
| Reduces amount owed | USD 160.00 |
| Adds to amount owed | USD 160.00 |
| Reduces amount owed | USD 40.00 |
| Closing balance Credit remaining | USD 20.00 |
Amount owed before payments and credits: opening amount owed USD 20.00 + lesson charges USD 160.00 = USD 180.00.
Payments and credits available: opening credit remaining USD 0.00 + payments USD 160.00 + cancellation money credit USD 40.00 = USD 200.00.
Credit remaining: USD 200.00 payments and credits − USD 180.00 owed before payments and credits = USD 20.00 credit remaining.
Cancellation credit
USD 40.00
21 Oct 2026
The school canceled one USD 40.00 lesson. The sample rule credits its full charge.
Inspect the source and rule, then mark this sample reviewed.
OPTIONAL · NO ACCOUNT NEEDED
Try a different fictional balance.
Change the opening amount owed or credit remaining and payments, then see an explained calculation using those inputs. This is separate from the source-linked worked sample above.
Optional · separate fictional calculation
Change the calculation inputs
This optional calculation starts separately from the source-linked worked ledger above. Change the opening amount owed or credit remaining, payments, lesson, and cancellation rule to see another explained result—all without an account. The fixed evidence and CSV/PDF files below remain the original worked sample. Edits stay in this tab until you deliberately create a share link or choose the separate practice handoff.
Why: The school canceled the lesson. This selected rule grants eligible school-initiated cancellations a full tuition credit; the canceled lesson remains among the 4 scheduled lesson charges. A notice threshold does not apply.
Traceable fictional ledger · 2026-10-01–2026-10-31
Amount owed before payments and credits: opening amount owed USD 20.00 + lesson charges USD 160.00 = USD 180.00.
Payments and credits available: opening credit remaining USD 0.00 + payments USD 160.00 + cancellation money credit USD 40.00 = USD 200.00.
Credit remaining: USD 200.00 payments and credits − USD 180.00 owed before payments and credits = USD 20.00 credit remaining.
Opening credit and cancellation credit are separate ledger entries; a makeup lesson is not money.
Illustrative calculation only—not approval of school records, a policy recommendation, or a family statement.
Browser-only downloads; entries are not sent anywhere. These illustrative files are separate from the fixed sample downloads and are not approved family statements.
FIXED FICTIONAL FILES · NOT SENT TO FAMILIES
Download the original worked sample files.
These files always show the fixed sample balance: USD 20.00 credit remaining, including the USD 40.00 cancellation credit. They do not change with the optional calculation above.
These files contain fictional records only. The PDF is a demonstration and has never been and will never be sent to a family.
FREE REUSABLE WORKSHEET · NO ACCOUNT
Reconcile one family balance in your spreadsheet.
Download a fictional worked tab and a reusable blank tab for one family and one period. Enter your currency, opening owed or credit, owner-confirmed charges and payments, and evidenced cancellation money credits.
Edit in your own spreadsheet app; your changes stay in your copy. The worksheet does not upload or send records or decide policy eligibility. Missing required inputs or unresolved credit evidence withhold the final result. Optional next steps: See Tufton’s explained sample · Compare fully anonymized records