accountant advice

10 No-Nonsense Ways to Manage Inventory

Even though Kildal Services is slowly moving away from clients and projects that involve inventory, and towards service providers and general contractors, over the years we’ve seen just about everything that could go wrong – and right (just not as often) – with managing inventory.

We recently worked with a client that had been using QuickBooks® Pro, but because they needed online access, they didn’t use it to manage the inventory aspect of their company.

They used spreadsheets. ~Insert dramatic sigh here.~

As you can imagine, as they started to grow, the gap between accurate inventory and accurate bookkeeping was ever widening. This meant that they were unable to analyze and plan, and they almost crashed and burned when the marketing team made a big push to clear out inventory on the books … that they didn’t even have in stock.

Here are the 10 things they learned as we moved them from QuickBooks Pro + Spreadsheet to QuickBooks Online + SOS Inventory.

1. Don’t use spreadsheets . Spreadsheets can get deleted. They can have cell contents deleted. Entire rows and/or columns can get deleted. Formulas can get screwed up. Yes, yes, I know you can protect cells, but that rarely happens. People forget to update spreadsheets. Plus, then you have figure out a way to move that information into your accounting program. My suggestion to manage is always one of three options:

  • QBO Plus (for very simple and/or low volume inventory)
  • QBO + SOS Inventory (for warehouse/manufacturing inventory)
  • QBO + Dear Inventory (for warehouse/manufacturing inventory)

Why do I have two inventory apps? Because sometimes it’s just a matter of interface, and other times it’s pricing. I think SOS and Dear are two of the best inventory management tools on apps.com right now.

2. Name your products clearly.  Make it easy for your team to choose what to put on orders, or for people to buy online from you. Using manufacturer part numbers, or some internal part number, makes it REALLY easy for people to choose the wrong item. Example: CYO523008 or CYO523016? I have no idea. How about “Crayola Crayons Set of 8” or “Crayola Crayons Set of 16”? SO much easier, and I’ll take the 16 please and thank you!

3. Keep your warehouse organized.  If your team can’t find anything, how can they fill orders? How can you do a count? A messy warehouse shows team members they don’t need to be held accountable, can create many safety issues, and cost you money simply because it’s inefficient.

Keep locations and items clearly labeled, aisles free of clutter, and make sure your team knows exactly what is expected of them to keep the warehouse clean and organized.

4. Always order with purchase orders (PO).  I’ve had many, many clients have employees over the years place phone orders with vendors. This is 100 percent unacceptable for clients with whom we consult. Every inventory order needs to be entered in QuickBooks, or your inventory management app, via a purchase order, faxed or emailed to the vendor, and then provided to team members who are responsible for receiving. This creates a paper trail for your business, and ensures there is no confusion for the vendor about what has been ordered, when delivery is expected, what estimated costs will be and what payment terms are.

Many of our general contractors use POs for subcontracted services as well, as this allows them to verify any invoices for labor subs against scope and cost.

5. Compare delivery to the POs. If your business sends POs, then make sure your receiving team has access to them so that when inventory is delivered, they can verify that the numbers are correct. Make sure each delivery is counted and a team member provides notes if the delivered quantities differ from the packing slip and/or PO.

6. Set minimum stock levels.  Most inventory apps allow you set minimum stock levels or reorder points. This ensures that you never run out of popular items, or key components needed for assembly/manufacturing. Two of my favorite options in SOS Inventory are the ability to calculate reorder points automatically based on historical data and setting an alert for low inventory.

7. Do regular checks. You should do inventory counts on a regular schedule. People make mistakes when checking deliveries in and entering quantities into QuickBooks, and sometimes items just seem to grow legs and walk away. Staying on top of the inventory levels in QuickBooks will eliminate the problems that arise from not having enough of something to fulfill an order or complete a build.

You can either do a complete physical inventory (counting all of the inventory at the end of the month), or you can schedule cycle counting (counting small sections/groups of inventory on a specific day). The client that I mentioned at the beginning of this article chose to do both: surface area cycle counts (one aisle in their four aisle warehouse per week, doing one section at the end of each day) and one large physical inventory at the end of their fiscal year.

8. Document processes and include tasks in job descriptions. Clearly document the workflow for all warehouse activities. By documenting each task in a workflow (i.e. purchase/receiving, sales/fulfillment and warehouse maintenance/stock status), and including these tasks in team member job descriptions, there is no question as to what comes next, or whom is responsible for them.

Include backup and contingency plans for problems that can bring your business to a

Standstill, such as a delivery not making on time, an unexpected cash flow issue, a spike in sales that creates backorders for customers or being short-staffed during a busy season.

9. Limit access to inventory. This applies to both physical inventory and within your accounting and inventory management programs. By reducing access and creating separation of duties, you’re reducing, at worst, the risk of fraud and, at best, the number of people that can make errors. By establishing access rights, you can make sure each team member is trained properly on workflow and the tasks for which they are responsible. This will make is much easier to manage inventory and the system you manage, identify when changes should be made, and implement those changes when needed.

10. Evaluate what is selling – and who is buying that what. It’s important to know when stock levels are getting low, but it’s also important to be able to identify sales trends. Once this company was up and running with an accounting system that tracked what was selling, when it was selling and whom they were selling, sales went through the roof. They were able to be proactive about stocking items that were more popular during certain times of year and identify busy times during the year to get temp help hired and trained BEFORE it hit.

What they loved the most was that it enabled them to do some target marketing to customers that had purchased specific items in the past by offering sales on some older stock to clear out inventory and do some market research to determine whether there was a need and want for a new product they were considering .

All of this might seem overwhelming, but please remember: not all of this has to be done at once. With this client, we had them do some work before we even started our conversion to QBO and SOS Inventory setup – they got their warehouse organized and more understandable item names in place. Then, we started working with them on processes: current workflow and job descriptions, and where the pain points were for them. I would recommend finding someone that can help you break all of this up into different phases, and creating a project timeline to get each phase complete. And, I have to say that there are quite a few that you can find at findaproadvisor.com!


Related Articles

Mail icon
Get the latest to your inbox
No Thanks

Get the latest to your inbox

Relevant resources to help start, run, and grow your business.

By clicking “Submit,” you agree to permit Intuit to contact you regarding QuickBooks and have read and acknowledge our Privacy Statement.

Thanks for subscribing.

Fresh business resources are headed your way!

Looking for something else?

QuickBooks

From big jobs to small tasks, we've got your business covered.

Firm of the Future

Topical articles and news from top pros and Intuit product experts.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.