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:
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!
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
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.
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.
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.
It seems ludicrous for an accounting software to not have the ability to run a functioning Trial Balance. This is beyond a drawback. Intuit should do everything to remedy this shortfall immediately, which does not appear to be such a big task, but it sure creates a bad reputation about product and service. This is a necessary and standard report for any accounting software. Please listen QB, and fill this void and inadequacy.
Completely agree. This is a HUGE fail on Quickbooks. I also work in Procas, which is a double entry journal system; as basic as you get, but approved for government accounting. Even Procas produces a trial balance showing beginning balance, debits, credits, and end balance. This should be a standard report format for all trial balances across all platforms, and right now Quickbooks seems to be the only platform not prividing this. Saying im dissapointed is an unerstatement.
I don't believe we are the only ones feeling this way. the question is, what is QB going to do about it? probably nothing. this can't be a new problem and has gone on for many years. wish we had a way for Intuit to listen and make changes.
Thanks for replying.
If you just go through the chart of accounts and open a specific account you have beg bal, end bal, and detail but there is no way to narrow the dates to the range you want. (I would like to be able to print the full TB or any individual account I wanted.). I guess all I can do is export to google sheets and create a tb type report there.
Greetings QB, We need a 6 column trial Balance!!!; Opening Balance(Debit/Credit), Movements(Debit/Credit), and closing Balance(Debit/Credit). This drawback sincerely makes your Software useless in OHADA(Francophone sub-Sahara African Countries).
I understand that you need to add more data to your Trial Balance report. Let me help you.
The Trial Balance only shows the lists of all accounts on your Chart of Accounts and their totals as either debits or credits. Currently, we're unable to customize it the way we edit the other reports.
You'll want to pull up the General Ledger report. From the Reports menu, hover over Accountant & Taxes, and select the said report. This shows all transactions on each account including the Opening Balance entries. The amount under the Balance column is your closing.
Here are some of the articles you'll want to check. These will show you how to available reports and how to customize them:
Need more help? Comment again here and we'll assist you. Take care!
I agree with Yensin - this is a very basic report that many organizations use - it should be added to the standard reports: REPORTS > ACCOUNTANT & TAXES > (and add) "Working Trial balance."
The report exists in the 'Accountant" version of QuickBooks (and no, we cannot switch versions as we use "Manufacturing and Wholesale" version), and we are failing to understand why this report cannot be added as an update the next time Intuit releases an update.
Jeannine Riley, MBA
Agreed! It is essentially the "working trial balance" from the 'Accountant" version of QB; why Intuit cannot add it in the next update is a mystery to me. Their suggestion is that we spend $500 on 3rd party software (Trial Balance Exporter - called TBX). My organization is not big on 3rd party software, so we will likely NOT renew our QB subscription and move to another software when the subscription runs out in Oct. '21.
In many accounting software TRIAL BALANCE that shows beginning & ending balance, debits/credits & net activity IS NOT REPORT. Its is first page, First what you see when you open your accounting and software.
AND you navigate from it. You click on any account and you are in any particular account. IMEGiNE ChART of Accounts on the left side, and next in this order -.Starting Balance - Debit - Credit - Difference (net activity) - Ending Balance. What do u need more. Click on any account and you into this account. WHY USA uses miles, Pounds when rest of the world uses km, KG... Same here in accounting. Whole accounting world is going towards IFRS and USA has his own GAAP.