Automated Outstanding Check Reconciliation
Every month, WebRun opens QuickBooks, lists the outstanding checks, matches each against the cleared items on the bank statement, updates Simple Escheat so cleared checks drop off and only truly uncashed ones remain, and writes the full reconciliation to a Google Sheet.
How do I reconcile outstanding checks to the bank before they escheat automatically?
Every month, WebRun opens QuickBooks, matches each outstanding check against the cleared items on the bank statement, and separates the checks that cleared from those still uncashed. It updates Simple Escheat so cleared checks drop off and only genuine unclaimed property remains, then logs the full reconciliation to a Google Sheet with cleared and outstanding totals.
- Cleared checks leave your escheat list the month they clear the bank
- Only genuinely uncashed checks stay on the filing track
- Every reconciliation is logged to a Google Sheet with a dated trail
Built for controllers · AP teams · corporate accounting · unclaimed property analysts
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
quickbooks.intuit.comin a real browser with your saved login - no setup, no API keys. -
1
QuickBooks - match outstanding checks to the bank
- Open QuickBooks and pull the list of outstanding checks alongside the latest bank statement
- Match each outstanding check to a cleared item on the statement by number and amount
- Separate the checks that have now cleared from those still genuinely uncashed
Done when Every outstanding check is marked as cleared or still uncashed against the bank statement.
-
2
Simple Escheat - update the unclaimed-property list
simpleescheat.com
WebRun updates Simple Escheat so cleared checks drop off the unclaimed-property list. - Open Simple Escheat and find the unclaimed-property records tied to the reconciled checks
- Remove or close any record whose check has now cleared the bank
- Leave the records for the checks still uncashed so they stay on the escheat track
Done when Simple Escheat reflects only the checks that are still genuinely uncashed.
-
3
Google Sheets - log the reconciliation
google.com
WebRun logs the full check reconciliation to a Google Sheet. - Write the month's reconciliation to a Google Sheet with one row per check
- Record the check number, amount, whether it cleared or stayed uncashed, and the resulting Simple Escheat action
- Total the value that cleared and the value still outstanding for the month
Done when The Google Sheet holds a full, dated reconciliation of every outstanding check.
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
Will it remove a record before I have checked it?
It only closes a Simple Escheat record when the matching check is confirmed cleared on the bank statement, and it logs every change to a Google Sheet. You can review the full reconciliation, so no record is dropped without a visible trail.
How does it match a check to the bank statement?
It matches each outstanding check to a cleared item by check number and amount in QuickBooks, so a check that cleared is separated from one still uncashed before Simple Escheat is touched.
What happens to checks that are still uncashed?
They stay on the escheat track. WebRun leaves their Simple Escheat records in place so genuinely unclaimed checks continue toward dormancy and filing.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.