How to Match Bank Deposits to PSP Payouts
Your bank shows deposits. Your PSP shows payouts. They should match — but often they don’t, at least not directly. Here is a practical guide to connecting the two.
Why bank deposits and PSP payouts don’t match directly
PSP payouts and bank deposits differ for several reasons: timing (PSPs initiate payouts before they arrive in your bank); fee deductions (some PSPs show gross amounts in the PSP dashboard and net in the bank); combined payouts (multiple settlement periods batched into one bank deposit); and currency conversion if applicable.
Step 1: Export your bank statement
Download your bank statement for the period in MT940, CAMT053, or CSV format. Most business banking portals provide at least one of these formats.
Step 2: Export PSP payout data
Download the payout report from each PSP for the same period. This shows the payout amounts and dates as the PSP sees them — before bank processing delays.
Step 3: Apply a timing window
PSP payouts typically arrive 1–3 business days after initiation. When matching PSP payouts to bank deposits, apply a timing window of 1–5 business days to account for this.
Step 4: Handle combined deposits
Some PSPs batch multiple settlement periods into one bank deposit. When a bank deposit is larger than expected, check whether it covers multiple PSP settlement periods. Split the deposit across the matching settlement amounts.
Step 5: Flag unexplained deposits or differences
Any bank deposit that cannot be matched to any expected PSP payout — or that differs significantly in amount — should be flagged and investigated before the period is closed.