Skip to main content

Merchant Help


Affirm Merchant Help

Settlement Reports


Settlement Reports are available in your Affirm Merchant Dashboard. This article describes how to access those reports and what they contain. You will need this settlement information to reconcile transactions with the deposits into your bank account.

Accessing Reports

  1. Log into your Affirm Merchant Dashboard. If you don't have access to the dashboard, click here to learn how to request access. 
  2. Hover over the left-side navigation bar and click on 'Settlements'.
  3. A list of settlements appears with the date initiated, sub totals, and total settled.
  4. The 'Date' for these settlements is the date the settlement was initiated from our bank.
    Note:  These settlements typically take 1-3 business days to be reflected in your bank account.





  • Daily reports are sent Monday - Friday @ 6:30 PM PST (Tuesday - Saturday @ 2.30 AM UTC)
    • The daily report will contain the data for the previous day. (e.g. Tuesday 6:30 PM PST report contains Monday's UTC charges)
    • Charges included in the reports will be between 12:00 AM to 11:59 PM UTC
    • Monday report will contain Friday, Saturday, Sunday settlements (as no settlements happen on Saturday or Sunday)
  • Weekly reports are sent on Monday @ 6.30 PM PST
    • The weekly report will contain data for Monday - Sunday of the previous week
  • Monthly reports are sent on the first day of the month @ 6.30 PM PST
    • The monthly report will contain data for the whole previous month.


  • All these jobs are run using UTC standard, affecting the delivery during daylight savings time.
  • All times above indicate when the job starts running - if there is a large number of reports to be run, it could be delayed in delivery.

Report Details

  • There is one settlement report for each settlement to your bank account.
  • Each settlement is the net sum of all captures, refunds, disputes, and exceptions for the time-period listed.
  • Typically, there's one settlement every day that you capture an Affirm charge.

Standard settlement reports include the following transaction details:

Column name



Possible values


refers to when the event_type happened

Timestamp (UTC)



when the loan was originally created

Timestamp (UTC)



Internal Affirm charge ID. Charge IDs remain the same even when a refund is issued.

String (9-character alphanumeric)



16-character alphanumeric value which is unique for each charge interaction

String (16-character alphanumeric)



Optional. Populated with the value you provide in the checkout object, or a charge update API call. If you do not provide a value, it will be empty. Order IDs remain the same even when a refund is issued.

If you do not currently pass us your internal order ID, please follow these directions to do so. 

String (fewer than 128 characters)



The charge event that was processed.


  • loan_captured

  • loan_refunded

  • dispute_opened

  • dispute_resolved

  • fee_adjustment



Float (USD)

  • Positive float

    • ‘loan_captured’

    • ‘dispute_resolved’  (Merchant wins the dispute)

  • Negative float

    • 'dispute_opened'

  • 0

    • ‘loan_ refunded’

    • 'dispute_resolved' (Merchant loses the dispute)



Float (USD)

  • Negative float

    • ‘loan_ refunded’

  • 0

    • ‘loan_captured‘

    • ‘dispute_opened’

    • ‘dispute_resolved’  (merchant wins the dispute)

    • ‘dispute_resolved ‘(merchant loses the dispute



Float (USD)

  • Negative float

    • ‘loan_captured ‘

    • ‘dispute_resolved’  (merchant wins the dispute)

  • Positive float

    • ‘loan_ refunded’

    • ‘dispute_opened’

  • 0

    • ‘dispute_resolved ‘(merchant loses the dispute)



Float (USD)

Positive float

Deposit_id Identifier generated by Affirm for individual settlement deposited to your bank account. This ID would be shown as part of the transaction details.  String (15-character alphanumeric)  

Analyzing Reports

  • The date of the settlement file is when we initiated the settlement to your bank account (not when the capture event was processed).
    Note: it can take 1-3 business days for the funds to hit your bank account. 
  • If you would like to see the individual transactions and events that compose of your daily sum, you can download a detailed report which includes the transaction in question, the activity on the transaction (loan captured, loan refunded, etc). and see line by line how much the transaction was for, what fees were paid to Affirm and the net amount that was deposited to you.

If you are looking at multiple days of settlements in the detailed reports, you can sum the "total_settled" by the "date".

Here's an example formula for spreadsheet applications.



Scheduling Reports

To add a new email report recipient:

  1. Go to the 'Settings' page
  2. Click the 'Scheduled Reports' tab on the settings page
  3. Click the '+' icon in the panel for 'Email preferences'
  4. Enter the email address you'd like to receive the settlement reports
  5. Select the report frequency (daily, weekly, monthly)

Email recipients can be removed, or edited by clicking the pencil icon next to each email address entry.

Example File

You can download a sample settlement file here: 


SFTP Delivery

If you prefer to have settlement files delivered to an SFTP directory, please contact and 

File Name Convention

  • Merchantname_start-date_end-date_details.csv
  • Merchantname_start-date_end-date_summary.csv

Example: Merchantname_2016-01-01_2016-04-14_details.csv (note use of underscores and hyphens to separate dates)