2020-03-31 10:18:48getting-startedEnglishImport Chart of Accounts in QuickBooks: “Import data” feature enables you to bring your previous financial data easily in QuickBooks.https://quickbooks.intuit.com/in/resources/in_qrc/uploads/2020/01/AS-7-Construction-Contracts-Its-Disclosure.jpghttps://quickbooks.intuit.com/in/resources/getting-started/how-to-import-chart-of-accounts-in-quickbooks/How to Import Chart of Accounts in QuickBooks?

How to Import Chart of Accounts in QuickBooks?

1 min read

Are you struggling to bring your previous financial records in QuickBooks? Are you worrying that your previous data will be lost while switching to QuickBooks? No, not at all. QuickBooks “Import data” feature enables you to bring your previous financial data easily in QuickBooks. Learn in this blog how to do it:

  • Log in to QuickBooks
  • Select the “Gear icon” on top right and select “Import data” (see below screenshot) under “Tools”

chart of accounts in quickbooks

  • Select ‘Chart of Accounts’ from the Import Data screen. (see screenshot below)

qb chart of accounts

  • ‘Import Account Window’ Opens up. ‘Download a sample file’ to get an idea on the data template that you need to prepare using your previous account data.

chart of accounts

The downloaded sample accounts data looks like this:

qb chart of accounts

  • Seeing the sample file format and data fields, prepare your previous account data in the same format. Once it is ready, save the file. Click ‘Browse’ to select the ‘file to upload’ (note: to upload, the file format should be .xls or .csv). Click Next.

qb chart of accounts

  • ‘Map data’ window appears. Once you map all the fields, fields appear with green tick box next to it. This means fields have been mapped after careful checking. Click Next.

import chart of accounts

In the import window, you find  a few fields mentioned under ‘type’ and ‘detail type’ are not correctly mapped and these are highlighted in ‘Red’

qb chart of account

  • Update the fields highlighted in red until all turn green.

import data in quickbooks

  • Now click ‘import’ and you will get a message mentioning 5 of 5 accounts have been imported successfully.

So,  why waiting? Import your previous chart of accounts data today in QuickBooks by following the above steps quickly.

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

Best Ways for Accountants to get Referrals

Getting clients through referrals is a powerful way to boost sales and…

Read more

How to Accept Digital Payments During COVID-19

In this article, you will learn: What are Digital Payments? Benefits of…

Read more

Impact of COVID-19 on Financial Reporting

To guide auditors as well as chartered accountants, ICAI has developed an…

Read more