在此文中
Multi currency-accounting template for enterprise in United Arab Emirates
UAE (United Arab Emirates)
Double-Entry Accounting with foreign currencies
Business
Double entry accounting for the United Arab Emirates.
模板预览
UAE-Multicurrency-VAT
Basic Currency: AED
Double-entry with foreign currencies
| Group | Account | Description | Currency | Sum In |
|---|---|---|---|---|
| BALANCE SHEET | ||||
| ASSETS | ||||
| 101001 | Trademark | AED | 101NCA | |
| 101NCA | Intangible Non Current Assets | 1NCA | ||
| 102001 | Machineries and appliances | AED | 102NCA | |
| 102005 | Furniture | AED | 102NCA | |
| 102010 | Hardware | AED | 102NCA | |
| 102015 | Software | AED | 102NCA | |
| 102NCA | Tangible Non Current Assets | 1NCA | ||
| 103001 | Security Deposit | AED | 103NCA | |
| 103NCA | Financial Non Current Assets | 1NCA | ||
| 1NCA | Non Current Assets | 1 | ||
| 107001 | Inventory | AED | 107CA | |
| 107CA | Inventory | 1CA | ||
| 10 | Clients | 108CA | ||
| 108001 | Invoices to be issued | AED | 108CA | |
| 108CA | Trade receivables | 1CA | ||
| 109001 | Advance Payment | AED | 109CA | |
| 109005 | Prepaid Rent | AED | 109CA | |
| 109010 | Prepaid License Fee | AED | 109CA | |
| 109015 | Prepaid Insurance | AED | 109CA | |
| 109020 | Rent Security Deposit | AED | 109CA | |
| 109CA | Other Current Assets | 1CA | ||
| 110001 | input VAT on purchases (box 9) | AED | 110CA | |
| 110002 | - Input VAT - adjustment unpaid suppliers older than 6 month (box 9) | AED | 110CA | |
| 110005 | Input VAT - purchase with reverse charge (box 10) | AED | 110CA | |
| 110CA | Tax Receivable | 1CA | ||
| 112001 | Cash | AED | 112CA | |
| 112005 | Bank AED | AED | 112CA | |
| 112010 | Bank EUR | EUR | 112CA | |
| 112015 | Bank USD | USD | 112CA | |
| 112016 | Bank CNY | CNY | 112CA | |
| 112CA | Cash and cash equivalent | 1CA | ||
| 1CA | Current Assets | 1 | ||
| 1 | Total ASSETS | 00 | ||
| LIABILITIES | ||||
| 201001 | Share Capital | AED | 2SE | |
| 201005 | Reseve | AED | 2SE | |
| 201010 | Retained (Profit) or Loss | AED | 2SE | |
| 230 | Profit or loss of the current year | 2 | ||
| 2SE | Shareholders' Equity | 2 | ||
| 205001 | Shareholders' loan - AED | AED | 205NCL | |
| 201002 | Shareholders' loan - EUR | EUR | 205NCL | |
| 205010 | Long term loan | AED | 205NCL | |
| 205NCL | Financial Non Current Liabilities | 2NCL | ||
| 207001 | End of service gratuity | AED | 207NCL | |
| 207NCL | Employee Benefit Provision | 2NCL | ||
| 2NCL | Non Current Liabilities | 2 | ||
| 210001 | Bank Loan | AED | 210CL | |
| 210CL | Financial Current Liabilities | 2CL | ||
| 20 | Suppliers | AED | 211CL | |
| 211005 | Invoices to be received | AED | 211CL | |
| 211CL | Trade payables | 2CL | ||
| 212200A | Automatic VAT | AED | 212CL | |
| 212200 | VAT payable | AED | 212CL | |
| 212201 | Automatic VAT Account | AED | 212CL | |
| 212202 | VAT temporary reverse charge | AED | 212CL | |
| 212CL | Tax liabilities | 2CL | ||
| 213001 | Payables vs personnel | AED | 213CL | |
| 213015 | Accruals AED | AED | 213CL | |
| 213020 | Other current liabilities | AED | 213CL | |
| 213CL | Other Current Liabilities | 2CL | ||
| 2CL | Current Liabilities | 2 | ||
| 2 | Total LIABILITIES & EQUITY | 00 | ||
| PROFIT/LOSS STATEMENT | ||||
| EXPENSES | ||||
| 301001 | Variation of inventories | AED | 301MA | |
| 301005 | Purchase of materials | AED | 301MA | |
| 301015 | Duty and freight | AED | 301MA | |
| 301MA | Material | 3OC | ||
| 302001 | Licenses | AED | 302SE | |
| 302005 | Administrative costs | AED | 302SE | |
| 302010 | Professioanal consultancies | AED | 302SE | |
| 302015 | Legal fee | AED | 302SE | |
| 302020 | Accounting services | AED | 302SE | |
| 302025 | Audit fee | AED | 302SE | |
| 302030 | Utilities | AED | 302SE | |
| 302035 | Maintenance and repairs | AED | 302SE | |
| 302040 | IT services | AED | 302SE | |
| 302045 | Office rent | AED | 302SE | |
| 302050 | Travel expenses | AED | 302SE | |
| 302055 | Marketing expenses | AED | 302SE | |
| 302060 | Insurance | AED | 302SE | |
| 302SE | Services Rental and Lease | 3OC | ||
| 303001 | Salary | AED | 303PE | |
| 303005 | End of service | AED | 303PE | |
| 303010 | Health insurance | AED | 303PE | |
| 303015 | VISA | AED | 303PE | |
| 303020 | Other personnel cost | AED | 303PE | |
| 303PE | Personnel | 3OC | ||
| 304001 | Amort machineries and appliances | AED | 304AM | |
| 304005 | Amort furniture | AED | 304AM | |
| 304010 | Amort hardware | AED | 304AM | |
| 304AM | Amortisation | 3OC | ||
| 305001 | provision for doubtful accounts | AED | 305OT | |
| 305015 | other provision | AED | 305OT | |
| 305020 | Negative adjustments | AED | 305OT | |
| 305OT | Other costs | 3OC | ||
| 3OC | Operating costs | 3 | ||
| 306001 | Bank interest payable | AED | 3FC | |
| 306005 | Foreign currency losses | AED | 3FC | |
| 3FC | Finance Costs | 3 | ||
| 3 | Total EXPENSES | 02 | ||
| REVENUE | ||||
| 401001 | Sales | AED | 401EI | |
| 401EI | External Incomes | 4OI | ||
| 402001 | Services Intragroup | AED | 402II | |
| 402II | Intragroup Incomes | 4OI | ||
| 403001 | Positive adjustments | AED | 403OI | |
| 403005 | Ohter Incomes | AED | 403OI | |
| 403OI | Other Incomes | 4OI | ||
| 4OI | Operating revenues | 4 | ||
| 404001 | Bank interest receivable | AED | 4FI | |
| 404005 | Foreigh currency profit | AED | 4FI | |
| 4FI | Finance Income | 4 | ||
| 4 | Total REVENUE | 02 | ||
| 02 | Profit(-) Loss(+) from Profit & Loss Statement | 230 | ||
| 00 | Difference should be = 0 (blank cell) | |||
| Customers/Debtors | ||||
| 11.001 | Altmann&Sons | AED | 10A | |
| 11.002 | Peter&Co. | AED | 10A | |
| 11.003 | MC | AED | 10A | |
| 11.004 | JDWater | AED | 10A | |
| 11.005 | RossiCostruzioni | AED | 10A | |
| 10A | Total Customers | 10 | ||
| Suppliers/Creditors | ||||
| 20.001 | Smith&Co | AED | 20A | |
| 20.002 | Doe&Sons | AED | 20A | |
| 20.003 | BosiaSoftware | AED | 20A | |
| 20A | Total Suppliers | 20 |
| Ref.Currency | Currency | Text |
|---|---|---|
| AED | EUR | Euro |
| AED | USD | US Dollars |
| AED | CNY | Chinese Yuan |