Showing results for 
Search instead for 
Did you mean: 
Level 1

Importing chart of accounts

 at 15:57, Jan 2:
Hi. I need to run an end of year Balance Sheet, but I have 2 companies on QB online (In August we went from being an LLC to Inc. so I set up the new, Inc. account when all this happened). We don't have a ton of transactions (we're a startup), so I've been manually creating new accounts on the new company, but now that I need to run a year-end Balance Sheet, should I just import the old chart of accounts, and if I do this, will the balances for each chart account carry-over to the new company? 
1 Comment 1

Importing chart of accounts

Thank you for contacting us, mjlandaverde.


Importing accounts in QuickBooks Online (QBO) only includes the account number, name, type, and detail type. Therefore, it won't carry over the balance.


You can refer to the screenshot below to see how your Excel file should look like. Or use this link, Account List to see the actual spreadsheet.


Just a heads up, you can only import lists of accounts, vendors, customers, and products/services. You need to manually enter the balance to the new company file.


Here's how:

  1. Select Accounting from the left navigation bar, then select Chart of Accounts.
  2. Locate each account, then click View register under the Action column.
  3. Click the Add drop-down, then select Journal Entry.
  4. Enter a date that's before the oldest transaction already in your account.
  5. Select Opening Bal Equity for the account, then enter the amount.
  6. Click Save.

You can also refer to this article, Enter an opening balance to learn what to do if you miss to create an account with no balance.


I've added this link, Move your lists to guide you how to import data into QuickBooks Online.


Let me know if you need additional information, and I'm happy to provide them.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up