Recording Valuations
Collection Spreadsheets and Systems
A valuation system is not a column headed Estimated value. It is a history of dated conclusions: what was valued, for what purpose, using which evidence, under which assumptions, in what condition, by whom and with what degree of confidence.
That distinction is what turns a basic inventory into a defensible record. The item page may show a convenient latest value, but the underlying system should retain every valuation event and the context that made it reasonable at the time. A collector should be able to return years later and understand not only the number, but the judgement behind it.
This chapter applies whether the collection is managed in a carefully built spreadsheet, a specialist database or a platform such as Collectaneum. The sophistication of the software can vary. The intellectual standard should not.
The central design rule
Treat a valuation as an event, not a permanent property of the item
Weak record
Estimated value: $5,000
No date, purpose, evidence, currency context, condition snapshot or explanation of whether this is market, insurance, retail or net resale value.
Defensible record
Retail replacement value: $5,000 GBP, effective 8 March 2025, based on recent specialist dealer evidence and comparable sales, assuming authenticity and complete original contents; moderate confidence; review due March 2026.
The figure can now be interpreted, reviewed, challenged and compared with later valuations.
Collector scenario
Four different values can all be correct
A single collectible may be valued repeatedly for different questions. The system fails when later values erase earlier ones or when different purposes are collapsed into one field.
Collector estimate
$350Effective 1 March 2022
Basis: Recent sold listings
Insurance replacement
$550Effective 14 June 2023
Basis: Professional appraisal
Resale estimate
$425Effective 8 January 2025
Basis: Adjusted auction comparables
Estate planning
$475Effective 2 July 2026
Basis: Purpose-specific professional valuation
The sequence does not show that the item was first worth $350, then $550, then $425 and finally $475 in one universal sense. It shows that different questions were answered at different dates. The purpose and basis are part of the value, not optional notes attached afterwards.
Meaning before mechanics
Separate the financial concepts before designing the fields
The most damaging spreadsheet errors begin before any formula is written: distinct financial ideas are merged into a generic value column.
Acquisition cost
What the collector paid to obtain the item, optionally expanded to include directly attributable costs such as buyer's premium, shipping, import duty, grading, authentication or restoration.
Meaning
It records the economics of acquisition. It does not prove what the item is worth now.
Collector risk
Using cost as current value can conceal both appreciation and overpayment, and may produce an unsuitable insurance figure.
Current market value
An estimate of the price achievable in the relevant market under the stated assumptions, for the identified item, at the stated date.
Meaning
The relevant market and sale channel matter. A specialist auction, private sale and general marketplace may not produce the same result.
Collector risk
A generic market-value field becomes misleading when the market, gross or net basis, and evidence are not stated.
Replacement value
The estimated cost of obtaining a substantially equivalent item within a reasonable period, often for insurance purposes.
Meaning
Replacement may require dealer retail pricing, rapid action, premiums, taxes, shipping and a scarcity allowance.
Collector risk
Replacement value is often higher than expected resale proceeds and should not be presented as a sale forecast.
Net realisable value
The amount the owner may retain after commissions, marketplace charges, payment fees, shipping, taxes, restoration, photography and other selling costs.
Meaning
This is a disposal scenario, not a headline retail figure.
Collector risk
Ignoring costs can make collection wealth appear more liquid and more accessible than it really is.
Record architecture
The minimum anatomy of a serious valuation record
The objective is not to collect fields for their own sake. Each field should answer a question that a future collector, insurer, executor, buyer, appraiser or auditor may reasonably need to ask.
Identification
- Stable valuation ID and owned-item ID
- Item title as understood on the valuation date
- Edition, printing, variant, region or version
- Serial, inventory or certification number where applicable
- Scope: one item, a group, a set or the whole collection
The financial conclusion
- Original amount and original currency
- Low, high and concluded amount where a range is used
- Gross or net basis
- Purpose and value definition
- Relevant market or disposal channel
Time and responsibility
- Effective valuation date
- Date entered or report issued
- Review-due date
- Valuer or source
- Creator, editor and record status
Defensibility
- Method and comparable evidence
- Condition, completeness and authentication snapshots
- Assumptions and limitations
- Confidence and reason for confidence
- Supporting photographs and documents
Titles change; identifiers should not
A valuation should link to a stable owned-item identifier. Human-readable titles may be corrected, expanded or standardised later. Row numbers are also unstable because rows move, filters change and imports are repeated. The link between the valuation and the physical owned copy must survive those changes.
Where the valuation applies to a set, boxed game, matched group or whole collection, the scope must be explicit. Otherwise the same economic value may be counted once for the group and again for each component.
Historical context
Condition must be captured as it stood on the valuation date
A live item record describes the object now. A valuation record must preserve the state of the object when that valuation was reached.
Physical condition
- ?What defects were present on the effective valuation date?
- ?Was the object physically inspected or judged from photographs?
- ?Was damage stable, active or recently repaired?
Completeness
- ?Were all original components, inserts, accessories and packaging present?
- ?Was the valuation for the complete object, a partial set or a component group?
- ?Could later loss or discovery of components invalidate the earlier conclusion?
Restoration and alteration
- ?Was restoration, conservation, recolouring, repair or replacement material recorded?
- ?Did the valuer understand the intervention and its effect on desirability?
- ?Does the valuation assume the restoration is acceptable to the relevant market?
Authentication and attribution
- ?Was authenticity confirmed, assumed, disputed or not examined?
- ?Was a signature, maker, printing, grade or certification verified?
- ?Is the value conditional on an attribution later proving correct?
Consider an item recorded as near mint in 2022, water-damaged in 2024, professionally restored in 2025 and incomplete in 2026 after an insert was lost. Using the current condition field to explain every historical value would falsify the earlier context.
The system should therefore store a valuation-specific snapshot or link to a dated condition report. A later change can trigger a new valuation, but it should not rewrite the previous one.
Evidence and judgement
Comparable sales are useful only when their differences are visible
A comparable is not simply another price. It is a transaction with a type, date, venue, currency, condition, completeness, variant and cost basis that must be understood before it can support a conclusion.
Strong evidence
Several recent completed sales of the exact variant, professional physical inspection, verified private-sale evidence or closely matched specialist auction results.
Evidence
Exact identification, similar condition, similar completeness, known transaction type and recent date.
Meaning
The estimate can usually be expressed with a narrower range, although judgement still remains necessary.
Collector risk
Even strong comparables can mislead when premiums, restoration, provenance or market venue are not normalised.
Moderate evidence
Older exact sales, recent sales of closely related variants, reputable market reports or consistent but indirect specialist evidence.
Evidence
The evidence is relevant but requires documented adjustment for time, variant, condition or venue.
Meaning
A range and an explanation of adjustments are normally more defensible than an exact number.
Collector risk
Silent adjustments can turn an inspectable valuation into an unexplained opinion.
Weak evidence
Unsold listings, asking prices, isolated social-media claims, old price guides, owner memory or automated estimates with undisclosed inputs.
Evidence
These sources may provide context, but they do not demonstrate that a willing buyer completed a comparable transaction.
Meaning
The system should lower confidence, widen the range and preserve the reason for uncertainty.
Collector risk
Weak evidence presented with false precision is one of the most common causes of systematic overvaluation.
Normalise the transaction before comparing the number
Transaction status
Sold, accepted offer, unsold, withdrawn, passed, reserve not met or merely listed.
Price basis
Hammer, buyer's premium, tax, shipping, all-in price and seller net are different facts.
Object match
Edition, printing, region, packaging, accessories, grade and signatures may materially alter comparability.
Condition match
Record defects, restoration, completeness and whether the object was physically inspected.
Time and venue
Older evidence and a different market channel may require an explicit adjustment.
Adjustment trail
Record the amount or percentage and the reason. Never bury the adjustment inside the final figure.
False precision warning
A formula cannot rescue poor evidence
Weighting exact matches more heavily than distant comparables can improve discipline. It does not make the result objective. A mathematically precise average based on misidentified variants, asking prices and incompatible conditions is still a poor valuation.
When evidence supports approximately $1,100 to $1,500, recording $1,347.82 suggests certainty that the market does not provide. The range, concluded figure and confidence should be stored separately.
A real sequence
The valuation workflow a system should support
The following sequence is not decorative. Each step protects the next one from inheriting an unstated assumption or an avoidable data error.
Identify the exact owned item
Confirm that the valuation attaches to a stable item record, not merely to a title that may later be renamed. Record the edition, variant, identifiers and whether the valuation applies to an item, group or collection.
Freeze the valuation context
Record condition, completeness, restoration and authentication as they stand on the effective date. A later change to the live item record must not rewrite the historical basis of the valuation.
Define the question
Choose the purpose, value basis, market and intended sale or replacement scenario. A valuation without a defined question cannot reliably answer one.
Gather and normalise evidence
Separate sold results from asking prices, record premiums and costs, preserve currencies, compare exact variants, and document adjustments rather than embedding them invisibly.
Conclude with uncertainty visible
Use a range when the market is thin or the evidence is indirect. Record the concluded amount, confidence level, assumptions and limitations together.
Attach, version and review
Link documents and photographs, preserve the source material, set a review date and create a new record when circumstances change. Do not overwrite the past.
Spreadsheet design
A workbook should separate entities, not collect everything in one row
A tiny collection can begin in one worksheet, but valuation history becomes safer when the workbook mirrors the real relationships between items, valuation events, evidence and documents.
Items
One row per owned item: stable ID, title, catalog link, variant, current condition, completeness, authentication status, storage location and acquisition facts.
Valuations
One row per valuation event: effective date, amounts, currency, purpose, basis, method, valuer, confidence, review date, status and rationale.
Comparable sales
One row per supporting transaction: source, sale date, transaction status, prices, premiums, condition, variant match, adjustments and verification status.
Documents and photographs
Links between evidence files and the relevant item or valuation, including appraisal reports, certificates, screenshots, catalogues and condition images.
Exchange rates
Rate date, original currency, reporting currency, rate and source. Preserve the original amount even when reporting equivalents are refreshed.
Collection summaries
Calculated views rather than hand-entered totals: latest values by purpose, stale records, coverage gaps, concentration and evidence quality.
System behaviour
The interface may simplify the view, but it must not simplify the meaning
Collectors need convenient summaries. Convenience becomes dangerous when a label hides which valuation has been selected or makes different bases look interchangeable.
Ambiguous interface
$4,500
Is this market, insurance, retail, trade, owner estimate or net resale? Is it current, superseded or converted from another currency?
Meaningful interface
Latest resale estimate: $4,500 USD
Effective 18 June 2026 · owner estimate · moderate confidence
The item record shows the most relevant summary; the valuation page exposes the complete history, evidence and alternatives.
Useful calculated views
Each view must be labelled. A system that chooses one value without exposing the selection rule can produce a clean dashboard and an unreliable conclusion at the same time.
Collection totals
A collection total is a scenario, not a natural fact
The total depends on which values are eligible, whether groups and components overlap, how currencies are converted, and whether the assumed outcome is replacement, patient resale or rapid disposal.
Item-by-item total
Add the latest qualifying value for individually significant items where records are complete, current and compatible.
Tiered valuation
Professionally value high-value items and apply category-level methods to lower-value material.
Bulk-disposal value
Estimate the result if the collection is sold in one transaction, usually below patient item-by-item retail.
Replacement-cost total
Estimate the cost of reacquiring equivalent items, potentially above both auction and bulk-sale outcomes.
Double-counting test
If a boxed set has a whole-set valuation and each component also has an individual value, which basis is the summary using? A collection total should include either the group value or the component values unless a deliberate sum-of-parts scenario is selected.
The same discipline applies to complete runs, matched groups and duplicate holdings. A complete group may attract a premium, while a rapid bulk sale may require a liquidity discount.
Currency and time
Preserve the original value before calculating reporting equivalents
Currency conversion is a reporting layer. It should never erase the amount and currency in which the valuation was originally expressed.
Historical-rate reporting
Convert using the rate on the effective valuation date. This supports period-specific analysis, historical reporting and some gain or tax calculations.
Store amount, currency, rate, rate date and source.
Current-rate reporting
Reconvert the latest foreign-currency valuation using the current reporting rate. This is useful for consolidated dashboards and current exposure.
Label the method so currency movement is not mistaken for market movement.
Inflation adjustment should be treated in the same way: a calculated analytical field, not a replacement for a fresh market valuation. Updating an old appraisal by consumer-price inflation answers what the historic amount represents in current purchasing power; it does not prove what the collectible would sell for now.
Audit and correction
Never repair history by deleting it
A valuation can later prove wrong because the object was misidentified, counterfeit, damaged, incomplete or supported by flawed evidence. The record should show that development rather than conceal it.
Superseded
A later valuation answers the same question with newer evidence.
Invalidated
A material premise failed: wrong variant, false signature, altered grade, counterfeit or undisclosed damage.
Withdrawn or disputed
The valuer or owner no longer relies on the conclusion, but the historical record remains relevant.
Record who created and edited the valuation, the original and replacement conclusions, the reason for change, the document version and the relationship between the records. Corrections should normally produce a new version or a linked replacement rather than silently changing the earlier value.
This is not bureaucratic excess. It preserves what was known at a particular date and allows a future reader to distinguish market movement from a change in identification, condition, method or evidence.
Imports and legacy data
Do not turn uncertainty in an old spreadsheet into false certainty
Legacy spreadsheets often mix amount, range, currency, date, valuer and purpose in one cell. An import should preserve the raw source and flag ambiguity instead of forcing every value into a clean but invented structure.
Preserve during import
- • Source workbook and original row number
- • Original column heading and raw value
- • Parsed amount, inferred currency and inferred date
- • Mapping confidence and item-match confidence
- • Import warning and legacy status
Warnings worth exposing
- • Currency not stated
- • Date ambiguous
- • Purpose not stated
- • Value appears to be an asking price
- • Purchase price and appraisal value cannot be separated
- • Duplicate valuation or uncertain item match
Imported values should begin as imported, unverified or legacy estimates until a collector has reviewed their meaning. Data cleanliness should not be achieved by inventing facts the source never contained.
Myths and corrections
Common system beliefs that undermine valuation records
Myth
The latest value is the correct value, so the old one can be replaced.
Reality
The latest value may answer a different purpose or use a different basis. Preserve both and label the question each one answers.
Myth
A high asking price is useful market proof.
Reality
It shows seller expectation. A system should distinguish listings, accepted offers, completed sales, unsold lots and reserve failures.
Myth
A professionally appraised amount is all that needs to be retained.
Reality
The report, effective date, purpose, value definition, inspection basis, assumptions, signature and version remain part of the evidence.
Myth
An automated value is objective because it was produced by an algorithm.
Reality
The result depends on product matching, transaction data, condition assumptions, outlier treatment, lookback period and model version. Those inputs should be disclosed.
Myth
A collection total is simply the sum of the numbers currently displayed.
Reality
The total is meaningful only when the included values use compatible purposes, dates, currencies and scopes, without double-counting groups and components.
Action hierarchy
What a collector should build first
A useful system can mature in stages. The priority is to create dependable records before adding sophisticated calculations and dashboards.
Essential
Make every value identifiable and dated
Require the owned item, amount, currency, effective date, purpose, method or source, and confidence. Preserve previous valuation rows.
Strong practice
Preserve the reasoning
Add ranges, value basis, condition and completeness snapshots, evidence links, assumptions, review date, status and supporting documents.
Advanced
Make portfolio reporting inspectable
Add comparable weighting, transaction-cost assumptions, reporting-currency conversion, collection-level adjustments, audit history and purpose-specific latest-value views.
Specialist threshold
When the spreadsheet should lead to a professional valuation
A collection system can reveal when an informal estimate is no longer proportionate to the decision or risk involved.
Escalate when the purpose demands it
- • Insurance scheduling or a large coverage gap
- • Probate, tax, donation, divorce, litigation or lending
- • A high-value item beyond the collector's evidence base
- • A whole collection where liquidity and grouping materially affect the outcome
Escalate when the evidence is unstable
- • Disputed authenticity, attribution or certification
- • Unique, thinly traded or highly volatile material
- • Significant restoration, damage or incomplete contents
- • No recent comparables or wide disagreement between sources
The system's role is to prepare the evidence, expose the uncertainty and preserve the resulting report. It should not present an owner estimate as formally compliant merely because the fields are well organised.
Documentation checklist
Before treating a valuation record as complete
Key principles
What the system must never forget
- 1.A valuation is a dated conclusion, not a permanent attribute of the collectible.
- 2.Purpose determines the appropriate definition of value.
- 3.Cost, market value, replacement value and net resale value are separate facts.
- 4.Condition, completeness and authenticity must be preserved as they stood on the valuation date.
- 5.Evidence quality and confidence are different from the amount itself.
- 6.Asking prices, sold prices, hammer prices and all-in prices must not be treated as interchangeable.
- 7.Original currencies and historical records should remain intact when reporting views are refreshed.
- 8.Professional reports and supporting evidence should remain attached, not reduced to a number.
- 9.Corrections should preserve the earlier conclusion and explain why it changed.
- 10.A collection total is meaningful only when the included values use a defined, compatible scenario.
Continue learning
Insurance Records
Understand how appraisal values, scheduled amounts, policy limits and coverage gaps should be recorded without conflating them.
Back to Recording Valuations
Return to the full recording framework, including dates, evidence, assumptions, condition, confidence and review triggers.
Review Triggers
Continue to the events and time-based rules that should prompt revaluation or specialist review.
Related topics
Valuation Records
Build the individual valuation record that sits inside the wider spreadsheet or collection-management system.
Evidence Links
Record comparable sales, source references, screenshots and documents so a value can still be examined after web pages disappear.
Condition at Valuation
Preserve the physical and completeness context that made a past valuation reasonable at the time.
Version History
Retain superseded, corrected, disputed and invalidated values as an audit trail rather than silently replacing them.