Reconciliation for Packages

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 package was originally purchased
• Destination Location: Where the package 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
• Package Settlement Dependencies: Cross-location package settlements require both the source location (where sold) and the destination location (where redeemed) to have linked bank accounts. If either location is missing an account, the system skips the settlement pair entirely.
  • Missing Source Account: The system does not debit the source or pay the destination.
    Revenue remains with the source location that collected the initial funds.
  • Reporting: Displays as "Source ACH missing" on the Reconciliation Detail Report.
    
  • Missing Destination Account: The system does not debit the source or pay the destination.
  • Reporting: Displays as "Destination ACH missing" on the Reconciliation Detail Report.
  • Parent Fallback Reserve: The parent account fallback does not cover missing bank accounts. It activates exclusively when an automated debit attempt from an established source account fails or bounces.
    

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 enrollment

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:

• Reconciliation Setup
• ACH Fee for Reconciliation
• Configure Bank Account for Reconciliation
• Reconciliation for Gift Cards  
• Reconciliation for Memberships  
• Reconciliation Detail Report  
• Reconciliation Settlement Report
• Reconciliation Payout Mechanism
• Reconciliation Failure Notification Emails