cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

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

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 Comments
Highlighted
Moderator

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

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

Highlighted
Level 2

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

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!

Highlighted
QuickBooks Team

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

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.

Highlighted
Level 1

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

This is one of the major drawbacks of QB. My auditors are asking for trial balance with details of opening balance, total debit and credit and the closing balance. I am however not able to generate the trial balance in this format.

Need to get in touch?

Contact us