You can access the Batch Reconciliation Report by clicking the App Drawer button then clicking View All > Reports > Sales > Batch Reconciliation.

The Batch Reconciliation Report is a sales report that displays the credit card transactions processed together in batches during the selected date range.

View options in the Batch Reconciliation Report

Use the search bar to filter 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.

For more information, see Viewing a report.

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. Click the summary card to filter the report to only show failed transactions.

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: Authorization Error – The credit card authorization was unsuccessful. Authorized Successfully – The credit card authorization was successfully processed. Error During Refund – The refund was unsuccessful. Failed – The transaction was unsuccessful. Full Refund – This transaction is a full refund of a prior transaction. The Purchase ID and Transaction ID should match the prior transaction. Fully Refunded – The transaction was successful but has been fully refunded. Partial Refund – This transaction is a partial refund of a prior transaction. The Purchase ID and Transaction ID should match the prior transaction. Partially Refunded – The transaction was successful but has been partially refunded. Processing – The transaction is being processed by the gateway. Purchase Error – The transaction was successful, but the purchased item, such as a Purchase Option, failed to appear in the client’s profile. This can occur when a temporary server issue interrupts the purchase. If the purchase was made using a credit card, the transaction will be voided after 30 minutes, and this payment status will be changed to Voided. If the purchase was made using ACH, cash, check, gift card, or the client’s account balance, then the transaction must be refunded. Successful – The transaction was successfully processed. Voided – The transaction was successfully canceled before the batch closed. For more information, see Transaction batches and refunds. Waiting for Settlement – The ACH transaction is being processed and will take up to 14 business days to settle.
Surcharge	The total surcharge amount associated with the items sold. This column is only displayed if you set the Surcharge setting to ON in your store settings.
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. Note: Staff 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.