How to Reconcile Daycare Tuition Billing — A Step-by-Step Guide
A tuition reconciliation answers one question: does what you billed match what you should have billed, and does what you collected match what you billed?
Most childcare operators know their enrollment number and their bank balance. What happens between those two numbers — invoices, credits, adjustments, partial payments, and balances — is where financial clarity breaks down.
This guide walks through a five-step reconciliation process. It applies to center-based childcare operations and can be adapted for larger home daycares. It assumes you have a billing software export, but the logic works with a well-organized spreadsheet.
Quick answer
Tuition reconciliation works in five steps: (1) build expected tuition from enrollment × rate schedule, (2) compare to actual invoices generated, (3) document credits and adjustments, (4) match payments to invoices, (5) produce an aging balance by account. Each step surfaces different categories of discrepancy.
Why Reconciliation Matters
Without a reconciliation, it is easy to overcount revenue. If your billing software shows $80,000 in invoices issued but $15,000 in outstanding balances, your true collected revenue for that period is $65,000 — not $80,000. Decisions about hiring, rent, or expansion made on $80,000 are made on wrong information.
Reconciliations also surface patterns: the same accounts with partial payments every month, informal discounts applied inconsistently, subsidies that are supposed to reimburse but are late. These patterns are not always visible in day-to-day operations.
Step 1 — Build Expected Tuition
Start from your enrollment file, not your billing software.
List every enrolled family with:
- Their agreed tuition rate (from their enrollment agreement)
- Any documented discounts or adjustments (sibling discount, staff rate, scholarship)
- Their enrollment status for the period (full month, partial month, on leave)
Calculate: expected tuition = rate − documented adjustments.
Sum across all enrolled families. This is what you should have invoiced before any billing errors.
Common issues at this step:
- Rate schedules that were updated but enrollment agreements were not
- Informal verbal agreements not reflected anywhere in writing
- Families on "hold" counted as full enrollment
Step 2 — Compare to Actual Invoices
Export all invoices generated in your billing software for the period.
Compare invoice totals by family to expected tuition from Step 1.
| If invoiced = expected | Match — no action needed |
|---|---|
| If invoiced < expected | Investigate — possible billing error, missing invoice, or unapplied adjustment |
| If invoiced > expected | Investigate — possible duplicate invoice or rate error |
The total difference between expected and invoiced tuition is the first reconciling item. It should either be zero or explained by documented adjustments.
Step 3 — Document Credits and Adjustments
List every credit or discount applied during the period:
- Credit amount
- Account it applies to
- Reason in the system
- Whether that reason is documented in a signed agreement or policy
Credits reduce the effective amount owed. If a $500 credit is applied to an account without a documented basis, that is a finding — not necessarily an error, but something to confirm.
Watch for:
- "Scholarship" credits with no agreement on file
- Courtesy credits that have become permanent informal discounts
- Sibling discounts applied to families who only have one enrolled child (billing software error)
After accounting for credits, you have: net invoiced tuition = invoiced tuition − credits applied.
Step 4 — Match Payments to Invoices
Export payment records for the period. Match each payment to the invoice it was applied against.
Calculate: outstanding balance = net invoiced tuition − payments applied.
An outstanding balance is not automatically a problem — it depends on whether the payment is within terms. But the exercise surfaces:
- Accounts with consistent partial payments and no payment plan on file
- Payments applied to old invoices (leaving current invoices unpaid)
- ACH or auto-draft failures that generated no follow-up
- Subsidy or voucher reimbursements that are delayed or missing
Step 5 — Produce an Aging Balance
Sort outstanding balances by how long they have been outstanding:
| Age bucket | Description |
|---|---|
| 0–30 days | Recently invoiced — may be within payment terms |
| 31–60 days | Should be followed up if no payment plan exists |
| 61–90 days | Elevated concern — contact family and document status |
| 90+ days | High risk — review collection policy; may need formal process |
The 90+ day bucket is where most unrecoverable balances live. It is also where small, ignored balances compound into significant totals.
What a Clean Reconciliation Shows
After running these five steps, you should be able to answer:
- What did we expect to bill? (Step 1)
- What did we actually bill? (Step 2) — difference is billing accuracy
- What was reduced by credits/adjustments? (Step 3) — difference is discount impact
- What was paid? (Step 4) — difference is uncollected balance
- How old is the uncollected balance? (Step 5) — determines urgency
A one-page reconciliation summary showing these five numbers is a useful monthly management tool. Most billing software can produce it; many operators just do not run it consistently.
Timing Differences Are Not Errors
A common confusion: payments that arrive in the following month are sometimes counted as missing. They are not missing — they are timing differences. A reconciliation should distinguish:
- Timing differences: payment is expected and within terms, just not yet received
- Adjustment-based differences: a credit or discount explains the gap
- Actual discrepancies: no explanation exists — invoice was not generated, or payment cannot be located
Only the third category requires correction. The first two categories are documentation opportunities.
When to Seek Outside Help
If running this reconciliation surfaces more than a few unexplained discrepancies, or if your billing software does not produce the reports needed to run the comparison cleanly, it may make sense to have someone outside your operations do it.
Pilot Billing & Profit Review — $299
A focused review of one month's enrollment, billing, collections, and payroll for established childcare centers. We compare expected to invoiced, document credits, match payments, and produce a prioritized action list.
Request a pilot review → daycarelicensecalifornia.com/daycare-profit-billing-check