Contents
Open a QuickBooks Desktop folder and you will see files ending in .qbw, .qbb, .qbm, .tlg, and .nd. Each has a different job. Mix them up, and you can lose work, send the wrong file to your accountant, or restore an old copy over your live data.
This guide explains the main QuickBooks file types, what each one does, and when to use it.
Quick answer: QBW is your live company file. QBB is a full backup. QBM is a smaller portable copy that you send to someone else.
The Three Main QuickBooks File Types at a Glance
|
QBW |
QBB |
QBM |
|
|
Name |
Company file |
Backup file |
Portable company file |
|
What it is |
Your live books |
A compressed copy of your whole company file |
A smaller compressed copy with financial data only |
|
How you make it |
QuickBooks creates it when you set up a company |
File → Back Up Company → Create Local Backup |
File → Create Copy → Portable Company File |
|
Can you work in it? |
Yes |
No, restore it first |
No, restore it first |
|
Best use |
Daily bookkeeping |
Protecting your data |
Emailing or moving your books |
Menu names can vary slightly between QuickBooks Desktop versions.
2. QBW: Your Company File
The QBW file is your live QuickBooks company file. QuickBooks Desktop opens it and writes to it every time you record a transaction. Each company has one QBW file, named after the company, such as MyCompany.qbw. Every other file type protects the QBW, copies it, or supports it. To create one, see how to set up QuickBooks Desktop.
Follow two rules:
- Do not email the QBW as an attachment. Every copy you send becomes another version of your books.
- Do not use a plain copy of the QBW as your backup. Use a real QBB.
The QBW is the Windows file type. QuickBooks for Mac uses different file names.
QBB: Your Backup File
A QBB file is a compressed backup. It holds a complete copy of your company file from the moment you made it.
To create a QBB: Go to File → Back Up Company → Create Local Backup, then choose where to save it.
To restore a QBB: Go to File → Open or Restore Company, select Restore a backup copy, and choose your file.
You cannot open a QBB directly. QuickBooks restores it into a working QBW. Restore into a new folder so you do not overwrite your current file.
A copied QBW renamed to .qbb is not a backup. Only a QBB that QuickBooks creates restores correctly. For full steps, read QuickBooks Desktop backup online.
QBM: Your Portable Company File
A QBM file is a portable company file. It holds financial data only, so it leaves out letters, logos, images, and templates. That makes it smaller than a QBB and easier to email.
To create a QBM: Go to File → Create Copy, choose Portable company file, and follow the prompts.
To open a QBM: Go to File → Open or Restore Company, select Restore a portable file, and choose your file.
A QBM must be restored before you can use it, and it is not a backup. Never keep working in a portable copy while someone else works in the original. You would end up with two different sets of books.
QBB or QBM: Which One Should You Use?
The difference between QBB and QBM comes down to purpose.
- Protecting your data: Use a QBB.
- Emailing your books or moving them: Use a QBM. For a full move, see how to transfer QuickBooks Desktop to another computer.
- Sending your books to your accountant: Use an Accountant's Copy. Read our guide to the QuickBooks Desktop Accountant's Copy.
Other Files You Will See
|
File |
What it is |
Good to know |
|
.QBX |
Accountant's Copy transfer file |
You create it to send to your accountant |
|
.QBA |
Accountant's working file |
It appears when your accountant opens the QBX |
|
.TLG |
Transaction log |
It records changes since your last backup and helps recovery. It starts fresh after a backup that includes verification |
|
.ND |
Network data file |
It helps computers find the company file in multi-user mode. QuickBooks recreates it |
|
.ADR |
Auto Data Recovery copy |
It can help restore a damaged file |
|
.QBO |
Bank transaction file |
You import it into your register. It is not a company file |
Do not delete the TLG as a habit. A common fix when QuickBooks cannot open a file is to rename the ND and TLG files. QuickBooks creates new ones when you reopen the file. See our guides to QuickBooks Desktop error 6000 and the QuickBooks unrecoverable error.
Common Mistakes to Avoid
- Emailing the QBW. Large files fail to send, and every copy becomes a new version. Send a QBM or use a shared system.
- Using a renamed file as a backup. Only a QBB made by QuickBooks restores correctly.
- Working in two copies at once. Changes in one copy never reach the other.
- Keeping backups in one place. If your only backup sits beside the QBW, one failure takes out both.
How Qbox Helps You Manage QuickBooks Files
When a team, bookkeeper, or accountant shares one QuickBooks Desktop file, file types become a daily problem. Someone emails a QBM. Someone else keeps working in the old QBW. Soon you have several versions of the same books.
Qbox is accounting collaboration software built for QuickBooks Desktop users. It keeps one shared file for everyone:
- It syncs the QBW and TLG together as a pair, so each user gets matching files.
- It locks the file while one person works, so two people never change it at once. When they finish, Qbox syncs the update to everyone.
- It creates a cloud backup copy each time a user locks and syncs, and keeps up to 20 earlier versions you can roll back to.
- It restores files on a new computer. Install Qbox on the new computer and sign in, and your files return to the last synced version.
Qbox does not replace your QuickBooks backups. Keep making them, and turn on the verification option. For more on safe sharing, see how to share QuickBooks Desktop files with your team without data conflicts.
Conclusion
The QBW is your live company file. The QBB is a full backup you restore when you need it. The QBM is a smaller portable copy for sending or moving your books.
Use the right file for the right job. Back up with a real QBB, send a QBM or an Accountant's Copy instead of the QBW, and leave supporting files like the TLG alone. When several people share the same books, use a system that keeps one file in sync, so you never have to guess which copy is current.