Creating a collection record you can maintain

Start with the next object you need to find

Imagine that you want to locate a particular postcard six months from now. Its purchase price alone will not help. You need a recognisable description, a photograph and a location. Those three pieces of information reveal the purpose of an inventory: connecting a record with an actual object, wherever that object is stored.

Give each object or deliberately defined group a unique identifier. Add its name, current location and the date you made the record. Record acquisition details if you have them, separating the purchase date from the date of documentation. If you bought an item years ago and cannot remember when, write that the date is unknown rather than treating today as the acquisition date.

Separate observations from information supplied by others

A maker’s name printed on a base is an observation. A seller’s statement that a model is an early release is a claim with a source. Put them in different fields, or label them clearly within the notes. Keep a copy of the original description so you can revisit it without presenting every part as established fact.

Condition notes become more useful when they identify locations. ‘Small crease across the lower right corner’ tells you more than ‘fair condition’. Link the note to a detail photograph and include the inspection date. A later change should become a new dated entry, not an invisible replacement of the earlier observation.

For costs, distinguish the item price from delivery or shared lot expenses. Use a currency field. If you divide the cost of a mixed lot among its contents, record that the figures are your allocation, rather than separate prices charged by the seller.

Keep the routine short enough to repeat

Choose a minimum record you can finish when an object arrives: identifier, description, location, photograph and source. Additional research can wait in a clearly marked field. A spreadsheet is sufficient for many small collections, provided the headings are consistent and photographs can be found without depending on a temporary download link.

Test the system with five different objects before entering everything. Include one awkward example, such as a model with detachable accessories or a group of related letters. If the record cannot explain which parts belong together, change the structure now. Do not make every future entry longer to accommodate information that applies to only one type of object.

Finally, use the inventory for a real task. Find an object from its record, then find the record from the object. If either direction is difficult, improve the identifier or location description. Save a backup outside the working folder and note when it was made. An inventory is a working connection between objects and information, not a one-time list that becomes obsolete after the next purchase.