Payment tracking
Keep event booking payments and balances reconciled
Reconcile deposits, instalments and event booking balances with a worked ledger example, exception checks and a practical handover routine for event suppliers.
Track receipt separately from the request
A sent invoice or payment request does not establish that funds have arrived. Keep the booking reference, agreed total, request date, verified receipt date, amount and payment reference distinct. Use a bank or payment-provider record to verify receipt. Keep access to financial records limited and never store full payment-card details in a booking spreadsheet.
Example: reconcile several instalments
An illustrative event booking totals £900. The first verified payment is £200 and a later verified instalment is £300, leaving £400 due. If a £50 agreed extra is added, the revised total becomes £950 and the outstanding balance becomes £450. Record the scope change and preserve each receipt rather than replacing the first payment with the latest one.
Review exceptions before changing the status
Match receipts by booking reference as well as amount. Two customers can pay identical deposits. A pending transaction, a screenshot or an unexplained transfer requires follow-up rather than an automatic paid status. Record duplicate payments, refunds and disputed amounts separately so the original receipt remains visible. Ask the payment provider or your accountant how to record an unusual transaction.
Run a balance review before the event
Filter upcoming events and compare their agreed balance deadlines with verified receipts. Assign one person to follow up overdue items, record the last contact and agree the next action. Reconcile again after any refund or booking amendment. Payment status should not be used as proof that venue access, staffing or equipment availability has also been checked.
Give the team a clear financial handover
A useful handover identifies the booking, the amount still outstanding, who owns the next action and when it is due. The Booking & Deposit Tracker provides an editable workbook with balance and payment-status formulas. It is not a connected bank feed: enter and check your records, inspect formulas after structural edits, and keep a backup before making bulk changes. Follow your accounting process for tax and statutory records.
Is a booking tracker an accounting system?
It supports day-to-day booking administration. Keep the accounting records and reconciliations required for your business and check tax or accounting questions with a suitable adviser.
How is this different from collecting a deposit?
Deposit collection establishes the initial payment workflow. Payment tracking follows all subsequent receipts, changes, refunds and balances throughout the booking.