Statements come from several banks in different formats. Someone downloads each one, lines the transactions up in Excel and works through the mismatches by eye.
- Bank statements (CSV, PDF or feed)
- The ledger
- Your matching rules
Statements are brought into one format and matched against the ledger by rule. What's left is a short exception list (missing, duplicated or unexpected items), each with the reason it didn't match.
- One reconciled view
- An exception list
- A reconciliation report