Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
tawarren63
Level 1

How do I create a trial balance report filtered by class?

I am managing 3 sub companies under on account by using the classes.  I need to generate individual trial balances for each sub company.  I am a proficient Sage Intact user and that software has a robust report writer that allows me to create just about any report.  I am performing financial reviews on the side for a couple of clients and they both use QBO.  Is there a way to get a report writer in QBO that allow from more customization, or can a custom report be generated by Intuit?
5 Comments 5
ShyMae
QuickBooks Team

How do I create a trial balance report filtered by class?

Warm welcome, tawarren63. I understand you want to generate and filter the trial balance report by class.

 

Currently, the trial balance report is unable to filter class. However, you can run the General Ledger or Transaction Detail by Account report to filter transactions by class.

 

  1. Hover to the Reports, then enter General Ledger or Transaction Detail by Account in the search bar.
  2. Click Switch to classic view, then tap Customize.
  3. Click Change columns and tick Class. 
  4. Click Filter, then tap the Class dropdown and select a specific customer if necessary. 
  5. Once done, hit Run report

 

I've included a screenshot for reference.
 



 

You can export the Trial Balance and Transaction Detail report and consolidate both. You can manually add a class column and input the necessary details in their respective rows.

 

Moreover, you have the option to memorize the reports you've customized. This way, you won't have to do the customization process again. 

 

I'm always around, ready to support you whenever you need information about customizing reports in QuickBooks Online. You can click the reply button below and enter your queries. 

9Ross9
Level 1

How do I create a trial balance report filtered by class?

Hi,

I am also in the same situation, with a couple companies using QBO that have sub funds/classes. Is QBO working at building the functionality to have a Trial Balance by class? I would think it would be pretty straightforward if they already do the GL.

Thanks,

Ross

FateCandylaneT
QuickBooks Team

How do I create a trial balance report filtered by class?

I can see that every business has definite needs, 9Ross9.

 

It's crucial to ensure that all your transactions are entered accurately to maintain well-balanced books. Keeping track of these entries with specific classes recorded on them will help you identify the profitability of your company. However, the ability to run Trial Balance by Class report is unavailable in the program. As a workaround, you can follow the information shared by my colleague above.

 

For now, you can send your valuable feedback directly to our product engineers to allow this option when running reports. They may consider your suggestion and will work on its progress to include them in future product updates. To do this:

 

  1. Go to the Gear icon and select Feedback.
  2. Enter your product suggestions or feedback.
  3. Then, click Next to submit.

 

In addition to that, you can also visit our QuickBooks Online Blog to be updated with our latest news and updates, including product improvements.

 

Moreover, I'm sharing this reference to help you review your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

If you need further assistance with managing transactions in your account, feel free to let me know in the comments below. Take care, and have a great day!

sfulford
Level 1

How do I create a trial balance report filtered by class?

Why is it important to accurately classify these transactions if Quickbooks then doesn't accurately report them? Word to wise, don't use the class functions assuming the actually full function in Quickbooks for the required reports your business will need to produce. 

BigRedConsulting
Community Champion

How do I create a trial balance report filtered by class?

Like a balance sheet, the trial balance will rarely balance (if ever) when filtered by class.

 

You can of course filter it by class using QuickBooks Desktop, but the results don't balance and don't seem useful to me.

 

These reports are designed to total all transactions for a date range by account. In most all cases, if they're filtered by some other thing, like class, the results are non-nonsensical.

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

Need to get in touch?

Contact us