Bar Product Report — Stock Movements

Bar Product Report — Stock Movements in IZI CRM

The Movements tab inside Analytics → Product Report is a line-by-line log of every change to your bar’s stock levels. Each row represents one operation: a purchase receipt that added stock, a bar sale that consumed it, a manual write-off for damage or promotional use, or an inventory correction after a physical count. Next to every row, IZI automatically calculates the cost using FIFO — the cost of whichever batch arrived first and has not yet been fully consumed. To open it: Analytics → Product Report → Movements, choose a date range, and optionally filter by product or operation type.

The report serves two purposes for a club owner: stock control (does the system balance match physical reality?) and cost control (is bar margin calculated correctly as purchase prices change?).

---

What operations appear in the movements log

Four operation types are recorded. Each appears as its own row with a type label, timestamp, quantity delta, and FIFO unit cost.

Operation type	Effect on stock	Additional data captured
Receipt (purchase invoice)	Increases	Purchase price, supplier, date
Bar sale	Decreases	Sale price, FIFO cost, shift and admin
Manual write-off	Decreases	Reason (damage, loss, promo), FIFO cost
Inventory adjustment	Increases or decreases	Inventory document, date, responsible staff

Why FIFO changes what you see in the report

Imagine you received 30 cans of a drink early in the month at price P₁, then 20 more cans mid-month at price P₂ where P₂ > P₁ (the supplier raised their price). When 10 cans are sold at month end, IZI costs them at P₁ — the earlier batch is not yet exhausted. Reported margin will be higher than if the system used today’s purchase price.

This is not an error — it is standard accounting. The key insight: when purchase prices are rising, FIFO margin in the report is optimistic during the transition between batches. Watch for the point when your old batch runs out; that is when reported margin shifts downward to reflect the newer, higher cost.

---

How to read the report: owner view vs. admin view

The Movements report operates on two levels.

For the owner — it is a cost and staff control tool. Look at the period totals:

• Total units and spend received (at purchase cost)
• Total units sold and average FIFO cost per unit
• Total units written off and the reason breakdown
• Closing theoretical balance and whether it matches the physical count

For the admin — it is a reconciliation history. If a stocktake reveals a shortage on a specific product, the movements log shows every operation and pinpoints the moment the balance began to drift from reality.

---

Using the Movements report to control stock accuracy

The theoretical balance in the report and the physical count on the shelf should match. When they do not, the cause is usually one of four things.

Common reasons for discrepancies

1. A purchase invoice was never entered Stock arrived physically but no receipt was created in the system. The report balance is understated. Rule: enter the invoice before selling from the new batch, otherwise FIFO is calculated from the wrong cost.

2. Sales made outside the system A staff member accepted cash for a product without ringing it through IZI. The physical count will be lower than the report balance. Cross-reference with the Suspicious Operations report — it flags anomalies in cash transactions.

3. Wrong item or quantity in a manual write-off The wrong product was selected, or the quantity was entered incorrectly. The Movements report shows the exact action with date, staff member, and quantity, making it straightforward to identify.

4. Inter-location transfer without a document In a multi-location club network, stock physically moved from one location to another but no internal transfer was recorded. The sending location shows an unexplained shortage; the receiving location shows an unexplained surplus.

Reconciliation workflow

1. Open the Movements report for the period since your last inventory count
2. For each product: opening balance + receipts − sales − write-offs = theoretical closing balance
3. Compare that figure with a physical count
4. If the gap exceeds your tolerance (for example, more than 5% by units) → review operations row by row for that product

IZI calculates the theoretical closing balance automatically — it appears in the right-hand column of the report. No manual arithmetic needed.

---

Movements report and bar margin: parametric view

The Movements tab is the foundation for calculating real bar margin. The formula per product:

Margin per unit = Sale price − FIFO cost
Total margin = Margin per unit × Units sold

The sum across all products for a period is your bar margin for that period. A more focused breakdown by product is available in the adjacent Products tab.

Parametric benchmark for owners. There are no universal “correct” margin figures — they depend on your assortment and region. Work from your own purchase cost:

Target markup % = (Retail price / Purchase price − 1) × 100

If your average bar markup is N% but the report consistently shows less, investigate: products may be sold with discounts or promotions reducing realised price; newer batches with higher purchase costs may now be flowing through FIFO; or unrecorded write-offs are inflating consumed stock.

---

Manual write-offs: when and how to use them

A manual write-off covers any case where stock left without a sale:

• Damage and spoilage — a broken bottle, expired product
• Promotional giveaway — a free drink for a tournament winner
• Inventory shortage — the physical count came in below the system balance

Each write-off reduces stock and appears in the Movements report as its own row. FIFO cost is applied from the current oldest remaining batch.

Always record a reason when creating a write-off. That reason field stays in the Movements log, so in three months you can still see why 40 cans were written off as “damage” in one particular shift.

---

How Movements connects to other report sections

The Movements tab provides the detail. Use it alongside adjacent sections for operational decisions.

Question	Where to look
Which products sell best and what is their margin?	Product Report — Products
How much stock is on hand and what needs reordering?	Product Report — Warehouse
Overall bar performance summary for a period	Product Report — Overview
Bar sales by shift and staff member	Shift Report
Anomalies in cash register operations	Suspicious Operations

---

Practical routine: monthly inventory cycle

A workable rhythm for a club bar with 20–40 product lines:

Weekly (5 minutes):

• Open the Movements report for the last 7 days
• Check the top 5 fast-moving items: compare the theoretical balance with a quick visual count
• If there is a gap, drill into that product’s operations for the week

Monthly (30–60 minutes):

• Full inventory count — physically count every item
• Compare with the theoretical closing balance from the Movements report
• Create write-offs or inventory adjustments for any confirmed discrepancies
• Review the write-off breakdown: categories with outsized totals beyond normal spoilage may indicate leakage

On staff changes:

• Run a stocktake before the new staff member’s first shift
• If the physical count differs from the theoretical balance, record an inventory correction to establish an accurate starting point
• Everything that happens after that correction is tied to the new staff member’s tenure — a clean audit trail with no ambiguity

---

Frequently asked questions

How do I verify that purchase prices in receipts are entered correctly?

Open the Movements report and filter by operation type “Receipt”. Each row shows the purchase price for that batch. If a price differs from your actual supplier invoice, FIFO will cost all sales from that batch incorrectly. Correct the invoice before the batch starts selling to avoid downstream margin errors.

What should I do if I want to reset all balances and start fresh?

Run a full inventory count and record the physical quantities as an inventory adjustment in IZI. The system will create a correction entry that brings the theoretical balance in line with the physical reality. That adjustment appears in the Movements log as its own row. All previous history is preserved — nothing is deleted or overwritten.

Does the Movements report feed into financial accounting?

Not directly — IZI is a club operations platform, not a general accounting system. However, the data it produces (total cost of goods sold, write-off volumes by period) is the primary source for management reporting and can be handed off to your accountant as supporting documentation for inventory movement.