Sales-Cash report
The Sales-Cash report shows revenue recognized only upon full payment β the cash-basis counterpart to the accrual-based Sales accrual report. Use it to monitor real-time cash flow, validate closed sales, and reconcile collections with bank records.
On this page
- Before you begin
- Report details
- Filters
- Columns
- Membership revenue recognition (IRR/MRR/SCR)
- Tips
- Related articles
Before you begin
- This report is for businesses that recognize revenue only when payment is received. Open invoices are excluded.
- For accrual reconciliation alongside this report, use the Sales accrual report and the Collections report.
Permission: Sales(Cash) 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 Sales-Cash.
Report details
| Aspect | Detail |
|---|---|
| Purpose | View revenue recognized only on payment, for cash-basis accounting and bank reconciliation |
| Filters | Level of Detail, Sale type, Sale date, Centers, Zone or Location group, Item type, Payment type, Sold by, Invoice status, Item Category, Item Sub-category, Business unit |
| View scope | Center, Organization |
Common uses:
- Track sales completed within a date range by payment method.
- Reconcile online payments with bank deposits (use alongside the Digital Payments report).
- Identify items sold without payment (use the Sales-Accrual report for those).
Note: The Sales-Cash report does not consider pending amounts in open invoices as sales. If any payment is received, all associated items show in the report; if no payment is made, all items are excluded.
Filters
| Filter | Description |
|---|---|
| Level of detail | Item β item-level payments collected cumulatively on the payment day. Item for each Payment β item level for each payment collected on the day. |
| Sale Type | Sale β sales completed with cash equivalent payment types (excludes dues). Redemption β sales completed with gift cards, packages, memberships, prepaid cards, or loyalty points. Refund β refunds regardless of payment type. Charges β no-show, cancellation, freeze fee, and setup fee. |
| Sale Date | Date the payment was processed and recorded. |
| Centers | Centers where payments were collected. |
| Zones | Search by zone or location group. Visible only if the Enable Location groups setting is on. |
| Item Type | Service, product, package, membership, gift card, or prepaid card. |
| Payment Type | Cash, credit card, debit card, check, custom payment types. The Sales Collected and Tax Collected columns update based on this filter. |
| Sold By | Employee who sold the item. Transactions without Sold By information are excluded unless Not specified is included. |
| Invoice Status | Pending, paid, overdue, disputed, or canceled. |
| Item Category | Category and sub-category associated with the item type. Transactions without these defined are excluded unless Not specified is included. |
| Sub Category | Category and sub-category associated with the item type. Transactions without these defined are excluded unless Not specified is included. |
| Business Unit | Business unit to which the item belongs. |
Columns
Default columns, in the order they appear in the report:
| Column | Description |
|---|---|
| Sale Date | Date payment was received or liability was redeemed. |
| Invoice# | Invoice number for the appointment or POS transaction. |
| Guest Code | Internal code identifying the guest. |
| Guest Name | Guest associated with the invoice. |
| Center Code | Internal code identifying the center. |
| Center Name | Center where the transaction occurred. |
| Item Code | Internal code identifying the item sold. |
| Item Name | Name of the item sold. |
| Qty | Quantity of items on the invoice. |
| Sales Collected (Exc.Tax) | Amount collected from the guest excluding tax. For redemption sales, this reflects the redemption amount. |
| Tax Collected | Tax collected on the item. For redemption, this displays tax paid for the item via redemption. |
| Sales Collected (Inc.Tax) | Amount collected including tax. If the item was purchased using a liability already taxed at the time of purchase, the additional tax applied is zero. |
| Redeemed | Amount redeemed using liabilities (memberships, prepaid cards, etc.). |
| Collected to Date | Cumulative amount collected to date across all payment methods. |
| Collected | Amount paid by cash, card, check, or custom payment types. |
| Item Subcategory | Sub-category associated with the item. |
| Invoice Source | Source through which the invoice was created. |
Optional columns
These can be added to the report and, per the Tips below, can accommodate up to 100 characters:
| Column | Description |
|---|---|
| Invoice Date | Date the invoice was created. |
| Invoice For | Purpose of the invoice (Sale, Dunning, Upgrade, Downgrade, Transfer for memberships; empty for other sales). |
| Receipt# | Auto-generated number assigned when the invoice is closed. Open invoices show 0. |
| Payment# | Auto-generated number for the payment transaction. |
| Item Category | Category and type of the item. |
| Item Type | Category and type of the item. |
| Discount Name | Discount applied (Price adjusted, Manual Discount, Waive Off, campaign or membership discount). When multiple promotions apply, all names appear. |
| Discount | Total discount applied, including package and membership redemptions. If loyalty points are non-taxable, LP redemptions are treated as discounts and reflected here. |
| Payment Type | Payment method used. |
| Room | Room and equipment for service items; blank otherwise. |
| Equipment | Room and equipment for service items; blank otherwise. |
| Closed By | Employees who closed, were credited with the sale, and created the invoice. |
| Sold By | Employees who closed, were credited with the sale, and created the invoice. |
| Created By | Employees who closed, were credited with the sale, and created the invoice. |
| Status | Open or Closed. |
| Invoice Notes | Notes added by staff. |
| Tip | Tip paid by the guest. |
| SSG | Support Staff Gratuity paid. |
| Referral Source | How the guest was referred. |
| Referred By | How the guest was referred. |
| Member | Whether the guest is an active member; whether this is the guest's first visit. |
| First Visit | Whether the guest is an active member; whether this is the guest's first visit. |
| Base Invoice# | Original invoice number for the refunded item. |
| Business Unit | Business unit, sales channel, product vendor, and brand. |
| Sale Type | Business unit, sales channel, product vendor, and brand. |
| Vendor | Business unit, sales channel, product vendor, and brand. |
| Brand | Business unit, sales channel, product vendor, and brand. |
| GST sequence # | GST sequence number and GSTIN of the center. Visible only when Level of detail is Item for each payment. |
| GSTIN | GST sequence number and GSTIN of the center. Visible only when Level of detail is Item for each payment. |
| Bundle name | Name of the bundle for items belonging to a bundle. Contact your Customer Success Manager if this column is missing. |
| Display name | Guest details. |
| Gender | Guest details. |
| Nationality | Guest details. |
| PAN Provided? | Whether the guest has submitted PAN details. |
| Refund Reason | Reason recorded for issuing a refund. |
| TIN # | Taxpayer Identification Number, Turnover Tax Number, and Value-Added Tax number. |
| TOT # | Taxpayer Identification Number, Turnover Tax Number, and Value-Added Tax number. |
| VAT # | Taxpayer Identification Number, Turnover Tax Number, and Value-Added Tax number. |
| Card Surcharge | Extra fee for card payment. |
| Tax on card surcharge | Tax on the card surcharge. |
| Tax redeemed by loyalty points | Tax paid via LP or gift card. Visible only when tax-inclusive pricing is enabled. |
| Tax redeemed by gift card | Tax paid via LP or gift card. Visible only when tax-inclusive pricing is enabled. |
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 setting is disabled by default.
When the setting is enabled, if its Value checkbox is not selected, the Value column (left side) and Sales Realized column (right side) are not shown in this report.
Note: This behavior applies to the Sales-Cash report alongside the Cross-Center Settlement report, Royalty v2 report, Collections report, Sales Tax report, Sales-Accrual report, Master Center Metrics report, and Business KPI report. For report settings, see Configure report settings.
Tips
- Optional columns can accommodate up to 100 characters.
- If the report includes more than one year of data, click Email to receive the export by email.