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?
J
jriley1414
March 11, 2020
Question

Trial Balance that shows beginning & ending balance, debits/credits & net activity

  • March 11, 2020
  • 4 replies
  • 45 views

Hi! We are attempting to replicate a report from AccountEdge (formerly MYOB) that is used in a mapped Excel model. We switched from AE to QB due to issues with AE.  The mapping & model cannot be changed, so we need to build a report that matches the old AccountEdge format.

 

We are running QuickBooks Enterprise Desktop - Manufacturing & Wholesale 20.0

 

We are looking to create a Summary Trial Balance that has the following columns:

Beginning Balance

Total Debits

Total Credits

Net Activity

Ending Balance

 

The columns do not necessarily need to be in this order; if we can export to Excel, we can move the columns.  See attached photo for sample.

 

Thanks so much!

    4 replies

    J
    JonpriL
    Level 9
    March 11, 2020

    Hello @jriley1414,

     

    At this time, there isn't an option to customize your Trial Balance report to show the beginning and ending balance of an account. You'll want to open the transaction detail of your account to see the net activity, opening, and ending balance.

     

    I'm adding a reference here for ideas about managing reports and accounting.

     

    Reach out to me if you have any other ques

    J
    jriley1414Author
    March 13, 2020

    I am sorry to say I can't "cheer" for this solutions. Many companies, including ours, are utilizing mapped models in Excel to create financials. We are creating consolidated, condensed reports for a Board of Directors and a PE firm. Mapping for mid-sized companies is very commonplace.

     

    A trial balance that shows beginning & ending balance, debits/credits & net activity is mapped into several reports in the model. If MYOB and AccountEdge can offer this report format as a standard report, I'd like to think QB can do it as well. I am a QB user since 1999.

     

    I'd further like to think that, as I was not the only person seeking this identical format a standard report can be created as opposed to sitting through several hours of advanced reporting videos to only discover there is no way to create the report yourself.

     

    Thank you!

      Ashley H
      Ashley H
      Level 4
      March 13, 2020

      Thanks for the response, @jriley1414.

       

      I'm submitting feedback to our Product Development Team about bringing in a report into QuickBooks Desktop that will show the beginning/ending balance, debits/credits, and net activity or bring in a feature that will allow you to customize the Trial Balance.

       

      In the meantime, I'd recommend customizing and exporting reports into Excel so they can be combined into one. I'm going to leave you with a couple of Community Articles that will provide with more information on Reports and Excel:

      If you need further assistance or have additional questions, just know that I'm just right around the corner! Have a beautiful day.

        J
        Jeff10413
        May 26, 2022

        I am running QB Enterprise 2021 and wanted to chime in on the working trial balance. QB still needs to create a report that shows the beginning balance, credits, debits, net transactions, and ending balance that we can display with detail or summarized. However, someone here mentioned a working trial balance which I found out how to run but it only displays Beginning Balance, Net Transaction Total, Adjustments, and Ending Balance.

         

        In QB menu bar, go to Lists -> Chart of Accounts. Once the list opens, right click on any account row then left click Working Trial Balance.

         

         

         

        J
        Jeff10413
        May 27, 2022

        I also found the working trial balance available at:

        Menu Bar -> Company -> Accounting Tools -> Working Trial Balance

         

        S
        SAMO2030
        February 28, 2023

        If QucikBooks online provide this reporting facility it would be great support that giving your customers.

         

        Because auditors asking for a TB with movement details. The current format is not fulfilling our needs.

         

        Hope that QBO may provide this Option 

         

        Thanks and regards

          E
          Erica_Kim_LA
          May 17, 2023

          Try this -- Not perfect, but it works 70% of the time. 

          1. Run a GL report for one month

          2. Filter by totals (you will see the acc totals for debits and credits)

          3. Delete the “Total…..” so that only the account numbers and names show (=right(A3,LEN(A3)-6), assuming you need to get rid of the first 6 letters and your acc number and name is in A3.

          4. Use this with V or X lookup to fill out debit and credit cells next to your beg balances

          5.  Add your

          beg + debit - credit = ending for  assets/exp

          beg - debit + credit = ending for liab/eq/revenue

          6. double check your ending balances w the current month’s Trial Balance for accuracy. 

          7. Fix the ones that did not work (20-30% in my case because of the ones with "-other" and other strange reasons.

          8. For the Net Change, some people posted good answers: REPORTS > ACCOUNTANT & TAXES > (and add) "Working Trial balance

           

          Hope this helps!! I will make a YouTube video too (soon). 
          Erica

          E
          Erica_Kim_LA
          May 18, 2023

          The sub-names do not seem to work with the v or x look up because the TB has the parent names + the sub names when the GL does not. 😕😕

          70% is not bad.

          Erica

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