Bank reconciliation
Match bank rows to accounting rows without burying exceptions.
Reconcile bank movements to journal or ledger rows.
Give it bank statements and journal or ledger rows. Get back accepted matches, candidate matches, unmatched rows and a workbook that keeps thresholds visible.
What it does
From bank and journal files to a reviewable reconciliation
Use it when the journal-bank reconciliation is structurally different from open-item reconciliation: bank statement rows must be matched directly to journal or ledger rows.
input/
bank/
statement.xlsx
journal.xlsx
sample_movements.xlsxout/
inspection.json
suggested_recipe.json
reconciliation/
normalized_bank.csv
normalized_journal.csv
reconciliation_matches.csv
unmatched_bank.csv
unmatched_journal.csv
journal_bank_reconciliation.xlsx
reconciliation_audit.json
review_notes.mdInputs
What it reads
Reads local Excel, CSV and text-PDF inputs. OCR-only PDFs are flagged for review rather than treated as reconciled.
Outputs
What it produces
The result is a reviewable work folder: recipe, normalized bank and journal rows, match table, exception tables, workbook and review log.
Matches and exceptions stay separate
The inspection step proposes bank and journal fields and asks only for unresolved choices before the reconciliation files are produced.
The workbook keeps normalized inputs, accepted matches and unmatched rows apart, so exceptions can be reviewed without losing the source trail.
Prompts
Ready prompts
Start from one of these prompts and replace the file and folder paths. Codex will ask before resolving essential ambiguities.
Installation
Install from Plugin Pack
Requires Codex desktop. One ZIP installs all Mparanza plugins.
First use
In a Codex chat, provide the bank path, journal path, language and thresholds.
Use Journal-Bank Reconciliation on bank statements in /path/bank and journal file /path/journal.xlsx.
Language: en. Document language: auto.
Inspect columns and files, ask only for essential ambiguities, then generate reconciliation, checks and review log.