The Batch Reconciliation Report is a sales report that displays the credit card transactions processed together in batches during the selected date range.
You can use the search bar in this report to filter the data by client, purchase ID, transaction ID, or item name. For example, if you only want to view transactions for a specific product, you can enter the product’s name in the search bar.
This article describes how to view the Batch Reconciliation Report and provides details of the columns that appear in the report. To learn how to customize and filter the report, see Viewing a report.NoteThe Batch Reconciliation Report might not accurately reflect the deposits received from the processor due to a variety of reasons such as when the transaction falls outside the default batch period or when next day funding is enabled. For more information, see FAQ: Reports.
In this article:
To view the Batch Reconciliation Report:
- Click the App Drawer button
. - In the App Drawer, click View All.
- In the list, click Reports. You can filter the list by entering Reports into the Search field.
- On the Reports menu, click Sales.
- On the Sales menu, click Batch Reconciliation. The Batch Reconciliation Report is displayed.
Summary cards in the Batch Reconciliation Report
| Summary cards | Description |
| Total Payments | The total number of transactions during the selected date range. Transactions that were refunded or voided aren’t included in the total. |
| Total Paid | The total amount of all transactions that occurred during the selected date range. Voided, refunded, or failed transactions aren’t included in this total. |
| Failed Payments | The total number of failed payments during the selected date range. |
| Total Amount Failed | The total amount from failed transactions during the selected date range. |
Headings in the Batch Reconciliation Report
| Heading | Description |
| Purchase ID | The Purchase ID for the sale. The Purchase ID can also be found next to the Purchase Number on the receipt. |
| Transaction ID | The Transaction ID for the sale. The Transaction ID can also be found on the Transaction details page. For more information see, Viewing a client’s Transaction page. |
| Date | The date and time the transaction was processed. |
| Client | The name and email of the client who made the transaction. Details such as pass status, waiver status, contract status, special notes, unpaid visits, and account balance are denoted by small icons. |
| Location | The location where the transaction was made. This heading is only available if your business has multiple locations. |
| Revenue Category | Any revenue categories selected for the item. If no revenue category was selected, this column will appear empty. 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. |
| Item | The name of the item that was sold. When a payment is made toward an item or account balance, such as a payment plan, deposit, or account payment, the type of payment made is listed in this column. |
| Total Paid | The total amount the client paid with the associated payment method. |
| Payment Method | The type of payment method used to process the transaction, along with the last four digits of the card used. |
| Payment Status | The current status of the transaction. The list of transaction statuses includes:
|
| Surcharges | The total amount of surcharges associated with the transaction. |
| User | The name of the staff member who processes the payment. Actions that weren’t performed directly by a staff member such as automated billing are listed as automatic payments. Hover over the name to view the IP address of the user. |
| Frequency | The frequency at which the transaction occurs, either Recurring or One-time. |
| Batch Number | The batch number associated with the transaction. You can choose whether your transaction batches are numbered sequentially (00001, 00002, and so on), or use the ID numbers generated by your merchant processor. For more information, see Store settings. |
| Actions | An expandable menu that allows you to view or edit the transaction details, issue a refund, void the transaction, view the invoice, or view, print, or email a receipt. NoteStaff members must have the required client permissions to perform these actions. For more information, see Staff role permissions. |
Advanced filters in the Batch Reconciliation Report
| Filter | Description |
| Payment Method | Use this filter to determine which sales to include in the report based on the payment methods used. |
| Transaction Status | Use this filter to determine which transactions to include in the report based on their transaction status. |
| Locations | Use this filter to determine which locations to include in the report. You can also use this filter to view purchases clients are making online. For example, if one of your business locations is named Location A, there will be both a Location A filter and a Location A Online filter available. The Location A filter will filter for sales made by staff members through the Elevate Staff App or who are signed into Location A for clients whose home location is Location A. The Location A Online filter will filter for purchases made through the Client Web App or the Achieve Client App by clients whose home location is Location A. |
| Credit card type | Use this filter to determine which transactions to include in the report based on the type of credit card used to complete the transaction. |
| Payment Status | Use this filter to determine which sales to include based on the status of the payment. This filter will only appear if Payment View is selected. |
| Payment Frequency | Use this filter to determine which transactions to include based on their frequency, either One-time, Recurring, or Select All. |
