Here we explain how to reconcile individual transactions on PSP with the aggregate settlement pay ins to the balance account and to identify balance account top-ups.
Pay in flow and reporting
Use the following reports to reconcile transactions across your pay ins on PSP and transfers to your balance accounts:
For merchants using a balance platform strictly for a pass-through transfer mechanism, filter the Balance Platform Accounting Report or the Balance Platform Statement Report on the following columns and values:
- Category: platformPayment
- Type: balanceAdjustment
- Status: booked
- Reference and Description columns contain the following information in JSON format:
- merchant account
- currency
- settlement batch number
You can reconcile these pay in transfers by retrieving the Settlement Details Report for the corresponding merchant account, with the matching batch number.
Filter the Settlement Details Report on the following columns and values:
- Type: BalancePlatformTransfer
- Currency
The Settlement Details Report will contain top-ups (type = reserveAdjustment) and/or individual transactions (type = capture, refund, chargeback, etc.), their gross amount, the fees, and net amounts, which add up to the BalancePlatformTransfer amount.