Contents
Reading your settlement report
If you choose to receive your settlement reports via email or by SFTP, you will receive a detailed report file (.csv) by default, and a summary file upon request. The summary report provides totals for a quick snapshot of performance, while the detailed report breaks down each individual event, offering a comprehensive view of all activities.
Opening up a detailed report may resemble the example below:
For your reference, you can download a sample settlement report here.
Standard settlement reports feature a variety of details, with the format column being particularly beneficial for developers seeking greater control over the data. Items highlighted in bold are included by default, whereas non-bolded items are optional and may require additional configuration to be included. The data will be presented in the report following the specified column order, and opting out of optional columns will not alter this sequence.
If you have additional needs not represented in this report, please contact our Merchant Care team.
| Name | Format | Description |
| date | String (ISO 8601 UTC) | The date that affirm initiates ACH disbursements to your bank account. |
| charge_created_date | String (ISO 8601 UTC) |
The date on which the loan is captured (ex: 2022-11-30). |
| charge_id | String (9 alphanumeric characters) | Affirm's persistent transaction identifier. The Charge ID remains even after you refund a charge. |
| transaction_id | String (16 alphanumeric characters) |
An Affirm generated unique value is created for each charge transaction. Capturing a charge and then voiding the charge will create 2 different Transaction IDs.
This value is only useful when using the Charges API. When using the Transactions API, use the “merchant_transaction_id” column to track loans end to end. |
| order_id | String (128 alphanumeric characters maximum) | Merchant generated identifiers are typically used in their own internal system to track the order. This is an optional value that you provide in the checkout object. If you do not provide Order IDs, this column will be empty. |
| event_type | String |
This is the current state of the charge. Possible values are:
|
| sales | Float (USD dollars) | This is the amount of the sales transaction and may be positive, negative, or zero. When you capture the loan or win a dispute, “sales” is the positive value of that transaction. When a customer opens a dispute, “sales” is zero and the negative value of that transaction is reflected under “refunds.” |
| refunds | Float (USD dollars) | This is the amount of the refund and may be a negative value or zero. When you refund a loan, “refunds” are the negative value of the refund. In all other cases, “refunds” are zero. |
| fees | Float (USD dollars) | This is the fee that Affirm charges for this transaction and may be positive or negative. When you capture a loan or resolve a dispute, fees will be a negative value. If you refund a loan or if a customer opens a dispute, fees are a positive value. |
| total_settled | Float (USD dollars) | This is the total amount deposited into your bank account. It is the sum of all “sales,” “refunds,” and “fees.’ This value can either be positive or negative. |
| merchant_name | String | The name of the Affirm account. Confirm with Affirm if you would like to enable this property. |
| financing_program | String | If the customer qualified for a financing program, the program name will be listed here. |
| entity_name | String | If you have multiple channels that use the same API keys, the “entity_name” is an optional string you can provide in the checkout object. |
|
merchant_transaction_id
Optional for Charges API |
String | Merchant generated ID used to track each instance of a charge action. This replaces the functionality of ‘transaction_id’ in the Transactions API. |
|
txn_fees
If applicable, this field will be required |
Float (USD dollars) |
This is a transaction fee that is charged by Affirm for processing a loan (Not to be confused with “fees” as this is charged outside of that).
Note: This column does not populate on the ‘Parent’ company report. |
| deposit_id | String (15 alphanumeric characters) | Affirm assigns this random string related to a single deposit to every charge in a settlement. Each charge with the same “deposit_id” was deposited on the same day. For any given day you’ll have a “deposit_id” per lending partner that was involved in a charge for that day. |
| dispute_reason | String | For dispute events, details on the reason for the dispute will be listed here. Confirm with Affirm if you would like to enable this property. |
Reconciling your settlements
For straightforward reconciliation, you have the option to filter out or hide additional information, allowing you to focus on key figures such as total_settled.
- The date of the settlement file is the date Affirm 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 a deposit made into your bank account. You may have multiple deposits each day (one per lending partner).
- 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 merchant_transaction_id to your accounts payable or accounts receivable in your accounting system.
Note: Affirm is making enhancements to settlement reporting and will be rolling out enhancements in the coming months. If you received communication regarding updated settlement reporting, please visit the Reading and reconciling your settlement reports: August '24 update. Please reach out to merchantcare@affirm.com or your account representative directly with any questions.