Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
queinnacct
Level 1

when importing a chart of accounts can you import the sub and parent account information at that time?

If anyone can share excel import file set up that would be helpful too

2 Comments 2
AdonL
QuickBooks Team

when importing a chart of accounts can you import the sub and parent account information at that time?

Great question, Queinnacct. Yes, you can import parent and sub-accounts in QuickBooks Online (QBO) by formatting your spreadsheet correctly.

 

Whether you are using an existing spreadsheet, creating a new one, or exporting your chart of accounts from another QuickBooks company, ensure you have these columns first:

 

  • Account Name
  • Type
  • Detail Type
  • Account number (optional)

 

Once done, format the sub-account by using a colon (:) to separate the parent account from the sub-account. Example: Main Account: Sub-Account or Utilities: Gas.

 

For more examples of how to format subaccounts, please refer to the table in this article: Importing your Chart of Accounts to QBO.

 

Click the Reply button below if you need further assistance.

AdonL
QuickBooks Team

when importing a chart of accounts can you import the sub and parent account information at that time?

Hi there, @queinnacct.

 

I just wanted to check if the resolution we provided helped you import the Chart of Accounts in QuickBooks.

 

Please let me know if everything is now working as expected or if you’re still experiencing any problems.

 

We’re here to help!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us