General Ledger detail report for a range of accounts (or for all subaccounts of a parent account)

It's nice to see you here, @mfeirman,

Yes, you can filter accounts in a General Ledger using the Customize option. On the General Ledger report, click the Customize button and add the accounts under Distribution Account and Account filters.

Check out our Reports Help page to learn more about what preference are available in QBO reports and how to use them: Reports Hub for QuickBooks Online.

If you have any questions or need further help with anything in QBO other than reports, feel free to visit us anytime. You can also mention my name on your posts and I'll be more than glad to help. Have a nice day!

I understand I can select specific accounts. However, I want my selection to be dynamic, and catch all new accounts in a specific number range as they are added to my chart of accounts. I do not want to keep going into the filter criteria and checking all of the new accounts in the range as they are created.

Hi mfeirman,

Choosing a parent account will indeed be more efficient than having to go through each of the sub-accounts. You can actually do this. When you filter the parent, the subaccounts will be included in the report as long as they are used in a transaction in the period you specified.

Below is a sample GL where I filtered a specific parent account.

BEFORE

AFTER

That's it. If you need further assistance, just let us know in the Reply section below.

This worked for my expense account (Distribution Account filter). However, this did NOT work for my balance sheet parent account (Account filter).

Hello there, @mfeirman.

Currently, we're unable to filter the sub-accounts in the Balance Sheet report. Though, you can directly run report the sub-accounts in the Chart of Accounts window.

Here's how:

1. Go to the Accounting menu, and then Chart of Accounts.

2. Choose the sub-accounts you want to run.

3. Click the View register drop-down arrow, and then Run report.

4. The Account QuickReport window will open.

I've also added this link about running and customizing reports in QBO. It can help you filter specific transactions you'll want to see in the reports window:

• Run reports in QuickBooks Online

• Customize reports in QuickBooks Online

Please know that you can always get back to us if you have other questions about QuickBooks. I'm always here to help you out.

I am not following.  I want to run a general ledger detail for a range of accounts (one range is in the balance sheet, and one range is in expenses). Both of these ranges also happen to be structured as subaccounts to a parent in the chart of accounts. What is the best way to get the transaction detail so that I do not have to keep selecting the accounts every time I run the report. Notre that the number of accounts will continually increase, as we add accounts often in these account ranges.

Hello there, @mfeirman.

We can run the Transaction Detail by Account to see the sub-accounts.

Here's how:

1. Go to the Reports menu.

2. On the search bar, type Transaction Detail by Account.

3. Click the Customize button.

4. Select the Filter drop-down arrow, and then choose the transactions you want to show in the report.

5. Hit Run report.

I'm also adding a reference here for ideas about your report data and other related tasks: Reports and Accounting.

You can count me in if there's anything else you need. Take care always, 

mfeirman.

I transitioned from the desktop to the Online version. I cannot figure out how to run a detailed report that breaks out all transactions coded to each account in the Chart of Accounts. I found a report that can be run for the transactions that are contained in an individual account.

For example, if I had 50 accounts that I code my transactions to, ranging from Advertising to Supplies, how do I run a detailed report that will reflect the transactions in each account for the year? The desktop version had this option; is it still available in the online version or do I have to run 50 separate reports for each account?

Nice to have you joined this thread, @sv2022.

You can run the Transaction Detail by Account as shared by my colleague Maybelle_S above. Then filter it to show all the accounts you need to see. Let me show you how.

1. Go to the Reports menu in your QuickBooks Online (QBO) account.
2. Type in Transaction Detail by Account in the search field.
3. Click Customize.
4. Adjust the date range of the report.
5. Select the Filter section and click the Accounts box, select the accounts you want to show from the drop-down menu. 
6. Click Run report.

You can also see this article for the complete details: Customize reports in QuickBooks Online.

You might want to memorize your report to save its currents settings. This way, you can easily access the same data without going through the customization process again.

If you need more help managing your reports in QBO, please don't hesitate to tag me in your reply. I'll be more than happy to help you out anytime. Keep safe!

I had the same issue. Try customize, click Distribution Account and then select the accounts you want to show on your report  instead of clicking Account to select your accounts. This worked for me. 

Is there a way to print General Ledger detail in Quickbooks desktop?

Hi there, CFF61.

I'm here to help you print reports in QuickBooks Desktop (QBDT).

Yes, there is. The steps to do this are pretty quick and easy. Here's how to do it:

1. In QBDT, go to the Reports menu at the top.
2. In the dropdown, choose Accountant & Taxes, then General Ledger.
3. Once pulled up, click the Print option at the top, then select Report in the dropdown.
4. Hit Print.

In case you encounter some printing errors, check out these articles for the detailed steps on how to fix them:

• Fix printing issues in QuickBooks Desktop.
• Fix PDF and Print problems with QuickBooks Desktop.

I'm also adding this article that tackles customizing reports in QBDT for future reference: Customize reports in QuickBooks Desktop.

Please let me know if you have additional questions about this or anything else. I'll be here to assist. Stay safe.