Settlement Reports

A settlement report explains how the amount in a payout was calculated. Use it to reconcile a Two payout with the orders, invoices, refunds, and fees in your own systems.

You can download a report for an individual settlement or for a date range in CSV or XLSX format. A date-range report can include more than one settlement.

Start with these fields

For most reconciliations, you only need these fields:

To answer	Use these fields
Which of our records does this row relate to?	Merchant Order ID, Document Number
What was the order value?	Net Order Amount, Tax, Gross Settlement
What did Two deduct?	Total Fee or Total Fee Including Tax
What amount was paid out?	Net Settlement Amount
Which bank transaction is this?	Payment Reference, Settlement Date, Currency

Keep Merchant Order ID as your primary reconciliation key. It is the identifier you supplied when the order was created and is usually the easiest field to match to your order or invoice system.

Reconcile a payout

Work through the report at settlement level, rather than treating each row as a separate bank payment.

1. Find the payout in your bank using Payment Reference, Settlement Date, and Currency.
2. Filter the report to the same Payment Reference.
3. Match each row to your records using Merchant Order ID. Use Document Number to identify the related invoice or credit note when needed.
4. Add the Net Settlement Amount values for the matching rows. The total should reconcile to the payout amount for a net settlement.
5. Investigate any negative rows before finalising your reconciliation; they generally represent a credit note or refund that reduces the payout.

How the amounts relate

For a typical net settlement row:

Gross Settlement = Net Order Amount + Tax
Net Settlement Amount = Gross Settlement − applicable fee total

For example:

Net Order Amount	Tax	Gross Settlement	Total Fee	Net Settlement Amount
8,000.00	1,200.00	9,200.00	184.00	9,016.00

Some reports show Total Fee; others show the fee split into tax-exclusive, tax-rate, tax-amount, and tax-inclusive columns. When Total Fee Including Tax is present, use that as the fee total in the calculation above.

How to read rows

Each row is a financial event included in a settlement, not necessarily a unique order. An order can have more than one row when it has related financial events.

• An invoice row adds value to the settlement.
• A credit-note or refund row commonly has negative amounts and reduces the relevant settlement.
• A manual-adjustment row includes an explanation in Manual Adjustment Comment.

Use Event Type to identify the event and Two Transaction Type for the corresponding Two transaction classification. Do not rely on a row's position in the spreadsheet: use the identifiers instead.

Field reference

Your references and Two identifiers

Field	Meaning
Merchant Name	The merchant associated with the row.
Merchant Vendor Name	The vendor or store name, where your setup uses one.
Merchant Vendor ID	The vendor or store identifier, where your setup uses one.
Merchant Order ID	Your order or invoice reference. Use this as the primary match to your system.
Merchant Reference	An additional reference provided by the merchant.
Merchant Payout Account Alias	A friendly name for the payout account.
Document Number	The invoice or credit-note document number.
Two UUID	The unique identifier for the report event.
Two Order ID	Two's internal order identifier.
Two Refund ID	Two's refund identifier, populated for refund rows.
Two Transaction Type	Two's classification of the transaction.
Refund Reference	The reference associated with a refund.

Event, buyer, and order context

Field	Meaning
Event Type	The financial event, such as INVOICE or CREDIT_NOTE.
Date Fulfilled	The date the underlying order was fulfilled.
Due in Days	The payment terms applied to the buyer.
Currency	The transaction currency.
Country Code	The relevant country in ISO 3166-1 alpha-2 format.
Buyer Company Name	The buyer's company name.
Buyer Organization Number	The buyer's company registration number.
Trading Name	The buyer's trading name, when available.
Buyer Shipping Address	The shipping address, when available.
Line Item Array	The line-item detail included with the event, when available.

Amounts and fees

Field	Meaning
Net Order Amount	The order amount excluding tax.
Tax	Tax charged on the order.
Gross Settlement	The gross order amount before merchant fees.
Total Fee	The total merchant fee in reports that do not show a fee-tax breakdown.
Fixed Fee	The fixed component of the merchant fee.
Variable Fee	The variable or percentage-based component of the merchant fee.
Total Fee Excluding Tax	The total merchant fee before tax.
Total Fee Tax Rate	The tax rate applied to the merchant fee.
Total Fee Tax Amount	Tax charged on the merchant fee.
Total Fee Including Tax	The total merchant fee including tax.
Net Settlement Amount	The amount remaining after applicable merchant fees are deducted.
Net Buyer Fees	Buyer fees excluding tax, where applicable.
Buyer Fees Tax	Tax charged on buyer fees, where applicable.
Gross Buyer Fees	Buyer fees including tax, where applicable.

Payout details

Field	Meaning
Settlement Date	The date the payout was made or scheduled.
Settlement Type	The settlement status or type.
Funding Provider	The funding entity associated with the payout.
Payment Reference	The reference used to match the payout with the bank transaction.
Manual Adjustment Comment	The reason for a manual adjustment, when one is included.

Repayment-plan details

These fields are populated only when the related order has a repayment plan.

Field	Meaning
Two Repayment Plan Id	The repayment-plan identifier.
Number of Terms	The number of instalments.
Term Period	The instalment frequency, such as MONTHLY.

Why columns may differ

The exact columns in a report depend on the information available for the settlement and your reporting configuration. In particular:

• Reports show either Total Fee or a detailed fee-tax breakdown.
• Buyer-fee columns appear only when buyer fees apply.
• Fields such as vendor details, buyer trading name, shipping address, line items, refund identifiers, and repayment-plan details appear only when relevant data is available.

Treat blank optional fields as unavailable information, rather than as an error in the report.

If a download has headers but no rows

A file with column headers but no data rows means no settlement-report entries matched the requested criteria. Check that the date range includes the expected activity and, for date-range downloads, that you selected the correct payout country.

Related API endpoints

• List settlements to find a settlement and its payment reference.
• Download a settlement statement for one settlement.
• Download a settlement report for a date range.

Contact support

When contacting support about a report, include the Merchant Order ID, Settlement Date, Currency, and Payment Reference. Do not share bank-account details unless an approved support channel specifically asks for them.