To view your Sales Reconciliation Report, click the App Drawer button then click View All > Reports > Enterprise Reports > Sales Reconciliation.

The Sales Reconciliation Report is an Enterprise report that displays details about purchases made at your business, as well as the amount received through your payment processor during the selected date range.

This report can be used to reconcile purchases made from your business with the actual money received through your payment processor. When the amounts don’t match, they’ll be highlighted in yellow for your convenience. Additionally, a red dot appears in the left-hand column when a discrepancy occurs and a green dot appears when no issues are found.

Unlike other reports, you don’t need to click through page numbers to find more information. Instead, you can keep scrolling to load additional entries for the report.

Business strategy insights: Why it’s valuable

The Sales Reconciliation Report is more than just a financial tracking tool—it provides valuable insights that can shape your overall business strategy. By comparing purchases with the actual amounts received through your payment processor, you can:

Strengthen financial accuracy – Quickly identify and resolve discrepancies to ensure your records always match your incoming payments.
Improve cash flow management – With accurate reconciliation, you’ll know exactly when and how much money is available for reinvestment in your business.
Enhance accountability – Highlighting mismatched amounts helps you spot errors, payment delays, or potential fraud before they impact your bottom line.
Support informed decision-making – Reliable financial data gives you confidence when planning promotions, adjusting pricing, or setting sales targets.

When used regularly, this report becomes an essential part of maintaining financial health, building trust with stakeholders, and setting your business up for sustainable growth.

Key tips

This report is only available to staff members at certain Enterprise Headquarters or Locations. If your business doesn’t have access to this report and you believe you should, contact your WellnessLiving representative.
This report combines data from several sources, including your payment processor. Because of this, transactions from the past few hours may be delayed, missing, or inaccurate. We recommend using this report to view transactions that are at least one day old.

Customize the Sales Reconciliation Report

To customize the Sales Reconciliation Report:

Change the appearance of the report by clicking the Density button, then selecting your desired spacing.

Change the columns displayed by clicking the Manage Columns button, then selecting and clearing checkboxes based on the columns you want to show and hide respectively. Alternatively, click Action > Hide column to hide an individual column.
- Sort the information in any column by clicking its name. Alternatively, click Action and select the desired sorting option or Unsort to sort by default.
- Change any column’s position by clicking-and-dragging the header to the desired spot.

Group information in the report to create custom reports that show you a sales summary by day, by location, and so on. You can create multiple groups together to obtain detailed, customized insights into your business. Create a group by clicking the Action button on a column, then selecting Group by [column name]. You can do this for all columns except Total Paid and Total Settlement.

Export the Sales Reconciliation Report

To export the Sales Reconciliation Report:

Click Export.
Select the file type you want to export: PDF, CSV, or Excel.
When your export is complete, you’ll receive an email with the file. Download the file from your email and open it in the appropriate program.

Refunded and voided purchases in the Sales Reconciliation Report

In the Sales Reconciliation Report, refunds and voids are displayed differently. Refunds create new rows, while voids update the original row. This makes it easier for staff members to quickly identify the type of transaction and reconcile sales activity accurately.

Refunds

Refunds always appear as new rows in the report. Each refund row contains the same columns as a regular purchase, including Date/Time, Location, Items, Primary Revenue Category (if unavailable, displays Refund), Client Name, Payment Method, Total Paid (a negative value), Tender Type, Batch Number, Settlement Status, and Total Settlement.

Clicking a refund displays:

A Refund Summary section in red, listing each refund in descending order by time, with negative amounts in red.
Updated Settlement Details showing all charges and refunds in chronological order.
Failed refunds, which appear the same way as failed transactions.

Voids

Voided transactions do not create new rows. Instead, the original row is updated:

Total Paid changes to $0.00 with a tooltip showing the voided amount.
Settlement-related fields are cleared.
Settlement Status displays Voided.
The entire row is shown with strikeout text and a light gray background.
Sorting order is retained based on the original transaction value.

Clicking a void displays:

A Void Summary section showing the date, time, and voided amount in red.
A new settlement block for the void transaction, shown above the original purchase block in chronological order.
The original purchase details remain, but the Total Paid value is $0.00.

Columns in the Sales Reconciliation Report

Click the information in any row to view detailed information about the purchase, including the client’s information, the date, location, purchase owner, purchase ID, frequency of payment, settlement status, settlement amount, and processor. If applicable, a summary of refund, void, and/or purchase information also appears. Additionally, you can view a list of the purchased items and the settlement details of the purchase.

Purchases

These columns include information about purchases made through WellnessLiving. Compare these columns with the Settlement columns to ensure that you’re receiving the expected amounts.

Column name	Description
Date	The date and time the transaction was processed. If you’re in a different time zone than the business, this is shown in your local time zone.
Location	The location at which the purchase was made.
Primary Revenue Category	This column is hidden by default. The primary revenue category selected for the item. When the item listed represents a payment toward another item, such as a payment plan or deposit, the revenue category associated with the originally purchased item is listed.
Client Name	The name of the client who made the transaction. You can click the client’s name to view more details. If a guest completed the transaction, Guest appears in this column.
Items	The name of the item(s) that were sold. If multiple items were sold, Multiple appears with the number of items. Hover your cursor over the number to view more details.
Payment Method	The payment method used by the client to make the transaction. If the client used multiple payment methods to make the transaction, Multiple appears with the number of payment methods. Hover your cursor over the number to view more details. If the payment method used was a check, the associated number will be included in this column.
Total Paid	The total amount the client paid toward the transaction. Failed purchases display $0 in this column.

Settlement

These columns include information about purchases processed and settled through your merchant processor. Compare these columns with the Purchases columns to ensure that you’re receiving the expected amounts.

Column name	Description
Tender Type	The type of credit card that was used to pay for the transaction, if any. This information is received from the processor and will appear as blank if the transaction wasn’t processed for any reason.
Settlement Status	The current settlement status of the transaction.
Batch Number	The batch number associated with the transaction. This number is provided by your payment processor. Pending transactions will show 0, while failed transactions will be blank. If multiple transactions made up the purchase, Multiple appears with the number of payment methods. Hover your cursor over the number to view more details.
Total Settlement	The total amount received through your payment processor for the transaction. Transactions that fail for a reason such as insufficient funds will still display the value of the purchase in this column, while the Total Paid column will show $0. This occurs because the transaction is sent to the processor and fails when attempting to process. Transactions that fail before being sent to the processor will show $0 in this column.

Total rows in the Sales Reconciliation Report

The total sum of the amounts paid and settled are listed at the bottom of the Total Paid and Total Settlement columns. These sums exclude failed transactions and are affected by your selected filters.

We recommend filtering the report to exclude purchases with a Settlement Status of Failed or Pending to ensure the report shows complete and correct information.

Filter the Sales Reconciliation Report

Note: By default, transactions made using payment methods that aren’t settled with the processor, such as Cash, PIN Pad, and Check, are automatically filtered out of the report. To include these transactions, adjust the Payment Method filters as desired.

To filter the Sales Reconciliation Report:

Click Filter.
Select the filter you want to apply, then set your desired Operator and Value.
- Add another filter by clicking Add Filter, then making your selections.
- Remove a filter by clicking the Delete button. Remove all filters by clicking Remove All.
The report is automatically filtered by your selections.

Filters in the Sales Reconciliation Report

Note: Applying filters may still display transactions that include the filtered criteria. For example, if a transaction is split between cash and credit, and the report is filtered to show only credit transactions, the split transaction will still appear because it contains a credit payment.

Filter	Description
Date	Determines which sales to display in the report based on the date they occurred.
Location	Determines which sales to display in the report based on the location at which they were sold.
Primary Revenue Category	Determines which sales to display in the report based on their relevant revenue category.
Client Name	Determines which sales to display in the report based on the client who made the purchase.
Items	Determines which sales to display in the report based on the included item(s).
Payment Method	Determines which sales to display in the report based on the payment method used. By default, transactions made using payment methods that aren’t settled with the processor, such as Cash, PIN Pad, and Check, are automatically filtered out of the report.
Total Paid	Determines which sales to display in the report based on the amount received by your business.
Tender Type	Determines which sales to display in the report based on the type of credit card used.
Settlement Status	Determines which sales to display in the report based on the transaction’s status.
Batch Number	Determines which sales to display based batch number.
Total Settlement	Determines which sales to display based on the amount received through the payment processor.