There are two methods of reconciliation, depending on the payment provider:
- Bulk reconciliation, or
- Custom report reconciliation
The sale_reconciliation_identifier and reconciliation_identifier parameters are available in these files for unique matching of actions. Make sure to generate a unique identifier per action and to always include it when doing the corresponding capture or refund.
Then, a funding file is created and made available. One payout on your bank account equals one file. For each capture and refund, there is one record in the post-settlement reports. The acquirer fee is included per row for each of the actions.
The funding files can be uploaded directly to your ERP system, using either:
The fundingList API call includes 100 records per page, and the newest funding is available on page 0.
You need to keep track of which files you have downloaded and call the fundingList method to check for new files regularly (for example once per day).
Bulk reconciliation files are available for the following acquirers and payment providers:
For payment methods, where bulk reconciliation is not available because the payments are paid out separately for each transaction, you can download a list of expected fundings, using a custom report and the getCustomReport API method.
Just as with the bulk reconciliation files, the reconciliation_identifier set is included for the action, and a column called expected statement where you can find what to expect to see on your bank account for each of the transactions.
You can use the expected funding data to match transactions with your bank, for the following providers:
|Provider and report name||Custom report ID|
|Ideal Expected fundings||9493a5f7-4450-4ac3-b440-4d41572a8b09|
|Pbs Dankort Expected fundings||fc52225a-649f-43ff-8910-f09b3a01891f|
|Sofort Expected Fundings||fd259cf1-58c3-4be7-a5d2-a9e972d0d1af|
For information about reconciling Dankort transactions using the text on the bank statement, see the FAQ.