cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
userplanetyvette
Level 1

I just imported my general ledgers with amount but QB only got the GLs, no amount. How do I import in chart of accounts that includes the amount?

 
2 Comments 2
RenjolynC
QuickBooks Team

I just imported my general ledgers with amount but QB only got the GLs, no amount. How do I import in chart of accounts that includes the amount?

Happy new year, userplanetyvette.

 

I'll share some details and steps regarding your concern.

 

When you import the Chart of Accounts from a spreadsheet in Excel or CSV format, QuickBooks Online will not request for you to enter your opening balance. This is to make sure that you enter the real-life bank account balance for the day you pick.

 

After the import, you can manually edit each account and enter the amount by following these steps:

 

  1. Go to Accounting > Chart of Accounts.
  2. Find the imported account and click the drop-down arrow next to the View register link.
  3. Select Edit.
  4. In the Account window, enter the amount in the Balance field and add the as of date.
  5. Hit Save once done.

I've got a sample screenshot for a visual reference:

 

 

You can follow the same process for the other imported accounts. 

 

I'm also adding this article for more details: Move your chart of accounts to QuickBooks Online. If you need help managing your QuickBooks Online account, you can browse our other articles here.

 

Please press the Reply button below if you have more questions for QuickBooks Online, I'd be glad to help you out again. Take care!

Fiat Lux - ASIA
Level 15

I just imported my general ledgers with amount but QB only got the GLs, no amount. How do I import in chart of accounts that includes the amount?

@userplanetyvette 

You may need a 3rd party tool to import data as the beginning/opening balance of each account.