Automated Bill.com Weekly Payment Run Report
Every Monday, WebRun opens Bill.com, pulls all approved and unpaid bills due within 7 days, groups them by vendor and payment date, calculates the total cash required, and exports a summary to Microsoft Excel. A snapshot is also posted to Slack so your AP and finance teams are aligned before the run.
How do I automatically generate a payment run report from Bill.com each week?
Every Monday, WebRun opens Bill.com, pulls all approved bills due in the next 7 days, groups them by vendor and due date, and exports the full payment schedule to Microsoft Excel. A summary is posted to Slack so your AP and finance teams are aligned and ready before the payment run begins.
- Your team knows exactly what is due and how much cash is needed before the payment run starts
- Vendors missing a payment method are flagged early so the run is not delayed
- Finance and AP are aligned every Monday with the same payment run view
Built for AP teams · controllers · CFOs · finance managers
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 approved bills due within 7 days
bill.com
WebRun opens Bill.com to pull approved bills due within 7 days. - Open Bill.com and filter to approved, unpaid bills with due dates in the next 7 days
- For each bill, capture the vendor name, invoice amount, due date, and payment method on file
- Calculate the total payment amount by date and the overall week total
Done when All approved bills due this week are listed with amounts and due dates.
-
2
Microsoft Excel - export and organize the payment schedule
microsoft.com
WebRun opens Microsoft Excel to export and organize the payment schedule. - Open the weekly payment run workbook and populate this week's tab with the bill list
- Add subtotals by due date and a grand total for the week
- Flag any vendor missing a payment method in Bill.com
Done when The weekly payment run report is complete in Excel with all bills, subtotals, and flags.
-
3
Slack - post a payment run summary to the finance channel
slack.com
WebRun opens Slack to post a payment run summary to the finance channel. - Post a summary to the finance Slack channel: total bills, total dollar amount, due dates, and any flagged vendors
- Include a note that payment execution happens in Bill.com and requires human approval
Done when The finance team has this week's payment run 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 WebRun initiate or schedule any payments in Bill.com?
No. WebRun only reads approved bills and reports on what is due. All payment scheduling and execution is done by your AP team in Bill.com.
Does the report include unapproved bills?
No. Only approved bills are included. Unapproved bills appear separately in the approval bottleneck digest so they do not clutter the payment run view.
What if a vendor is missing a payment method?
Bills for vendors with no payment method on file in Bill.com are flagged in the Excel report and the Slack summary so your team can add the method before the run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.