The reserves spreadsheet nobody trusts
You store wine for a few hundred customers. Some of it sits in your own cellar under the shop, some in a professional bonded warehouse, some in a duty paid store. The record is a spreadsheet with a row per case, updated when someone remembers. A customer asks for three bottles from his 2016 Rioja for a birthday, and you discover the spreadsheet says he has a case, the warehouse says he has eleven bottles, and nobody knows where the twelfth went.
Every storage invoice run means a day of checking. Every withdrawal request means a phone call to the warehouse to confirm the case is really there.
Where reserve records go wrong
The spreadsheet records a state, not a history. It says what someone thought was true when they last edited it. When a customer takes three bottles, the row is overwritten, and the reason and date are lost.
- Withdrawals of part cases are edited in place, with no trail.
- Cases moved between your cellar and the warehouse are not always recorded.
- The warehouse's own reference numbers are not kept alongside yours.
- Storage charges are calculated by hand from a list that may be out of date.
- Wine bought by one customer as a gift for another sits under the wrong name.
Without a movement history, any mismatch between your records and the warehouse's is a mystery to be solved by phone.
What an unreliable ledger costs
Most directly, it risks a customer asking for wine that is not where you said it was. That conversation is uncomfortable, and with fine wine it can be expensive to put right. It also costs staff time on every withdrawal, every storage invoice and every year end, and it makes it hard to offer storage as a service with confidence.
Customers who store with you are usually among your best. They deserve a record as careful as their cellar.
The reserves ledger we build
- Every stored holding is recorded with its owner, wine, vintage, format, quantity, where it is held and the warehouse's reference.
- Every change is a movement: into storage, out for delivery, transfer between sites, part withdrawal, change of owner. Nothing is overwritten.
- The warehouse's stock report, whatever format it comes in, is imported and matched against the ledger, and differences are listed for someone to resolve.
- Storage charges are calculated from the ledger using your own charging rules, and drafted as invoices in your accounts package.
- Customers receive a statement of their holdings, and can ask for a withdrawal or delivery from a link in it.
- Withdrawal requests become tasks for the team, with the location and reference already on them.
| Event | Old way | With the ledger |
|---|---|---|
| Customer takes three bottles | Row edited to 'nine' | Movement recorded, balance nine, reason kept |
| Case moved to the warehouse | Sometimes noted | Transfer movement with both locations |
| Warehouse report arrives | Checked by eye, if at all | Matched line by line, differences listed |
| Storage invoice run | A day of checking | Drafted from the ledger for review |
| Customer asks what they hold | Staff search the sheet | Statement sent from the ledger |
Storage you can stand behind
When a customer asks what they hold, the answer comes from a record that shows how it got there. The reconciliation with the warehouse becomes a short list of real differences rather than a guessing game. Storage invoicing becomes routine. And because the ledger is kept separately from your own trading stock, there is no confusion between wine you own and wine you look after.
What charges you apply and how storage is described in your terms remain your decisions and your adviser's.
Recognise this cellar?
- Your customer reserves live in a spreadsheet.
- Part-case withdrawals are recorded by overwriting the quantity.
- The warehouse's figures and yours regularly disagree.
- Storage charges take a day or more to prepare.
- Customers do not receive a statement of what they hold.