Boot stock discrepancies in excisable goods are not an accounting problem. They are an audit exposure problem.
When a duty-paid tobacco transfer is reconstructed from memory or fragmentary notes at the end of a week, you are not producing a record — you are producing a narrative. The ATO does not accept narratives. What it accepts is a timestamped, SKU-level transfer log that shows exactly how many units of Ashford 25 Red moved from main stock to boot stock on a given date, verified by a calculated total that closes against your opening and closing inventory counts.
This template exists because someone learned that lesson the hard way.
What a Disorganised Boot Stock Looks Like at End-of-Cycle
Twenty-three individual SKU fields. That number is not arbitrary — it reflects the actual breadth of a working tobacco product range across Ashford, Easy, Manitou, Gala Slims, Reef, and Harvest lines. A rep who tracks "some Ashford and a few Reef" against a boot stock that contains six Ashford variants and four Reef variants is going to find themselves short on a reconciliation with no audit trail to explain where the gap opened.
The variant granularity matters. Ashford 25 Red and Ashford 25 Blue are not interchangeable for excise purposes or for customer allocation. Manitou 20 Organic moves differently from Manitou 20 Gold. Reef 25 Treasure is a separate line item from Reef 25 Lagoon. Collapsing these into "Reef 25s" is the kind of shortcut that generates a three-way discrepancy between your records, the warehouse transfer docs, and the retail sale register.
The Architecture of a Correct Transfer Record
The calculated TOTAL STICKS field is the structural discipline that makes this template useful rather than just organized. It aggregates all 23 SKU counts into a single verified number at the point of transfer entry.
This matters for one specific reason: it closes the loop at the time of action rather than at the time of review. A rep who transfers 400 sticks across 12 SKUs and sees a total of 387 knows immediately that one of the field entries is wrong — before the boot stock is loaded, before the van leaves the depot. After the van leaves, that discrepancy is a two-day paper chase involving the warehouse controller, the account manager, and a manual recount.
The Date/Time field stamps each transfer session. When you have multiple transfers in a week — duty paid to boot stock on Monday, a partial top-up Wednesday morning — you have a sequential record. The STOCK ADDED TO BOOT STOCK FROM DUTY PAID text field accommodates any notes about authorisation reference numbers or exceptions. It is not mandatory, but on transfers that fall outside the normal cycle pattern, it is the field that explains the anomaly.
Harvest RYO 25g sits alongside the stick brands in the same template, which is correct. Roll-your-own pouch product moves on a different volume pattern to sticks but carries the same duty-paid documentation requirement. Having it in the same transfer record means one entry per session rather than maintaining a parallel pouch-specific log.
Pulling a Transfer Record When You Need It Fast
The scenario that exposes poor systems is not the end-of-year reconciliation. It is the mid-cycle spot audit. A compliance officer requesting documentation for a specific transfer date needs to see the record in under two minutes — not a reconstructed estimate from the rep's recollection.
A Memento database filtered by Date/Time, sorted by the TOTAL STICKS calculated field, returns the complete transfer history immediately. Every Reef 20 Coral unit, every Gala Slims 20 Black, every Manitou variant moved in any given period, timestamped, with running totals that were computed at entry and cannot be retroactively adjusted without a new record.
The template structure enforces this. Each session creates a new record. There is no overwrite, no edit-in-place that disguises a correction. The history is preserved in the sequence of entries, and the calculated total on each record is locked to the SKU counts that were entered at the time.
Reef 25 Treasure to boot stock: six units, logged at 07:42, transfer total 412. That is what a duty-paid transfer record looks like when the system is working.