Australian Wine to China: Landed Cost and Pricing Model

Description
Importing Australian bottled wine into mainland China is a trade lane where the tax mechanics, not the freight bill, decide whether a shipment makes money. This Excel model turns that calculation into something you can run in under an hour, in English and Chinese.

The model follows the five-step sequence Chinese customs actually applies: dutiable value, customs duty, composite assessable price, consumption tax, and import VAT. Step three is where most spreadsheets fail. China's consumption tax on wine is price-inclusive, so its base is grossed up by dividing by one minus the rate rather than multiplying the duty-paid value. A comparison table places the correct treatment beside the common shortcut and quantifies the gap, so you can see exactly what a simplified model would have cost you.

A dedicated worksheet prices the ChAFTA Certificate of Origin for your own consignment. Because duty feeds the consumption tax and VAT bases, the gap between the zero preferential rate and the fourteen percent most-favoured-nation rate cascades well past fourteen percent of goods value. The model nets the certificate fee against the tax saved and expresses the result as a return multiple.
Australian-side costs are modelled line by line rather than buried in a freight figure. Wine Equalisation Tax and GST appear as reference rates and are correctly excluded on export, with a reminder that the exemption is conditional and that wineries routinely quote domestic WET-inclusive prices unless asked otherwise. Export charge, consignment fees, label registration and certificate costs each sit on their own editable row.

All inputs live on one colour-coded worksheet; everything downstream is formula-driven. Two toggles change the commercial picture materially: whether a valid certificate is held, and whether import VAT is recoverable or a sunk cost in private-channel resale. A closing reference sheet carries the rates, the Australian fee schedule, a pre-shipment compliance checklist covering GACC registration and Chinese back-label filing, and the source and verification date for every figure.