Industry Use Cases

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.

Try Jolene.pro · Follow Jolene.pro on LinkedIn

Leave a comment