Last updated 5 months ago
Settlements are made available whenever it reaches us. This happens at different times, depending on the PSP. For some it can be multiple times per day, while others more rare, like once a week. This usually is according to when money is paid out to the merchant account.
Endpoint for fetching CSV reports curl -i -X GET \ https://api.spensepay.com/partner/settlements/generate_csv \ -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \ -H 'Content-Type: application/json' \ -H 'X-Organization-Id: string' \ -d '{ "from_date": "2025-01-01", "to_date": "2025-01-31", "format": "transactions" }' Column Number Title Description 1 Type Always A for header entries. 2 Total Payouts The total number of payouts in the report. 3 Total Transactions The total number of transactions in the report. 4 Transaction Amount The transaction amount. 5 Fee Amount The fee amount. 6 Amount paid out The total amount paid out to the merchant. 7 Amount for invoicing later The total amount to invoice the merchant.
Column Number Title Description 1 Type Always R for provider summary entries. 2 Payment Provider The name of the payment provider. Example: WORLDLINE 3 Total Payouts The total number of payouts for the payment provider. 4 Total Transactions The total number of transactions for the payment provider. 5 Transaction Amount The total transaction amount for the payment provider. 6 Fee Amount The total fee amount for the payment provider. 7 Amount paid out The total amount paid out to the merchant for the provider. 8 Amount for invoicing later The total amount to invoice the merchant for the provider.
Column Number Title Description 1 Type Always P for payout entries. 2 Payment Provider The name of the payment provider. Example: WORLDLINE 3 Date The date the payout was made. Format: YYYY-MM-DD 4 Reference A reference to the payout. Example: 123456 5 Report ID The ID of the report. Example: 123456 6 Transaction Count The number of transactions in the payout. Example: 10 7 Purchase Amount The total amount of the transactions
Column Number Title Description 1 Type Always T for transaction entries. 2 Payment ID Unique Spense Payment ID. 3 Order Number (if available) 4 Payout Reference 5 Paid out date 6 Payout type (NET or GROSS) 7 Transaction Reference 8 Parent Transaction Reference No longer in use, will always be blank. 9 Transaction Amount 10 Transaction Fee 11 Transaction Amount Paid Out 12 Transaction State This field indicates transaction type: SETTLED , REFUNDED , or FEE , based on provider agreements or refunds. 13 Currency 14 Transaction Date