We looked at a client’s QuickBooks Enterprise 11 file this week that was mysterious — their TLG file was growing by more than 1GB every day.

But they weren’t entering or importing very many transactions…just a hundred or so per day. So why was their TLG file exploding on a daily basis? The client was having to manually delete the file every few days to keep it under control. But then QuickBooks would recreate it from scratch (which is normal) and quickly add a gigabyte or more of information to it within hours of normal use (not normal). Strange, eh?

(By the way, TLG stands for Transaction Log file, and is an auxiliary file that QuickBooks maintains along with your main QBW file. QuickBooks inserts new transactions into the TLG file. For that reason, the TLG file is sometimes helpful to us when we are helping clients recover from QuickBooks data crashes. The TLG is otherwise not necessary for the operations of QuickBooks.)

The company file verified and rebuilt without errors, and the client was not experiencing errors or crashes during normal QuickBooks operations.

We found some minor problems in the QBW file, and supercondensed their file for them. But we couldn’t find the source of the TLG growth issue.

Then we heard that that this issue is known by Intuit to occur in certain cases, and a resolution is expected in 2-4 weeks. So our client will continue to manually delete the file every few days until the fix from Intuit comes out.

This is the first time we’ve encountered a problem like this. Has anyone else seen it?

I recently spoke with a gentleman who lost eight months of data in his QuickBooks file.

It’s not perfectly clear what happened to cause this, but we think the key moment was when he got some kind of message about the file name, and something about ‘overwriting’.  Sounds like the warning you might get when you’re restoring a QuickBooks backup, doesn’t it?

He told me that he was talking on the phone while he was working in QuickBooks at that moment; he wasn’t paying complete attention to what was going on in QuickBooks.


Multitasking is a wonderful skill/aptitude. But there are certain tasks that merit single-task focus. Like driving a car. Or restoring a QuickBooks backup file.

p.s. This story actually had a happy ending, because although the user had overwritten and lost his current QBW file, he had an intact, current TLG file and an older backup file on his hard drive. We were able to recover all the information.

Have you ever deleted something on your computer and then regretted it? (I have.)

There are several different editions of QuickBooks available. They vary in how well suited they are for different sizes and types of organizations and in the way users access their data.

All of the editions can do basic accounting – check printing, paying bills, processing payroll, invoicing customers — but some are better suited for specific requirements and situations. (Can I easily change between editions? See below.)

For Small Business – 100% Online Access:

QuickBooks Online Plus

Up to 5 simultaneous users + accountant
Seamlessly access accounting records real-time from multiple locations
Limited import/export and inventory capabilities

For Small Business – Mac:

QuickBooks Mac

Up to 5 simultaneous users on a network
$229.95 retail
Feature set similar to QuickBooks Online

For Small Business – PC/Network Based Accounting:

QuickBooks Pro

Up to 3 simultaneous users on a network
$229.95 retail for single user
Best combination of general accounting features for most small businesses
Wide selection of optional add-ins

For Small/Medium Business — Industry Focused PC/Network Based Accounting:

QuickBooks Premier

Up to 5 simultaneous users on a network
$399.95 retail for single user
Industry-specific editions for not-for-profits, construction, manuf., etc.
Extra management tools like business planning and forecasting

For Medium Business — Many Users/Network Based Accounting:

QuickBooks Enterprise Solutions

Up to 30 simultaneous users on a network
$600 retail per user
More robust multiuser performance
Designed for higher transaction volumes and database sizes

Moving from One Edition to Another

You can easily upgrade between the following editions, simply by opening the file in the higher edition:

Pro -> Premier
Pro -> Enterprise
Premier -> Enterprise

You can convert from Pro or Premier to Online by uploading your file. But there is a 120MB file size limit; if your QBW file is bigger than that, QB Online won’t accept it. Your file can be recreated with only last year’s transaction history to bring the file size down and make it uploadable.

You can downgrade these editions:

Premier -> Pro (file formats are compatible)
Online -> Pro/Premier (upon request by Intuit)
Enterprise -> Pro/Premier (by AccountingUsers, Inc.)

Do you have the best version in place already? Or are you contemplating a switch?

Want to get more from QuickBooks in less time? And have fewer problems? OK, repeat after me…

  1. I will reconcile my bank accounts and credit cards in QuickBooks every month
  2. I will review my books with an accountant and listen to their suggestions
  3. I will explore some of the App Center offerings and see if one can them can help me either make or save significant money
  4. I will regularly open the Company Dashboard and see how the sales, profit, and receivables trends are doing
  5. I will upgrade to a higher version of QuickBooks before May, 2012 (support discontinuance date) if I’m using version 2009
  6. I will review my backup system/procedures and make sure it works
  7. I will pay my bills through online bill payment services.

Any of these ring true for you for 2012?