Freight Cost & Profit Spreadsheet for Excel, Split Shipment Tracker and Order Margin Dashboard

Freight Profit Analyzer: Compare completed-order revenue, matched product costs, shipping income and billed freight in one editable workbook. Split-shipment costs aggregate by Order ID. Open orders stay out of completed-order profitability until you mark them Complete.

WHAT YOU GET
- Start Here worksheet
- Dashboard worksheet
- Orders worksheet
- Shipments worksheet
- Checks worksheet
- Clearly marked input and formula cells
- Worked DEMO records and built-in exception checks

SCOPE
250 orders and 500 freight charges per file. Contribution excludes overhead, taxes, payment fees and other unentered costs; it is not net profit. Use one currency throughout. All freight invoices must be entered manually.

FORMAT & SOFTWARE
Digital download only. No physical item. You receive a ZIP containing the editable XLSX workbook, Quick Start text file and one-business internal-use license. Microsoft Excel desktop 2019 or later / Microsoft 365 is required. Excel software is not included. Other spreadsheet apps, including Google Sheets and Numbers, have not been verified.

HOW IT WORKS
1. Download your ZIP through Etsy in a web browser after payment is confirmed.
2. Extract the ZIP and save a working copy of the XLSX.
3. Read Start Here. Replace the clearly labeled DEMO records in blue input cells.
4. Keep gray formula cells intact and resolve check flags before using the dashboard.

No macros, live carrier feeds, accounting sync, inventory integrations or automatic imports are included. Data entry and business decisions remain yours.

LICENSE & SUPPORT
One purchasing business may use and modify the file internally, including across its employees. Resale, redistribution, public sharing, sublicensing and inclusion in other template products are prohibited. For file questions, contact the shop through Etsy Messages with a redacted example.

CREATION DISCLOSURE
Created with AI assistance for the OpsFlow Templates collection. The workbook’s calculations and worked examples were checked. Screenshots show included sample data. Microsoft and Excel are trademarks of their respective owner; this product is independent and not endorsed by Microsoft.