Batch-level reconciliation

To reconcile payout batches against your bank statement, you need:

• The Aggregate Settlement Details Report to find settled batches and other account movements for a specified date range.

Step 1: Find settlement batches

Use the following column to find a batch:

• Batch Number: The settlement batch number.

Each batch can have more than one entry in the report if it includes settlements with more than one:

• Creation date: for example, it includes settlement amounts from several days of sales.
• Payment method: for example, it includes settlements from Mastercard and Visa payments.
• Journal type: for example, it includes a settlement from American Express payments and a balance transfer form a previous batch.
• Currency: for example, it includes settlement amounts in EUR and USD.

Example

The following example shows select columns from the Aggregate settlement details report. The entries are for a settlement batch with the Batch Number of 604.

There are six entries with the Creation Date of 2021-03-26.

• Three of the entries have a Journal Type: Settled.
  • One entry is for the Payment Method: mc.
  • One entry is for the Payment Method: visa with the Net Currency: USD.
  • One entry is for the Payment Method:visa with the Net Currency: EUR.
• Three of the entries have a Journal Type: Balancetransfer.
  • Each of these entries has a different Net Currency.

Step 2: Find the total transaction amounts and fees in a batch

Each entry with the Journal Type of Settled shows the amount settled for a group of transactions. You can see details about the amount in the following columns:

• Gross Credit: The total amount for the group of transactions in the entry.
• Bank/Card Commission: The bank and/or card commission fees for the group of transactions in the entry.
• DCC Markup: The Dynamic Currency Conversion (DCC) markup for the group of transactions in the entry.
• Num Txs: The number of transactions included in the entry.
• Net Credit: The amount settled to your bank account after deducting bank and/or card commission fees and DCC markup. This is the amount in Gross Credit minus the amounts in Bank/Card Commission and DCC Markup.

Example

The following example shows select columns from the Aggregate settlement details report. The entries are for a settlement batch with the Batch Number: 608.

The net settlement amount for this batch is EUR 5,847.53. This is the total of the amounts in the Net Credit column.
The total bank or card commission fees for this batch is EUR 114.27. This is the total of the amounts in the Bank/Card Commission column.
The total number of transactions in this batch is 31. This is the total of the numbers in the Num Txs column.

See also