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.
|
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.
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:
The QBW is the Windows file type. QuickBooks for Mac uses different file names.
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.
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.
The difference between QBB and QBM comes down to purpose.
|
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.
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:
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.
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.