How To Import A Chart Of Accounts Into QuickBooks Pro
If you use QuickBooks Pro, don’t waste time creating a chart of accounts. Instead, save time by importing your chart of accounts right into your accounting software.
In this post, we’ll teach you how to import your chart of accounts into QuickBooks Desktop Pro in five simple steps.
Don’t have a chart of accounts? Start by learning how to create a chart of accounts for your business in just a few easy steps.
Table of Contents
Import Your Chart Of Accounts
To import your chart of accounts, begin by going to Lists>Chart of Accounts>Accounts>Import from Excel.
Note: QuickBooks Pro recommends creating a backup company file before importing your chart of accounts.
Step 1: Select The Appropriate File
Click “Browse” and choose the Excel file with your chart of accounts in it.
Once you find the appropriate file, click “open.”
There are a few requirements for the files that you import to QuickBooks Desktop Pro. Here are a few things to keep in mind.
- File Size: Files are limited to 2 MB or 1,000 rows.
- File Format: QuickBooks Desktop Pro supports Excel and CSV files.
- Sub-Accounts: Sub-accounts may be imported to QuickBooks Desktop by using the parent account name.
- Headings: All columns must have headings.
Before making any major changes to your company file, make sure that you backup your file. Learn more about how to backup your company files in QuickBooks Desktop.
Step 2: Select A Sheet
Select the sheet your data is on.
Step 3: Create A New Mapping
Next, you’ll need to create a new mapping. A mapping is basically how you tell QuickBooks to import your columns.
More likely than not, the column headings in your Excel file will differ from the column headings QuickBooks uses. So instead of having to change your Excel file, you can create a new mapping instead. Think of this as a big matching game.
Use the drop-down menu to select the Excel column you want attached to each QuickBooks heading. For example, we want our “Account Name” column in Excel to match the “Name” column in QuickBooks, so we clicked “Name” and selected the appropriate Excel column.
You can save the following chart of accounts information in QuickBooks:
- Type
- Number
- Name
- Description
- Bank Account Number/Credit Card Number
- Opening Balance
- As of (Date)
- Remind Me To Order Checks When I Print Number
- Track Reimbursable Expenses
- Income Account for Reimbursable Expenses
- Is Inactive
Once all of your column headings are mapped, don’t forget to add a mapping name at the top of the screen before clicking the blue “Save” button in at the bottom of the screen.
Step 4: Import Your File
Finally, you are ready to import your chart of accounts. Simply click the blue “Import” button and you’re good to go.
Step 5: Agree To The Display Message
If this is your first import, you’ll see a popup box warning that you can’t undo imported information. Simply click “yes” to complete the import.
Congratulations, you’ve successfully imported your chart of accounts into QuickBooks Pro! The good news? Now that you’ve been through one successful import, the rest won’t seem so scary.
Import Chart Of Accounts In QuickBooks: FAQs
Final Tips On Importing Your Chart Of Accounts To QuickBooks Desktop
If you have any troubleshooting issues, check out the QuickBooks Community or call QuickBooks directly. Don’t forget to check out the rest of our QuickBooks Desktop Pro 101 Series to learn how to import customers, import items, import vendors, and more.
Overwhelmed by QuickBooks Pro? Maybe it’s time to switch to QuickBooks Online. QBO is easy to use, cloud-based, and affordable. Best of all, you can easily import your QuickBooks Desktop data into QuickBooks Online. Check out our full review on QuickBooks Online for more details.
Outgrown QuickBooks Pro? Switch to QuickBooks Premier. It’s the same QuickBooks Desktop software you love but with more users and advanced, industry-specific features, which we cover in our QuickBooks Premier review.