A travel agency ledger and receivables tracker shows, for each client, every amount invoiced, paid and still due, with a running balance and an aging report that groups overdue amounts by age. It shows exactly what clients owe, which balances need action first and whether collections are on track each month.
Receivables are the money clients owe the agency. In a travel business they can build up quickly, because a client pays an advance, then a balance, then sometimes an extra charge for a change. Without a clear ledger, the team does not know how much each client owes, and overdue amounts quietly grow. A client ledger and receivables tracker gives you a running balance for each client and an aging report that shows which balances need action first. This guide explains how to set it up and keep it accurate.
What a client ledger shows
A client ledger is a record of everything that affects the client's balance. Each invoice adds to the balance, each payment reduces it, and each refund or credit note changes it. The ledger lists these entries in date order, with a running balance after each one.
The running balance is the number you need most. It tells you what the client owes today. Show it on the client record, so anyone who opens the record sees the amount without doing the arithmetic.
Link every entry to a booking
Each entry in the ledger should link to a booking or an invoice. An entry with no reference is hard to check, and a payment linked to the wrong trip can make a balance look correct when it is not. Use the booking reference or the invoice number on every line.
This link also helps with disputes. When a client questions a charge, you can show the invoice, the booking and the payment in one place.
Enter payments on the day they arrive, with the bank reference. A payment recorded a week late makes the overdue list look worse than it is and creates unnecessary calls to clients.
Set up the aging report
An aging report groups the outstanding amounts by how long they have been overdue. A common set of buckets is current, one to thirty days overdue, thirty-one to sixty days, sixty-one to ninety days and over ninety days. Each client's balance falls into one bucket, based on the oldest unpaid invoice.
The aging report tells you where to focus. Balances in the older buckets are harder to collect and need a decision: keep chasing, agree a payment plan or write the amount off if the client cannot pay. Review the report every week, and assign an owner to each overdue balance.
Agree payment terms with each client
Every receivable should have clear payment terms. Write them on the invoice and in the booking confirmation. State the due date for each instalment and the balance, and the consequence of a late payment if your policy includes one.
Corporate clients often pay on a monthly cycle or after receiving an approved invoice. Record their terms in the account, so the team knows what to expect and the collection calls are timed correctly.
Follow up on overdue balances
Follow-up should be consistent. A reminder before the due date, a message on the due date, a call a few days after it and a formal reminder if the balance remains unpaid. Keep the messages polite and specific: the amount, the invoice number and the due date.
Record each follow-up in the ledger, so the team can see the history. A balance with three reminders and no response needs a different approach from one with a single missed payment. The owner should decide the next step for any balance more than thirty days overdue.
Handle credit notes and adjustments
Sometimes a balance changes for reasons other than payment. A client may receive a credit for a cancelled item, or an invoice may be corrected. Record these as credit notes or adjustments in the ledger, with a clear reason. Never delete an invoice that has been sent. Issue a credit note or a corrected invoice instead, so the history stays clear.
Check the adjustments with your accountant before they affect the books. A credit note that is not recorded correctly can cause tax problems later.
Monthly receivables review
Once a month, review the whole ledger with the owner or the accountant. Check that the total receivables match the total of the individual client balances. Confirm that the aging report is accurate. Decide what to do about balances that are more than sixty days overdue, and record the decision.
Look for patterns too. If one type of client pays late, you may need a different payment plan. If one destination creates many adjustments, the quotation may need clearer terms.
Common mistakes
The first mistake is recording payments without linking them to bookings. The second is no aging report, so overdue balances are invisible until they are large. The third is deleting or editing sent invoices instead of issuing credit notes. The fourth is no owner for overdue balances. The fifth is a ledger that does not match the bank statement, which is often caused by late or unrecorded payments.
Another mistake is giving the same payment terms to every client without considering their risk. A new client with a large booking may need a higher advance than a long-standing client with a steady record.
Choosing a tool for ledgers
Look for a tool that keeps a running balance for each client, links entries to bookings and invoices, produces an aging report and records follow-ups. Ask the vendor to show a client with an invoice, two payments and a credit note, and check that the balance is correct.
If you use a spreadsheet, create one tab for each client group, with columns for date, reference, description, debit, credit and running balance. Add a separate aging tab that uses the due dates to group the balances. Keep the sheet updated every week.
Our accounting software guide explains what to check for the full ledger and tax features. Miya Travel focuses on the sales side of the agency, so check the documentation before you rely on a specific ledger feature.
A weekly receivables routine
Each Monday, update the ledger with the payments received last week. Check the aging report and list the balances that need action this week. Assign each balance to an owner and set a follow-up date. Once a month, reconcile the total with the bank statement and the accountant's records.
Reconciling the ledger with the bank
The ledger shows what the agency thinks it has received. The bank statement shows what has actually arrived. Reconciling the two each week catches missing payments, duplicate entries and payments recorded against the wrong client. Set a fixed time for the reconciliation, such as Friday afternoon, and make it part of the routine.
Match each bank credit to a ledger entry. Use the bank reference, the client name and the amount to find the match. When a payment cannot be matched, check with the client or the accounts contact before you record it against a client. Leave unmatched items in a suspense list until they are explained, rather than guessing.
Record the reconciliation date on the ledger, so that anyone who opens the file can see when the balances were last confirmed. A reconciled ledger is trustworthy, and a ledger that is not reconciled regularly slowly drifts away from the bank.
Dealing with disputed balances
Sometimes a client disputes the balance shown in the ledger. They may believe they have paid more than the ledger shows, or they may question a charge. Respond promptly and calmly. Check the ledger entries, the invoices and the bank records for the period in question, and send the client a clear statement that lists each entry.
If the dispute reveals an error, correct it with a clear adjustment entry and tell the client what changed. If the charge is correct, explain it with reference to the invoice and the booking terms. Keep a note of the dispute, the explanation and the outcome, so that the same question can be answered quickly if it arises again.
Frequently asked questions
What is a client ledger in a travel agency?
It is a record of every invoice, payment, refund and adjustment for a client, with a running balance that shows what the client owes today.
What is an aging report?
It groups overdue balances by how long they have been unpaid, such as one to thirty days, thirty-one to sixty days and so on, so you know which balances to chase first.
How do I correct a sent invoice?
Do not edit or delete it. Issue a credit note or a corrected invoice, and record it clearly in the ledger with the reason.
How often should receivables be reviewed?
Update the ledger weekly and review the aging report each week. Hold a fuller monthly review with the owner or the accountant.
What should I do with a balance that is more than sixty days overdue?
Decide the next step with the owner: keep chasing, agree a payment plan or, if the client cannot pay, write it off as your policy allows. Record the decision.
