Collections by item report (v1)
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Deprecated: This is a legacy report. Businesses that have signed up with Zenoti after April 2022 do not have access to this report.
Audience: Finance admin, center admin
The Collections by item report (v1) lists every payment received against every item sold at a center over a date range. Each row represents one item line on one invoice, with the payment broken out by tender β cash, card, check, or custom β alongside pre-tax collection, tax, and total collection. Use it to reconcile cash drawer totals against item-level sales, audit collections against a specific category or invoice, or export item-level revenue for finance.
This is a legacy report under Zenoti's classic reporting framework. Businesses that signed up with Zenoti after April 2022 do not have access to it.
Current alternatives: For an item-type rollup, see Collections by item type report. For a tender-level view, see Collections by payment type report. For an employee-pivoted item-type rollup, see Employee collections by item type report.
Data refresh: Real-time on Refresh. Values reflect collections recorded at the moment of click.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- How payment columns are populated
- Notes and limitations
- Tips
- Troubleshooting
- Related articles
Before you begin
- Your organization must have been onboarded before April 2022 for this legacy report to be available. Newer organizations do not have access to it.
- Enable the report at the organization level under Configuration > Reports > List of reports. The toggle is the
Show old reportsflag against this entry.
Permission: This classic report is controlled by View Admin Reports in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions). Select the report-area action that applies to this report (for example Collections). Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.
Note for businesses in India: Payments made by redeeming memberships, gift cards, prepaid cards, and loyalty points appear in the report only when the GST India organization setting is enabled. Without GST India enabled, these redemption-funded items show zero in the redemption columns.
Run the report
- Select the center for which you want to run the report.
- Navigate to Reports.
- In the search box, enter Collections by Item. Alternatively, expand Finance > Collections and select Collections by Item from the list.
- Set the date range and any additional filters listed in Filter reference.
- To break the Tax column out into individual tax components, select Show tax components.
- Click Refresh.
To export the report, click the Excel or CSV icon above the result grid.
Note on date range: The date filter anchors on collection date β the date the payment was received β not the invoice date. An invoice raised in March and paid in April surfaces under an April date range.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by collection (payment) date, not invoice date. |
| Center | One or more centers | Restricts to centers the user has access to. |
| Sale Type | Service / Product / Membership / Package / Gift Card / Prepaid Card | Multi-select. Limits rows to the selected item categories. |
| Payment Type | Cash / Card / Check / Custom / Membership / Gift Card / Prepaid Card / Loyalty Points | Multi-select. Limits rows to payments made using the selected tender. |
| Invoice Status | Open / Closed | Limits to invoices in the selected status. Open invoices still show partial collections. |
| Show tax components | Checkbox | When selected, expands the Tax column into one column per configured tax component plus a Total Tax column. |
Note: Item Tags, Business Unit, Category, and Sub Category are output columns (see Column reference). They are not exposed as input filters in this report. To slice by those dimensions, export to Excel or CSV and filter in the spreadsheet.
Column reference
| Column | Type | Description |
|---|---|---|
| Invoice No | Identifier | Invoice on which the item was sold. |
| Guest Code | Identifier | Unique code that identifies the guest. |
| Guest Name | Text | Guest who purchased the item. |
| Guest Mobile | Text, conditional | Guest's mobile number. Appears only when your organization has this enabled in report settings. |
| Receipt No | Identifier | Generated when an invoice is closed after full payment. Blank for open invoices. |
| Zone | Text | Zone to which the center belongs. |
| Center Code | Identifier | Unique code that identifies the center. |
| Center | Text | Center in which the collection was recorded. |
| Date | Date | Date on which the payment was collected. |
| Gender | Text | Guest's gender. |
| Employee Code | Identifier | Unique code that identifies the employee who sold the item. |
| Employee Name | Text | Employee who sold the item. |
| Employee Job Code | Identifier | Unique job code associated with the employee. |
| Item | Text | Item type β Service, Product, Membership, Package, Gift Card, Prepaid Card, Class, or Workshop. Shows (No Show) when the linked appointment was cancelled or marked as a no-show. |
| Item Code | Identifier | Unique code that identifies the item. |
| Item Name | Text | Display name of the item. |
| Item Tags | Text | Tags configured against the item. |
| Business Unit | Text | Business unit to which the item belongs. |
| Category | Text | Category to which the item belongs. |
| Sub Category | Text | Subcategory to which the item belongs. |
| Cash | Currency | Portion of the item's payment received in cash. |
| Card | Currency | Portion of the item's payment received via card. |
| Online Banking | Currency | Portion of the item's payment received via online banking. |
| Check | Currency | Portion of the item's payment received via check. |
| Custom | Currency | Portion of the item's payment received via any custom payment type. |
| Loyalty Points | Currency | Value of loyalty points redeemed against the item. |
| Membership | Currency | Membership value redeemed against the item. |
| Gift Card | Currency | Gift card value redeemed against the item. |
| Pre-Paid Card | Currency | Prepaid card value redeemed against the item. |
| Collections Pre Tax | Currency | Amount collected for the item across all tenders, before tax. |
| Tax | Currency | Total tax collected for the item across all tenders. |
| Total Collection | Currency | Collections Pre Tax + Tax. |
| Gross Invoice Value | Currency | Invoice value including tax, before applying discounts or redemptions. |
| Invoice Discount | Currency | Discount applied to the invoice (gross value minus net value). |
| Net Invoice Value | Currency | Gross Invoice Value - Invoice Discount, including tax. |
| Payment No | Identifier | Number generated per payment. Populated only when the center has Generate unique number for every payment enabled. |
| Invoice Center Code | Identifier | Unique code that identifies the center in which the invoice was generated (may differ from the collection center for cross-center invoices). |
| Invoice Center | Text | Name of the center in which the invoice was generated. |
| Item Quantity | Number | Quantity entered against the item at point of sale. Shown as a negative number for refunds and voided items. |
| Item Sale Price | Currency | Item price after discounts and redemptions are applied at the line level. |
| Item Discount | Currency | Total amount given as a discount (manual or campaign) on the line. |
| Invoice Date | Date | Date on which the invoice was created (distinct from the collection Date above). |
| Tip | Currency, conditional | Tip amount recorded for the item. Appears only when tips are enabled, and may carry a custom label your organization has configured. |
| SSG | Currency, conditional | Service charge recorded for the item. Appears only when enabled, and may carry a custom label your organization has configured. |
| SAC/HSN | Identifier, conditional | GST SAC/HSN code for the item, where applicable. |
| Invoice Sequence No | Identifier, conditional | Invoice sequence number. Appears only for organizations with GST enabled. |
| Tax Components | Currency, conditional | Appears as one column per configured tax component when Show tax components is selected; otherwise hidden. |
| Total Tax | Currency, conditional | Sum across all tax components. Appears when Show tax components is selected. |
Columns shown in specific views
- If your organization uses custom fields (Service Entities), additional columns carrying those custom field values appear after the Zone column.
- Selecting Show tax components switches the grid to a view with a per-row tax breakdown and an additional total tax column. A few column names also render slightly differently in that view.
How payment columns are populated
The Cash, Card, Online Banking, Check, and Custom columns split a single item's collection by tender. Each row represents one line on one invoice; when guests split a payment across multiple tenders, one row can carry non-zero values in several of these columns.
Redemption-funded portions have their own columns β Loyalty Points, Membership, Gift Card, and Pre-Paid Card. For businesses in India, these columns are populated only when the GST India organization setting is enabled; without it, redemption-funded items show zero in those columns.
Reconciliation note: Because the report attributes payments to the items they paid for, the sum of the tender columns per invoice equals Total Collection for that invoice. It does not equal Net Invoice Value when the invoice is still partially paid or carries an outstanding balance.
Notes and limitations
- Open invoices appear with a blank Receipt No. Partial collections on an open invoice still surface as rows; the receipt number populates only when the invoice closes.
- Tax components are configuration-dependent. The columns added by Show tax components match the tax structure configured for your organization. A center with no tax components configured sees only the consolidated Tax column even with the checkbox selected.
- Cross-center invoices are surfaced via Invoice Center. The Center column shows where the collection was received; the Invoice Center column shows where the invoice was generated. They differ when a guest pays at one center against an invoice raised at another.
- No item-level filter for Category, Sub Category, Item Tags, or Business Unit. Those dimensions are in the output but not in the input filter set. Export to a spreadsheet and filter there.
- Performance. Large date ranges with Show tax components enabled produce wide result sets. Run weekly or monthly slices for high-volume centers and aggregate offline.
Tips
- Reconcile to the register closure. Cross-check the Cash column total against the Daily Petty Cash and Register Closure reports for the same date range to surface drawer mismatches at the item level.
- Verify discount attribution. When auditing campaigns, compare Item Discount in this report against the campaign performance data β discounts that hit the invoice header rather than the line item appear in Invoice Discount, not Item Discount.
- Use Show tax components for tax-audit prep. Export with Show tax components selected to produce a per-line tax breakdown auditors can reconcile against the Taxes collected report.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report does not appear under Finance > Collections | The organization was onboarded after April 2022, or the Show old reports toggle for this entry is off. | Confirm the onboarding date with your Zenoti representative. If the organization is pre-April-2022, enable Show old reports for this entry under Configuration > Reports > List of reports. |
| Permission denied opening the report | The user role does not carry View Admin Reports (with the report-area action that applies, for example Collections) in the Administrator section of the security role. | Grant the permission in the security role. |
| Redemption columns are all zero on a redemption-funded row | The item was paid entirely via membership, gift card, prepaid card, or loyalty redemption, and GST India is not enabled for the organization. | Cross-check the payment against the Transaction details report to confirm the redemption was recorded; for businesses in India, verify GST India is enabled. |
| Tax components do not appear after selecting Show tax components | The organization has no tax components configured, or Refresh was not clicked after selecting the checkbox. | Click Refresh after toggling. If the columns are still missing, confirm tax components are configured for the organization. |
| Totals do not match another collections report | Collections reports differ in how redemptions and cross-center invoices are attributed, and in the date anchor they use. | Re-run both reports with the same date anchor and identical Invoice Status filter; remaining gaps usually trace to redemption attribution. |