Settlement reports
Our system has the ability to provide consolidated settlement reports for a wide variety of payment service providers.
Our settlement reports provides detailed records of all the financial transactions processed through each of
your configured payment services.
Ingestion
You have to configure a payment service to allow us to ingest the daily settlement data for each of your merchant accounts. We run a daily ingestion cycle for each connection that you have enabled settlement report ingestion for.- Each day at 2am UTC we will fetch all the reports that have been created by your payment services between 00:00 and 23:59 UTC the day before.
- After the ingestion is completed we store the data in your merchant instance and we will start generating a consolidated, universal settlement report, combining data from all the ingested files.
- At 1am UTC the following day we will make this report available.
- One hour later, at 2am, we will start obtaining the reports from the payment services that were created the previous 24 hours to continue the ingestion and creation cycle.
Reconciliation
Settlement reports include various pieces of data, including details on the captured funds, deducted fees, and net amounts transferred to your account. They are crucial for reconciling your accounts, managing cash flow, and ensuring accurate financial records. We will automatically match each ingested record against your transactions, providing you with settlement data directly in our dashboard. Where possible, we try to match the transaction and add any of the reported fees to the transaction records.Universal reports
Finally, the consolidated settlement report is a transaction level report of the ingested data from all your configured payment services, conveniently combined into one report. The report is generated on a daily basis by ingesting settlement details from your configured connections, and then generating a daily CSV with the reported settled transactions.Supported features summary
Different PSP settlement reports offer varying levels of reporting granularity. As a result, not every integration supports the same level of detail. Full end to end reconciliation with your bank statement may also not be possible. Below is a table summarizing the supported features of each settlement reporting integration.| Payment service | Definition | Settlements | Fees | Fee breakdown | Refunds | Chargebacks | Other journal types | Full reconciliation possible? | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Adyen | adyen-card | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| Braintree | braintree-card | Yes | Yes | No | Yes | No | No | No | Only card and card-like transactions. |
| Cybersource | cybersource-card | Yes | No | No | Yes | No | No | No | Only card transactions. Currently in early beta; fields mapping may change. |
| Nuvei | nuvei-card | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| PayPal | paypal-paypal | Yes | Yes | No | Yes | Yes | Yes | Yes | Only PayPal transactions. |
| Stripe | stripe-card | Yes | Yes | No | Yes | Yes | Yes | Yes |