Bank Transaction Data Automation

A large ASX-listed financial services group had over 40 bank accounts across 7 banking relationships in three countries - and no automated way to consolidate them. Each week, a single employee spent two full days manually downloading CSV exports from each bank's proprietary portal, collating the data in Excel, and categorising transactions by hand. The result was a management report that was out of date for most of the week and disconnected from any operational process in the ERP.

Rather than pursuing time-consuming API integrations across 7 institutions, I built a smarter path: a pipeline that ingested each bank's existing CSV format directly, with controls to prevent duplicate ingestion and detect gaps in the transaction record. Files were simply dropped into a SharePoint folder - a task taking under a minute - and the pipeline handled the rest, consolidating data across all accounts and making it available daily for operationally critical banks.

On top of the consolidated data, I built a transaction recognition engine in SQL that matched keywords and account number combinations to automatically suggest the appropriate journal entry for each transaction. Accountants reviewed, added one-off entries where needed, and loaded the full journal into Dynamics 365 at the click of a button. The result: a process that had consumed two full days of staff time each week was reduced to minutes, daily cash visibility replaced a weekly snapshot, and bank transaction data fed directly into the ERP - eliminating a separate manual posting step entirely.