Cellar Keg Register: Track It Properly

This guide covers what to record in a Cellar Keg Register, why a spreadsheet eventually falls over for this kind of tracking, and how to keep the data reliable as the list grows.

What you record

Fields in the Cellar Keg Register

Every record in this register captures the fields below — 3 of 7 are mandatory, and a record can't be saved until they're filled in.

Keg code Required: ITM-872
Keg name Required: Keg
Category: Spare parts
Quantity on hand Required: 8
Reorder level: 13
Location: Storeroom 3
Last counted date: 01/02/2026

Where spreadsheets break down

How spreadsheet registers fail

None of these need malice — just a busy team and a file with no safeguards built in.

✕ No change history — there's no way to prove a row wasn't edited after it was first entered.
✕ Incomplete records — a row can be saved half-filled, and the gap often isn't caught until you need it.
✕ Version conflicts — two people work from different copies, and the "final" file quietly drops recent changes.
✕ Silent formula errors — a dragged formula or broken reference changes data without anyone noticing.
✕ No access control — anyone with the file can edit or delete any row, with no record of who did it or when.
✕ Lost institutional knowledge — the person who maintained it leaves, and the file (or how to read it) goes with them.

In practice

Keeping a Cellar Keg Register reliable

The failure modes above all come back to the same set of habits — get these right and the register looks after itself.

1 Fill in every mandatory field as soon as the event happens — the Cellar Keg Register requires 3 per record, and back-filling later is when details get lost.
2 Keep a clear edit history — every change should show who made it and when, not just the latest value.
3 Set a reminder for every recurring date — a service or renewal due date that lives only in someone's memory eventually gets missed.
4 Import once, don't re-key — bring your existing spreadsheet in directly instead of retyping years of records by hand.

What's built in

What this register includes

Attachments Attach photos, manuals or receipts directly to a record.
Due-date reminders Service or renewal dates trigger reminders automatically, before they're missed.
CSV import & export Bring in your existing spreadsheet, and export everything back out whenever you like.
Unlimited users & sites One flat rate per register, regardless of how many people or locations use it.

Launch this register

No setup, no configuration required. TidyRegister ships with the Cellar Keg Register ready to go.

Start free — $3/week

Common questions

Frequently asked questions

Who normally maintains the Cellar Keg Register?

Stocktake counts, supplier invoices, and the point-of-sale or inventory system.

Can I import my existing spreadsheet into the Cellar Keg Register?

Yes — upload your CSV and its columns are matched to this register's fields automatically.

Can I export my data out of the Cellar Keg Register?

Yes, at any time, as a CSV — there's no lock-in.

What does the Cellar Keg Register cost?

TidyRegister is $3/week per register, with unlimited records, users and sites.