Understanding Tax Reporting Codes
For: Business Users, Finance Teams, Tax Preparers, UAE VAT Compliance Officers Purpose: Explain what tax reporting codes are and how they automate VAT return generation Reading Time: 10 minutes
What are Tax Reporting Codes?
Tax Reporting Codes are identifiers that tell the ERP system where to report tax amounts on your official tax returns (like the UAE VAT Return Form 201).
The Core Concept
Tax Codes tell the system HOW to calculate tax:
- SR-5% = "Calculate 5% tax"
- ZR-0% = "Calculate 0% tax"
- ES = "No tax, exempt"
Tax Reporting Codes tell the system WHERE to report those amounts:
- Code "10" = "Report in Box 1: Standard rated supplies"
- Code "11" = "Report in Box 2: Output tax"
- Code "170" = "Report in Box 8: Taxable purchases"
Real-World Analogy
Think of filing your tax return form:
Manual Process:
1. Review all invoices for the quarter
2. Calculate totals for different categories
3. Write amounts in specific boxes on the form:
- Box 1: Total sales at 5% VAT
- Box 2: VAT collected on those sales
- Box 8: Total purchases at 5% VAT
- Box 9: VAT paid on those purchases
ERP Automated Process:
1. Each transaction is tagged with tax reporting code
2. System automatically calculates totals per code
3. System generates VAT return with amounts in correct boxes
4. You review and submit to FTA
The tax reporting code is the "address" on the form where each amount belongs.
Why Do We Need Tax Reporting Codes?
1. Automated VAT Return Generation
Without Tax Reporting Codes:
Manual work required:
1. Export all transactions to Excel
2. Filter sales by tax code
3. Calculate subtotals for each box
4. Manually enter into FTA portal
5. Risk of human error in calculations
6. Takes hours or days for complex businesses
With Tax Reporting Codes:
Automated process:
1. Click "Generate VAT Return"
2. System automatically aggregates amounts
3. VAT return generated in minutes
4. Ready for review and electronic submission
Time saved: Hours → Minutes Error reduction: Significant → Minimal
2. UAE VAT Return Compliance
The UAE Federal Tax Authority (FTA) requires specific information in specific boxes on Form 201.
Example - Standard 5% Sale in Dubai:
Transaction:
- Invoice: AED 105,000
- VAT Amount: AED 5,000
- Net Amount: AED 100,000
Must appear in TWO places on VAT return:
| Box | Description | Amount | Reporting Code |
|---|---|---|---|
| Box 1 (Field 20) | Standard rated supplies - Dubai | AED 100,000 | "20" |
| Box 2 (Field 21) | Output VAT - Dubai | AED 5,000 | "21" |
The tax reporting code ensures the transaction goes to the correct boxes automatically.
3. Multi-Jurisdiction Tracking
UAE VAT reporting tracks sales by emirate (Abu Dhabi, Dubai, Sharjah, etc.) for statistical purposes.
Example:
| Transaction | Emirate | Tax Reporting Code | VAT Return Box |
|---|---|---|---|
| Sale in Abu Dhabi | AD | "10" (base), "11" (tax) | Box 1: Field 10, Box 2: Field 11 |
| Sale in Dubai | DB | "20" (base), "21" (tax) | Box 1: Field 20, Box 2: Field 21 |
| Sale in Sharjah | SH | "30" (base), "31" (tax) | Box 1: Field 30, Box 2: Field 31 |
Without reporting codes, you'd manually sort transactions by emirate. With reporting codes, the system does it automatically.
How Tax Reporting Codes Work in the UAE
The UAE VAT Return Form 201 Structure
The UAE VAT return has 16 main boxes, each with multiple fields:
Output VAT (What you collected):
- Box 1: Standard rated supplies (taxable revenue)
- Field 10: Abu Dhabi sales
- Field 20: Dubai sales
- Field 30: Sharjah sales
- (And more for other emirates)
- Box 2: Output tax (VAT collected)
- Field 11: Abu Dhabi VAT
- Field 21: Dubai VAT
- Field 31: Sharjah VAT
Input VAT (What you paid):
- Box 8: Standard rated expenses (taxable purchases)
- Field 170: Standard purchases
- Box 9: Recoverable input VAT
- Field 171: Input VAT you can reclaim
Other Boxes:
- Box 3/4: Reverse charge supplies
- Box 5: Zero-rated supplies
- Box 6: Exempt supplies
- Box 10/11: Reverse charge purchases
- Box 12-16: Net tax, adjustments, refunds
How Transactions Map to Reporting Codes
Example 1: Standard Sale in Dubai
Invoice Details:
- Customer: ABC Trading LLC, Dubai
- Net Amount: AED 50,000
- VAT Rate: 5% (AED 2,500)
- Total: AED 52,500
Tax Code: SRSD (Standard Rated Supplies - Dubai)
Tax Reporting Codes Assigned:
- Sales Base Amount Reporting Code: "20" → Box 1, Field 20
- Sales Tax Amount Reporting Code: "21" → Box 2, Field 21
On VAT Return:
Box 1, Field 20 (Dubai standard sales): AED 50,000
Box 2, Field 21 (Dubai output VAT): AED 2,500
Example 2: Standard Purchase (Input VAT)
Supplier Invoice:
- Supplier: XYZ Suppliers LLC
- Net Amount: AED 20,000
- VAT Rate: 5% (AED 1,000)
- Total: AED 21,000
Tax Code: SRE (Standard Rated Expenses)
Tax Reporting Codes Assigned:
- Purchase Base Amount Reporting Code: "170" → Box 8
- Purchase Tax Amount Reporting Code: "171" → Box 9
On VAT Return:
Box 8 (Standard rated expenses): AED 20,000
Box 9 (Recoverable input VAT): AED 1,000
Example 3: Zero-Rated Export
Export Invoice:
- Customer: International buyer (outside GCC)
- Net Amount: AED 100,000
- VAT Rate: 0%
- Total: AED 100,000
Tax Code: ZRS (Zero Rated Supplies)
Tax Reporting Codes Assigned:
- Sales Base Amount Reporting Code: "100" → Box 5
On VAT Return:
Box 5 (Zero-rated supplies): AED 100,000
(No entry in Box 2 - no VAT collected)
D365 F&O Approach to Tax Reporting Codes
The system follows Microsoft Dynamics 365 Finance & Operations patterns for tax reporting:
Key Design Principles
1. Direct FK Fields on Tax Code (Not Separate Mapping)
Each tax code has four reporting code fields:
Tax Code: SRSD (Standard Rated Supplies - Dubai)
├─ Sales Base Amount Reporting Code → "20"
├─ Sales Tax Amount Reporting Code → "21"
├─ Purchase Base Amount Reporting Code → "170"
└─ Purchase Tax Amount Reporting Code → "171"
Why four fields?
- Sales Base: Where to report sales revenue (Box 1)
- Sales Tax: Where to report VAT collected (Box 2)
- Purchase Base: Where to report purchase amounts (Box 8)
- Purchase Tax: Where to report input VAT (Box 9)
2. Context from Field Names (Not from Reporting Code Properties)
Wrong approach (Over-engineered):
Reporting Code "20"
├─ Report Section: Sales ❌
├─ Amount Type: Base Amount ❌
└─ Field: "20" ✓
Correct approach (D365 F&O pattern):
Reporting Code "20"
└─ Field: "20" ✓
Context comes from WHICH field on Tax Code is used:
- If using "SalesBaseAmountReportingCodeId" → It's a sales base amount
- If using "PurchaseBaseAmountReportingCodeId" → It's a purchase base amount
Why this matters:
- Simpler design
- Matches D365 F&O exactly
- One reporting code can be reused in different contexts
- No redundant data
3. Tax Report Layout for Multi-Country Support
Tax Report Layout represents the actual tax form structure:
Tax Report Layout: UAE_VAT_201
├─ Code: "UAE_VAT_201"
├─ Description: "UAE VAT Return Form 201"
├─ Country: "AE"
├─ Version: "v1.0"
└─ Tax Reporting Codes:
├─ "10", "11" (Abu Dhabi)
├─ "20", "21" (Dubai)
├─ "100" (Zero-rated)
├─ "170", "171" (Purchases)
└─ ... (70+ codes total)
Benefits:
- Support multiple countries (UAE, Saudi Arabia, Bahrain, etc.)
- Handle form versions (when FTA updates the form)
- Future-proof for new jurisdictions
Complete UAE Tax Reporting Codes Reference
Sales Codes (Box 1: Taxable Sales)
| Code | Description | VAT Return Field |
|---|---|---|
| 10 | Standard rated supplies - Abu Dhabi (base) | Box 1, Field 10 |
| 20 | Standard rated supplies - Dubai (base) | Box 1, Field 20 |
| 30 | Standard rated supplies - Sharjah (base) | Box 1, Field 30 |
| 40 | Standard rated supplies - Ajman (base) | Box 1, Field 40 |
| 50 | Standard rated supplies - Umm Al Quwain (base) | Box 1, Field 50 |
| 60 | Standard rated supplies - Ras Al Khaimah (base) | Box 1, Field 60 |
| 70 | Standard rated supplies - Fujairah (base) | Box 1, Field 70 |
| 80 | Tax refunds provided to tourists (base) | Box 1, Field 80 |
| 100 | Zero-rated supplies | Box 5 |
| 110 | Supplies to GCC registered customers | Box 1, Field 110 |
| 120 | Exempt supplies | Box 6 |
Output VAT Codes (Box 2: Tax Payable)
| Code | Description | VAT Return Field |
|---|---|---|
| 11 | Output VAT - Abu Dhabi | Box 2, Field 11 |
| 21 | Output VAT - Dubai | Box 2, Field 21 |
| 31 | Output VAT - Sharjah | Box 2, Field 31 |
| 41 | Output VAT - Ajman | Box 2, Field 41 |
| 51 | Output VAT - Umm Al Quwain | Box 2, Field 51 |
| 61 | Output VAT - Ras Al Khaimah | Box 2, Field 61 |
| 71 | Output VAT - Fujairah | Box 2, Field 71 |
| 81 | Output VAT - Tourist refunds | Box 2, Field 81 |
Adjustment Codes (Box 2: Adjustments)
| Code | Description | VAT Return Field |
|---|---|---|
| 15 | Adjustment - Abu Dhabi | Box 2, Field 15 |
| 25 | Adjustment - Dubai | Box 2, Field 25 |
| 35 | Adjustment - Sharjah | Box 2, Field 35 |
| 45 | Adjustment - Ajman | Box 2, Field 45 |
| 55 | Adjustment - Umm Al Quwain | Box 2, Field 55 |
| 65 | Adjustment - Ras Al Khaimah | Box 2, Field 65 |
| 75 | Adjustment - Fujairah | Box 2, Field 75 |
| 85 | Adjustment - Tourist refunds | Box 2, Field 85 |
Purchase Codes (Box 8: Taxable Purchases)
| Code | Description | VAT Return Field |
|---|---|---|
| 170 | Standard rated expenses (base) | Box 8 |
Input VAT Codes (Box 9: Recoverable VAT)
| Code | Description | VAT Return Field |
|---|---|---|
| 171 | Recoverable input VAT | Box 9 |
| 160 | Adjustment - Standard rated expenses | Box 9, Field 160 |
Reverse Charge Codes
| Code | Description | VAT Return Field |
|---|---|---|
| 90 | Supplies subject to reverse charge (base) | Box 3 |
| 91 | Reverse charge - Output VAT | Box 4 |
| 95 | Reverse charge - Adjustment | Box 4, Field 95 |
| 130 | Goods imported - Reverse charge (base) | Box 3, Field 130 |
| 131 | Goods imported - Output VAT | Box 4, Field 131 |
GCC Transfer Codes (Sales)
| Code | Description | VAT Return Field |
|---|---|---|
| 180 | Goods transferred to Bahrain (base) | Box 1, Field 180 |
| 181 | Goods transferred to Bahrain (VAT) | Box 2, Field 181 |
| 190 | Goods transferred to Kuwait (base) | Box 1, Field 190 |
| 191 | Goods transferred to Kuwait (VAT) | Box 2, Field 191 |
| 200 | Goods transferred to Oman (base) | Box 1, Field 200 |
| 201 | Goods transferred to Oman (VAT) | Box 2, Field 201 |
| 210 | Goods transferred to Qatar (base) | Box 1, Field 210 |
| 211 | Goods transferred to Qatar (VAT) | Box 2, Field 211 |
| 220 | Goods transferred to Saudi Arabia (base) | Box 1, Field 220 |
| 221 | Goods transferred to Saudi Arabia (VAT) | Box 2, Field 221 |
GCC VAT Recovery Codes (Purchases)
| Code | Description | VAT Return Field |
|---|---|---|
| 230 | VAT paid in Bahrain (base) | Box 10, Field 230 |
| 231 | VAT paid in Bahrain (recoverable) | Box 11, Field 231 |
| 240 | VAT paid in Kuwait (base) | Box 10, Field 240 |
| 241 | VAT paid in Kuwait (recoverable) | Box 11, Field 241 |
| 250 | VAT paid in Oman (base) | Box 10, Field 250 |
| 251 | VAT paid in Oman (recoverable) | Box 11, Field 251 |
| 260 | VAT paid in Qatar (base) | Box 10, Field 260 |
| 261 | VAT paid in Qatar (recoverable) | Box 11, Field 261 |
| 270 | VAT paid in Saudi Arabia (base) | Box 10, Field 270 |
| 271 | VAT paid in Saudi Arabia (recoverable) | Box 11, Field 271 |
How to Configure Tax Reporting Codes
Step 1: Tax Codes Setup
For each tax code, assign reporting codes for all four scenarios:
Example: SRSD (Standard Rated Supplies - Dubai)
Tax Code: SRSD
Description: Standard 5% VAT - Dubai
Tax Rate: 5%
Reporting Codes:
├─ Sales Base Amount: "20" (Box 1, Field 20)
├─ Sales Tax Amount: "21" (Box 2, Field 21)
├─ Purchase Base Amount: "170" (Box 8)
└─ Purchase Tax Amount: "171" (Box 9)
Why all four?
- Sales codes: Used when invoicing customers
- Purchase codes: Used when receiving supplier invoices
- Some tax codes can appear on both sides
Example: ZRS (Zero Rated Supplies)
Tax Code: ZRS
Description: Zero-rated supplies (exports)
Tax Rate: 0%
Reporting Codes:
├─ Sales Base Amount: "100" (Box 5)
├─ Sales Tax Amount: (None - 0% rate)
├─ Purchase Base Amount: "170" (Box 8)
└─ Purchase Tax Amount: "171" (Box 9)
Step 2: Verify During Transactions
When creating invoices:
- Select appropriate tax code (e.g., SRSD)
- System automatically uses assigned reporting codes
- No manual intervention required
At period end:
- Generate VAT return
- Review amounts in each box
- Verify totals match your transaction records
- Submit to FTA
Common Scenarios
Scenario 1: Retail Business in Dubai
Business Profile:
- Physical store in Dubai
- All sales in Dubai
- Purchases from UAE suppliers
Tax Codes Used:
- SRSD (Standard Rated Supplies - Dubai) for sales
- SRE (Standard Rated Expenses) for purchases
Reporting Codes:
- Sales → "20" (base), "21" (VAT) → Box 1/2, Field 20/21
- Purchases → "170" (base), "171" (VAT) → Box 8/9
VAT Return Result:
Box 1, Field 20: AED 500,000 (Dubai sales)
Box 2, Field 21: AED 25,000 (Output VAT)
Box 8: AED 200,000 (Purchases)
Box 9: AED 10,000 (Input VAT)
Box 13: AED 15,000 (Net VAT payable)
Scenario 2: Export Business
Business Profile:
- Exports to international markets
- Zero-rated sales (0% VAT)
- Standard purchases in UAE
Tax Codes Used:
- ZRS (Zero Rated Supplies) for export sales
- SRE (Standard Rated Expenses) for purchases
Reporting Codes:
- Exports → "100" → Box 5
- Purchases → "170" (base), "171" (VAT) → Box 8/9
VAT Return Result:
Box 5: AED 1,000,000 (Zero-rated exports)
Box 8: AED 200,000 (Purchases)
Box 9: AED 10,000 (Input VAT)
Box 13: (AED 10,000) (VAT refund position)
Scenario 3: Multi-Emirate Operations
Business Profile:
- Branches in Abu Dhabi, Dubai, and Sharjah
- Sales tracked by emirate for reporting
Tax Codes Used:
- SRSAD (Abu Dhabi sales)
- SRSD (Dubai sales)
- SRSS (Sharjah sales)
Reporting Codes:
- Abu Dhabi → "10" (base), "11" (VAT)
- Dubai → "20" (base), "21" (VAT)
- Sharjah → "30" (base), "31" (VAT)
VAT Return Result:
Box 1, Field 10: AED 300,000 (Abu Dhabi)
Box 1, Field 20: AED 500,000 (Dubai)
Box 1, Field 30: AED 200,000 (Sharjah)
Box 2, Field 11: AED 15,000 (AD VAT)
Box 2, Field 21: AED 25,000 (DB VAT)
Box 2, Field 31: AED 10,000 (SH VAT)
Total Output VAT: AED 50,000
Common Mistakes to Avoid
Mistake 1: Not Assigning Reporting Codes to Tax Codes
Problem:
Tax Code: SRSD
Sales Base Reporting Code: (Not assigned)
Sales Tax Reporting Code: (Not assigned)
Result: Transactions don't appear on VAT return
Solution: Always assign all four reporting codes when creating tax codes.
Mistake 2: Using Wrong Emirate Code
Problem:
Sale in Dubai
Tax Code Used: SRSAD (Abu Dhabi code)
Result: Amount reported under Abu Dhabi instead of Dubai
Solution: Train users to select correct tax code based on transaction location.
Mistake 3: Mixing Up Base and Tax Codes
Problem:
Tax Code Configuration:
Sales Base Reporting Code: "21" (Should be "20")
Sales Tax Reporting Code: "20" (Should be "21")
Result: Base amount in VAT box, VAT amount in base box
Solution: Follow naming convention - even numbers for base, odd for VAT (e.g., 20/21, 30/31).
Summary
Tax Reporting Codes are the "address" system for tax amounts on VAT returns.
Key Takeaways:
- Automation - Eliminate manual VAT return preparation
- Accuracy - Reduce human error in tax reporting
- Compliance - Meet FTA electronic reporting requirements
- Efficiency - Generate VAT returns in minutes, not hours
- Traceability - Clear audit trail from transaction to tax return
How They Work:
- Each Tax Code is assigned four Tax Reporting Codes
- When transactions are posted, they're tagged with reporting codes
- At period end, system aggregates amounts by reporting code
- VAT return generated with amounts in correct boxes
- Ready for review and FTA submission
Next Steps:
- Review your tax codes and assign reporting codes
- Verify reporting code setup before going live
- Test with sample transactions
- Generate test VAT return and verify accuracy
- Train users on selecting correct tax codes
Related Resources
Business Concepts:
- UAE VAT Setup and Reporting - Legal entity VAT configuration
- Understanding Sales Tax and VAT - How VAT calculation works
- Understanding Main Accounts - VAT posting accounts
User Guides:
- How to Configure Tax Reporting Codes (step-by-step)
- How to Assign Reporting Codes to Tax Codes
- How to Generate UAE VAT Returns
- How to Verify VAT Return Accuracy
For Administrators:
- Tax Reporting Code Configuration (technical setup)
- Tax Report Layout Management (multi-country forms)
- VAT Return Generation Process (system workflow)
External Resources:
- Federal Tax Authority (FTA) - Official UAE tax authority
- UAE VAT Executive Regulation - Legal framework
- FTA VAT Guide - Official compliance guide
This guide is part of the ERP Business Concepts series, designed to help business users understand tax reporting automation without technical jargon.