# UK VAT Return Calculator with Postponed Import VAT

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

## Short answer

Calculate UK VAT return Boxes 1, 4, 5, 6 and 7 from sales and purchases, including postponed import VAT accounting.

## Category

regional

## Region

United Kingdom

## Audience

- Finance controller
- Accountant
- Import manager

## Tool

**Kind:** calculator

**Currency:** GBP 

**Inputs:**

#### Sales at standard rate (excl. VAT)

**Key:** sales_std

**Type:** number

**Default:** 480000

**Min:** 0

**Step:** 1000

**Unit:** GBP

#### Sales at reduced rate (excl. VAT)

**Key:** sales_red

**Type:** number

**Default:** 0

**Min:** 0

**Step:** 1000

**Unit:** GBP

#### Zero-rated sales incl. exports

**Key:** sales_zero

**Type:** number

**Default:** 120000

**Min:** 0

**Step:** 1000

**Unit:** GBP

#### Purchases at standard rate (excl. VAT)

**Key:** purch_std

**Type:** number

**Default:** 260000

**Min:** 0

**Step:** 1000

**Unit:** GBP

#### Purchases at reduced rate (excl. VAT)

**Key:** purch_red

**Type:** number

**Default:** 4000

**Min:** 0

**Step:** 500

**Unit:** GBP

#### Imports under postponed VAT accounting

**Key:** pva_imports

**Type:** number

**Default:** 90000

**Min:** 0

**Step:** 1000

**Unit:** GBP

**Help:** Customs value plus duty and other import costs on which import VAT is postponed.

#### Standard rate

**Key:** std_rate

**Type:** number

**Default:** 20

**Min:** 0

**Max:** 100

**Step:** 0.5

**Unit:** %

#### Reduced rate

**Key:** red_rate

**Type:** number

**Default:** 5

**Min:** 0

**Max:** 100

**Step:** 0.5

**Unit:** %

**Outputs:**

#### Box 1: VAT due on sales and other outputs

**Key:** box1

**Expr:** sales_std * std_rate / 100 + sales_red * red_rate / 100 + pva_imports * std_rate / 100

**Format:** currency

**Description:** Includes postponed import VAT accounted on the return.

#### Box 4: VAT reclaimed on purchases and imports

**Key:** box4

**Expr:** purch_std * std_rate / 100 + purch_red * red_rate / 100 + pva_imports * std_rate / 100

**Format:** currency

**Description:** Includes the matching postponed import VAT, if the goods are for taxable use.

#### Box 5: Net VAT to pay (refund if negative)

**Key:** box5

**Expr:** box1 - box4

**Format:** currency

**Primary:** true

#### Box 6: Total value of sales excl. VAT

**Key:** box6

**Expr:** sales_std + sales_red + sales_zero

**Format:** currency

#### Box 7: Total value of purchases excl. VAT

**Key:** box7

**Expr:** purch_std + purch_red + pva_imports

**Format:** currency

#### Net cash effect of postponed import VAT

**Key:** pva_effect

**Expr:** pva_imports * std_rate / 100 - pva_imports * std_rate / 100

**Format:** currency

**Description:** Zero when the goods are fully used for taxable supplies, which is the point of postponed accounting.

**Chart:**

#### Box 5 net VAT vs standard-rate sales

**Type:** line

**X:** sales_std

**From:** 0

**To:** 1000000

**Steps:** 20

**Series:**

- box5

**Disclaimer:** Estimate for planning. Box 2, 3, 8 and 9 relate to acquisitions from the EU and Northern Ireland protocol goods, and are not modelled here. Partial exemption, flat rate and margin schemes and blocked input tax need separate treatment.

## Content

**Intro:** This calculator builds the main boxes of a UK VAT return from your sales and purchases and shows how postponed VAT accounting (PVA) for imports flows through Boxes 1 and 4. It suits UK manufacturers who import components and want to sanity-check a return before filing through Making Tax Digital software.

**Sections:**

#### How to use it

**Body:** Enter the net values for the VAT period: sales split by rate, purchases by rate and the value of imports where you account for import VAT on the return. Adjust the rates if you are modelling a historical period. The calculator returns Box 1 (VAT due), Box 4 (VAT reclaimed), Box 5 (net amount) and the net values for Boxes 6 and 7. A negative Box 5 means a repayment is due. Use the chart to see how the result moves as standard-rate sales change.

#### How postponed import VAT works

**Body:** With postponed VAT accounting, a VAT-registered importer does not pay import VAT at the border. Instead the VAT is declared in Box 1 and, where the goods are for taxable business use, reclaimed in Box 4 on the same return. The net effect on cash is nil, which improves cash flow compared with paying VAT up front and reclaiming it later. The monthly postponed import VAT statement from HMRC is the document to reconcile to your records.

**Bullets:**

- Box 1 includes postponed import VAT
- Box 4 includes the same amount if recoverable
- Box 7 includes the value of imported goods
- Reconcile to the HMRC monthly statement

#### Worked example

**Body:** With standard sales of 480,000, reduced sales of 0, zero-rated sales of 120,000, standard purchases of 260,000, reduced purchases of 4,000 and imports of 90,000 under PVA, Box 1 is 96,000 plus 18,000, so 114,000. Box 4 is 52,000, 200 and 18,000, so 70,200. Box 5 is 43,800 to pay. Box 6 is 600,000 and Box 7 is 354,000. The PVA amount has no net effect, which you can confirm in the last output.

#### Registration and common mistakes

**Body:** The compulsory UK registration threshold is set by HMRC and has been 90,000 pounds of taxable turnover since April 2024, so confirm the current figure. Mistakes to avoid include forgetting to include PVA in both boxes, treating exports as exempt rather than zero-rated, reclaiming VAT without a valid invoice, and using VAT-inclusive figures. Reconcile VAT control accounts to the return and keep supporting documents for the required period.

**Cta:** If you want the return boxes reconciled automatically from your ERP tax codes and import records, Netray can help prepare a read-only extract you can check against your filing software.

**Faq:**

#### What are the UK VAT rates?

**Answer:** The standard rate is 20 percent, the reduced rate is 5 percent for specific goods and services, and some supplies are zero-rated. Others are exempt. Check HMRC guidance for the correct treatment of your products.

#### What is postponed VAT accounting?

**Answer:** It lets a VAT-registered business account for import VAT on its VAT return rather than paying at the border. The VAT is shown as output tax in Box 1 and, where recoverable, as input tax in Box 4 on the same return.

#### Is a negative Box 5 possible?

**Answer:** Yes. If reclaimed VAT exceeds VAT due, for example after large capital purchases or if you mostly make zero-rated supplies, the difference is repaid by HMRC subject to normal checks.

#### Does this cover Northern Ireland?

**Answer:** Not fully. Northern Ireland has special arrangements for goods traded with the EU, which affect Boxes 2, 8 and 9. Those boxes are not modelled here, so check HMRC guidance for your situation.

## Search terms

uk vat calculator, uk vat return calculator, vat return box 5 calculator, postponed vat accounting calculator, uk vat 20 percent calculator, making tax digital vat boxes, uk vat excel, uk manufacturer vat

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