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	Description
Collection Date	Date on which the payment was received, the amount was refunded, or liability was redeemed
Invoice#	Number generated for the appointment or point of sale entry
Guest Name	Name of the guest on the invoice
Center Name	Center in which the payment was collected
Liability Center	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 paid by the guest
Payment Type	Payment option that was used to pay for the item
Amount Paid	Amount paid or liability redeemed for the item
Total Paid	Total amount paid or redeemed for the items on the invoice up cumulated till that payment date.
Due	Amount that is yet to be received from the guest.
Tips	Amount paid by the guest towards tips.
Support staff gratuity	Amount paid by the guest towards Support Staff Gratuity (SSG)
Cashback	Amount paid as cashback for the transaction.
Card Number	Card number provided for the transaction
Card Type	Type of card used for the transaction
Card Invoice No	For offline card payments, this is the receipt number for the payment done using a card terminal.
Card Bank Name	For offline card payments, the bank name entered for the card payment.
Card Expiry	For offline card payments, this expiry date is as per the card.
Check Number	Check number entered for the transaction
Check Bank Name	Name of the bank on the check
Check Date	Date on the check
Custom Name	Name of the custom payment used for the transaction
Additional Data	Additional information for the custom payment
Comments	Comments entered on the invoice
Collected By	Employee who last closed the invoice
Cash Register	Cash register on which the transaction was performed
Gender	Gender identity of the guest.
Nationality	Guest's country of citizenship.

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