Automated Uncashed Check Escheat Import
Every Monday, WebRun opens QuickBooks, lists the accounts-payable checks still uncashed past your stale-date window, imports each one into Simple Escheat as an unclaimed-property record with the payee and amount, and posts the team a Slack summary of what was added.
How do I import uncashed AP checks into my unclaimed-property records automatically?
Every Monday, WebRun opens QuickBooks, lists the accounts-payable checks still uncashed past your stale-date window, and captures the payee, number, date, and amount for each. It imports every check into Simple Escheat as an unclaimed-property record and posts the team a Slack summary, so no stale check is missed when filing season arrives.
- Stale AP checks land in your escheat records the week they age out, not at year-end
- Every imported record carries its payee and amount, ready for review
- Duplicate and reissued checks are skipped automatically from live QuickBooks status
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 - find uncashed AP checks
- Open QuickBooks and run the uncleared-checks report on your bank and AP accounts
- Capture the payee, check number, issue date, and amount for each check still uncashed past your stale-date window
- Skip any check already voided, reissued, or previously loaded into Simple Escheat
Done when Every uncashed AP check past the stale-date window is listed with its payee, number, date, and amount.
-
2
Simple Escheat - import as unclaimed property
simpleescheat.com
WebRun imports each uncashed check into Simple Escheat as an unclaimed-property record. - Open Simple Escheat and use the drag-and-drop data import to add each uncashed check as an unclaimed-property record
- Map the payee, amount, check date, and property type onto the matching import template fields
- Leave every new record in the working list so a person can review it before any report is prepared
Done when Each uncashed check is loaded into Simple Escheat as an unclaimed-property record with its owner and amount.
-
3
Slack - report what was added
slack.com
WebRun posts a Slack summary of the checks imported into Simple Escheat. - Post the team a short summary of how many checks were imported and their total value
- Flag any check that could not be matched to an owner or amount so someone can fix it
- Note that the new records are waiting in Simple Escheat for review before filing
Done when The team has this week's import summary in Slack.
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 file anything with a state on its own?
No. WebRun only loads uncashed checks into Simple Escheat as unclaimed-property records and leaves them in the working list. A person reviews the records and prepares any report, so nothing is submitted to a state without approval.
How does it avoid importing the same check twice?
It checks each candidate against Simple Escheat before importing and skips any check already loaded, plus any check voided or reissued in QuickBooks, so records are not duplicated.
What if a check is uncashed but not really unclaimed?
It flags any check it cannot cleanly match to a payee or amount instead of importing it, so you can void, reissue, or reclassify before the record is created.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.