Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Track of Deposits, Balances and Refunds for Every Student Booking?
Problems We Solve

How Do We Keep Track of Deposits, Balances and Refunds for Every Student Booking?

Language schools chase course balances and apply refund rules from memory. We build payment tracking that links deposits, balances and refunds to each booking.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Student bookings are paid in parts, by the student, a parent or an agent, in different currencies and by different methods, and cancellations and changes create credits and refunds. We build payment tracking that ties every payment and refund to the booking, sends balance reminders on your schedule and applies your cancellation terms consistently. The terms themselves stay yours.

Who owes what, for which weeks?

A direct student pays a deposit by card in January, her father sends the balance by international bank transfer in March with a reference that does not match anything, and she extends by two weeks when she arrives and pays at reception. An agent pays for three students in one transfer, less commission, and a fourth student's booking with the same agent was cancelled.

Accounts spends part of every week matching payments to bookings. Some students arrive with a balance still owing that nobody chased. A cancellation refund is worked out differently from the last one, because the person who did the last one is on holiday.

Why payments drift away from bookings

  • Payments arrive from several payers: the student, a parent, a sponsor or an agent.
  • Bank references are often missing, shortened or in a different alphabet.
  • Agents pay several bookings at once, net of commission.
  • Currencies and bank charges leave small differences.
  • Bookings change after payment, creating credits or new amounts due.
  • Cancellation terms depend on timing, and are applied from a PDF.

The student system knows what was booked, the bank knows what arrived, and a spreadsheet tries to bridge the two.

The cost of loose payment tracking

Unpaid balances on arrival are awkward to collect from a student who is already in class. Refunds done inconsistently lead to complaints and sometimes to chargebacks. Accounts time goes on matching instead of reporting. And a manager cannot quickly answer a basic question: how much do students and agents owe us today, and for which bookings?

The payment tracking we build

  1. Every booking has a payment schedule, set from your terms: deposit, balance due date, and who is expected to pay.
  2. Card payments through Stripe or your provider are linked to the booking automatically, from a payment link on the confirmation.
  3. Bank transfers are imported from your bank feed or accounts package, such as Xero, and matched to bookings by amount, payer name and reference, with suggested matches for a person to confirm.
  4. Agent payments covering several bookings are split across them, with commission deducted under each agent's terms.
  5. Balance reminders go to the right payer at points you choose before the due date, and overdue balances appear on a list before the student arrives.
  6. Cancellations and changes calculate the credit or refund from your terms and the dates involved, and a person approves before any money moves.
  7. Everything posts to your accounts package, so the ledger and the booking agree.
Payment situationWhat the tracking does
Card deposit on bookingLinked automatically
Transfer with an unclear referenceSuggested matches for a person
Agent pays several bookingsSplit across bookings, net of commission
Balance not paid by due dateReminder, then on the overdue list
CancellationRefund calculated from your terms, approved by a person

Your cancellation and refund terms are yours, set with your advisers. We apply them as written and flag anything they do not cover.

Money that matches the bookings

Accounts confirms suggested matches instead of hunting for them. Balances are collected before arrival, not in the corridor. A refund is worked out the same way whoever does it, with the calculation shown. And the owed-today report takes a click.

Consider an ordinary Tuesday. The bank feed brings in nine transfers overnight. Six match a booking on amount and name and are confirmed with a click. Two are agent payments, split across their bookings with commission shown. One has no usable reference, and the tracking suggests the two bookings it could belong to, so accounts emails the payer to check. Meanwhile three balance reminders went out that morning without anyone opening a spreadsheet.

Is this your accounts week?

  • Bank transfers are matched to bookings by hand.
  • Students arrive with unpaid balances.
  • Agent payments for several students are hard to split.
  • Refunds are calculated differently by different people.
  • Nobody can say quickly what is owed today.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does it tell us what our refund terms should be?

No. Your terms are set by you and your advisers. We apply them consistently and show the calculation.

Can it handle payments in several currencies?

Yes. Payments are recorded in the currency received and converted using the rate your accounts package uses.

Do we need to change bank?

No. We read from your existing bank feed or accounts package.

What if a payment cannot be matched?

It stays on an unmatched list with suggestions, and a person decides.

What drives the cost?

How payments arrive today, which accounts package you use and how complex your terms are.

Keep reading

More on Problems We Solve

Start here

Tell us where the admin piles up at your language school

Describe how a normal week runs at your school, from the Monday arrivals to the Friday certificates, and which student management system, spreadsheets and accounts package you already use. We will tell you what we would build and what we would leave alone, and if your current system already has a setting that fixes it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →