Reconcile Carrier Invoices vs Rates
Every Monday, WebRun opens your FedEx account, downloads the latest invoice, matches each charge against the rate card in your spreadsheet, calculates any overcharges, and posts a discrepancy report to Slack so you can dispute before the payment window closes.
How can I automatically reconcile carrier invoices against my quoted freight rates?
Every Monday, WebRun opens your FedEx account, downloads the latest invoice, matches each charge against the rate card in your Google Sheet, calculates any overcharges, and posts a discrepancy report to Slack so you can dispute charges before the payment window closes.
- Overcharges caught every week before payment is due
- Every invoice line matched against your negotiated rate card
- Dispute window protected by Monday morning Slack alerts
Built for logistics managers · supply chain teams · ecommerce operators · freight procurement 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
www.fedex.com/en-us/billing.htmlin a real browser with your saved login - no setup, no API keys. -
1
FedEx - download latest invoice
fedex.com
WebRun opens FedEx to download latest invoice. - Log in to FedEx Billing Online and open the most recent invoice
- Export or read the line-item charges: tracking number, service type, weight, zone, and billed amount
- Note the invoice date and total
Done when All invoice line items are captured with their billed amounts and service details.
-
2
Google Sheets - compare charges to rate card
google.com
WebRun opens Google Sheets to compare charges to rate card. - Open the Rate Card sheet with your negotiated rates per service type, weight bracket, and zone
- For each invoice line, look up the expected rate and calculate the variance
- Flag any line where the billed amount exceeds the quoted rate by more than your tolerance (e.g. 2%)
- Add a Reconciliation tab with the full comparison and a summary row showing total overcharge
Done when Every invoice line has been matched to a quoted rate and variances are highlighted.
-
3
Slack - report discrepancies to you
slack.com
WebRun opens Slack to report discrepancies to you. - Post a summary to #finance with the invoice total, expected total, and total discrepancy amount
- List the top 5 overcharged shipments with tracking numbers so you can open a dispute
Done when You have a clear dispute list before the payment window closes.
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
Does it pay or dispute invoices automatically?
No. It only reads and compares - it never initiates a payment or submits a dispute. You get the data, you take the action.
What if my rate card changes?
Just update the Google Sheet. WebRun reads it fresh every run, so next Monday it will use the new rates automatically.
Can it work with UPS or DHL invoices too?
Yes - the same logic works for any carrier you log in to. Add a second flow node for each additional carrier and it will reconcile all of them in one run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.