Warehouses and stock tracking

Warehouses and stock tracking are powerful but optional. Most service businesses don't need them; some can't function without them. Here's the decision framework and the setup mechanics.

Updated 16 hours ago 3 views inventory warehouses stock adjustments

Warehouses and stock tracking

Warehouses and inventory tracking are some of Suprata's more powerful features and also some of the most over-applied. A lot of service businesses turn them on because they "should" track inventory, get tangled in adjustments and reconciliations, and end up with stock counts that don't match reality. A smaller number of businesses genuinely need real inventory tracking and find these features indispensable.

This article covers the decision (do you actually need this?), the setup mechanics if you do, and the operational discipline that keeps stock counts accurate.

When you need warehouse and stock tracking

Use it if all of these are true:

  • You physically stock parts in known locations (a warehouse, a truck, a service van) and care which location has what.
  • You track quantity-on-hand as a real number you'd report to your accountant.
  • You want stock-level alerts (reorder when below threshold) or per-item movement reports.
  • You buy in bulk and use over time (rather than buying per-job, which is "just-in-time" and doesn't really need stock tracking).
  • You're prepared to do periodic counts to keep the system honest.

If you order parts per-job and they never sit on a shelf, you don't need this. If you have one shop with one set of parts and don't care about quantities, you don't need this. If you need it on paper but won't actually do counts and reconcile, you'll have an inaccurate system that's worse than none.

Examples that benefit

  • HVAC contractor with a parts warehouse and stocked vans. Filters, capacitors, common refrigerant — bought in bulk, used over months, distributed across multiple vans.
  • Plumbing company with a shop and trucks. Common fittings, valves, pipe — high turnover, moderate variety.
  • Electrical contractor stocking commodity items. Wire, switches, breakers, fixtures.
  • Marina with chandlery items for sale. Ropes, hardware, cleaning supplies — actually retailed to customers.

Examples that don't

  • A solo handyman. Buys parts at the hardware store on the way to each job. No stock to track.
  • A consulting business. Service-only, no parts.
  • A reservations business that sells reservations primarily, not goods.
  • A tech-savvy small contractor with a single van and 10 commonly-used parts. Could probably manage with a notebook; the system overhead doesn't pay off.

How warehouses work

A warehouse is any physical location where you keep stock. Common types:

  • A central shop or storeroom.
  • A truck or van (each vehicle is its own warehouse).
  • A trade-show booth or pop-up location.
  • A consignment location at a customer's site.

The warehouses screen lists each location:

The warehouses list

Each warehouse has:

  • Name — what you call this location.
  • Address — physical location (matters for delivery and tax purposes).
  • Type / category — sometimes used to group warehouses (Shop, Vehicle, Customer Site).
  • Active flag — disable the warehouse without losing history.

When you sell or use an item, the system can subtract from a specific warehouse's stock. When you receive parts, you specify which warehouse received them. The stock count per warehouse is what you can report on.

Stock counts — what's actually in each warehouse

The detailed warehouse view shows what's stocked there:

A specific warehouse with its stock

Stock counts are a running balance, computed from:

  • Receipts — when you receive items (inbound shipments, restocks). Increase stock.
  • Sales / uses — when items go out on a job or invoice. Decrease stock.
  • Transfers — moving stock from one warehouse to another. Decrease one, increase the other.
  • Adjustments — manual corrections (counts found different from system, damaged stock written off, found stock added in).

The system maintains the math; what it can't do is tell you whether the math matches reality. That's what physical counts are for.

The receipt-to-job flow

A typical inventory-tracking flow:

  1. Vendor delivers 50 air filters to your shop warehouse. You record a receipt — 50 filters added to Shop warehouse stock.
  2. Tech loads 5 filters onto Truck #2. You record a transfer — 5 filters out of Shop, 5 into Truck #2.
  3. Tech installs 1 filter on a customer's job. The job's invoice has the filter as a line item; saving the invoice (or marking the job complete) decrements 1 filter from Truck #2's stock.
  4. At end of week, Shop has 45 filters, Truck #2 has 4 filters, total 49. One filter was sold; 49 remain.

That arithmetic is the whole point. If at end-of-week the actual physical count of Truck #2 shows 3 filters and the system says 4, you have a discrepancy of 1 — and an adjustment records the correction.

Stock adjustments

Adjustments are the system's way of saying "I am admitting the records and reality don't match, here's why." Common adjustment types:

  • Found stock — a count revealed more than the system thought; add to inventory.
  • Missing stock — a count revealed less than the system thought; remove from inventory.
  • Damaged / written off — items broken, expired, or otherwise unusable; remove with a damage reason.
  • Used internally — items used for something not on a customer invoice (a tech grabs a tool for the shop, marketing samples, etc.).
  • Returned to vendor — items sent back to the supplier; remove with a return reason.

Every adjustment should have:

  • The item.
  • The warehouse.
  • The quantity (positive for adds, negative for removes).
  • The reason — chosen from a list of adjustment reasons.
  • A note for context.

The reason matters because it powers the "where is my stock going?" report. A warehouse where 30% of the variance is "damaged" tells you something different from one where 30% is "used internally" or "missing".

Periodic physical counts

Stock tracking only works if you actually count. A monthly or quarterly cycle is typical:

  1. Pick a warehouse (or all).
  2. Print or pull the system's expected stock list.
  3. Walk the warehouse, count each item, write the actual.
  4. Compare actuals to expected.
  5. Record adjustments for differences, with reason codes.
  6. Sign off and move on.

Skip the count cycle and stock counts drift. Within six months, the numbers in the system have nothing to do with reality and you've lost the value of inventory tracking.

For high-turnover items, count more often (weekly even). For low-turnover items, quarterly is fine. The system doesn't enforce counts; the discipline is yours.

Permission gates

Inventory and warehouse functions usually sit behind a permission gate so that not every staff user can adjust stock. Typically:

  • Techs can record items used on a job (which decrements stock automatically).
  • Inventory managers can record receipts, transfers, and adjustments.
  • Admins can do everything plus reconfigure warehouses.

Setting up these permissions is part of users and roles. The default is usually fine for small teams; fine-grained inventory permissions matter once you have multiple warehouse staff.

What does and does not sync to QuickBooks

If QuickBooks is connected:

  • Items marked as Inventory in QB can have stock-level updates pushed.
  • Sales of inventory items affect QB COGS (cost of goods sold) and reduce QB inventory quantity.
  • Vendor receipts (purchases) increase QB inventory.

The QB inventory feature is itself complex and not all QB Online editions support it. Verify your QB plan supports inventory tracking before relying on the sync.

For Suprata-only stock tracking (when QB isn't doing inventory), you still get internal reports — they just don't flow to QB.

Common mistakes

  • Turning on inventory tracking without committing to counts. Within months, the numbers are fiction. If you won't count regularly, don't track stock — track cost in pricelist items only.
  • Creating too many warehouses. Each truck as its own warehouse is fine for HVAC; each shelf in a single shop is overkill. Match warehouse granularity to how you actually move stock.
  • Inconsistent receipt practices. Tech grabs parts off the truck without anyone recording the use; system stock balance drifts immediately. Discipline at the receipt and use level is what makes inventory work.
  • Not adjusting damaged or expired stock. Items that physically aren't usable but still show in the system make stock counts wrong. Adjust them out with a damage reason.
  • Manually editing stock counts to "match reality" without recording the adjustment. That's how audit trails get destroyed. Always go through the adjustment mechanism so the variance and reason are captured.
  • Confusing pricelist items with inventory items. Service items (labor) don't have stock; product items do. Make sure each item's type is set correctly so the system knows whether to track stock at all.
  • Letting truck stock drift forever. Trucks are the warehouses most likely to be off — techs use parts, don't record, and counts get bad. Either count trucks regularly or simplify to one shop warehouse and treat trucks as informal carries.
  • Trying to track every little commodity. Screws, washers, electrical tape — items that cost pennies and where counts will always be approximate. Better to set them up as expensed consumables (charged on jobs but not stock-tracked) than to obsess over count accuracy.
  • Over-reliance on transfers. Every move from shop to truck logged formally is overhead. If your team is small, treat the shop+trucks as one warehouse and reconcile by counting all of them periodically rather than logging every micro-move.

Related articles