Excel workbookOfficial Zeyto

UAE VAT 201 Workings Workbook

An Excel workbook for UAE owners, bookkeepers and accountants who want a second check on a VAT return.

Check your VAT 201 figures before you file.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box2 files, 124 KB
  • Works withMicrosoft Excel 2016 or later, Google Sheets or LibreOffice Calc
  • UAE VATMade for UAE VAT

How it works

  1. BuyPay on Stripe’s secure page.
  2. DownloadYour order page opens at once with a secure link.
  3. Open and useOpen the workbook in Excel and start from the example.

What you get

  • Excel workbook with 8 sheets
  • Sales and purchase registers of 500 rows each
  • All 14 VAT 201 boxes, with Box 1 by emirate
  • Ledger reconciliation and pre-filing checks
  • Worked example with deliberate errors
  • Instructions sheet and README
Files and sizes (2)
  • uae-vat-201-workings-workbook.xlsx119 KB
  • README.txt5.5 KB

2 files, 124 KB in total. You download them from your order page after payment.

What it does not do

  • You file in EmaraTax.
  • Special cases are typed in as adjustments.
  • Check with your accountant or the FTA.
  • It does not file anything and it does not replace your accountant.

After you buy

  • Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
  • A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
  • Help is one email awayWrite to info@emeron.io with your order reference. The team answers every enquiry.
  • Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Find my purchasesContact the Zeyto teamMarketplace terms

Full refund wording

Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.

About this product

This workbook helps you prepare the figures for the VAT 201 return from your own sales and purchase lists. You enter each invoice and credit note once.

Read the full description

This workbook helps you prepare the figures for the VAT 201 return from your own sales and purchase lists. You enter each invoice and credit note once. The workbook sorts them into the 14 boxes of the return, shows the amount, VAT and adjustment for each box, compares the result with your ledger and runs a set of checks so that you find problems before you file.

What is inside:

  • Setup sheet for your business name, TRN, period dates, rate and tolerance
  • Sales and Purchases registers of 500 rows each, with a row check that explains what is wrong in plain words
  • Purchase types for standard rated, reverse charge, customs import, zero rated, exempt and VAT not recoverable
  • A VAT 201 Workings sheet with the 14 boxes, including Box 1 by emirate
  • A Ledger Reconciliation sheet where you type your ledger figures and explain each difference
  • A Checks sheet that ends in ALL CHECKS PASSED or a list of what to clear
  • A Worked Example with a fictional quarter and two deliberate errors so you can see the checks work

Who it is for: owners, bookkeepers and accountants in the UAE who want a clear second check on a return, or who keep their books in a spreadsheet or in software without a good VAT 201 view.

If you use Zeyto, its VAT 201 report maps the tax codes SR5, ZR, EX, OOS and RCM to boxes in the same way. This workbook is independent of Zeyto and of any other software, and nothing is imported: you copy figures across.

What it is not: it does not file anything and it does not replace your accountant. It handles the common cases. Tax groups, the profit margin scheme, designated zone special cases, bad debt relief, annual input tax apportionment and capital assets calculations are worked out elsewhere and typed into the adjustment cells. Box 6 is pre-filled by the FTA from customs, so the workbook only helps you compare. The return can change: always compare with the current return in EmaraTax. Check with your accountant or the FTA for your case.

Requirements: Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.

Questions

Who is it for?
UAE owners, bookkeepers and accountants who want a second check on a VAT return.
What do I need to use it?
Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.
How do I get it?
Pay on Stripe, then download from your order page at once. Links last 48 hours: ask for a fresh one with your order reference and email.
What if the file is wrong?
If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you. Read the terms.

UAE VAT 201 Workings Workbook: AED 149

Pay once, download at once.

Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.

Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.

Not sure it is the right one?

Works well with

Other official products that cover the same ground or finish the job.