Settlement reports

Settlement reports are detailed records summarizing all transactions processed through the Reach platform during a specific period.

The Settlement report contains various terms that may appear based on your filter settings and chosen CSV delivery format. The specific terms included in your report will depend on these preferences. Additionally, when you select a CSV delivery format, the terms may be slightly renamed to fit the column headings. The following table lists all possible terms that can appear in the Settlement report.

For more information on downloading a settlement statement from the Reach Admin, see Exporting a Settlement Statement.

FEE - FINANCING

Reach charges the fraud coverage revenue fee to the merchant.

FEE - FRAUD ENGINE

Reach charges the fraud coverage revenue fee to the merchant.

FEE - PASSTHROUGH

The passthrough fee is passed through Reach from the Payment Service Provider (PSP) onto the merchant.

FEE - PROCESSING

Reach charges the processing revenue fee to the merchant.

FEE - REFUND

Reach charges the refund revenue fee to the merchant.

FEE - TAAS

Reach charges the tax revenue fee to the merchant.

FEE - TRANSACTION

Reach charges the transaction revenue fee to the merchant.

FX RATE

The foreign exchange (FX) rate used for any trade done by Reach. A value of 1 denotes like-for-like processing.

LINE TYPE

This column indicates the type of transaction, such as Payments, Refund, Adjustment, Transaction, NetTotal, etc.

MERCHANT MARKUP

The foreign exchange (FX) revenue that the merchant requested as markup if Reach trades the transaction.

MERCHANT ORDER ID

The merchant-provided ID for the order.

MERCHANT PAYMENT ID

The merchant-provided ID for the payment.

MERCHANT REFUND ID

The merchant provided the ID for the refund (if any).

NET AMOUNT

This value is Reach's final settlement amount with the merchant, net of all fees and taxes.

NOTES

A field for text notes, if any.

ORDER DATE

The date the consumer placed the order in the merchant's store.

ORDER ID

The Reach identifier for the order that contains the transaction(s).

PAYMENT METHOD

The method of payment, e.g., AMEX, PayPal.

PLATFORM ORDER ID

The payment platform-provided ID for the order (e.g., Shopify).

PROCESSED DATE

The date when the transaction was processed.

PSP TRANSACTION ID

The payment service provider's (PSP) transaction identifier.

REFUND ID

The Reach external identifier for the refund (if any).

SELL AMOUNT - DUTY

The DUTY amount is a component of the overall SELL AMOUNT. It sums with other SELL AMOUNT components, such as SELL AMOUNT - PRODUCT, SELL AMOUNT - SHIPPING, SELL AMOUNT - TAX, and SELL AMOUNT - FINANCING, which total the SELL AMOUNT.

**This term is deprecated.**

SELL AMOUNT - FINANCING

The FINANCING amount is a component of the overall SELL AMOUNT. It sums with other SELL AMOUNT components, such as SELL AMOUNT - PRODUCT, SELL AMOUNT - SHIPPING, SELL AMOUNT - DUTY, and SELL AMOUNT - TAX, which total the SELL_AMOUNT.

**This term is deprecated.**

SETTLEMENT AMOUNT - GROSS

The transaction amount in the settlement currency (SETTLEMENT CURRENCY), net of tax.

SELL AMOUNT - PRODUCT

The PRODUCT amount is a component of the overall SELL AMOUNT. It sums with other SELL AMOUNT components, such as SELL AMOUNT - SHIPPING, SELL AMOUNT - DUTY, SELL AMOUNT - TAX, and SELL AMOUNT - FINANCING, which totals the SELL AMOUNT.

**This term is deprecated.**

SELL AMOUNT - SHIPPING

The SHIPPING amount is a component of the overall SELL AMOUNT. It sums with other SELL AMOUNT components, such as SELL AMOUNT - PRODUCT, SELL AMOUNT - DUTY, SELL AMOUNT - TAX, and SELL AMOUNT - FINANCING, which total the SELL AMOUNT.

**This term is deprecated.**

SELL AMOUNT - SUBTOTAL

The transaction amount in the currency the consumer paid with (SELL CURRENCY), net of tax.

SELL AMOUNT - TAX

The tax on the Sell Amount Subtotal. A positive value appears when a transaction has taxes levied against it, and a negative value occurs when the tax is refunded. For instance, the sign ensures that adding it to the subtotal results in the total. For example:

The sign will generally be the inverse of this on the settlement side because the tax was withheld from the settlement total. The extent of these details is clearer when looking at an example:

Sell amount subtotal: 100
Sell amount tax: 10
Sell amount total: 110
FX rate: 1
Settlement amount total: 110
Settlement amount tax: -10
Gross amount settled: 100

SELL AMOUNT - TOTAL

The transaction amount in the currency the consumer paid with (SELL CURRENCY), including tax.

SELL CURRENCY

The three-letter ISO code represents the currency consumers use, specifically the currency sold on the foreign exchange (FX).

SETTLEMENT AMOUNT - DUTY

The DUTY amount is a component of the overall SETTLEMENT AMOUNT. It sums with other SETTLEMENT AMOUNT components, such as SETTLEMENT AMOUNT - PRODUCT, SETTLEMENT AMOUNT - SHIPPING, SETTLEMENT AMOUNT - TAX, and SETTLEMENT AMOUNT - FINANCING, which total the SETTLEMENT_AMOUNT.

**This term is deprecated.**

SETTLEMENT AMOUNT - FINANCING

The FINANCING amount is a component of the overall SETTLEMENT AMOUNT. It sums with other SETTLEMENT AMOUNT components, such as SETTLEMENT AMOUNT - PRODUCT, SETTLEMENT AMOUNT - SHIPPING, SETTLEMENT AMOUNT - DUTY, and SETTLEMENT AMOUNT - TAX, which total the SETTLEMENT_AMOUNT.

**This term is deprecated.**

SETTLEMENT AMOUNT - PRODUCT

The PRODUCT amount is a component of the overall SETTLEMENT AMOUNT. It sums with other SETTLEMENT AMOUNT components, such as SETTLEMENT AMOUNT - SHIPPING, SETTLEMENT AMOUNT - DUTY, SETTLEMENT AMOUNT - TAX, and SETTLEMENT AMOUNT - FINANCING, which total the SETTLEMENT AMOUNT.

**This term is deprecated.**

SETTLEMENT AMOUNT - SHIPPING

The SHIPPING amount is a component of the overall SETTLEMENT AMOUNT. It sums with other SETTLEMENT AMOUNT components, such as SETTLEMENT AMOUNT - PRODUCT, SETTLEMENT AMOUNT - DUTY, SETTLEMENT AMOUNT - TAX, and SETTLEMENT AMOUNT - FINANCING, which total the SETTLEMENT AMOUNT.

**This term is deprecated.**

SETTLEMENT AMOUNT - TAX

The TAX amount is a component of the overall SETTLEMENT AMOUNT - TOTAL. It sums into SETTLEMENT AMOUNT - TOTAL, but not into NET AMOUNT.

SETTLEMENT AMOUNT - TOTAL

The transaction amount in the settlement currency (SETTLEMENT CURRENCY), including tax. Reach uses this value to calculate any volume-based fees.

SETTLEMENT CURRENCY

The three-letter ISO code for the currency for settlement with the merchant, specifically the currency purchased during foreign exchange (FX).

SETTLEMENT DATE

The merchant will receive the Net Amount settlement on this date.

TAX TRANSACTION ID

The Reach-assigned ID for the tax transaction, irrespective of tax processing source (e.g., Avalara, ShopTax, etc.).