If your QuickBooks file seems to be getting more and more sluggish, or if it has suddenly gone from fast to slow, here’s something you can try. This might speed up your reports. It might even speed up transaction saving, if that is taking awhile for your company file.
The nice thing about this tip is that you don’t lose anything you use. And you don’t have to cajole the cooperation of your users.
All you have to do is get rid of memorized reports that you don’t need anymore.
This can make a significant difference. A lot of users save memorized reports and then kind of forget about them. So the list of memorized reports keeps growing over the years without ever being pared down — or even used.
QuickBooks can really get sluggish when you have lots and lots of memorized reports. We don’t know why, exactly. We just know anecdotally that sometimes there are performance increases when one significantly pares down the list of memorized reports.
Sometimes memorized reports get corrupted or contain no-longer-valid accounts or names, and that might affect performance too.
It’s an easy fix.
IMPORTANT NOTE: Make a backup of your data before deleting reports.
Click Reports / Memorized Reports / Memorized Reports List.
Right click on any unneeded report and select Delete Memorized Report.
Delete any and all obsolete Memorized Reports. Then log out of the company, log in again, and see if it speeds things up.
This tip won’t help if your file is huge, or if you have tens of thousands of customers or items (these situations create their own bottlenecks and a different solution is required). But it might help otherwise. And the worst that can happen is that you have a cleaner memorized reports list than you had before.