How to Prepare for EOFY Stocktakes in Melbourne for Your Liquor Store

 

EOFY stocktakes do more than balance shelves with your books—they underpin financial statements, tax lodgements & audit readiness. Below is a practical guide for liquor retailers in Melbourne. We cover what to prepare, how to count, which reports auditors expect, and how to handle write-offs without risking compliance issues.

1) Build an EOFY timeline (work back from 30 June)

Create a dated plan with owners for each step. A clear sequence reduces errors & recounts.

• T-8 to T-6 weeks: Lock your valuation method (FIFO or weighted average), freeze SKU rules (sizes, pack conversions), and publish your count SOP. Confirm staff availability & assign area ownership.

• T-6 to T-4 weeks: Clean the item master (merge duplicates, fix unit sizes, map barcodes). Configure blind counting in your POS or stock platform. Set variance thresholds (e.g., ±2 units for spirits, ±6 for beer slabs).

• T-3 weeks: Run a mock count in one bay to test scanners, labels, pack conversions & recount workflow. Finalise the write-off policy & evidence requirements.

• T-2 weeks: Schedule deliveries to land before/after count day—not during. Print shelf labels for any unlabelled SKUs. Pre-build the reporting pack template.

• Count day (T-0): Pause movements, perform blind counts, reconcile variances, sign off.

• T+1 to T+5 days: Complete valuation, post write-offs, finalise the inventory roll-forward & archive evidence.

Melbourne retailers should lock in logistics early—winter demand spikes for spirits & red wine can distort on-hand figures if deliveries land mid-count.

2) Set your compliance foundations

Auditors expect consistency, evidence & controlled processes. Get these foundations in place before count day.

• Documented policies: Stock valuation method; write-off categories; recount rules; who can approve adjustments; how to treat consignment, promo stock & customer lay-bys (if any).

• Evidence trail: Date-stamped count sheets or mobile logs, photos for damaged/leaking items, supplier credits for returns, and POS snapshots at freeze time.

• Segregation of duties: Different people for counting, investigating variances & posting adjustments. Managers do final review & sign-off.

• Data retention: Archive the count SOP, signed variance approvals, the valuation report, and the movement roll-forward from last count to EOFY.

3) Clean your item master before you count

Accurate masters reduce variance noise and speed reconciliation.

• Unify units: Map common pack sizes (e.g., 24-pack beer, 6-pack wine, singles) to one base unit with clear conversions.

• Standardise descriptions: Brand | Product | Size | ABV | Pack (e.g., “Jameson Irish Whiskey 700ml 40% 1×1”).

• Barcode hygiene: One barcode per sellable unit. Record inner/outer barcodes for cartons vs singles.

• Classify properly: Use categories (beer/cider/wine/spirits/RTD), plus “high-risk” flags for premium spirits & limited releases.

4) Design a liquor-specific counting method

Liquor ranges create unique pitfalls. Calibrate your approach to avoid them.

• Split & open packs: Record partial cartons using the base-unit rule. Train staff to convert quickly (e.g., 1 carton + 5 singles = 29 units if base is singles).

• Look-alike SKUs: Adjacent facings of near-identical bottles (e.g., 700ml vs 1L) cause miscounts—space them apart or add colour labels for count day.

• Back-of-house & displays: Count dump bins, window displays & under-counter stock. Temporary displays are frequent variance sources.

• Age & quality: Track best-before dates for beer/RTDs; store photos for spoilt, oxidised or heat-affected stock to support write-offs.

• Premium control: Double-count high-value spirits & gift packs; require manager verification before posting variances.
  
  

5) Control the day: freeze, blind count & recount

A disciplined count day is your best defence against audit queries.

• Movement freeze: Stop sales, transfers & deliveries during the snapshot. If trading through, time-box the snapshot and capture POS movement logs.

• Blind counting: Counters see SKU & description—but not expected quantity. This prevents “counting to the book.”

• Two-pass method: First pass to capture, second pass to verify high-risk areas & material variances.

• Variance thresholds: Auto-recount when value variance exceeds your threshold (e.g., >$200 per line or >5% of expected).

• Sign-offs: Area owners sign their zones; manager signs the master reconciliation.

6) Handle write-offs correctly (breakage, spoilage, theft)

Write-offs must be specific, consistent & evidenced.

• Categories: Breakage, leakage, spoilage/expired, shoplifting, staff error, supplier short-delivery, promotional sampling.

• Evidence: Photo, incident note, witness/manager sign-off; supplier credit for short-supply; police or insurer reference for theft where applicable.

• Timing: Prefer posting write-offs before valuation so your inventory value reflects saleable stock only.

• Analytics: Review write-offs by category, brand & location each quarter to reduce recurring loss.

7) Produce an audit-ready reporting pack

Assemble a single, dated pack that ties opening to closing inventory and agrees to the GL.

• Inventory valuation report: Quantity × cost by SKU, with method noted (FIFO/weighted average). Include the pricing source & last updated date.

• Count variance report: Expected vs counted quantities & values, with cause codes and approvals.

• Write-off register: Line-level detail with evidence references.

• Roll-forward reconciliation: Opening stock + purchases – cost of sales ± adjustments – write-offs = closing stock (tie this to the balance sheet).

• Aged & slow-moving stock: Identify discount/return actions for lines >90 days on hand (beer/RTDs) or beyond normal rotation.

• Sign-offs: Area owners, store manager, and if applicable, our supervisor/your accountant.

8) Align with tax & financial statement needs (practical pointers)

Keep the content high-level & practical—your tax agent will advise specifics.

• Valuation method disclosure: Use one method consistently. Document any change and quantify the impact.

• GST support: Ensure purchase invoices exist for counted stock; retain supplier ABNs & tax invoices.

• Pricing evidence: Archive a cost snapshot per SKU (supplier file or last invoice) used for valuation.

• Cut-off discipline: Separate pre- and post-EOFY deliveries with clear GRN timestamps to avoid misstated balances.

9) Strengthen controls for next year (make EOFY easier)

Treat EOFY as a springboard to simpler, cleaner stock control.

• Cycle counts: Monthly for high-risk spirits; quarterly across the full range.

• Exception monitoring: Flag negative on-hands, frequent refunds, scan-rate gaps & high discount items.

• Receiving controls: Two-person checks on premium deliveries; immediate barcode scan on receipt.

• Planograms & labels: Keep shelves labelled & planograms current to reduce mis-picks & miscounts.

• Training: Short refreshers on pack conversions, premium handling & evidence capture.

10) What we provide (so your EOFY is audit-ready)

We support Melbourne liquor retailers with disciplined, evidence-led stocktakes:

• Pre-count master-data clean-up & barcode mapping.

• Count-day execution with blind counts, scanners & variance tiers.

• Full reconciliation: valuation, roll-forward, write-off register & sign-offs.

• Auditor-friendly reporting packs & post-count recommendations.

As part of Stocktaking in Melbourne, we align count procedures with your POS, your chart of accounts & your auditor’s expectations—so the numbers tie out cleanly the first time. Our bottle shop Stocktaking Melbourne team standardises pack conversions, isolates premium-risk lines & documents evidence for every material adjustment.

Quick checklist 

• Valuation method confirmed & documented

• Item master cleaned (sizes, barcodes, pack conversions)

• Write-off categories, evidence rules & approvals set

• Movement freeze plan & blind-count settings tested

• Variance thresholds & recount rules agreed

• Deliveries scheduled away from snapshot window

• Reporting pack template built (valuation, variances, roll-forward, write-offs)

• Count-day staffing, zone ownership & sign-off flow mapped

• Post-count reconciliation calendar with GL tie-out booked

Final note

This guide is general information. Always confirm tax positions with your accountant or tax agent. If you’d like us to prepare, execute & reconcile your EOFY stocktake, we’ll align our process to your systems & audit requirements and deliver a complete evidence pack ready for review.