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 to convert the sell currency to the settlement currency. A value of 1 or null denotes like-for-like processing.

LINE TYPE

This column indicates the type of transaction, such as Payments, Refund, Adjustment, Transaction, etc. On the last row, the "Net Total" indicates each entry in that row will contain a sum of the corresponding column for all Transactions, Refunds, and Adjustments that are included in the report.

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. Can be found in admin, listed in the Overview section as the "Merchant Reference".

MERCHANT PAYMENT ID

The merchant-provided ID for the payment.

MERCHANT REFUND ID

The merchant provided the ID for the refund (if any). This ID is listed in admin under the Refunds page in the Payment Details window in Admin.

NET AMOUNT

This value is the amount remitted to the merchant by Reach, with all fees and taxes deducted.

Example:

Settlement Amount Gross: 45.00 USD

Processing Fee: 2.00 USD

All other fees: 0 USD

Net Amount: $43.00 USD

NOTES

A field for text notes, if any. Often includes details about chargebacks or the fee for the chargeback. If the net total from the previous settlement report was negative, details about the balance carried forward will be included in the notes section on the Net Total row of the report.

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). Searchable in Reach Admin as the order ID (Searching in Admin).

PAYMENT METHOD

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

PLATFORM ORDER ID

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

PROCESSED DATE

The date when the transaction was completed and entered into the system as processed.

PSP TRANSACTION ID

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

REFUND ID

The Reach external identifier for the refund (if any). Can be searched under the Refund ID in admin, details included in the Refunds section of the Payment Details window.

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.

For Example: SETTLEMENT AMOUNT - TOTAL: 50 USD

SETTLEMENT AMOUNT - TAX: -5 USD

SETTLEMENT AMOUNT - GROSS: 45 USD

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), excluding 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.

Example Refund:

Sell Amount Subtotal: -50.00 USD

Sell Amount Tax: -5.00 USD

Sell Amount - Total: -55.00 USD

SELL CURRENCY

The three-letter ISO code represents the currency consumers use, specifically the currency sold on the foreign exchange (FX). Examples include USD, CAD, GBP, AUD, EUR, etc.

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. SETTLEMENT AMOUNT - TOTAL - SETTLEMENT AMOUNT TAX = SETTLEMENT AMOUNT GROSS. This is the SELL AMOUNT - TAX converted into the Settlement Currency.

SETTLEMENT AMOUNT - TOTAL

The transaction amount converted into 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). Examples include USD, GBP, CAD, AUD, EUR

SETTLEMENT DATE

The merchant will receive a settlement equal to the Net Total on the bottom row of the settlement report on this date.

TAX TRANSACTION ID

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