Batch History Report

Go to Reports and then select Batch History.

The Batch History report includes a list of all closed and pending batches. If you have more than one payment profile or process in multiple currencies, you may see more than one batch per day. 

There are four sections to a Batch History report: a list of batches; a summarization by payment type for a selected closed batch; a list of transactions within the batch; a detailed transaction view for a selected transaction. From the transaction detail, you can initiate refunds, as a follow-on action. You will find the refund button located to the right of the detail under Actions.

Use the filters to locate a specific batch or group of batches. You can filter by Merchant ID, DBA Name, Batch Date,  Batch Number, Sales Amount, and Refund Amount. See using filters and how to configure reports for more information on customizing reports.

Section 1 - Batch History Table 

Reporting FieldDescription
Batch Date
The date a batch was settled.
DBA Name
The Doing Business As name listed on your Qualpay Account.
Merchant ID
Your Qualpay Merchant ID.
Batch Number
A system-generated number used to identify your batch.
Batch Type
The type of batch is defined as either Bank Payment, for ACH payments or Card Payment, for all credit card payments.
Sales Count
The number of sale transactions included in a batch.
Sales Amount
The transaction value of sales included in the batch, in the target currency.
Refund Count
The number of refund transactions included in a batch.
Refund Amount
The transaction value of refunds included in batch, in the target currency.
Net Amount
Value of sales, less the value of refunds, in the target currency.
Currency
The currency type of the batch. Note that a separate batch will be created per currency.
Terminal NumberThe terminal number of the device is a unique number assigned and linked to a specific merchant that can be used to identify the point-of-sale (POS) terminal during credit card sales transaction processing. If there is no terminal number associated with the transaction this field will display “None”.
Status
Closed - Batch has closed.
Pending - Batch has not yet closed and is in the process of finalizing.
Report
A printable PDF view of the batch summary and detailed view.

Section 2 - Individual Batch Summary View (by payment type) Table

Reporting FieldDescription
Payment Type
Visa, MasterCard, American Express, Discover, or ACH payment.
Sales Count
The number of sale transactions per card type included in a batch.
Sales Amount
Transaction value of sales included in the batch, in the target currency.
Refund Count
The number of credit transactions per card type included in a batch.
Refund Amount
Transaction value of credits per card type included in batch, in the target currency.
Net Amount
Value of sales, less the value of credits, in the target currency.
Currency
The currency type of the batch.  
Funded Amount
Amount funded into your account in USD. If your batch processed in another currency other than USD, this is the batch Net Amount converted to USD.

Section 3 - Batch Detailed View Table

Reporting FieldDescription
Transaction date
The date the transaction was authorized.
Settled Date
The date that the transaction settled.
First Name
First Name of your customer.
Last Name
Last Name of your customer.
Account Number
Masked account number. The format for credit cards is 123456xxxxxx1234. Format for ACH payments is xxxxxxxxxxxx1234.
Payment Type
Visa, MasterCard, American Express, Discover, or ACH payment.
Transaction Amount
Amount of the transaction in the target currency.
Purchase ID
The purchase ID, sometimes referred to as the invoice ID, is input by you at the time of transaction processing. The value may appear on the cardholder statement and can be used for reconciliation purposes. For third-party payment gateway processing, the purchase ID is available when the transaction is settled. This value is system generated when transactions are initiated by the Qualpay Recurring Billing engine and Qualpay Invoicing.
Currency
The currency type of the transaction.
Funded Amount
Amount funded into your account in USD. If your batch processed in another currency other than USD, this is the batch Net Amount converted to USD.
Merchant Reference
A value created and input by you at the time of transaction processing and can be used for reconciliation purposes.
Convenience Fee
The amount of the convenience fee, if one was added. This amount is included in the transaction amount.