Use the Ledger Summary report track various metrics aggregated by each reporting category and GL Code such as seeing how much tax is payable at the end of the month.
Record deferred revenue and report revenue on the date it was earned (rather than received). To unlock accrual accounting with a Pro plan and above, contact your account manager or the support team.Learn More
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 as unassigned revenue.
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.
|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 devices|
What data can I see?
You can see data for the following metrics and attributes.
|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.