You can import an existing Chart of Accounts into QuickBooks Online. Before you start, it's important to understand all the information in the following sections:
|Warning: Imports cannot be undone.|
Reminders before you import
Importing a Chart of Accounts is additive, meaning your import will add accounts to your existing Chart of Accounts, but won't remove any duplicate or QuickBooks Online default accounts.
When you import your Chart of Accounts, the Type and Detail Type must exactly match the types available in QuickBooks Online, including capitalization. If they don't match, you'll either get a red error message and will have to change each line manually, or your import operation will fail.
Currently, you cannot add new Types or Detail Types as they are hard-coded in the system. You must select the best fit for each account.
File requirements for import
- The import file size limit is 2 MB or 1000 rows per import, but if your import file is larger, you can do multiple smaller imports.
- The file to import must be in Excel or CSV format, and must have Account Type and Name fields. If you'd like, you can download our sample file.
- You can import sub-accounts by using the parent account name, followed by a colon and by the sub-account name (for example: parent:sub-account).
- Account numbers should not be left blank and should not include decimal points.
- All columns must have headings, even if the column is empty or has no data.
Import your Chart of Accounts
- Go to Settings ⚙︎, then select Import Data.
- Select Charts of Accounts.
- On the Import Accounts page, select Browse.
- Find the Excel file to import, then select Open.
- Select Next to continue.
- Map your data, then select Next.The next page shows the accounts that are ready to be imported. You'll be prompted with instructions if you're missing critical fields, such as Choose type or Choose detail type.
- Adjust your data if necessary, then select Import.
Error messages and issues
You may get the message Error while reading the file. Format may be incorrect.
If this happens:
- Make sure the headings in columns A-D are: Account Number, Account Name, Account Type, and Detail Type.
- Every column has a heading. If not, entering headings should clear the error.
- There should be no heading and column in the sheet for Description.
Need a new company file?