Compares the bank journal from your accounting software with the bank statement (Excel or CSV). Applies the debit/credit inversion, matches transactions by amount and date, and produces a four-tab Excel workbook: discrepancy summary, matched transactions, unmatched book entries, unmatched bank entries.
Compares the bank journal from your accounting software with the bank statement (Excel or CSV). Applies the debit/credit inversion, matches transactions by amount and date, and produces a four-tab Excel workbook: discrepancy summary, matched transactions, unmatched book entries, unmatched bank entries.
This resource is maintained by i2Business consultants and updated whenever the systems it covers change. It works with the other building blocks in the catalog and can be tailored to your context as part of a support engagement.
Excerpt: the inversion rule between the books and the statement, on which all matching relies. rapprochement-bancaire/SKILL.md
Money in: Debit in the books <-> Credit on the bank statement Money out: Credit in the books <-> Debit on the bank statement Pass A: same amount and date gap within tolerance (5 days by default) Pass B: same amount, whatever the date (date shift) Remainder: unmatched lines, with suggested analysis (fees, timing, data entry)
Our consultants tailor this resource to your use cases and train your teams in its day-to-day use.
Talk to a consultant