Home / Case studies / Payment creation from bank files
Al Dahra · Agribusiness & trading · Finance & accounting
Payment creation from bank files
Over 4,000 payments a month created in Sage from bank flat files, with no manual entry. A bank file payment automation Sage project for Al Dahra, built with UiPath · FTP · Bank flat files (TXT/CSV) · Sage ERP.
The problem
Payment records had to be created in Sage from bank flat files: over 4,000 a month at 6–9 minutes each, handled by a team of 4–5 people.
What we built
The automation picks up daily text files from an FTP location, parses each transaction, maps it to the right vendor or employee and creates the payment in Sage with the bank reference for traceability.
Results
- Work of a 4–5 person team fully automated
- Hours of processing reduced to minutes
- Every payment traceable to its bank reference
How we'd build it today
An agent now matches ambiguous beneficiaries and partial references, and explains any payment it could not post.
Built with: UiPath · FTP · Bank flat files (TXT/CSV) · Sage ERP
Related
More in Finance & accounting
Supplier invoice processing into Sage
65% Less manual effort on invoice managementSupplier invoices in any format captured, matched to POs and posted to the ERP, live in six weeks.
Exchange rate updates into the ERP
100% Schedule compliance, with no manual trackingDaily, weekly and monthly FX rates updated in the ERP on schedule, every time.
Intercompany transaction mirroring
Eliminated Double entry for intercompany transactionsIntercompany transactions mirrored automatically across group entities, with no double entry.
Tell us which task you'd switch off first
Bring one process. In 30 minutes we'll tell you whether it's worth automating, which KPI we'd move and how we'd get there in 8 weeks.