How-To Guide
6 min read

How to Export Settlements from Afterpay (2026 Guide)

Follow these steps to export your Afterpay settlements as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.

Export Steps

1

Log in to the Afterpay Business Hub

Open your browser and navigate to the Afterpay Business Hub (also known as the Afterpay Merchant Portal). Sign in using your merchant account credentials. The Business Hub is the central dashboard for managing your Afterpay merchant account, viewing orders, and downloading reports.

2

Navigate to the Settlements section

In the Business Hub navigation, find and click on the 'Settlements' section. This area shows your payout history and provides access to reconciliation reports that detail how each settlement amount was calculated.

Afterpay Business Hub Settlements section showing settlement reports with payout dates and amounts
The Settlements section displays your payout history and report downloads.
3

Select the Reconciliation Report

Within the Settlements section, look for the 'Reconciliation Report' option or an 'Export' button. This report provides order-level detail for each settlement, including the original order amount, Afterpay merchant fees, fee tax, and net settlement amount paid to your bank.

Afterpay Business Hub showing the tax invoices and reconciliation download options
Find the Export or Reconciliation Report option within the Settlements section.
4

Choose the report type and date range

Select the type of reconciliation data you want (e.g., all settlements, specific payout period). Set the date range to cover the period you need. Afterpay settlements typically occur on a rolling basis, so choose dates that align with your accounting period.

Tip: The Settlement Date column in the export shows when funds were deposited to your bank account, which is what you need for bank reconciliation. The Order Date shows when the customer placed the order.
5

Download the CSV file

Click the 'Export' or 'Download' button to generate the CSV file. The download includes fields such as Order ID, Merchant Reference, Order Date, Settlement Date, Type, Order Amount, Merchant Fee (excluding and including tax), Net Settlement Amount, Currency, Store, and Channel.

Afterpay Business Hub showing the settlement report download dialog with CSV export options
Click the download button to save the reconciliation report as a CSV file.
6

Verify the settlement calculations

Open the CSV in a spreadsheet and verify the fee math: Net Settlement Amount should equal Order Amount minus Merchant Fee incl Tax. Check that the Settlement Date values match your bank deposits. Review any refund rows (Type = 'Refund') to ensure they are properly accounted for.

Warning: Afterpay regional date formats vary. Australian and New Zealand exports use DD/MM/YYYY, while US exports use MM/DD/YYYY. Confirm the format before importing into other tools.

Required Settlements Fields

Field Type Description Example
Order ID Text Afterpay order identifier AP-12345678
Order Date and Time Date/Time When order was placed (format varies by region) 15/01/2025 10:30
Settlement Date Date When funds settled to merchant account 17/01/2025
Order Amount Currency Total order amount (gross) 150.00
Net Settlement Amount Currency Net payout to merchant (Order Amount - Fees) 145.60

Your Afterpay export must include these fields for successful conversion.

Next Step Once you have exported your settlements, use one of the converter tools below to transform your file.

Frequently Asked Questions

Afterpay exports settlements as a CSV (Comma Separated Values) file, which can be opened in Excel or Google Sheets.
The file is usually downloaded to your browser's default Downloads folder. Check your Downloads folder or look for the download notification.