# Inventory

Inventory tracks your finished goods: what is on hand, where, and how it moves. For how products, package formats and date codes fit together, and how to load opening inventory, start with Finished Goods.

# How inventory is organized

  • Lots are finished product by product, package format and date code, at a facility and location. A lot is what you count, move and sell.
  • Tracked casks are one inventory item per cask fill, so each cask follows its own lifecycle.
  • Returned goods are recorded as separate quarantined inventory. They are not merged back into saleable lots.
  • Movements (transfers) move inventory: between facilities, to a customer, or from a taproom's cold box onto the bar.
  • Orders are the commercial record. The movement linked to an order is what changes inventory.

# How product moves

  1. Packaging a batch, or receiving finished goods, creates lots at that facility and location.
  2. A movement is requested: an internal move, an order fulfillment, a buyback, and so on.
  3. Whoever fills the movement chooses specific lots by date code. Fill Oldest First proposes the oldest lots to confirm.
  4. Completing the movement updates on-hand at both ends.

# Goods status

Product on Hand shows Finished Goods by default. Casks that are still conditioning and quarantined returns are kept out of it.

Use the Goods Status filter to review:

  • Finished Goods: normal saleable inventory.
  • Unfinished Goods: inventory that is visible operationally but not ready for finished-goods reporting, such as conditioning casks or quarantined returns.
  • All Goods: finished and unfinished inventory together, when available.

# Tracked casks

Casks are tracked as one inventory item per vessel use.

  1. Filling a cask creates a visible inventory item for that cask with quantity 1.
  2. The filled cask starts as unfinished goods while conditioning or finishing.
  3. Marking the vessel use Ready to Tap promotes only that cask to finished goods.
  4. Transfers allocate casks by cask number instead of date code.
  5. Transfer completion updates inventory location and keeps the vessel-use movement history aligned.

Use transfers for cask movement between facilities or locations. The vessel record tracks the vessel lifecycle and contents, but the transfer remains the operational inventory movement record.

# Taproom inventory

# Stocking the taproom

When the taproom draws from a shared cold box or warehouse, record the move like any other: a movement from the source location to the taproom. Every inventory move uses the same kind of record, so taproom stock is traceable in the same way as a wholesale shipment.

# Taproom POS consumption

Taproom POS days convert sales data into inventory consumption movements. The POS day is used to review product mapping and inventory availability, while the linked transfer remains the operational record for allocation, completion, and inventory impact.

Open a taproom day in Inventory → Taproom POS. Automatic POS depletion is set per taproom facility in Settings → Facilities → Taproom Operations. The taproom must be linked to an active Square location in Settings → Integrations before automatic depletion can be turned on.

  1. POS data is loaded for a taproom day.
  2. POS items are mapped to product and package format.
  3. Build Movement (or Rebuild Movement) creates the linked taproom consumption movement.
  4. The movement is allocated and completed from the source location configured for that taproom.
  5. Inventory impact is applied from the completed movement.

# Mapping Square items

Each line of a POS day is a Square item, and it has to be mapped to a product and package format before it can come out of inventory. Most lines map themselves. The rest show as unknown POS items.

To map a line, edit its mapping, choose the product and format, and choose Save Mapping. Other unknown lines with the same Square item are mapped at the same time, and the page says how many.

  • If the line is your product and you know the format but not which product, choose the format, then Product name unknown, and save. The volume stays visible for review and shortage reporting, marked Exception mapping.
  • Exclude Item is for lines that are not your product, such as food or merchandise, or whose format can't be known.

Edits are staged, not applied one by one. When the day's lines are right, choose Apply Edits & Rebuild Movement.

A saved mapping is kept for that Square item variation and used on later days, where the line shows a Saved mapping chip. You map an item once, not every day.

If a Square item's name is what prevents a correct mapping, fix the category, item name or variation name in your Square item catalog, then choose Refresh POS Data on the POS day. Refreshing reloads the day from Square and discards manual edits made on it.

Inventory → Taproom POS lists POS days and kegs on tap for each taproom. From its Actions menu you can Generate Missing POS Days for dates that have none, or Re-extract From Square to reload a range.

# Kegs on tap

A keg sold by the glass can't be depleted from inventory as a whole keg at the first pour. So when a keg goes on tap, it becomes a keg on tap: a lot of its own that draft sales deplete pour by pour. When that keg runs out, the next one is pulled from inventory. Draft and cask POS categories use this flow.

  • Already on tap means the POS day consumed from an existing keg on tap.
  • Put on tap means the POS day opened a new keg on tap from source inventory.
  • The Qty Available column shows source inventory plus a green keg-on-tap chip when a keg on tap already holds that product.
  • The keg-on-tap tooltip shows before, consumed, and after quantities.

If the mapped draft format has run out but another keg format is available, the POS day shows a Switch format warning on that row. Edit the row's mapping and rebuild the movement, so the pours come out of the keg that is actually on tap and the volume depleted stays correct.

To close out or correct a keg on tap, use Reconcile Keg On Tap. Choose Close / untap keg or Correct remaining qty.

# Draft loss

Some of every keg never reaches a glass: foam, line cleaning, spills. Set each taproom's expected loss as Draft Loss in Settings → Facilities → Taproom Operations. That rate turns poured volume into keg volume as kegs on tap are depleted.

When a keg on tap is reconciled, the dialog shows its actual loss beside the assumed rate. That is the keg-by-keg difference between what was sold and what left the keg. A per-keg figure that is consistently above or below the setting tells you to adjust the setting, or to look at the lines.

# Inventory exceptions

When inventory is missing or insufficient but the sales record is valid, record an inventory exception instead of deleting or skipping the inventory demand.

Inventory exception types tell the system whether follow-up is needed:

  • Pending inventory impact: inventory is expected to be recorded later. Use this when the inventory demand is real, but the package log or future package event has not created the lot yet. The system tracks an inventory obligation and can automatically deduct from matching inventory after the lot is created.
  • Inventory reconciliation required: the discrepancy is documented, but a manager still needs to review or resolve it manually. This keeps the item visible in inventory reconciliation instead of treating it as closed documentation.
  • Other documented discrepancy: the discrepancy is documented and no future reconciliation is expected. A written explanation is required.
  • Historical opening inventory gap: legacy or catch-up-only inventory that was physically available but absent from opening inventory records. Use this for historical documentation only; it does not create a follow-up reconciliation item.

The exception picker shows context for each type:

  • Auto reconciliation means the system will watch for matching inventory and apply the pending impact when possible.
  • Manual reconciliation means the exception should stay visible for follow-up in the inventory reconciliation workflow.
  • No reconciliation means the exception is accepted documentation and should not appear as an active follow-up item.

For taproom catch-up, the POS day provides a bulk close-with-exceptions action. The accepted exceptions are written to the linked movement so the transfer remains the plan of record.

# Pending inventory impact

Pending inventory impact is designed for timing gaps. Common examples:

  • A presale or POS day happened before the package log was entered.
  • A package log is known to be coming, but the movement or taproom consumption movement needs to stay visible now.
  • A future package event will create inventory within the normal matching window.

When selecting this type, choose why inventory is deferred:

  • Package log pending: the product is already packaged, but the package log has not been entered yet. Enter the expected date code or keg fill date. Matching is exact for that date.
  • Not yet packaged / preorder: the product will be packaged later. The system looks for matching lots created near the movement impact date.

Pending inventory impact may show as Waiting for inventory in transfer follow-up while the system waits for a matching lot. If the matching window expires, the package log is overdue, or automatic resolution fails, it changes to Needs review.

From Inventory → Reconciliation, use the reconciliation action to deduct a pending quantity from a selected inventory lot. This resolves only the pending exception quantity; it does not reallocate other movement lines.

# Inventory reconciliation required

Use Inventory reconciliation required when a discrepancy is real and documented, but should not be treated as resolved. This is useful for catch-up periods where the source event is in the past and you want the exception to remain visible until an audit, count, or manager review closes it.

This type requires an explanation and appears as follow-up in inventory reconciliation. It does not expect the system to find a future package log automatically.

# Returned inventory and quarantine

Most credit memos are financial-only and do not affect inventory. When returned product is physically received, the credit memo can be marked as an inventory return and linked to an inbound customer return transfer.

Returned inventory is received into the selected facility/location as quarantined, non-saleable inventory. It is excluded from the default Product on Hand view and normal allocation until it is manually reviewed and released, disposed, or adjusted.

The system records quarantine status, but physical marking remains an operational responsibility. Tag returned product or place it in a clearly marked area so the physical stock matches the electronic record.

# Where to work with inventory

  • Inventory → Product on Hand: current balances by product, format and facility, and physical inventory audits. See Physical Inventory Audits.
  • Inventory → Movements: movement requests, lot selection and completion.
  • Inventory → Item Lookup: a single lot or cask and its history.
  • Inventory → Taproom POS: POS day mapping, kegs on tap and taproom consumption movements.
  • Inventory → Audits: draft and completed physical inventory audits, and starting a new one. See Physical Inventory Audits.
  • Inventory → Reconciliation: shortages and inventory exceptions waiting on follow-up.
  • Inventory → Setup: opening inventory and historical catch-up (inventory admins only).
  • Batch packaging: creates new finished inventory.