Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
the_tile_setters
the_tile_setters
January 26, 2021
Solved

trial balance report

  • January 26, 2021
  • 3 replies
  • 60 views

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

Best answer by JamesDuanT

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!

3 replies

J
JamesDuanTQuickBooks TeamAnswer
QuickBooks Team
January 26, 2021

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!

    G
    grunertime
    February 14, 2022

    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?

      L
      LollyNino_CQuickBooks Team
      QuickBooks Team
      February 14, 2022

      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. 

      A
      Am Mutuku
      May 25, 2022

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

      MariaSoledadG
      MariaSoledadGQuickBooks Team
      QuickBooks Team
      May 25, 2022

      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.

       

      Y
      yasowryh-gmail-c
      June 9, 2023

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

      But, QB just shows Debit and Credit.

      Y
      yasowryh-gmail-c
      June 9, 2023

      QuickBooks on line

      DHeraV
      DHeraVModerator
      Moderator
      June 9, 2023

      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.

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement