Reconcile your takings by finding out how, where and by whom every payment and refund was taken. For each payment or refund, the report shows when it was taken, the amount, the payment method, the channel and the staff member who took it. The Funds Received total at the top shows the money you took for the dates you choose. Tips and gift card payments have their own totals.
The permission required to open the Detailed Transactions report is Can access Transactions reports. The administrator and manager roles have this permission enabled by default.
Open the report
The Detailed Transactions report sits in the Transactions section of All reports. If you use it often, select the star icon next to it to add it to Favorite reports at the top of the page.
From Venue Manager, go to Reports > All reports.
Search for and select Detailed Transactions.
Filter the report
Narrow the report to the payments you need to check (eg yesterday's card payments at POS). The report opens on Yesterday.
Filter | What it does |
|---|---|
Search | Find payments by booking ID, booking name, the booking holder's first or last name, or the Gateway Id from your payment gateway. |
Date selector | Shows payments and refunds by the date they were taken, not the booking date. |
Channel | Shows payments taken in one channel (eg POS, Online checkout or Recurring billing). |
Device | Shows payments taken on one device (eg the POS at your front desk). |
Payment method | Shows payments made with the methods you select (eg Cash and Cards). |
Status | Shows payments on bookings with the statuses you select (eg Canceled, to check payments on canceled bookings). With nothing selected, it shows every status except Venue Draft. |
Type | Shows payments only (Payment) or refunds only (Refund). |
Companies | Shows payments on bookings for the companies you select (eg a school that books group visits). |
After you change a filter, select Apply filters.
To show more columns, group rows or download the report, see the guide Filter, customize and download a report.
What the report shows
The totals tell you what came in for the dates you filtered. Each row under them is one payment or refund you can trace back to its booking.
Total | What it shows |
|---|---|
Funds Received | The money guests paid, less refunds. Tips aren't included. They show in Gratuity Total. Payments made with a gift card, wallet or cashless card aren't included either. That money already counted when the guest bought the card or added money to it. These payments show in Gift Cards Redeemed, Wallets Redeemed and Cashless Cards Redeemed. Vouchers (eg Groupon) and payments made through a third party aren't included. They show in External Payments |
Gift Cards Redeemed | The value of gift cards guests used to pay |
Gratuity Total | The tips guests added to their payments |
Wallets Redeemed | The value of wallet balances guests used to pay. Shows only if your venue uses wallets |
Cashless Cards Redeemed | The value of cashless card balances guests used to pay. Shows only if your venue uses cashless cards |
External Payments | The value of vouchers (eg Groupon) and payments from third parties. Shows only if your venue takes these payments |
Columns marked (hidden) don't show until you add them. To add one, right-click the grid and select it.
Column | What it shows |
|---|---|
Transaction Date | The date and time the payment or refund was taken, in your venue's time zone. A deposit paid on 3 October for a party on 25 October shows 3 October |
Booking Id | The booking the payment belongs to. Select it to see the booking's details in a side panel, then select Go to booking to open it |
Booking Name (hidden) | The name on the booking (eg Mia's 7th birthday). If the booking has no name, it's the booking holder's name |
Channel | Where the payment was taken (eg POS, Online checkout or Venue manager) |
Device (hidden) | The device the payment was taken on (eg the POS at your front desk). Blank when no device was used |
Amount | The payment or refund, including any tip (eg 60.00 for a $50 payment plus a $10 tip). Refunds show as a negative amount |
Gratuity | The tip included in the payment (eg 10.00) |
Status | The booking's current status, not its status when the payment was taken (eg Partially Paid for a party with a deposit paid) |
Pmt Method | How the guest paid (eg Cash, Cards or Gift card) |
Gateway Id (hidden) | The transaction ID from your card payment gateway. Use it to find the same payment in your gateway's records |
Staff | The staff member who took the payment |
Notes (hidden) | Comments recorded with the payment |
Authorizing Staff (hidden) | The staff member who authorized a refund (eg a manager approving a refund at POS) |
Reason Code (hidden) | The reason selected when the refund was processed. Shows only if your venue uses refund reason codes. |
To show hidden columns, see the guide Filter, customize and download a report.
Check the refunds taken for a period
Refunds come straight out of your takings. Check that each one has a reason and the right approval. This report shows the full refund amount, which makes it the one to use when you reconcile refunds.
From Venue Manager, go to Reports > All reports, then search for and select Detailed Transactions.
Select the date selector and choose the dates to check (eg last weekend).
In Type, select Refund.
Select Apply filters.
Right-click the grid and add Authorizing Staff and Reason Code (if your venue uses reason codes).
Funds Received shows the total refunded as a negative amount. Select a Booking Id to see the booking a refund belongs to.
Match card payments to your payment gateway
When an amount in your gateway doesn't match ROLLER, the Gateway Id links each card payment to the same payment in your gateway's records.
From Venue Manager, go to Reports > All reports, then search for and select Detailed Transactions.
Select the date selector and choose the dates to check.
In Payment method, select Cards.
Select Apply filters.
Right-click the grid and select Gateway Id.
To find one payment, enter its gateway transaction ID in the search field.
FAQs
How is this report different from Transactions by Channel?
Both use the same payments. This report lists each payment and refund. The Transactions by Channel report adds them up by payment method and channel. To learn more, see the guide Transactions by channel.
Can I see which products a payment was for?
To see payments by product, with tax, use the Detailed Product Sales report. To learn how, see the guide Detailed Product Sales report.
Can I find a payment by the last four digits of a card?
Go to Bookings > Transactions in Venue Manager to search ROLLER Payments transactions by card number, transaction ID or booking ID. That page can't be downloaded.
Can I see which POS device took a payment?
Yes. Right-click the grid and add the Device column, or use the Device filter to show one device's payments.