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.
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
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
Start with amount_diff and timing_diff. PSP settlements often have same-reference timing differences caused by settlement delay.