Reconcile input invoices against delivery records automatically
Every Monday, WebRun reads vendor invoices from Gmail, pulls corresponding input delivery records from Conservis, matches quantities and prices, flags any discrepancy, and logs a reconciliation report in Google Sheets so you catch billing errors before writing a check.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile farm input invoices against delivery records?
Every Monday, WebRun reads vendor invoice emails from Gmail, pulls the matching input delivery records from Conservis, compares quantities and prices line by line, and logs a reconciliation report in Google Sheets with variances flagged. No invoice is approved or paid automatically.
- Billing errors caught before payment instead of after
- Every invoice line matched to a delivery record or flagged for review
- Full reconciliation history in Google Sheets for end-of-season audit
Built for farm financial managers · row-crop farm operators · ag input buyers · farm bookkeepers
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
gmail.comin a real browser with your saved login - no setup, no API keys. -
1
Gmail - read incoming vendor invoices
gmail.com How to Automate Gmail
WebRun opens Gmail to read incoming vendor invoices. - Open Gmail and search for unprocessed vendor invoice emails from input suppliers
- Extract vendor name, invoice number, line items, quantities, and totals from each invoice
- Mark each processed email with a label so it is not picked up again next run
Done when All new vendor invoices are read and their line-item details are captured.
-
2
Conservis - pull input delivery records for matching
conservis.ag
WebRun opens Conservis to pull input delivery records for matching. - Open Conservis and navigate to input inventory or delivery records
- For each invoice line item, find the matching delivery record: product, quantity received, date, and applied cost
- Note any invoice line where no matching delivery record is found in Conservis
Done when Each invoice line item is matched to a Conservis delivery record or flagged as unmatched.
-
3
Google Sheets - log reconciliation results and flag discrepancies
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log reconciliation results and flag discrepancies. - Open the invoice reconciliation sheet
- Append each matched line with vendor, invoice number, product, invoiced quantity, delivered quantity, and any price or quantity variance
- Flag rows with variances above the configured tolerance in red
- Log unmatched invoice lines in a separate tab for manual review
Done when The reconciliation report is complete with all matched lines, flagged variances, and unmatched items.
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 approve or pay any invoices automatically?
No. WebRun only reads invoices and delivery records and produces a reconciliation report. All payment decisions and approvals remain entirely with you.
How does it identify invoice emails from input suppliers?
It searches Gmail for emails matching supplier names or domains you configure in the setup. You can also use Gmail labels to pre-sort supplier emails into a folder WebRun monitors.
What tolerance does it use before flagging a variance?
The default is a two percent quantity or price variance. You can set a tighter or looser threshold in the Google Sheet configuration tab to match your purchasing agreements.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.