By the Meet to Manage team
A useful fee tracker answers three questions: what was billed, what has actually arrived, and what needs attention next. This starter template keeps those answers together, with one row per invoice rather than one row per family.
Download the CSV and open it in Excel, Google Sheets or another spreadsheet app. No account is required. The sample records are fictional and use INR only to illustrate the workflow; replace them with your centre's own currency and billing details.
| Invoice | Fee | Received | Outstanding | Credit | Status |
|---|---|---|---|---|---|
| SAMPLE-001 | 3,000 | 1,000 | 2,000 | 0 | Part-paid |
| SAMPLE-002 | 2,500 | 2,500 | 0 | 0 | Paid |
| SAMPLE-003 | 2,000 | 2,200 | 0 | 200 | Overpaid |
1. Set up one record for each invoice
Give each invoice a unique ID, link it to a learner ID, and record the batch, billing period, due date and currency. A family with two children may need two records. A learner billed monthly needs a new record for each month's invoice.
Use a consistent billing-period format such as 2026-10 and an unambiguous due date such as 2026-10-10. Keep personal contact details in your existing family record rather than repeating them throughout the tracker.
2. Record confirmed payments and part payments
Enter the fee amount and the total confirmed payments allocated to that invoice. A payment promise or checkout attempt is not a received payment. Check the payment record before changing the total.
For SAMPLE-001, a fee of INR 3,000 with INR 1,000 received leaves INR 2,000 outstanding. When the next instalment arrives, update the received total on that same invoice. Keep individual transaction references in a separate payment log so each receipt remains traceable.
3. Keep outstanding fees separate from credits
The download contains plain sample values, not formulas or automatic payment reconciliation. Calculate outstanding as the larger of zero and fee amount minus amount received. In the supplied column order, a spreadsheet formula for cell I2 is =MAX(0,G2-H2).
Record an overpayment separately as credit. For a fee of INR 2,000 with INR 2,200 received, outstanding is zero and credit is INR 200. The equivalent formula for J2 is =MAX(0,H2-G2). Agree whether to refund or allocate that credit before changing another invoice.
4. Review the next action before sending a reminder
Filter for positive outstanding balances, then review due dates and the last reminder. Use the next-action field to distinguish a payment check, a scheduled instalment and a reminder. An overpaid invoice needs a credit decision rather than a collection message.
- Confirm the amount, invoice reference and due date before contacting a family.
- Use the family's agreed contact channel and keep messages specific to their invoice.
- Reconcile the tracker against receipts regularly, with one named person responsible for updates.
Template questions
- Does the CSV calculate balances or send reminders?
- No. It is a downloadable starting record with fictional values. Add your own spreadsheet formulas and update statuses yourself. It does not connect to a payment gateway or send messages.
- When should a centre move beyond a spreadsheet?
- Consider a connected billing workflow when several people edit the record, receipts are hard to reconcile, or reminders depend on someone remembering each family. Compare your actual process with the platform's fee-management tools before choosing a plan.
When you need a connected workflow
Explore the product details and discuss your actual records and class setup during a free walkthrough.