Reconciliation for Packages

Modified on Tue, 9 Sep at 7:55 AM

The reconciliation process for packages occurs when the package was purchased at one franchise but used at another. This article will walk through the process of configuring reconciliation for packages.

Things to Know:

To activate the reconciliation feature, follow the steps provided here
Source Location: Where the membership was originally purchased
Destination Location: Where the membership was redeemed/used
Reconciliation %: The percentage of the item value (service, product, class) to be transferred from the source to the destination location.
Reconciliation records are automatically generated when a ticket is closed, as long as the reconciliation feature is active at the time of closing.
All reconciliation data is captured in the Reconciliation Detailed Report
Reconciliation for packages is based on the source location's package item price x adjustment rate.
Package item price refers to the per-item cost within a package. It is calculated by dividing the group price by the quantity of items in that group. Example:
- Group price: $350
- Quantity: 5
- Package item price: $350 ÷ 5 = $70

Configuration

Reconciliation % of the price to transfer

5% of services
30% of products
20% of classes

Per Item Price on Package Configuration

Service: $350 ÷ 5 = $70 per service
Product: $200 ÷ 5 = $40 per product purchased
Class: $150 ÷ 5 = $30 per class enrolment

Example:

A client purchases a package at Franchise 1 and redeems it at Franchise 2 for services, classes, and products.

Service price: $70

Class price: $30

Product price: $40

Reconciliation Calculation

The percentage that will be transferred from Franchise 1 to Franchise 2 will be based on the per-item price from the package of each group:

The price for the service on the ticket is $0 since the service is included in the package.
Service - 5% x $70 =$3.50
Product - 30% x $40 = $12
Class - 20% x $30 = $6

Total to be transferred - $3.5 + $12 + $6 =$21.50

This information can be seen in the Reconciliation Detailed Report which can be accessed by going to Dashboard > Reports > Reconciliation Detailed Report.

Related Articles: