Overview

Settlement reports provide a list of sales transactions, refunds, and disputes over a daily, weekly, or monthly period. There is one settlement report for each settlement to your bank account, and typically, there's one settlement every day that you capture an Affirm charge. These reports allow you to reconcile your transactions with the deposits made into your bank account. This guide will cover:

• Report delivery schedule
• How to access your reports
• How to read your reports
• How to reconcile your settlements

Click here for timing information about when you get paid.

Report delivery schedule

There are daily, weekly, and monthly settlement reports. Our settlement process is based on Coordinated Universal Time (UTC), but we'll discuss the timeline in terms of Pacific Daylight Time to give a sense of when these events may occur in your timezone.

Please note that if you are expecting a large number of reports, you may experience some delay in delivery times.

Daily reports

Daily reports are generated every day between Monday and Friday at 7:30 PM PDT. Each daily settlement report includes all charges from the previous day (accounting for the timezone conversion, Tuesday's report contains all of UTC Monday's charges). Because of that, the report that appears on your dashboard on a weekday at 7:30 PM PDT will be the previous days report. For example, the report that appears on your dashaboard on Wednesday March 6th at 7:30 PM will be the Tuesday, March 5th Settlement report.

Since settlements do not occur on weekends, on Monday evenings one report is generated containing the settlements for Friday, Saturday, and Sunday. Bank holidays are similar. Settlement Reports are not generated on bank holidays. If a Bank Holiday is on a Monday, then the Tuesday night report will contain settlements for the previous Friday, Saturday, Sunday, and Monday. 

Weekly reports

Weekly reports are delivered every Monday at 8:00 PM PDT. Each weekly settlement report includes charges from the previous week, Monday through Sunday.

Monthly reports

Monthly reports are delivered on the first day of the month at 6:30 PM PDT. Each monthly settlement reports includes charges from the previous month.

Accessing your reports

There are 3 ways to access your settlement reports.

• Merchant dashboard
• Email
• SFTP

Dashboard

1. Sign in to your merchant dashboard:

• Affirm sandbox environment
• Affirm live environment

2. On the left navigation bar, 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 our bank initiates an ACH transfer for that payment. It may take 1 to 3 business days for it to appear in your bank account.

Email

You can schedule emails with settlement reports to any email address.

1. Sign in to your merchant dashboard

• Affirm sandbox environment
• Affirm live environment

2. On the left navigation bar, click Settings
3. Click the Scheduled Reports tab
4. Click the (+) icon next to EMAIL PREFERENCES
5. Enter the email address for the recipient
6. Select which report to send (daily, weekly, monthly)

You can remove any recipient by clicking the X next to their name.

SFTP

You can choose to have settlement files sent to a secure FTP (SFTP) directory. Contact us at [email protected] or use the widget at the bottom of the screen and specify if you'll host the SFTP directory or if you'd like to use one hosted by Affirm. The file name conventions for settlement reports sent to an SFTP directory are:

• Merchant-name_start-date_end-date_details.csv
• Merchant-name_start-date_end-date_summary.csv

If you're hosting the SFTP directory, we'll provide an Affirm public IP address for you to whitelist after you send us:

• The SFTP server address
• The port number
• The directory path (if applicable)
• Basic authentication credentials (if applicable)

If you'd like to use an SFTP directory hosted by Affirm, we'll 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

Download a sample settlement report here

Download a sample parent 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 talk to your Affirm counterpart to determine if you should be using a Parent Settlement Report.

If you would like to receive a Settlement Report from your Sandbox environment, please reach out to your Affirm technical counterpart.

How to read your reports

Standard settlement reports include the following details:

Reconciling your settlements

• The date of the settlement file is the date we initiated the ACH transfer to your bank account, which is a different date than when the charge was processed.
• Take the sum of all the amounts in the total_settled column that have the same Deposit ID. This sum should equal the amount of the deposit made into your bank account.
• If you use Order ID, take the sum of all the amounts with the same Order ID across different reports to calculate the final state of that order.
• You can optionally map each Transaction_id to your accounts payable or accounts receivable in your accounting system.