Free · Source-backed · No signup

Export Shipment Profit Reconciliation

Compare estimated revenue/cost lines with actual receipts and shipment costs to calculate actual profit, margin and post-shipment variance.

The quote is a hypothesis; actual profit is the outcome.Normalize all rows into one accounting/base currency before comparing estimated and actual economics.
Shipment reconciliation

Estimated vs actual economics.

Estimated profitINR 240,000
Actual profitINR 197,500
Profit varianceINR -42,500
Estimated margin26.7%
Actual margin22.3%
LineTypeEstimated (INR)Actual (INR)Variance
-15,000
5,000
1,000
18,000
3,500
Why this tool is different

Export costing predicts a margin; reconciliation measures what the shipment actually earned. The important learning loop is which cost/revenue assumptions were wrong and whether that should change the next quotation.

Requirements and recommendations

Bring estimate and actual onto one basis

  • List the revenue assumptions used in the quote.
  • List each estimated shipment cost and the actual booked/paid amount.
  • Include bank/FX, storage, demurrage, claims or other exceptions that materially affected profit.
How OpenFileTools processes it

Source-backed inputs, explicit assumptions.

The browser totals estimated and actual revenue/costs, compares profit and margin, and exports the reconciliation as a JSON snapshot for future quote improvement.

Frequently asked

Questions, answered.

How is this different from the export costing calculator?

Costing is pre-deal/pre-shipment planning. Reconciliation compares that plan with actual receipts and costs after execution.

Related guide

Learn more about this task.

Read the related guide