What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Open a QuickBooks File in Desktop
QuickBooks Desktop

How to Open a QuickBooks File: The Menu, the Extension, and the Errors

Open QuickBooks Desktop and go to File > Open or Restore Company. What you choose next depends on the last letters of the file name: a .QBW opens as it is, while a .QBB or .QBM has to be restored into a working file first. None of these open without QuickBooks Desktop installed. QuickBooks Online has no file to open at all; you sign in through a browser.

By file extension

.QBW, the company file: choose Open a company file and browse to it.

File Open or Restore Company Open a company file

.QBB, a backup: choose Restore a backup copy, then Local backup. Give the restored file a new name.

File Open or Restore Company Restore a backup copy

.QBM, a portable company file: choose Restore a portable file.

File Open or Restore Company Restore a portable file

No QuickBooks Desktop on this computer? Install it first, or ask whoever has it to open the file and export what you need.

Opening a .QBW company file in QuickBooks Desktop

  1. 1

    Start QuickBooks Desktop

    If the file was opened on this computer before, it may already be listed on the No Company Open window, or under File > Open Previous Company. Pick it there and skip ahead.

  2. 2

    Choose Open or Restore Company

    File Open or Restore Company

    One menu covers opening a company file, restoring a backup, restoring a portable file and, in the Accountant edition, converting a transfer file.

  3. 3

    Pick Open a company file, then Next

    This is the route for a working .QBW. A backup or portable file uses the restore options instead.

  4. 4

    Browse to the .QBW and select it

    If you don't know where it is, search the computer or the shared drive for files ending in .qbw. Our page on where QuickBooks files are stored has the usual folders, and pressing F2 in an open file shows its exact location.

    Watch for: the Open file in multi-user mode box at the bottom of the window. Tick it only if other people need to work in the file at the same time and it's hosted for that.

  5. 5

    Open and sign in

    Enter the user name and password set up for that company file. They belong to the file, not to your Intuit account.

  6. 6

    Decide on the update prompt

    A file last used in an older QuickBooks year asks to be updated to this one. Back it up first if it's a big jump.

    Watch for: the one-way door. Once updated, the older year can't open the file again.

Still not opening? Four reasons a company file refuses

It lives on another computer that isn't hosting it

How you'll know: A message that the file is in use, or that QuickBooks can't reach it, when it sits on a server or a colleague's machine.

Fix: The computer holding the file needs the QuickBooks Database Server Manager running, even with QuickBooks closed, and the folder needs the right Windows permissions. Our multi-user mode page covers the setup.

Your QuickBooks year is older than the file

How you'll know: QuickBooks says the file was created or updated with a newer version.

Fix: Install the same year or a newer one. There's no way to save a company file back to an older year.

The file is damaged

How you'll know: QuickBooks freezes or crashes as the file loads, or opens it with data errors.

Fix: Run the file-repair tools in Intuit's QuickBooks Tool Hub. If the file opens, Rebuild Data may clear what's left. A backup is the last resort, because it brings back the file as of its date and loses everything since.

You double-clicked the backup instead of the company file

How you'll know: QuickBooks starts a restore when you expected the books to open.

Fix: Finish the restore under a new file name so your current .QBW isn't replaced. The full route is on our restore a backup page.

Other QuickBooks file types, and opening one without QuickBooks

How do I open a QuickBooks backup (.QBB) file?

Restore it rather than opening it: File > Open or Restore Company > Restore a backup copy, then Local backup, and browse to the .QBB. QuickBooks unpacks it into a new .QBW wherever you choose, and the backup stays untouched.

Can I open a QuickBooks file without having QuickBooks installed?

Not in any practical way. Intuit doesn't offer a standalone viewer for .QBW or .QBB files, so you need QuickBooks Desktop on the computer, or someone who has it to open the file and send you reports or exports.

Why does QuickBooks crash or freeze when I try to open a company file?

Usually a damaged file, an out-of-date QuickBooks release, or, on a shared setup, the Database Server Manager not running on the computer that holds the file. Update QuickBooks, then try the file-repair tools in the QuickBooks Tool Hub before restoring anything.

How do I open a QuickBooks Accountant's Copy Transfer file (.QBX)?

A .QBX is converted, not opened, and only QuickBooks Desktop Accountant does it, under File > Open or Restore Company > Convert an Accountant's Copy Transfer File. If you're the business owner, what you get back from your accountant is a different file for importing their changes; our page on sending your accountant a file covers that round trip.

I searched how to open a QDF file in QuickBooks. Why can't QuickBooks open it?

A .QDF is a Quicken data file, Intuit's personal finance product, not QuickBooks. QuickBooks uses .QBW, .QBB, .QBM and .QBX, so a .QDF has to be opened in Quicken.

We open the company file every day just to pull figures out. Can that run on its own?

Yes. n-frames builds it with Intuit's Desktop SDK and the Web Connector on the computer where QuickBooks is installed, so the invoices, sales or balances you need are exported or sent to the other system on a schedule, without anyone opening the file to do it. Our QuickBooks Desktop API page covers how those connections work.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.