# Reporting & Reconciliation

Retrieve reporting data and reconciliation information using reporting APIs and supported report types.

Deluxe supports reporting and reconciliation workflows using:

- Transaction Search
- Payment history and transaction detail retrieval
- Custom reporting capabilities
- Settlement reporting (where enabled)
- ACH reporting (where enabled)
- Reconciliation reporting (where enabled)
- Deposit and funding reporting (where enabled)
- Chargeback monitoring capabilities


Reporting availability varies by product, report type, merchant configuration, and integration enablement.

The complete externally supported reporting catalog is currently being validated.

### **Search Payment Endpoint**

This API endpoint is used to search and retrieve a list of payments, providing details about each payment for a given date range.

Explore

Search Payments API →


### **Custom Report Endpoint**

The Custom Report API endpoint allows you to fetch a report based on a specific title and date range.

Reports available for retrieval include:

#### **ccReconciliation**

Summarizes daily credit card sales activity per merchant by capture date and transaction type, showing aggregated sales totals and counts for reconciliation against bank deposits.

| Field | Type | Description |
|  --- | --- | --- |
| merchantInfo:Merchant# | string | Merchant account number |
| transInfo:CaptureDate | datetime | Date/time the transaction batch was captured |
| transInfo:TransactionType | string | Transaction type (e.g., SALE) |
| totals:Sales(sum) | currency | Total dollar amount of sales for the group |
| totals:Sales(count) | int | Number of sales transactions in the group |


#### **ccMethodOfPayment**

Breaks down a merchant's credit card volume by card brand (Visa, Mastercard, Amex, Discover, Cash) along with overall sales/refund counts.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA (doing-business-as) name |
| cash | currency | Total cash volume |
| visa | currency | Total Visa volume |
| mastercard | currency | Total Mastercard volume |
| amex | currency | Total American Express volume |
| discover | currency | Total Discover volume |
| total | currency | Total volume across all payment methods |
| #Sales | int | Count of sale transactions |
| #Refunds | int | Count of refund transactions |
| totalTrans | int | Total transaction count (sales + refunds + other) |


#### **ccChannelFees**

Reports gross credit card processing volume alongside the various fees assessed (merchant, transaction, auth, monthly, batch) and tax, to show net revenue by channel.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| total(gross) | currency | Gross transaction volume before fees |
| #Trans | int | Total transaction count |
| #Batches | int | Total batch count |
| merchantFee | currency | Merchant-level fee charged |
| transFee | currency | Per-transaction fee charged |
| authFee | currency | Authorization fee charged |
| monthlyFee | currency | Monthly fee charged |
| batchFee | currency | Per-batch fee charged |
| tax | currency | Tax applied |
| total | currency | Net total after fees/tax |


#### **ccTransaction**

High-level transaction activity summary per merchant, counts of sales, refunds, rejects (bank vs. internal), and batches over the reporting period.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| #Sales | int | Count of sale transactions |
| #Refunds | int | Count of refund transactions |
| #Rejects(bank) | int | Count rejected by the issuing bank/processor |
| #Rejects(internal) | int | Count rejected by internal validation |
| #Batches | int | Count of batches processed |


#### **ccListBatches**

Lists each closed credit card batch for a merchant with its batch number, date, and total amount.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| date | date | Batch close date |
| batch# | int | Batch identifier |
| total | currency | Total dollar amount of the batch |


#### **ccApproval**

Detailed, transaction-level report of approved credit card transactions, including full cardholder, payment, and authorization details.

| Field | Type | Description |
|  --- | --- | --- |
| merchantid | string | Merchant account number |
| dbaname | string | Merchant DBA name |
| total | currency | Transaction amount |
| submissiontype | string | How the transaction was submitted (e.g., Recurring) |
| date | date | Transaction date |
| transactiondatetime | datetime | Full transaction timestamp |
| transactiontype | string | Transaction type (e.g., SALE) |
| transactionstatus | string | Status (e.g., APPROVED) |
| invoice# | string | Invoice/order reference number |
| paymentid | guid | Internal payment method identifier |
| transactionrecordid | long | Internal transaction record ID |
| arn | string (nullable) | Acquirer Reference Number |
| apvlcode | string | Authorization/approval code |
| currency | string | Transaction currency code |
| cardtype | string | Card brand (e.g., VISA) |
| cardholdername | string | Name on card |
| cardholderaddress | string | Cardholder billing address |
| cardholdercity | string | Cardholder billing city |
| cardholderstate | string | Cardholder billing state |
| cardholdercountry | string | Cardholder billing country |
| cardholderzip | string | Cardholder billing zip |
| cardholderphone | string | Cardholder phone number |
| cardholderemail | string | Cardholder email |
| card# | string | Masked card number |
| expdate | string | Card expiration date (MMYY) |
| customerid | long | Internal customer ID |
| vaultid | guid | Vaulted payment method ID |
| recurringid | guid | Recurring schedule ID (if applicable) |
| requestid | guid | Original request/idempotency ID |


#### **ccReject**

Detailed, transaction-level report of declined/rejected credit card transactions, including cardholder details and the reject/decline reason.

| Field | Type | Description |
|  --- | --- | --- |
| invoice# | string | Invoice/order reference number |
| date | date | Transaction date |
| merchantid | string | Merchant account number |
| dbaname | string | Merchant DBA name |
| deviceid | string (nullable) | Originating device ID, if applicable |
| cardholdername | string | Name on card |
| cardholderaddress | string | Cardholder billing address |
| cardholdercity | string | Cardholder billing city |
| cardholderstate | string | Cardholder billing state |
| cardholdercountry | string | Cardholder billing country |
| cardholderzip | string | Cardholder billing zip |
| cardholderphone | string | Cardholder phone number |
| cardholderemail | string | Cardholder email |
| cardtype | string | Card brand (e.g., VISA) |
| card# | string | Masked card number |
| expdate | string | Card expiration date (MMYY) |
| total | currency | Attempted transaction amount |
| rejectcode? | string | Reject/decline code and reason |
| paymentid | guid | Internal payment method identifier |
| vaultid | guid (nullable) | Vaulted payment method ID, if used |
| recurringid | guid (nullable) | Recurring schedule ID, if applicable |
| transactionrecordid | long | Internal transaction record ID |
| requestid | guid | Original request/idempotency ID |


#### **achBankReconciliation**

Summarizes ACH batch activity per merchant by capture date, showing how many batches were processed - used to reconcile ACH settlement against bank deposits.

| Field | Type | Description |
|  --- | --- | --- |
| captureDate | datetime | Date/time the ACH batch was captured |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| #Batches | int | Number of ACH batches captured on that date |


#### **achChannelFees**

Reports gross ACH processing volume alongside associated fees (transaction, batch, return) and tax, to show net ACH revenue by channel.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| total(gross) | currency | Gross ACH volume before fees |
| #Sales | int | Count of ACH sale/debit transactions |
| #Returns | int | Count of returned ACH transactions |
| transFee | currency | Per-transaction fee charged |
| batchFee | currency | Per-batch fee charged |
| returnFee | currency | Fee charged per returned transaction |
| tax | currency | Tax applied |
| total | currency | Net total after fees/tax |


#### **achBatchTotal**

Lists ACH batch-level totals by transaction type and status, showing the amount and approval status of each ACH batch entry.

| Field | Type | Description |
|  --- | --- | --- |
| merchantId | string | Merchant account number |
| dbaName | string | Merchant DBA name |
| transInfo:TransactionType | string | ACH transaction type (e.g., ACH DEBIT) |
| totalsSummary:Sales(sum) | currency | Summed sales amount for the batch |
| transInfo:Amount | currency | Transaction amount |
| transInfo:Status(approved/declined) | string | Approval status of the transaction |
| transInfo:Batchid | long | Batch identifier |
| achTransDate | date | ACH transaction date |


#### **achSettlement**

Detailed, transaction-level report of settled ACH transactions, including full customer banking and payment details.

| Field | Type | Description |
|  --- | --- | --- |
| invoice# | string | Invoice/order reference number |
| date | date | Transaction date |
| merchantid | string | Merchant account number |
| dbaname | string | Merchant DBA name |
| cardholdername | string | Account holder name |
| cardholderaddress | string | Billing address |
| cardholdercity | string | Billing city |
| cardholderstate | string | Billing state |
| cardholdercountry | string | Billing country |
| cardholderzip | string | Billing zip |
| cardholderphone | string | Phone number |
| cardholderemail | string | Email address |
| accounttype | string | Bank account type - "c" (checking) or "s" (savings) |
| total | currency | Settled transaction amount |
| transtionstatus | string | Transaction status (e.g., APPROVED) |
| paymentid | guid | Internal payment method identifier |
| vaultid | guid | Vaulted payment method ID |
| recurringid | guid | Recurring schedule ID (if applicable) |
| accountnumber | string | Masked bank account number |
| transactionrecordid | long | Internal transaction record ID |
| requestid | guid | Original request/idempotency ID |


#### **achReturn**

Detailed report of ACH transactions returned by the receiving bank (e.g., NSF, closed account), including account and customer details.

| Field | Type | Description |
|  --- | --- | --- |
| transInfo:Bin/country | string | BIN/country info |
| date | date | Transaction date |
| merchantId | string | Merchant account number |
| checking(c)/savings(s) | string | Bank account type |
| name(first&Last) | string | Account holder name |
| accountnumber | string | Masked bank account number |
| total | currency | Transaction amount |
| transactionStatus | string | Status (e.g., RETURNED) |
| invoice# | string | Invoice/order reference number |
| paymentId | guid | Internal payment method identifier |
| vaultId | guid (nullable) | Vaulted payment method ID, if used |
| recurringId | guid (nullable) | Recurring schedule ID, if applicable |


#### **achReject**

Detailed report of ACH transactions declined/rejected at submission time (prior to settlement), including customer and payment details.

| Field | Type | Description |
|  --- | --- | --- |
| invoice# | string | Invoice/order reference number |
| date | date | Transaction date |
| merchantid | string | Merchant account number |
| dbaname | string | Merchant DBA name |
| accounttype | string | Bank account type |
| cardholdername | string | Account holder name |
| cardholderaddress | string | Billing address |
| cardholdercity | string | Billing city |
| cardholderstate | string | Billing state |
| cardholdercountry | string | Billing country |
| cardholderzip | string | Billing zip |
| cardholderphone | string | Phone number |
| cardholderemail | string | Email address |
| total | currency | Attempted transaction amount |
| transactionstatus | string | Status (e.g., DECLINED) |
| paymentid | guid | Internal payment method identifier |
| vaultid | guid (nullable) | Vaulted payment method ID, if used |
| recurringid | guid (nullable) | Recurring schedule ID, if applicable |
| transactionrecordid | long | Internal transaction record ID |
| requestid | guid | Original request/idempotency ID |


#### **salesItems**

Line-item (itemized) detail report for a transaction, breaking down individual sale items, quantities, and prices within a transaction.

| Field | Type | Description |
|  --- | --- | --- |
| merchant# | string | Merchant account number |
| invoice# | string | Invoice/order reference number |
| transactionId | guid | Payment method/transaction identifier |
| date | date | Transaction date |
| name(first&Last) | string | Customer name |
| batch:Date/time | datetime (nullable) | Batch date/time, if batched |
| addressTotalsSummary: | string | Street address |
| city | string | Customer city |
| state | string | Customer state |
| zip | string | Customer zip |
| email | string | Customer email |
| paymentMethod | string | Card brand/payment method used |
| transactionTotal | currency | Total transaction amount |
| saleItem | string | Name/description of the line item sold |
| itemPrice | currency | Unit price of the item |
| quantity | int | Quantity of the item sold |
| itemTotal | currency | Extended total for the item |


#### **customFields**

Returns merchant-defined custom field name/value pairs captured against a transaction.

| Field | Type | Description |
|  --- | --- | --- |
| batch:Date/time | datetime (nullable) | Batch date/time, if batched |
| name(first&Last) | string | Customer name |
| email | string | Customer email |
| transactionId | guid | Payment method/transaction identifier |
| customFieldName | string | Name of the custom field |
| customFieldValue | string | Value stored for the custom field |


### **Related Resources**

Search Payments API
Search and retrieve payment activity.

Reports API
Retrieve report data using supported report types and reporting parameters.