Cross Center Redemptions: Accounting Report

Table of Contents

Overview

Navigation

Filter Criteria

Column Descriptions

 

Overview

The center level Cross Center Redemptions report helps to settle balances across centers - it displays the monetary value that a center should collect or pay to other centers. It provides detailed information on redemptions for memberships, packages, pre-paid cards, gift cards and loyalty points.

Use this report to track the following:

  • Amount to collect: Track the total amount your center should collect from other centers in your organization.
    Example: A guest purchases a $500 gift card from center B and redeems it for a service worth $200 at center A (your center). If the report is being viewed at your center, then your center needs to collect $200 from center B.
  • Amount to pay: Track the total amount your center should pay to other centers in your organization.
    Example: A guest purchases a $500 gift card from center A (your center) and redeems it for a service worth $200 at center B. If the report is being viewed at your center, then your center needs to pay $200 to center B.

Note: The report will not show any cash payments that were rendered to complete a payment in the POS.

 

Navigation

Follow these steps to run the report:

  1. Ensure you are at the center level.
  2. On the main menu, click the Admin tab.
  3. On the Admin Dashboard, click Reports > Accounting.
  4. On the Accounting Reports page, from the reports list, select the Cross Center Redemptions report.
  5. Click Refresh to see the report. To export the report, on the top right side of the report, click the Excel or .CSV icons.


Filter Criteria

Criteria Options Description

Payment Type

By Revenue

 

By Payment

Note: The By Revenue and By Payment filter options show different numbers only if your organization sells items that have different selling price and value. For example, you could sell a Gift Card at $100 but give it a redemption value of $200. In other cases, both these filter options show the same values.

By Revenue: When you select this option, the report calculates the amount you owe or need to collect from other centers based on the purchase Price (not it’s value) of the item that the guest redeems.

For instance, a guest purchases a prepaid card at another center for a price of $100 and value $200. The guest can now use this card to redeem a service or product worth $200 at your center based on its value. However, when you select the By Revenue option, the money that the other center owes you is calculated as a proportion of the purchase price as follows: (Price/Value) * Redemption

Example:
If the guest redeems the card for a service worth $150 at your center, you do not get to collect the full $150 from the other center, but only (100/200) * 150, which is $75 of the price.

 

By Payment: When you select this option, the report calculates the amount you owe or need to collect from other centers based on the value of the item that the guest redeems. Value is extra credit added to the price on the purchase of the membership, prepaid card or gift card.

For instance, a guest purchases a prepaid card at another center for a price of $100 and value $200. The guest can now use this card to redeem a service or product worth $200 at your center based on its value. When you select the By Payment option, the money that the other center owes you is calculated based on the value of the item.

Example:
If the guest redeems the card for a service worth $150 at your center, you get to collect the full redemption amount of $150 from the other center.

Date

1 Month,

2 Months,
3 Months,
6 Months,
Custom

From the drop-down list, select either 1, 2, 3, 6 months or custom.
You can alternatively choose Custom from the list and specify custom dates in the From and To fields.
Note: For custom dates, you can view data for a maximum date range of 6 months at a time.

 

Column Descriptions

Column Description

Code

The center code number

Center

The name of the center

Payment modes – membership, membership service, package, gift card, pre-paid card, loyalty points

  • To collect: Displays the total amount your center should collect from other centers.
    Example: A guest purchases a $500 gift card at center B and later redeems it for services worth $200 at center A (your center). Now, your center needs to collect $200 from center B.
  • To Pay: Displays the total amount your center should pay to other centers within an organization.
    Example: A guest purchases a $500 gift card at center A (your center) and later redeems it for services worth $200 in center B. Now, your center needs to pay $200 to center B.

Total

  • To collect: Displays the total amount your center should collect from other centers within an organization. Click on the amount link to view:
    • Name of the center(s) from which you need to collect payment
    • Redemptions made at other centers using various payment modes – gift cards, prepaid cards, memberships, loyalty points etc.
    • Total amount to collect against each payment type
  • To Pay: Displays the total amount your center should pay to other centers within an organization. Click on the amount link to view:
    • Name of the center(s) to whom you need to make payment
    • Redemptions made at your center using various payment modes – gift cards, prepaid cards, memberships, loyalty points etc.
    • Total amount to pay against each payment type

Net to collect

Displays the net cross center redemption collection amount that is calculated as follows: (Total to collect - Total to pay amount)

 

Have more questions? Submit a request

Comments

Powered by Zendesk