Automated Trovata Bank Reconciliation Worklist
Every morning, WebRun opens Trovata, finds bank transactions older than your reconciliation tolerance that have no matching ledger entry, and appends each unreconciled item to an Airtable worklist with the account, amount, date, and description so your team has a clear queue to work through.
How do I automatically track unreconciled bank transactions and build a worklist for my team?
WebRun opens Trovata every morning, identifies bank transactions that have aged past your reconciliation tolerance without a matching ledger entry, and logs each item in an Airtable worklist with the account, amount, date, and description, giving your team a clear, prioritized queue to work through before the backlog grows further.
- Unreconciled transactions surfaced every morning before they age further
- Reconciliation team opens Airtable to a prioritized queue each day
- Duplicate entries prevented by daily dedup check
Built for treasury analysts · finance controllers · accounting teams · CFOs
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.trovata.ioin a real browser with your saved login - no setup, no API keys. -
1
Trovata - find unreconciled bank transactions
trovata.io
WebRun opens Trovata to find unreconciled bank transactions. - Open Trovata and filter to transactions with no reconciliation match
- Apply the tolerance window to exclude transactions that are still within the acceptable match period
- Capture the account, bank, transaction date, amount, reference, and description for each unreconciled item
- Sort by transaction date, oldest first
Done when All overdue unreconciled transactions are listed in age order.
-
2
Airtable - log each item in the reconciliation worklist
airtable.com
WebRun opens Airtable to log each item in the reconciliation worklist. - Open the Bank Reconciliation Worklist Airtable base
- Check whether each transaction is already present to avoid duplicates
- Add a new record for each new unreconciled item with all captured details and today's date
- Set status to Open for new records
Done when Every new unreconciled transaction has a record in the Airtable worklist.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What tolerance window does it use?
You configure the tolerance during setup. Common choices are 1 business day for high-volume accounts and 3 to 5 business days for lower-frequency accounts. WebRun applies your rule on every morning run.
Will it try to match or post the transactions itself?
No. WebRun identifies unreconciled items and logs them for your team to review. Posting journal entries or marking items as reconciled in your accounting system requires a human decision.
What if an item is resolved after it was already added to the worklist?
WebRun checks for existing records each morning to avoid duplicates. Your team marks resolved items as Closed in Airtable, and WebRun will not re-add them on subsequent runs.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.