Reconciling Odyssey TEFA deposits

Reconciliation is the quarterly job of matching what you billed to what actually landed in your bank account. With TEFA, the deposits come from Odyssey on behalf of each family, and they do not always match your invoice to the penny. This is the spot where real money goes missing, quietly, one short deposit at a time. Here is how to keep it from happening to you.

Why an Odyssey deposit may not match your invoice

You invoiced a family for a clean quarterly amount. The deposit arrives a little different. The usual reasons:

• A processing detail. The amount that settles in your account can differ slightly from the amount directed, depending on how the platform handles the transfer.
• A partial release. Part of the award is staged for a later date because of a mid-quarter re-verification or recertification, so the first deposit is only a fraction of what you expected.
• A timing split. Two siblings on one family account can direct funds on different days, so one invoice is paid by two separate deposits.
• A memo that names the family, not the student. The deposit is correct but hard to attribute, so it sits unmatched until you work out which invoice it belongs to.

The reconciliation a school actually has to run

Every quarter, for every ESA-funded family, you are answering three questions:

1. Did the deposit arrive? If not, is it pending, or is it held behind an enrollment-confirmation step?
2. Was it the right amount? If it came in short, is the balance staged for later, or is it a real shortfall to follow up on?
3. Which invoice does it pay? Match the deposit to the student and the quarter, and mark it received with the date it settled.

Do this within a few weeks of each funding window while the details are fresh. A shortfall you catch in October is a phone call. The same shortfall found in May is a write-off.

Treat “partial” as a real state

The trap is binary thinking: paid or unpaid. In practice a lot of deposits are partial. If your records only have two states, a partial deposit either looks fully paid (and you lose the balance) or fully unpaid (and you chase money that is genuinely on the way). Track what came in, when, and what is still expected, with a date, so the picture is on the screen instead of in your head.

Where this lives in CohortLedger

The reconcile view auto-matches each Odyssey deposit to the expected invoice by amount and memo, then surfaces the exceptions: a deposit that came in short of the invoiced amount is flagged as a variance, and a deposit with no matching invoice is flagged as unmatched. You see the expected amount and the received amount side by side, so the gap is visible the moment it happens, rather than surfacing at year-end when there is nothing left to do about it.

Related reading: how TEFA actually pays your school and quarterly ESA invoicing math.