cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Vignesh_touchkin
Level 1

How to generate trial balance report with opening balance, debit transactions, credit transactions and closing balance in QB?

Tried all the customization options available in QB. Couldn't find any feature that could help me. Please guide me on how to do the same.

1 Comment 1
CarlSJ
QuickBooks Team

How to generate trial balance report with opening balance, debit transactions, credit transactions and closing balance in QB?

Customizing the Trial Balance report with your desired details is unavailable in QuickBooks Online (QBO), Vignesh. Allow me to provide an alternative way.

 

Please know that the Trial Balance in QBO shows the closing balance of each account over a given period to ensure the debit and credit balances are equal.

 

Meanwhile, you can generate a Transaction Detail by Account or General Ledger report that provides a detailed view of all transactions sorted by accounts such as Debit, Credit, and Balance as a workaround:

 

  1. Sign in to your QBO account.
  2. Go to the Reports tab.
  3. Search for Transaction Detail by Account or General Ledger report.
  4. Adjust the Report Period if necessary.
  5. Click on the Settings or Columns button to make customization.
  6. Put a checkmark on your desired details.

    Transaction-Detail-by-Account.png

    General-Ledger.png

  7. Click Refresh Report or Run Report.

 

Additionally, you can export the reports to Excel and manually combine each report's details.

Transaction-Detail-by-Account-Export.png

General-Ledger-Export.png

 

Furthermore, you can check out this article to save the current customization of your report and use it in the future: Memorize reports in QBO.

 

Let me know if you need additional help generating a report in QBO with your desired details. Have a good one.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us