From 3751379f1e9a4c215fb6eb898b4ccc67659b9ace Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 10 May 2022 21:51:50 +0700 Subject: initial commit 2 --- addons/l10n_uk/data/account.account.template.csv | 101 ++++++ addons/l10n_uk/data/account.chart.template.csv | 2 + addons/l10n_uk/data/account.tax.group.csv | 5 + .../l10n_uk/data/account_chart_template_data.xml | 8 + addons/l10n_uk/data/account_tax_data.xml | 388 +++++++++++++++++++++ addons/l10n_uk/data/account_tax_report_data.xml | 104 ++++++ addons/l10n_uk/data/l10n_uk_chart_data.xml | 14 + 7 files changed, 622 insertions(+) create mode 100644 addons/l10n_uk/data/account.account.template.csv create mode 100644 addons/l10n_uk/data/account.chart.template.csv create mode 100644 addons/l10n_uk/data/account.tax.group.csv create mode 100644 addons/l10n_uk/data/account_chart_template_data.xml create mode 100644 addons/l10n_uk/data/account_tax_data.xml create mode 100644 addons/l10n_uk/data/account_tax_report_data.xml create mode 100644 addons/l10n_uk/data/l10n_uk_chart_data.xml (limited to 'addons/l10n_uk/data') diff --git a/addons/l10n_uk/data/account.account.template.csv b/addons/l10n_uk/data/account.account.template.csv new file mode 100644 index 00000000..2bf60920 --- /dev/null +++ b/addons/l10n_uk/data/account.account.template.csv @@ -0,0 +1,101 @@ +"id","code","name","user_type_id:id","reconcile","chart_template_id:id" +"0010","0010","Software","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0011","0011","Software Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0020","0020","Patents & Trademarks","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0021","0021","Patents & Trademarks Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0030","0030","Fixtures and fittings","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0031","0031","Fixtures and fittings Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0040","0040","Land and buildings","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0041","0041","Land and buildings Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0050","0050","Motor vehicles","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0051","0051","Motor vehicles Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0060","0060","Office equipment (inc computer equipment)","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0061","0061","Office equipment (inc computer equipment) Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0070","0070","Plant and machinery","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"0071","0071","Plant and machinery Depreciation","account.data_account_type_fixed_assets","FALSE","l10n_uk" +"1001","1001","Stock","account.data_account_type_current_assets","TRUE","l10n_uk" +"1002","1002","Work in Progress","account.data_account_type_current_assets","FALSE","l10n_uk" +"1003","1003","Finished Goods","account.data_account_type_current_assets","FALSE","l10n_uk" +"1100","1100","Debtors Control Account","account.data_account_type_receivable","TRUE","l10n_uk" +"1101","1101","Sundry Debtors","account.data_account_type_receivable","TRUE","l10n_uk" +"1102","1102","Other Debtors","account.data_account_type_current_assets","FALSE","l10n_uk" +"1104","1104","Debtors Control Account (PoS)","account.data_account_type_receivable","TRUE","l10n_uk" +"1240","1240","Company Credit Card","account.data_account_type_current_assets","TRUE","l10n_uk" +"1103","1103","Prepayments","account.data_account_type_current_assets","FALSE","l10n_uk" +"2100","2100","Creditors Control Account","account.data_account_type_payable","TRUE","l10n_uk" +"2101","2101","Sundry Creditors","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2102","2102","Other Creditors","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2200","2200","Sales Tax Control Account","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2201","2201","Purchase Tax Control Account","account.data_account_type_current_assets","FALSE","l10n_uk" +"2202","2202","HMRC - VAT Account","account.data_account_type_payable","TRUE","l10n_uk" +"2204","2204","Manual Adjustments οΎ– VAT","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2210","2210","P.A.Y.E. & NI","account.data_account_type_payable","TRUE","l10n_uk" +"2220","2220","Net Wages","account.data_account_type_payable","TRUE","l10n_uk" +"2230","2230","Pension Fund","account.data_account_type_payable","TRUE","l10n_uk" +"2150","2150","Bad debt provision","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2109","2109","Accruals","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2320","2320","Corporation Tax","account.data_account_type_payable","TRUE","l10n_uk" +"2300","2300","Loans","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2310","2310","Hire Purchase","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"2330","2330","Mortgages","account.data_account_type_current_liabilities","FALSE","l10n_uk" +"3000","3000","Called up share capital","account.data_account_type_equity","FALSE","l10n_uk" +"3010","3010","Share premium account","account.data_account_type_equity","FALSE","l10n_uk" +"3020","3020","Revaluation reserve","account.data_account_type_equity","FALSE","l10n_uk" +"3030","3030","Other reserves","account.data_account_type_equity","FALSE","l10n_uk" +"4000","4000","Sales category 1","account.data_account_type_revenue","FALSE","l10n_uk" +"4001","4001","Sales category 2","account.data_account_type_revenue","FALSE","l10n_uk" +"4002","4002","Sales category 3","account.data_account_type_revenue","FALSE","l10n_uk" +"4003","4003","Sales category 4","account.data_account_type_revenue","FALSE","l10n_uk" +"5000","5000","Cost of sales 1","account.data_account_type_expenses","FALSE","l10n_uk" +"5001","5001","Cost of sales 2","account.data_account_type_expenses","FALSE","l10n_uk" +"5002","5002","Cost of sales 3","account.data_account_type_expenses","FALSE","l10n_uk" +"5003","5003","Cost of sales 4","account.data_account_type_expenses","FALSE","l10n_uk" +"6000","6000","Marketing, POS","account.data_account_type_expenses","FALSE","l10n_uk" +"6001","6001","Exhibitions and events","account.data_account_type_expenses","FALSE","l10n_uk" +"6002","6002","PR","account.data_account_type_expenses","FALSE","l10n_uk" +"6010","6010","Distribution vehicles","account.data_account_type_expenses","FALSE","l10n_uk" +"6020","6020","Distribution salaries and wages","account.data_account_type_expenses","FALSE","l10n_uk" +"6030","6030","Shipping","account.data_account_type_expenses","FALSE","l10n_uk" +"7000","7000","Directors pension","account.data_account_type_expenses","FALSE","l10n_uk" +"7001","7001","Directors remuneration","account.data_account_type_expenses","FALSE","l10n_uk" +"7010","7010","Admin gross salaries","account.data_account_type_expenses","FALSE","l10n_uk" +"7011","7011","Management gross salaries","account.data_account_type_expenses","FALSE","l10n_uk" +"7012","7012","Employers NIC","account.data_account_type_expenses","FALSE","l10n_uk" +"7020","7020","Subcontractors payments","account.data_account_type_expenses","FALSE","l10n_uk" +"7610","7610","Consultancy","account.data_account_type_expenses","FALSE","l10n_uk" +"7620","7620","Legal and professional charges","account.data_account_type_expenses","FALSE","l10n_uk" +"7601","7601","Accounting","account.data_account_type_expenses","FALSE","l10n_uk" +"7602","7602","Auditing","account.data_account_type_expenses","FALSE","l10n_uk" +"7110","7110","Light, heat and power","account.data_account_type_expenses","FALSE","l10n_uk" +"7100","7100","Rent and rates","account.data_account_type_expenses","FALSE","l10n_uk" +"7120","7120","Repairs, renewals and maintenance","account.data_account_type_expenses","FALSE","l10n_uk" +"7300","7300","Car hire","account.data_account_type_expenses","FALSE","l10n_uk" +"7301","7301","Car fuel","account.data_account_type_expenses","FALSE","l10n_uk" +"7302","7302","Car maintenance","account.data_account_type_expenses","FALSE","l10n_uk" +"7502","7502","Telephone","account.data_account_type_expenses","FALSE","l10n_uk" +"7503","7503","Internet & hosting","account.data_account_type_expenses","FALSE","l10n_uk" +"7504","7504","Mobiles","account.data_account_type_expenses","FALSE","l10n_uk" +"7505","7505","Stationery","account.data_account_type_expenses","FALSE","l10n_uk" +"7506","7506","Office consumables","account.data_account_type_expenses","FALSE","l10n_uk" +"7507","7507","Postage and Carriage","account.data_account_type_expenses","FALSE","l10n_uk" +"7508","7508","Books","account.data_account_type_expenses","FALSE","l10n_uk" +"7509","7509","Network costs","account.data_account_type_expenses","FALSE","l10n_uk" +"7510","7510","Software expenses","account.data_account_type_expenses","FALSE","l10n_uk" +"7511","7511","Other computer costs","account.data_account_type_expenses","FALSE","l10n_uk" +"7512","7512","Recruitment fees","account.data_account_type_expenses","FALSE","l10n_uk" +"7513","7513","Other admin expenses","account.data_account_type_expenses","FALSE","l10n_uk" +"7700","7700","Exchange gains/losses","account.data_account_type_expenses","FALSE","l10n_uk" +"7710","7710","Other sundry expenses","account.data_account_type_expenses","FALSE","l10n_uk" +"7850","7850","Bad debts","account.data_account_type_expenses","FALSE","l10n_uk" +"7910","7910","Bank, credit card and other financial charges","account.data_account_type_expenses","FALSE","l10n_uk" +"8000","8000","Intangible assets depn","account.data_account_type_expenses","FALSE","l10n_uk" +"8001","8001","Tangible assets depn","account.data_account_type_expenses","FALSE","l10n_uk" +"8200","8200","Donations","account.data_account_type_expenses","FALSE","l10n_uk" +"8300","8300","Entertaining","account.data_account_type_expenses","FALSE","l10n_uk" +"8400","8400","Insurance","account.data_account_type_expenses","FALSE","l10n_uk" +"8500","8500","Travel and subsistence","account.data_account_type_expenses","FALSE","l10n_uk" +"9000","9000","Profits/Losses on disposals of assets","account.data_account_type_revenue","FALSE","l10n_uk" +"4900","4900","Bank Interest received","account.data_account_type_revenue","FALSE","l10n_uk" +"4910","4910","Investment Interest received","account.data_account_type_revenue","FALSE","l10n_uk" +"7900","7900","Interest paid","account.data_account_type_expenses","FALSE","l10n_uk" +"8800","8800","Corporation tax expense","account.data_account_type_expenses","FALSE","l10n_uk" diff --git a/addons/l10n_uk/data/account.chart.template.csv b/addons/l10n_uk/data/account.chart.template.csv new file mode 100644 index 00000000..a7ececab --- /dev/null +++ b/addons/l10n_uk/data/account.chart.template.csv @@ -0,0 +1,2 @@ +"id","name","property_account_receivable_id:id","property_account_payable_id:id","property_account_expense_categ_id:id","property_account_income_categ_id:id","income_currency_exchange_account_id:id","expense_currency_exchange_account_id:id","default_pos_receivable_account_id:id","use_anglo_saxon" +"l10n_uk","UK Tax and Account Chart Template (by SmartMode)","1100","2100","5000","4000","7700","7700","1104","True" diff --git a/addons/l10n_uk/data/account.tax.group.csv b/addons/l10n_uk/data/account.tax.group.csv new file mode 100644 index 00000000..a352a493 --- /dev/null +++ b/addons/l10n_uk/data/account.tax.group.csv @@ -0,0 +1,5 @@ +id,name +tax_group_0,TAX 0% +tax_group_5,TAX 5% +tax_group_175,TAX 17.5% +tax_group_20,TAX 20% diff --git a/addons/l10n_uk/data/account_chart_template_data.xml b/addons/l10n_uk/data/account_chart_template_data.xml new file mode 100644 index 00000000..6ad3b918 --- /dev/null +++ b/addons/l10n_uk/data/account_chart_template_data.xml @@ -0,0 +1,8 @@ + + + + + + + + diff --git a/addons/l10n_uk/data/account_tax_data.xml b/addons/l10n_uk/data/account_tax_data.xml new file mode 100644 index 00000000..db1a6429 --- /dev/null +++ b/addons/l10n_uk/data/account_tax_data.xml @@ -0,0 +1,388 @@ + + + + + ST0 + + sale + Zero rated sales + percent + 0 + + + + + + + ST2 + + sale + Exempt sales + percent + 0 + + + + + + + PT0 + + purchase + Zero rated purchases + percent + 0 + + + + + + + PT2 + + purchase + Exempt purchases + percent + 0 + + + + + + + PT8 + + purchase + Standard rated purchases from EC + percent + 20 + + + + + + + PT5 + + purchase + Lower rate purchases (5%) + percent + 5 + + + + + + + ST5 + + sale + Lower rate sales (5%) + percent + 5 + + + + + + + ST4 + + sale + Sales to customers in EC + percent + 0 + + + + + + + PT7 + + purchase + Zero rated purchases from EC + percent + 0 + + + + + + + ST11 + + sale + Standard rate sales (20%) + percent + 20 + + + + + + + PT11 + + purchase + Standard rate purchases (20%) + percent + 20 + + + + + + \ No newline at end of file diff --git a/addons/l10n_uk/data/account_tax_report_data.xml b/addons/l10n_uk/data/account_tax_report_data.xml new file mode 100644 index 00000000..65caaa7e --- /dev/null +++ b/addons/l10n_uk/data/account_tax_report_data.xml @@ -0,0 +1,104 @@ + + + + + Tax Report + + + + + VAT calculations + + + + + + [BOX 1] VAT due on sales and other outputs + 1 + UKTAX_1 + + + + + + + [BOX 2] VAT due on acquisitions from EC + 2 + UKTAX_2 + + + + + + + [BOX 3] Total VAT due (box 1 + box 2) + + + UKTAX_1 + UKTAX_2 + + + + + [BOX 4] VAT reclaimed on purchases and other inputs (including acquisitions from EC) + 4 + UKTAX_4 + + + + + + + [BOX 5] VAT to pay/reclaim + + + UKTAX_1 + UKTAX_2 - UKTAX_4 + + + + + Sales and Purchases Excluding VAT + + + + + + [BOX 6] Total value of sales and other outputs excluding VAT (including EC supplies) + 6 + + + + + + + EC Sales and Purchases excluding VAT + + + + + + [BOX 7] Total value of purchases and inputs excluding VAT (including EC acquisitions) + 7 + + + + + + + [BOX 8] Total value of EC sales excluding VAT + 8 + UKTAX_8 + + + + + + + [BOX 9] Total value of EC purchases excluding VAT + 9 + UKTAX_9 + + + + + + \ No newline at end of file diff --git a/addons/l10n_uk/data/l10n_uk_chart_data.xml b/addons/l10n_uk/data/l10n_uk_chart_data.xml new file mode 100644 index 00000000..ed3d46d5 --- /dev/null +++ b/addons/l10n_uk/data/l10n_uk_chart_data.xml @@ -0,0 +1,14 @@ + + + + + + + UK Tax and Account Chart Template (by SmartMode) + 1200 + 1210 + 1220 + 6 + + + -- cgit v1.2.3