It’s no secret that QuickBooks inventory tracking has its limitations. Even using the Advanced Inventory functionalities in QuickBooks Enterprise (the highest level of the QuickBooks suite) is often insufficient for fast-growing, high volume, or beyond-basic manufacturing companies. But before we turn to building out complex Excel spreadsheets or considering investing hundreds of thousands of dollars into a full ERP system, let’s look at some practical ways we can analyze what we have access to inside the QuickBooks Ecosystem, allowing your team of non-CPA office staff to continue providing support while receiving better and more accurate information from your systems.
Consideration 1: Desktop or Cloud
Would you like to be managing your inventory activity (purchasing, receiving, building, selling, shipping, fulfilling) in the cloud? What about having cloud access to your accounting information and financial reports?
- Desktop: QuickBooks desktop products provide a lot of tools for TRACKING your inventory. But they lack in MANAGING your inventory. There are several applications – both desktop and cloud – that integrate with QuickBooks desktop products to provide more tools to your warehouse team, manufacturing team, purchasing team, and sales team while maintaining your accounting records inside of QuickBooks. See Considerations 6 and 7 below for a list of those solutions.
- Cloud: QuickBooks Online inventory tracking is simply widgets in and widgets out, but you do gain multi-location tracking. There are several recommended cloud solutions that integrate with QuickBooks Online so that your accounting side can be in the cloud and handle your A/R, A/P, Bank, and other transactions while the app software handles the inventory tracking and management. Not all integrations are equal, so make sure to understand what you are actually getting out of the integration. See Consideration 7 below for a list of cloud-based inventory management solutions.
Consideration 2: Size of your team
Are you sharing the load with other team members to manage inventory and/or do your accounting functions? In some operations, the company is a one-five person show and using QuickBooks is good enough information. But if you’re small and seem to be spending more than 30 min a day digesting information that you feel like should already be available to you in a system, then you should look into the rest of the considerations below.
Or maybe your team has accounting people and warehouse people and sales people all trying to play inside of the QuickBooks box. To an extent, we’ve been able to keep these teams all happy inside of QuickBooks, but often, those team members outside of accounting need more information and more features to be able to efficiently do their job. Let them go looking for something they’d enjoy working in as long as it integrates with QuickBooks. We don’t want to make everyone else’s life harder just to make theirs easier. Your company needs to be integrated, but have the flexibility of letting them run with their strengths and the strength of the apps out there in the marketplace helping them do their jobs.
Consideration 3: Usage of QuickBooks Inventory tracking currently
What kind of information are you feeding into QuickBooks? QuickBooks does not read minds or hear the churn of the machines when a product is completely finished. It relies on data input (electronically or manually) in order to track properly. In order for QuickBooks to track properly, you need to have entered data in the following order:
- Purchase Order for raw materials not yet received (this can be skipped if not applicable)
- Bill for raw materials received
- Build assembly to use up raw materials and produce a finished good
- Sell finished goods
The biggest problem we see in QuickBooks inventory is selling inventory you don’t have. If QuickBooks doesn’t think you have it, then your data entry process is broken down somewhere. If you don’t really have it, then you shouldn’t be selling it, so question your processes before questioning the system. We either have to buy or make the product in order to sell it. So when did I make it? What went into making it? And when did I buy the parts to make or sell? Then go find those transactions and point them in the right direction. We cannot just have all of our credit card charges and bills hitting Cost of Goods Sold while we are simultaneously trying to track our inventory on hand.
Consideration 4: Information you wish you had
What surprises have you encountered in your inventory tracking? What information do you think you should have at your fingertips (because it shouldn’t be that hard) but that it’s like pulling teeth to get? If you’re looking for tracking information, then you can probably be effective inside of QuickBooks. But if you get stressed wondering what you should have on your shelves to handle the busy season starting next month or trying to schedule production to handle the ramp-up of inventory stock, or how long it’s taking to turn around your sales orders, then you are ready to find the right inventory management and analytics platform. Just make sure it still integrates with QuickBooks.
Consideration 5: Complexity of Inventory costing
What exceptions to a standard bill of materials do you run into? Do you want to incorporate labor and overhead into your inventory costing? Do you need to track landed costs in your inventory? If you “sometimes” change up a build because you substitute a product here and there, then that’s easily done in QuickBooks. Perhaps you have custom orders all the time, so you’ll want to look at add-on software. If you want to incorporate labor and overhead at a standard rate, then QuickBooks can do it, but if you want more of a job costing production approach, you’ll want add-on software. And if you want to track landed costs, you’ll want add-on software.
Consideration 6: Desktop Apps to expand your Inventory Management resources
These applications are either local or hosted, but they are installed on computers and not usually accessible via the cloud. Some may have mobile apps that give you limited visibility and/or functionality. Let us know if you’re interested in speaking with them, as we likely have partner relationships with them to get you the best value.
- Fishbowl Manufacturing – the Number 1 add-on to QuickBooks desktop. Fishbowl brings many additional features to help increase your management in manufacturing, selling, distribution, warehousing, and bar coding. Visit them here: https://www.fishbowlinventory.com/
- TrueCommerce EDI – bring together your B2B orders through EDI and your B2C orders through webstores to have a convenient and efficient way to fulfill orders and keep QuickBooks updated on what’s happening. Visit them here: https://www.truecommerce.com/
- Acctivate Inventory – Manage your orders, inventory, and purchasing. Use these tools to grow your business and gain insights to help you make better business decisions. Visit them here: https://acctivate.com/
Consideration 7: Cloud Apps to expand your Inventory Tracking resources
These applications are cloud-based, often mobile-friendly. You’ll want to find out whether they integrate with QuickBooks Desktop or Online or both. Let us know if you’re interested in speaking with them as we likely have partner relationships with them to get you the best value.
- SOS Inventory – the longest-standing inventory application compatible with QuickBooks Online. Handles multi-location inventory tracking, manufacturing, WIP, serial number tracking, and order management. Visit them here: https://www.sosinventory.com/
- DataNinja – customize your system to meet your manufacturing needs. Keeping things traceable, controlled, visible, and correct is easy inside of DataNinja. Maintain batch records that are searchable and retrievable. Integrates with QuickBooks Online and desktop, relying on the QuickBooks inventory tracking to maintain accounting. Visit them here: https://www.dataninja.com/
- BoxStorm – starts free with enhanced, cloud-based purchasing and selling for limited items. Integrates with QuickBooks Online. A great alternative to spreadsheets and whiteboards. Does not currently support any manufacturing. Visit them here: https://www.boxstorm.com/
- Fiddle – Develop custom builds with clients using price costing tools. Connect your purchasing with suppliers. Generate production work orders with accurate procedures and quality control. Include batch tracking of raw goods and production in order to quickly dial into the information you need. Visit them here: https://fiddle.io/
At Squire, we’ve seen countless scenarios for tracking and managing inventory. Each system has its own strengths and limitations, so do your research, or let us help you through it. Get back some sleepless nights and gray hairs by upgrading your system and processes so that you know what you’ve got, where it is, how much money is tied up, what that’s worth in future sales, what is currently in the pipeline, and what to do next with your inventory. Contact us at (801) 225-6900 for the help you need today.