Recovering Transactions From a QuickBooks .TLG Transaction Log File

When a QuickBooks company file is damaged, the paired .TLG file can be used with your last backup to restore transactions entered between that backup and the crash.

When QuickBooks Desktop writes a transaction, it does not immediately commit every entry to the main .QBW file. Instead, recent transactions are recorded in a transaction log file (.TLG) that sits alongside the company file. Under normal operation, QuickBooks integrates those logged entries into the .QBW file during a clean backup or an orderly shutdown. When the company file is damaged by a crash, power loss, or storage failure before that integration happens, the .TLG file retains the transactions entered since the last successful backup. Our engineers use that log, paired with the matching backup, to recover the entries that would otherwise be stranded.

How the .TLG File Works

Every time you create, edit, or delete a transaction in QuickBooks, the change is appended to the .TLG file. The log is sequential: it records each operation in order, along with enough structural information for QuickBooks to replay those operations against a company file that is in the exact state it was in when the log was started. That last phrase is the critical detail. The .TLG file is not a standalone database. It is a delta — a record of changes relative to a specific starting point. To recover transactions from it, you need the backup that corresponds to that starting point.

What You Need Before Starting

Gather the following before attempting recovery:

1. The last successful backup — a .QBB file created through QuickBooks' built-in backup routine. This is the anchor point. The .TLG file must have been created at the same time as this backup. If a newer backup was made after the one you plan to use, the log will have been reset and the earlier transactions are no longer recoverable through this method.
2. The matching .TLG file — located in the same folder as your working .QBW file. It will have the same base filename (for example, Company.QBW and Company.TLG).
3. The QuickBooks Admin password — required to open the restored file. If the backup is password-protected, you need that password as well.
4. A working copy of QuickBooks Desktop at the same version year or newer than the one that created the files.

The Recovery Process

1. Create a dedicated recovery folder on your local drive — not a network share or cloud-synced folder. Name it something clear, such as TLG_Recovery.
2. Copy — do not move — the .QBB backup file into the recovery folder. Work on copies only so the originals remain untouched.
3. Copy the .TLG file into the same recovery folder. It must sit in the same directory as the backup you are about to restore, and it must be the .TLG that was active at the time of the damage.
4. Open QuickBooks Desktop and restore the .QBB backup into the recovery folder. When prompted, choose a new filename for the restored .QBW so you do not overwrite anything.
5. Close QuickBooks completely once the restore finishes. This is essential — QuickBooks must not be holding the file open during the next step.
6. Verify the .TLG filename matches the restored .QBW filename exactly. If the restored company file is named Company_Recovered.QBW, rename the .TLG file to Company_Recovered.TLG. The base filenames must be identical, including capitalization.
7. Reopen QuickBooks and open the restored company file. QuickBooks will detect the .TLG file alongside the .QBW and automatically attempt to integrate the logged transactions into the company file. You may see a brief progress indicator.
8. Run Verify Data (File → Utilities → Verify Data) once the file opens. Review the results for any integrity issues.

Signs the Recovery Worked

Open the restored file and check the most recent transactions — the ones entered between your last backup and the crash. They should appear in the appropriate registers, reports, and transaction lists. Run a Transaction List by Date covering the gap period and confirm the entries are present with correct amounts, names, and accounts. Compare key account balances against what you expect.

When the Problem Runs Deeper

This procedure works when the .TLG file is intact and the backup is the correct match. If the .TLG file itself is corrupted, if a newer backup has already reset the log, or if the backup file is damaged, QuickBooks will not be able to replay the transactions. In those situations, the log data can sometimes still be extracted through direct analysis of the .TLG file structure, but that requires specialized tools and expertise beyond what QuickBooks Desktop provides. Our QuickBooks TLG recovery engineers can evaluate the log directly when the built-in replay fails. If the underlying .QBW file has structural damage — damaged target chaining, broken transaction links, or list corruption — the recovered transactions may not integrate cleanly even from a healthy log, and the file will need repair before or alongside recovery.