Collections report (v2)

Disclaimer

This article is only for the latest version of Zenoti Reports. Do not compare the data in this version with the data in the previous version.

Zenoti's Collections report enables businesses to manage and reconcile their business finances effectively. This report is for businesses following accrual-based accounting. Here are the specific capabilities and actions you can perform using the Collections reports:

Accountants can track all payments received, including the source and timestamp of all payments. This is crucial for maintaining accurate financial records and ensuring all transactions are accounted for.
By comparing the payments received (as shown in the report) with the deposits made in the bank, accountants can ensure that all collections are accurately recorded and deposited.
Accountants can reconcile the Collections Report with the Sales-Accrual Report to understand the differences between sales and collections. This is important for businesses that use accrual-based accounting, as it helps distinguish between the revenue earned and the cash flow.
Businesses can check when liabilities such as membership credits, packages, gift cards, and loyalty points have been redeemed. This helps in tracking the usage of prepaid services and benefits.
The Collections report provides information on the amounts that are still owed by clients. This allows businesses to follow up on outstanding payments and manage their accounts receivable effectively.
The Collections report indicates which employee last closed the invoice, providing insights into employee performance and accountability in handling transactions. Additionally, the report also shows which cash register was used for each transaction, helping businesses manage and audit cash flows through different points of sale.

At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Collections report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you generate the report for over a year, click the Email button.

Column descriptions

The following table describes columns in the collections v2 report.

Column Name	Short Description	Details and Examples
Collection Date	Date on which the payment was received from the guest.	Date on which the payment was received, the amount was refunded, or liability was redeemed
Invoice#	Invoice number generated for the sale or service.	Number generated for the appointment or point of sale entry
Guest Name	Name of the guest who made the payment.	Full name of the guest associated with the transaction, captured from their profile for tracking and reporting.
Center Name	Center where the payment was collected.	Center in which the payment was collected
Liability Center	Center where the liability was originally sold.	Center in which the liability was sold You will see a center name in this column only when the Payment Type is Redemption (Membership Credits, Membership Benefits, Packages, Gift Cards, Prepaid Cards, Loyalty Points).
Tax Collected	Tax amount paid by the guest on this transaction.	The total tax amount paid by the guest as part of the transaction, including any applicable service or product taxes.
Payment Type	Payment method used by the guest such as cash, card, gift card.	The specific payment method selected by the guest to complete the transaction — for example, cash, credit/debit card, gift card, or membership credits.
Amount Paid	Amount paid or liability redeemed for this item.	The exact monetary value paid by the guest or redeemed from a liability such as gift card or membership, for a specific item on the invoice.
Total Paid	Total amount collected or redeemed across all items in the invoice.	Total amount paid or redeemed for the items on the invoice up cumulated till that payment date.
Due	Amount still due from the guest for the invoice.	Amount that is yet to be received from the guest.
Tips	Amount paid by the guest as a tip.	Amount paid by the guest towards tips.
Support staff gratuity	Gratuity paid by the guest for support staff.	Amount paid by the guest towards Support Staff Gratuity (SSG)
Cashback	Cashback amount paid to the guest.	Amount paid to the guest as cashback for the transaction.
Card Number	Card number used for the transaction.	Card number provided for the transaction
Card Type	Type of card used such as, Visa, MasterCard.	Type of card used for the transaction
Card Invoice No	Reference number or receipt ID for the card payment.	For offline card payments, this is the receipt number for the payment done using a card terminal.
Card Bank Name	Name of the bank associated with the card.	For offline card payments, the bank name entered for the card payment.
Card Expiry	Expiry date of the card used.	For offline card payments, this expiry date is as per the card.
Check Number	Number on the check used for payment.	Check number entered for the transaction.
Check Bank Name	Bank name printed on the check used.	The name of the bank printed on the guest's check used for payment.
Check Date	Date written on the check used for payment.	The date mentioned on the guest's check, indicating when the payment was issued.
Custom Name	Name of the custom payment method used.	Name of the custom payment used for the transaction
Additional Data	Extra info associated with the custom payment method.	Additional custom data associated with the selected payment method; often used for reference or audit purposes in custom payment types.
Comments	Notes or remarks entered on the invoice.	Comments entered by the staff on the invoice for internal reference.
Collected By	Employee who received and closed the payment.	Name of the staff member who finalized the invoice by collecting the payment and closing the transaction.
Cash Register	Register where the transaction was recorded.	Cash register on which the transaction was performed.
Gender	Gender identity of the guest.	Gender identity of the guest, as recorded in the system for demographic or personalization purposes.
Nationality	Guest's country of citizenship.	Country of citizenship of the guest.
Guest Code	System-generated identifier for the guest.	A unique system-generated identifier automatically assigned to each guest profile for internal tracking and integration purposes.
Center Code	Internal identifier assigned to the center.	The unique internal identifier automatically assigned to each center, used for reporting and system operations.
Reading Mode	Mode used to read the card such as, swipe, chip, tap, manual.	Describes how the card was read during the transaction — such as swiping, dipping, tapping, or manual key entry — for audit and fraud analysis.
ESF	Indicates if the payment was processed using Easy Split Financing.	Indicates whether the payment was processed through the Easy Split Financing option, enabling guests to pay in installments.
Card Surcharge	Extra fee charged for using card as the payment method.	Additional fee applied when a guest chooses a card-based payment method, typically covering processing costs.
Collected By Code	Unique code for the staff member who collected the payment.	Unique employee code of the staff member who closed the transaction, used for reconciliation and accountability.
Invoice Status	Current status of the invoice at the time of payment such as, Paid, Unpaid.	The current financial status of the invoice — such as Paid, Partially Paid, or Unpaid — at the time of report generation.
Invoice Closed Date	Date on which the invoice was closed.	The exact date on which the transaction invoice was marked as complete or fully paid and officially closed in the system.

The Sales-Accrual report is based on the sale date, while the Collections report is based on the payment date. Moreover, the Sales-Accrual report shows the sales of each item on an invoice, and the Collections report shows each payment on an invoice.

The table lists the columns that are compared in the two reports, and the scenarios when these columns can and cannot be compared.

Sales - Accrual report	Collections report	Compare	Do not compare
Column: Sales (Inc. Tax)	Column: Amount Paid	NA	Invoices with a different sale date and full payment date. Reason Sales-Accrual is based on the sale date and collections are based on the payment date.
Column: Collected Filter: No specific filter	Column: Amount Paid Filter: Payment type Options: Cash, Card, Check, Custom	Invoices with the same sale date and full payment date.	Invoices with a different sale date and full payment date. Reason Amount Paid is based on the payment date, whereas Collected is based on the total amount collected for an item till the current date.
Column: Redeemed Filter: No specific filter	Column: Amount Paid Filter: Payment Type Options: Gift Card, Prepaid Card, Membership, Packages, Loyalty Points	Invoices with the same sale date and full redemption date.	Invoices with a different sale date and full redemption date. Reason Amount Paid is based on the payment date or redemption date, whereas Redeemed is based on the total amount redeemed for an item till the current date.

In this section:

Collections report (v2)

Disclaimer

Search results