Bank vs PSP
Reconcile a bank statement against a payment service provider export.
Use this workflow when a bank statement must agree with a PSP settlement or transaction export. PSP exports typically store amounts in minor units, while bank exports use major units, so the multiplier differs between the two sources.
Config pattern
sources:
bank:
file_pattern: "data/bank/*.csv"
parser:
type: csv
date_col: "Date"
date_layout: "2006-01-02"
amount_col: "Amount"
decimal: "."
thousands: ","
multiplier: 100
currency_col: "Currency"
ref_col: "Reference"
name_col: "Details"
psp:
file_pattern: "data/psp/*.csv"
parser:
type: csv
date_col: "created"
date_layout: "2006-01-02"
amount_col: "amount"
multiplier: 1
currency_col: "currency"
ref_col: "id"
name_col: "description"
pairs:
bank_vs_psp:
left: bank
right: psp
date_window: "1d"
amount_tolerance_minor: 0
name_mode: "tokens"Run
Check each source's column mapping before the full run, then reconcile.
reconify config check-source --source bank --file data/bank/jan.csv
reconify config check-source --source psp --file data/psp/jan.csv
reconify reconcile --pair bank_vs_psp --format ndjson --out results.ndjsonReview
amount_diff and timing_diff are the first sections to inspect. PSP settlements often have same-reference timing differences caused by settlement delay rather than missing transactions.