Revenue Recognition report

Prev Next

Reconcile your month-end numbers by separating what guests have paid from what your venue has earned. The report follows each booking from the day it was paid to the day its revenue was earned (eg a deposit paid in July for an August party). For each product in a booking, it adds a row every time money is paid, refunded or recognized as revenue, showing the amount, the tax and the date. When a summary figure in another accounting report needs explaining (eg funds received, net revenue or tax payable), the rows here show what's behind it.

The video follows a booking paid in February for a visit in March, then shows how this report fits with the Ledger Summary, Sales Tax and Trial Balance reports.

The permission required to open the Revenue Recognition report is Can access Accounting reports. The administrator and manager roles have this permission enabled by default.

Open the report

The Revenue Recognition report sits in the Accounting section of All reports. If you use it every month-end, select the star icon next to it to add it to Favorite reports.

  1. From Venue Manager, go to Reports > All reports.

  2. Search for and select Revenue Recognition.

Filter the report

Set the period you're closing, then narrow the rows to the part of your business you're looking at (eg one product, or bookings made online).

Filter

What it does

Date selector

Shows entries recorded on the dates you choose. The report opens on Yesterday. A payment is recorded on the day it's received, and revenue on the day the item is redeemed or expires

Booking location

Shows entries for bookings made in the sales channels you choose: POS, Online checkout, Venue manager, Recurring billing, API, Data import, Channel partners and Cashless card provider. Reseller Portal shows if your venue uses the reseller portal

Payment method

Shows entries for the payment methods you choose: Cash, Cards, Check, Bank transfer, Gift card, Wallet, PayPal, Cashless card, Voucher, Third party and Other

Company

Shows entries for bookings assigned to the companies you choose. Select None for bookings with no company

Reseller

Shows entries for the resellers you choose. You see this filter only if your venue uses the reseller portal

Product

Shows entries for the products, product types or product categories you choose. With nothing selected, the report includes every product with entries in the period, archived products included. To report on a product you've archived, select it under Archived products

Payment device

Shows entries for bookings made on the devices you choose (eg one POS device during a busy period). Select None for bookings made without a device

From an HQ account, the report also has a Venue Name filter and a Venue column. It has no Product or Payment device filter.

After you change a filter, select Apply filters.

To show hidden columns or download the report as CSV or Excel, see the guide Filter, customize and download a report.

What the report shows

Every row is one entry for one product in a booking. Read together, a booking's rows show where its money is: received, deferred, owed or earned.

Each row has one of three entry types:

Entry type

When ROLLER adds it

What it shows

Transaction

A guest pays, or you refund them

The amount in Funds Received. A refund is negative. A payment for an item that isn't redeemed yet also adds to Deferred Rev

Recognition

Staff redeem the item, or it expires. For a membership, when each payment is made

The amount leaves Deferred Rev as a negative and shows in Gross Revenue

Adjustment

The booking changes (eg an item is added or removed, a quantity, price or discount changes, or the booking is canceled)

What's been paid, split again across the booking's items. It's recorded on the day of the change

A walk-in sale at POS still gets both a Transaction row and a Recognition row, often seconds apart. A row can show 0.00 in every amount column when nothing was paid or recognized at that point (eg a new On Account reseller booking, or a change to a booking that hasn't been paid).

When a guest pays part of a booking (eg a deposit), ROLLER splits the payment across the booking's items by value. Each product's row shows its share.

The totals above the grid add up each column for the dates and filters you've set.

Total

What it shows

Funds Received

Payments received less refunds, across every payment method. Tips aren't included

Fee Revenue

Fees for the period (eg booking fees)

Deferred Fee Revenue

The change in fees paid but not yet recognized. Shows amounts only when Fee recognition is set to Recognize at redemption

Tax On Fees

Tax collected on booking fees

Tax Collected

The tax included in Funds Received

Discounts

Discounts redeemed in the period

Deferred Revenue

The change in deferred revenue. Payments for items not yet redeemed add to it, and items redeemed or expired take away from it. It's negative when more was recognized than paid ahead

Gift Card Revenue

The change in gift card deferred revenue. Gift cards sold add to it, and gift cards spent take away from it

Accounts Receivable

The change in what guests owe for items already redeemed or expired

Reseller Accounts Receivable

The change in what resellers owe for On Account bookings already redeemed or expired. Shows only if your venue uses the reseller portal

Gross Revenue

Revenue recognized in the period, including tax and after recognized discounts

Recognized Discounts

Discounts on the revenue recognized in the period

Tax Payable

The tax included in Gross Revenue and now payable

Net Revenue

Gross Revenue less Tax Payable

Under cash accounting, the report shows Funds Received, Fee Revenue, Tax On Fees, Tax Collected and Discounts only. The deferred, receivable and recognized revenue totals and columns don't show.

For what each term means, see the guide Get to know reporting terms in ROLLER. To check or change your accounting method, see the guide Choose cash or accrual accounting for your reports.

The grid shows the same amounts for each row, with the details of the entry. Each amount column shows your venue's currency in brackets (eg Deferred Rev ($)). Columns marked (hidden) don't show until you add them. To add one, right-click the grid and select it.

Column

What it shows

Record Date

The date and time of the entry, in your venue's time zone

Entry Type

Transaction, Recognition or Adjustment

Booking ID

The booking's ID. Select it to see the booking's total, balance and items

Booking Location (hidden)

The sales channel the booking was made in

Payment Device (hidden)

The device the booking item was added on

Product Name

The product sold or redeemed

Ticket Name (hidden)

The ticket sold or redeemed (eg Adult)

Funds Received

The payment or refund for the item. A refund is negative

Discount (hidden)

The discount redeemed

Fee Revenue (hidden)

Fees for the item

Deferred Fee Revenue (hidden)

Fees paid but not yet recognized

Tax Collected

The tax included in Funds Received

Tax % (hidden)

The tax rate for the item

Status

The booking's payment status (eg Fully Paid, Partially Paid or On Account)

Transaction ID (hidden)

The payment's ID in ROLLER

Transaction Location (hidden)

Where the payment was taken (eg recurring billing)

Payment Method (hidden)

The payment method used

Gateway ID (hidden)

The payment's ID from the payment gateway

GL Code

The GL code of the product's reporting category

Ticket Quantity (hidden)

The number of tickets in the booking item

Company Name (hidden)

The company assigned to the booking

Reseller Name (hidden)

The reseller the booking was made by or for. Shows only if your venue uses the reseller portal

Tax On Fees (hidden)

Tax collected on booking fees

Deferred Rev

Positive when a guest pays for an item that isn't redeemed yet. Negative when that item is redeemed or expires

Gift Card Def Rev

The value of a gift card when it's sold. It stays here until the gift card is spent

Manual Gift Card Adjustment

Changes staff make by hand to a gift card's balance

Acc Receivable

What the guest owes for an item once it's redeemed or expires. When they pay, the same amount shows as a negative

Reseller Acc Receivable

What a reseller owes for an On Account booking item once it's redeemed or expires. When you record the reseller's payment, the same amount shows as a negative. Shows only if your venue uses the reseller portal

Gross Revenue

Revenue recognized for the item, including tax

Discounts Recognized

The discount on the revenue recognized

Tax Payable

The tax included in Gross Revenue

Net Revenue

Gross Revenue less Tax Payable

A download has every column above, hidden ones included, and some the grid doesn't have (eg each item's expiry date and the discount code used).

To learn when each product type's revenue is recognized, and what happens to an expired gift card's balance, see the guide Revenue recognition and product expiry rules in ROLLER (accrual accounting).

Follow a booking from payment to revenue

When a month-end figure looks off, follow one booking through the report to see what happened to its money and when.

  1. From Venue Manager, go to Reports > All reports.

  2. Search for and select Revenue Recognition.

  3. Set the date selector to cover the booking, from the day it was paid to the day of the visit (eg Within the last 1 month).

  4. In the Product filter, select the booking's product.

  5. Select Apply filters.

  6. Select the Booking ID column header to sort the rows by booking.

  7. Find the booking and read its rows in date order.

  8. To see the booking's total, balance and items, select its Booking ID.

  9. To open the full booking, select Go to booking.

For example, a guest pays $110 online on February 27 for a visit on March 3, and $10 of that is tax. The booking has two rows:

Record Date

Entry Type

Funds Received

Deferred Rev

Gross Revenue

February 27

Transaction

110.00

110.00

0.00

March 3

Recognition

0.00

-110.00

110.00

February's report shows $110 received and deferred, with no revenue. March's shows the $110 leaving deferred revenue and counting as gross revenue, with 10.00 in Tax Payable and 100.00 in Net Revenue. That's the pattern to expect: a payment for a future visit adds to deferred revenue, then moves into revenue when the booking is redeemed or expires.

Once a booking is fully paid and redeemed, its Deferred Rev rows add up to 0.00. If they don't when you expect them to, look at whether staff have redeemed the booking and when its product expires. If part of a booking is still unpaid when it's redeemed, the unpaid amount shows in Acc Receivable until the guest pays.

To compare this report with the Ledger Summary, Sales Tax or Trial Balance report, set the same dates in each one. Their summary figures are built from the entries here.

FAQs

Why doesn't Funds Received match Gross Revenue?

They count money on different days. Funds Received counts a payment on the day the guest pays (eg a deposit for next month's party). Gross Revenue counts it when staff redeem the item or it expires.

To learn more, see the guide What's the difference between funds received and revenue?

What's the difference between deferred revenue and accounts receivable?

Deferred revenue is money a guest has paid for an item that hasn't been redeemed or expired yet. Accounts receivable is money a guest still owes for an item that has.

To learn more, see the guide What's the difference between deferred revenue and accounts receivable?

What's the difference between Tax Collected and Tax Payable?

Tax Collected is the tax in the payments received for the period. Tax Payable is the tax in the revenue recognized for the period, when items are redeemed or expire.

To learn more, see the guide What's the difference between tax collected and tax payable?

When is revenue recognized for a multi-pass?

ROLLER recognizes a multi-pass one visit at a time. For example, with a 10-visit pass sold for $100, $10 moves from deferred revenue to recognized revenue each time staff redeem a visit. If the pass expires with visits left, ROLLER recognizes the rest on the expiry date.

To learn more, see the guide Create multi-pass products.

When is revenue recognized for a recurring pass?

Under accrual accounting, ROLLER recognizes a recurring pass one session at a time. Each session's price moves from deferred revenue to recognized revenue when staff redeem that session.

For example, a guest pays $120 for a six-week class ($20 a session). ROLLER recognizes $20 each week they attend. If they miss a week, ROLLER recognizes that session's $20 when the session expires, as it does for a session pass. It doesn't wait for the end of the course.

In the report, each session has its own Recognition entry.

To learn more about when sessions expire, see the guide Revenue recognition and product expiry rules in ROLLER (accrual accounting).

Why doesn't an unpaid reseller booking show in Reseller Acc Receivable?

Only On Account bookings go there, and only once their items are redeemed or expire. An unpaid bank transfer or pay on arrival booking shows in Acc Receivable, like any guest booking.