summaryrefslogtreecommitdiff
path: root/addons/l10n_nz/data
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2022-05-10 21:51:50 +0700
committerstephanchrst <stephanchrst@gmail.com>2022-05-10 21:51:50 +0700
commit3751379f1e9a4c215fb6eb898b4ccc67659b9ace (patch)
treea44932296ef4a9b71d5f010906253d8c53727726 /addons/l10n_nz/data
parent0a15094050bfde69a06d6eff798e9a8ddf2b8c21 (diff)
initial commit 2
Diffstat (limited to 'addons/l10n_nz/data')
-rw-r--r--addons/l10n_nz/data/account.account.template.csv98
-rw-r--r--addons/l10n_nz/data/account.tax.group.csv5
-rw-r--r--addons/l10n_nz/data/account_chart_template_configure_data.xml8
-rw-r--r--addons/l10n_nz/data/account_chart_template_data.xml15
-rw-r--r--addons/l10n_nz/data/account_fiscal_position_tax_template_data.xml31
-rw-r--r--addons/l10n_nz/data/account_tax_report_data.xml112
-rw-r--r--addons/l10n_nz/data/account_tax_template_data.xml304
-rw-r--r--addons/l10n_nz/data/l10n_nz_chart_data.xml16
-rw-r--r--addons/l10n_nz/data/res_currency_data.xml26
9 files changed, 615 insertions, 0 deletions
diff --git a/addons/l10n_nz/data/account.account.template.csv b/addons/l10n_nz/data/account.account.template.csv
new file mode 100644
index 00000000..514fb1ca
--- /dev/null
+++ b/addons/l10n_nz/data/account.account.template.csv
@@ -0,0 +1,98 @@
+id,chart_template_id:id,code,name,user_type_id:id,reconcile
+nz_11110,l10n_nz.l10n_nz_chart_template,11110,Bank Account,account.data_account_type_liquidity,FALSE
+nz_11130,l10n_nz.l10n_nz_chart_template,11130,Petty Cash,account.data_account_type_liquidity,FALSE
+nz_11140,l10n_nz.l10n_nz_chart_template,11140,Cash Drawer,account.data_account_type_liquidity,FALSE
+nz_11180,l10n_nz.l10n_nz_chart_template,11180,Undeposited Funds,account.data_account_type_current_assets,TRUE
+nz_11190,l10n_nz.l10n_nz_chart_template,11190,Electronic Clearing Account,account.data_account_type_current_assets,TRUE
+nz_11200,l10n_nz.l10n_nz_chart_template,11200,Trade Debtors,account.data_account_type_receivable,TRUE
+nz_11210,l10n_nz.l10n_nz_chart_template,11210,Less Prov'n for Doubtful Debts,account.data_account_type_current_assets,FALSE
+nz_11220,l10n_nz.l10n_nz_chart_template,11220,Trade Debtors (PoS),account.data_account_type_receivable,TRUE
+nz_11310,l10n_nz.l10n_nz_chart_template,11310,Raw Materials,account.data_account_type_current_assets,FALSE
+nz_11320,l10n_nz.l10n_nz_chart_template,11320,Finished Goods,account.data_account_type_current_assets,FALSE
+nz_11330,l10n_nz.l10n_nz_chart_template,11330,Trading Stock on Hand,account.data_account_type_current_assets,FALSE
+nz_12100,l10n_nz.l10n_nz_chart_template,12100,Deposits Paid,account.data_account_type_prepayments,FALSE
+nz_12200,l10n_nz.l10n_nz_chart_template,12200,Prepaid Insurance,account.data_account_type_current_assets,FALSE
+nz_13110,l10n_nz.l10n_nz_chart_template,13110,Manufacturing Plant at Cost,account.data_account_type_fixed_assets,FALSE
+nz_13120,l10n_nz.l10n_nz_chart_template,13120,Manufac. Plant Accum Dep,account.data_account_type_fixed_assets,FALSE
+nz_13130,l10n_nz.l10n_nz_chart_template,13130,Manufacturing Equipment Cost,account.data_account_type_fixed_assets,FALSE
+nz_13140,l10n_nz.l10n_nz_chart_template,13140,Manufac. Equip Accum Dep,account.data_account_type_fixed_assets,FALSE
+nz_13210,l10n_nz.l10n_nz_chart_template,13210,Furniture & Fixtures at Cost,account.data_account_type_fixed_assets,FALSE
+nz_13220,l10n_nz.l10n_nz_chart_template,13220,Furniture & Fixtures Accum Dep,account.data_account_type_fixed_assets,FALSE
+nz_13310,l10n_nz.l10n_nz_chart_template,13310,Office Equip at Cost,account.data_account_type_fixed_assets,FALSE
+nz_13320,l10n_nz.l10n_nz_chart_template,13320,Office Equip Accum Dep,account.data_account_type_fixed_assets,FALSE
+nz_13410,l10n_nz.l10n_nz_chart_template,13410,Motor Vehicles at Cost,account.data_account_type_fixed_assets,FALSE
+nz_13420,l10n_nz.l10n_nz_chart_template,13420,Motor Vehicles Accum Dep,account.data_account_type_fixed_assets,FALSE
+nz_21110,l10n_nz.l10n_nz_chart_template,21110,Credit Card,account.data_account_type_current_liabilities,FALSE
+nz_21200,l10n_nz.l10n_nz_chart_template,21200,Trade Creditors,account.data_account_type_payable,TRUE
+nz_21210,l10n_nz.l10n_nz_chart_template,21210,A/P Accrual - Inventory,account.data_account_type_current_liabilities,FALSE
+nz_21310,l10n_nz.l10n_nz_chart_template,21310,GST Collected,account.data_account_type_current_liabilities,FALSE
+nz_21330,l10n_nz.l10n_nz_chart_template,21330,GST Paid,account.data_account_type_current_assets,FALSE
+nz_21350,l10n_nz.l10n_nz_chart_template,21350,Fuel Tax Credits Accrued,account.data_account_type_current_liabilities,FALSE
+nz_21360,l10n_nz.l10n_nz_chart_template,21360,Import Duty Payable,account.data_account_type_current_liabilities,FALSE
+nz_21370,l10n_nz.l10n_nz_chart_template,21370,Voluntary Withholdings Payable,account.data_account_type_current_liabilities,FALSE
+nz_21380,l10n_nz.l10n_nz_chart_template,21380,Tax Withholdings Payable,account.data_account_type_current_liabilities,FALSE
+nz_21410,l10n_nz.l10n_nz_chart_template,21410,Payroll Accruals Payable,account.data_account_type_current_liabilities,FALSE
+nz_21420,l10n_nz.l10n_nz_chart_template,21420,PAYG Withholding Payable,account.data_account_type_current_liabilities,FALSE
+nz_21600,l10n_nz.l10n_nz_chart_template,21600,Customer Deposits,account.data_account_type_current_liabilities,FALSE
+nz_21700,l10n_nz.l10n_nz_chart_template,21700,Other Current Liabilities,account.data_account_type_current_liabilities,FALSE
+nz_22100,l10n_nz.l10n_nz_chart_template,22100,Mortgages Payable,account.data_account_type_non_current_liabilities,FALSE
+nz_22200,l10n_nz.l10n_nz_chart_template,22200,Notes Payable,account.data_account_type_non_current_liabilities,FALSE
+nz_22300,l10n_nz.l10n_nz_chart_template,22300,Other Long Term Liabilities,account.data_account_type_non_current_liabilities,FALSE
+nz_31100,l10n_nz.l10n_nz_chart_template,31100,Capital Investment,account.data_account_type_equity,FALSE
+nz_31200,l10n_nz.l10n_nz_chart_template,31200,Capital Drawings,account.data_account_type_equity,FALSE
+nz_38000,l10n_nz.l10n_nz_chart_template,38000,Retained Earnings,account.data_account_type_equity,FALSE
+nz_39000,l10n_nz.l10n_nz_chart_template,39000,Current Year Earnings,account.data_unaffected_earnings,FALSE
+nz_39999,l10n_nz.l10n_nz_chart_template,39999,Historical Balancing,account.data_account_type_equity,FALSE
+nz_41110,l10n_nz.l10n_nz_chart_template,41110,Sales Product #1,account.data_account_type_revenue,FALSE
+nz_41120,l10n_nz.l10n_nz_chart_template,41120,Sales Product #2,account.data_account_type_revenue,FALSE
+nz_41130,l10n_nz.l10n_nz_chart_template,41130,Sales Product #3,account.data_account_type_revenue,FALSE
+nz_42000,l10n_nz.l10n_nz_chart_template,42000,Wholesale Sales,account.data_account_type_revenue,FALSE
+nz_43000,l10n_nz.l10n_nz_chart_template,43000,Consignment Sales,account.data_account_type_revenue,FALSE
+nz_44000,l10n_nz.l10n_nz_chart_template,44000,Freight Income,account.data_account_type_revenue,FALSE
+nz_45000,l10n_nz.l10n_nz_chart_template,45000,Late Fees Collected,account.data_account_type_other_income,FALSE
+nz_46000,l10n_nz.l10n_nz_chart_template,46000,Miscellaneous Income,account.data_account_type_other_income,FALSE
+nz_47000,l10n_nz.l10n_nz_chart_template,47000,Fuel Tax Credits,account.data_account_type_other_income,FALSE
+nz_51110,l10n_nz.l10n_nz_chart_template,51110,Cost of Goods Sold #1,account.data_account_type_direct_costs,FALSE
+nz_51120,l10n_nz.l10n_nz_chart_template,51120,Cost of Goods Sold # 2,account.data_account_type_direct_costs,FALSE
+nz_51130,l10n_nz.l10n_nz_chart_template,51130,Cost of Goods Sold # 3,account.data_account_type_direct_costs,FALSE
+nz_52000,l10n_nz.l10n_nz_chart_template,52000,Wholesale Cost of Sales,account.data_account_type_direct_costs,FALSE
+nz_53000,l10n_nz.l10n_nz_chart_template,53000,Consignment Cost of Sales,account.data_account_type_direct_costs,FALSE
+nz_54000,l10n_nz.l10n_nz_chart_template,54000,Wages for Production Labour,account.data_account_type_direct_costs,FALSE
+nz_55000,l10n_nz.l10n_nz_chart_template,55000,Materials & Supplies,account.data_account_type_direct_costs,FALSE
+nz_56000,l10n_nz.l10n_nz_chart_template,56000,Freight,account.data_account_type_direct_costs,FALSE
+nz_57000,l10n_nz.l10n_nz_chart_template,57000,Other Costs,account.data_account_type_direct_costs,FALSE
+nz_61000,l10n_nz.l10n_nz_chart_template,61000,Advertising,account.data_account_type_expenses,FALSE
+nz_61200,l10n_nz.l10n_nz_chart_template,61200,Car & Truck Expenses,account.data_account_type_expenses,FALSE
+nz_61300,l10n_nz.l10n_nz_chart_template,61300,Commissions Paid,account.data_account_type_expenses,FALSE
+nz_61500,l10n_nz.l10n_nz_chart_template,61500,Depreciation Expense,account.data_account_type_depreciation,FALSE
+nz_61610,l10n_nz.l10n_nz_chart_template,61610,Discounts Given,account.data_account_type_expenses,FALSE
+nz_61620,l10n_nz.l10n_nz_chart_template,61620,Discounts Taken,account.data_account_type_expenses,FALSE
+nz_61630,l10n_nz.l10n_nz_chart_template,61630,Exchange Rate Losses (Gains),account.data_account_type_expenses,FALSE
+nz_61700,l10n_nz.l10n_nz_chart_template,61700,Freight Paid,account.data_account_type_expenses,FALSE
+nz_61800,l10n_nz.l10n_nz_chart_template,61800,Insurance,account.data_account_type_expenses,FALSE
+nz_61910,l10n_nz.l10n_nz_chart_template,61910,Overdraft Interest,account.data_account_type_expenses,FALSE
+nz_61920,l10n_nz.l10n_nz_chart_template,61920,Mortgage Interest,account.data_account_type_expenses,FALSE
+nz_61930,l10n_nz.l10n_nz_chart_template,61930,Other Interest,account.data_account_type_expenses,FALSE
+nz_62000,l10n_nz.l10n_nz_chart_template,62000,Late Fees Paid,account.data_account_type_expenses,FALSE
+nz_62110,l10n_nz.l10n_nz_chart_template,62110,Machinery & Equipment,account.data_account_type_expenses,FALSE
+nz_62120,l10n_nz.l10n_nz_chart_template,62120,Other Business Property,account.data_account_type_expenses,FALSE
+nz_62200,l10n_nz.l10n_nz_chart_template,62200,Legal & Professional Services,account.data_account_type_expenses,FALSE
+nz_62300,l10n_nz.l10n_nz_chart_template,62300,Office Expenses,account.data_account_type_expenses,FALSE
+nz_62410,l10n_nz.l10n_nz_chart_template,62410,Staff Amenities,account.data_account_type_expenses,FALSE
+nz_62420,l10n_nz.l10n_nz_chart_template,62420,Superannuation,account.data_account_type_expenses,FALSE
+nz_62430,l10n_nz.l10n_nz_chart_template,62430,Wages & Salaries,account.data_account_type_expenses,FALSE
+nz_62440,l10n_nz.l10n_nz_chart_template,62440,Workers' Compensation,account.data_account_type_expenses,FALSE
+nz_62450,l10n_nz.l10n_nz_chart_template,62450,Other Employer Expenses,account.data_account_type_expenses,FALSE
+nz_62500,l10n_nz.l10n_nz_chart_template,62500,Repairs,account.data_account_type_expenses,FALSE
+nz_62550,l10n_nz.l10n_nz_chart_template,62550,Shrinkage/Spoilage,account.data_account_type_expenses,FALSE
+nz_62600,l10n_nz.l10n_nz_chart_template,62600,Supplies,account.data_account_type_expenses,FALSE
+nz_62700,l10n_nz.l10n_nz_chart_template,62700,Taxes,account.data_account_type_expenses,FALSE
+nz_62800,l10n_nz.l10n_nz_chart_template,62800,Telephone,account.data_account_type_expenses,FALSE
+nz_62910,l10n_nz.l10n_nz_chart_template,62910,Gas,account.data_account_type_expenses,FALSE
+nz_62920,l10n_nz.l10n_nz_chart_template,62920,Electricity,account.data_account_type_expenses,FALSE
+nz_62930,l10n_nz.l10n_nz_chart_template,62930,Water,account.data_account_type_expenses,FALSE
+nz_63110,l10n_nz.l10n_nz_chart_template,63110,Travel,account.data_account_type_expenses,FALSE
+nz_63120,l10n_nz.l10n_nz_chart_template,63120,Meals & Entertainment,account.data_account_type_expenses,FALSE
+nz_81000,l10n_nz.l10n_nz_chart_template,81000,Interest Income,account.data_account_type_other_income,FALSE
+nz_91000,l10n_nz.l10n_nz_chart_template,91000,Interest Expense,account.data_account_type_expenses,FALSE
+nz_92000,l10n_nz.l10n_nz_chart_template,92000,Income Tax Expense,account.data_account_type_expenses,FALSE \ No newline at end of file
diff --git a/addons/l10n_nz/data/account.tax.group.csv b/addons/l10n_nz/data/account.tax.group.csv
new file mode 100644
index 00000000..afaf8f45
--- /dev/null
+++ b/addons/l10n_nz/data/account.tax.group.csv
@@ -0,0 +1,5 @@
+id,name
+tax_group_0,TAX 0%
+tax_group_gst_15,GST 15%
+tax_group_15,TAX 15%
+tax_group_100000000,GST 100000000%
diff --git a/addons/l10n_nz/data/account_chart_template_configure_data.xml b/addons/l10n_nz/data/account_chart_template_configure_data.xml
new file mode 100644
index 00000000..f54ef641
--- /dev/null
+++ b/addons/l10n_nz/data/account_chart_template_configure_data.xml
@@ -0,0 +1,8 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+ <data noupdate="1">
+ <function model="account.chart.template" name="try_loading">
+ <value eval="[ref('l10n_nz.l10n_nz_chart_template')]"/>
+ </function>
+ </data>
+</odoo>
diff --git a/addons/l10n_nz/data/account_chart_template_data.xml b/addons/l10n_nz/data/account_chart_template_data.xml
new file mode 100644
index 00000000..f8922aa3
--- /dev/null
+++ b/addons/l10n_nz/data/account_chart_template_data.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+ <record id="l10n_nz_chart_template" model="account.chart.template">
+ <field name="property_account_receivable_id" ref="nz_11200"/>
+ <field name="property_account_payable_id" ref="nz_21200"/>
+ <field name="property_account_expense_categ_id" ref="nz_51110"/>
+ <field name="property_account_income_categ_id" ref="nz_41110"/>
+ <field name="property_stock_account_input_categ_id" ref="nz_21210"/>
+ <field name="property_stock_account_output_categ_id" ref="nz_51110"/>
+ <field name="property_stock_valuation_account_id" ref="nz_11330"/>
+ <field name="expense_currency_exchange_account_id" ref="nz_61630"/>
+ <field name="income_currency_exchange_account_id" ref="nz_61630"/>
+ <field name="default_pos_receivable_account_id" ref="nz_11220" />
+ </record>
+</odoo>
diff --git a/addons/l10n_nz/data/account_fiscal_position_tax_template_data.xml b/addons/l10n_nz/data/account_fiscal_position_tax_template_data.xml
new file mode 100644
index 00000000..541de9f8
--- /dev/null
+++ b/addons/l10n_nz/data/account_fiscal_position_tax_template_data.xml
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+ <record id="fiscal_position_os_partner" model="account.fiscal.position.template">
+ <field name="name">OS Partner</field>
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ </record>
+
+ <record id="fiscal_position_tax_template_os_partner_sale1" model="account.fiscal.position.tax.template">
+ <field name="position_id" ref="fiscal_position_os_partner"/>
+ <field name="tax_src_id" ref="nz_tax_sale_15"/>
+ <field name="tax_dest_id" ref="nz_tax_sale_0"/>
+ </record>
+
+ <record id="fiscal_position_tax_template_os_partner_sale2" model="account.fiscal.position.tax.template">
+ <field name="position_id" ref="fiscal_position_os_partner"/>
+ <field name="tax_src_id" ref="nz_tax_sale_inc_15"/>
+ <field name="tax_dest_id" ref="nz_tax_sale_0"/>
+ </record>
+
+ <record id="fiscal_position_tax_template_os_partner_purch1" model="account.fiscal.position.tax.template">
+ <field name="position_id" ref="fiscal_position_os_partner"/>
+ <field name="tax_src_id" ref="nz_tax_purchase_15"/>
+ <field name="tax_dest_id" ref="nz_tax_purchase_0"/>
+ </record>
+
+ <record id="fiscal_position_tax_template_os_partner_purch2" model="account.fiscal.position.tax.template">
+ <field name="position_id" ref="fiscal_position_os_partner"/>
+ <field name="tax_src_id" ref="nz_tax_purchase_inc_15"/>
+ <field name="tax_dest_id" ref="nz_tax_purchase_0"/>
+ </record>
+</odoo>
diff --git a/addons/l10n_nz/data/account_tax_report_data.xml b/addons/l10n_nz/data/account_tax_report_data.xml
new file mode 100644
index 00000000..cf9136bb
--- /dev/null
+++ b/addons/l10n_nz/data/account_tax_report_data.xml
@@ -0,0 +1,112 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+
+ <record id="tax_report" model="account.tax.report">
+ <field name="name">Tax Report</field>
+ <field name="country_id" ref="base.nz"/>
+ </record>
+
+ <record id="tax_report_sale_and_income" model="account.tax.report.line">
+ <field name="name">Sales and Income</field>
+ <field name="sequence" eval="1"/>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box5" model="account.tax.report.line">
+ <field name="name">[BOX 5] Total sales and income for the period(including GST and zero-rated Supplies)</field>
+ <field name="tag_name">BOX 5</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="1"/>
+ <field name="code">NZBOX5</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box6" model="account.tax.report.line">
+ <field name="name">[BOX 6] Zero-rated supplies in Box 5</field>
+ <field name="tag_name">BOX 6</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="2"/>
+ <field name="code">NZBOX6</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box7" model="account.tax.report.line">
+ <field name="name">[BOX 7] The amount in Box 6 is subracted from Box 5</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="3"/>
+ <field name="formula">NZBOX5 - NZBOX6</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box8" model="account.tax.report.line">
+ <field name="name">[BOX 8] Multiply the amount in Box 7 by 3 and then divide by 23</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="4"/>
+ <field name="formula">((NZBOX5 - NZBOX6) * 3)/23</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box9" model="account.tax.report.line">
+ <field name="name">[BOX 9] Enter any adjustments from your calculation sheet</field>
+ <field name="tag_name">BOX 9</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="5"/>
+ <field name="code">NZBOX9</field>
+ <field name="formula"></field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box10" model="account.tax.report.line">
+ <field name="name">[BOX 10] Total GST collected on sales and income</field>
+ <field name="parent_id" ref="tax_report_sale_and_income"/>
+ <field name="sequence" eval="6"/>
+ <field name="formula">(((NZBOX5 - NZBOX6) * 3)/23) + NZBOX9</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_purchases_and_expenses" model="account.tax.report.line">
+ <field name="name">Purchases and Expenses</field>
+ <field name="sequence" eval="2"/>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box11" model="account.tax.report.line">
+ <field name="name">[BOX 11] Total purchases and expenses(including GST) for which tax invoicing requirements have been met</field>
+ <field name="tag_name">BOX 11</field>
+ <field name="parent_id" ref="tax_report_purchases_and_expenses"/>
+ <field name="sequence" eval="1"/>
+ <field name="code">NZBOX11</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box12" model="account.tax.report.line">
+ <field name="name">[BOX 12] Multiply BOX11 by 3 and then divide by 23</field>
+ <field name="parent_id" ref="tax_report_purchases_and_expenses"/>
+ <field name="sequence" eval="2"/>
+ <field name="formula">(NZBOX11 * 3)/23</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box13" model="account.tax.report.line">
+ <field name="name">[BOX 13] Credit adjustments from your calculation sheet</field>
+ <field name="parent_id" ref="tax_report_purchases_and_expenses"/>
+ <field name="sequence" eval="3"/>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box14" model="account.tax.report.line">
+ <field name="name">[BOX 14] Total GST credit for purchases and expenses</field>
+ <field name="parent_id" ref="tax_report_purchases_and_expenses"/>
+ <field name="sequence" eval="4"/>
+ <field name="formula">((NZBOX11 * 3)/23)</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+ <record id="tax_report_box15" model="account.tax.report.line">
+ <field name="name">[BOX 15] Difference between BOX10 and BOX14</field>
+ <field name="sequence" eval="3"/>
+ <field name="formula">((((NZBOX5 - NZBOX6) * 3)/23) + NZBOX9) - ((NZBOX11 * 3)/23)</field>
+ <field name="report_id" ref="tax_report"/>
+ </record>
+
+</odoo>
diff --git a/addons/l10n_nz/data/account_tax_template_data.xml b/addons/l10n_nz/data/account_tax_template_data.xml
new file mode 100644
index 00000000..51b48dd4
--- /dev/null
+++ b/addons/l10n_nz/data/account_tax_template_data.xml
@@ -0,0 +1,304 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<odoo>
+ <record id="nz_tax_sale_15" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">Sale (15%)</field>
+ <field name="sequence">1</field>
+ <field name="description">GST Sales</field>
+ <field name="type_tax_use">sale</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">15</field>
+ <field name="price_include">FALSE</field>
+ <field name="tax_group_id" ref="tax_group_15"/>
+ <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'plus_report_line_ids': [ref('tax_report_box5')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21310'),
+ 'plus_report_line_ids': [ref('tax_report_box5')],
+ }),
+ ]"/>
+ <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'minus_report_line_ids': [ref('tax_report_box5')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21310'),
+ 'minus_report_line_ids': [ref('tax_report_box5')],
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_sale_inc_15" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">GST Inc Sale (15%)</field>
+ <field name="sequence">2</field>
+ <field name="description">GST Inclusive Sales</field>
+ <field name="type_tax_use">sale</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">15</field>
+ <field name="price_include">TRUE</field>
+ <field name="tax_group_id" ref="tax_group_gst_15"/>
+ <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'plus_report_line_ids': [ref('tax_report_box5')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21310'),
+ 'plus_report_line_ids': [ref('tax_report_box5')],
+ }),
+ ]"/>
+ <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'minus_report_line_ids': [ref('tax_report_box5')]
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21310'),
+ 'minus_report_line_ids': [ref('tax_report_box5')],
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_sale_0" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">Zero/Export (0%) Sale</field>
+ <field name="sequence">3</field>
+ <field name="description">Zero Rated (Export) Sales</field>
+ <field name="type_tax_use">sale</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">0</field>
+ <field name="price_include">FALSE</field>
+ <field name="tax_group_id" ref="tax_group_0"/>
+ <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'plus_report_line_ids': [ref('tax_report_box5'), ref('tax_report_box6')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ }),
+ ]"/>
+ <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'minus_report_line_ids': [ref('tax_report_box5'), ref('tax_report_box6')]
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_purchase_15" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">Purch (15%)</field>
+ <field name="sequence">1</field>
+ <field name="description">GST Purchases</field>
+ <field name="type_tax_use">purchase</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">15</field>
+ <field name="price_include">FALSE</field>
+ <field name="tax_group_id" ref="tax_group_15"/>
+ <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'plus_report_line_ids': [ref('tax_report_box11')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21330'),
+ 'plus_report_line_ids': [ref('tax_report_box11')],
+ }),
+ ]"/>
+ <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'minus_report_line_ids': [ref('tax_report_box11')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21330'),
+ 'minus_report_line_ids': [ref('tax_report_box11')],
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_purchase_inc_15" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">GST Inc Purch (15%)</field>
+ <field name="sequence">2</field>
+ <field name="description">GST Inclusive Purchases</field>
+ <field name="type_tax_use">purchase</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">15</field>
+ <field name="price_include">TRUE</field>
+ <field name="tax_group_id" ref="tax_group_gst_15"/>
+ <field name="invoice_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'plus_report_line_ids': [ref('tax_report_box11')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21330'),
+ 'plus_report_line_ids': [ref('tax_report_box11')],
+ }),
+ ]"/>
+ <field name="refund_repartition_line_ids" eval="[(5, 0, 0),
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'base',
+ 'minus_report_line_ids': [ref('tax_report_box11')],
+ }),
+
+ (0,0, {
+ 'factor_percent': 100,
+ 'repartition_type': 'tax',
+ 'account_id': ref('nz_21330'),
+ 'minus_report_line_ids': [ref('tax_report_box11')],
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_purchase_0" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">Zero/Import (0%) Purch</field>
+ <field name="sequence">3</field>
+ <field name="description">Zero Rated Purchases</field>
+ <field name="type_tax_use">purchase</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">0</field>
+ <field name="price_include">FALSE</field>
+ <field name="tax_group_id" ref="tax_group_0"/>
+ <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',
+ }),
+ ]"/>
+ <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',
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_purchase_taxable_import" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">Purch (Imports Taxable)</field>
+ <field name="sequence">4</field>
+ <field name="description">Purchase (Taxable Imports) - Tax Paid Separately</field>
+ <field name="type_tax_use">purchase</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">0</field>
+ <field name="price_include">FALSE</field>
+ <field name="tax_group_id" ref="tax_group_0"/>
+ <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',
+ }),
+ ]"/>
+ <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',
+ }),
+ ]"/>
+ </record>
+ <record id="nz_tax_purchase_gst_only" model="account.tax.template">
+ <field name="chart_template_id" ref="l10n_nz_chart_template"/>
+ <field name="name">GST Only – Imports</field>
+ <field name="sequence">5</field>
+ <field name="description">GST Only on Imports</field>
+ <field name="type_tax_use">purchase</field>
+ <field name="amount_type">percent</field>
+ <field name="amount">100000000000</field>
+ <!--
+ The tax percentage is so high because on imported goods we
+ needed to link the tax line acknowledgment (not to be paid)
+ on the customer invoice and what need to actually be
+ paid from another invoice given by a clearance house
+ (i.e. customs)
+ For more info see the complete discussion below
+ https://github.com/odoo/odoo/pull/48700#issuecomment-607586417
+ -->
+ <field name="price_include">TRUE</field>
+ <field name="tax_group_id" ref="tax_group_100000000"/>
+ <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('nz_21330'),
+ }),
+ ]"/>
+ <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('nz_21330'),
+ }),
+ ]"/>
+ </record>
+</odoo>
diff --git a/addons/l10n_nz/data/l10n_nz_chart_data.xml b/addons/l10n_nz/data/l10n_nz_chart_data.xml
new file mode 100644
index 00000000..23892f54
--- /dev/null
+++ b/addons/l10n_nz/data/l10n_nz_chart_data.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+
+<data>
+
+ <record id="l10n_nz_chart_template" model="account.chart.template">
+ <field name="name">New Zealand Tax and Account Chart Template (by Willow IT)</field>
+ <field name="bank_account_code_prefix">1111</field>
+ <field name="cash_account_code_prefix">1113</field>
+ <field name="transfer_account_code_prefix">11170</field>
+ <field name="code_digits">5</field>
+ <field name="currency_id" ref="base.NZD"/>
+ </record>
+
+</data>
+</odoo>
diff --git a/addons/l10n_nz/data/res_currency_data.xml b/addons/l10n_nz/data/res_currency_data.xml
new file mode 100644
index 00000000..f1333757
--- /dev/null
+++ b/addons/l10n_nz/data/res_currency_data.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+ <data noupdate="1">
+ <record id="base.NZD" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+
+ <!-- Common trading partner currencies, and especially for AU -->
+
+ <record id="base.AUD" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+
+ <record id="base.JPY" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+
+ <record id="base.INR" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+
+ <record id="base.GBP" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+ </data>
+</odoo>