cancel
Showing results for 
Search instead for 
Did you mean: 
KareninAZ
Level 1

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

 
12 Comments
Alessandra_B
QuickBooks Team

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Hey @KareninAZ,

 

Currently, there’s no option to create a customized Trial Balance report in QuickBooks. Because it's statement reporting only the debits and credits of your accounts.

 

Also, you’re only able to edit the Report period you wish to show on the report.

 

While this option isn’t available, I’ll personally send feedback to our engineers. This way, they'll know about your suggestion to customize the Trial Balance report. They can consider adding this to future product updates.

 

Please let me know if you have other concerns. 

telrod
Level 2

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Is there a way to customize it in QB Premier?  I have never worked with a program that would let you have the beginning balance.  That is a standard for yearend financials sent to CPA's for tax returns.

Thanks!

MaryGraceS
Moderator

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Hi there, @telrod.

 

Thank you for posting in the Community. Allow me to help share some details about customizing the Trial Balance report. 

 

You can customize the Trial Balance in QuickBooks Desktop, however, the option to add the Beginning Balance in the report isn't available. As mentioned by my colleague, Alessandra_B this report only confirms the total of all debit balances matches the total of all credit balances in each account.

 

I've attached some articles as future reference:

These resources should help to get you on the right track. Stay in touch if you have any other questions about customizing reports in QuickBooks Desktop. I'll be happy to help you out. Have a great rest of your week. 

jriley1414
Level 2

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

That is nearly what I have been looking for as well. We were running AccountEdge (formerly MYOB) and the trial balance is dumped into a mapped Excel model each month - and the mapping cannot be changed.

 

We need:

Beginning Balance

Debits

Credits

Net Activity

Ending Balance

 

So, we're clearly not the only people on the planet needing this format!

 

I DID find one report in the report in the "contributed" reports that is called "Comparative Trial Balance" that shows beginning, ending balances & net acvitity. I hope that helps you somewhat.

jriley1414
Level 2

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Hi Alessandra,

 

We need something very similar. We are attempting to replicate a report that came out of AccountEdge (formerly MYOB). The trial balance gets dumped into a mapped Excel model and cannot be changed, so were therefore are desparately in need of this report so that we can produce month-end financials.

 

We need the following columns:

Beginning balance

Total Debits

Total Credits

Net Activity

Ending Balance

 

Please see attached sample for reference.

 

Thank you!!

GraceC
QuickBooks Team

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Hello there, @jriley1414

 

I've checked that you've posted the same question twice and my colleague @JonpriL has already added an answer. If you haven't notified with the new response, here's the link: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/trial-balance-that-shows-be...

 

Keep me posted if you have other concerns. Have a great rest of your day!

jriley1414
Level 2

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Essentially, what we are in need of is a working trial balance, which is available in the Accountant's version. Is it possible to ask the developers to develop an update for folks that have versions other than the Accountant's version (we have manufacturing & wholesale, for instance). An update/patch with the WTB might solve the issue quite easily since the report already exists in another version of QB. Just a thought!  Thank you!

Maybelle_S
QuickBooks Team

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Hi, @jriley1414.

 

I know how important it is to have this feature in your QuickBooks. I'll be sending this suggestion to our product developers to add this feature in future product updates.

 

Additionally, you'll be notified through in-products ads and email, once our engineers have new enhancements in QuickBooks.

 

To monitor the latest news and updates, including what our developers are currently working on, you can check our QuickBooks Blog site.

 

Stay in touch with us if you have other concerns with QuickBooks. We're always here to back you up.

jparker24
Level 2

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

I need the trial balance report to be customizable as well. Specifically I need to be able to see "Class" on the trial balance. I will use the trial balance export to excel to power the historical data in my financial model. It is shocking to me that the trial balance report is not able to be customized.

Sunnydale
Level 1

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

I can't believe that Quickbooks Online doesn't have a standard Trial Balance which has four columns:

1) Beginning Balance,

2) Debit (total Debit for the period),

3) Credit (total Credit for the period) and

4) Ending Balance.  

 

This is so basic, but I only see the TB that has two columns: Debit and Credit which list the ending balances of the period, not the transactions.  This is an useless TB.  The auditors won't accept it.   

 

 

Sunnydale
Level 1

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

Has there any development in the standard four columns Trail Balance?  Our auditors need this also and the one currently in QB online is useless.

MaryJoyD
QuickBooks Team

Can a custom Trial Balance report be created that shows a Beginning Balance column, Net change Debit and Credit Columns, and an Ending Balance column?

I can provide some information with our Trial Balance report, @Sunnydale.

 

Currently, the Trial Balance report that we have summarizes the debit and credit balances of each account on your chart of accounts during a period.

 

I understand the importance of having the Beginning Balance and Ending Balance of your Trial Balance, so I’ll take note of it. That will surely help in providing an accurate report to your accountant.

 

In the meantime, I suggest checking out our QuickBooks Blog to check for new updates and features that we have. 

 

You can check out this article to know more about the reports that we have in QuickBooks Online: Run Reports. If you want to learn more about customizing reports, you can refer to this article: Customize Reports.

 

Stay in touch if you have other concerns with your reports by leaving a comment below. I'm always glad to help in any way I can.​ Have a great rest of the day. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us