Build your team a prioritised overdue invoice worklist every morning
Every morning, WebRun opens Versapay, extracts all overdue invoices, ranks them by balance size and aging bucket, writes the prioritised worklist to a shared Google Sheet, and pings the AR team in Slack so they know the list is ready.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I get a prioritised overdue invoice worklist for my AR team every morning?
WebRun opens Versapay each morning, pulls every overdue invoice, and ranks them by aging bucket and balance size in a shared Google Sheet. A Slack message alerts your AR team with the total overdue value and the top three accounts, so the team can start working the highest-priority items the moment they sit down.
- AR team starts every morning with a ranked, ready-to-work invoice list
- Highest-value overdue balances are surfaced first, every day
- No manual export or spreadsheet prep needed
Built for AR managers · credit teams · finance operations · B2B companies with large receivables books
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.versapay.comin a real browser with your saved login - no setup, no API keys. -
1
Versapay - extract all overdue invoices
versapay.com How to Automate Versapay
WebRun opens Versapay to extract all overdue invoices. - Open Versapay and navigate to the open invoices view
- Filter to all invoices past their due date
- Capture customer name, invoice number, amount, due date, and days overdue for each
Done when A full list of overdue invoices with their details has been collected.
-
2
Google Sheets - write ranked worklist
google.com How to Automate Google Sheets
WebRun opens Google Sheets to write ranked worklist. - Open the shared AR worklist Google Sheet
- Clear yesterday's rows and paste today's overdue invoices
- Sort by balance descending within each aging bucket (1-30, 31-60, 61-90, 90+ days)
- Apply conditional colour coding so the oldest, largest invoices stand out
Done when The sheet shows today's full ranked overdue invoice list, ready for the team to work.
-
3
Slack - notify AR team the list is ready
slack.com How to Automate Slack
WebRun opens Slack to notify AR team the list is ready. - Post a short message to the AR Slack channel with the total overdue count and value
- Include a direct link to the Google Sheet
- Call out the top 3 largest balances by name
Done when The AR team has been alerted and has the link to start working the list.
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
Does it send any messages to customers?
No. This workflow only produces an internal worklist in Google Sheets and a Slack notification for your team. No customer-facing messages are sent or drafted.
How are invoices prioritised in the list?
Invoices are sorted by balance descending within each aging bucket (1-30, 31-60, 61-90, and 90-plus days), so your team tackles the highest-value and oldest risk first.
Can we customise which accounts are included?
Yes. Tell WebRun to exclude certain customer groups, minimum balance thresholds, or accounts already on a payment plan, and it will apply those filters each morning.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.