Attendance
Family ID, lesson date, status; lesson charge, initiator and notice evidence where relevant.
BEFORE YOU CREATE A WORKSPACE
See what your files need, download a matching fictional set, and prepare fully anonymized copies offline. You do not need to sign in to use this guide.
FREE DOWNLOAD · NO ACCOUNT
Get a fictional worked tab and a reusable blank XLSX for one family and one period. Enter your currency, explicit opening owed or credit, owner-confirmed charges and payments, and evidenced cancellation money credits.
Open and edit the file in your own spreadsheet app; your edits stay in your copy. The worksheet does not upload or send records, and it does not decide cancellation-policy eligibility. Missing required inputs or unresolved credit evidence withhold the final result.
These three existing importer templates share the same fictional family IDs and September 2026 period. They are ready to use in the workspace as a worked import.
Family ID, lesson date, status; lesson charge, initiator and notice evidence where relevant.
Family ID, payment date and amount. Payment reference is optional.
Family ID, amount, owed or credit direction, and balance as-of date.
SAMPLE-ALDER: USD 0.00 owed; USD 42.00 credit remaining. SAMPLE-BIRCH: USD 18.50 owed. Lesson charges are USD 84.00 and USD 40.00 respectively; cancellation credits are USD 42.00 and USD 40.00. Payments are USD 84.00 and USD 40.00. The one makeup lesson is a count, not a money credit.
These expected balances come from the fictional templates and the sample rule described below. Confirm your own policy and records before relying on a result.
Try a fictional set or paste one header row at a time. Choose the same columns you would map in the workspace.
No records: enter headings only—never family names, student/family identifiers, contact details, amounts, or data rows.
Enter a header row or choose a fictional example to see the mapping.
This checks headings only. A match does not validate amounts, dates, anonymity, cancellation-policy evidence, or a reconciliation result. The check runs in this browser tab; headings are not uploaded, saved, included in a URL, or sent to analytics.
Next: prepare fully anonymized copies offline using the checklist below; keep family rows and identifying details out of this public check.
Prepare anonymized recordsCreate a workspaceUse the same arbitrary family ID in every file for a family. Choose codes unrelated to names or contact details, such as FAM-01, and keep spelling and punctuation identical.
Stable family ID, lesson date, and attendance status. The downloaded template headings are family_code, lesson_date, and status; map family_code to Stable family ID.
Lesson charge per row; cancellation initiator; notice hours or cancellation and lesson timestamps. In the template, cancellation_initiator maps to Cancellation initiator. The field used depends on your rule’s timing evidence.
Keep the template headings family_code, payment_date, and amount. Map family_code to the same Stable family ID used in your other files.
reference is optional. Remove free-text references that identify a person; leave blank or replace with a neutral code that carries no personal detail.
Keep family_code, opening_amount, opening_direction, and as_of. Map family_code to that same Stable family ID. Include an explicit zero where the confirmed balance is zero.
The as_of date must equal the period start. Resolve records between dates before preparing the opening balance.
The templates demonstrate a standard 100% credit rule, USD currency, a USD 42.00 lesson rate, 24 hours’ notice for family cancellations, and September 2026. Your school’s policy may differ; the example does not choose it for you.
Use this checklist as a reminder while working in your own files.
These checks only help you prepare. They do not inspect your files, retain progress after you leave, or guarantee that a copy is anonymous.
Create a school workspace when your files and policy evidence are prepared. You'll confirm dates, currency, rate, and cancellation rule before calculation.
Create a workspaceReturn to the fictional source-linked balance and follow an adjustment before starting.
Back to the worked sample