PSP payout lands as one amount on the bank, how do I match it to individual invoices?
Stripe, Mollie and Adyen send a bulk payout for multiple transactions minus their fee. You need a clearing account per PSP, then it reconciles cleanly.
Try this first
- 1Create a separate clearing account per PSP in the ledger (for example 1100 Mollie, 1101 Stripe, 1102 Adyen).
- 2Book every customer payment to that clearing account, not directly to the bank.
- 3Book the PSP payout from the clearing account to the bank, so the balance walks back to zero.
- 4Book the PSP fee on a separate line as a cost, so both payout and matched invoice are correct.
- 5Reconcile the clearing account monthly, a residual balance means a missing fee line or currency mismatch.
When to bring us in
If the clearing account drifts structurally, we can help tune the booking rules and chart of accounts.
See also
- Switching from Exact Online to Yuki, open items and history do not matchPackage migrations stumble on ledger mapping and open AR/AP. Without a mapping table you lose context.
- Twinfield to Exact, dimensions and cost centres go missingTwinfield uses dimensions, Exact uses cost centres and projects. The mapping is not one-to-one.
- Accountant asks for RGS mapping, your ledger does not follow RGSRGS is the Dutch standard chart that SBR filings and accountant software expect. Without mapping, every year-end is manual.
None of the above fits?
Describe your situation below. We pass your input plus the steps you already saw to our AI and return tailored next-step advice. If it's too risky to DIY, we'll say so.
Or skip the DIY entirely
Our Managed IT clients do not look these things up. One point of contact, a fixed monthly price, resolved within working hours.