Automated Bill.com Duplicate Invoice Detection
Every morning, WebRun opens Bill.com, reviews bills entered in the past 48 hours, and checks each one against recently paid invoices for matching vendor, amount, and invoice number combinations. Suspected duplicates are logged in a Google Sheet and a review digest is drafted in Gmail for your AP lead.
How do I automatically detect duplicate invoices in Bill.com?
WebRun scans Bill.com every morning for bills entered in the past 48 hours, checking each against 90 days of paid invoices for matching vendor, amount, and invoice number. Flagged duplicates are logged in Google Sheets and a review digest is drafted in Gmail for your AP lead to approve before any action is taken.
- Duplicate invoices are caught before payment, not after
- Every suspected duplicate is logged with match evidence for fast human review
- AP leads get a drafted digest each morning rather than a manual hunt
Built for AP teams · controllers · finance managers · accounting firms
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 - scan new bills and paid history for duplicate signals
bill.com
WebRun opens Bill.com to scan new bills and paid history for duplicate signals. - Open Bill.com and pull all bills entered or updated in the past 48 hours
- For each bill, compare the vendor name, invoice number, and amount against paid bills from the last 90 days
- Flag any bill that matches on two or more of: same vendor, same amount, same invoice number, or same invoice date
Done when All recently entered bills have been checked and suspect duplicates identified.
-
2
Google Sheets - log flagged duplicates with match reasons
google.com
WebRun opens Google Sheets to log flagged duplicates with match reasons. - Open the duplicate-detection log sheet
- Append each flagged bill with the vendor, amount, original paid date, and the match reasons
- Mark each row as pending review
Done when All flagged duplicates are logged in the sheet with match details.
-
3
Gmail - draft a duplicate review digest for the AP lead
gmail.com
WebRun opens Gmail to draft a duplicate review digest for the AP lead. - Draft a short review email to the AP lead listing each flagged bill with a link to the Google Sheet
- Leave the email as a draft for the AP lead to review and send. Do not send automatically
Done when A draft review email is ready in Gmail for the AP lead to approve and send.
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 void or delete any invoices automatically?
No. WebRun only flags and logs suspicious bills. Every flagged invoice stays untouched in Bill.com until a human reviews and decides.
What counts as a duplicate?
Any bill matching on two or more of: same vendor, same invoice number, same amount, or same invoice date compared to paid bills from the last 90 days.
Will the review email go out on its own?
No. The Gmail digest is saved as a draft. Your AP lead reviews it and decides whether to send before anything leaves their inbox.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.