Collections by Invoices Financial report
The Collections-Invoices report provides you details of all the collections from sales of all the items (services, products, memberships, packages, prepaid cards, and gift cards) made at your center during a specified time period. The collection details include the invoice number, amount collected from each of the payment types (cash, card, check, and custom) and redemption details of memberships, gift cards, prepaid cards, and loyalty points.
Make sure you have selected the center for which you want to run the report.
On the Main menu, click the Reports tab.
On the Reports Dashboard, click Finance > Collections (from filter).
From the list of reports, click Collections by Invoices. The report opens in a new tab.
Make your selections in the Filter Criteria and click Refresh.
The report opens.
To export the report, on the top right side of the report, click the Excel OR CSV icon.
Filters
Criteria | Options | Description |
|---|---|---|
Invoice Status | All Invoices, Open, Closed, | Select All Invoices to view collections of both open and closed invoices. To view collections of either open or closed invoices, select either Open and Closed. |
Custom Payments | All Custom Payments, List of Custom Payments | Select All Custom Payments to view all types of Custom Payments. To view collection details of a particular Custom Payment, select that payment from the list. |
Time Period | Today, Last 7 days, Last 14 days, 1 Month, 2 Months, 3 Months, 6 Months, Custom | Based on your requirement, from the drop-down list, select either today, last 7 or 14 days, 1, 2, 3, or 6 months. You can alternatively choose Custom from the list and specify custom dates. NoteFor custom dates, you can view data for a maximum date range of 6 months at a time. Example: If you wish to see data from January to August, first view data from January to June and then view data from July to August. |
Guest Name, Mobile, Email, Code | Leave this field blank to view collections from all guests. To view collections from a specific guest, enter either the guest name, mobile number, email address, or the guest code. | |
Show tax components | Select this option to show the segregation of taxes. NoteThis option is relevant to centers in Asia. | |
Show CC Types | Select this option if you wish to see the types of cards used (such as Mastercard, Visa) in the Collections section. | |
Show taxes based on collections | Select this option to display the tax portion of the collected amount. |
Column descriptions
Column | Description |
|---|---|
Invoice No | The invoice number. Clicking the invoice number opens the invoice details. |
Guest Code | The unique identifier associated with the guest. |
Guest Name | The name of the guest who made the purchase. Clicking the guest's name opens the guest's profile. |
Receipt No | The receipt number generated when the invoice was closed. NoteIf the invoice is open, no receipt number is generated. |
Invoice Date | The date on which the invoice was created. |
Payment Date | The date on which the payment was collected. |
Service Total | The price of the purchased service before any applicable taxes or discount. |
Product Total | The price paid for the purchased product. |
Membership Total | The price paid for the purchased membership. |
Package Total | The price paid for the purchased package (series or custom). |
Gift Card Total | The price paid for the gift card or prepaid card. |
Total Sale | The invoice final amount. |
Total Tax | The tax on the invoice. |
Promotion | The promotion name (if the item was sold as part of a promotion). NoteIf the front office gave a manual discount on an invoice, this field shows "Manual Discount" as the entry and not a promotion name. |
Package Redemption | The name of the package redeemed for the item. |
Discount | The total amount given as a discount on the invoice (manual discount or campaign). |
Membership Redemption | The amount paid for the item using membership credits. |
Loyalty Points Redemption | The amount paid for the item using loyalty points. |
Gift Card Redemption | The amount paid for the item using a gift card. |
Cashback | The amount paid for the item using a cashback coupon. |
Total Deductions | The total amount offered as discount or redemptions on the invoice. |
To-be Paid | The total amount to be collected from the guest. |
Rounding Adjustments | The amount (in decimals) that is rounded off to help a guest pay the exact amount. |
Shipping Charge | The charge levied for shipping a product to the guest. This is applicable for retail purchases made online. |
Cash | The amount paid for the item using cash. |
Card | The amount paid for the item using a card. NoteIf you have selected show CC types in the filter criteria, you will additionally see each of the credit card type columns (example, Amex, Mastercard, Visa, etc.) and the amount collected against each of them. |
Check | The amount paid for the item by means of a check. |
Membership | The amount (in equivalent membership credits) deducted from the price paid for the item (before adding any applicable taxes and discounts). |
Gift Card | The amount from the gift card deducted from the price paid for the item (before adding any applicable taxes and discounts). |
Loyalty Points | The amount (in equivalent loyalty points) deducted from the price paid for the item (before adding any applicable taxes and discounts). |
Custom | The amount paid for the item using custom payment. |
Custom Payment Commission | The calculated commission amount to be paid the custom payment provider. |
Total Paid | The total amount collected via cash, card, check, and custom payments. |
Due | If partial payment or no payment is made, this field reflects the amount that you must collect from the guest. |
Comments | Helpful suggestions or comments about the guest or transaction added by the front office. |
Tips | The amount paid by guests as tips. |
SSG | The amount paid by guests as Suggested Staff Gratuity (SSG). |
Center | The center in which the collection was made. |
Referral Source | The referral source selected by the front office during the guest profile creation. For example, Advertisement. |
Referred By | The name of the referrer. This is available only if the Referral Source is Guest. |
Referrer Code | The unique identifier associated with the referring guest. |