The paper magazine register is costing you more than you think

Every display company has a magazine register, and most of them are well kept. Receipts go in. Issues to shows go out. Someone initials it. Nobody is arguing that the book should go.

The problem is what sits next to it. The stock spreadsheet. The supplier order in an email thread. The pick list on a clipboard. The register records what went in and out of the store, and everything else is a separate attempt to remember the same facts. By November the attempts disagree.

How the records drift

It starts small. A delivery arrives on a Friday afternoon. The pallets get broken down, the cases go on the shelves, and the register gets written up on Monday from the delivery note and memory. The delivery note says forty cases. Two were short-shipped. The register says forty, because that is what was on the paper.

Then a transfer. Ten cases go from the main store to the satellite unit for a run of shows. The main store's register shows them out. The satellite's register was in the van. It gets written up later, or it doesn't, and for a few weeks the same ten cases exist on paper in one store and not the other. Or in both.

Then the stock-take. Someone counts, the numbers don't match, and the difference goes into the spreadsheet as an "adjustment". No reason. No date beyond the tab name. The count is now the new truth, and whatever caused the gap is gone.

Through all of this the spreadsheet is copied, emailed and edited on two laptops. It was right in March, when someone sat down and rebuilt it from the register. It has been decaying since.

None of this is negligence. It is what happens when several records describe the same physical stock and none of them is the master.

What it costs

Three costs turn up every season. They rarely appear as a line on anything, which is why they are easy to ignore.

Re-ordering product you already had. The January order goes in against the spreadsheet. The spreadsheet says twelve of a particular cake. The shelf has thirty, because the last stock-take adjustment went against the wrong line. You buy more of what you had, tie up cash, and use up storage you will want in October.

A show picked short. The design calls for twenty of something. The spreadsheet says twenty-four in stock. There are sixteen. Nobody finds out until the pick, which is usually the day before, and the fix is a substitution agreed on the phone with the office. The register is not wrong here. It never claimed to know how many were left. That was the spreadsheet's job.

An afternoon reconstructing what happened. Someone asks a straightforward question. Where did the last of a line go? Why does the shelf not match the book? Answering means the register, the spreadsheet, a stack of pick sheets and someone's memory of a show in August. It takes an afternoon. Sometimes two people's afternoons, and the answer is still "probably".

These are operating costs. They come out of margin and out of the hours of the person who runs the store.

What changes when every movement is typed

The change is not a better spreadsheet. The change is that every physical event in a store becomes one record, of one type, against one store, written once.

In PyroPortal there are six movement types: In, Out, Transfer, Adjustment, Stock-take and Write-off. Every movement records the product, the store, the quantity, the quantity before and after, who recorded it and when. In, Out and Write-off carry an ex-VAT unit-cost snapshot. An In from a goods receipt carries the supplier order number as its reference. An Out at pick time carries a link to the pick line, and through it the show.

Take the same three failures.

The Friday delivery is received against the supplier order, line by line, in cases. Short-shipped lines stay outstanding. Each received line writes an In movement to the store you chose, converted to units, with the order number as the reference. There is no Monday write-up, because the receipt is the record.

The transfer is one movement. It is deducted from the source store and added to the destination store in the same transaction. If either side fails, neither happens. Filter the movement log by either store and you see it. Ten cases cannot be in one store's book and not the other's, because there is only one book.

The stock-take is a Stock-take movement, not an edit to a cell. It records the previous quantity, the counted quantity and who counted. The variance is on the movement itself. The reason still has to come from a human, in the notes, and a mandatory reason is not something that ships today. But the fact that a count happened, when, and by whom, no longer depends on anyone remembering to write it down.

Adjustments and write-offs are separate types on purpose. An adjustment corrects a data error. A write-off is product that has actually gone: damaged, expired, test-fired. One counts as cost in the year-end figures and the other does not. When both are "adjustment" in a spreadsheet, the accountant cannot tell them apart. Neither can you.

Live utilisation, per store and per category

Because every movement lands against a store, the storage dashboard shows what each store holds without anyone adding it up. NEQ in store, per store, against the capacity you have configured for it, with a gauge that turns amber at eighty percent and red over the limit. NEQ broken down by hazard category. A low-stock list. A recent-movements feed, so you can see what changed today without opening the log.

To be clear about what this is: it is a calculation from the movements, shown on a screen. It is not an alerting system. Nothing emails you at ninety percent. It does not make the store compliant with anything. It shows the number to the person responsible for the store, so they can act on it.

The stock-check screen, on a phone, in the store

The piece that makes this hold together in practice is the stock-check screen. It is built for a phone. Pick a store. Type part of a product code or name. The screen shows the recorded quantity and what is on order. Enter the count you can see. The variance shows as you type. Save.

That save is a Stock-take movement. It updates the store's quantity, stamps the product's last-counted date and records who did it. The recent checks for that store sit underneath, so two people counting the same shelf can see what has already been done.

There is a narrower permission for this, so seasonal staff can count without being able to edit stock any other way. That matters more than it sounds. Counts don't happen because they need someone senior to do them. Once anyone can count and nobody can silently correct, counts happen.

The register can stay

Nothing here requires you to stop keeping the paper register. Plenty of operators keep it because they always have, because an inspector expects to see it, or because a book in the store works without signal. Keep it.

What changes is which record wins. When the register and the spreadsheet disagree, you have a problem with two possible answers. When the register and the movement log disagree, you have a paper transcription to check against a timestamped record of who did what. The paper becomes a copy. The movement log is the source.

There is a list of things this does not do, and it is worth reading before you decide. There is no digital signature on a movement, only the user who recorded it. There is no formatted PDF or CSV register export for a date range yet. There is no NEQ alerting, no UN number field, no photo of the delivery note. Until those ship, the paper register is still the document you hand over.

But the paper register was never the thing that cost you an afternoon in November. The missing source of truth was.

Questions operators ask

Do I have to stop using the paper register?

No. Keep it if you want to. The point is that it stops being the only record. When the two disagree, the movement log has the timestamp and the user, and the paper is checked against it, not the other way round.

What happens when a count is wrong?

The Stock-take movement records the previous and counted quantities, who counted and when. If the count itself was a mistake, you record another count. The history keeps both. Nothing is overwritten.

Can seasonal staff do counts without editing stock?

Yes. There is a separate stock-take permission. A user with only that permission can save counts from the stock-check screen and nothing else. General stock editing stays with whoever you give it to.

Does this replace the register I show an inspector?

Not today. There is no formatted register export yet, and movements carry a recorded user rather than a signature. The operator stays responsible for the register and for the store. What you get is a record that tells you what actually happened, when you need to know.

See it on your own data. Set up a store, receive one order and count one shelf. The magazine module is described in full on the magazine feature page, and the Spark plan on pricing is free.