cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Buck Tsai
Level 2

Does any one know how to extract general ledger from QuickBooks online with account type information?

I need to extract detailed ledger transaction with ACCOUNT TYPES infomation. does anyone know how to do it?
6 Comments 6
MJoy_D
Moderator

Does any one know how to extract general ledger from QuickBooks online with account type information?

I can help you with extracting your General Ledger with Account Type in QuickBooks. 

 

You can generate the Account List report in QuickBooks Online (QBO). It'll provide you with the name, type, and balance for each account in your chart of accounts. Once done, you can extract or export it to either Excel or PDF

 

Here's how to run the report:

 

  1. Go to Business overview, select Reports, then enter Account List in the Find report by name field.
  2. Click to run the report. 
  3. Select the Customise button to add all the information needed.

 

Refer to this article for more information about generating and adding all the information needed in your report: Customise reports in QuickBooks Online.

 

Here's how you can show both Debits and Credits for each transaction in QBO: Create a report that shows Debits and Credits for each transaction

 

Let me know if you need further help with extracting your General Ledger with Account Type in QuickBooks. I'm always glad to help in any way I can. Have a great rest of the day!

Buck Tsai
Level 2

Does any one know how to extract general ledger from QuickBooks online with account type information?

Good day MJoy_D for quick response

 

Kindly see attached screen shot...

 

I have been using QBO since 5 years ago, and since that time until now, QBO has not develop an option to TICK " account type" while one extracting detailed ledger.

 

In the past 5 years, i always have to extract separate account list report, then do a VLOOKUP to fill in the account type....which is very time consuming.

MJoy_D
Moderator

Does any one know how to extract general ledger from QuickBooks online with account type information?

It's my pleasure to help, Buck

 

I can see the importance of having the Account Type when running the General Ledger report. That would be a great addition to the current features that we have, so I’ll take note of it. I also encourage you to leave feedback from within the product. 

 

Here are the steps:

 

  1. Go to the Gear icon and select Feedback.
  2. Provide your product suggestion. 
  3. Click on Next to submit feedback.

 

You can check out this article for more information about providing feedback to make the program better: How do I submit feedback?.

 

Here's also how you can change account types: Change the type of an existing parent account or subaccount in QuickBooks Online

 

I'm always here if you have additional concerns about General Ledger. I'm always here to assist. Have a wonderful day!

Buck Tsai
Level 2

Does any one know how to extract general ledger from QuickBooks online with account type information?

Good day MJoy_D

 

Thank you for below reply. I sincerely wish that this additional option/ box could be added before end of this year.

 

On the other note about the FEEDBACK. I have lodged feedback continuously for this identical issue for the past 4 years already.......

 

I do not know how QBO overlook this basic info that is hugely important when an accountant need account type info when doing AFS/ VAT recon, etc. 

 

It would be greatly appreciated that if you could help us ( the other accountants out there having identical issue) to resolve this issue asap.

Buck Tsai
Level 2

Does any one know how to extract general ledger from QuickBooks online with account type information?

Good day MJoy_D

 

On the other note, may i ask another query?

 

I used to use google chrome to open QBO because i can open multiple TABs to work with.

 

However, i do not know WHERE i made the adjustment, but now, whenever after i successfully lodge into a company working page, and like to go to TOP tab section and add additional tab, then the original tab somehow loos its connection?

MariaSoledadG
QuickBooks Team

Does any one know how to extract general ledger from QuickBooks online with account type information?

Let me provide some information about why this is happening. This will guide you on what you'll have to do. Buck Tsai.

 

Leaving tabs open because you want to go back may sometimes cause tab overload. Every tab that you open is sipping at your system resources and clutters up your browser. Therefore, it leads to slower performance. That is the reason why you're experiencing the issue.

 

You'll want to press F5 to refresh. Aside from that, this reloads the page or document window. 

 

Furthermore, you may want to get familiar with some of the main features of QuickBooks Online, I've added this article for more information: Get Started With QuickBooks Online.

 

Let me know if you have any other concerns with QuickBooks. We're always right here to further assist you.