Financial Report: Collections by Invoices

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.

 

Table of Contents

 

Navigation

Follow these steps to run the report:

  1. Make sure you have selected the center for which you want to run the report. 

  2. On the Main menu, click the Reports tab.

  3. On the Reports Dashboard, click Finance > Collections (from filter).

  4. From the list of reports, click Collections by Invoices (General). The report opens in a new tab.

  5. Make your selections in the Filter Criteria and click Refresh.
    The report opens.

  6. To export the report, on the top right side of the report, click the Excel ()  or .CSV icons (). 

Filter Criteria

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.
Note: For 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.
Note: This 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.
Note: If 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 paid for the purchased service.
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).
Note: If 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.
Note: If 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.
 
Have more questions? Submit a request

Comments

Powered by Zendesk