How You Can Import A Chart of Accounts Into QuickBooks Pro

Our impartial reviews and content are supported partly by affiliate partnerships. Find out more.

How to Import A Chart of Accounts Into QuickBooks Pro

Developing a proper chart of accounts is among the most significant (and frequently overlooked) things new QuickBooks Pro users must do. If you’re already acquainted with business and accounting, this can be no real surprise. Fortunately for you personally, in case your company already has a chart of accounts, it can save you some serious time by importing (or uploading) it instead of getting to recreate it one account at any given time.

Within this publish, we’ll educate you the way to import your chart of accounts in five easy steps.

Table of Contents

Import Your Chart Of Accounts

To import your chart of accounts, begin by visiting Lists>Chart of Accounts>Accounts>Import from Stand out.

Note: QuickBooks Pro recommends creating a backup company file before importing your chart of accounts.

Step One: Choose The Appropriate File

Click “Browse” and select the Stand out file together with your chart of accounts inside it.

How to Import A Chart of Accounts into QuickBooks Pro

Once you discover the right file, click “open.”

Step Two: Pick A Sheet

Choose the sheet your computer data is on.

How to Import A Chart of Accounts into QuickBooks Pro

Step Three: Produce A New Mapping

Next, it’s important to produce a new mapping. A mapping is essentially the way you tell QuickBooks to import your posts.

In all likelihood, the column headings inside your Stand out file will vary from the column headings QuickBooks uses. So rather of getting to modify your Stand out file, you may create a brand new mapping rather. Think of the like a big matching game.

Make use of the drop-lower menu to decide on the Stand out column you would like mounted on each QuickBooks heading. For instance, we would like our “Account Name” column in Stand out to complement the “Name” column in QuickBooks, therefore we clicked “Name” and selected the right Stand out column.

How to Import A Chart of Accounts into QuickBooks Pro

It can save you the next chart of accounts information in QuickBooks:

  • Type
  • Number
  • Name
  • Description
  • Banking Account Number/Charge Card Number
  • Opening Balance
  • By (Date)
  • Help remind Me To Buy Checks After I Print Number
  • Track Reimbursable Expenses
  • Earnings Take into account Reimbursable Expenses
  • Is Inactive

Once all your column headings are mapped, remember to include a mapping name towards the top of the screen before clicking nowhere “Save” button in at the end from the screen.

How to Import A Chart of Accounts into QuickBooks Pro

Step Four: Import Your File

Finally, you are prepared to import your chart of accounts. Just click nowhere “Import” button and you’re all set.

Step Five: Agree To The Display Message

If this sounds like the first import, you will see a popup box warning that you simply can’t undo imported information. Just click “yes” to accomplish the import.

How to Import A Chart of Accounts into QuickBooks Pro

Congratulations, you’ve effectively imported your chart of accounts into QuickBooks Pro! What’s promising? Since you have been through one effective import, the remainder won’t appear so frightening.

For those who have any troubleshooting issues, take a look at the QuickBooks Community or call QuickBooks directly. For those who have any more questions, leave a remark below and we’ll do our very best that will help you.

Keep watching our QuickBooks Pro 101 series to learn to import your contact and products next.

Chelsea Krause

Chelsea Krause is really a author, enthusiastic readers, and investigator. Additionally to loving writing, she grew to become thinking about accounting software due to her constant need to learn something totally new and know how things work. When she’s no longer working or daydreaming about her newest story, she are available consuming obscene levels of coffee, studying anything compiled by C.S. Lewis or Ray Bradbury, kayaking and hiking, or watching The X-Files together with her husband.

Chelsea Krause



Todays Most Sophisticated eCommerce Solution