What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/What Is a QuickBooks TLG File, and Can It Go?
QuickBooks Desktop files

What Is a QuickBooks TLG File, and Why Is It Bigger Than My Company File?

You opened the QuickBooks folder to free up space and found a .TLG file the size of a movie. It's QuickBooks Desktop's transaction log. It sits beside your company file (.QBW) with the same name and records every change made since the last full, verified backup. If QuickBooks crashes, that log is how recent work gets put back. It's not junk, and it's not a backup either.

The .QBW holds the books; the .TLG holds the changes

CompanyName.QBW

The company file

  • Every transaction, list and setting, as of right now.
  • The file you open, back up, move and restore.
  • Useless without QuickBooks Desktop to read it.
CompanyName.TLG

The transaction log

  • Each change made since the last full backup, in the order it happened.
  • Created and written by QuickBooks on its own. There's no setting for it.
  • Only useful paired with its own company file, for recovery after a crash.

Neither one is a copy of the other. A .QBB backup is the copy, and the log only covers the stretch after it.

The .TLG file, briefly

What it does: logs changes to the company file so QuickBooks, and Intuit's Auto Data Recovery, can rebuild transactions lost in a crash.

Why it grows: it keeps adding entries until a manual backup with complete verification resets it. Several QuickBooks maintenance guides report that scheduled backups don't reset it, so a file backed up only on a schedule can keep swelling.

Can you delete it? There's no need. Intuit's help resets it with a manual backup using complete verification. Deleted anyway, QuickBooks makes a new empty one the next time the file opens, and everything the old one held is gone.

QuickBooks Online? No .TLG, no .QBW. Intuit keeps the books on its servers.

Resetting an oversized .TLG with a verified backup

  1. 1

    Have everyone close the company file

    A backup with full verification checks the whole file, and QuickBooks may ask for single-user mode to finish it. Ask the others to close QuickBooks first.

  2. 2

    Open the backup window

    File Back Up Company Create Local Backup

    Choose Local backup and select Next, or Options first if this is the first manual backup in a while.

  3. 3

    Choose complete verification

    In Options, pick where the .QBB goes, ideally a drive other than the one holding the company file, and choose Complete verification rather than the quicker setting or none.

    Watch for: a verification error. That's QuickBooks finding damage in the file. Stop there and run Rebuild Data before trusting this backup.

  4. 4

    Save it now, and wait

    Pick Save it now and let it run. On a file that's gone months without a verified backup, this can take a while.

  5. 5

    Look at the .TLG again

    In File Explorer, the log should be down to a small fraction of what it was. If it hasn't shrunk, the backup probably didn't complete with verification, so check for an error message and try again.

How a harmless log file turns into a lost week

Deleting it to save disk space

How you'll know: The log went in the bin before any backup, and the file crashed a few days later.

Fix: Without the log there's nothing to replay, so recovery falls back to the last .QBB. Run the verified backup first; it does the same space-saving job without the risk.

Moving the company file without its log

How you'll know: You copied only the .QBW to a new computer or folder, or copied it next to an older .TLG.

Fix: Move a backup or portable file instead and restore it on the new machine. The steps are in moving QuickBooks to a new computer.

Trusting the nightly scheduled backup

How you'll know: Backups run every night, and the log still keeps growing.

Fix: Keep the schedule, and add a manual backup with complete verification on a fixed rhythm, such as at each month-end close.

Treating the log as the safety net

How you'll know: There's a .TLG and an Auto Data Recovery folder, but no recent .QBB anywhere.

Fix: Auto Data Recovery keeps its copies on the same computer. If that drive fails, the log and its copies go with it. A .QBB on another drive or service is the only real backup.

TLG, QBW and QuickBooks Online

What's the difference between a .QBW file and a .TLG file?

The .QBW is your company file: all the data, lists and settings. The .TLG is the log beside it, holding only the changes since the last full backup, so QuickBooks can recover them after a crash. You work in the first; QuickBooks writes the second for you.

Can I just delete a QuickBooks .TLG file?

There's no need: Intuit's help points to a manual backup with complete verification, which shrinks it safely. If you delete it anyway, do it right after that backup, with QuickBooks closed on every computer, so the only thing lost is a log of changes the backup already holds.

How do I open a .QBW file without QuickBooks installed?

There isn't a way. It's a proprietary database only QuickBooks Desktop reads, the same year that made it or newer. Without a copy, ask someone who has Desktop, often your accountant, to open it and export the reports you need.

Does QuickBooks Online have a .TLG file?

No. Both files belong to QuickBooks Desktop, where the company data lives on your own computer or server. In QuickBooks Online there's no local file to log, back up or recover.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.