Daily bank reconciliation
Statements matched to the ledger before the team arrives.
Common in: Banking, Insurance, Telecommunications, Finance and accounting
Before
- Download yesterday's statements from each bank portal
- Match thousands of lines to the ledger in a spreadsheet
- Chase the ones that don't match, one by one
- Prepare the daily report before the morning meeting
With Exekra
- 1Starts at six, before the team arrivesA schedule in the Hub, around your holiday calendar
- 2Reads the statement exportsExcel and file steps
- 3Matches each line to the ledgerRules built and tested in Studio
- 4Looks up what is missing in the bank portalBrowser steps, with a credential the Hub holds
- 5Hands what still doesn't match to a personA Hub worklist, with the evidence for each item
- 6Saves the reportTo the share the team already uses
Potential improvements
- The report is ready when the team arrives
- Every exception has an owner and a due date
- Each run, and the hours it returned, is recorded in the Hub
People stay involved
The reconciliations team decides the exceptions. Everything they need is on the worklist item.