Hi. I have recently migrated to Quickbooks for a handful of companies I do the bookkeeping for due to this MTD VAT fiasco.
How do I get a monthly Trial Balance as the report only shows YTD Trial Balance, which is not helpful.
The old system of MYOB which I migrated from combined the Monthly and YTD in one report.
With QuickBooks online you are only able to run the trial balance for the financial year you have set.
The product is evolving constantly and to assist us meet your requirements, and hopefully get them implemented, we encourage you to leave feedback from within the product.
Hi Paulg1969. One would think that entering custom dates would give you the information specific to only that date range. However, on QB desktop - they don't seem to realise that needed functionality.
I get the same result if I have (01/01/2019 to 30/06/2019) or (01/06/2019 to 30/06/2019).
It does not only give the changes specific to the date range - only the YTD as at your "to" date.
If it is working as intended, why have a date from, since it does nothing? If the From date is years before, it still provides the same results. I would like to see data for specific periods. How do I achieve this?
Hi there, @John666.
Let's ensure the trial balance report you pull up is not a memorized report. It's possible someone else created a custom, memorized report, and called it Trial Balance.
Here's how to locate the traditional trial balance report:
If you're using the Accrual reporting method, it will accumulate all balances even before the period you set on the report. You can change it to Cash,so the report shows income only if you have received it, and expenses only if you have paid them.
If you get the same result, run the verify and rebuild tool. Verifying the data identifies commonly known data issues within a company file while rebuilding data resolves data integrity issues.
You can use the following link to edit the display, filters, and create reports in QuickBooks: Modify reports.
Feel free to leave a comment below if you have any other questions. Have a great weekend.
Hi, and thanks for your reply, but it made no difference at all. The only item that changes the result is the ‘To’ date which is everything from the very first transaction up to that date.
Is there any of only viewing the relevant information?
I have tried Verifying and rebuilding my data files and I have also removed and re-installed Quickbooks. None of this made any difference.
We appreciate you fro performing some troubleshooting steps to fix the problem, John666.
Let's try opening a sample company file to see if you're having a problem with one file only. You can also open the file from a different location to check if the problem might be coming from a damaged folder.
Then, try choosing This Month option in the Dates drop-down or manually enter the period in the From and To field.
If the same thing happens, I'd suggest contacting our Technical Support Team. They'll investigate what's causing this issue.
Here's how to reach them:
I have articles here about understanding and customizing reports:
Please loop me in if you need anything else with running reports in QuickBooks. I'm here to help.
Hi, thanks for your suggestions but again, nothing changed.
I tried copying some of my own files to a different Drive and Directory and I looked at the 3 sample files provided.
All act in the exact same way in that the 'From' date has absolutely no bearing on anything so the data is taken from the first transaction up to the 'To' date. Maybe I am using the 'Trial Balance' in the wrong way, but I can't see how else to get the information I want.
As far as contacting Quickbooks Support is concerned, there is now a huge language and cultural problem when dealing with them in my experience.
Looks like my comment from this morning has been “moderated” out. Quickbooks probably don’t like us mentioning going back to our other software because their essential Trial Balance report is useless.
I just tried following your instructions for contacting your Technical Support Team, but I ran into a problem...
I am unable to find the 'Contact Us' option you refer to. The closest I found was 'Check the Support Site for more answers' link at the very bottom of each page.
Having clicked on that and typing in a search on Trial Balances it brought me back to this page.
We appreciate you for performing the steps I've provided to connect with us, John666.
Aside from going to the QuickBooks Desktop Help tab, you can contact our technical support by going to the Ask Intuit tab.
If you can't see the Ask Intuit tab, you can go to this support link: https://help.quickbooks.intuit.com/en_US/contact. Then, follow Step 7 to Step 9 to connect with us.
This will take you in the right direction today. Feel free to come back to this thread if you need anything else in QuickBooks Desktop.
I also have had this issue where the Trial Balance only gives YTD figures and completely ignores your "From" date.
I have had to export to a spreadsheet and use formulae to work out my monthly Trial Balance figures.
I have experienced this from QB2016 and now have the latest QB2020, which I upgraded to because of the MTD VAT.
I have since found free bridging software for the MTD VAT and am gradually migrating back to my old MYOB software, which allows for a Trial Balance of a single day to be done.
Hello there, John666.
I already updated my answer and provided you the direct link to contact our Customer Support Team.
Just reply to this thread if you have further questions in QuickBooks.
Thanks for the information. I too am having to resort to excel in order to get the information that QuickBooks fails to provide. There also doesn't appear to be any inclination from them to listen and put it right, like so many other things.
I also don't understand why the UK has been forced into the Quickbooks monthly subscription system, but you can still buy it outright in other locations.
Thanks for the update. I tried opening the link and I got a page telling me to go through the F1 help screen. When I took the alternative route and typed in a question I was asked to connect to the support team. After a few basic questions like my name etc. I was then asked for my question, and that's where it stopped!
Apparently the support system does not support Chrome as I had nothing but blank windows, and they do not answer Internet Explorer.
Hi RCV, a quick update.
I finally got connected to the help team.
It took 11 minutes before someone connected with me, but did not communicate.
After a further 15 minutes I gave up.
Your effort in contacting our phone support is much appreciated, John666.
In the Trial Balance report, changing the reporting period to a monthly basis won't change the amount. As a workaround, you can consider running and customizing a monthly Profit and Loss and Balance Sheet report and exporting them to Excel. This way, you'll be able to get the information needed.
You can check this article on how to customize your reports for reference.
If you have any additional questions, you can always go back to this thread.
I am aware of how to customise reports, and I am used to exporting reports into Excel. What I don't understand is, why have a 'From' date if it is just ignored. I'm sure it wasn't ignored in previous editions of Quickbooks. And if it is to be ignored in Trial Balance reports, how about adding another report where the 'From' date does something. I am sure there must be many other users that are having the same problems. Maybe they just can't be bothered to try and contact the Support Team. I know I won't bother trying again.
I ran through the thread and yes you’re correct, John666.
The Trial Balance report will always get the data from the first transaction you entered up to the To date you set. The date range will take effect on the transaction list report when you drill-down to each account.
We can use the Transaction List from the trial balance or pull up the Transaction Detail by Account report. Let's make sure that we filter it to Cash basis to only calculate posting transactions. Then, collate and modify them in Excel.
Here's how to run the Custom Transaction Detail:
I personally notified our engineers with regards to this feedback and they might consider it for future updates.
Always know that the Community is right here if need anything else.
Thanks for your response, but this still leaves me having to go to Excel to process the information which should be available with just a couple of clicks in Quickbooks.
I understand why it does what it does, but it should also show the information for any given period, otherwise why have the From date. I am sure that it used to work properly, so this is a feature which has been disabled. Why?
Let's hope the QB engineers fix it so that it works the way it should.
I concur with user John666. We have the same issue. Companies traditionally format their financial statements in excel and then rely on a monthly data dump from the ERP system. This report needs to be FIXED to recognize the from date. This is a bug. You can't claim that the report is running as intended when the from date is ignored. Monthly activity financials are necessary for all businesses. The user's ability to design an excel based system of presenting them is also necessary.