cancel
Showing results for 
Search instead for 
Did you mean: 
the_tile_setters
Level 4

trial balance report

How do you run a trial balance report in QB desktop premier 2019???????????????? 

Solved
Best answer January 26, 2021

Best Answers
JamesDuanT
Moderator

trial balance report

We got you on this, the_tile_setters.

 

The Trial Balance report is under the Accountant & taxes. Here's how to pull up your data:

  1. Click Reports at the top menu.
  2. Select Accountant & Taxes.
  3. Select Trial Balance.
  4. You can click the Customize Report button if necessary.

You can also use these links for reference when managing reports in QuickBooks Desktop:

We'll be right here if you have additional queries regarding the reports or your data in QuickBooks. Have a great day!

View solution in original post

13 Comments 13
JamesDuanT
Moderator

trial balance report

We got you on this, the_tile_setters.

 

The Trial Balance report is under the Accountant & taxes. Here's how to pull up your data:

  1. Click Reports at the top menu.
  2. Select Accountant & Taxes.
  3. Select Trial Balance.
  4. You can click the Customize Report button if necessary.

You can also use these links for reference when managing reports in QuickBooks Desktop:

We'll be right here if you have additional queries regarding the reports or your data in QuickBooks. Have a great day!

grunertime
Level 1

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?

LollyNino_C
QuickBooks Team

trial balance report

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: 

 

  

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. 

Am Mutuku
Level 1

trial balance report

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

MariaSoledadG
QuickBooks Team

trial balance report

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.

 

MasseyC
Level 1

trial balance report

@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?

Adrian_A
Moderator

trial balance report

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:

 

 

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

MasseyC
Level 1

trial balance report

@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.

JillTs
Level 1

trial balance report

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.

 

SAMO2030
Level 2

trial balance report

do we have this type of TB in quickbooks online

 

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

yasowryh-gmail-c
Level 1

trial balance report

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

But, QB just shows Debit and Credit.

yasowryh-gmail-c
Level 1

trial balance report

QuickBooks on line

DHeraV
Moderator

trial balance report

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.

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

Need to get in touch?

Contact us