How to Set Up QuickBooks Desktop Multi-User Mode

Server, workstations, Database Server Manager and hosting, explained simply.

Once your business grows past one person doing the books, you'll probably want two or three people in QuickBooks at the same time: someone entering bills, someone sending invoices, maybe your bookkeeper reconciling. That's what multi-user mode is for.

Setting it up isn't hard, but the order matters, and one wrong checkbox can leave you staring at an H202 error. This guide walks through the whole thing.

How Multi-User Mode Works

One computer stores the company file and hosts it. That's the server. The other computers, the workstations, open the file over your office network. A small background program called QuickBooks Database Server Manager runs on the server and manages everyone's connections.

User limits: Pro up to 3, Premier up to 5, Enterprise up to 40, with a license seat for each person working at the same time.

What You Need

• The same QuickBooks edition and year on every computer (for example, all Premier 2021)
• A user license for each simultaneous user
• A reliable computer to act as the server, preferably on a wired connection
• Windows admin access on every computer

Step 1: Set Up the Server

1. Run the QuickBooks installer on the server computer.
2. Choose Custom and Network Options.
3. Pick one of these:
   • "I'll be using QuickBooks Desktop on this computer, AND I'll be storing our company file here" if someone will also work on the server.
   • "I will NOT be using QuickBooks Desktop on this computer" if it's a dedicated server. This installs only Database Server Manager.
4. Finish the install.

Step 2: Create a Shared Folder for the Company File

1. On the server, create a folder on a local drive, for example C:\QBData.
2. Right-click it, choose Properties > Sharing > Advanced Sharing, tick Share this folder and set permissions so your QuickBooks users have Full Control.
3. Move or restore your company file into this folder.

Step 3: Run Database Server Manager

1. On the server, open the Windows Start menu and search for QuickBooks Database Server Manager.
2. Click Add Folder and choose your company file folder.
3. Click Scan. This sets up the network data file (.ND) and permissions QuickBooks needs.
4. When the scan finishes, your company file should appear in the list.

Step 4: Turn On Hosting on the Server Only

If full QuickBooks is installed on the server, open it and go to File > Utilities > Host Multi-User Access. Click Yes to confirm.

On every workstation, open QuickBooks and check File > Utilities. It should say Host Multi-User Access, which means the workstation is *not* hosting. If it says Stop Hosting, click it. Only one computer should host.

Step 5: Set Up the Workstations

1. Install QuickBooks on each workstation using the Express option.
2. Open QuickBooks, choose Open or restore an existing company, and browse to the shared folder on the server through the network (for example \\SERVER\QBData).
3. Open the company file and, when prompted, switch to multi-user mode under File > Switch to Multi-user Mode.

Step 6: Create User Logins

In QuickBooks, go to Company > Set Up Users and Passwords > Set Up Users. Give each person their own login. Enterprise lets you control exactly what each person can see.

Troubleshooting