Automated Magaya Profit Per File Report
Every Monday, WebRun opens Magaya, finds all shipment files closed in the prior week, reads the revenue and cost breakdown for each, calculates the gross profit per file, and posts a ranked summary to Slack while logging the full detail to a Google Sheet for management review.
How do I get an automatic weekly profit-per-file report from Magaya?
WebRun opens Magaya every Monday, pulls every shipment file closed in the prior week, and reads the revenue and cost breakdown for each. It ranks the results by gross profit, logs the full detail in a Google Sheet, and posts a management summary to Slack with totals and outliers, giving your team a consistent weekly profitability view without any manual report pulling.
- Weekly profit-per-file report delivered without manual Magaya report-pulling
- Top and bottom performing files surfaced every Monday for management review
- Files with incomplete cost data flagged so margin figures are clearly labeled as estimates
Built for freight forwarding managers · logistics finance teams · NVOCC operators · international freight companies
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.magaya.comin a real browser with your saved login - no setup, no API keys. -
1
Magaya - pull closed shipment files with revenue and cost data
magaya.com
WebRun opens Magaya to pull closed shipment files with revenue and cost data. - Open Magaya and filter shipment files to those closed during the prior calendar week
- For each file, read the total invoiced revenue and the itemized cost breakdown including agent fees, carrier charges, and customs costs
- Calculate gross profit and gross margin percentage for each file
Done when Every closed file from the prior week has its revenue, cost, and profit figures captured.
-
2
Google Sheets - log profit per file ranked by margin
google.com
WebRun opens Google Sheets to log profit per file ranked by margin. - Open the profit-per-file Google Sheet
- Add a new section for the current week with one row per closed file
- Include file reference, client, trade lane, mode, revenue, costs, gross profit, and margin percentage, sorted by profit descending
Done when The Google Sheet has a complete profit-per-file log for the prior week.
-
3
Slack - post weekly profit summary to management channel
slack.com
WebRun opens Slack to post weekly profit summary to management channel. - Post a summary to the management Slack channel with total files closed, total gross profit, average margin, and top three and bottom three files by profit
- Include a link to the full Google Sheet for drill-down
Done when Management has the weekly profit summary in Slack with a link to the detail report.
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 calculate net profit after overhead, or gross profit only?
It calculates gross profit per file using the direct revenue and cost figures recorded in Magaya. Overhead allocation is not included unless your Magaya setup allocates it to individual files.
What if a file has unbilled costs at the time of the report?
Files with open cost lines are flagged in the Google Sheet as having incomplete cost data so your team knows the margin figure may change once all costs are finalized.
Can I filter the report by trade lane or mode?
Yes. The Google Sheet includes mode and trade lane columns. You can add your own filters or pivot table to slice the data by any dimension after WebRun populates it each week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.