The Ledger Summary report helps you track various metrics aggregated by each reporting category (GL name) and GL code. It enables you to monitor key financial metrics such as how much tax is payable at the end of the month.
Create your reporting categories
To use this report effectively, allocate every product to a reporting category. Any revenue against products that are not assigned to a category show up in an unassigned category.
Refer to the guide Create your reporting categories to learn how to do so.
Access the report
The Ledger Summary report is located in Accounting section of the All reports page in ROLLER.
From Venue Manager, go to Reports > All reports.
Search for and select the Ledger Summary report.
Filter the results
Filter the data shown by booking location and payment device for the time period by using the drop-down filters at the top of the report. Select Apply filters to display the filtered results.
Filters | Description |
|---|---|
Date selector | Filter results by day, date or a specific time period. |
Booking location | Filter results by where the booking took place. For example:
|
Payment device | Filter results to view data related to specific POS or self-serve kiosk devices |
What data can I see?
You can see data for the following metrics and attributes.
Right-click the report table to select additional columns to add to the report. Learn how to customize report views and save them to use later
Metric/attribute | Definition |
|---|---|
GL Code | The general ledger code assigned to each reporting category |
GL Name | The name/description of the reporting category |
Funds Collected ($) | The total funds collected for all payment methods inclusive of tax |
Tax Collected ($) | The total amount of tax collected for the period on Funds Received |
Gross Revenue ($) | The total recognized revenue based on accrual accounting for each reporting category, tax inclusive |
Tax Payable ($) | The amount of tax included in Gross Revenue and now payable |
Net revenue ($) | Gross Revenue excluding tax |
Quantity Recognized | The total count of transactions recognized as revenue for each reporting category |
Discounts Redeemed ($) | The value of discounts against Funds Collected |
Recognized Discounts ($) | The total value of discounts relating to Gross Revenue |
Export report data
Export the data to a CSV or Excel file by using the download icon in the top right of the page.
Frequently asked questions
We recently added reporting categories with GL codes to our platform, but some transactions are still not classified.
Reporting categories also update historical data. If there are some transactions that are still not classified, submit a
What is the difference between funds received and recognized revenue?
Funds received is the amount of money that has been received for bookings against products within each reporting category for the timeframe selected. Recognized revenue is the value of bookings that were redeemed at POS or have expired (no longer valid bookings are recognized
) during the selected timeframe.