Collections report
The Collections report records every payment received, refunded, or redeemed against an invoice β with the source, payment method, timestamp, employee who collected the payment, and the cash register where the payment was recorded. It is the primary report for accrual-based reconciliation between sales and bank deposits.
Before you begin
- This report is built for accrual-based accounting. For cash-based accounting, use the Sales-Cash report.
Permission: Collections Report under Financial in the Reports(V2) section of the security role β required to open this report. For the classic version of the report, the report-area action under View Admin Reports in the Administrator section of the security role.
Navigation: Open the Reports dashboard, type the report name in Search Report, and select Collections.
Report details
| Aspect | Detail |
|---|---|
| Purpose | Track payments received, refunded, or redeemed against invoices for accrual reconciliation |
| Filters | Date range, Center, Payment type, Zone or Location group |
| View scope | Center, Organization |
Use the Collections report to:
- Track all payments received with timestamps, sources, and payment methods.
- Reconcile bank deposits against collected payments.
- Compare with the Sales-Accrual report to understand differences between sales earned and cash collected.
- See when liabilities (membership credits, packages, gift cards, loyalty points) were redeemed.
- Identify amounts still owed and follow up on outstanding payments.
- Audit which employee closed each invoice and which register was used.
Report columns
Default columns, in order:
| Column | Description |
|---|---|
| Collection Date | Date the payment was received, the amount was refunded, or a liability was redeemed. |
| Invoice# | Invoice number generated for the appointment or POS entry. |
| Guest Code | System-generated guest identifier. |
| Guest Name | Full name of the guest associated with the transaction. |
| Center Code | Internal code assigned to the center. |
| Center Name | Center where the payment was collected. |
| Tax Collected | Tax paid by the guest on this transaction, including any applicable service or product taxes. |
| Payment Type | Payment method used (cash, card, gift card, membership credits, etc.). |
| Amount Paid | Amount paid or redeemed for a specific item on the invoice. |
| Total Paid | Total amount paid or redeemed across all items in the invoice up to that payment date. |
| Due | Amount still owed by the guest for the invoice. |
| Tip | Tip amount paid by the guest. |
| SSG | Support staff gratuity (SSG) paid by the guest. |
| Invoice Center | Center where the invoice was originally created, which may differ from the Center Name if the payment was collected at a different center. |
| Card Type | Type of card used for the payment (for example, Visa, Mastercard, Amex). |
Additional optional columns available on this report:
| Column | Description |
|---|---|
| Liability Center | Center where the liability was originally sold. Populated only when Payment Type is a redemption (Membership Credits, Membership Benefits, Packages, Gift Cards, Prepaid Cards, Loyalty Points). |
| ESF | Whether the payment was processed using Easy Split Financing (ESF). |
| Cashback | Cashback paid to the guest for the transaction. |
| Card Number / Card Invoice No / Card Bank Name / Card Expiry | Card-payment details. For offline card payments, Card Invoice No is the receipt number from the card terminal. |
| Check Number / Check Bank Name / Check Date | Check-payment details. |
| Custom Name | Name of the custom payment method used. |
| Additional Data | Extra info recorded for the custom payment method. |
| Comments | Notes added on the invoice for internal reference. |
| Collected By | Employee who finalized the invoice. |
| Cash Register | Register on which the transaction was performed. |
| Gender / Nationality | Demographic details from the guest profile. |
| Reading Mode | How the card was read (swipe, dip, tap, manual key entry). |
| Card Surcharge | Extra fee charged for card payments. |
| Tax on Surcharge | Tax on the card surcharge. |
| Collected By Code | Employee code of the staff member who closed the transaction. |
| Invoice Status | Current invoice status (Paid, Partially Paid, Unpaid). |
| Invoice Closed Date | Date the invoice was closed. |
| Tax redeemed by loyalty points | Tax paid through loyalty point redemption. Visible only when tax-inclusive pricing is enabled. |
| Tax redeemed by gift card | Tax paid through gift card redemption. Visible only when tax-inclusive pricing is enabled. |
Filters
- Date range β Restrict results to a specific collection period.
- Center β View collections for one or more centers.
- Payment type β Filter by how the guest paid (cash, card, gift card, membership credits, etc.).
- Zone or Location group β Filter by a configured zone or location group.
Compare with the Sales-Accrual report
The Sales-Accrual report is based on the sale date; the Collections report is based on the payment date. Sales-Accrual shows each item on an invoice; Collections shows each payment on an invoice.
| Sales-Accrual report | Collections report | Compare | Do not compare |
|---|---|---|---|
| Column: Sales (Inc. Tax) | Column: Amount Paid | N/A | Invoices whose sale date differs from full payment date. Sales-Accrual uses sale date; Collections uses payment date. |
| Column: Collected, no specific filter | Column: Amount Paid, Filter: Payment type = Cash, Card, Check, or Custom | Invoices with the same sale date and full payment date | Invoices whose sale date differs from full payment date. Amount Paid is per-payment-date; Collected is total collected up to current date. |
| Column: Redeemed, no specific filter | Column: Amount Paid, Filter: Payment Type = Gift Card, Prepaid Card, Membership, Packages, Loyalty Points | Invoices with the same sale date and full redemption date | Invoices whose sale date differs from full redemption date. Amount Paid is per-redemption-date; Redeemed is total redeemed up to current date. |
Membership revenue recognition (IRR/MRR/SCR)
When the organization-level Include membership IRR, MRR, and SCR values in reports setting (Configuration > Reports) is enabled, this report's redemption, sales, and collection calculations use the Initial Revenue Recognition (IRR), Monthly Revenue Recognition (MRR), and Service Credit Revenue (SCR) values defined in membership settings. This is disabled by default.
Note: The same setting affects several other reports when enabled, including the Cross-Center Settlement report, Royalty v2 report, Sales-Cash report, Sales Tax report, Sales-Accrual report, Master Center Metrics report, and Business KPI report.
For report settings, see Configure report settings.
Tips
- If the report includes more than one year of data, click Email to receive the export by email.