--- title: "Ledger Summary report" slug: "ledger-summary-report" description: "Track key financial metrics with the Ledger Summary report. Monitor tax, filter data, and export results for effective financial management." tags: ["Reference"] updated: 2026-10-19T21:00:11Z published: 2026-10-19T21:00:11Z canonical: "mysupport.roller.software/ledger-summary-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. # Ledger Summary report 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. > [!NOTE] > The [permission](/v1/docs/permissions-by-feature-and-role) 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**. > [!NOTE] > To show hidden columns or download the report as CSV or Excel, see the guide [Filter, customize and download a report](/v1/docs/customize-the-reporting-grid). ## 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. > [!NOTE] > For what each term means, see the guide [Get to know reporting terms in ROLLER](/v1/docs/quick-guide-key-concepts-terms-in-roller-reports). ## 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](/v1/docs/set-up-and-manage-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)](/v1/docs/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?](/v1/docs/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. > [!NOTE] > If revenue still shows as **Unassigned** after that, contact your customer success manager or the [support team](/v1/docs/contact-roller-support). ## Related - [Set up reporting categories and GL codes](/set-up-and-manage-reporting-categories-and-gl-codes.md) - [Revenue Recognition report](/revenue-recognition-report.md) - [Trial Balance report](/trial-balance-report.md) - [Does changing reporting categories and GL codes impact historical data?](/does-changing-reporting-categories-and-gl-codes-impact-historical-data.md) - [What's the difference between funds received and revenue?](/what-s-the-difference-between-funds-received-and-revenue.md)