Collections by Transactions 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.
The Collections by Transactions report lists the individual payment transactions collected across your business, so you can see how much was collected, when, by whom, and through which payment method.
Where to find it
Open the Reports dashboard, type the report name in Search Report, and select Collections by Transactions. Classic reports appear on the Reports Dashboard only when they are enabled under Configuration > Reports > List of reports (Reports V1).
Filters
Use the filters available on the report page to narrow the results, such as date range and center, before running the report.
Columns
| Column | What it shows |
|---|---|
| CenterCode | The code of the center where the transaction was processed. |
| CenterName | The name of the center where the transaction was processed. |
| Receipt No | The receipt number for the transaction. |
| TransactionNo | The transaction/payment number. |
| Invoice Date | The date the invoice was created. |
| InvoiceCenterCode | The code of the center the invoice belongs to. |
| InvoiceCenterName | The name of the center the invoice belongs to. |
| PaymentType | The method used for payment (for example, cash, card, or check). |
| PaymentDate | The date the payment was collected. |
| PaymentAmount | The base payment amount collected. |
| Payment Amount(Inc. Tip/SSG) | The payment amount including any tip or service charge, where applicable. |
| Tip | The tip amount collected, where tips are enabled for your organization. |
| SSGAmount | The service charge (SSG) amount collected, where service charges are enabled for your organization. |
| OtherFeeAmount | Any environmental or other additional fee collected, where enabled for your organization. |
| CashBackAmount | The cash-back amount given, where cash back is enabled for your organization. |
| Total | The total amount collected for the transaction. |
| CardNumber | The masked card number used for payment, if applicable. |
| CardInvoiceNo | The card processor's reference number for the transaction, if applicable. |
| CardBankName | The issuing bank of the card used, if applicable. |
| CardExpiry | The expiry date of the card used, if applicable. |
| Bank A/C Number | The bank account number used for payment, if applicable. |
| CheckNumber | The check number, if payment was made by check. |
| CheckBankName | The bank name on the check, if payment was made by check. |
| CheckDate | The date on the check, if payment was made by check. |
| CustomName | A custom label associated with the payment, if applicable. |
| Additional Data | Any additional payment details recorded. |
| MembershipName | The name of the membership used for payment, if applicable. |
| GiftCardCode | The gift card code used for payment, if applicable. |
| PrePaidCardCode | The prepaid card code used for payment, if applicable. |
| LPProgramName | The loyalty program used for payment, if applicable. |
| Tax Applied | The tax amount applied to the transaction. |
| Collected By | The staff member who collected the payment. |
| CashRegister | The cash register or till the payment was processed through. |
| Paid Currency | The currency the payment was made in, shown when your center accepts payments in multiple currencies. |
| Conversion Rate | The exchange rate applied to the payment, shown when your center accepts payments in multiple currencies. |
| Paid Currency Amount | The payment amount in the currency actually paid, shown when your center accepts payments in multiple currencies. |
| Comments | Any comments recorded against the invoice. |
| GST Sequence Number | The GST sequence number for the transaction, shown when GST columns are enabled for your organization. |
Columns shown in specific views
Some columns only appear depending on your organization's settings:
- Tip, SSGAmount, OtherFeeAmount, CashBackAmount appear only when the related feature (tips, service charge, environmental fee, or cash back) is turned on for your organization.
- Paid Currency, Conversion Rate, Paid Currency Amount appear only when your center accepts payments in more than one currency.
- GST Sequence Number appears only when GST columns are turned on for your organization.
Good to know
- The Invoice No, Guest Code, and Guest Name columns are not shown as plain text β instead, the invoice number and guest name appear as clickable links you can use to open the related invoice or guest profile directly.
- The "Payment Amount(Inc. Tip/SSG)" column label may adjust slightly depending on which of Tip or service charge apply to a given transaction, but the underlying amount is always shown.
- Column headings on this report reflect the underlying field names and are not renamed to match any custom labels your organization may use elsewhere.