Importing a chart of accounts is additive, the import will add accounts to the existing chart of accounts, but won’t remove any duplicate or QuickBooks online default accounts. When the user imports the chart of accounts, the type and detail type must exactly match the types available in QuickBooks. If you are also looking for the guide to import the charts of accounts in QuickBooks desktop, then reading this post can be of great help. For more details, you can also get in touch with our QuickBooks support team . Our experts will be happy to help you.
Requirements to import file
Before you import the charts of accounts, it is important to first ensure that you have considered and fulfilled all the requirements:
- The very first requirement is that the import file size should be limit to 2MB or 1000 rows per import
- And the file must be in excel and must have the account type and name fields
- The next thing to consider is that the users can import sub accounts by using the parent account name
- And also, all columns must include the heading
Steps to Import Chart of Accounts into QuickBooks
Importing Chart of accounts into QuickBooks Desktop with saas Ant Transactions application is a breeze with our simplified and powerful Import wizard. Just follow a simple 3 step process to bulk import chart of accounts into QuickBooks from Excel.
Click the Import button in the Dashboard screen or Import option from the File menu in the menu bar to navigate to the File Selection screen of the Import Wizard (Step 1).
- Step 1 – File Selection: Select “QuickBooks Transaction Type” as “Account”. “Select Your File” – You can either click “Browse File” to browse and select the file from the local computer folder or click “Sample Templates” to navigate to saas Ant sample file locally.
- Step 2 – Mapping: Set up the mapping of the file columns corresponding to QuickBooks fields. This step will be automated for you if you use the saas Ant template file. Download the Sample Template file.
- Step 3 – Review & Import: Review your file data in the Review Grid screen and click “Send to QuickBooks” to upload your file data to QuickBooks.
Steps to import charts of accounts into QuickBooks desktop
- The very first step is to log in QBO account
- And then select the gear icon present in the top right-hand corner of the page
- After that, the user needs to click on import data
- Tap on the chart of accounts icon
- And then, click the links that says download a sample file
- And also open the downloaded file and clear the sample data
- The last step is to copy the data in one column at a time
We end this post over here with the hope that the information we have shared in above might help the user in importing the charts of accounts in QuickBooks desktop with much ease. However, if the error persists call us at our toll-free number +1-844-405-0906. Our experts and certified QuickBooks desktop support professionals will be happy to help you.
Read Also: Market watch hub