Reconcile provider invoices against your billing ledger
Once provider invoices post each month, WebRun opens Gmail, reads every water, electric, and gas invoice for the period, matches each one against the expected charge on the property's Conservice ledger, logs every match and mismatch to Google Sheets, and posts the flagged list to Slack for your accounting team to resolve.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile provider utility invoices against my billing ledger?
Once provider invoices post each month, WebRun reads every water, electric, and gas invoice in Gmail and matches it against the expected charge on the property's Conservice ledger. Every match, duplicate, or mismatch is logged to Google Sheets, and anything missing or off by more than a set dollar amount is posted to Slack for accounting to resolve.
- Missing and duplicate provider invoices surface the same month, not at audit time
- Ledger mismatches are grouped and ready to resolve, not buried in a spreadsheet
- Accounting reconciles by exception instead of checking every invoice line by line
Built for property accountants · utility billing teams · accounts payable for multifamily · RUBS administrators
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
mail.google.comin a real browser with your saved login - no setup, no API keys. -
1
Gmail - read incoming provider invoices
gmail.com How to Automate Gmail
WebRun opens Gmail to read incoming provider invoices. - Open Gmail and pull every provider invoice email received for the period
- Extract the provider, account number, billing period, and total from each
- Note any invoice that looks like a duplicate of one already received
Done when Every provider invoice received this period is captured with its account and total.
-
2
Conservice - match each invoice to the ledger
conservice.com How to Automate Conservice
WebRun opens Conservice to match each invoice to the ledger. - Open Conservice and pull the expected charge for each provider account on the ledger
- Match each Gmail invoice to its ledger line by account number and period
- Flag any invoice with no ledger match, any ledger line with no invoice, and any total off by more than a set dollar amount
Done when Every invoice is matched to a ledger line, or flagged as missing, duplicate, or mismatched.
-
3
Google Sheets - log every match and mismatch
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log every match and mismatch. - Log every invoice checked this period with its match status: matched, missing, duplicate, or mismatched
- Record the dollar difference for any mismatch
- Keep a running column so a recurring mismatch with the same provider stands out
Done when Every invoice's match status and any dollar difference is logged for the period.
-
4
Slack - report mismatches to accounting
slack.com How to Automate Slack
WebRun opens Slack to report mismatches to accounting. - Post the month's mismatch summary to the accounting channel
- Group it into missing invoices, duplicates, and dollar mismatches
- Include the account number and provider for each so it's easy to trace
Done when Accounting has the month's full mismatch list in Slack, grouped by issue type.
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 correct the ledger or mark an invoice as paid?
No. WebRun only matches invoices to the ledger and flags mismatches. Correcting the ledger or approving payment stays with your accounting team.
What counts as a mismatch?
An invoice with no matching ledger line, a ledger line with no invoice on file, a likely duplicate invoice, or a total that's off from the ledger by more than a set dollar amount.
Does it catch a provider invoice that never arrived?
Yes. Any ledger line with no matching invoice email for the period is flagged as missing, so a lost or delayed invoice doesn't go unnoticed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.