How to Match Event Ticket Orders to Bank Payouts
Friday’s event sold out. The deposit arrived for less than the ticket dashboard showed. Follow the transactions through to the payout before reporting a shortage.
What to pull
Use Excel ticket orders, payouts and bank activity or export orders and settlement detail from ticketing and transactions from banking. Keep event, order, payout, amount and currency.
How to check it
Group payout lines by payout ID. Reconcile sales, refunds, fees and holds on the same currency basis. Match deposits by amount and reference, allowing for settlement timing.
Select the relevant sheets in Jolene.pro and run this check.
Which orders or payout adjustments explain the difference? Show pending settlements and source rows.
What to do with the result
Close explained differences in your event report and send only unmatched payout references to finance for follow-up.
Verify payout timing and processor adjustments against original statements.