[IMP] l10n_il: add tags and tax report

This way the PCN874 report is already there.
Existing databases will need to relink the taxes
with the report however.

closes odoo/odoo#60293

X-original-commit: 6963f58d1c23065eec440d5be23c93f73c24b3bd
Signed-off-by: Josse Colpaert <jco@openerp.com>

7 files changed, 395 insertions, 6 deletions

diff --git a/addons/l10n_il/__manifest__.py b/addons/l10n_il/__manifest__.py
index f7f4c6e3bd7..de5bfe60972 100644
--- a/addons/l10n_il/__manifest__.py
+++ b/addons/l10n_il/__manifest__.py
@@ -9,17 +9,21 @@
 This is the latest basic Israelian localisation necessary to run Odoo in Israel:
 ================================================================================
 
-This module consists:
- - Generic Israelian chart of accounts
- - Israelian taxes
+This module consists of:
+ - Generic Israel Chart of Accounts
+ - Taxes and tax report
+ - Fiscal position for Palestina
  """,
     'website': 'http://www.odoo.com/accounting',
     'depends': ['account'],
     'data': [
         'data/account_chart_template_data.xml',
+        'data/account_account_tag.xml',
         'data/account.account.template.csv',
         'data/account_data.xml',
+        'data/account_tax_report_data.xml',
         'data/account_tax_template_data.xml',
+        'data/fiscal_templates_data.xml',
         'data/account_chart_template_post_data.xml',
         'data/account_chart_template_configure_data.xml',
     ],
diff --git a/addons/l10n_il/data/account.account.template.csv b/addons/l10n_il/data/account.account.template.csv
index 34f3da81ab3..49e90e7a977 100644
--- a/addons/l10n_il/data/account.account.template.csv
+++ b/addons/l10n_il/data/account.account.template.csv
@@ -37,9 +37,9 @@ il_account_111000,111000,Current Liabilities,account.data_account_type_current_l
 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,,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,,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_current_liabilities,TRUE,,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
@@ -90,4 +90,4 @@ il_account_300100,300100,Capital,account.data_account_type_equity,FALSE,,il_char
 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,,il_chart_template
+il_account_300200,300200,Dividends,account.data_account_type_equity,FALSE,account_tag_dividend_account,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 00000000000..da95f2b8b41
--- /dev/null
+++ b/addons/l10n_il/data/account_account_tag.xml
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <record id="account_tag_retention_tax_vendor_account" model="account.account.tag">
+        <field name="name">Withholding Vendor Tax Account</field>
+    </record>
+
+	<record id="account_tag_dividend_account" model="account.account.tag">
+        <field name="name">Dividend Account</field>
+    </record>
+
+    <record id="account_tag_retention_tax_dividend_account" model="account.account.tag">
+        <field name="name">Withholding Dividend Tax Account</field>
+    </record>
+</odoo>
\ No newline at end of file
diff --git a/addons/l10n_il/data/account_data.xml b/addons/l10n_il/data/account_data.xml
index c8220003a99..da98a1c645c 100644
--- a/addons/l10n_il/data/account_data.xml
+++ b/addons/l10n_il/data/account_data.xml
@@ -13,4 +13,7 @@
         <field name="name">VAT exempt</field>
     </record>
 
+    <record id="tax_group_retention_purchase" model="account.tax.group">
+        <field name="name">Withholding purchase</field>
+    </record>
 </odoo>
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 00000000000..64c00ba17e0
--- /dev/null
+++ b/addons/l10n_il/data/account_tax_report_data.xml
@@ -0,0 +1,133 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <record id="vat_report" model="account.tax.report">
+        <field name="name">VAT Report (PCN874)</field>
+        <field name="country_id" ref="base.il"/>
+    </record>
+
+    <!-- SALES lines -->
+
+    <record id="account_tax_report_line_out_base_title" model="account.tax.report.line">
+        <field name="name">VAT SALES (BASE)</field>
+        <field name="sequence">1</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_out_base" model="account.tax.report.line">
+        <field name="name">VAT SALES (BASE)</field>
+        <field name="tag_name">VAT SALES (BASE)</field>
+        <field name="code">ILTAX_OUT_BASE</field>
+        <field name="sequence">1</field>
+        <field name="parent_id" ref="account_tax_report_line_out_base_title"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+	<record id="account_tax_report_line_vat_sales_tax" model="account.tax.report.line">
+        <field name="name">VAT SALES (TAX)</field>
+        <field name="formula">ILTAX_OUT_BALANCE_00+ILTAX_OUT_BALANCE_PA</field>
+        <field name="code">ILTAX_OUT_BALANCE</field>
+        <field name="sequence">2</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_out_balance" model="account.tax.report.line">
+        <field name="name">VAT Sales</field>
+        <field name="tag_name">VAT Sales</field>
+        <field name="code">ILTAX_OUT_BALANCE_00</field>
+        <field name="sequence">21</field>
+        <field name="parent_id" ref="account_tax_report_line_vat_sales_tax"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_out_balance_pa" model="account.tax.report.line">
+        <field name="name">VAT PA Sales</field>
+        <field name="tag_name">VAT PA Sales</field>
+        <field name="code">ILTAX_OUT_BALANCE_PA</field>
+        <field name="sequence">22</field>
+        <field name="parent_id" ref="account_tax_report_line_vat_sales_tax"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_out_base_exempt_title" model="account.tax.report.line">
+        <field name="name">VAT Exempt Sales (BASE)</field>
+        <field name="sequence">3</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_out_base_exempt" model="account.tax.report.line">
+        <field name="name">VAT Exempt Sales (BASE)</field>
+        <field name="tag_name">VAT Exempt Sales (BASE)</field>
+        <field name="code">ILTAX_OUT_BASE_exempt</field>
+        <field name="sequence">3</field>
+        <field name="parent_id" ref="account_tax_report_line_out_base_exempt_title"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <!-- PURCHASE lines -->
+    <record id="account_tax_report_line_in_balance" model="account.tax.report.line">
+        <field name="name">VAT INPUTS (TAX)</field>
+        <field name="formula">ILTAX_IN_BALANCE_17+ILTAX_IN_BALANCE_2_3+ILTAX_IN_BALANCE_1_4+ILTAX_IN_BALANCE_PA</field>
+        <field name="code">ILTAX_IN_BALANCE</field>
+        <field name="sequence">5</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+	<record id="account_tax_report_line_in_balance_17" model="account.tax.report.line">
+        <field name="name">VAT Inputs 17%</field>
+        <field name="tag_name">VAT Inputs 17%</field>
+        <field name="code">ILTAX_IN_BALANCE_17</field>
+        <field name="sequence">51</field>
+        <field name="parent_id" ref="account_tax_report_line_in_balance"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_in_balance_pa_16" model="account.tax.report.line">
+        <field name="name">VAT Inputs PA 16%</field>
+        <field name="tag_name">VAT Inputs PA 16%</field>
+        <field name="code">ILTAX_IN_BALANCE_PA</field>
+        <field name="sequence">52</field>
+        <field name="parent_id" ref="account_tax_report_line_in_balance"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_in_balance_2_3" model="account.tax.report.line">
+        <field name="name">VAT Inputs 2/3</field>
+        <field name="tag_name">VAT Inputs 2/3</field>
+        <field name="code">ILTAX_IN_BALANCE_2_3</field>
+        <field name="sequence">53</field>
+        <field name="parent_id" ref="account_tax_report_line_in_balance"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_in_balance_1_4" model="account.tax.report.line">
+        <field name="name">VAT Inputs 1/4</field>
+        <field name="tag_name">VAT Inputs 1/4</field>
+        <field name="code">ILTAX_IN_BALANCE_1_4</field>
+        <field name="sequence">54</field>
+        <field name="parent_id" ref="account_tax_report_line_in_balance"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_vat_in_fa_title" model="account.tax.report.line">
+        <field name="name">VAT INPUTS (fixed assets)</field>
+        <field name="sequence">6</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_vat_in_fa" model="account.tax.report.line">
+        <field name="name">VAT INPUTS (fixed assets)</field>
+        <field name="tag_name">VAT INPUTS (fixed assets)</field>
+        <field name="code">ILTAX_VAT_IN_FA</field>
+        <field name="sequence">6</field>
+        <field name="parent_id" ref="account_tax_report_line_vat_in_fa_title"/>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+
+    <record id="account_tax_report_line_vat_due" model="account.tax.report.line">
+        <field name="name">VAT DUE</field>
+        <field name="code">ILTAX_VAT_DUE</field>
+        <field name="formula">(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</field>
+        <field name="sequence">7</field>
+        <field name="report_id" ref="vat_report"/>
+    </record>
+</odoo>
diff --git a/addons/l10n_il/data/account_tax_template_data.xml b/addons/l10n_il/data/account_tax_template_data.xml
index b66020e1d34..08d5004e86b 100644
--- a/addons/l10n_il/data/account_tax_template_data.xml
+++ b/addons/l10n_il/data/account_tax_template_data.xml
@@ -15,22 +15,26 @@
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'plus_report_line_ids': [ref('account_tax_report_line_out_base')]
             }),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_111110'),
+                'plus_report_line_ids': [ref('account_tax_report_line_out_balance')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'minus_report_line_ids': [ref('account_tax_report_line_out_base')]
             }),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_111110'),
+                'minus_report_line_ids': [ref('account_tax_report_line_out_balance')]
             }),
         ]"/>
     </record>
@@ -48,22 +52,26 @@
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'plus_report_line_ids': [ref('account_tax_report_line_out_base')]
             }),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_111120'),
+                'plus_report_line_ids': [ref('account_tax_report_line_out_balance_pa')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'minus_report_line_ids': [ref('account_tax_report_line_out_base')]
             }),
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_111120'),
+                'minus_report_line_ids': [ref('account_tax_report_line_out_balance_pa')]
             }),
         ]"/>
     </record>
@@ -83,6 +91,7 @@
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'plus_report_line_ids': [ref('account_tax_report_line_out_base_exempt')]
             }),
             (0,0, {
                 'factor_percent': 100,
@@ -94,6 +103,7 @@
             (0,0, {
                 'factor_percent': 100,
                 'repartition_type': 'base',
+                'minus_report_line_ids': [ref('account_tax_report_line_out_base_exempt')]
             }),
             (0,0, {
                 'factor_percent': 100,
@@ -103,6 +113,41 @@
         ]"/>
     </record>
 
+    <record id="il_vat_self_inv_sale" model="account.tax.template">
+        <field name="sequence">10</field>
+        <field name="description">17%</field>
+        <field name="name">Self Invoice 17%</field>
+        <field name="amount">17</field>
+        <field name="amount_type">percent</field>
+        <field name="type_tax_use">sale</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="tax_group_id" ref="tax_group_vat_17"/>
+        <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+                'plus_report_line_ids': [ref('account_tax_report_line_out_base')]
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'plus_report_line_ids': [ref('account_tax_report_line_out_balance')],
+            }),
+        ]"/>
+        <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+                'minus_report_line_ids': [ref('account_tax_report_line_out_base')],
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'minus_report_line_ids': [ref('account_tax_report_line_out_balance')]
+            }),
+        ]"/>
+    </record>
+
     <!-- Purchase Taxes -->
     <record id="il_vat_inputs_17" model="account.tax.template">
         <field name="sequence">2</field>
@@ -113,6 +158,7 @@
         <field name="type_tax_use">purchase</field>
         <field name="chart_template_id" ref="il_chart_template"/>
         <field name="tax_group_id" ref="tax_group_vat_17"/>
+        <field name="include_base_amount" eval="True"/>
         <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
             (0,0, {
                 'factor_percent': 100,
@@ -122,6 +168,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'plus_report_line_ids': [ref('account_tax_report_line_in_balance_17')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
@@ -133,6 +180,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'minus_report_line_ids': [ref('account_tax_report_line_in_balance_17')]
             }),
         ]"/>
     </record>
@@ -155,6 +203,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101830'),
+                'plus_report_line_ids': [ref('account_tax_report_line_in_balance_pa_16')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
@@ -166,6 +215,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101830'),
+                'minus_report_line_ids': [ref('account_tax_report_line_in_balance_pa_16')]
             }),
         ]"/>
     </record>
@@ -189,6 +239,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'plus_report_line_ids':[ ref('account_tax_report_line_in_balance_2_3')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
@@ -200,6 +251,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'minus_report_line_ids':[ ref('account_tax_report_line_in_balance_2_3')]
             }),
         ]"/>
     </record>
@@ -223,6 +275,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'plus_report_line_ids':[ ref('account_tax_report_line_in_balance_1_4')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
@@ -234,6 +287,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101800'),
+                'minus_report_line_ids':[ ref('account_tax_report_line_in_balance_1_4')]
             }),
         ]"/>
     </record>
@@ -256,6 +310,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101810'),
+                'plus_report_line_ids':[ref('account_tax_report_line_vat_in_fa')]
             }),
         ]"/>
         <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
@@ -267,6 +322,7 @@
                 'factor_percent': 100,
                 'repartition_type': 'tax',
                 'account_id': ref('il_account_101810'),
+                'minus_report_line_ids':[ref('account_tax_report_line_vat_in_fa')]
             }),
         ]"/>
     </record>
@@ -302,4 +358,136 @@
         ]"/>
     </record>
 
+    <record id="il_vat_retention_10" model="account.tax.template">
+        <field name="sequence">13</field>
+        <field name="description">Withholding 10%</field>
+        <field name="name">Withholding 10%</field>
+        <field name="amount">-10</field>
+        <field name="amount_type">percent</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="tax_group_id" ref="tax_group_retention_purchase"/>
+        <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111200'),
+            }),
+        ]"/>
+        <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111200'),
+            }),
+        ]"/>
+    </record>
+
+    <record id="il_vat_retention_35" model="account.tax.template">
+        <field name="sequence">14</field>
+        <field name="description">Withholding 35%</field>
+        <field name="name">Withholding 35%</field>
+        <field name="amount">-35</field>
+        <field name="amount_type">percent</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="tax_group_id" ref="tax_group_retention_purchase"/>
+        <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111200'),
+            }),
+        ]"/>
+        <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111200'),
+            }),
+        ]"/>
+    </record>
+
+    <record id="il_vat_retention_30" model="account.tax.template">
+        <field name="sequence">15</field>
+        <field name="description">Withholding 30%</field>
+        <field name="name">Withholding 30%</field>
+        <field name="amount">-30</field>
+        <field name="amount_type">percent</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="tax_group_id" ref="tax_group_retention_purchase"/>
+        <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111220'),
+            }),
+        ]"/>
+        <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111220'),
+            }),
+        ]"/>
+    </record>
+
+    <record id="il_vat_retention_25" model="account.tax.template">
+        <field name="sequence">16</field>
+        <field name="description">Withholding 25%</field>
+        <field name="name">Withholding 25%</field>
+        <field name="amount">-25</field>
+        <field name="amount_type">percent</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="tax_group_id" ref="tax_group_retention_purchase"/>
+        <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111220'),
+            }),
+        ]"/>
+        <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'base',
+            }),
+            (0,0, {
+                'factor_percent': 100,
+                'repartition_type': 'tax',
+                'account_id': ref('il_account_111220'),
+            }),
+        ]"/>
+    </record>
+
 </odoo>
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 00000000000..b4258d81823
--- /dev/null
+++ b/addons/l10n_il/data/fiscal_templates_data.xml
@@ -0,0 +1,47 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <!-- Israel keep standard taxes -->
+    <record id="account_fiscal_position_israel" model="account.fiscal.position.template">
+        <field name="name">Israel</field>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="country_id" ref="base.il"/>
+        <field name="auto_apply" eval="True"/>
+    </record>
+
+    <!-- Palestinian state -->
+    <record id="account_fiscal_position_palestinian_authority" model="account.fiscal.position.template">
+        <field name="name">Palestinian Authority (PA)</field>
+        <field name="auto_apply" eval="True"/>
+        <field name="country_id" ref="base.ps"/>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="auto_apply" eval="True"/>
+    </record>
+
+    <record id="account_fiscal_position_palestinian_authority_01" model="account.fiscal.position.tax.template">
+        <field name="tax_src_id" ref="il_vat_sales_17"/>
+        <field name="tax_dest_id" ref="il_vat_pa_sales_17"/>
+        <field name="position_id" ref="account_fiscal_position_palestinian_authority"/>
+    </record>
+
+    <record id="account_fiscal_position_palestinian_authority_02" model="account.fiscal.position.tax.template">
+        <field name="tax_src_id" ref="il_vat_inputs_17"/>
+        <field name="tax_dest_id" ref="il_vat_pa_purchase_16"/>
+        <field name="position_id" ref="account_fiscal_position_palestinian_authority"/>
+    </record>
+
+    <!-- Export -->
+    <record id="account_fiscal_position_export" model="account.fiscal.position.template">
+        <field name="name">Import / Export</field>
+        <field name="auto_apply" eval="True"/>
+        <field name="chart_template_id" ref="il_chart_template"/>
+        <field name="auto_apply" eval="True"/>
+    </record>
+
+    <record id="account_fiscal_position_export_01" model="account.fiscal.position.tax.template">
+        <field name="tax_src_id" ref="il_vat_sales_17"/>
+        <field name="tax_dest_id" ref="il_vat_sales_exempt"/>
+        <field name="position_id" ref="account_fiscal_position_export"/>
+    </record>
+
+
+</odoo>