Skip to main content

Merchant Help

 

Affirm Merchant Help

Settlement Reports

Overview 

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.

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

Description

Format

Possible values

Date

refers to when the event_type happened

Timestamp (UTC)

 

Charge_created_date

when the loan was originally created

Timestamp (UTC)

 

Charge_id

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

String (9-character alphanumeric)

 

Transaction_id

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

String (16-character alphanumeric)

 

Order_id

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)

 

Event_type

The charge event that was processed.

String

  • loan_captured

  • loan_refunded

  • dispute_opened

  • dispute_resolved

  • fee_adjustment

Sales

 

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)

Refunds

 

Float (USD)

  • Negative float

    • ‘loan_ refunded’

  • 0

    • ‘loan_captured‘

    • ‘dispute_opened’

    • ‘dispute_resolved’  (merchant wins the dispute)

    • ‘dispute_resolved ‘(merchant loses the dispute

Fees

 

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)

Total Settled

 

Float (USD)

Positive float

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.

=SUMIF($A$2:$A$1000,"2/12/17",$I$2:$I$1000)

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: Sample_Merchant._settlement_2016-12-13_2016-12-14_details.csv

SFTP Delivery

If you prefer to have settlement files delivered to an SFTP directory, please contact merchanthelp@affirm.com 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)