Data Exchange
Exchange files with QuickBooks Online. All files use QBO CSV format.
Upload a QBO file
Maximum 2 MB / 1000 rows. The file is validated before any record is updated.
Chart of Accounts 2026-10-18 03:42
validated
Chart of Accounts
|
24 rows
|
23 to review
|
1 errors
| Layer | Message | Done |
|---|---|---|
| error | Duplicate account number 6000 appears 2 times. | |
| review | [Mapped] 1000 Chequing Account -> 111311 Bank | |
| review | [Mapped] 1010 Savings Account -> 111200 Demand Deposits / Notice Deposits in Deposit Accepting Institutions | |
| review | [Mapped] 1100 Accounts Receivable -> 112110 Trade Accounts Receivable | |
| review | [Mapped] 1200 Inventory -> 121120 Goods for Sale Inventory | |
| review | [Mapped] 1300 Prepaid Expenses -> 131200 Prepaid Expenses | |
| review | [Mapped] 1500 Computer Equipment -> 124107 Machinery and Equipment | |
| review | [Mapped] 2000 Accounts Payable -> 221120 Accounts Payable - Other Trade Accounts | |
| review | [Mapped] 2100 GST/HST Payable -> 231000 GST to pay | |
| review | [Mapped] 2110 Payroll Liabilities -> 221206 Employee Deduction Payable | |
| review | [Mapped] 3000 Owner's Equity -> 313000 Owners' Equity (Owners' Investment - No Share Capital Entities) | |
| review | [Mapped] 4000 Service Revenue -> 411200 Sales of Services | |
| review | [Mapped] 4100 Product Sales -> 411100 Sales of Goods | |
| review | [Mapped] 4200 Training Revenue -> 411230 Sales of Services Excluding Commission & Rental | |
| review | [Mapped] 5000 Cost of Goods Sold -> 511200 Purchases and Costs Chargeable to Cost of Sales | |
| review | [Mapped] 6000 Advertising & Marketing -> 512210 All Other Operating Expenses | |
| review | [Mapped] 6100 Bank Charges -> 512210 All Other Operating Expenses | |
| review | [Mapped] 6200 Insurance -> 512207 Purchased Materials, Supplies and Services | |
| review | [Mapped] 6300 Professional Fees -> 512207 Purchased Materials, Supplies and Services | |
| review | [Mapped] 6400 Office Supplies -> 512207 Purchased Materials, Supplies and Services | |
| review | [Mapped] 6500 Rent -> 512207 Purchased Materials, Supplies and Services | |
| review | [Mapped] 6600 Utilities -> 512202 Energy (Including Vehicle Fuel), Water and Telephone/Telecommunication Expenses | |
| review | [Mapped] 6000 Marketing -> 512210 All Other Operating Expenses | |
| review | [New in QBO] 1020 Petty Cash has no Odoo account. |
