BEFORE YOU CREATE A WORKSPACE

Prepare a safe first comparison.

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

Reconcile one family balance in your spreadsheet.

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.

1

Download the matching fictional files

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.

Attendance

Family ID, lesson date, status; lesson charge, initiator and notice evidence where relevant.

Download Attendance CSV
Fictional example totals · USD · 1–30 Sep 2026

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.

2

Check how your headings map

Try a fictional set or paste one header row at a time. Choose the same columns you would map in the workspace.

Try a fictional example:
Enter headings separated by commas, as in a CSV first row. Do not paste records or sample family rows.

No records: enter headings only—never family names, student/family identifiers, contact details, amounts, or data rows.

Map headings to importer fields

Heading check · Attendance

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 workspace
3

Know which fields to keep

Use 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.

Attendance · required

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.

Keep when present in your records

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.

Payments · required

Keep the template headings family_code, payment_date, and amount. Map family_code to the same Stable family ID used in your other files.

Optional

reference is optional. Remove free-text references that identify a person; leave blank or replace with a neutral code that carries no personal detail.

Opening balances · required

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.

Dates must align

The as_of date must equal the period start. Resolve records between dates before preparing the opening balance.

Before calculation, be ready to confirm

  • Exact reconciliation period start and end dates, and one school currency.
  • Your confirmed lesson charge per row or school lesson rate (with no more than two decimal places).
  • The cancellation rule: policy type, eligible cancellation initiators, and required timing evidence.
  • When the rule uses notice hours, the notice threshold and row-level hours; when it uses timestamps, both cancellation time and lesson date and time.

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.

4

Prepare fully anonymized copies

Use this checklist as a reminder while working in your own files.

0 of 6 reminders checked

These checks only help you prepare. They do not inspect your files, retain progress after you leave, or guarantee that a copy is anonymous.

This page does not accept uploads. Checklist selections stay on the page and are not sent to Tufton or saved after you leave. Inspect every sheet, hidden column, note, and unusual identifier yourself before creating a workspace. Use only fully anonymized copies; real personal-data uploads are not enabled.

Ready to compare?

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 workspace

Prefer the worked example?

Return to the fictional source-linked balance and follow an adjustment before starting.

Back to the worked sample