By J. Carlton Collins, CPA
QuickBooks is the world's most popular small-business accounting system with a reported 3.5 million users. There is no denying the success of this product. For the money, QuickBooks provides a good value and a reasonable assortment of features to meet the needs of small and entry-level businesses. While QuickBooks offers a good entry-level solution, it has limitations that prevent the product from meeting the needs of many companies and organizations—especially growing companies and larger organizations.
In this article, accounting industry expert J. Carlton Collins, CPA, describes these limitations and offers practical advice for squeezing the most out of QuickBooks. He also suggests ways you can ultimately replace QuickBooks and compares the product with Microsoft Dynamics GP.
Limitations of QuickBooks
QuickBooks has two basic limitations:
If you run a smaller operation, these product characteristics are actually appealing. For one thing, having fewer features makes Intuit QuickBooks easier to use. If hundreds of new features were added to the product, users would have more difficulty mastering it. In addition, if QuickBooks incorporated a more robust database, its price would increase.
If your organization is rapidly expanding, however, you will eventually outgrow the QuickBooks feature set and database performance, as the rest of this section helps to illustrate.
As a general rule, you are beginning to outgrow QuickBooks when you notice an unacceptable delay in the menus and screens when navigating QuickBooks, or when reports take an unacceptable amount of time to print. As a general rule, most companies using QuickBooks start to notice a decline in QuickBooks performance once the file size reaches 30 MB or the total number of transactions exceeds 32,000. However, while these measures can be good predictors of performance issues, file size and transaction volume are not the best indicators of impending performance problems. In QuickBooks, the number of customers, vendors, employees, and other lists most dramatically affects performance. QuickBooks support acknowledges that significant performance problems generally occur when any list exceeds 10,000—however, as a practical matter most companies see performance issues far earlier. For example, with each added employee, QuickBooks launches slower, and only a few hundred employees on a list can lead to unacceptable performance issues.
Squeezing the last few drops out of QuickBooks
Once you have determined that you are quickly outgrowing QuickBooks, there are a few measures that you can take to temporarily relieve the problem until a new accounting system can be selected and implemented. For a complete list of suggestions, request the full copy of this report at www.asmartmove.com.
Update - Update your QuickBooks software to reflect the latest patches and tune-up files. In 2007 Intuit released several patches that addressed some nagging performance issues with certain portions of their program. The installation of these patches and updates might alleviate your problems, or at least help.
Turn Off Beep and Preferences - Turn off the "Beep on Transaction Entry" feature. According to QuickBooks Customer Support, the "Beep" feature can cause dramatic performance problems and even lead to freezing up QuickBooks. Also, you can turn off certain QuickBooks preferences such as alerts, reminders, auto refresh reports, and check for duplicate numbers, etc., to gain a little more speed.
Defragment the computer hard drive - Initially, your computer saves all data sequentially on your hard drive— like using a single groove on a vinyl record item. However, over time as you erase small files from your hard drive, empty segments are created through the hard drive. Thereafter, QuickBooks saves data files on these separate empty segments, causing the file to be fragmented and physically located on numerous parts of your hard drive. The defragmentation process will rewrite your QuickBooks data file into one sequential file on your hard drive. The result is that QuickBooks will then operate faster.
If you have reached the point at which you are outgrowing the database performance and/or feature set offered by QuickBooks, that's probably good news—because that means that your business is growing. The measures listed above can help you buy some time, perhaps enough to allow you to properly plan for, purchase, and implement a new accounting system. Presented below is additional information to help you better understand your options.
From QuickBooks to Microsoft Dynamics GP
The reality is that once you've started seeing performance and feature shortcomings in QuickBooks, this is a sure signal that your company is on the verge of outgrowing QuickBooks. The performance suggestions mentioned above will only delay the inevitable need to move to a stronger solution. One of the best migration upward paths offered to QuickBooks users is to step up to Microsoft Dynamics GP. There are numerous benefits to migrating from QuickBooks to Microsoft Dynamics GP. Presented below are just a few of those benefits.
1. More features
Microsoft Dynamics GP offers 1,531 more features than QuickBooks Enterprise (2,550 compared to 1,019 according to the 2007 edition of the Accounting Library). For example, listed below are 15 key features provided by Microsoft Dynamics GP that are not found in QuickBooks. To find out an additional 20 key features provided by Microsoft Dynamics GP, request the full report from www.asmartmove.com.
Allocation calculations
Intercompany accounts
Statistical accounts
Supports landed cost tracking
Forecasted demand based on formulas
Multiple ship-to on same order
Automatic tracking of vendor performance
Partial pay invoice for partial receipt
Default printer destination by invoice type
Automatic calculation of late fees
Supports multidimensional items
LIFO and FIFO inventory methods
Applies sales tax rates by item
Support multiple warehouses
Lot & serial number tracking
2. Better financial reporting
The whole point of an accounting system is financial reporting, and Microsoft Dynamics GP offers far more reports (700+ standard reports) than QuickBooks (112 standard reports). While both Microsoft Dynamics GP and QuickBooks allow users to edit reports and send them to Excel or Word, only Microsoft Dynamics GP allows users to view reports in real-time through an integrated intranet business portal. Further, Microsoft Dynamics GP provides more than 200 out–of-the-box Excel reports that contain an active ODBC link to the Microsoft Dynamics GP database, ensuring data is never out of date whenever the Excel file/report is opened. Microsoft Dynamics GP also provides over 70 standard SRS reports based on SQL Server Query technology.
The Microsoft Dynamics GP FRx advanced financial reporting tool allows users to schedule reports to be printed automatically at regular intervals, and automatically delivered to the appropriate recipients via e-mail or publishing to a business portal Web site. This feature ensures that the desired reports are generated and delivered on time, every time, automatically without any effort required by the bookkeepers. Using the FRx tool, users can create entire booklets of reports including title pages, cover letters, tables of contents, reports, logos, charts, graphs, and graphic images—and thereafter, FRx will generate and deliver these booklets automatically incorporating the latest data into the booklet of reports.
3. Office integration
Both QuickBooks and Microsoft Dynamics GP offer a wide variety of Microsoft Office integration features, such as:
Exporting reports directly to Microsoft Excel (with built-in formulas) or Microsoft Word
E-mailing reports and documents directly through Microsoft Outlook
Using ODBC drivers to link data directly to Microsoft Excel and Microsoft Access
Integrating Outlook Calendar to time and billing system
However, Microsoft Dynamics GP provides additional advanced Office integration features via SmartTags and Workflow. SmartTags give users within Outlook, Word, or Excel the ability to view information from Microsoft Dynamics GP all without having to enter the application and manually look up the data.
Conclusion
While QuickBooks is a good entry-level product, its database shortcomings and lack of features make it possible for companies to quickly outgrow it. When your business needs change and you are looking outside the Intuit family of products, you may wish to consider Microsoft Dynamics GP. Microsoft Dynamics GP offers competitive pricing, support, conversion tools, and products designed to help QuickBooks users step up to a more powerful business management system that will meet their needs for many years to come.
To obtain the full version of this report, visit www.asmartmove.com and request the Microsoft Dynamics Smart Move Kit.
J. Carlton Collins, CPA, president of ASA Research, LLC, is an independent author, lecturer, and analyst in the accounting systems industry. He has installed more than 200 accounting systems, and delivered 1,800 lectures around the world on the subject of accounting systems and technology. Collins has published extensive accounting system reviews that can be seen at Accounting Software Advisor.
