Month-End Childcare Billing Review: Charges, Payments and Unresolved Balances
A month-end childcare billing review should leave the office with a clear explanation of each unresolved balance. Start with the billing records, check payment status separately, and give each discrepancy an owner. A total on a dashboard is a starting point for investigation.
This guide is an operational review, not instructions for tax reporting or revenue recognition. Agree accounting treatment and period-close requirements with your bookkeeper or accountant.
Set the review boundary
Record the period, cutoff time and accounts included. Decide whether you are reviewing activity dated in the month, balances as of month-end, or both. Save the source reports with their generation time so a later payment does not make an earlier review appear incorrect.
Keep separate questions separate: what was charged, what the family owes, what the processor reports as paid, and what reached the bank. These amounts can differ because of timing, fees, refunds or other adjustments.
For the wider workflow, read the childcare billing software guide. Use billing and invoicing preparation to review the inputs before the next cycle.
Review charges against the agreed arrangement
For each account with a discrepancy, compare the charge with the applicable schedule, agreed rate, effective dates and documented adjustments. Check new starts, departures and changes in attendance plans. Use the program's approved billing terms; do not invent a proration rule to make a balance disappear.
Look for duplicate charges and gaps around a transition. Record the source reference and the action needed. The review sheet should point to the authoritative record, not become a second billing ledger.
Distinguish payment states
A payment attempt is not the same as a completed payment. Keep pending, failed, refunded and disputed items visible with their source status and last-check date. Follow the meanings in your processor and billing system; do not rename a pending item “paid” for convenience.
When comparing processor activity to a bank deposit, use the processor's payout details. Do not expect every family payment to equal an individual bank deposit. Ask the person responsible for reconciliation to explain unresolved differences before closing the review.
Walk through a fictional account
Suppose an account starts with 100 owed, receives 800 in new charges, has a documented credit of 50, and has 600 in completed payments applied. With no other adjustments, the remaining balance is 250: 100 + 800 − 50 − 600.
A separate pending payment of 250 is recorded in the pending column. It does not reduce this worksheet's balance until its completed status and application are confirmed. If that payment later fails, the office still has an accurate list of accounts needing attention.
This example deliberately excludes refunds, chargebacks and reallocations. If those occur, document their effect from the authoritative ledger rather than forcing them into the simple example. The worksheet includes a signed “other balance adjustment” column: positive increases the amount owed; negative decreases it. Have the accounting owner verify its use.
Resolve exceptions before sending reminders
Assign each unresolved item a reason, owner and next review date. Useful reasons include “rate needs confirmation,” “payment pending,” “possible duplicate” and “credit approval missing.” Do not send a balance reminder until staff verify that the amount and status are current.
If an adjustment is needed, use the authorized process and retain its reference. Keep review completion separate from adjustment approval. A reviewer identifying a problem does not automatically have permission to change a charge.
Use the month-end worksheet
Use one row per account being reviewed and avoid unnecessary personal information. The manual balance calculation is opening balance + new charges − credits − applied completed payments + signed other adjustments. Compare it to the source balance. A mismatch should remain open until explained.
The CSV contains a fictional example and no formulas. Enter amounts in one currency per sheet. Keep pending payments in their own column and retain report references. Reconcile the resulting sheet back to your authoritative records before relying on it.
Close with a short handoff
Your handoff should identify the period reviewed, unresolved items, approved corrections and the person responsible for each next step. Check later status changes against this record instead of starting over from memory.
Explore Bloomily's billing workflow with a realistic example of a changed schedule, a pending payment and a credit. Ask to see how each appears in the records you will use for review.
Common questions
Is a pending payment a completed payment? No; preserve its source status and verify completion before treating it as applied in this worksheet.
Should the bank total equal charges for the month? Not necessarily. Charges, payments and payouts describe different events and may use different dates.
Can this worksheet replace accounting records? No. It organizes exceptions and references the records used to resolve them.
Download the worksheet
Download the editable CSV worksheet. Open it in Excel, Google Sheets, or another spreadsheet application. The first data row is a fictional example; delete it before entering your own records. The file has no automatic calculations. Keep completed copies in your approved staff storage, not on a public link.