Skip to content

Stock expiry and lot reports

All plansOwner / ManagerAccountantUpdated 15 Nov 2026

What you'll do: find the stock that expires soon so you can sell it first, and see what is left of each lot.

Before you start:

  • Your role needs View stock report.
  • Stock Expiry Report needs Product Expiry on (Business Settings → Products & Stock); Lot Report needs Lot Number on (Business Settings → Purchases). See Track lot numbers and expiry dates.
  • Filters, print and export work as in How reports work.

Open Stock Expiry Report

  1. Open Reports & Analytics → Reports → Stock Expiry Report.

  2. Press Filter (Filter Products): branch, category, brand and unit, the Expiry Window, and a Date Range of expiry dates.

    1 Filter · 2 Stock Left · 3 Expiry Date
  3. Read the report:

    • Product, SKU, Ref. No. (the purchase) and Location;
    • Stock Left, Lot No., Expiry Date and Mfg. Date;
    • Edit Expiry in the Action column corrects a wrong expiry date (Edit Expiry Date).
  4. Use Export CSV, Export Excel (XLSX) or Print above the table (Current Page Only or All Records). See How reports work.

Open Reports & Analytics → Reports → Lot Report. Press Filter (Filter Stock) for branch, category, brand and unit. Each row shows the Product, SKU, Lot Number, Expiry Date, Stock, Total Sold and Total Adjusted of one lot.

Was this page helpful?