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

Custom Trial Balance

Is it possible to create a custom trial balance that includes both the account info & the class info?

3 Comments 3
KlentB
Moderator

Custom Trial Balance

Good day, luannsanford.

 

I'm here to share some insights on how Trial Balance works in QuickBooks Online.

 

The main function of the Trial Balance report is to show the total debit and credit balances of each account during a period of time. Thus, we're unable to add additional details, like account information and class. If you need them to be included in the report, I'd recommend exporting the Trial Balance and Balance Sheet Detail reports to an Excel file. Then, combine the related columns outside of the program. Here's how:

 

  1. Go to the Reports menu.
  2. Open the Trial Balance and Balance Sheet Detail reports.
  3. Set the appropriate reporting date and accounting method.
  4. Click Run report, then select the Export icon.
  5. Choose Export to Excel, then customize the data.

I've also added some resources that will help you speed up the reporting process in the program:

 

Do you have any other questions in mind? Just leave them below and I'll get back to you as soon as I can. 
 

shannonm@fccdc.o
Level 1

Custom Trial Balance

Is it possible to customize the accounts that are listed on this report?  Im trying to see the FY-end balances on several accounts but not all of them

JessT
Moderator

Custom Trial Balance

Hello shannonm,

 

I hope you're having a good day! Thank you for joining the conversation.

 

Due to the simplicity of the Trial Balance report, we're unable to do further customizations down to the detail level, particularly, filtering certain accounts. The closest thing you can do for your case is to set the desired Report period. Then, export the report to Excel so you can remove the accounts you don't need.

 

On the other hand, if you need some references for QBO, you can check out our help articles

 

Feel free to go back to this thread if you have any other concerns about reports. Take care and have a good one!