Finance & accounts

Invoice and payment reconciliation

Reconciliation is the clearest example of a task that's important, entirely mechanical, and still done by a person every single day.

How it happens today

  • ×Someone logs in to the banking portal each morning and downloads yesterday's statement as a CSV or PDF.
  • ×They open the accounting app and work down the list, matching each credit and debit against an open invoice or bill.
  • ×Anything that doesn't match cleanly gets noted in a spreadsheet to chase later — and often gets forgotten.
  • ×The whole thing takes 45 minutes to two hours, every working day, and it has to be redone from scratch if they're on leave.

The task that replaces it

Four tools chained into one scheduled task. Steps 1 and 3 are tools you record once against your own portals; step 2 is your accounting app; step 4 is a built-in spreadsheet utility.

TaskMate — Daily reconciliation
1Download yesterday's statement
Banking portal · recorded tool
deterministic
2Fetch open invoices and bills
Accounting web app · your tool
138 rows
3Match on amount, date and reference
Built-in matching utility
deterministic
4Mark matched, export exceptions
Accounting app + spreadsheet utility
9 exceptions
Runs every weekday at 07:30 · last run 41s

What changes

  • It's done before anyone arrives. The schedule runs at 07:30; the exception list is waiting rather than being produced at 11am.
  • Exceptions stop getting lost. Anything that doesn't match cleanly lands in one place every day instead of a spreadsheet someone means to get back to.
  • It survives holidays. The task doesn't care who's in the office, and the run log shows exactly what it did on any given day.

Questions on this one

What if the bank changes its statement layout?
The run stops on that step and tells you what it couldn't find, rather than guessing. Re-record that one step and the rest of the task carries on unchanged.
Can it post entries, or only match them?
Both, but we'd suggest starting read-only: let it produce the matched list and the exceptions for a couple of weeks, and turn on writing once you trust it.

Stop being the integration between your own tools.

Start on the free plan — 150 credits every month, no credit card, no sales call.

Start Free Trial Talk to us