If QuickBooks Desktop flies for one person in the office but everyone else seems to spend their day waiting for reports, invoices, and screens to open, QuickBooks itself may not be the real problem.
The problem may be where the company file lives and how your QuickBooks network is set up.
I still come across small businesses where the QuickBooks company file has gradually become dependent on one employee's computer. Nobody intentionally designed it that way. It simply started on one computer years ago. Another employee eventually needed access, so someone created a network share, and everyone kept working.
Until it stopped working well.
Why QuickBooks can be faster for one person
Imagine the QuickBooks company file is stored on Sarah's accounting computer.
Sarah opens QuickBooks and accesses the company file directly from her own computer. Everyone else in the office connects to that computer across the network.
That arrangement is not automatically wrong. QuickBooks Desktop supports multi-user configurations in which one Windows computer hosts the company file. What matters is whether that computer has been intentionally configured to do the job.
For proper QuickBooks multi-user access, Intuit says QuickBooks Database Server Manager must be installed and running on the computer hosting the company files. It manages access to those files for the other QuickBooks computers on the network.
Problems start when the accounting computer is basically acting as the office server without anyone realizing it.
It may be sleeping at night. It may reboot for Windows updates. Someone may shut it down before leaving. Its network connection may be unreliable. Firewall permissions may have changed. QuickBooks hosting settings may not be configured correctly.
Then everyone else starts blaming QuickBooks.
Signs your QuickBooks hosting deserves a closer look
One clue is that QuickBooks works noticeably better on the computer where the company file is stored than on any other computer.
Another is that QuickBooks becomes unavailable whenever that particular computer is shut down, restarted, or disconnected from the network.
You may also see QuickBooks multi-user mode errors, trouble switching between single-user and multi-user modes, users being told someone else needs to leave the file, or repeated problems finding the company file.
Slow QuickBooks does not automatically mean the hosting setup is wrong. Large company files, damaged data, slow computers, antivirus software, network problems, and other issues can also affect performance.
But when several employees share the same QuickBooks Desktop company file, the hosting configuration is one of the first things I want to understand.
A shared folder is not the same thing as proper QuickBooks hosting
This distinction matters.
QuickBooks Desktop is not just another Word or Excel document sitting in a shared folder.
In a multi-user environment, the computer hosting the QuickBooks file should be properly configured with QuickBooks Database Server Manager, appropriate Windows permissions, firewall access, and a reliable network connection. Intuit specifically recommends a local area network for QuickBooks Desktop and currently specifies a minimum of 40 Mbps of network bandwidth.
Simply creating a Windows shared folder and pointing everybody toward a QBW file does not mean the entire QuickBooks environment has been configured correctly.
That is often where the problems begin.
Remote employees can make a bad setup much worse
Remote work adds another complication.
A common temptation is to connect to a remote computer via a VPN and open the QuickBooks company file directly over that connection.
I generally do not recommend building a QuickBooks Desktop environment that way.
Intuit currently lists VPN connections among the network configurations it does not recommend for QuickBooks Desktop. It also does not recommend traditional NAS devices that only provide network file storage.
For employees who need QuickBooks from outside the office, it is often better to have them remotely access a computer or environment that has QuickBooks installed, rather than repeatedly accessing the live company file over a wide-area connection.
Businesses with heavier remote access needs can also consider QuickBooks Desktop cloud hosting. Intuit currently offers cloud hosting for QuickBooks Desktop Enterprise and maintains a list of authorized third-party hosting providers for supported Desktop products. The right answer depends on the number of users, where they work, what version of QuickBooks they use, and how dependent the business is on the software.
OneDrive and Dropbox are not a substitute for QuickBooks hosting
Another solution I occasionally see is to put the live QuickBooks company file into OneDrive, Dropbox, or another file-synchronization service so everybody can access it.
That may sound like cloud hosting, but it is not the same thing.
File synchronization services are great for ordinary documents and for storing backup copies. They are not a replacement for the network services QuickBooks uses to manage simultaneous access to a live company file.
A backup copy of your QuickBooks data can absolutely be stored off-site as part of a properly designed backup strategy. The important distinction is between backing up the company file and trying to operate the live company file through a synchronization folder.
What a better QuickBooks setup looks like
For a small office, the answer does not necessarily mean buying an expensive server.
Sometimes a reliable dedicated computer makes sense. In another office, an existing computer can continue to host QuickBooks if it is properly configured and kept available. A Windows server, Remote Desktop environment, or authorized QuickBooks cloud hosting service might better serve a larger business.
The important part is that the arrangement is intentional.
Everyone should know where the company file lives.
QuickBooks Database Server Manager should be properly configured.
The host should be reliable and available when employees need QuickBooks.
Backups should run automatically, and copies should exist on a computer other than the one containing the live company file.
Remote employees should have a solution designed for remote access rather than simply stretching a local QuickBooks network across the internet.
The bigger concern is not speed.
Slow QuickBooks is frustrating, but the larger problem is what happens when the computer containing your accounting data fails.
If the only current copy of the company file is sitting on one employee's computer, that machine has quietly become one of the most important computers in the business.
A failed drive, ransomware infection, stolen computer, Windows problem, or accidental deletion could suddenly become an accounting emergency.
That is why I look at backup and recovery at the same time I look at QuickBooks performance.
A business should have a reliable backup of its QuickBooks company file, preferably with multiple recovery points and an off-site copy. Intuit's own hosted Enterprise offering, for example, includes automatic backups in multiple locations and access to previous backups.
You do not necessarily need that particular service, but you do need a backup plan.
Get QuickBooks off one person's desk.
If your entire accounting department depends on one employee leaving their computer turned on, that is worth fixing.
For businesses needing QuickBooks Desktop support in Springfield, MA, I can review where the QuickBooks company file is stored, how users connect to it, whether QuickBooks Database Server Manager is configured properly, how the network is performing, and whether the company file is backed up correctly.
I see the same kinds of setups in small businesses throughout Springfield, MA, Chicopee, and the surrounding Western Massachusetts area. Usually nobody did anything obviously wrong. The system simply grew over time, without the QuickBooks hosting arrangement keeping pace.
The goal is simple.
QuickBooks should not depend on one person's computer behaving perfectly every day.
And your company's financial history definitely should not depend on it.
