Excel workbookOfficial Zeyto

UAE SME Chart of Accounts with VAT 201 Mapping

An Excel workbook for UAE small businesses setting up or tidying the accounts in their bookkeeping system.

Start with a chart of accounts that maps to VAT 201.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box7 files, 146 KB
  • Works withMicrosoft Excel 2016 or later
  • 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

  • 125 core accounts with tax code and VAT 201 box
  • Add-on accounts for trading, services, restaurant, contracting
  • Five CSV files ready to import
  • Reports map and opening balance checker
  • Example journal and trial balance with VAT cross-check
Files and sizes (7)
  • uae-sme-chart-of-accounts-workbook.xlsx54 KB
  • chart-core.csv17 KB
  • chart-trading.csv18 KB
  • chart-services.csv18 KB
  • chart-restaurant.csv18 KB
  • chart-contracting.csv18 KB
  • README.txt2.2 KB

7 files, 146 KB in total. You download them from your order page after payment.

What it does not do

  • Map by name when you import, decide the accounts marked Check, and have your accountant approve the chart.
  • The licence is for your own business: no reselling or sharing the files.

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 support@zeyto.app 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

A chart of accounts built for UAE reporting.

Read the full description

A chart of accounts built for UAE reporting. Each account has a code, a type, a statement line, a normal balance, a default tax code (SR5, ZR, EX, OOS, RCM or Check), the VAT 201 box its transactions usually land in, the reports it feeds and a note on what to watch. The design aims to let your VAT workings and standard reports fall out of the account structure.

What is inside

  • Core chart: 125 accounts, with Arabic names (drafted, they need a native read before you print them).
  • Variants: 16 trading, 12 services, 19 restaurant and 18 contracting accounts that do not clash with the core codes.
  • Tax Codes and VAT 201: what each code means, where it lands on the return, the Box 12, 13 and 14 logic.
  • Reports Map, Opening Balances (it tells you when debits and credits do not agree), Example Journal and Example Trial Balance with a VAT cross-check.
  • Five CSV files (core and one full chart per industry) for importing into an accounting system.

What it is not A chart is a design. It does not make your bookkeeping right and it does not file anything. Codes are this workbook's own scheme, so map by name when you import. Treatment of rent, insurance, bank fees, travel and entertainment depends on the facts, so those accounts are marked Check. It is a starting point your accountant, lawyer or PRO should review. It does not say that any document satisfies a law, and it does not file, register or pay anything.

How we checked it We opened every workbook in desktop Excel on Windows, recalculated all formulas, and checked the worked examples against hand calculations. We measured Word page counts in desktop Word. We did not test Google Sheets, LibreOffice, Excel for Mac or Excel on the web.

Questions

Who is it for?
UAE small businesses setting up or tidying the accounts in their bookkeeping system.
What do I need to use it?
Microsoft Excel 2016 or later (formulas also work in current Google Sheets and LibreOffice, untested here).
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 SME Chart of Accounts with VAT 201 Mapping: AED 109

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.