ESA invoice template for microschools

An ESA invoice is not a normal tuition invoice. A regular invoice asks one family for one amount. An ESA invoice has to split a single student’s tuition into the part the state scholarship pays and the part the family owes, track those two pieces separately, and tie the whole thing to a quarter so a program reviewer can follow it later. Get the structure right once and every quarter after that is fill-in-the-blanks. Get it wrong and money goes missing in the gap between what you billed and what the platform actually sent.

This is the template we would hand a new operator, plus the reasoning behind each column. There is a downloadable CSV at the end you can open in Excel or Google Sheets and start using today.

Why an ESA invoice needs its own shape

Most ESA-funded families are not fully covered. A student’s award may be more than your tuition, exactly your tuition, or less than it. If the award covers tuition in full, the family owes nothing and the whole invoice is an ESA line. If the award is smaller than your tuition, the ESA covers part and the family pays the rest out of pocket. Your invoice has to show both numbers on the same row so the family knows what they owe and you know what to expect from the state.

The timing is the other reason. ESA money does not arrive when you send the invoice. In Texas, TEFA funds in three installments across the year, not as one payment, so the amount you invoiced in a quarter and the amount that lands in your bank that quarter are two different figures you have to reconcile. The full per-family math is in quarterly ESA invoicing for microschools, and you can run one student’s award against your tuition in the ESA calculator.

The columns that matter

Every ESA invoice should carry these fields. The first block identifies the invoice, the middle block is the money split, and the last block is what you settle against when the deposit lands.

• Invoice date and number. The real day you issued it, not the funding date. A reviewer reads an invoice dated after the money it records as a red flag.
• Quarter. Which funding period this covers (Q1, Q2, and so on). ESA money is quarterly, so every invoice belongs to a quarter.
• Family and student. Name the student, not just the family. The state funds a student, and the audit packet is per student.
• Program. Which ESA the student is on (TEFA, AZ ESA, FL FES-EO, and so on). A multi-program roster needs this to attribute each deposit to the right source.
• Tuition for the quarter. Your full quarterly tuition for that student, before any split.
• ESA portion.The part of that tuition the scholarship is expected to cover, up to the family’s award.
• Out-of-pocket portion. Tuition minus the ESA portion. What the family owes you directly.
• ESA received and date. What the platform actually deposited and when. Left blank until the money lands, then filled in.
• Balance. What is still outstanding once the ESA deposit and any family payment are in. This is the number that tells you a deposit came in short.

The ESA portion plus the out-of-pocket portion always equals the quarter’s tuition. That is the check that keeps an invoice honest: if the two pieces do not add up to tuition, something is mislabeled.

A worked row

Say a student’s quarterly tuition is $2,400 and their annual ESA award works out to $2,000 for the quarter. The ESA portion is $2,000, the out-of-pocket portion is $400, and the family owes you that $400 on your own schedule. When the platform deposits the ESA money, you record what actually arrived next to what you expected. If it lands at $1,976 instead of $2,000, the $24 gap is a real shortfall to chase, not a rounding error to ignore. Why deposits arrive short, and how to match each one to the right invoice, is in reconciling Odyssey TEFA deposits.

Download the template

The CSV below has the columns above, one example row, and blank rows to fill in. Open it in any spreadsheet. It is a starting point you own, not a product you log into.

Download the ESA invoice template (CSV)

When the spreadsheet stops being enough

A template works for one quarter and a small roster. It starts to strain when you are tracking the ESA-and-out-of-pocket split across twenty families, matching uneven platform deposits against what you billed, and keeping the dated records a reviewer will ask for, all at once and all by hand. That is the point where the columns above stop being a convenience and become the thing you maintain instead of teaching. Where a tool earns its keep over a spreadsheet is covered in what software runs a school’s TEFA money, and you can see the invoicing and reconciliation flow on real numbers in the live demo with no signup.