QuickBooks Desktop file types and what each extension does
QuickBooks Desktop saves company, backup, portable, and template files under different extensions, and each one has a distinct job.
QuickBooks Desktop keeps its data in a family of files rather than a single one, and the differences between them trip up users year after year. Someone opens a backup and wonders where this month’s entries went. Someone else emails the wrong file and it bounces for its size. Both problems share one root: each extension marks a different kind of file with a different job.
The extensions you will meet most often
Four extensions cover almost everything in a company folder. Here is what each one means.
| Extension | What it is | What you do with it |
|---|---|---|
| .qbw | Company file | Your live books and account settings; the file you open daily |
| .qbb | Backup | A compressed copy you create on purpose and restore when needed |
| .qbm | Portable file | A condensed copy for moving or emailing |
| .qbo | Bank statement file | Downloaded from your bank and imported through Bank Feeds |
The company file is the only one you open by habit. It holds your full set of books, your account settings, and everything you enter. Desktop names it after your business when you first create the company, and it is usually the largest file in the folder.
The other three are deliberately different. A backup exists to be restored, not opened. A portable file is a slimmed-down version for when a copy has to travel. A bank statement file is not yours at all: your bank produces it, and Desktop imports it into your register. Note that the .qbo extension has nothing to do with the QuickBooks Online product, despite the similar letters.
Extra files that appear as you work
A few more extensions show up for particular tasks rather than daily use.
Form layouts export with the .des extension. If you have customized an invoice or statement template and want it in another company file, this is the file that carries it. Memorized report layouts work the same way and export as .qbr.
The .qwc extension belongs to the Web Connector, which lets outside applications exchange data with Desktop. You do not create this file yourself; the application you are linking supplies it, and you open it once to make the connection.
United States payroll adds one more dependency. Desktop maintains a tax table file, and payroll needs that file present and current. It updates through the payroll update routine, not by hand.
Which file should you open?
For daily work, open the company file, the .qbw. Use Open Company from the File menu and select the file carrying your business’s name. If the books look months out of date, you have almost certainly opened a backup or an old copy rather than the live file. Close it and check the list again.
Never rename a file or retype its extension by hand. Desktop recognizes files by their extensions, and a renamed file will refuse to open or restore. If you need a second copy, make it through the menus so the program controls the naming.
How do you create a backup?
Backups are created from the File menu.
- Open the company file you want to protect.
- Choose File, then Back Up Company, then Create Backup.
- Select Local Backup and follow the prompts.
- Save the resulting .qbb somewhere other than the computer holding your books, such as an external drive or a cloud folder.
Desktop can also run scheduled backups automatically, which is worth switching on. A backup sitting on the same drive as the original helps no one when that drive fails.
How do you restore a backup?
Restoring reverses the backup, and you never do it by double-clicking the file.
- Choose File, then Open or Restore Company.
- Select Restore a backup copy, then Local backup.
- Browse to the .qbb you saved.
- Pick a location and name for the restored company file and confirm.
Desktop then writes a fresh .qbw from the backup. Note that restoring does not merge anything. The newly opened file reflects the moment the backup was made, and anything entered after that point still lives only in the old file.
Portable files and when they help
When a copy of your books has to reach someone else, the portable format is usually the better tool. It is far smaller than the company file and carries the financial data without the accumulated extras. Create one through File, then Create Copy, then Portable company file. The person receiving it opens it through the same Open or Restore Company option used for backups.
The mix-ups we hear about most
Three mistakes account for most of the trouble. Opening a .qbb directly and wondering why nothing looks current. Emailing a .qbw when a .qbm would do, sending a far bigger file than the job needs. And clearing out the folder to tidy up, which can delete every backup on the machine.
Leave the extensions alone, keep backups off the main drive, and treat the company file as the only one you open routinely. Everything else in the set exists to be restored, imported, or sent somewhere, and each has a menu command built for exactly that job.