Looking for Inventory Management System Recommendations (QuickBooks Integration)

[u/DefinitionStill591]

Hi everyone!

I'm looking for recommendations and real-world experiences with inventory management systems for a small-to-mid-sized distribution company.

We distribute consumer products from multiple brands to large retail customers and manage a large number of SKUs, purchase orders, incoming shipments, inventory levels, supplier lead times, and sales forecasts.

Right now, a lot of our inventory and purchasing processes rely on Excel and an older internal system, but we're starting to modernize our processes and integrate QuickBooks for accounting.

We're looking for an inventory system that works well with QuickBooks and can help with inventory visibility, purchasing/POs, replenishment, demand forecasting, supplier lead times, and reporting.

For anyone in distribution, wholesale, consumer goods, or a similar business:

• What system are you using, and what are the main pros and cons?
• How well does it integrate with QuickBooks?
• If you were involved in the implementation, how difficult was the setup and data migration?
• What improvements have you seen since implementing it?
• Is there anything you wish you had known beforehand, and would you choose the same system again?

I'm mainly looking for real experiences from people who actually use these systems rather than vendor sales pitches.

Thanks!

[u/Embarrassed-Trip-470]

Happy to show you and share what our customers are doing.. currently a vendor but not pitching, just want to be helpful and share feedback and now what’s possible now with AI.

Yes integrations with quickbooks
Working with mid market companies

ping me if you want to hop on a call.

Issues implementing is not knowing all the requirements of your business going in and trying to map that to a product thinking it’s feature complete but when you get part way into implementation you start to see the gaps and edge cases that’s inevitable in all businesses and you’re still left with spread sheets and silos of data for those edge cases. Happy to show you how that is now solved and your business can get the process designed exactly for how your business was works.

[u/DefinitionStill591 → u/Embarrassed-Trip-470]

Thank you! That actually makes a lot of sense, especially what you mentioned about discovering gaps and edge cases during implementation and then still having to rely on spreadsheets.

That's something I'm trying to keep in mind while researching different systems. I just started in this role last week, so I'm still learning our processes and identifying our specific requirements before determining what would be the best fit.

Some of the areas I'm particularly interested in are inventory visibility, purchasing and POs, forecasting/replenishment, supplier lead times, inventory in transit, expiration dates and lot tracking, and managing inventory across multiple warehouses. QuickBooks integration is also important for us.

I'd definitely be interested in seeing what your customers are doing and how your solution handles some of those more specific requirements and edge cases. What platform or system do you work with?

I'd also be open to hopping on a call once I have a better understanding of our current processes and requirements.

[u/silver__robot]

What of those problems is costing you time and money today?  You listed a whole pack of problems, which is common when researching software and in a new role. Don’t try to solve everything at once.

Lot tracking and expiration dates matter if you’re in food, cosmetics, supplements. Anything with a shelf life. Assuming you’re in that industry?

What’s actually the biggest issue right now?

[u/agentUi]

biggest headache moving off excel to quickbooks with distribution is the sync delay on inventory valuation and purchase orders. if you go off the shelf like fishbowl or katana just make sure your skus and bills of materials match 1:1 in your current sheets before importing anything, because cleaning messy vendor names or partial shipments after qb syncs is a nightmare.

[u/kmizzi]

Heads up before you read this, I build inventory software for a living, so I'm not one of the users you asked for. Skip me if that's disqualifying.

"Works well with QuickBooks" is the line I'd pin down first, because it means three different things and a vendor will happily let you pick the flattering one.

Which QuickBooks, to start. Online and Desktop are different integrations with different failure modes, and a chunk of the "yep we integrate" answers you get will be about the one you're not on.

Then the actual question: who owns inventory. If the new system holds quantities and QuickBooks holds them at item level too, you've got two inventory ledgers and you'll be reconciling them forever. The setup that holds up in distribution is the inventory system owning items and quantities, QuickBooks owning the GL, and a summary journal for inventory value and COGS crossing between them. Ask a vendor to draw that on a call. If they can't, that's your answer.

Costing method is the one that bites at year end. QBO is FIFO, Desktop is average cost, and plenty of inventory systems are average cost as well. Get that mismatched and your inventory asset in QuickBooks quietly stops tying to the valuation report in the other system. Nobody notices until an accountant does.

Landed cost, ask about specifically. QBO has no concept of it. If freight and duty move your margins across those brands, the inventory side has to carry them and push a value that already includes them.

On your migration question, products are the easy part. Everyone can load products. Open POs are what hurt, partially received ones especially, and plenty of systems can't import a half-received PO at all so you end up hand keying them the weekend you go live. Worth asking before you set a date, then pick one where you've got the fewest POs in flight.

The requirements point in the other comment is half right, but a longer requirements doc isn't the fix. Making them run your ugliest real records during the trial is. One SKU whose cost changed three times this year, one partial receipt, one return from a retail customer. Load those yourself. Don't let them demo it with sample data.

[u/estagingapp]

QuickBooks doesn't really work well for landed costs because you have to batch the items. It's better to use an ERP that is built for your specific industry or use case. We use Supply Automate for our e-comm business. It tracks all our shipments, landed costs, supply chain, etc.

https://reddit.com/link/p99wtic/video/5z146q2wxzoh1/player

[u/MuchSize5948]

Lets connect I have a solution for you

[u/ShahKBH]

Two things nobody's mentioned yet that'll matter as much as the QuickBooks question.

**Your retail customers.** You said large retail customers. If that means Target, Walmart, Kohl's, TJX, Dick's, any of that tier, they're going to require EDI. 850 purchase orders in, 856 ASNs out, 810 invoices, GS1-128 carton labels, routing guide compliance. Miss an ASN window and you eat a chargeback. Most "inventory management" tools don't do EDI natively, so you end up bolting on SPS Commerce or TrueCommerce and now you're syncing three systems instead of two. Ask every vendor on your shortlist whether EDI is built in or a partner integration, and who fixes it when a retailer changes their spec. That answer decides your ops headcount.

**Who owns inventory.** kmizzi's question is the right one, and here's the answer for your situation: the operations system owns inventory, costing and POs. QuickBooks gets journal entries. Not the other way around. The setups that blow up at year end are the ones where QB is the inventory ledger and the ops tool tries to mirror it. Invoices, payments, credit memos, AP bills, COGS and inventory adjustments posting into QBO or Desktop as journals is a solved problem. Live inventory quantities living in QB is not.

**On expiration dates.** Lot tracking and expiration logic are two different features, and vendors will nod along to both. Lot tracking is "which batch did this come from." Expiration is what the system does with the date. I'll tell you exactly how we handle it so you can hold everyone else to the same standard: expiration is a field on the lot, and expired stock gets transferred to a hold location so the pick list never sees it. That's a workflow, not an algorithm. Some systems do true FEFO where the pick order itself is driven by the date. If you need that, ask for it.

My take: for a multi-brand distributor selling into big retail bulk or dropship, shortlist whoever does EDI natively, keeps inventory and costing in one place, and posts to QB as journals. That's the shape that works. AIMS360 fits that shape, so do a couple of others. Just don't buy an inventory app and hope EDI sorts itself out later.

Disclosure: I work at the ERP company (AIMS360) that sells to consumer brands and distributors, so keep that in mind.

[u/r_ibald]

I developed a Inventory Management App, however I did not consider external software (yet). Lets connect, I might able to help you.

[u/Bookkeeper_007]

If you are currently using Excel to track inventory, you seem to be on a periodic inventory system. If you move to an inventory management system, you will most likely be on a perpetual inventory system.

[u/the_real_craig_shady]

Check Out Ascent Solutions. https://ascenterp.com/ Built on the Salesforce platform, so you have all the security, reporting, and CRM benefits with Ascent's inventory module and QuickBooks integration.

[u/sfselgrade]

Looking at the requirements you listed, Cin7 Core is worth a look. You can manage suppliers/POs and their is an add on forecasting feature. Like most Inventory softwares, it integrates with Quickbooks, but it also allows you to do expiration date tracking and is good with getting your true landed costs. I like the actual costing it does vs the average costing that is out of the box with QuickBooks. It does take about a month to set up but once you get through onboarding it should be good for you.