Monthly and custom statement reports
Last updated: Aug 15th, 7:36am
Monthly and custom statements are similar to a bank statement. The monthly statement provides a consolidated view of the following:
- balances
- payments
- fees
- taxes
- chargebacks
- refunds Monthly statements include the list of transactions, categorized by record types, to help you reconcile your beginning and ending balances.
See Monthly and Custom Statements for more information.
Interchange++ fees summary: If you are on the Interchange++ (IC++) pricing model, your monthly statement includes a consolidated view of your gross billed fees.
Access a sample report to understand how the monthly statements look.
Report Specification
For details about these values, see the Glossary.
| Position | Column Name | Optional/Required | Data Type | Description |
| 1 | Record type | Required | Character varying (256) | Type of the transaction |
| 2 | Record subtype | Optional | Character varying (256) | Subtype of the transaction |
| 3 | Payment instrument type | Required | Character varying (256) | The payment method used to process the transaction. |
| 4 | Payment instrument subtype | Required | Character varying (256) | The specific tender used to process the transaction |
| 5 | Transaction count | Required | Numeric (23, 2) | Total number of transactions applicable for each category. |
| 6 | Gross amount | Required | Numeric (23, 2) | Total amount of the transaction before deducting fees. |
| 7 | PayPal fees | Optional | Numeric (23, 2) | Total PayPal fees for each transaction. |
| 8 | Passthrough fees | Optional | Numeric (23, 2) | Passthrough fees applied to this transaction, which is the sum of total interchange fees and total scheme fees. |
| 9 | Total fees gross billed | Optional | Numeric (23, 2) | The net disbursed amount, which is the gross amount minus total fees net billed. |
Along with this aggregated view, the following information is available for every currency summary:
- Total fees in transaction currency: the total fees applicable for gross billing.
- Total fees in invoice currency: applies if the holding currency is different from the transaction currency. The total gross billed fees are converted to the invoice currency and displayed here.
Fees are shown in both the invoice and the transaction currency. If these currencies are the same, the same value shows for both.
The amount shown in total fees in the invoice currency is the amount that is debited from your bank account.