Reconcile payouts against bank deposits by reference
Match provider settlements to bank deposits by exact reference, currency and signed amount, with exceptions linked to source rows.
How this check works
Inputs and matching rules
Use the following exports: Provider payouts, Bank deposits.
- Compare exact, case-sensitive references after trimming spaces.
- Require unique references and the same currency before comparing signed decimals.
- Show unmatched references on either side.
Read the evidence
In the sample, BK-102 shows USD 85.30 in the payout file and USD 83.30 in the bank file. BK-103 and BK-104 both carry 52.00, yet their references differ; a matching amount alone does not tie them out.
What the result can establish
Use one account, one row per reference, and only relevant bank transactions. Date or amount alone cannot identify a match.