Import and parsing of bank statements into an accounting table

We are looking for a developer to set up the import of bank statements into a single accounting spreadsheet. Every month we receive files from several banks in different formats: tables, workbooks and plain text dumps, where dates, amounts and payment descriptions are written in different ways. The task is to build a script that detects the format of each bank, normalizes the data into a common structure and stores it in one table with columns for date, counterparty, amount, currency and purpose. Next we need automatic categorization of transactions by rules: rent, salaries, taxes, purchases, bank fees and so on. The rules must be easy to extend without rewriting the code. A separate and important part is reconciliation: the script matches incoming and outgoing payments against our internal ledger and flags discrepancies, duplicates and missing entries. At the end of the month we need a summary report broken down by category, by bank and by counterparty, plus the opening and closing balance for the period. We value careful error handling: if a row cannot be recognized, it must not be lost but placed into a separate list for manual review. Please attach examples of similar solutions and describe how you store the categorization rules and how you add support for a new bank.