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_il/data/account.account.template.csv | 89 ++++ addons/l10n_il/data/account_account_tag.xml | 14 + .../data/account_chart_template_configure_data.xml | 6 + .../l10n_il/data/account_chart_template_data.xml | 11 + .../data/account_chart_template_post_data.xml | 15 + addons/l10n_il/data/account_data.xml | 19 + addons/l10n_il/data/account_tax_report_data.xml | 133 ++++++ addons/l10n_il/data/account_tax_template_data.xml | 493 +++++++++++++++++++++ addons/l10n_il/data/fiscal_templates_data.xml | 47 ++ 9 files changed, 827 insertions(+) create mode 100644 addons/l10n_il/data/account.account.template.csv create mode 100644 addons/l10n_il/data/account_account_tag.xml create mode 100644 addons/l10n_il/data/account_chart_template_configure_data.xml create mode 100644 addons/l10n_il/data/account_chart_template_data.xml create mode 100644 addons/l10n_il/data/account_chart_template_post_data.xml create mode 100644 addons/l10n_il/data/account_data.xml create mode 100644 addons/l10n_il/data/account_tax_report_data.xml create mode 100644 addons/l10n_il/data/account_tax_template_data.xml create mode 100644 addons/l10n_il/data/fiscal_templates_data.xml (limited to 'addons/l10n_il/data') diff --git a/addons/l10n_il/data/account.account.template.csv b/addons/l10n_il/data/account.account.template.csv new file mode 100644 index 00000000..ecbe5101 --- /dev/null +++ b/addons/l10n_il/data/account.account.template.csv @@ -0,0 +1,89 @@ +id,code,name,user_type_id/id,reconcile,tag_ids/id,chart_template_id:id +il_account_100100,100100,Land and buildings,account.data_account_type_fixed_assets,FALSE,,il_chart_template +il_account_100200,100200,Machinery and equipment,account.data_account_type_fixed_assets,FALSE,,il_chart_template +il_account_100300,100300,Vehicles,account.data_account_type_fixed_assets,FALSE,,il_chart_template +il_account_100400,100400,Other property,account.data_account_type_fixed_assets,FALSE,,il_chart_template +il_account_101110,101110,Stock Valuation account,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101120,101120,Stock Interim Account (Received),account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101130,101130,Stock Interim Account (Delivered),account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101140,101140,Inventory - Raw materials,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101150,101150,Inventory - Work in progress,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101160,101160,Inventory - Finished goods,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101200,101200,Account Receivable,account.data_account_type_receivable,TRUE,,il_chart_template +il_account_101201,101201,Account Receivable(POS),account.data_account_type_receivable,TRUE,,il_chart_template +il_account_101250,101250,Allowance for credit losses,account.data_account_type_current_assets,TRUE,,il_chart_template +il_account_101300,101300,Income tax withheld - customers,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101410,101410,Bank Deposit,account.data_account_type_liquidity,FALSE,,il_chart_template +il_account_101420,101420,Cheques,account.data_account_type_liquidity,FALSE,,il_chart_template +il_account_101430,101430,Financial Assets,account.data_account_type_liquidity,FALSE,,il_chart_template +il_account_101440,101440,Petty Cash,account.data_account_type_liquidity,FALSE,,il_chart_template +il_account_101800,101800,VAT - Inputs,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101810,101810,VAT - Fixed Assets,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101820,101820,VAT - Import Transactions,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_101830,101830,VAT - PA Import Transactions,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_102110,102110,Land and buildings depreciation,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_102120,102120,Machinery and equipment depreciation,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_102130,102130,Vehicles depreciation,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_102140,102140,Other property depreciation,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_102150,102150,Accumulated depreciation,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_102200,102200,Intangible Assets,account.data_account_type_non_current_assets,FALSE,,il_chart_template +il_account_103000,103000,Prepayments,account.data_account_type_current_assets,FALSE,,il_chart_template +il_account_111000,111000,Current Liabilities,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111100,111100,Account Payable,account.data_account_type_payable,TRUE,,il_chart_template +il_account_111110,111110,VAT Sales,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111120,111120,VAT PA Sales,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111200,111200,Income tax withheld - vendors,account.data_account_type_current_liabilities,FALSE,account_tag_retention_tax_vendor_account,il_chart_template +il_account_111210,111210,Income tax withheld - employees,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111220,111220,Income tax withheld - dividends,account.data_account_type_current_liabilities,FALSE,account_tag_retention_tax_dividend_account,il_chart_template +il_account_111300,111300,Reserve and Profit/Loss Account,account.data_account_type_equity,FALSE,,il_chart_template +il_account_111400,111400,Credit cards,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111450,111450,Short term loans,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_111460,111460,Interest Payable,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111500,111500,Employees wages,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111550,111550,Employees Benefits,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111600,111600,Deferred Revenue,account.data_account_type_non_current_liabilities,FALSE,,il_chart_template +il_account_111650,111650,Advances,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111660,111660,Other Payable,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111700,111700,Income Tax,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111710,111710,National Insurance,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111720,111720,VAT due,account.data_account_type_current_liabilities,TRUE,,il_chart_template +il_account_111730,111730,Deferred Taxes,account.data_account_type_current_liabilities,FALSE,,il_chart_template +il_account_112000,112000,Non-current Liabilities,account.data_account_type_non_current_liabilities,FALSE,,il_chart_template +il_account_112100,112100,Long Term loans,account.data_account_type_non_current_liabilities,FALSE,,il_chart_template +il_account_112150,112150,Provisions,account.data_account_type_non_current_liabilities,FALSE,,il_chart_template +il_account_200000,200000,Product Sales,account.data_account_type_revenue,FALSE,account.account_tag_operating,il_chart_template +il_account_200100,200100,Services Sales,account.data_account_type_revenue,FALSE,account.account_tag_operating,il_chart_template +il_account_200200,200200,Other Income,account.data_account_type_other_income,FALSE,account.account_tag_operating,il_chart_template +il_account_200300,200300,Interest Income,account.data_account_type_other_income,FALSE,account.account_tag_operating,il_chart_template +il_account_201000,201000,Foreign Exchange Gain,account.data_account_type_other_income,FALSE,account.account_tag_financing,il_chart_template +il_account_202000,202000,Other Expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_202100,202100,Foreign Exchange Loss,account.data_account_type_expenses,FALSE,account.account_tag_financing,il_chart_template +il_account_202200,202200,Interest Expenses,account.data_account_type_expenses,FALSE,account.account_tag_financing,il_chart_template +il_account_202300,202300,Donations,account.data_account_type_expenses,FALSE,,il_chart_template +il_account_202400,202400,Fines,account.data_account_type_expenses,FALSE,,il_chart_template +il_account_210000,210000,Cost of Goods Sold,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_211000,211000,Cost of Services Sold,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_212000,212000,Customer discounts,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_212100,212100,Salary Expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_212200,212200,Purchase of Equipments,account.data_account_type_expenses,FALSE,account.account_tag_investing,il_chart_template +il_account_212300,212300,Bank Fees,account.data_account_type_expenses,FALSE,account.account_tag_financing,il_chart_template +il_account_213000,213000,Customer returns,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_214000,214000,Vendor returns,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_215000,215000,Vendor discounts,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_216000,216000,Good's Shrinkage,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_217000,217000,Lost goods,account.data_account_type_direct_costs,FALSE,account.account_tag_operating,il_chart_template +il_account_220000,220000,G&A Expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220100,220100,Rent Expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220200,220200,Communication expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220300,220300,Transportation expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220400,220400,Depretiation expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220500,220500,Credit provision expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220600,220600,Sales and marketing expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220700,220700,Other non-operating expenses,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_220800,220800,Bad debts expense,account.data_account_type_expenses,FALSE,account.account_tag_operating,il_chart_template +il_account_300100,300100,Capital,account.data_account_type_equity,FALSE,,il_chart_template +il_account_300110,300110,Ordinary Shares,account.data_account_type_equity,FALSE,,il_chart_template +il_account_300120,300120,Preferred Shares,account.data_account_type_equity,FALSE,,il_chart_template +il_account_300130,300130,Shares Premium,account.data_account_type_equity,FALSE,,il_chart_template +il_account_300200,300200,Dividends,account.data_account_type_equity,FALSE,account_tag_dividend_account,il_chart_template +il_account_300270,300270,current year earnings,account.data_unaffected_earnings,FALSE,,il_chart_template diff --git a/addons/l10n_il/data/account_account_tag.xml b/addons/l10n_il/data/account_account_tag.xml new file mode 100644 index 00000000..da95f2b8 --- /dev/null +++ b/addons/l10n_il/data/account_account_tag.xml @@ -0,0 +1,14 @@ + + + + Withholding Vendor Tax Account + + + + Dividend Account + + + + Withholding Dividend Tax Account + + \ No newline at end of file diff --git a/addons/l10n_il/data/account_chart_template_configure_data.xml b/addons/l10n_il/data/account_chart_template_configure_data.xml new file mode 100644 index 00000000..1fccdf8f --- /dev/null +++ b/addons/l10n_il/data/account_chart_template_configure_data.xml @@ -0,0 +1,6 @@ + + + + + + diff --git a/addons/l10n_il/data/account_chart_template_data.xml b/addons/l10n_il/data/account_chart_template_data.xml new file mode 100644 index 00000000..2837aec8 --- /dev/null +++ b/addons/l10n_il/data/account_chart_template_data.xml @@ -0,0 +1,11 @@ + + + + Israel - Chart of Accounts + 1014 + 1015 + 1017 + 6 + + + diff --git a/addons/l10n_il/data/account_chart_template_post_data.xml b/addons/l10n_il/data/account_chart_template_post_data.xml new file mode 100644 index 00000000..4d830efb --- /dev/null +++ b/addons/l10n_il/data/account_chart_template_post_data.xml @@ -0,0 +1,15 @@ + + + + + + + + + + + + + + + diff --git a/addons/l10n_il/data/account_data.xml b/addons/l10n_il/data/account_data.xml new file mode 100644 index 00000000..da98a1c6 --- /dev/null +++ b/addons/l10n_il/data/account_data.xml @@ -0,0 +1,19 @@ + + + + + VAT 16% + + + + VAT 17% + + + + VAT exempt + + + + Withholding purchase + + diff --git a/addons/l10n_il/data/account_tax_report_data.xml b/addons/l10n_il/data/account_tax_report_data.xml new file mode 100644 index 00000000..64c00ba1 --- /dev/null +++ b/addons/l10n_il/data/account_tax_report_data.xml @@ -0,0 +1,133 @@ + + + + VAT Report (PCN874) + + + + + + + VAT SALES (BASE) + 1 + + + + + VAT SALES (BASE) + VAT SALES (BASE) + ILTAX_OUT_BASE + 1 + + + + + + VAT SALES (TAX) + ILTAX_OUT_BALANCE_00+ILTAX_OUT_BALANCE_PA + ILTAX_OUT_BALANCE + 2 + + + + + VAT Sales + VAT Sales + ILTAX_OUT_BALANCE_00 + 21 + + + + + + VAT PA Sales + VAT PA Sales + ILTAX_OUT_BALANCE_PA + 22 + + + + + + VAT Exempt Sales (BASE) + 3 + + + + + VAT Exempt Sales (BASE) + VAT Exempt Sales (BASE) + ILTAX_OUT_BASE_exempt + 3 + + + + + + + VAT INPUTS (TAX) + ILTAX_IN_BALANCE_17+ILTAX_IN_BALANCE_2_3+ILTAX_IN_BALANCE_1_4+ILTAX_IN_BALANCE_PA + ILTAX_IN_BALANCE + 5 + + + + + VAT Inputs 17% + VAT Inputs 17% + ILTAX_IN_BALANCE_17 + 51 + + + + + + VAT Inputs PA 16% + VAT Inputs PA 16% + ILTAX_IN_BALANCE_PA + 52 + + + + + + VAT Inputs 2/3 + VAT Inputs 2/3 + ILTAX_IN_BALANCE_2_3 + 53 + + + + + + VAT Inputs 1/4 + VAT Inputs 1/4 + ILTAX_IN_BALANCE_1_4 + 54 + + + + + + VAT INPUTS (fixed assets) + 6 + + + + + VAT INPUTS (fixed assets) + VAT INPUTS (fixed assets) + ILTAX_VAT_IN_FA + 6 + + + + + + VAT DUE + ILTAX_VAT_DUE + (ILTAX_OUT_BALANCE_00 + ILTAX_OUT_BALANCE_PA) - (ILTAX_IN_BALANCE_17 + ILTAX_IN_BALANCE_2_3 + ILTAX_IN_BALANCE_1_4 + ILTAX_IN_BALANCE_PA) - ILTAX_VAT_IN_FA + 7 + + + diff --git a/addons/l10n_il/data/account_tax_template_data.xml b/addons/l10n_il/data/account_tax_template_data.xml new file mode 100644 index 00000000..08d5004e --- /dev/null +++ b/addons/l10n_il/data/account_tax_template_data.xml @@ -0,0 +1,493 @@ + + + + + + 1 + 17% + VAT Sales + 17 + percent + sale + + + + + + + + 8 + 17% + VAT PA Sales + 17 + percent + sale + + + + + + + + 9 + 0% + VAT exempt + + 0 + percent + sale + + + 1 + + + + + + 10 + 17% + Self Invoice 17% + 17 + percent + sale + + + + + + + + + 2 + 17% + VAT inputs + 17 + percent + purchase + + + + + + + + + 3 + 16% + VAT 16% (PA) + 16 + percent + purchase + + + + + + + + 4 + 17% + VAT Inputs 2/3 + + 9.6866 + division + purchase + + + + + + + + 5 + 17% + VAT Inputs 1/4 + + 3.6325 + division + purchase + + + + + + + + 6 + 17% + VAT inputs for fixed assets + 17 + percent + purchase + + + + + + + + 7 + 0% + VAT exempt + 0 + percent + purchase + + + + + + + + 13 + Withholding 10% + Withholding 10% + -10 + percent + purchase + + + + + + + + 14 + Withholding 35% + Withholding 35% + -35 + percent + purchase + + + + + + + + 15 + Withholding 30% + Withholding 30% + -30 + percent + purchase + + + + + + + + 16 + Withholding 25% + Withholding 25% + -25 + percent + purchase + + + + + + + diff --git a/addons/l10n_il/data/fiscal_templates_data.xml b/addons/l10n_il/data/fiscal_templates_data.xml new file mode 100644 index 00000000..b4258d81 --- /dev/null +++ b/addons/l10n_il/data/fiscal_templates_data.xml @@ -0,0 +1,47 @@ + + + + + Israel + + + + + + + + Palestinian Authority (PA) + + + + + + + + + + + + + + + + + + + + + Import / Export + + + + + + + + + + + + + -- cgit v1.2.3