summaryrefslogtreecommitdiff
path: root/addons/l10n_au/data
diff options
context:
space:
mode:
authorRichard deMeester <richard@willowit.com.au>2015-10-07 18:14:32 +1100
committerMartin Trigaux <mat@odoo.com>2015-10-08 15:34:28 +0200
commit91aa012ed030c9927f49fd1d799321744729ef83 (patch)
tree4824c616dcb0a127f4e40018e40ac4cdad7dcb66 /addons/l10n_au/data
parent1a585795406efbb1fabbab6c6186be9d097cb44a (diff)
[ADD] l10n_au: Australian Accounting
Basic Australian Accounting Module. Closes #8936
Diffstat (limited to 'addons/l10n_au/data')
-rw-r--r--addons/l10n_au/data/account.account.tag.csv11
-rw-r--r--addons/l10n_au/data/account.account.template.csv97
-rw-r--r--addons/l10n_au/data/account.tax.template.csv11
-rw-r--r--addons/l10n_au/data/account_chart_template.xml38
-rw-r--r--addons/l10n_au/data/account_chart_template.yml3
-rw-r--r--addons/l10n_au/data/account_chart_template_refs.xml13
-rw-r--r--addons/l10n_au/data/account_fiscal_position_tax_template.xml28
-rw-r--r--addons/l10n_au/data/localisation.xml26
8 files changed, 227 insertions, 0 deletions
diff --git a/addons/l10n_au/data/account.account.tag.csv b/addons/l10n_au/data/account.account.tag.csv
new file mode 100644
index 00000000000..c3f40d4850d
--- /dev/null
+++ b/addons/l10n_au/data/account.account.tag.csv
@@ -0,0 +1,11 @@
+id,name,applicability
+tag_au_tax_sale_10,Taxable Sales Ex-GST,taxes
+tag_au_tax_sale_inc_10,Taxable Sales Inc-GST,taxes
+tag_au_tax_sale_0,Tax Exclusive Sales,taxes
+tag_au_tax_sale_exempt,Tax Exempt Sales,taxes
+tag_au_tax_purchase_10,Taxable Purchases Ex-GST,taxes
+tag_au_tax_purchase_inc_10,Taxable Purchases Inc-GST,taxes
+tag_au_tax_purchase_capital,Capital Purchases Ex-GST,taxes
+tag_au_tax_purchase_0,Tax Exempt Purchases,taxes
+tag_au_tax_purchase_taxable_import,Taxable Import without GST,taxes
+tag_au_tax_purchase_gst_only,GST Payment for Taxable Imports,taxes
diff --git a/addons/l10n_au/data/account.account.template.csv b/addons/l10n_au/data/account.account.template.csv
new file mode 100644
index 00000000000..065cd900578
--- /dev/null
+++ b/addons/l10n_au/data/account.account.template.csv
@@ -0,0 +1,97 @@
+id,chart_template_id:id,code,name,user_type_id:id,reconcile
+au_11110,l10n_au.l10n_au_chart_template,11110,Bank Account,account.data_account_type_liquidity,FALSE
+au_11130,l10n_au.l10n_au_chart_template,11130,Petty Cash,account.data_account_type_liquidity,FALSE
+au_11140,l10n_au.l10n_au_chart_template,11140,Cash Drawer,account.data_account_type_liquidity,FALSE
+au_11180,l10n_au.l10n_au_chart_template,11180,Undeposited Funds,account.data_account_type_liquidity,TRUE
+au_11190,l10n_au.l10n_au_chart_template,11190,Electronic Clearing Account,account.data_account_type_liquidity,TRUE
+au_11200,l10n_au.l10n_au_chart_template,11200,Trade Debtors,account.data_account_type_receivable,TRUE
+au_11210,l10n_au.l10n_au_chart_template,11210,Less Prov'n for Doubtful Debts,account.data_account_type_current_assets,FALSE
+au_11310,l10n_au.l10n_au_chart_template,11310,Raw Materials,account.data_account_type_current_assets,FALSE
+au_11320,l10n_au.l10n_au_chart_template,11320,Finished Goods,account.data_account_type_current_assets,FALSE
+au_12100,l10n_au.l10n_au_chart_template,12100,Deposits Paid,account.data_account_type_prepayments,FALSE
+au_12200,l10n_au.l10n_au_chart_template,12200,Prepaid Insurance,account.data_account_type_current_assets,FALSE
+au_13110,l10n_au.l10n_au_chart_template,13110,Manufacturing Plant at Cost,account.data_account_type_fixed_assets,FALSE
+au_13120,l10n_au.l10n_au_chart_template,13120,Manufac. Plant Accum Dep,account.data_account_type_fixed_assets,FALSE
+au_13130,l10n_au.l10n_au_chart_template,13130,Manufacturing Equipment Cost,account.data_account_type_fixed_assets,FALSE
+au_13140,l10n_au.l10n_au_chart_template,13140,Manufac. Equip Accum Dep,account.data_account_type_fixed_assets,FALSE
+au_13210,l10n_au.l10n_au_chart_template,13210,Furniture & Fixtures at Cost,account.data_account_type_fixed_assets,FALSE
+au_13220,l10n_au.l10n_au_chart_template,13220,Furniture & Fixtures Accum Dep,account.data_account_type_fixed_assets,FALSE
+au_13310,l10n_au.l10n_au_chart_template,13310,Office Equip at Cost,account.data_account_type_fixed_assets,FALSE
+au_13320,l10n_au.l10n_au_chart_template,13320,Office Equip Accum Dep,account.data_account_type_fixed_assets,FALSE
+au_13410,l10n_au.l10n_au_chart_template,13410,Motor Vehicles at Cost,account.data_account_type_fixed_assets,FALSE
+au_13420,l10n_au.l10n_au_chart_template,13420,Motor Vehicles Accum Dep,account.data_account_type_fixed_assets,FALSE
+au_21110,l10n_au.l10n_au_chart_template,21110,Credit Card,account.data_account_type_current_liabilities,FALSE
+au_21200,l10n_au.l10n_au_chart_template,21200,Trade Creditors,account.data_account_type_payable,TRUE
+au_21210,l10n_au.l10n_au_chart_template,21210,A/P Accrual - Inventory,account.data_account_type_current_liabilities,FALSE
+au_21310,l10n_au.l10n_au_chart_template,21310,GST Collected,account.data_account_type_current_liabilities,FALSE
+au_21330,l10n_au.l10n_au_chart_template,21330,GST Paid,account.data_account_type_current_assets,FALSE
+au_21350,l10n_au.l10n_au_chart_template,21350,Fuel Tax Credits Accrued,account.data_account_type_current_liabilities,FALSE
+au_21355,l10n_au.l10n_au_chart_template,21355,WET Payable,account.data_account_type_current_liabilities,FALSE
+au_21360,l10n_au.l10n_au_chart_template,21360,Import Duty Payable,account.data_account_type_current_liabilities,FALSE
+au_21370,l10n_au.l10n_au_chart_template,21370,Voluntary Withholdings Payable,account.data_account_type_current_liabilities,FALSE
+au_21380,l10n_au.l10n_au_chart_template,21380,ABN Withholdings Payable,account.data_account_type_current_liabilities,FALSE
+au_21410,l10n_au.l10n_au_chart_template,21410,Payroll Accruals Payable,account.data_account_type_current_liabilities,FALSE
+au_21420,l10n_au.l10n_au_chart_template,21420,PAYG Withholding Payable,account.data_account_type_current_liabilities,FALSE
+au_21600,l10n_au.l10n_au_chart_template,21600,Customer Deposits,account.data_account_type_current_liabilities,FALSE
+au_21700,l10n_au.l10n_au_chart_template,21700,Other Current Liabilities,account.data_account_type_current_liabilities,FALSE
+au_22100,l10n_au.l10n_au_chart_template,22100,Mortgages Payable,account.data_account_type_non_current_liabilities,FALSE
+au_22200,l10n_au.l10n_au_chart_template,22200,Notes Payable,account.data_account_type_non_current_liabilities,FALSE
+au_22300,l10n_au.l10n_au_chart_template,22300,Other Long Term Liabilities,account.data_account_type_non_current_liabilities,FALSE
+au_31100,l10n_au.l10n_au_chart_template,31100,Capital Investment,account.data_account_type_equity,FALSE
+au_31200,l10n_au.l10n_au_chart_template,31200,Capital Drawings,account.data_account_type_equity,FALSE
+au_38000,l10n_au.l10n_au_chart_template,38000,Retained Earnings,account.data_account_type_equity,FALSE
+au_39000,l10n_au.l10n_au_chart_template,39000,Current Year Earnings,account.data_unaffected_earnings,FALSE
+au_39999,l10n_au.l10n_au_chart_template,39999,Historical Balancing,account.data_account_type_equity,FALSE
+au_41110,l10n_au.l10n_au_chart_template,41110,Sales Product #1,account.data_account_type_revenue,FALSE
+au_41120,l10n_au.l10n_au_chart_template,41120,Sales Product #2,account.data_account_type_revenue,FALSE
+au_41130,l10n_au.l10n_au_chart_template,41130,Sales Product #3,account.data_account_type_revenue,FALSE
+au_42000,l10n_au.l10n_au_chart_template,42000,Wholesale Sales,account.data_account_type_revenue,FALSE
+au_43000,l10n_au.l10n_au_chart_template,43000,Consignment Sales,account.data_account_type_revenue,FALSE
+au_44000,l10n_au.l10n_au_chart_template,44000,Freight Income,account.data_account_type_revenue,FALSE
+au_45000,l10n_au.l10n_au_chart_template,45000,Late Fees Collected,account.data_account_type_other_income,FALSE
+au_46000,l10n_au.l10n_au_chart_template,46000,Miscellaneous Income,account.data_account_type_other_income,FALSE
+au_47000,l10n_au.l10n_au_chart_template,47000,Fuel Tax Credits,account.data_account_type_other_income,FALSE
+au_51110,l10n_au.l10n_au_chart_template,51110,Cost of Goods Sold #1,account.data_account_type_direct_costs,FALSE
+au_51120,l10n_au.l10n_au_chart_template,51120,Cost of Goods Sold # 2,account.data_account_type_direct_costs,FALSE
+au_51130,l10n_au.l10n_au_chart_template,51130,Cost of Goods Sold # 3,account.data_account_type_direct_costs,FALSE
+au_52000,l10n_au.l10n_au_chart_template,52000,Wholesale Cost of Sales,account.data_account_type_direct_costs,FALSE
+au_53000,l10n_au.l10n_au_chart_template,53000,Consignment Cost of Sales,account.data_account_type_direct_costs,FALSE
+au_54000,l10n_au.l10n_au_chart_template,54000,Wages for Production Labour,account.data_account_type_direct_costs,FALSE
+au_55000,l10n_au.l10n_au_chart_template,55000,Materials & Supplies,account.data_account_type_direct_costs,FALSE
+au_56000,l10n_au.l10n_au_chart_template,56000,Freight,account.data_account_type_direct_costs,FALSE
+au_57000,l10n_au.l10n_au_chart_template,57000,Other Costs,account.data_account_type_direct_costs,FALSE
+au_61000,l10n_au.l10n_au_chart_template,61000,Advertising,account.data_account_type_expenses,FALSE
+au_61200,l10n_au.l10n_au_chart_template,61200,Car & Truck Expenses,account.data_account_type_expenses,FALSE
+au_61300,l10n_au.l10n_au_chart_template,61300,Commissions Paid,account.data_account_type_expenses,FALSE
+au_61500,l10n_au.l10n_au_chart_template,61500,Depreciation Expense,account.data_account_type_depreciation,FALSE
+au_61610,l10n_au.l10n_au_chart_template,61610,Discounts Given,account.data_account_type_expenses,FALSE
+au_61620,l10n_au.l10n_au_chart_template,61620,Discounts Taken,account.data_account_type_expenses,FALSE
+au_61630,l10n_au.l10n_au_chart_template,61630,Exchange Rate Losses (Gains),account.data_account_type_expenses,FALSE
+au_61700,l10n_au.l10n_au_chart_template,61700,Freight Paid,account.data_account_type_expenses,FALSE
+au_61800,l10n_au.l10n_au_chart_template,61800,Insurance,account.data_account_type_expenses,FALSE
+au_61910,l10n_au.l10n_au_chart_template,61910,Overdraft Interest,account.data_account_type_expenses,FALSE
+au_61920,l10n_au.l10n_au_chart_template,61920,Mortgage Interest,account.data_account_type_expenses,FALSE
+au_61930,l10n_au.l10n_au_chart_template,61930,Other Interest,account.data_account_type_expenses,FALSE
+au_62000,l10n_au.l10n_au_chart_template,62000,Late Fees Paid,account.data_account_type_expenses,FALSE
+au_62110,l10n_au.l10n_au_chart_template,62110,Machinery & Equipment,account.data_account_type_expenses,FALSE
+au_62120,l10n_au.l10n_au_chart_template,62120,Other Business Property,account.data_account_type_expenses,FALSE
+au_62200,l10n_au.l10n_au_chart_template,62200,Legal & Professional Services,account.data_account_type_expenses,FALSE
+au_62300,l10n_au.l10n_au_chart_template,62300,Office Expenses,account.data_account_type_expenses,FALSE
+au_62410,l10n_au.l10n_au_chart_template,62410,Staff Amenities,account.data_account_type_expenses,FALSE
+au_62420,l10n_au.l10n_au_chart_template,62420,Superannuation,account.data_account_type_expenses,FALSE
+au_62430,l10n_au.l10n_au_chart_template,62430,Wages & Salaries,account.data_account_type_expenses,FALSE
+au_62440,l10n_au.l10n_au_chart_template,62440,Workers' Compensation,account.data_account_type_expenses,FALSE
+au_62450,l10n_au.l10n_au_chart_template,62450,Other Employer Expenses,account.data_account_type_expenses,FALSE
+au_62500,l10n_au.l10n_au_chart_template,62500,Repairs,account.data_account_type_expenses,FALSE
+au_62550,l10n_au.l10n_au_chart_template,62550,Shrinkage/Spoilage,account.data_account_type_expenses,FALSE
+au_62600,l10n_au.l10n_au_chart_template,62600,Supplies,account.data_account_type_expenses,FALSE
+au_62700,l10n_au.l10n_au_chart_template,62700,Taxes,account.data_account_type_expenses,FALSE
+au_62800,l10n_au.l10n_au_chart_template,62800,Telephone,account.data_account_type_expenses,FALSE
+au_62910,l10n_au.l10n_au_chart_template,62910,Gas,account.data_account_type_expenses,FALSE
+au_62920,l10n_au.l10n_au_chart_template,62920,Electricity,account.data_account_type_expenses,FALSE
+au_62930,l10n_au.l10n_au_chart_template,62930,Water,account.data_account_type_expenses,FALSE
+au_63110,l10n_au.l10n_au_chart_template,63110,Travel,account.data_account_type_expenses,FALSE
+au_63120,l10n_au.l10n_au_chart_template,63120,Meals & Entertainment,account.data_account_type_expenses,FALSE
+au_81000,l10n_au.l10n_au_chart_template,81000,Interest Income,account.data_account_type_other_income,FALSE
+au_91000,l10n_au.l10n_au_chart_template,91000,Interest Expense,account.data_account_type_expenses,FALSE
+au_92000,l10n_au.l10n_au_chart_template,92000,Income Tax Expense,account.data_account_type_expenses,FALSE
diff --git a/addons/l10n_au/data/account.tax.template.csv b/addons/l10n_au/data/account.tax.template.csv
new file mode 100644
index 00000000000..8d630836f8a
--- /dev/null
+++ b/addons/l10n_au/data/account.tax.template.csv
@@ -0,0 +1,11 @@
+id,chart_template_id:id,name,sequence,description,type_tax_use,amount_type,amount,price_include,account_id:id,refund_account_id:id,tag_ids:id
+au_tax_sale_10,l10n_au_chart_template,Sale (10%),1,GST Sales,sale,percent,10,FALSE,au_21310,au_21310,tag_au_tax_sale_10
+au_tax_sale_inc_10,l10n_au_chart_template,GST Inc Sale (10%),2,GST Inclusive Sales,sale,percent,10,TRUE,au_21310,au_21310,tag_au_tax_sale_inc_10
+au_tax_sale_0,l10n_au_chart_template,Zero (Export) Sale,3,Zero Rated (Export) Sales,sale,percent,0,FALSE,au_21310,au_21310,tag_au_tax_sale_0
+au_tax_sale_exempt,l10n_au_chart_template,Exempt Sale,4,Exempt Sales,sale,percent,0,FALSE,au_21310,au_21310,tag_au_tax_sale_exempt
+au_tax_purchase_10,l10n_au_chart_template,Purch (10%),1,GST Purchases,purchase,percent,10,FALSE,au_21330,au_21330,tag_au_tax_purchase_10
+au_tax_purchase_inc_10,l10n_au_chart_template,GST Inc Purch (10%),2,GST Inclusive Purchases,purchase,percent,10,TRUE,au_21330,au_21330,tag_au_tax_purchase_inc_10
+au_tax_purchase_capital,l10n_au_chart_template,Capital (10.0%),3,Capital Purchases,purchase,percent,10,FALSE,au_21330,au_21330,tag_au_tax_purchase_capital
+au_tax_purchase_0,l10n_au_chart_template,Zero Rated Purch,4,Zero Rated Purchases,purchase,percent,0,FALSE,au_21330,au_21330,tag_au_tax_purchase_0
+au_tax_purchase_taxable_import,l10n_au_chart_template,Purch (Taxable Imports),5,Purchase (Taxable Imports) - Tax Paid Separately,purchase,percent,0,FALSE,au_21330,au_21330,tag_au_tax_purchase_taxable_import
+au_tax_purchase_gst_only,l10n_au_chart_template,GST Only on Imports,6,GST Only on Imports,purchase,percent,100000000,TRUE,au_21330,au_21330,tag_au_tax_purchase_gst_only
diff --git a/addons/l10n_au/data/account_chart_template.xml b/addons/l10n_au/data/account_chart_template.xml
new file mode 100644
index 00000000000..b1b7c860099
--- /dev/null
+++ b/addons/l10n_au/data/account_chart_template.xml
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data noupdate="1">
+ <record id="action_client_l10n_au_menu" model="ir.actions.client">
+ <field name="name">Open Account Dashboard Menu</field>
+ <field name="tag">reload</field>
+ <field name="params" eval="{'menu_id': ref('account.menu_board_journal_1')}"/>
+ </record>
+ <record id="base.open_menu" model="ir.actions.todo">
+ <field name="action_id" ref="action_client_l10n_au_menu"/>
+ <field name="state">open</field>
+ </record>
+</data>
+
+<data noupdate="0">
+
+ <record id="au_11170" model="account.account.template">
+ <field name="name">Transfers</field>
+ <field name="code">11170</field>
+ <field name="reconcile" eval="True"/>
+ <field name="user_type_id" ref="account.data_account_type_current_assets"/>
+ </record>
+
+ <record id="l10n_au_chart_template" model="account.chart.template">
+ <field name="name">Australian 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="code_digits">5</field>
+ <field name="currency_id" ref="base.AUD"/>
+ <field name="transfer_account_id" ref="au_11170"/>
+ </record>
+
+ <record id="au_11170" model="account.account.template">
+ <field name="chart_template_id" ref="l10n_au_chart_template"/>
+ </record>
+
+</data>
+</openerp>
diff --git a/addons/l10n_au/data/account_chart_template.yml b/addons/l10n_au/data/account_chart_template.yml
new file mode 100644
index 00000000000..63dea9050ad
--- /dev/null
+++ b/addons/l10n_au/data/account_chart_template.yml
@@ -0,0 +1,3 @@
+-
+ !python {model: account.chart.template, id: l10n_au_chart_template}: |
+ self[0].try_loading_for_current_company()
diff --git a/addons/l10n_au/data/account_chart_template_refs.xml b/addons/l10n_au/data/account_chart_template_refs.xml
new file mode 100644
index 00000000000..131697e3391
--- /dev/null
+++ b/addons/l10n_au/data/account_chart_template_refs.xml
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data noupdate="0">
+ <record id="l10n_au_chart_template" model="account.chart.template">
+ <field name="property_account_receivable_id" ref="au_11200"/>
+ <field name="property_account_payable_id" ref="au_21200"/>
+ <field name="property_account_expense_categ_id" ref="au_51110"/>
+ <field name="property_account_income_categ_id" ref="au_41110"/>
+ <field name="expense_currency_exchange_account_id" ref="au_61630"/>
+ <field name="income_currency_exchange_account_id" ref="au_61630"/>
+ </record>
+</data>
+</openerp>
diff --git a/addons/l10n_au/data/account_fiscal_position_tax_template.xml b/addons/l10n_au/data/account_fiscal_position_tax_template.xml
new file mode 100644
index 00000000000..2f102292a3a
--- /dev/null
+++ b/addons/l10n_au/data/account_fiscal_position_tax_template.xml
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+ <record id="fiscal_position_os_partner" model="account.fiscal.position.template">
+ <field name="name">OS Partner</field>
+ <field name="chart_template_id" ref="l10n_au_chart_template"/>
+ </record>
+
+ <record id="fiscal_position_tax_template_os_partner_sale" model="account.fiscal.position.tax.template">
+ <field name="position_id" ref="fiscal_position_os_partner"/>
+ <field name="tax_src_id" ref="au_tax_sale_10"/>
+ <field name="tax_dest_id" ref="au_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="au_tax_purchase_10"/>
+ <field name="tax_dest_id" ref="au_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="au_tax_purchase_capital"/>
+ <field name="tax_dest_id" ref="au_tax_purchase_0"/>
+ </record>
+
+ </data>
+</openerp>
diff --git a/addons/l10n_au/data/localisation.xml b/addons/l10n_au/data/localisation.xml
new file mode 100644
index 00000000000..95647e09771
--- /dev/null
+++ b/addons/l10n_au/data/localisation.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data noupdate="1">
+ <record id="base.AUD" model="res.currency">
+ <field name="active" eval="True"/>
+ </record>
+
+ <!-- Common trading partner currencies, and especially for NZ, subsidiaries and branches -->
+
+ <record id="base.NZD" 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>
+</openerp>