QuickBooks being a bit sluggish for you?

Apart from adding newer, faster hardware (think solid state drives) or having your file supercondensed, here are some less obvious ways to possibly get a speed increase.

1. Turn off the built-in search indexing in QuickBooks. This is a company preference that enables you to do the quick, global search with F3. But that instant search capability comes at a price: slower performance for other functions, particularly saving new transactions. This is particularly true with very large files, or with version 2013 files.

So try this: Click on Edit / Preferences / Search / Company preferences. Uncheck the search box, or the search update automatically box, depending on your version of QuickBooks. Rebuild your file. Close out of QuickBooks, then open it up again. Are formerly sluggish processes faster? They might be. (If the rebuild step failed, your file has other issues.)

(Note: you can still search in your company file after turning off Search, but it will take longer.)

RELATED: Why QuickBooks Is Sometimes Slow
Condensing a Big QuickBooks File Without Downtime
Interview: User with a Big, Slow QuickBooks File

2. Get rid of unneeded memorized reports. Some users save a bunch of memorized reports over the years that become irrelevant later on. Get rid of the memorized reports you don’t need anymore.

We have seen cases where QuickBooks performance slows way down if you have memorized reports numbering in the dozens. Not sure why this is exactly. Maybe QuickBooks pre-populates at least some of the information in the memorized reports whenever you save new transactions? Maybe. In any event, we’ve seen performance increases sometimes when you parse the list of memorized reports down significantly.

To delete unneeded memorized reports, click Reports / Memorized Reports / Memorized Reports List. Right click on any unneeded report and select Delete Memorized Report.

3. Delete the TLG file. The TLG file – transaction log file – is an auxiliary file that QuickBooks automatically creates and maintains alongside your main file. The TLG file doesn’t have to be there for QuickBooks to work correctly; it can be deleted without data loss. (It sometimes is useful in data recovery situations, however.)

If the TLG file gets very large — say, over 1GB — then it might start to slow down QuickBooks, especially when you are adding new transactions.

RELATED: The Case of the Exploding TLG File
A Humble Hero: The QuickBooks TLG File
The Biggest QuickBooks File in the World

The simplest way to delete the TLG file is to just make a verified backup of your file in QuickBooks. That will blank out the TLG file and start it over again.

You can simply click File / Create Backup / Local Backup, and click the Options button. Make sure that “Complete verification” is selected. Finish making the backup, and the TLG file will be reset to a blank file. (If there are problems verifying the file, contact us for help.)

You should make sure that your automatic backup system is backing up the TLG file in addition to your QBW file, in case you need it later. Or, you can just manually move it in Windows from its current folder to a backup folder that you have created.

Anybody tried any of these techniques? How did they work for you?

Please follow and like us:
hawaiian sunset
Some sunsets please. Others do not.

…You should see what Sage is getting ready to do.

Starting in 2014, Sage 50 (formerly known as Peachtree Accounting) will start a transition to only support the most current software release, instead of supporting the current AND the previous two releases. (Sage posted their new policy here.)

Sage and Intuit are two separate companies, but until now their support policies for their respective small business accounting solutions have been pretty much the same: they both support the current version plus the last two previous versions.

In the QuickBooks world, the discontinuance (“sunsetting”) of the oldest version of QuickBooks happens in May of every year. So in May, 2013, Intuit will discontinue supporting QuickBooks 2010 editions.

RELATED: QuickBooks 2010 About to Depart Into the Sunset

That annoys some QuickBooks users. But imagine if you are a Sage 50 user. In the future, you’ll have to upgrade every single year if you want to have the support associated with payroll updates, etc.

Sage calls it an “obsolescence policy”, as if software 13 months old is inherently obsolete, like a can of soup with an expired date.

Oh well. QuickBooks users don’t have to worry about it. Be thankful that on planet QuickBooks, it takes three years for the sun to set. And if you’re coming over to QuickBooks from Sage 50, welcome.

Please follow and like us: