ZenotiHelp

Collections by item report (v1)

ZTZenoti Docs Team Updated September 6, 2026 9 min readReference

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

  • 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 reports flag 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

  1. Select the center for which you want to run the report.
  2. Navigate to Reports.
  3. In the search box, enter Collections by Item. Alternatively, expand Finance > Collections and select Collections by Item from the list.
  4. Set the date range and any additional filters listed in Filter reference.
  5. To break the Tax column out into individual tax components, select Show tax components.
  6. 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.
Was this article helpful?
Your feedback helps us improve our documentation.