trial balance report

a standard form of a trial balance report has 4 columns

Beg. Balance             Debit             Credit              Ending Balance 

But, QB just shows Debit and Credit.

How do I customize the report? Do I have to do it myself in Excel?

Hello there, @grunertime. 

Thank you all for taking the time to post in the Community. You'll want to export the Trial balance into an Excel file. 

From there, you can customize the data to show the specific details you wanted. The Trial Balance report only displays the Debit and Credit Column. To filter and export the report, just follow these steps:

1. In the Report period section, filter it to show the data for a month.
2. Click the Export icon and select Export to Excel (see screenshot).
3. Follow the same steps until you're finished with the current year.
4. In the Excel spreadsheet, manually customize the columns the way you'd like them to be displayed.

You can also check these articles for more details: 

• Export reports as Excel workbooks in QuickBooks Desktop
• Customize reports in QuickBooks Desktop 

I'm always available if you have more questions about QuickBooks Desktop. Just leave a reply and I'll get back to you as soon as possible. Have a great day and stay safe. 

Hello there, the DR & CR of my TB in Quickbooks aint the same. Advise

Let's find out why you're getting an unbalanced trial balance, Am Mutuku.

There are some reasons why your trial balance fails to balance. This usually happens if you transposed numbers while posting from the general journal to the ledger, or from the ledger to the trial balance. Also, if you've miscalculated the numbers that will show different figures. Or perhaps you credited something that should be debited or vice versa. Another is if you applied a transaction to the wrong account.  You'll want to go through each transaction starting with the journal entries and make sure they are posted correctly to the general ledgers. Then, double-check the ledger balances and make sure those were entered in the trial balance correctly. You can also reach out to your accountant to guide and figure out what causes such issue. 

To help you understand more about debits and credits and how they are balanced, I've added this QuickBook Blog that contains more information: Debit vs. Credit Accounting: The Ultimate Guide.

In addition, learn from this article some of our financial reports available in QuickBooks that give you information about different areas of your business: Reports Included In Your QuickBooks Online Subscription.

Let me know if you have any other concerns about your trial. I'll be right here to help.

@LollyNino_C you recognize that what you are recommending requires additional manual manipulation. Resulting in a greater chance of report error.

A standard trial balance in most other accounting softwares provides: Opening Balance, Activity (for the period), and Closing Balance. 

By requiring users to export the data and manipulate the reports creates an opportunity for error. Please advise if a true trial balance report is in the works?

Hi MasseyC,

I can see how convenient it would be to be able to run a different data of a Trial balance report.

We're continuously working towards providing better features to help improve our customer's experience while using the program.

I'd suggest sharing this idea with our Developers. You may post this suggestion through these steps:

1. Click the Help menu.
2. Click on Send Feedback Online.
3. Select Product Suggestion.
4. Type in your feedback or feature request.
5. Click on Send Feedback.

Feel free to pin these references as your guide in modifying reports:

• Export reports as Excel workbooks in QuickBooks Desktop
• Customize reports in QuickBooks Desktop

Keep me posted if you need help customizing reports. I'll be around to help you!

@Adrian_A  I appreciate the steps to suggest the improvement to the Developers. I'll be sure to do that.

With regard to customizing the reports, please correct me if I am wrong, but there is not the ability to add additional detail based on the various inputs/selections there in, is that correct? Meaning I can't add a beginning balance & activity based on the Customize Functions. Rather those functions are reserved for the actual formatting of the report itself, how the report looks vs what the report includes.

Also trial balance should include entire chart of account. Unrealized gain/loss is omitted from Quickboobks trial balance report, the report is incorrect and does not reflect the amount in actual chart of accounts.

do we have this type of TB in quickbooks online

we are struggling for this option . why qbo not providing this for their customers!!! 

my audit asks about Beg. Balance Movements and Ending Balance all of them Debit Credit

But, QB just shows Debit and Credit.

QuickBooks on line

We appreciate you raising your query here in the Community forum.
 

As much as we'd like to help you achieve your goal, however, we need a few details of your concern to give you accurate answers. You can also share with us some screenshots of your concern. Any information that you can provide will be greatly appreciated. 

We're looking forward to hearing back from you. The Community team is always here to have your back. Have a good one.