Settlement reports provide a list of sales transactions, refunds, disputes, and fee adjustments over a daily, weekly, or monthly period. There is one settlement report for each deposit settled to your bank account. In some cases, there may be more than one settlement report per day. These reports allow you to reconcile your transactions with the deposits made into your bank account.
There are several ways you can access your Settlement Reports.
Accessing Settlement Reports via the Merchant Dashboard
The merchant portal provides settlement information. To get to it:
- Sign in to your Merchant Dashboard
- On the left-hand sidebar, click Settlements.
For each date on the settlement page, you can view total sales, refunds, total fees, and total amount settled. The date listed is when we initiate an ACH transfer for that payment. It may take 1 to 3 business days for settlements to appear in your bank account. From this page, you can also download the current report immediately, or schedule recurring emails that contain the settlement report.
Accessing Settlement Reports via Email
You can schedule emails with settlement reports to any email address on a regular cadence of your choosing. Click here for more information on scheduling email reports.
Accessing Settlement Reports via Secure File Transfer Protocol (SFTP)
You can choose to have settlement files sent to a Secure File Transfer Protocol (SFTP) directory. Contact our Merchant Care team and specify if you'll host the SFTP directory or if you'd like to use one created and hosted by Affirm. The file name conventions for settlement reports sent to an SFTP directory have specific requirements and are:
- Merchant name_start-date_end-date_details.csv
- Merchant name_start-date_end-date_summary.csv
If you are hosting the SFTP directory, we will provide an Affirm public IP address for you to whitelist after you send us:
- Your SFTP server address
- The port number
- The directory path (if applicable)
- Basic authentication credentials (if applicable)
If you would like to use an SFTP directory hosted by Affirm, we will send you the server address, port number, and username after you send us:
- Your SSH RSA public key
- The IP address that will access the server
Sample Settlement Report
This sample file can be used to develop against if you need a practical example of the file format and data types described below. If you have multiple URLs under one account, please reach out to Affirm to determine if Affirm is able to configure a combined Parent Settlement Report.
If you would like to receive a settlement report from your sandbox environment, please contact the Affirm Merchant Care team.