Question
How do I reconcile deposits from bank statements with transactions in ROLLER?
Solution
First, look at the bank deposit in your bank account and note the date and deposit amount. Then, find the transaction date in the ROLLER Payments Export report:
- From Venue Manager, go to Reports > All reports.
- Search for ROLLER Payments Payout Export.
- Choose the date range for the deposit (payout) you want to match (date range is best due to your bank’s processing delays).
- Select Alert me when complete. You will receive a notification when your report is ready to view on the notifications icon (bell) at the bottom of the main menu.
- Download and open the report in a spreadsheet program.
- Locate the payout amount and its payout date in the exported report (the payout date is the date the payout was initiated from ROLLER Payments, not the date it arrived in your bank account).
- For the payout, identify the funds received transaction date (the date the transactions were processed in ROLLER).
Match funds received totals in the Detailed Transactions report:
- From Venue Manager, go to Reports > All reports.
- Search for Detailed Transactions.
- Set the date filter to match the funds received transaction date range from the ROLLER Payments Payout Export.
- Apply the following filters:
- Filter for Cards and Other (eg Apple Pay) payment methods only (exclude cash).
- Filter the payment type to include only Payments (exclude refunds).
- Check that the total Funds received metric at the top of the table matches the payout amount for the date range in the ROLLER Payments Export report.
- The filtered table lists all transactions for the day that make up the total.