Move your Chart of Accounts to QuickBooks Online


QuickBooks is one of the fastest-growing accounting software which is known by everyone. It is one of the finest accounting software which is building the latest relations between users and organizations. Let’s start our article about the “Move your Chart of Accounts to QuickBooks Online“. The Chart of Accounts is a list of collections of your all company’s accounts and balances. QuickBooks software uses this collection to manage the transactions on your reports and Ta forms. Chart of accounts also organizes your transactions so that you always know what money you are having and owe in the accounts.

How to Move your Chart of Accounts to QuickBooks Online:

Below 5 steps are mentioned to move your chart of accounts to QuickBooks Online.

Total Time: 20 minutes

Step 1 – Make your Spreadsheet Ready

🔹 First, import your chart of accounts in excel or CSV file format. Below steps are ready to upload it to QuickBooks.
🔹 Open your existing spreadsheet of the accounts and if it is not existing create a new one.
🔹 You can also export the chart of accounts from other QuickBooks company
🔹 Don’t forget to include below columns in your sheet
Account name
Account Type
Detail Type

🔹 If you are organizing the accounts by numbers you need to add the account number column. If you don’t use account number skip this step
🔹 If you have any sub-account, add it in the account name column in below format: Main account: Subaccount
🔹 Once everything is done save your spreadsheet in Excel or CSV format

Step 2 – Upload the Spreadsheet

🔹 First Sign in to QuickBooks Online company
🔹 Go to Settings >> Import data
🔹 Select the chart of accounts
🔹 Select Browse, search your sheet which you have saved
🔹 Click on Next

Step 3 – Match the Fields with the QuickBooks Fields

After uploading the spreadsheet, make sure your accounts get imported correctly.
Select every small row in your field column. Now match the columns in the spreadsheet to below QuickBooks fields:

🔹 Detail Type
🔹 Account Name
🔹 Account Number
🔹 Type

NoteIf you any field except Account Name select No match which doesn’t have a matching column in the spreadsheet.

🔹 Select Next

Step 4 – Import your Chart of Accounts

🔹 Its almost done. Check everything last time before saving
🔹 If you did not yet, make sure to add types and details types (You may focus on account type first, then select the details type which fits the transactions you want to track)
🔹 If you found any field highlighted in Red which shows that you need to fix that info.
🔹 Move your pointer over a highlighted field to see the description which you need to fix
🔹 Uncheck any account you don’t want to save
🔹 Once everything looks fine, Select Import
🔹 To see your imported accounts go to settings>>chart of accounts

Step 5 – Mention the Opening Balance for Accounts

🔹 Once every account is in QuickBooks, mention your opening balance for a bank, credit card, and other accounts.
🔹 An opening balance is the starting point for every account which is created in QuickBooks.
🔹 It summarizes all past transactions in your real-life account until opening the balance date.
🔹 Go to Settings >> Chart of accounts
🔹 Search your bank or credit card
🔹 Select the small arrow in the Action column, then edit
🔹 To date, tell QuickBooks when you want to start your account. It will set the starting point
🔹 For Balance, enter the amount in the account as of the date you select.
🔹 Once all is complete save and close

Your chart of accounts manages and give you the information about the below things:

  • Liabilities: The amount which you need to pay and it is owing to you
  • Income: Money which you gets a day to day business tasks from sales revenue or income
  • Expenses: This is the money which you spend on expenses related to normal business operations, like advertising, promotion, office supplies, etc
  • Assets: It consists of vehicle, equipment, building, and other things used for business

You can easily access the chart of accounts through settings >> Chart of accounts

5 Steps to Move your Chart of Accounts to QuickBooks Online

Tips to Manage the Chart of Accounts Efficiently

Many accounting systems come with the chart of accounts line included with the headers such as “1430.2” and “530.8”. These numbers could be for large accounting firms, sometimes they are often not important for entrepreneurs and small businesses. While settings up your lines for the first time, keep it simple. Remember to make the title in that way so that anybody can understand the same including you and your accountant. You can use the straightforward name like “bank fees” and “bottling equipment”.

With time sometimes you need to create a new line item for each transaction. It may be confusing to navigate. Take the benefit of accounting software sub-accounts.

Now connect your bank or credit card to bring in your transactions. If you connect QuickBooks categories and download your transactions for you. You just need to review and approve the same.

How to Optimize your Chart of Accounts in QuickBooks:

Hundreds of user are using the chart of accounts, below are some tips through which anyone can optimize the chart of accounts:

  • Don’t stick with the default – Default chart of accounts provides you a canned set of reports based on the information you select. This is helpful but you can add chart of accounts and customize it as per your need
  • Order is everything – Default chart of accounts show the list in alphabetical order. Reorder this hart to make sure that it accurately reflects your business needs.
  • Take the advantage of Parent and Subaccounts – Priority is the best things and you also should use parent and subaccount to allow you to see your business result in the most useful way
  • Use classes and customer – Keep your chart of accounts simple, and add exact tags for everything which will show a clean report
  • Don’t guess when it comes to Bookkeeping – Do all the transactions properly, Your statements are good till good information is going to them. Whoever is using your chart of accounts should have a solid understanding

Get in touch

Whatever the concern is we have a solution for everything related to your QuickBooks issues such as move chart of accounts and import chart of accounts in QuickBooks online. You can also email at and get in touch with the QuickBooks Helpdesk. QuickBooks proadvisor support are always available 24*7 to assist you with the solutions. Just connect with the experts and get the quality solutions for your business.