Import Chart of Accounts

Follow these steps to import your chart of accounts from legacy accounting software into sql-ledger.

  1. Export/prepare your chart of accounts in your spreadsheet software according to the sample given below.
  2. Double check the correctness of your final csv file by opening it in a text editor like notepad or wordpad.
  3. Upload the chart csv file using ‘Import–Chart’ menu option.
  4. Check/uncheck the accounts to be imported and click continue to import the selected accounts.

Here is a sample chart of accounts in CSV format.

accno,description,charttype,category,link
1000,"CURRENT ASSETS",H,A,
1060,"Checking Account",A,A,AR_paid:AP_paid
1065,"Petty Cash",A,A,AR_paid:AP_paid
1200,"Accounts Receivables",A,A,AR
1205,"Allowance for doubtful accounts",A,A,
1500,"INVENTORY ASSETS",H,A,
1520,"Inventory / General",A,A,IC
1530,"Inventory / Aftermarket Parts",A,A,IC
1800,"CAPITAL ASSETS",H,A,
1820,"Office Furniture & Equipment",A,A,
1825,"Accum. Amort. -Furn. & Equip.",A,A,
1840,Vehicle,A,A,
1845,"Accum. Amort. -Vehicle",A,A,
2000,"CURRENT LIABILITIES",H,L,
2100,"Accounts Payable",A,L,AP
2160,"Corporate Taxes Payable",A,L,
2190,"Federal Income Tax Payable",A,L,
2210,"Workers Comp Payable",A,L,
2220,"Vacation Pay Payable",A,L,
2250,"Pension Plan Payable",A,L,
2260,"Employment Insurance Payable",A,L,
2280,"Payroll Taxes Payable",A,L,
2310,"VAT (10%)",A,L,AR_tax:AP_tax:IC_taxpart:IC_taxservice
2320,"VAT (14%)",A,L,AR_tax:AP_tax:IC_taxpart:IC_taxservice
2330,"VAT (30%)",A,L,AR_tax:AP_tax:IC_taxpart:IC_taxservice
2600,"LONG TERM LIABILITIES",H,L,
2620,"Bank Loans",A,L,
2680,"Loans from Shareholders",A,L,AP_paid
3300,"SHARE CAPITAL",H,Q,
3350,"Common Shares",A,Q,
4000,"SALES REVENUE",H,I,
4020,"Sales / General",A,I,AR_amount:IC_sale
4030,"Sales / Aftermarket Parts",A,I,AR_amount:IC_sale
4300,"CONSULTING REVENUE",H,I,
4320,Consulting,A,I,AR_amount:IC_income
4400,"OTHER REVENUE",H,I,
4430,"Shipping & Handling",A,I,IC_income
4440,Interest,A,I,
4450,"Foreign Exchange Gain",A,I,
5000,"COST OF GOODS SOLD",H,E,
5010,Purchases,A,E,AP_amount:IC_expense
5020,"COGS / General",A,E,AP_amount:IC_cogs
5030,"COGS / Aftermarket Parts",A,E,AP_amount:IC_cogs
5100,Freight,A,E,AP_amount:IC_expense
5400,"PAYROLL EXPENSES",H,E,
5410,"Wages & Salaries",A,E,
5420,"Employment Insurance Expense",A,E,
5430,"Pension Plan Expense",A,E,
5440,"Workers Comp Expense",A,E,
5470,"Employee Benefits",A,E,
5600,"GENERAL & ADMINISTRATIVE EXPENSES",H,E,
5610,"Accounting & Legal",A,E,AP_amount
5615,"Advertising & Promotions",A,E,AP_amount
5620,"Bad Debts",A,E,
5650,"Capital Cost Allowance Expense",A,E,
5660,"Amortization Expense",A,E,
5680,"Income Taxes",A,E,
5685,Insurance,A,E,AP_amount
5690,"Interest & Bank Charges",A,E,
5700,"Office Supplies",A,E,AP_amount
5760,Rent,A,E,AP_amount
5765,"Repair & Maintenance",A,E,AP_amount
5780,Telephone,A,E,AP_amount
5785,"Travel & Entertainment",A,E,
5790,Utilities,A,E,AP_amount
5795,Registrations,A,E,AP_amount
5800,Licenses,A,E,AP_amount
5810,"Foreign Exchange Loss",A,E,