# GCC Import Landed Cost and VAT Worksheet

> Source: https://netray.co/tools/gcc-import-landed-cost-and-vat-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Per shipment line worksheet that builds CIF, duty, import VAT and landed cost for imports into UAE, Saudi Arabia, Oman, Bahrain and other Gulf markets.

## Category

supply-chain

## Region

Gulf (GCC)

## Audience

- Procurement manager
- Import coordinator
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** AED 

**Columns:**

#### Item or shipment

**Key:** item

**Type:** text

#### Destination

**Key:** country

**Type:** select

**Options:**

- UAE
- Saudi Arabia
- Oman
- Bahrain
- Kuwait
- Qatar

#### FOB value

**Key:** fob

**Type:** number

**Format:** currency

#### Freight

**Key:** freight

**Type:** number

**Format:** currency

#### Insurance

**Key:** insurance

**Type:** number

**Format:** currency

#### CIF value

**Key:** cif

**Type:** number

**Expr:** fob + freight + insurance

**Format:** currency

#### Duty rate %

**Key:** duty_rate

**Type:** number

#### Customs duty

**Key:** duty

**Type:** number

**Expr:** cif * duty_rate / 100

**Format:** currency

#### VAT rate %

**Key:** vat_rate

**Type:** number

#### Import VAT

**Key:** vat

**Type:** number

**Expr:** (cif + duty) * vat_rate / 100

**Format:** currency

#### Clearing and local charges

**Key:** clearing

**Type:** number

**Format:** currency

#### Landed cost excl. recoverable VAT

**Key:** landed

**Type:** number

**Expr:** cif + duty + clearing

**Format:** currency

**Rows:**

**Item:** CNC spindle motors

**Country:** UAE

**Fob:** 52000

**Freight:** 3800

**Insurance:** 260

**Duty rate:** 5

**Vat rate:** 5

**Clearing:** 1450

**Item:** Hydraulic power packs

**Country:** Saudi Arabia

**Fob:** 84000

**Freight:** 6200

**Insurance:** 420

**Duty rate:** 5

**Vat rate:** 15

**Clearing:** 2900

**Item:** Stainless sheet 3mm

**Country:** Oman

**Fob:** 38500

**Freight:** 4100

**Insurance:** 190

**Duty rate:** 5

**Vat rate:** 5

**Clearing:** 1100

**Item:** PLC control panels

**Country:** Bahrain

**Fob:** 29400

**Freight:** 2100

**Insurance:** 150

**Duty rate:** 5

**Vat rate:** 10

**Clearing:** 900

**Item:** Bearings and seals

**Country:** UAE

**Fob:** 11200

**Freight:** 950

**Insurance:** 60

**Duty rate:** 5

**Vat rate:** 5

**Clearing:** 480

**Totals:**

#### Total CIF

**Key:** cif

**Agg:** sum

**Format:** currency

#### Total customs duty

**Key:** duty

**Agg:** sum

**Format:** currency

#### Total import VAT

**Key:** vat

**Agg:** sum

**Format:** currency

#### Total landed cost

**Key:** landed

**Agg:** sum

**Format:** currency

**Summary:**

#### Duty as share of CIF

**Key:** duty_pct

**Expr:** sum_duty / sum_cif * 100

**Format:** percent

**Primary:** true

#### Landed cost multiple of CIF

**Key:** landed_factor

**Expr:** sum_landed / sum_cif

**Format:** decimal

#### Cash due at border (duty plus VAT)

**Key:** cash_at_border

**Expr:** sum_duty + sum_vat

**Format:** currency

**Notes:** Enter all amounts in one currency, converted at the rate customs uses. The GCC common external tariff is often 5% but varies by product, with exemptions, higher rates and free zone treatment. Rates shown are examples; confirm duty and VAT per HS code and country with your customs broker. Landed cost excludes VAT on the assumption it is recoverable.

## Content

**Intro:** Quoted prices for imported machinery and materials rarely include everything due at the border. This worksheet builds up CIF, customs duty, import VAT and local charges per line so buyers can compare true landed cost.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per shipment line or item group. Enter FOB value, freight and insurance, then the duty rate and VAT rate for the destination and tariff code. The sheet calculates CIF, customs duty on CIF, VAT on CIF plus duty, and a landed cost that leaves out recoverable VAT. Export to Excel for approval, or paste into a costing file. Change currency symbol by converting values first.

#### The method behind it

**Body:** Gulf customs duty is generally assessed on the CIF value. Import VAT is then charged on CIF plus duty, plus other applicable taxes. Standard VAT rates differ across the region: 5% in the UAE and Oman, 15% in Saudi Arabia and 10% in Bahrain, while Qatar and Kuwait did not have VAT at the time of writing. Check current rules before use, since rates and reliefs change. Free zones and designated zones can alter when VAT is due.

#### Common mistakes

**Body:** Typical mistakes are applying duty to FOB instead of CIF, forgetting freight when the supplier quotes ex-works, using a default rate where the HS code has a different one, and treating recoverable VAT as cost. Another is ignoring demurrage and storage when clearance is slow. Capture actual clearing charges after each shipment and compare them to the plan.

**Bullets:**

- Use the correct HS code for each line
- Confirm any duty exemption certificate is on file
- Separate recoverable VAT from cost in your ERP
- Reconcile estimates against the actual customs declaration

**Cta:** If you want planned landed cost compared with actual cost in your ERP automatically, we can help design that. The worksheet works on its own.

**Faq:**

#### Is customs duty charged on CIF or FOB?

**Answer:** In the GCC the customs value for duty is typically the CIF value, so freight and insurance are included. Confirm with the customs authority of the destination country for special cases.

#### Is the 5% duty rate fixed?

**Answer:** No. The common external tariff is often 5%, but some goods have higher rates, exemptions or reliefs, and national rules differ. Look up the HS code with your broker.

#### Why is VAT excluded from landed cost?

**Answer:** For VAT registered businesses making taxable supplies, import VAT is usually recoverable, so it is not a cost. If your business cannot recover it, add it to the cost manually.

#### Can I use it for free zone imports?

**Answer:** Partly. Goods entering a free zone often have duty and VAT suspended until they move into the mainland, so set rates to zero for the stage in the free zone and apply them at release.

## Search terms

GCC import landed cost calculator, UAE import duty and VAT worksheet, Saudi import duty calculator, CIF duty VAT calculation excel, landed cost template Gulf, customs duty 5 percent GCC, import cost sheet UAE

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json