Skip to main content
September 28, 2022
Question

Is there a detailed trial balance report in Quickbooks Online?

  • September 28, 2022
  • 1 reply
  • 0 views
I need a detailed trial balance report that shows the debit and credit for each transaction for a specified date range. Is this available? I am not seeing this and cannot seem to get the Transaction Detail by Account report to work in this manner either.

1 reply

September 28, 2022

Hi, nelsonvilleIkslo.

 

I'm here to ensure you'll be able to get the detailed Trial Balance report in QuickBooks Online (QBO).

 

Currently, the option to filter the Trial Balance report to show the main accounts only isn't available.

 

The goal of this report is to list all accounts on the Chart of Accounts and their totals as either debits or credits. Unlike a balance sheet, a trial balance doesn't group accounts by type and shows totals as debits and credits. 

 

However, we can click the amount of the trial balance to show the associated transactions, and then, we can export it to Excel to make such modifications or any other changes that we need.

 

Here's how:
 

  1. On the Trial Balance Report window, click the Export icon.
  2. Tap Export to Excel.
  3. Open the downloaded file.

 

You can also check out this article to learn more ways to organize your accounts: Organize your Chart of Accounts.


Additionally, I included a guide on how to memorize a report. This way, you'll no longer go over the same customization process and save the reports you've opened.

 

Stay in touch if you have additional questions about opening a Trial Balance report by leaving a comment below. I'll be around in the Community to help you out.