Skip to content

Bar Write-Offs and Spoilage: How to Record and Control

Published: · Updated: (12 days ago)· IZI Team

Bar Write-Offs and Spoilage: How to Record and Control

Section titled “Bar Write-Offs and Spoilage: How to Record and Control”

Bar losses are inevitable: something will break, something will spoil, something will be used up in preparation. It is important to record every such situation in the system — otherwise stock diverges from reality, analytics gives wrong data, and it becomes unclear where the gap is.

Physical damage: a bottle dropped and broken, a can dented beyond saleable condition, packaging torn. Loss: an item has disappeared and nobody knows where or how.

Reason when creating the operation: “Breakage” or “Loss.”

Product has gone bad: expired, improper storage, changed consistency or smell. Applies to milk, juices, baked goods, perishable snacks.

Reason: “Spoilage” or “Expired.”

Ingredient usage above the standard recipe: milk spilled during frothing, syrup dripped off target, coffee burnt and had to be remade. This is normal operational loss, but it must be recorded.

Reason: “Production Losses.”

Order was cancelled after the item was already prepared. The item physically exists, the money was refunded — the item must be written off.

Reason: “Order Cancellation.”

Before going into the system — make sure the facts are clear: what exactly, how many units, the reason. For large or high-value write-offs — photograph the spoiled item.

Go to Warehouse → Write-Off (or Bar → Warehouse → Write-Off).

Item — select from the catalog.

Quantity — number of units to write off.

Reason — choose the type from the list: breakage, spoilage, loss, production losses, order cancellation.

Comment — required for any write-off. What exactly happened: “dropped during transfer,” “expired 30 May,” “spilled during coffee preparation.” Without a comment, the write-off looks suspicious on review.

Photo — attach if available, especially for:

  • Items above average value in the menu
  • Quantities above 3–5 units at a time
  • Any loss (no physical evidence)

Click “Confirm.” Stock decreases immediately. The operation is recorded in history.

If confirmation by a senior staff member is configured — the operation goes for approval. Until confirmed, stock may not update (depends on settings).

IZI has one built-in staff role — Administrator — plus any custom roles the owner creates (for example, a role named “Manager” with write-off approval rights). Control levels are configured through role permissions in IZI.

Recommended setup:

Administrator handles independently:

  • 1–2 units of an inexpensive item (water, snacks)
  • Obvious breakage with visible damage
  • Production losses within normal range

Requires approval from the owner or a custom role with elevated permissions:

  • Any write-off of a high-value item
  • More than 5 units at a time
  • Loss (no physical evidence)
  • Total shift write-offs above a set threshold

Configure thresholds in IZI role permissions — this reduces misuse risk without adding unnecessary bureaucracy for small operations.

Regular stock counts reveal discrepancies that were not documented through write-offs.

How it works:

  1. Count physical stock manually
  2. Enter the numbers in Warehouse → Stock Count
  3. The system shows discrepancies: where the physical count is below the system value — these are unrecorded losses

Discrepancy → investigation: what happened? If there is an explanation (breakage that was not recorded) — create a retrospective write-off. If there is no explanation — unknown-origin losses.

Recommended frequency:

Item TypeCount Frequency
High-turnover drinksEvery shift
Snacks, dessertsDaily
Hot beverage ingredientsEvery shift
Low-turnover itemsWeekly

More on the shift-close stock count procedure → Bar Shift Procedure: Opening and Closing.

Losses % = Total Write-Offs for Period / Bar Revenue for Period × 100%

Benchmarks:

  • Under 2% — good result
  • 2–4% — normal for a bar serving hot beverages
  • Above 5% — reason to investigate

View write-off totals in Warehouse → Operations History → filter “Write-Off” for the period. Bar revenue — in the shift report.

If most write-offs are “breakage,” look for a storage or transportation problem. If “spoilage” — a stock management issue (over-ordering perishables). If “loss” — a possible oversight problem.

Compare loss levels across shifts. If one bartender consistently shows higher losses — training or a disciplinary conversation is needed.

A bar write-off is a warehouse operation, not a cash transaction. It does not appear in a fiscal receipt and does not directly affect the shift X-report.

If your club operates with an online cash register — a corrective receipt is not required for a stock write-off. A receipt is only needed when refunding money to a customer (cancellation of a paid order). Verify the requirements for your jurisdiction with your accountant.

Frequently asked questions

What types of write-offs occur at the bar?

Three main types: breakage/loss (physical damage or disappearance), spoilage/expiry (item no longer fit for sale), preparation losses (ingredient usage above the standard recipe). Each type is recorded with a different reason in IZI.

Should I photograph spoiled items before writing them off?

Recommended for high-value items and large write-offs. A photo is evidence when a senior staff member reviews the operation and protects the staff member from accusations of theft.

Who should approve a write-off?

Depends on club policy. IZI has one built-in staff role — Administrator — plus any custom roles the owner creates (for example, a 'Manager' custom role with elevated permissions). Typically: small write-offs (1–2 units of an inexpensive item) — the administrator can handle independently. Large or high-value items — require approval from the owner or a staff member assigned a custom role with write-off confirmation rights.

How does IZI record a write-off?

Through an operation in the Warehouse section: the item, quantity, reason type, and a text comment are specified. Stock decreases immediately. The operation is saved in history with the staff member's name and timestamp.

Does a write-off affect the shift X-report?

No. A write-off is a warehouse operation, not a cash transaction. Only sales appear in the X-report. But loss analytics are visible in the warehouse journal.

How do I know if losses are too high?

Compare the write-off total against bar revenue. A normal loss level for a gaming center bar is 1–3% of turnover. Above 5% is a reason to investigate: spoilage, theft, or tracking errors.

What should I do if a stock count shows a negative balance for an item?

A negative means more was sold than was received in the system — either there was an error in receiving or items were consumed without a system operation. Correct via stock count and investigate the cause.