Import Charts Of Accounts QuickBooks Desktop
Import Charts Of Accounts QuickBooks Desktop

How To Import Chart Of Accounts QuickBooks

Once you are fully engrossed in QuickBooks, you cannot leave Chart of Accounts that is required to be maintained in some other format. You will surely desire everything to be imported to QuickBooks, right? QuickBooks Charts Of Accounts is a mirror of company earning & expense and play crucial role in tax calculation . A number of situations come when the user wants to import COA into QB, like from switching from QuickBooks Desktop to online version vice versa, or migrating QB from the old computer, workstation to new one. Sometimes a user wants to merge two or more company file in a single QB file in such situation COA need to be imported in a proper manner.

How To Import QuickBooks COA In CSV, Excel

Here is how you do it:
Process 1: Export COA to Excel And then import to QB

  1. Select the Lists menu
  2. Click Chart of Accounts
  3. Choose Report drop-down available at the bottom
  4. Click on Account Listing
  5. Click the Excel button
  6. Follow the instructions that prompt on the screen

Process 2: Import existing COA using QuickBooks Online

  1. Choose the Gear icon available in the top right corner of the screen
  2. Click Import Data
  3. Select Accounts box
  4. Click Browse
  5. Choose the file to be imported
  6. Click Next
  7. Map the fields
  8. Finish the import

Process 3: Import COA using Excel or CSV file
Step I: Prepare your spreadsheet

  1. Open the existing spreadsheet or create a new one or you can also export it from other sources.
  2. Have columns, including Account Name, Account Type, and Detail Type
  3. Organize the accounts using numbers
  4. Also, add an Account Number column
  5. Even if you have a subaccount, you can add it in the Account Number column in a format – Main account: Subaccount (Facilities – Hotel)
  6. Save your sheet in Excel or CSV format

You can also find detailed instruction for QuickBooks Import CSV file step by step process .

Step II: Upload the spreadsheet

  1. Log in to QuickBooks Online company
  2. Move to Settings
  3. Choose Import Data
  4. Now choose Chart of Accounts
  5. Click Browse
  6. Select the Excel sheet or CSV file
  7. Click Next

Step III: Map the fields

  1. In each of the field column, you will have a small arrow
  2. Map the fields with the QuickBooks fields i.e. Detail Type. Account Name, Account Number, and Account Type
  3. Choose No Match for any field that doesn’t exist in your original file
  4. Click Next

Step IV: Import the Chart of Accounts

  1. Check verify and review the details properly as you will have the import summary in front of you
  2. If any of the fields are marked in Red, fix the issue to remove the highlight
  3. You can uncheck the account, the details of which you don’t want to see
  4. Click Import

Step V: Review the COA & start entering opening balances

  1. Go to Settings
  2. Select Chart of Accounts. Review the imported data
  3. To proceed with entering opening balances, find the bank or credit card account
  4. In the Action field, choose the small arrow
  5. Click Edit
  6. In the As of date space, QB asks when you want to start with. Set the start date
  7. Choose the amount on the said date and fill it up in the Balance text
  8. Click Save
  9. Close the window

Importing Charts Of Accounts QB Failed

You can download the sheet in QB when you require it. The steps are properly mentioned. However, if you get stuck anywhere while QuickBooks import of COA, connect with experts available 24*7 on QuickBooks Support Number for assistance.

Related Posts

2 Comments

  • Jenny

    I am using QB 2019 Mac for Desktop. When I run a Balance Sheet Standard Report, the Accounts Receivable line item shows a negative amount. I have processed a transaction that removed some money from the AR account and it shows on the Chart of Accounts that the amount has been removed, but the amount does not change on the balance sheet. how do I change the balance sheet

  • Tony Kukeli

    i need guidance how to export chart of accounts from quicbooks enterprise 2019

Leave a Reply

Your email address will not be published. Required fields are marked *

AccountsPro Disclaimer
Call Now CALL NOW