Ledger Summary report

Prev Next

Match ROLLER to your general ledger at month-end by checking what each GL code took in payments and earned in revenue. For each reporting category, the report shows funds collected, revenue recognized and the tax in each (eg how much tax is payable for the month). Revenue from products with no reporting category shows in an Unassigned row, which points you to the products to fix first.

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

Open the report

The Ledger Summary 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 Ledger Summary.

Filter the report

Narrow the report to the period you're closing (eg last month), or to one part of your business.

Filter

What it does

Date selector

Shows payments received and revenue recognized on the dates you choose. The report opens on Yesterday. A payment counts on the day it was received, and revenue on the day tickets were redeemed or expired

Booking location

Shows activity from bookings made in the sales channels you choose: POS, Self-serve kiosk, Online checkout, Venue manager, Recurring billing, API, Data import, Channel partners, Cashless card provider and Reseller Portal

Payment device

Shows activity from the POS or self-serve kiosk devices you choose (eg one till during a busy period)

Companies

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

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

Each row is one GL code, ready to check against the matching account in your books. Each column totals at the bottom of the grid.

Each amount column shows your venue's currency in brackets (eg Funds Collected ($)). Columns marked (hidden) don't show until you add them. To add one, right-click the grid and select it.

Column

What it shows

GL Code

The GL code of the reporting category. Blank in the Unassigned row

GL Name

The name of the reporting category. Unassigned for revenue from products with no reporting category

Funds Collected

Payments received for the category's products, including tax, across all payment methods

Tax Collected

The tax included in Funds Collected

Discounts Redeemed (hidden)

The value of discounts on Funds Collected

Qty Recognized (hidden)

The number of items recognized in the period, when they're redeemed or expire

Gross Revenue

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

Tax Payable

The tax included in Gross Revenue and now payable

Net Revenue

Gross Revenue less Tax Payable

Discounts Recognized (hidden)

The value of discounts on the revenue recognized for the period

Funds Collected and Tax Collected count money on the day the guest pays. Gross Revenue, Tax Payable and Net Revenue count it when staff redeem the tickets or the product expires (eg a deposit paid in July for an August party counts toward August revenue). The report always counts revenue this way (accrual accounting), even if your venue uses cash accounting.

For what each term means, see the guide Get to know reporting terms in ROLLER.

Find revenue that isn't matched to a GL code

Revenue in the Unassigned row won't match any account in your books until its products have a reporting category.

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

  2. Search for and select Ledger Summary.

  3. Set the date selector to the period you're closing, then select Apply filters.

  4. Look for a row with Unassigned in the GL Name column. If there isn't one, every product with revenue in the period has a reporting category.

  5. Go to Reports > Reporting categories. Unassigned at the top of the page shows how many active products have no reporting category.

  6. Add each product to a reporting category, then select Save. To learn how, see the guide Set up reporting categories and GL codes.

The revenue moves from Unassigned to the GL code of the product's new category, for past dates too. Reports can take a few minutes to show the change.

FAQs

Why don't Funds Collected and Gross Revenue match?

They count money on different days. Funds Collected 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 tickets or the product expires, whichever accounting method your venue uses. To learn when each product type expires, see the guide Revenue recognition and product expiry rules in ROLLER (accrual accounting).

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 tickets are redeemed or expire. To learn more, see the guide What's the difference between tax collected and tax payable?

Does assigning or changing a reporting category change past reports?

Yes. The report groups revenue by each product's current reporting category, so revenue from earlier dates moves to the new GL code too. Renaming a category or changing its GL code also changes past reports. Reports you've already downloaded don't change.

Why does revenue still show as Unassigned after I've assigned my products?

Reports can take a few minutes to show the change.

If revenue still shows as Unassigned after that, contact your customer success manager or the support team.