The problem
Bank lines were matched by eye and client packs were assembled by copying between workbooks.
What we built
A reconciliation agent, an Excel workbook built to last, and a pack generator that reads from both.
The result
- Before
- 33,600keystrokes a year
Four days.
- After
- keystrokes a year
One morning.
A keystroke is one thing a person had to type or click.
| Date | Bank line | Amount | Matched to | Result |
|---|---|---|---|---|
| 03 Mar | EFT 4471 | 1,280.00 | INV-2207 | Matched |
| 03 Mar | EFT 4472 | 640.50 | INV-2198 | Matched |
| 04 Mar | DD Telco | 219.00 | BILL-0871 | Matched |
| 04 Mar | EFT 4475 | 3,905.00 | INV-2211 | Matched |
| 05 Mar | Card 8841 | 74.90 | RCPT-3310 | Matched |
| 05 Mar | EFT 4479 | 2,150.00 | — | Listed |
| 06 Mar | EFT 4480 | 980.00 | INV-2215 | Matched |
An illustration of the build running, with sample data.
Every job is quoted individually after a free consultation.
Book a free consultation