cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us