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

Requesting Monthly Trial balance

I have  request that please have a option to view and export trial balance where For Balance sheet items balances are as on date and for Profit and loss items its activity amount for the selected period. 

There's already trial balance but it doesn't serves my purpose and I believe many people require  Monthly TB for viewing/further uses and auditing purposes. 

 

Please, I request everyone to cheer if you support and QB team to consider this. The current TB is alright for YTD but its not all that is required.

 

Description of Issue:

If I have to Make a monthly TB I have export TB, Export PL. Clear PL items then decide what are PL items and then decide whats debit and whats credit and if something is negative then I have to put is in other side. Its a time consuming task, which should be possible by few clicks and download. 

 

I am not trying to blame or sound rude but I am having a trouble and I need you to help me. Hope you understand. Thanks. 

Solved
Best answer December 10, 2019

Best Answers
Highlighted
Moderator

Requesting Monthly Trial balance

Thanks for the detailed information, @kajalkhatri.

 

I can see how having a monthly trial balance report for viewing and auditing purposes would be helpful for you and your business. Rest assured that I'll pass along your suggestion to our Product Developers. They're always looking for ideas from users on how to improve QBO. Also, I already added cheer on your post above.

 

In the meantime, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

Just in case, consider checking out these articles for future reference:

 

 

Please let me know if you have any other issues or concerns, and I'll get back to you right away. I'm more than willing to assist. Have a great day!

View solution in original post

15 Comments
Highlighted
Moderator

Requesting Monthly Trial balance

Thanks for the detailed information, @kajalkhatri.

 

I can see how having a monthly trial balance report for viewing and auditing purposes would be helpful for you and your business. Rest assured that I'll pass along your suggestion to our Product Developers. They're always looking for ideas from users on how to improve QBO. Also, I already added cheer on your post above.

 

In the meantime, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

Just in case, consider checking out these articles for future reference:

 

 

Please let me know if you have any other issues or concerns, and I'll get back to you right away. I'm more than willing to assist. Have a great day!

View solution in original post

Level 2

Requesting Monthly Trial balance

Thank you so much. I am happy that you forwarded the suggestion.  

Highlighted
Level 1

Requesting Monthly Trial balance

I have the same issue with this as well - I should be able to run a monthly trial balance if this is a true Accounting software. 

Also note that what is very deceptive is that you can select a one month period of time in the date range section but then it still shows the year to date amount (and not the monthly one). You have to check the numbers to make this determination.

 

Highlighted
Level 1

Requesting Monthly Trial balance

Yes, was this problem ever solved? I am having the same issue currently trying to run monthly trial balances which take into account only specific date ranges 

Highlighted
QuickBooks Team

Requesting Monthly Trial balance

Hello there, @accountant231.

 

At this time, there's not a feature that's been put in place yet for Monthly Trial Balance Report. I'm going to submit feedback for you to our Product Development Team about your concern. 

 

If you have additional questions or concerns, please don't hesitate and reach back out! You're always welcomed to come back to this thread for updates. Have a beautiful day.

Highlighted
Level 1

Requesting Monthly Trial balance

I need this monthly TB option as well.  It would help me greatly in my monthly reporting.  Please, please consider this as an option in the reporting module

Highlighted
Level 1

Requesting Monthly Trial balance

I can really use monthly reporting for TB as well.

Highlighted
Level 2

Requesting Monthly Trial balance

I really need this feature as well. I would highly recommend making this a priority. It would also be nice to be able to run a trial balance by class. 

 

Thanks,

 

Highlighted
Level 1

Requesting Monthly Trial balance

I can really use monthly reporting for TB as well.

Highlighted
Level 1

Requesting Monthly Trial balance

Has a custom period trial balance report feature been added yet??

Highlighted
QuickBooks Team

Requesting Monthly Trial balance

Thank you for joining the thread, @Johan Spoor.

 

We don't receive any updates from our engineering team about this feature request. Rest assured that they never stop working to develop QuickBooks and deliver the best experiences for all users. Hopefully, this will be included in the next updates. At this time, you can visit our blog to stay current with the latest QuickBooks news and updates.

 

You can also open this article to learn more about running and customizing reports in QuickBooks Online.

 

If you wish to save the current customization of your report/s, you can also memorize it by following the instructions from this link: Memorize reports in QuickBooks Online.

 

Keep in touch with me if you still need more help with this. I'll be here. Have a great weekend.

Highlighted
Level 2

Requesting Monthly Trial balance

I recently received an email that seemed to imply that you now have a monthly trial balance feature; however, when I go in and put in the current month, so 8/1/20 - 8/31/20, the P & L portion of the trial balance still has the year to date total, not the total for the month. Can you please advise whether this is actually available and I am running the report incorrectly or whether this has not yet been resolved? 

 

Thanks,

Highlighted
QuickBooks Team

Requesting Monthly Trial balance

Hi ashleyspitzer. 

 

Thanks for dropping by the Community this evening. I'm happy to show you how to run the P&L report for an individual month period. Follow these steps:

  1. Click Reports.
  2. Choose the P&L Report
  3. Click the first drop-down arrow that says This-year-to-date and change it to This month
  4. Run Report

From there you can view the P&L report for the month desired. If you have any other questions, feel free to post here anytime. 

Highlighted
Level 2

Requesting Monthly Trial balance

I am not trying to run a P & L report by month, I am trying to run a trial balance by month. 

 

When you do the following:

1. Click Reports.

2. Chose the Trial Balance Report.

3. Click the first drop-down arrow that says this year to date and change it to last month.

4. Run Report.

The portion of the trial balance that reflects the P&L does not reflect last month, it reflects the year to date. I am requesting that you make it possible to run a Trial Balance report that actually reflects the totals of the period selected. It is very misleading to be able to select last month or a customized period, but not have the report provide you the date for that period of time. Its actually useless. Most accountants use trial balances to consolidate financials and to perform month end closing duties, so this is a feature that is very much needed. 


Thanks,

 

Highlighted
Level 2

Requesting Monthly Trial balance

Neither QuickBooks Desktop nor QBO can produce a Trial Balance that separates out the expenses by class name or with a "period net change."  They print "as of" only.

The Trial Balance is not in one column where Debits are Positive and Credits are Negative.

The account numbers are embedded with the account name.

This makes data analysis clunky and time-consuming.

 

FOR DESKTOP:

I am an accountant who wrote a utility called TBX Trial Balance Exporter back in 2004, which gives you these options. I don't see any sign that the T/B will be changed in Desktop. Since Intuit constantly improves QBO, I will not invest in developing a QBO application.

 

Here is a link to the QuickBooks Desktop App page:  

https://desktop.apps.com/apps/167772/tbx-trial-balance-exporter#!overview

Need to get in touch?

Contact us