We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

How to Import Chart of Accounts into QuickBooks Desktop? | Forum

Topic location: Forum home » Support » General Questions
Lillian Martin
Lillian Martin May 25 '23

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 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 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

 

See Also:  QuickBooks Point of Sale Error 176104


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 at 1-888-351-0999. Our experts and certified QuickBooks desktop support professionals will be happy to help you.

Peter Groft
Peter Groft May 30 '23

To import a chart of accounts into QuickBooks Desktop, you can follow these steps:


Prepare your chart of accounts: Ensure that you have your chart of accounts in a compatible format for import. QuickBooks Desktop supports importing from Excel (.xlsx, .xls) or comma-separated values (.csv) files. Make sure your chart of accounts data is organized with appropriate columns and headers.


Open QuickBooks Desktop: Launch QuickBooks Desktop on your computer.


Access the Chart of Accounts: From the main menu, go to "Lists" and select "Chart of Accounts" to open the Chart of Accounts window.


Enable Import: In the Chart of Accounts window, click on the "Account" drop-down menu and select "Import from Excel" or "Import from CSV" (depending on your file format).


Locate and select the file: Browse your computer to find the file containing your chart of accounts data and select it.


Map the fields: QuickBooks will prompt you to map the fields in your import file to the corresponding fields in QuickBooks. Match the columns in your import file to the appropriate QuickBooks fields (e.g., Account Name, Account Type, etc.). You may need to create a custom mapping if the columns in your import file don't directly match the QuickBooks fields.


Review and confirm: Once you have mapped the fields, QuickBooks will display a preview of the import. Review the preview to ensure the data is correctly aligned. If everything looks accurate, click "Import" to proceed with the import.


Complete the import: After the import process is complete, QuickBooks will notify you of any errors or issues encountered during the import. If there are errors, you may need to correct them in your import file and repeat the import process.


Greetings,
Peter