# UK Postponed Import VAT Reconciliation Worksheet

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

## Short answer

Editable list of import entries with customs value, duty and other charges that calculates import VAT and totals for boxes 1 and 4 of the VAT return.

## Category

regional

## Region

United Kingdom

## Audience

- VAT accountant
- Customs coordinator
- Finance controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** GBP 

**Columns:**

#### Entry or MRN

**Key:** entry

**Type:** text

#### Acceptance date

**Key:** date

**Type:** date

#### Supplier

**Key:** supplier

**Type:** text

#### VAT rate %

**Key:** rate

**Type:** select

**Options:**

- 20
- 5
- 0

#### Customs value

**Key:** value

**Type:** number

**Format:** currency

#### Duty

**Key:** duty

**Type:** number

**Format:** currency

#### Other dutiable charges

**Key:** other

**Type:** number

**Format:** currency

#### VAT base

**Key:** base

**Type:** number

**Expr:** value + duty + other

**Format:** currency

#### Import VAT

**Key:** vat

**Type:** number

**Expr:** base * 20 / 100

**Format:** currency

#### VAT per HMRC statement

**Key:** stmt

**Type:** number

**Format:** currency

#### Difference

**Key:** diff

**Type:** number

**Expr:** vat - stmt

**Format:** currency

**Rows:**

**Entry:** 26GB1234567890ABC1

**Date:** 2026-09-03

**Supplier:** Shenzhen Connector Ltd

**Rate:** 20

**Value:** 18400

**Duty:** 0

**Other:** 620

**Stmt:** 3804

**Entry:** 26GB1234567890ABC2

**Date:** 2026-09-10

**Supplier:** Nagoya Bearings KK

**Rate:** 20

**Value:** 42650

**Duty:** 1706

**Other:** 1100

**Stmt:** 9091.2

**Entry:** 26GB1234567890ABC3

**Date:** 2026-09-17

**Supplier:** Chennai Forgings Pvt

**Rate:** 20

**Value:** 27900

**Duty:** 1395

**Other:** 840

**Stmt:** 6027

**Entry:** 26GB1234567890ABC4

**Date:** 2026-09-24

**Supplier:** Gdansk Castings Sp

**Rate:** 20

**Value:** 9800

**Duty:** 0

**Other:** 300

**Stmt:** 2000

**Entry:** 26GB1234567890ABC5

**Date:** 2026-09-29

**Supplier:** Istanbul Fasteners AS

**Rate:** 20

**Value:** 12500

**Duty:** 0

**Other:** 410

**Stmt:** 2582

**Totals:**

#### Total import VAT per calculation

**Key:** vat

**Agg:** sum

**Format:** currency

#### Total per HMRC statement

**Key:** stmt

**Agg:** sum

**Format:** currency

#### Total difference

**Key:** diff

**Agg:** sum

**Format:** currency

**Summary:**

#### Box 1 postponed VAT due (this month)

**Key:** box1

**Expr:** sum_vat

**Format:** currency

**Primary:** true

#### Box 4 reclaim (if fully recoverable)

**Key:** box4

**Expr:** sum_vat

**Format:** currency

#### Average VAT per entry

**Key:** avg_entry

**Expr:** sum_vat / count

**Format:** currency

**Notes:** The VAT column uses 20% for every row as a simple default. For reduced or zero rated goods, edit the formula in your exported file or adjust the VAT per HMRC statement column and review the difference. Enter statement amounts from the monthly postponed import VAT statement. Not tax advice; confirm treatment with your adviser.

## Content

**Intro:** With postponed VAT accounting, UK import VAT is declared on the VAT return instead of being paid at the border. This worksheet lets you rebuild the figure per entry and compare it with the monthly statement before you file.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per import entry for the month. Enter customs value, duty and other charges that are part of the VAT base, and the amount shown on the HMRC postponed import VAT statement. The sheet calculates the VAT base, the import VAT at 20% and the difference. Export to Excel and keep it with the return working papers. Any non-zero difference needs an explanation before filing.

#### The method behind it

**Body:** Import VAT is generally charged on the customs value plus duty and other charges incurred up to the first place of destination in the UK, such as freight and insurance not already in the value. With postponed accounting you account for that VAT in box 1 of the VAT return and reclaim it, subject to normal rules, in box 4. For a fully taxable business these roughly offset, so cash flow improves and the border payment disappears.

#### Common mistakes

**Body:** Typical issues are entries missing from your records because the freight forwarder used its own account, wrong values after a late freight invoice, and reduced or zero rated goods treated at 20%. Another is reclaiming import VAT without holding the right evidence. Chase forwarders for entry data each month and reconcile the statement before the quarter end rather than at filing time.

**Bullets:**

- Match every statement line to an entry in your ERP
- Check the VAT base includes duty and other charges
- Identify entries that used a forwarder's account
- Agree who owns the monthly reconciliation

**Cta:** If your ERP holds import costs and entry numbers, we can help build a reconciliation report that does this automatically. The worksheet is free and complete without it.

**Faq:**

#### Where do I find the postponed import VAT statement?

**Answer:** Businesses using postponed VAT accounting can download a monthly statement from their HMRC online account. It lists entries and the VAT postponed, which you use for the return.

#### Does the sheet handle reduced or zero rated goods?

**Answer:** The default formula uses 20%. For other rates, edit the VAT formula in the exported Excel file, or enter the statement value and use the difference column to see what needs adjusting.

#### What goes into the VAT base?

**Answer:** Generally the customs value, any duty, and other charges up to the first UK destination such as freight and insurance not already included. Check current HMRC guidance for your specific import type.

#### Is import VAT always recoverable?

**Answer:** Not always. Recovery follows your normal input tax rules, including partial exemption and business use, and you must hold valid evidence. The box 4 line in the summary assumes full recovery.

## Search terms

postponed VAT accounting worksheet, UK import VAT reconciliation excel, PVA monthly statement reconciliation, postponed import VAT box 1 box 4, import VAT calculation UK, HMRC postponed VAT statement check

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