Generate your AP aging report in Bill.com automatically each month
On the first business day of each month, WebRun opens Bill.com and pulls every unpaid bill, organizes vendor balances into current, 1 to 30, 31 to 60, 61 to 90, and over 90 day aging buckets, exports the full aging report to Google Sheets, and posts a summary with totals by bucket to your finance Telegram group.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically generate a monthly AP aging report from Bill.com?
On the first business day of each month, WebRun opens Bill.com, pulls every unpaid bill, classifies vendor balances into current, 1 to 30, 31 to 60, 61 to 90, and over 90 day aging buckets, and exports the full report to Google Sheets. A totals summary is posted to the finance Telegram group so the controller has a complete AP aging picture before the monthly review.
- The monthly AP aging report is ready on the first business day without a manual export
- Vendors with balances over 90 days past due are highlighted for immediate attention
- The controller and finance team see an aging summary before the monthly review meeting
Built for controllers · CFOs · AP managers · accounting teams
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.bill.comin a real browser with your saved login - no setup, no API keys. -
1
Bill.com - pull all unpaid bills and calculate aging by vendor
bill.com How to Automate Bill.com
WebRun opens Bill.com to pull all unpaid bills and calculate aging by vendor. - Open Bill.com and pull all unpaid bills as of the end of the prior month
- For each bill, calculate days outstanding from the bill due date
- Group bills by vendor and assign each to an aging bucket: current (not yet due), 1 to 30, 31 to 60, 61 to 90, and over 90 days
- Calculate totals for each bucket and a grand total
Done when All unpaid bills are classified into aging buckets with vendor and dollar totals.
-
2
Google Sheets - export the full AP aging report by aging bucket
google.com How to Automate Google Sheets
WebRun opens Google Sheets to export the full AP aging report by aging bucket. - Open the AP aging workbook and write this month's report to a new tab named for the month
- Include a vendor detail section and a summary section with aging bucket totals
- Highlight vendors with any balance over 90 days past due
Done when The full AP aging report is complete in Google Sheets.
-
3
Telegram - post the monthly aging summary to the finance group
telegram.org How to Automate Telegram
WebRun opens Telegram to post the monthly aging summary to the finance group. - Post a summary to the finance Telegram group: total AP balance, balance by aging bucket, and the count and dollar value of invoices over 90 days
- Include a link to the Google Sheets report for the full vendor detail
Done when The finance team has the monthly AP aging summary in Telegram.
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 make any payments or changes in Bill.com when it runs?
No. WebRun only reads bills and exports data. Nothing in Bill.com is changed, approved, or paid during the aging report run.
Can I get the report on a different cadence, such as weekly?
The default is monthly on the first business day, but WebRun can be configured to run the aging report weekly if your close process requires it.
What if a bill is disputed and should not appear in the aging?
Bills in Bill.com marked as disputed will appear with their status noted in the Google Sheets report, so your controller can decide how to present them to management.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.