Flexport Automated Landed Cost Variance Report
Every Monday, WebRun opens Flexport and collects the actual landed cost components for shipments completed in the prior week, including freight, duties, fees, and surcharges. It compares these against your planned targets in Google Sheets, calculates the variance per shipment and per SKU, and posts a summary of the biggest outliers to your finance and compliance Slack channel.
How do I automatically compare actual Flexport landed costs against my planned targets?
WebRun pulls actual landed cost data from Flexport every Monday for shipments completed the prior week, compares freight, duty, port charges, and fees against your planned targets in Google Sheets, and calculates the variance per shipment and SKU. A Slack report highlights the biggest outliers so your finance and compliance teams can investigate before variances compound.
- Landed cost variances identified within days of shipment completion, not at quarter-end
- Top 5 outlier shipments surfaced to finance each Monday for immediate review
- Full history of actual vs. plan built automatically in Google Sheets for trend analysis
Built for finance teams · trade compliance managers · procurement directors · import controllers · supply chain finance 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
app.flexport.com/shipmentsin a real browser with your saved login - no setup, no API keys. -
1
Flexport - collect actual landed costs for completed shipments
flexport.com
WebRun opens Flexport to collect actual landed costs for completed shipments. - Open Flexport and navigate to shipments completed or invoiced in the prior week
- For each shipment, collect the actual landed cost breakdown: freight, duty, port charges, brokerage fees, and other surcharges
- Pull per-SKU landed cost data where available from Flexport's landed cost reporting
Done when Actual landed cost components are captured for all prior-week completed shipments.
-
2
Google Sheets - compare actuals against plan and calculate variances
google.com
WebRun opens Google Sheets to compare actuals against plan and calculate variances. - Match each completed shipment to the planned landed cost target from the procurement plan tab
- Calculate the absolute and percentage variance for each shipment and each SKU
- Flag any shipment or SKU where the variance exceeds your configured threshold
- Append the week's results to the landed cost history tab for trend tracking
Done when Variances are calculated and outliers are flagged in the Google Sheets report.
-
3
Slack - post the weekly landed cost variance report
slack.com
WebRun opens Slack to post the weekly landed cost variance report. - Post the weekly landed cost variance summary to the finance and compliance Slack channel
- Lead with the top 5 shipments by variance amount, showing actual vs. plan and the gap
- Link to the full Google Sheets report for the complete breakdown
Done when Finance and compliance have the weekly variance report 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
What cost components does it include in the landed cost comparison?
It captures freight, duty and tariff charges, port and terminal fees, brokerage fees, and any other surcharges recorded in Flexport's landed cost module, matching the components you track in your plan.
Can we set different variance thresholds for different product categories?
Yes. The Google Sheets plan tab supports per-category thresholds. WebRun reads the threshold for each SKU or product category and applies the correct tolerance when flagging outliers.
Does it update the plan automatically if costs change?
No. Plan targets are maintained by your finance or procurement team in Google Sheets. WebRun reads the targets each run and compares them to Flexport actuals, but it does not modify the plan without human input.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.