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_za/data/account.account.tag.csv | 17 + addons/l10n_za/data/account.account.template.csv | 112 +++++ addons/l10n_za/data/account.tax.group.csv | 3 + .../data/account_chart_template_configure_data.xml | 8 + .../l10n_za/data/account_chart_template_data.xml | 15 + .../data/account_chart_template_post_data.xml | 18 + addons/l10n_za/data/account_tax_report_data.xml | 253 ++++++++++ addons/l10n_za/data/account_tax_template_data.xml | 552 +++++++++++++++++++++ 8 files changed, 978 insertions(+) create mode 100644 addons/l10n_za/data/account.account.tag.csv create mode 100644 addons/l10n_za/data/account.account.template.csv create mode 100644 addons/l10n_za/data/account.tax.group.csv create mode 100644 addons/l10n_za/data/account_chart_template_configure_data.xml create mode 100644 addons/l10n_za/data/account_chart_template_data.xml create mode 100644 addons/l10n_za/data/account_chart_template_post_data.xml create mode 100644 addons/l10n_za/data/account_tax_report_data.xml create mode 100644 addons/l10n_za/data/account_tax_template_data.xml (limited to 'addons/l10n_za/data') diff --git a/addons/l10n_za/data/account.account.tag.csv b/addons/l10n_za/data/account.account.tag.csv new file mode 100644 index 00000000..99438878 --- /dev/null +++ b/addons/l10n_za/data/account.account.tag.csv @@ -0,0 +1,17 @@ +id,name,applicability,country_id:id +tag_ST1,ST1,taxes,base.za +tag_ST1A,ST1A,taxes,base.za +tag_ST2,ST2,taxes,base.za +tag_ST2A,ST2A,taxes,base.za +tag_ST3,ST3,taxes,base.za +tag_ST5,ST5,taxes,base.za +tag_ST7,ST7,taxes,base.za +tag_ST10,ST10,taxes,base.za +tag_ST12,ST12,taxes,base.za +tag_PT14,PT14,taxes,base.za +tag_PT14A,PT14A,taxes,base.za +tag_PT15,PT15,taxes,base.za +tag_PT15A,PT15A,taxes,base.za +tag_PT16,PT16,taxes,base.za +tag_PT17,PT17,taxes,base.za +tag_PT18,PT18,taxes,base.za diff --git a/addons/l10n_za/data/account.account.template.csv b/addons/l10n_za/data/account.account.template.csv new file mode 100644 index 00000000..17fbef2b --- /dev/null +++ b/addons/l10n_za/data/account.account.template.csv @@ -0,0 +1,112 @@ +id,code,name,user_type_id/id,reconcile,chart_template_id/id +100020,100020,Stock Valuation Account,account.data_account_type_current_assets,True,default_chart_template +100030,100030,Stock Work In Progress,account.data_account_type_current_assets,False,default_chart_template +100040,100040,Stock Finished Goods,account.data_account_type_current_assets,False,default_chart_template +100050,100050,Stock Delivered Control Account,account.data_account_type_current_assets,True,default_chart_template +100060,100060,Purchase Tax Control Account,account.data_account_type_current_assets,False,default_chart_template +100070,100070,Other Current Assets,account.data_account_type_current_assets,False,default_chart_template +110010,110010,Debtors Control Account,account.data_account_type_receivable,True,default_chart_template +110020,110020,Sundry Debtors,account.data_account_type_receivable,True,default_chart_template +110030,110030,Debtors Control Account (PoS),account.data_account_type_receivable,True,default_chart_template +124010,124010,Credit Card Merchant Account,account.data_account_type_liquidity,False,default_chart_template +126010,126010,Cash In Hand,account.data_account_type_liquidity,False,default_chart_template +130010,130010,Prepayments,account.data_account_type_prepayments,False,default_chart_template +140010,140010,Software,account.data_account_type_fixed_assets,False,default_chart_template +140020,140020,Patents & Trademarks,account.data_account_type_fixed_assets,False,default_chart_template +140030,140030,Fixtures & Fittings,account.data_account_type_fixed_assets,False,default_chart_template +140040,140040,Land & Buildings,account.data_account_type_fixed_assets,False,default_chart_template +140050,140050,Motor Vehicles,account.data_account_type_fixed_assets,False,default_chart_template +140060,140060,Office Equipment (incl computer equipment),account.data_account_type_fixed_assets,False,default_chart_template +140070,140070,Plant & Machinery,account.data_account_type_fixed_assets,False,default_chart_template +150010,150010,Non-current assets,account.data_account_type_non_current_assets,False,default_chart_template +200010,200010,Stock Received Control Account,account.data_account_type_current_liabilities,True,default_chart_template +200020,200020,Sundry Creditors,account.data_account_type_current_liabilities,False,default_chart_template +200030,200030,Other Creditors,account.data_account_type_current_liabilities,False,default_chart_template +200040,200040,Accruals,account.data_account_type_current_liabilities,False,default_chart_template +200050,200050,Bad debt provision,account.data_account_type_current_liabilities,False,default_chart_template +200060,200060,Sales Tax Control Account,account.data_account_type_current_liabilities,False,default_chart_template +200070,200070,Manual Adjustments & VAT,account.data_account_type_current_liabilities,False,default_chart_template +200080,200080,Loans,account.data_account_type_current_liabilities,False,default_chart_template +200090,200090,Hire Purchase,account.data_account_type_current_liabilities,False,default_chart_template +200100,200100,Mortgages,account.data_account_type_current_liabilities,False,default_chart_template +210010,210010,Company Credit Card,account.data_account_type_credit_card,False,default_chart_template +220010,220010,Creditors Control Account,account.data_account_type_payable,True,default_chart_template +220020,220020,SARS - VAT Account,account.data_account_type_payable,True,default_chart_template +220030,220030,P.A.Y.E. & UIF,account.data_account_type_payable,True,default_chart_template +220040,220040,Net Wages,account.data_account_type_payable,True,default_chart_template +220050,220050,Pension Fund,account.data_account_type_payable,True,default_chart_template +220060,220060,Corporation Tax,account.data_account_type_payable,True,default_chart_template +300010,300010,Called up share capital,account.data_account_type_equity,False,default_chart_template +300020,300020,Share premium account,account.data_account_type_equity,False,default_chart_template +300030,300030,Revaluation reserve,account.data_account_type_equity,False,default_chart_template +300040,300040,Other reserves,account.data_account_type_equity,False,default_chart_template +300050,300050,Capital,account.data_account_type_equity,False,default_chart_template +300060,300060,Dividends,account.data_account_type_equity,False,default_chart_template +300070,300070,Drawings,account.data_account_type_equity,False,default_chart_template +400010,400010,Undistributed Profits/Losses,account.data_unaffected_earnings,False,default_chart_template +500010,500010,Sales category 1,account.data_account_type_revenue,False,default_chart_template +500020,500020,Sales category 2,account.data_account_type_revenue,False,default_chart_template +500030,500030,Sales category 3,account.data_account_type_revenue,False,default_chart_template +500040,500040,Sales category 4,account.data_account_type_revenue,False,default_chart_template +500050,500050,Bank Interest received,account.data_account_type_revenue,False,default_chart_template +500060,500060,Investment Interest received,account.data_account_type_revenue,False,default_chart_template +500070,500070,Profits/Losses on disposals of assets,account.data_account_type_revenue,False,default_chart_template +500080,500080,Rental Income,account.data_account_type_revenue,False,default_chart_template +510010,510010,Other Income,account.data_account_type_other_income,False,default_chart_template +600010,600010,Cost of sales 1,account.data_account_type_direct_costs,False,default_chart_template +600020,600020,Cost of sales 2,account.data_account_type_direct_costs,False,default_chart_template +600030,600030,Cost of sales 3,account.data_account_type_direct_costs,False,default_chart_template +600040,600040,Cost of sales 4,account.data_account_type_direct_costs,False,default_chart_template +610010,610010,Marketing,account.data_account_type_expenses,False,default_chart_template +610020,610020,Exhibitions and events,account.data_account_type_expenses,False,default_chart_template +610030,610030,PR,account.data_account_type_expenses,False,default_chart_template +610040,610040,Distribution vehicles,account.data_account_type_expenses,False,default_chart_template +610050,610050,Distribution salaries and wages,account.data_account_type_expenses,False,default_chart_template +610060,610060,Shipping,account.data_account_type_expenses,False,default_chart_template +610070,610070,Directors pension,account.data_account_type_expenses,False,default_chart_template +610080,610080,Directors remuneration,account.data_account_type_expenses,False,default_chart_template +610090,610090,Gross Salaries,account.data_account_type_expenses,False,default_chart_template +610100,610100,Employers SDL & UIF,account.data_account_type_expenses,False,default_chart_template +610110,610110,Subcontractors payments,account.data_account_type_expenses,False,default_chart_template +610120,610120,Rent and rates,account.data_account_type_expenses,False,default_chart_template +610130,610130,Light / heat and power,account.data_account_type_expenses,False,default_chart_template +610140,610140,Repairs and maintenance,account.data_account_type_expenses,False,default_chart_template +610150,610150,Car hire,account.data_account_type_expenses,False,default_chart_template +610160,610160,Car fuel,account.data_account_type_expenses,False,default_chart_template +610170,610170,Car maintenance,account.data_account_type_expenses,False,default_chart_template +610180,610180,Telephone,account.data_account_type_expenses,False,default_chart_template +610190,610190,Internet & hosting,account.data_account_type_expenses,False,default_chart_template +610200,610200,Mobiles,account.data_account_type_expenses,False,default_chart_template +610210,610210,Stationery,account.data_account_type_expenses,False,default_chart_template +610220,610220,Office consumables,account.data_account_type_expenses,False,default_chart_template +610230,610230,Postage and Carriage,account.data_account_type_expenses,False,default_chart_template +610240,610240,Books,account.data_account_type_expenses,False,default_chart_template +610250,610250,Network costs,account.data_account_type_expenses,False,default_chart_template +610260,610260,Software expenses,account.data_account_type_expenses,False,default_chart_template +610270,610270,Other computer costs,account.data_account_type_expenses,False,default_chart_template +610280,610280,Recruitment fees,account.data_account_type_expenses,False,default_chart_template +610290,610290,Other admin expenses,account.data_account_type_expenses,False,default_chart_template +610300,610300,Accounting,account.data_account_type_expenses,False,default_chart_template +610310,610310,Auditing,account.data_account_type_expenses,False,default_chart_template +610320,610320,Consultancy,account.data_account_type_expenses,False,default_chart_template +610330,610330,Legal and professional charges,account.data_account_type_expenses,False,default_chart_template +610340,610340,Exchange gains/losses,account.data_account_type_expenses,False,default_chart_template +610350,610350,Other sundry expenses,account.data_account_type_expenses,False,default_chart_template +610360,610360,Bad debts,account.data_account_type_expenses,False,default_chart_template +610370,610370,Interest paid,account.data_account_type_expenses,False,default_chart_template +610380,610380,Bank Charges,account.data_account_type_expenses,False,default_chart_template +610390,610390,Donations,account.data_account_type_expenses,False,default_chart_template +610400,610400,Entertaining,account.data_account_type_expenses,False,default_chart_template +610410,610410,Insurance,account.data_account_type_expenses,False,default_chart_template +610420,610420,Travel and subsistence,account.data_account_type_expenses,False,default_chart_template +610430,610430,Corporation tax expense,account.data_account_type_expenses,False,default_chart_template +610440,610440,Foreign Exchange Gains/Losses,account.data_account_type_expenses,False,default_chart_template +610450,610450,Price Differences Control Account,account.data_account_type_expenses,False,default_chart_template +610460,610460,Cash Register Gains/Losses,account.data_account_type_expenses,False,default_chart_template +620010,620010,Software Depreciation,account.data_account_type_depreciation,False,default_chart_template +620020,620020,Patents & Trademarks Depreciation,account.data_account_type_depreciation,False,default_chart_template +620030,620030,Fixtures and fittings Depreciation,account.data_account_type_depreciation,False,default_chart_template +620040,620040,Land and buildings Depreciation,account.data_account_type_depreciation,False,default_chart_template +620050,620050,Motor vehicles Depreciation,account.data_account_type_depreciation,False,default_chart_template +620060,620060,Office equipment (inc computer equipment) Depreciation,account.data_account_type_depreciation,False,default_chart_template +620070,620070,Plant and machinery Depreciation,account.data_account_type_depreciation,False,default_chart_template \ No newline at end of file diff --git a/addons/l10n_za/data/account.tax.group.csv b/addons/l10n_za/data/account.tax.group.csv new file mode 100644 index 00000000..ec35d114 --- /dev/null +++ b/addons/l10n_za/data/account.tax.group.csv @@ -0,0 +1,3 @@ +id,name +tax_group_0,VAT 0% +tax_group_1,VAT 15% diff --git a/addons/l10n_za/data/account_chart_template_configure_data.xml b/addons/l10n_za/data/account_chart_template_configure_data.xml new file mode 100644 index 00000000..b4579c80 --- /dev/null +++ b/addons/l10n_za/data/account_chart_template_configure_data.xml @@ -0,0 +1,8 @@ + + + + + + + + diff --git a/addons/l10n_za/data/account_chart_template_data.xml b/addons/l10n_za/data/account_chart_template_data.xml new file mode 100644 index 00000000..4925dbff --- /dev/null +++ b/addons/l10n_za/data/account_chart_template_data.xml @@ -0,0 +1,15 @@ + + + + + + + South African Tax and Account Chart Template (by Paradigm Digital) + 1200 + 1250 + 1010 + 6 + + + + diff --git a/addons/l10n_za/data/account_chart_template_post_data.xml b/addons/l10n_za/data/account_chart_template_post_data.xml new file mode 100644 index 00000000..ed453b83 --- /dev/null +++ b/addons/l10n_za/data/account_chart_template_post_data.xml @@ -0,0 +1,18 @@ + + + + + + + + + + + + + + + + + + diff --git a/addons/l10n_za/data/account_tax_report_data.xml b/addons/l10n_za/data/account_tax_report_data.xml new file mode 100644 index 00000000..0eb16ed5 --- /dev/null +++ b/addons/l10n_za/data/account_tax_report_data.xml @@ -0,0 +1,253 @@ + + + + + Tax Report + + + + + [20] VAT PAYABLE/REFUNDABLE (Total A - Total B) + (VAT4 + VAT4A + (SEC6 * 60/100 + SEC7) + VAT11 + VAT12) - (VAT14 + VAT14A + VAT15 + VAT16 + VAT17 + VAT18) + + + + + + [13] Total A: TOTAL OUTPUT TAX (4 + 4A + 9 + 11 + 12) + + + VAT4 + VAT4A + (SEC6 * 60/100 + SEC7) + VAT11 + VAT12 + + + + + [19] Total B: TOTAL INPUT TAX (14 + 14A + 15 + 16 + 17 + 18) + + + VAT14 + VAT14A + VAT15 + VAT16 + VAT17 + VAT18 + + + + + [1] Standard Rate (Excluding Capital goods and/or services and accomodation) + [1] Standard Rate (Excluding Capital goods and/or services and accomodation) + VAT1 + + + + + + + [4] x 15/ (100 + 15) + [4] x 15/ (100 + 15) + VAT4 + + + + + + + [1A] Standard Rate (Only Capital goods and/or services) + [1A] Standard Rate (Only Capital goods and/or services) + VAT1A + + + + + + + [4A] x 15/ (100 + 15) + [4A] x 15/ (100 + 15) + VAT4A + + + + + + + [2] Zero Rate (excluding goods exported) + [2] Zero Rate (excluding goods exported) + VAT2 + + + + + + + [2A] Zero Rate (Only goods exported) + [2A] Zero Rate (Only goods exported) + VAT2A + + + + + + + [3] Exempt and Non supplies + [3] Exempt and Non supplies + VAT3 + + + + + + + [5] Accomodation exceeding 28 days + [5] Accomodation exceeding 28 days + VAT5 + + + + + + + [6] x 60% + + + VAT5 * 60 / 100 + + + + + [7] Accomodation under 28 days + [7] Accomodation under 28 days + VAT7 + + + + + + + [8] Total (6 + 7) + + + (VAT5 * 60 / 100) + VAT7 + + + + + [9] x 15 / (100 ??) + + + SEC6 * 60/100 + SEC7 + + + + + VAT on Accomodation exceeding 28 days + VAT on Accomodation exceeding 28 days + SEC6 + + + + + + + VAT on Accomodation under 28 days + VAT on Accomodation under 28 days + SEC7 + + + + + + + [10] Change in use and export of second-hand goods + + + VAT10a + VAT11 + + + + + [10] Base Amount: Change in use and export of second-hand goods + [10] Change in use and export of second-hand goods + VAT10a + + + + + + + [11] x 15 / (100 + 15) + [11] x 15 / (100 + 15) + VAT11 + + + + + + + [12] Other and imported services + [12] Other and imported services + VAT12 + + + + + + + [14] Capital Goods and/or services supplied to you + [14] Capital Goods and/or services supplied to you + VAT14 + + + + + + + [14A] Capital Goods imported by you + [14A] Capital Goods imported by you + VAT14A + + + + + + + [15] Other goods and/or services supplied to you (not Capital Goods) + [15] Other goods and/or services supplied to you (not Capital Goods) + VAT15 + + + + + + + [15A] Other goods imported by you (not Capital Goods) + [15A] Other goods imported by you (not Capital Goods) + VAT15A + + + + + + + [16] Change in Use + [16] Change in Use + VAT16 + + + + + + + [17] Bad Debts + [17] Bad Debts + VAT17 + + + + + + + [18] Other + [18] Other + VAT18 + + + + + + diff --git a/addons/l10n_za/data/account_tax_template_data.xml b/addons/l10n_za/data/account_tax_template_data.xml new file mode 100644 index 00000000..8c1622a2 --- /dev/null +++ b/addons/l10n_za/data/account_tax_template_data.xml @@ -0,0 +1,552 @@ + + + + + 15% + + sale + Standard Rate + percent + 15 + + + + + + + 15% + + sale + Standard Rate (Capital Goods) + percent + 15 + + + + + + + 0% + + sale + Zero Rate + percent + 0 + + + + + + + 0% + + sale + Zero Rate Exports + percent + 0 + + + + + + + 0% + + sale + Exempt and Non-Supplies + percent + 0 + + + + + + + 15% + + sale + Accommodation (28+ days) + percent + 15 + + + + + + + 15% + + sale + Accommodation (Under 28 days) + percent + 15 + + + + + + + 15% + + sale + Export of Second-hand Goods/ Change in Use + percent + 15 + + + + + + + 15% + + sale + VAT Adjustments and Manual VAT + percent + 15 + + + + + + + 15% + + purchase + Standard Rate + percent + 15 + + + + + + + 15% + + purchase + Standard Rate (Capital Goods) + percent + 15 + + + + + + + 15% + + purchase + Capital Goods Imported + percent + 15 + + + + + + + 15% + + purchase + Goods and Services Imported + percent + 15 + + + + + + + 15% + + purchase + Change in Use + percent + 15 + + + + + + + 15% + + purchase + Bad Debts + percent + 15 + + + + + + + 15% + + purchase + Other Adjustments + percent + 15 + + + + + + -- cgit v1.2.3