--- title: "Report on and reconcile reseller bookings" slug: "reseller-bookings-report" description: "Track every reseller booking in one list, export it to invoice from your own system and work out what each reseller still owes." tags: ["Reference"] updated: 2026-11-19T05:31:28Z published: 2026-11-19T05:31:28Z canonical: "mysupport.roller.software/reseller-bookings-report" --- > ## Documentation Index > Fetch the complete documentation index at: https://mysupport.roller.software/llms.txt > Use this file to discover all available pages before exploring further. # Report on and reconcile reseller bookings Keep every reseller booking in one list, work out what each reseller owes and find their bookings in your accounting reports. The Reseller Bookings report covers bookings resellers make in your reseller portal and the ones your team makes for them in Venue Manager. For each item, it shows the reseller, the guests it admits and how many have checked in, and what's still owing on the booking. When it's time to invoice, filter the report to one reseller and export it into the system you invoice from. Use this guide to open and filter the Reseller Bookings report, export reseller bookings to invoice them and find them in your other reports. > [!CAUTION] > Advanced Channel Management add-on > > The Reseller Portal is now in early access for venues on the **Pro**, **Premium** or **Enterprise** plan. To use it, you need the **Advanced Channel Management** add-on. The add-on also gives you access to [Online Travel Agents](/v1/docs/get-started-with-channel-management-in-roller) (OTAs). You pay a small percentage of reseller booking revenue, billed monthly after the bookings happen, so there’s nothing to pay up front. > > To get started, [request early access to the Reseller Portal.](/v1/docs/reseller-portal-is-now-in-early-access) > > [Learn more](https://www.roller.software/pricing/) ## Open the Reseller Bookings report You’ll open the Reseller Bookings report each time you invoice your resellers. It’s in the **Guests** 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. > [!NOTE] > The [permission](/v1/docs/permissions-by-feature-and-role) required to open the Reseller Bookings report is **Can access Guests reports**. The administrator and manager roles have this permission enabled by default. 1. From Venue Manager, go to **Reports** > **All reports**. 2. Search for and select **Reseller Bookings**. ## Filter the Reseller Bookings report Narrow the report to one reseller's bookings for the period you're invoicing (eg last month's bookings for a tour operator on account). | Filter | What it does | | --- | --- | | Search | Finds a booking by its booking ID, or items by product name. It doesn't search reseller or booking names. To see one reseller's bookings, use the **Reseller** filter. | | Date selector | Shows items by the date they're booked for, not the date the booking was made. A booking with items on different dates shows each item under its own date. Choose **Today**, **Tomorrow**, **Yesterday**, **On...**, **Between...**, **Within the next...** or **Within the last...**, then a number of **Days**, **Weeks** or **Months**. | | **Reseller** | Shows the bookings of the resellers you choose. You can search the list and choose more than one. | | **Status** | Shows bookings with the statuses you choose. You can choose more than one. The options are in the next table. | | **Product** | Shows items for the products you choose. The list holds your venue's products grouped by type, including types resellers can't book, such as gift cards and memberships. | **Status** has these options: | Status | Shows | | --- | --- | | **All** | Bookings with any status | | **All reserved** | Bookings that aren't canceled or a venue draft: **Pending**, **On Account**, **Complimentary**, **Partially Paid** and **Fully Paid** | | **Pending** | Bookings with no payment made yet, including tentative bookings waiting for payment before their hold ends | | **On Account** | Bookings charged to the reseller's account, with a balance still owing | | **Complimentary** | Bookings that need no payment | | **Partially Paid** | Bookings with part of the cost paid and a balance still owing | | **Fully Paid** | Bookings paid in full, with nothing owing | | **Canceled** | Canceled bookings | | **Venue Draft** | Bookings saved as a draft in Venue Manager. A draft doesn't hold capacity | After you change a filter, select **Apply filters**. ## What the Reseller Bookings report shows Use the totals for a quick view of the dates you chose, and the rows to check each booking before you invoice. Each row is one item in a booking, with **Quantity** showing how many were booked (eg one row for 2 adult hot tub tickets). A booking with different items, such as hot tub tickets and bath towels, takes one row for each. A package counts as one item, so it takes one row however much it includes. | Total | What it shows | | --- | --- | | **Bookings** | The number of bookings, counting each booking once however many items it has | | **Guests** | The guests the filtered items admit, added together | | **Total value** | The **Total** of every filtered item added together, including canceled and paid bookings unless you filter them out in **Status** | | Column | What it shows | | --- | --- | | **Reseller ID** | The reseller's ID in ROLLER | | **Reseller** | The reseller the booking was made by or for | | **Booking ID** | The booking's ID. Select it to see the booking's details in a side panel, then select **Go to booking** to open it | | **Booking Name** | The booking's name. It can hold the reseller's own reference (eg their order number or group name). If none was given, it shows the name of the reseller contact who booked | | **Item** | What was booked. A product with a variation shows the product name, then the variation (eg Forest Hot Tub Experience - Adult). A package takes one row: its inclusions don't get their own rows | | **Quantity** | How many of the item were booked | | **Guests** | How many guests the item admits (eg 0 for a bath towel) | | **Checked in** | How many of the item have been redeemed so far. For tickets, that’s how many guests have checked in. | | **Total** | The item's total, including modifiers and after discounts. A package's total includes what its inclusions cost. Items in a complimentary booking show 0.00. | | **Booking total** | The whole booking's total, repeated on each of the booking's items | | **Balance** | What's still owing on the whole booking, repeated on each of the booking's items | | **Status** | The booking's current status (eg **On Account**). See the status table earlier in this guide | | **Booking date** | The date the item is booked for | ## Export reseller bookings to invoice them Export your reseller bookings for the month to bring them into the system you invoice from. Each row includes the **Booking Name**, which can hold the reseller's own reference. Use it to match each booking to its invoice line without looking the booking up. 1. From Venue Manager, go to **Reports** > **All reports**, then search for and select **Reseller Bookings**. 2. Select the date selector, then select **Within the last...**. 3. Enter the number of months, weeks or days, and choose **Months**, **Weeks** or **Days**. 4. Select **Apply**. 5. (Optional) To export one reseller’s bookings, in **Reseller**, search for and select the reseller. Leave it empty to export every reseller, then sort by **Reseller ID** in your spreadsheet. 6. In **Status**, select the statuses to include (eg **Pending**, **On Account** and **Partially Paid** for bookings with money still owing). 7. Select **Apply filters**. 8. Select the download button at the top right of the report. 9. Select **Export to Excel** or **Export to CSV**. 10. Select **Alert me when complete**. ROLLER prepares the file in the background. You can keep working while it does. When it's ready, a red dot appears on the **notifications** icon (bell) at the bottom of the left menu. Select the bell, then select the download icon next to your report. ### Work out what a reseller owes Before you invoice, work out what each reseller owes for the dates you exported. **Balance** is what’s still owing on the whole booking, so a booking with more than one row shows the same balance on each row. If you add up the whole column, you count that booking’s balance more than once. 1. In your spreadsheet, sort the rows by **Reseller ID**, then by **Booking ID**. 2. For each booking, take the **Balance** from one of its rows. 3. Add up those amounts for each reseller. For example, a reseller has two bookings with money owing: - Booking A has two rows, one for 2 adult hot tub tickets and one for 2 adult sauna tickets. It has 184.00 owing, so 184.00 shows on both rows. - Booking B has one row, for 2 adult hot tub tickets, and 92.00 owing. The whole **Balance** column adds up to 460.00 (184.00 + 184.00 + 92.00), but the reseller owes 276.00 (184.00 + 92.00). ## Mark on account bookings as paid To keep **Balance** up to date in this report and in the reseller’s record, mark each booking as paid when the reseller pays you. From the booking, select **Take payment**, then choose how they paid (eg **Bank transfer**). **Balance** then shows what’s still owing. You don’t have to mark reseller payments in ROLLER: many venues track them only in their invoicing system. > [!NOTE] > To record a bank transfer or check payment, see the guide [How do I record a bank transfer or payment by check?](/v1/docs/how-do-i-record-a-bank-transfer-or-cheque-payment) To learn more about reseller bookings, see the guide [Create and manage reseller bookings in Venue Manager](/v1/docs/create-and-manage-reseller-bookings-in-venue-manager). ## Find reseller bookings in your other reports Reseller bookings also show in your accounting and sales reports. Use the table to find them when you match ROLLER to your books. Only bookings resellers make in your reseller portal show **Reseller Portal** as the booking location or channel. Bookings your team makes for a reseller in Venue Manager show **Venue manager**. To see both, use the Reseller Bookings report, or the **Reseller** filter in the Revenue Recognition report. | Report | How reseller bookings show | | --- | --- | | [Revenue Recognition report](/v1/docs/revenue-recognition-report) | To see one reseller's entries, select them in the **Reseller** filter at the top of the report. You can choose more than one. To see only portal bookings, select **Reseller Portal** in **Booking location** instead. **Reseller Acc Receivable** shows what a reseller owes for an **On account** booking item once it's redeemed or expires. When you record their payment, the same amount shows as a negative. Unpaid reseller bookings with other payment options (eg pay on arrival) show in **Accounts Receivable**, like any guest booking. This column shows only with accrual accounting. To add the **Reseller Name** column, right-click the grid and select it. | | [Trial Balance report](/v1/docs/trial-balance-report) | Debits: **Accumulated reseller accounts receivable** for **On account** bookings redeemed or expired in the period. Credits: **Reseller accounts receivable collected** when you record a reseller's payment. Accrual accounting only | | [Ledger Summary report](/v1/docs/ledger-summary-report) | Select **Reseller Portal** in **Booking location** to see revenue from portal bookings by reporting category | | [Detailed Transactions report](/v1/docs/detailed-transactions-report) | Payments resellers make when they book in your portal show **Reseller Portal** in **Channel**, with **Staff** left blank. A bank transfer your team records in Venue Manager shows **Venue manager** | | [Transactions by Channel report](/v1/docs/transactions-by-channel) | Payments made in your reseller portal show in the **Reseller Portal** column | | [Detailed Product Sales report](/v1/docs/detailed-product-sales-report) | Select **Reseller Portal** in **Booking location** to see portal sales by product | | [Xero Export (accrual accounting)](/v1/docs/xero-export-accrual-accounting) | A **Reseller accounts receivable** line: a debit when on account bookings are redeemed or expire, and a credit when the reseller pays. Map it on the Xero Integration page, or the line exports with no account code | ## FAQs **Why does Balance add up to more than the reseller owes?** **Balance** is what’s still owing on the whole booking, so a booking with more than one row shows it on each row. Adding up the column counts those bookings more than once. Take each booking’s balance once, as in **Work out what a reseller owes** earlier in this guide. **Booking total** works the same way. **How do I see everything a reseller owes?** Go to **Guests** > **Resellers**, open the reseller and select the **Bookings** tab. **Balance** at the top adds up what's owing on all their **Pending**, **On Account** and **Partially Paid** bookings, whatever their dates. This report shows what's owing only on bookings in the dates you filtered to. To learn more, see **See a reseller's bookings and balance** in the guide [Create and manage reseller bookings in Venue Manager](/v1/docs/create-and-manage-reseller-bookings-in-venue-manager). **Why is Total value different from what the reseller owes?** **Total value** adds up what the filtered items cost, whether or not they're paid. It includes **Fully Paid** and **Canceled** bookings unless you filter them out in **Status**. **Does the report include bookings my team makes for a reseller?** Yes. Bookings your team makes for a reseller in Venue Manager show here, as well as bookings the reseller makes in your reseller portal. **Are canceled bookings included?** Yes, with the status **Canceled**. To leave them out, select **All reserved** in **Status**, then select **Apply filters**. **Why does a package show on one row?** The report lists a package as one item, not each item included in it. Its **Total** is the cost of the whole package, and **Checked in** shows how many guests have checked in for it (eg 10 for a package for 10 guests, not 20 for its jump session and pizza). **Why doesn't searching for a product find the packages that include it?** The report shows each package on one row, so search and **Product** match the package, not the products included in it (eg grip socks in a package). Search for or select the package instead. **Why can't I see the Reseller Bookings report?** It shows only for venues set up to use resellers, and you need **Can access Guests reports**. > [!NOTE] > To request access to reseller features, contact your customer success manager or the [support team](/v1/docs/contact-roller-support). ## Related - [Create and manage reseller bookings in Venue Manager](/create-and-manage-reseller-bookings-in-venue-manager.md) - [Get started with the Reseller Portal](/get-started-with-the-reseller-portal.md) - [Bookings report](/bookings-report.md) - [Filter, customize and download a report](/customize-the-reporting-grid.md) - [Bookings receivables report](/bookings-receivables-report.md)