For those using QuickBooks Desktop, you may have encounter with a TLG file problem. Don’t worry! This blog explains all that in plain language, along with answering to most frequently-asked-questions on TLG files and how to make things in the right order. Let’s dive in!
What is a TLG file in QuickBooks?
Answer: A TLG file (or Transaction Log file) is sort of like a helper file for QuickBooks Desktop. It does not maintain every change you’ve made to your company file (the ). QBW file) before they’re saved. Think of it like a notepad that QuickBooks uses to write down every change, so it can unmake them if something doesn’t work out (like if your computer crashes or your file gets damaged)
Why do TLG file issues happen?
Answer: TLG file problems can pop up for a few reasons:
- The TLG file becomes large and slows down or causes errors with QuickBooks.
- The TLG file is corrupt, and QuickBooks can’t open your company file.
- The TLG file and your company file (.QBW) are not in the same folder, confusing QuickBooks.
- Your computer or QuickBooks fails when you save the changes, like locking the TLG File.
These can result in error codes such as 6000, 6190 or 6012 — or messages claiming the file won’t open.
Is it safe to delete a TLG file?
It won’t hurt for you to Delete the TLG file associated with your Company file. QBW), but that is not always ideal. This TLG file assists QuickBooks to recover data if your company file is damaged. If you remove it, you could lose the ability to undo recent changes. Don’t delete a TLG file unless it’s causing big problems, such as errors that prevent you from opening QuickBooks, and you’ve tried other repairs first.
How can I tell if my TLG file is causing a problem?
Answer: The following are some indications that your TLG file could be the cause:
- QuickBooks is extremely slow or QuickBooks Crashes regularly.
- You receive messages that read something like, “Error 6190” or “QuickBooks is unable to open the company file.”
- Your TLG file is much bigger than your .QBW file (check file sizes in the folder where your company file is saved).
- QuickBooks is refusing to open it, and your TLG file is “locked.”
If you notice these, it’s time to troubleshoot!
How do I fix a TLG file issue in QuickBooks?
Answer: Follow these easy steps to fix most TLG file problems. Go one step at a time, and check if QuickBooks works after each step.
Step 1: Make a Backup of Your Company File
- Why? Before messing with files, save a copy of your data to avoid losing anything.
- How?
- Open QuickBooks Desktop.
- Go to the File menu and click Back Up Company > Create Local Backup.
- Choose a safe place to save the backup (like an external drive or a different folder).
- Select Complete Verification to make sure the backup is good.
- Click OK and wait for the backup to finish.
This step also resets the TLG file, which might fix the issue right away!
Step 2: Check If the TLG File Is Too Big
- Why? A huge TLG file can slow QuickBooks or cause errors.
- How?
- Open the folder where your company file is saved (usually in C:\Users\Public\Documents\Intuit\QuickBooks\Company Files).
- Look for your company file (e.g., MyCompany.qbw) and its TLG file (e.g., MyCompany.qbw.tlg).
- Right-click each file and choose Properties to see their sizes.
- If the TLG file is much bigger than the .QBW file (like 10GB vs. 500MB), it’s too large.
If it’s too big, go to Step 3.
Step 3: Rename the TLG File
- Why? Renaming the TLG file forces QuickBooks to create a new, clean one, which can fix errors.
- How?
- Close QuickBooks completely.
- Go to the folder with your company file.
- Find the TLG file (e.g., MyCompany.qbw.tlg).
- Right-click it and select Rename.
- Add “.OLD” to the name (e.g., MyCompany.qbw.tlg.OLD).
- Open QuickBooks and your company file. QuickBooks will make a new TLG file automatically.
Check if the error is gone. If not, try Step 4.
Step 4: Use QuickBooks File Doctor
- Why? This tool can find and fix problems with your company file and TLG file.
- How?
- Download the QuickBooks Tool Hub from the Intuit website (it’s free).
- Install and open the Tool Hub.
- Click Company File Issues in the left menu.
- Select Run QuickBooks File Doctor.
- Choose your company file from the list and click Check Your File > Continue.
- Enter your QuickBooks admin password and wait for the tool to finish (it may take a few minutes).
- Open QuickBooks to see if the issue is fixed.
If the problem persists, move to Step 5.
Step 5: Restore a Recent Backup
- Why? If the TLG file and company file are both damaged, restoring a backup can get you back on track.
- How?
- Open QuickBooks and go to File > Open or Restore Company.
- Select Restore a Backup Copy and click Next.
- Choose Local Backup and find the backup file you created in Step 1.
- Follow the prompts to restore the file to a safe location (don’t overwrite your original file yet).
- Open the restored file to check if it works.
If this doesn’t help, go to Step 6.
Step 6: Contact QuickBooks Support
- Why? If none of the above works, you might need expert help for deeper issues, like file corruption.
- How?
- Visit the QuickBooks Support website or call their toll-free number (1-800-446-8848 in the U.S.).
- Explain the TLG file issue and the steps you’ve tried.
- They may use advanced tools or Auto Data Recovery to fix your file.
How can I prevent TLG file issues in the future?Answer: To keep TLG files from causing trouble again, try these tips:
- Back up regularly: Do a manual backup with Complete Verification at least once a month. This resets the TLG file and keeps it small.
- Keep files together: Always store your .QBW and .TLG files in the same folder.
- Update QuickBooks: Go to Help > Update QuickBooks Desktop to get the latest fixes.
- Check your computer: Make sure your Windows operating system isn’t corrupted, and run antivirus scans to avoid file damage.
- Use QuickBooks in single-user mode for backups to avoid errors in multi-user setups.
What if my TLG file is locked and I can’t delete or rename it?
Answer: A locked TLG file means QuickBooks or another program is using it. Here’s how to unlock it:
- Close QuickBooks on all computers using the file.
- If you’re in multi-user mode, go to the server computer and open the QuickBooks Database Server Manager (in the QuickBooks Tool Hub). Stop and restart the service.
- Restart your computer to clear any stuck processes.
- Try renaming the TLG file again (as in Step 3 above). If it’s still locked, contact your IT person or QuickBooks Support to check for permission issues.
Can I move my TLG file to another folder?
Answer: No, you shouldn’t move the TLG file to a different folder from your .QBW file. QuickBooks needs them to be together to work properly. If your TLG file keeps appearing on your desktop, it means your company file (.QBW) is there too. To fix this:
- Move your .QBW and .TLG files to a proper folder (like C:\Users\Public\Documents\Intuit\QuickBooks\Company Files).
- Open QuickBooks and go to File > Open or Restore Company to point to the new location. This keeps your desktop clean and QuickBooks happy!
Final Thoughts
The TLG file issues in QuickBooks are annoying, but most of the time it’s easy to fix them with simple steps, like taking the backup and renaming the TLG file, or using QuickBooks File Doctor. Make sure you backup first, to take care of your data and if you’re stuck don’t be shy to get in touch with QuickBooks Support. While ensuring that it doesn’t get worse in the future, and you who knows, maybe prevents some new issues, you’ll also be running your QuickBooks as it’s, smooth and fast!
