StoreCashierDocumentation Free 1.6.6 Pro 1.5.6 Apps 1.5.0

Stock reports FREE PRO

How much stock you have, where, what it is worth, what to reorder, what is about to expire and how stock moved through adjustments and transfers. Stock, valuation and low-stock reports always show the situation now; adjustment, transfer and lot reports cover the chosen period.

Where: Reports → Stock Report · Stock Valuation Report · Low Stock / Reorder Report · Expiry Report · Lot Report · Stock Adjustment Report · Stock Transfer Report

Stock Report FREE#

Stock report with closing stock by purchase and sale price, potential profit and margin cards and a table per product, variation and location
One row per product, variation and location.

Cards: Closing stock (By purchase price), Closing stock (By sale price), Potential profit (sale value − cost value) and Profit Margin %. Columns: Action (stock history), SKU, Product, Variation, Location, Selling Price, Current stock, Value (Purchase), Value (Sale), Total unit sold. Only products with stock management are listed.

Stock Valuation Report PRO#

Stock valuation report with units, value at cost, value at retail and potential profit cards, value by location and per product table
Stock value at cost and at retail, per location and per product.

Cards: Units in stock, Stock value at cost, Stock value at retail, Potential profit. By business location: Location, Units, At cost, At retail (with a chart). Per product: Product, SKU, In stock, Unit cost, Unit price, Value at cost, Value at retail, Share of stock value; Total.

Low Stock / Reorder Report PRO#

Low stock reorder report with low stock, out of stock and estimated reorder cost cards and table with alert quantity, daily sales, days of cover, suggested reorder and last supplier
What to reorder, how much and from whom.
ColumnHow it is worked out
Product / SKU / LocationEach stock-managed product (variation) per location at or below its low-stock threshold (the same rule as the dashboard Low Stock Alerts tile).
In stockCurrent quantity at that location.
Alert qtyThe threshold used: the product's alert quantity; when it has none, the WooCommerce “Low stock threshold” of the variation, then of the product; else the store-wide WooCommerce threshold (default 2). See Low stock & reorder.
Avg. daily sales (30d)Units sold at that location in the last 30 days ÷ 30.
Days of coverIn stock ÷ average daily sales.
Suggested reorderTarget − in stock, where target = the larger of 2 × alert qty and 30 days of sales.
Last cost / Reorder valueLast purchase price (else the purchase price) and suggested qty × last cost.
Last supplierSupplier of the most recent purchase of the product.

Cards: Low stock items, Out of stock, Estimated reorder cost. New Purchase opens a purchase. When nothing is low: “Nothing to reorder — every tracked product is above its alert quantity.”

Expiry Report PRO#

Expiry report with lots, expired, expiring within 30 days and stock at risk cards and window buttons
Lots by expiry date.

Window: All, 7, 30, 60, 90 or 180 days. Cards: Lots with expiry, Expired, Expiring within 30 days, Stock at risk (expired, at cost). Columns: Expiry date, Days left (negative = expired), Product, SKU, Lot, Location, Qty received, Current stock, Unit cost. Expiry dates are entered when receiving purchases or opening stock.

Lot Report PRO#

Lot-tracked purchases in the period: Lot Number, Product, SKU, Purchase, Purchased (date), Qty Purchased, Qty in Ledger, Unit Cost, Expiry. Requires lot numbers enabled in purchase settings.

Stock Adjustment Report PRO#

Cards: Total Adjustment Amount, Total Amount Recovered, Adjustments. Table: Date, Reference, Location, Type (normal / abnormal), Total Amount, Recovered; Total. The net (amount − recovered) is the stock adjustment line of the Profit / Loss.

Stock Transfer Report PRO#

Cards: Transfers, Units moved, Value moved, Transfer shipping; chart “Units moved per route”. Table: Date, Reference, From, To, Status, Lines, Qty, Value, Shipping, Added By, Note; Total.

IMEI / serial numbers have their own report: IMEI / serial number report.

Why doesn't a product appear in the Stock report?

Only products with stock management enabled in StoreCashier are listed. Products imported before installation may also need their opening stock.