Contents
- Accessing settlement reports via the Merchant Portal
- Accessing settlement reports via Email
- Accessing settlement reports via Secure File Transfer Protocol (SFTP)
- Sample settlement report
Settlement reports provide a list of sales transactions, refunds, disputes, and fee adjustments over a daily, weekly, or monthly period. In some cases, there may be more than one deposit per day; this will be represented in the deposit_id column of your settlement report. 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, which will be covered in the next section.
Accessing settlement reports via the Merchant Portal
The merchant portal provides settlement information. To get to it:
- Sign in to your Merchant Portal
- On the left-hand sidebar, click “Settlements.”
For each date on the settlement page, you can view the following:
- Total sales
- Refunds
- Total fees
- Total amount settled
Please note that the report you download offers additional information beyond what is displayed on the Merchant Portal. Should you wish to include extra details in a report, please contact Merchant Care to submit a request.
The date listed is when Affirm initiated 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, or schedule recurring emails that contain the settlement report.
Accessing settlement reports via Email
You can arrange for emails containing settlement reports to be dispatched to any email address, choosing a frequency that meets your needs. 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 will host the SFTP directory or if you would like to use one created and hosted by Affirm. The file naming conventions for settlement reports sent to an SFTP directory can be changed to accommodate your specific needs by contacting Merchant Care. If you do not require any naming customizations, default formats include the following:
-
Merchant name_start-date_end-date_details.csv
(example: yourbusiness_2022-11-25_2022-12-14_details)
-
Merchant name_start-date_end-date_summary.csv
(example: yourbusiness_2022-11-25_2022-12-14_summary)
If you are hosting the SFTP directory, we will provide an Affirm public IP address for you to whitelist after you send us the items listed below:
- 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 the following:
- Your SSH RSA public key.
- The IP address that will access the server.
Sample settlement report
Download a sample settlement report here
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 can 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.