Interactive cost worksheet
Landed cost variance worksheet: compare baseline and current import costs
Compare baseline and current import costs in a private, local-only worksheet, then keep each amount's evidence state and uncertainty visible. The method supports review without presenting one universal accounting, tax, or customs formula.
By Ayhan Karaca, Co-Founder · Updated: September 8, 2026
Private in this tab · no upload
Compare baseline and current landed-cost evidence
Enter one reference amount and one current amount for every cost layer in the same reporting currency. Then classify the current amount and confirm whether source evidence is available. The worksheet exposes variance and uncertainty; it does not choose rates or accounting treatment.
Define the decision and boundary before calculating
Start by naming the decision: shipment approval, purchase comparison, margin review, accrual, or final accounting. Then record the included and excluded cost layers, the shipment or line-item allocation basis, reporting currency, exchange-rate source and date, and whether the result accepts estimates.
A working control total can be expressed as accepted purchase cost plus included transport and insurance, duty and tax evidence, brokerage and terminal charges, and approved domestic or other costs. That expression organizes evidence; it does not decide which amounts receive a particular customs, tax, or accounting treatment.
Build the worksheet by evidence layer
Keep quoted, estimated, accrued, disputed, and final amounts as different states. Preserve the original currency and value, then store the conversion rule separately so a reviewer can reproduce the reporting amount.
| Cost layer | Preferred evidence | Calculation control | Decision owner |
|---|---|---|---|
| Purchase and commercial value | Accepted commercial invoice and purchase record | Retain line, quantity, currency, adjustments, and allocation basis | Purchasing and finance |
| International freight and insurance | Carrier or forwarder contract, quote, and invoice | Separate estimate from final charge and prevent duplicate invoice capture | Logistics and finance |
| Duty, tax, and customs amounts | Entry, broker, and official customs evidence | Store reported amount and basis; do not guess classification or applicable rate | Qualified customs and finance owners |
| Brokerage, port, terminal, and accessorial charges | Provider invoice or explicitly identified estimate | Map each charge once and preserve dispute or approval state | Logistics and finance |
| Domestic and other included costs | Approved invoice, contract, or internal policy record | State inclusion rule and shipment or line-item allocation method | Finance and policy owner |
Test predictable failure modes
A total should not move to an approved state merely because every cell contains a number. Run explicit checks for duplicates, source status, currency consistency, scope, and allocation before using it in a comparison or financial decision.
| Failure example | Why it distorts the result | Detection control | Required resolution |
|---|---|---|---|
| Freight appears in both invoice value and a separate provider charge | The same economic cost may be counted twice | Compare inclusion scope and evidence identifiers | Owner accepts one treatment and records the rationale |
| Currencies are converted with different dates or unnamed rates | Rows cannot be compared or reproduced | Require currency, rate source, rate date, and reporting value | Finance applies the approved conversion policy |
| An estimate silently becomes a final amount | Decision confidence is overstated | Block state change without final evidence or explicit approval | Charge owner resolves or approves the variance |
| A shipment charge is allocated without a stated basis | SKU or order profitability can be misleading | Require quantity, value, weight, volume, or policy-based allocation | Finance chooses and documents the applicable basis |
Use a six-question decision framework
Before approval, ask: What decision is this total for? What is inside and outside its scope? Which rows are estimates or disputed? Which evidence and exchange-rate rule produced each value? How were shared charges allocated? Who can accept the remaining exception?
Compare shipments, suppliers, or scenarios only after normalizing purpose, cost boundary, currency policy, allocation method, and evidence state. Keep the answer and unresolved exceptions together rather than exporting a context-free total.
Turn the worksheet into an owned shipment review.
Use the methodology here to define the control total, then see how Tyllus keeps source-backed, estimated, and unresolved shipment costs separate.