summaryrefslogtreecommitdiff
path: root/sql/Australia_General_00000-chart.sql
blob: 0c0a2c2bd69ddc4641459542f238ed1f1f900972 (plain)
  1. -- Australia chart of accounts
  2. -- sample only
  3. --
  4. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10000','BANK AND CASH ACCOUNTS','H','','A','');
  5. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10001','Bank Account','A','100','A','AR_paid:AP_paid');
  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10010','Petty Cash','A','100','A','AR_paid:AP_paid');
  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11000','CUSTOMERS AND SETTLEMENT ACCOUNTS','H','','A','');
  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11001','Accounts Receivables','A','110','A','AR');
  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12000','OTHER CURRENT ASSETS','H','','A','');
  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12001','Allowance for doubtful accounts','A','120','A','');
  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15000','INVENTORY ASSETS','H','','A','');
  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15001','Inventory / General','A','150','A','IC');
  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15002','Inventory / Aftermarket Parts','A','150','A','IC');
  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16000','STATUTORY DEBTORS','H','','A','');
  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16001','INPUT GST','A','160','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18000','CAPITAL ASSETS','H','','A','');
  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18001','Land and Buildings','A','180','A','');
  18. insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18002','Accumulated Amortization -Land & Buildings','A','180','A','','1');
  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18003','Office Furniture & Equipment','A','180','A','');
  20. insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18004','Accumulated Amortization -Furniture & Equipment','A','180','A','','1');
  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18005','Vehicle','A','180','A','');
  22. insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18006','Accumulated Amortization -Vehicle','A','180','A','','1');
  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20000','CURRENT LIABILITIES','H','','L','');
  24. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20001','Accounts Payable','A','200','L','AP');
  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21000','STATUTORY CREDITORS','H','','L','');
  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21001','Corporate Taxes Payable','A','210','L','');
  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21002','OUTPUT GST','A','210','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21003','GST Settlement Account','A','210','L','');
  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22000','PAYROLL ACCOUNTS','H','','L','');
  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22001','Workers Net Salary Payable','A','220','L','');
  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22002','PAYG Witholding Payable','A','220','L','');
  32. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22003','Superannuation Plan Payable','A','220','L','');
  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26000','LONG TERM LIABILITIES','H','','L','');
  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26001','Bank Loans','A','260','L','');
  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26002','Loans from Shareholders','A','260','L','AP_paid');
  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33000','SHARE CAPITAL','H','','Q','');
  37. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33001','Common Shares','A','330','Q','');
  38. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40000','SALES REVENUE','H','','I','');
  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40001','Sales / General','A','400','I','AR_amount:IC_sale');
  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40002','Sales / Aftermarket Parts','A','400','I','AR_amount:IC_sale');
  41. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41000','CONSULTING REVENUE','H','','I','');
  42. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41001','Consulting','A','410','I','AR_amount:IC_income');
  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42000','OTHER REVENUE','H','','I','');
  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42001','Interest and Financial Income','A','420','I','');
  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42002','Foreign Exchange Gain','A','420','I','');
  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50000','COST OF GOODS SOLD','H','','E','');
  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50001','Purchases','A','500','E','AP_amount:IC_cogs:IC_expense');
  48. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50002','COGS / General','A','500','E','AP_amount:IC_cogs');
  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50003','COGS / Aftermarket Parts','A','500','E','AP_amount:IC_cogs');
  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50004','Freight','A','500','E','AP_amount:IC_expense');
  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54000','PAYROLL EXPENSES','H','','E','');
  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54001','Wages & Salaries','A','540','E','');
  53. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54002','PAYG Tax Expense','A','540','E','');
  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54003','Superannuation Plan Expense','A','540','E','');
  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56000','GENERAL & ADMINISTRATIVE EXPENSES','H','','E','');
  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56001','Accounting & Legal','A','560','E','AP_amount');
  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56002','Advertising & Promotions','A','560','E','AP_amount');
  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56003','Amortization Expense','A','560','E','');
  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56004','Income Taxes','A','560','E','');
  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56005','Insurance','A','560','E','AP_amount');
  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56006','Office Supplies','A','560','E','AP_amount');
  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56007','Rent and Rates','A','560','E','AP_amount');
  63. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56008','Repair & Maintenance','A','560','E','AP_amount');
  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56009','Telephone, Fax and Internet','A','560','E','AP_amount');
  65. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56010','Travel & Entertainment','A','560','E','');
  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56011','Utilities','A','560','E','AP_amount');
  67. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56012','Registrations','A','560','E','AP_amount');
  68. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56013','Licenses','A','560','E','AP_amount');
  69. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58000','OTHER EXPENSES','H','','E','');
  70. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58001','Interest & Bank Charges','A','580','E','');
  71. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58002','Foreign Exchange Loss','A','580','E','');
  72. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58003','Bad Debts','A','580','E','');
  73. --
  74. insert into tax (chart_id,rate) values ((select id from chart where accno = '16001'),0.1);
  75. insert into tax (chart_id,rate) values ((select id from chart where accno = '21002'),0.1);
  76. --
  77. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '15001'));
  78. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '40001'));
  79. INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50001'));
  80. INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '42002'));
  81. INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '58002'));
  82. INSERT INTO defaults (setting_key, value) VALUES ('curr', 'AUD:USD:EUR');
  83. INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');