VAT Return Workpaper

Preparing the VAT return from an accounting export usually means a pivot table rebuilt every quarter, a reverse charge line forgotten in Box 3, credit notes entered with the wrong sign, and a final figure that differs from the ledger by an amount nobody can explain. This app does the sorting and the arithmetic once, shows the formula for every box and keeps a printed page for the return file.

What is inside

• Sales and purchase grids: type each invoice once or import a CSV from your accounting system. Credit notes are entered as positive amounts and the app applies the sign.
• Category lists that say which box each category feeds: Box 1a to 1g by emirate, Box 3 reverse charge, Box 4 zero-rated, Box 5 exempt, Box 6 imports, Boxes 9 and 10 for input VAT, with a recoverable percentage you set per category.
• Reverse charge VAT is always calculated, so it cannot be mistyped. VAT you type on other lines is kept, and a line where it differs from rate times net is flagged.
• An Adjustments tab for figures you work out elsewhere, such as the Box 7 adjustment.
• The return workpaper: Boxes 1 to 14 with the formula beside each, printable on one A4 page.
• A Reconcile tab: type the totals from your ledger and see every difference against your own tolerance.
• A Checks tab: duplicate document numbers, missing dates, lines dated outside the period, VAT differing from rate times net, invalid numbers.
• Export of the boxes and the lines as CSV, JSON backup and restore, and a README with a worked example in numbers.

What is fact and what is a setting The standard rate of 5% and the VAT 201 box structure follow the FTA VAT Returns User Guide, as recorded in the Zeyto Academy fact check; the README says to verify them with the FTA. The rate, the categories, the recoverable percentages and the tolerance are settings you control. Tax groups, profit margin scheme, designated zones, bad debt relief, capital asset adjustments and Box 2 are not decided by the app.

What it is NOT It is a workpaper, not a filing tool. It does not connect to the FTA, submit a return or decide how a transaction should be treated. It is not tax or legal advice and is not endorsed by the Federal Tax Authority. E-invoicing is not covered.

How it differs from the VAT 201 Workings Workbook That product is an Excel workbook with the same purpose. This one is a single offline file that needs no Excel, runs on a phone, and handles credit note signs and reverse charge automatically. If you already work comfortably in Excel, the workbook is an equal alternative. Buying both adds little.

How it was checked Every box total was compared with an independent Python Decimal calculation over 30 random sets of lines, with no difference at all. Typed screens, CSV import, exports, reload, print view and phone width were tested in Chromium. Not tested in Safari, Firefox or Edge. Single business use.