Skip to main content
JamesDuanTAnswer
Jan 26, 2021 9:55 AM UTC

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 in thread

13 replies

JamesDuanTAnswer
Jan 26, 2021 9:55 AM UTC

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
    Feb 14, 2022 9:19 PM UTC

    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
      Feb 14, 2022 11:56 PM UTC

      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
      May 25, 2022 8:07 AM UTC

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

      MariaSoledadG
      MariaSoledadG
      May 25, 2022 9:30 AM UTC

      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.

       

      yasowryh-gmail-c
      Jun 9, 2023 2:13 PM UTC

      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
      Jun 9, 2023 2:15 PM UTC

      QuickBooks on line

      DHeraV
      DHeraV
      Jun 9, 2023 3:45 PM UTC

      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.

      Terms & ConditionsAccessibility statement