- KEY `account_code` (`account_code`),
- KEY `account_name` (`account_name`)
-) TYPE=MyISAM ;
-
-
-### Data of table `0_chart_master` ###
-
-INSERT INTO `0_chart_master` VALUES ('3000', '', 'Sales', '1', '0');
-INSERT INTO `0_chart_master` VALUES ('3010', '', 'Sales - Wholesale', '1', '0');
-INSERT INTO `0_chart_master` VALUES ('3020', '', 'Sales of Other items', '1', '0');
-INSERT INTO `0_chart_master` VALUES ('3400', '', 'Difference On Exchange', '1', '0');
-INSERT INTO `0_chart_master` VALUES ('5000', '', 'Direct Labour', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('5050', '', 'Direct Labour Recovery', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4200', '', 'Material Usage Varaiance', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4210', '', 'Consumable Materials', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4220', '', 'Purchase price Variance', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4000', '', 'Purchases of materials', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4250', '', 'Discounts Received', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4260', '', 'Exchange Variation', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4300', '', 'Freight Inwards', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('4010', '', 'Cost of Goods Sold - Retail', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('6790', '', 'Bank Charges', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('6800', '', 'Entertainments', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('6810', '', 'Legal Expenses', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('6600', '', 'Repairs and Maintenance Office', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('6730', '', 'phone', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('8200', '', 'Bank Interest', '52', '0');
-INSERT INTO `0_chart_master` VALUES ('8900', '', 'Profit and Loss this year', '52', '0');
-INSERT INTO `0_chart_master` VALUES ('6840', '', 'Credit Control', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('7040', '', 'Depreciation Office Equipment', '51', '0');
-INSERT INTO `0_chart_master` VALUES ('3800', '', 'Freight Outwards', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('4500', '', 'Packaging', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('6400', '', 'Commissions', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('3200', '', 'Prompt Payment Discounts', '1', '0');
-INSERT INTO `0_chart_master` VALUES ('6700', '', 'General Expenses', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('5200', '', 'Indirect Labour', '2', '0');
-INSERT INTO `0_chart_master` VALUES ('5210', '', 'Overhead Recovery', '5', '0');
-INSERT INTO `0_chart_master` VALUES ('1700', '', 'Bank account', '10', '0');
-INSERT INTO `0_chart_master` VALUES ('1705', '', 'Petty Cash', '10', '0');
-INSERT INTO `0_chart_master` VALUES ('1710', '', 'Foreign currency account', '10', '0');
-INSERT INTO `0_chart_master` VALUES ('1500', '', 'Accounts Receivable', '20', '0');
-INSERT INTO `0_chart_master` VALUES ('1400', '', 'Stocks of Raw Materials', '45', '0');
-INSERT INTO `0_chart_master` VALUES ('1410', '', 'Stocks of Work In Progress', '45', '0');
-INSERT INTO `0_chart_master` VALUES ('1420', '', 'Stocks of Finsihed Goods', '45', '0');
-INSERT INTO `0_chart_master` VALUES ('1430', '', 'Goods Received Clearing account', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2630', '', 'Accounts Payable', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2660', '', 'VAT out 5', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2662', '', 'VAT out 1', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2664', '', 'VAT out 25', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2680', '', 'VAT In 5', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2682', '', 'VAT In 25', '30', '0');
-INSERT INTO `0_chart_master` VALUES ('2050', '', 'Retained Earnings', '50', '0');
-INSERT INTO `0_chart_master` VALUES ('2000', '', 'Share Capital', '50', '0');
-
-
-### Structure of table `0_chart_types` ###
+ KEY `account_name` (`account_name`),
+ KEY `accounts_by_type` (`account_type`,`account_code`)
+) TYPE=MyISAM;
+
+--
+-- Dumping data for table `0_chart_master`
+--
+
+INSERT INTO `0_chart_master` VALUES('1060', '', 'Checking Account', '1', 0);
+INSERT INTO `0_chart_master` VALUES('1065', '', 'Petty Cash', '1', 0);
+INSERT INTO `0_chart_master` VALUES('1200', '', 'Accounts Receivables', '1', 0);
+INSERT INTO `0_chart_master` VALUES('1205', '', 'Allowance for doubtful accounts', '1', 0);
+INSERT INTO `0_chart_master` VALUES('1510', '', 'Inventory', '2', 0);
+INSERT INTO `0_chart_master` VALUES('1520', '', 'Stocks of Raw Materials', '2', 0);
+INSERT INTO `0_chart_master` VALUES('1530', '', 'Stocks of Work In Progress', '2', 0);
+INSERT INTO `0_chart_master` VALUES('1540', '', 'Stocks of Finsihed Goods', '2', 0);
+INSERT INTO `0_chart_master` VALUES('1550', '', 'Goods Received Clearing account', '2', 0);
+INSERT INTO `0_chart_master` VALUES('1820', '', 'Office Furniture & Equipment', '3', 0);
+INSERT INTO `0_chart_master` VALUES('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
+INSERT INTO `0_chart_master` VALUES('1840', '', 'Vehicle', '3', 0);
+INSERT INTO `0_chart_master` VALUES('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
+INSERT INTO `0_chart_master` VALUES('2100', '', 'Accounts Payable', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2110', '', 'Accrued Income Tax - Federal', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2120', '', 'Accrued Income Tax - State', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2130', '', 'Accrued Franchise Tax', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2150', '', 'Sales Tax', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2160', '', 'Accrued Use Tax Payable', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2210', '', 'Accrued Wages', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2220', '', 'Accrued Comp Time', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2230', '', 'Accrued Holiday Pay', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2240', '', 'Accrued Vacation Pay', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2310', '', 'Accr. Benefits - 401K', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2370', '', 'Accr. Benefits - Garnish', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
+INSERT INTO `0_chart_master` VALUES('2620', '', 'Bank Loans', '5', 0);
+INSERT INTO `0_chart_master` VALUES('2680', '', 'Loans from Shareholders', '5', 0);
+INSERT INTO `0_chart_master` VALUES('3350', '', 'Common Shares', '6', 0);
+INSERT INTO `0_chart_master` VALUES('3590', '', 'Retained Earnings - prior years', '7', 0);
+INSERT INTO `0_chart_master` VALUES('4010', '', 'Sales', '8', 0);
+INSERT INTO `0_chart_master` VALUES('4430', '', 'Shipping & Handling', '9', 0);
+INSERT INTO `0_chart_master` VALUES('4440', '', 'Interest', '9', 0);
+INSERT INTO `0_chart_master` VALUES('4450', '', 'Foreign Exchange Gain', '9', 0);
+INSERT INTO `0_chart_master` VALUES('4500', '', 'Prompt Payment Discounts', '9', 0);
+INSERT INTO `0_chart_master` VALUES('4510', '', 'Discounts Given', '9', 0);
+INSERT INTO `0_chart_master` VALUES('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5020', '', 'Material Usage Varaiance', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5030', '', 'Consumable Materials', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5040', '', 'Purchase price Variance', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5050', '', 'Purchases of materials', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5060', '', 'Discounts Received', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5100', '', 'Freight', '10', 0);
+INSERT INTO `0_chart_master` VALUES('5410', '', 'Wages & Salaries', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5420', '', 'Wages - Overtime', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5430', '', 'Benefits - Comp Time', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5440', '', 'Benefits - Payroll Taxes', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5450', '', 'Benefits - Workers Comp', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5460', '', 'Benefits - Pension', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5470', '', 'Benefits - General Benefits', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5510', '', 'Inc Tax Exp - Federal', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5520', '', 'Inc Tax Exp - State', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5530', '', 'Taxes - Real Estate', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5540', '', 'Taxes - Personal Property', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5550', '', 'Taxes - Franchise', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5560', '', 'Taxes - Foreign Withholding', '11', 0);
+INSERT INTO `0_chart_master` VALUES('5610', '', 'Accounting & Legal', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5615', '', 'Advertising & Promotions', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5620', '', 'Bad Debts', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5660', '', 'Amortization Expense', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5685', '', 'Insurance', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5690', '', 'Interest & Bank Charges', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5700', '', 'Office Supplies', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5760', '', 'Rent', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5765', '', 'Repair & Maintenance', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5780', '', 'Telephone', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5785', '', 'Travel & Entertainment', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5790', '', 'Utilities', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5795', '', 'Registrations', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5800', '', 'Licenses', '12', 0);
+INSERT INTO `0_chart_master` VALUES('5810', '', 'Foreign Exchange Loss', '12', 0);
+INSERT INTO `0_chart_master` VALUES('9990', '', 'Year Profit/Loss', '12', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `0_chart_types`
+--