Premises — property operations platform
SupportStart free
Inventory4 min read

Stock as a ledger: why we record movements, not counts

A stock count typed into a box is wrong by the time you close the box. A list of what came in and went out is right by construction, and it knows things a count never will: who, when, where, and at what cost.

By the end of this pageYou will understand the six movement kinds, why stock and value are computed, and how the ledger feeds invoices and the P&L.
On this pageSix kinds of movementWhat is computedWhat a count can't tell youThe monthly count still matters
Six kinds of movement, one numberAnimated
Bottled water 500 ml · movementsDATEKINDQTYWHERENOTE1 AugPurchase+40Storage₱ 18 each4 AugTransfer6Storage → 2E9 AugSold−22E₱ 35 each · on invoice12 AugUsed−11Acleaning15 AugDamaged−13Cbilled at cost31 AugAdjust−1Storagecount: 29, system 30STOCK RIGHT NOWStorage 332E 4 · 1A 0 · 3C 0computed from the lines, never typedVALUE AT COST₱ 66637 × ₱18 · P&L charged as used

Six kinds of movement

Purchase — into storage, with the unit cost on the line. Transfer — between storage and a unit, or between units. Use — consumed in a clean or a repair, against a unit. Sale — to a tenant, at the selling price, creating an invoice line. Damage — lost or broken, optionally billed at cost. Adjust — the month-end count differs from the computed stock, recorded with a note.

What is computed

Stock anywhere — storage, each unit — is the sum of movements in and out of that place. Value at cost is stock times the cost remembered on the purchase lines. Consumption this month is the sum of use, sale and damage lines dated this month, at cost, and that is what the P&L charges — not what you bought. Why purchases are not expenses.

What a count can't tell you

That 2E's shelf ran out twice this month and the cleaner topped it up from storage both times. That the last bottle sold was sold by Shane on the 9th and invoiced. That a case went missing between the 15th and the 31st. Each of those is a line in the ledger and a line in the audit log, which is why a ledger is also an honesty instrument.

The monthly count still matters

Count storage once a month. Where it differs, record an adjustment with a reason. A ledger that is never reconciled drifts; one that is reconciled monthly is usually within a unit or two, and the adjustments tell you where the leaks are.

Three categories, fixed. Food, beverage & toiletries (sellable); cleaning & maintenance (consumed); assets (furniture, appliances — tracked, not consumed). The category decides which movements make sense and where the cost lands.

Related

Describes the platform as it is today. Something out of date? Tell us. · help 0.12.3