The working artist inventory and archive system

The permanent, immutable ID is the foundation

The single most important principle, borrowed directly from museum registration practice, is that every work gets one unique identifier that never changes and is never reused. In museum terms this is the accession number or object number; for an artist it is the inventory number.

As Museum Registration Methods puts it, "Without a unique number that relates to specific files, an object is at risk of losing its context and information relating to its legal status." If a work is later deaccessioned, destroyed, or lost, its number is retired — not recycled onto a new piece.

A crucial workflow rule from the Joan Mitchell Foundation's Career Documentation for Visual Artists: work from your record to your object, not your object to your record. Create the database record first — that generates the Inventory Number (Unique ID) — then label the physical work and its housing with that ID. Their hard rule: "Never allow an artwork to leave your studio if it is not linked to a record in your inventory management system with a proper label that includes your Inventory Number (Unique ID) affixed to the artwork."

There is no universal standard, and museums are advised to prize internal consistency over cleverness. Common approaches:

• Sequential/running number: 0001, 0002, 0003… The simplest scheme; just a unique number per work. Use leading zeros sized to your expected lifetime output (e.g., four digits if you may exceed 999 works).
• Year-based (museum convention): The dominant museum format is year followed by a running number, e.g., 2024.3, 2024.4, 2024.5 — often extended to a three-part number (2024.3.1) where the parts denote year, accession group, and item. Collections Trust advises using the full four-digit year (not "24"), never placing the year last (it breaks computer sorting), and not prefacing numbers with zeros in a way that locks sequence length.
• Series- or medium-coded: Many artist tools suggest embedding a category code. The GYST scheme uses [year][medium code]-[sequential]: e.g., "13P-023" is the 23rd painting made in 2013; add an edition suffix like "13E-002-21" for the 2nd print of 2013, edition number 21. Codes such as P=Painting, S=Sculpture, D=Drawing, PR=Print, V=Video, PH=Photo can be added.
• Initials/entity prefixes: Useful for collaborations or if you also manage others' work (e.g., "TN14D-022" = Tucker Neel's 22nd drawing of 2014).

Two cautions from the registrar's side First, do not overload the number with meaning. As PastPerfect's guidance warns, "intelligent" numbers that try to classify (T for tools, then CT, ST, BT…) reliably break down; keep classification in fields, and let the number simply be unique. Second, an inventory number offers useful neutrality — an older creation date on an unsold work can prompt buyers to wonder why it hasn't sold, whereas a neutral code (e.g., "BT2503P3") identifies the work without broadcasting a potentially "judgmental timeline."

Core metadata: CDWA framework + essential fields

Museum cataloguing standards give a principled way to decide what is essential. The Getty's Categories for the Description of Works of Art (CDWA) — an extensive framework of 532 categories and subcategories (Getty itself rounds to "around 540"), of which a small subset are flagged "core" as "the minimum information necessary to uniquely and unambiguously identify and describe a particular work" — designates these core categories: Object/Work Type, Classification, Titles or Names, Creation (Creator + Creation Date), Measurements, Materials/Techniques, Subject Matter, and Current Location. That maps almost exactly to what artist tools recommend.

Essential fields (record these for every work)

• Inventory/Accession Number — the unique ID.
• Title — the full title; use a neutral placeholder scheme if you use "Untitled" repeatedly.
• Creation date — exact date or month/year; gives career context.
• Medium / Materials — free-text detail of materials and techniques; vital for unusual or experimental materials, and for later conservation.
• Dimensions — height × width × depth, with unit clearly stated; record unframed and framed dimensions separately; use "variable" or duration for installation/video/performance.
• Edition information — edition size and number for prints, photos, sculpture multiples.
• Image — at least one photograph per record.
• Status and Location.

Strongly recommended / optional fields

• Description — visual and conceptual; especially important for installation, video, performance, kinetic, and social-practice work where a static image cannot convey the piece (also invaluable for future retrospectives and scholarship).
• Signature notes — whether signed, where (recto/verso), and how.
• Subject matter / tags — for searching and grouping.
• Prices/values — retail price, wholesale price, and (as relevant) fair market value and insurance/replacement value. Keep purchase/production cost separate from sale price.
• Provenance notes — seed the ownership history here.
• Notes — private field for materials, kiln temperatures, inspirations, whether it was a gift or commission.
• Condition — a brief condition note/report, updated over time.
• Expenses — production costs, for pricing and tax.

A registrar's note on completeness: your inventory should reflect every work you have created regardless of status, and you can create placeholder records for works missing an image or critical data rather than leaving gaps.

Highest-leverage insightA work without a unique permanent number is at risk of losing its context, and context is most of what makes a work legible to anyone but you.

Why current-location tracking is non-negotiable

This is where inventory earns its keep operationally and legally. GYST's blunt framing: "Know where your artwork is at all times. Is it on a shelf in your studio, consigned to a gallery, under the bed, or in an exhibition in Europe?" The stakes:

• Money and recovery of consigned work. GYST warns artists not to rely on galleries to track work: "many galleries go out of business, lose records, or purposefully try to keep their artists in the dark… create your own records." Always obtain a list of what you have on consignment and what has sold, with buyer contact details.
• Retrospectives and museum shows. A curator building a career survey starts from your inventory; not knowing where sold works reside means "more work for the curator" and can sink a loan request.
• Legal proof. In theft, fire, or insurance disputes, the burden of proof is on you. Ownership is typically established through photographs, documentation, and detailed records; adjusters and the Art Loss Register need an accurate description, image, and value. Detailed sales records are also what let an appraiser substantiate fair market value — without them, an artist's own price claims often are not accepted.

A distinction registrars insist on: current location (where the work is right now — gallery, art fair, museum on loan, in transit) is not the same as home/storage location (where it normally lives — "Shelf 2, Box B," a named storage facility). Recording both means that when a loan ends you know where the piece returns to, and you can physically find packed works. The Spectrum standard treats "Location and movement control" as a primary procedure: "Keeping a record of where all the objects in your care can be found, and updating the location each time an object is moved."

Dedicated tools converge on a status list you can adopt or adapt. A representative set:

• Available
• Reserved / On hold
• On consignment (at a gallery/dealer)
• On loan (exhibition or non-sale loan)
• In transit
• Sold
• Gifted / Donated
• Not for sale (NFS)
• In storage
• Work destroyed
• Lost
• Deaccessioned / Archived

The key operational habit is to update the status the moment the work moves — every movement is a state change that should be logged.

Consignment tracking specifically

When work goes to a gallery on consignment, protect yourself with a consignment sheet/report that both parties sign and keep. It should include: a consignment ID number, your contact details and the gallery's, the delivery date, and per-work details (inventory number, title, medium, dimensions, retail price, agreed commission split, condition on delivery). It functions simultaneously as a condition report and an accountability record of "what you have delivered, what has sold and what needs to be returned." Note that the gallery will maintain its own internal inventory number — record theirs alongside yours, but treat your record as authoritative.

(Consignment agreements — commission rate, payment timing, length, exclusivity — are a related contract topic; here the point is that the movement and terms get logged against the work.)

Think of each artwork record as carrying a chronological event log that accretes over the work's life. This is precisely how catalogue raisonné projects are built — the Roy Lichtenstein and Arshile Gorky catalogues, for example, add "new publications… as needed" and treat records as ongoing. Every sale, show, loan, and publication is one dated entry. Over decades, this log becomes the work's provenance and scholarly apparatus.

For each sale, record: buyer name and contact details, date of sale, price received, the gallery/dealer/entity that arranged it, and the commission taken. Keep wholesale and retail figures distinct, note when you were paid, and record the currency for foreign sales. Track secondary-market resales too when you learn of them — relevant to resale royalty rights such as California's Resale Royalties Act (Cal. Civ. Code §986), which the U.S. Court of Appeals for the Ninth Circuit largely nullified on July 6, 2018 in *Close v.

Sotheby's (holding it preempted by the 1976 Copyright Act, leaving only works resold between Jan 1, 1977 and Jan 1, 1978 eligible for the 5% royalty), and Europe's droit de suite, first codified in France in 1920 and now recognized in roughly 79 jurisdictions worldwide (the U.S. being the only major market without it). Contemporary Art Issue models a compact sale-history string: $60,000 (Christie's, London, UK, 2022) / $20,000 (private sale, 2019) / $4,000 (Tim Van Laere Gallery, Antwerp, BE, 2015) — one line that captures the full price trajectory.

Why it matters: documented, arm's-length sales are the raw material appraisers use to establish market value, and a chain of sales builds collector confidence. Sales to related parties carry less evidentiary weight, so record the relationship where relevant.

Highest-leverage insightThis is where an inventory earns its keep: recovering consigned work, assembling a retrospective and proving ownership all depend on knowing where things are.

Exhibition history

Museum standards give the exact anatomy of an exhibition entry. The Getty CDWA category "Exhibition/Loan History" specifies that "Each occasion when a work is exhibited or loaned should be documented separately; the subcategories… repeat as a group for each subsequent exhibition or loan. Gaps or uncertainties… should be indicated." A single exhibition entry should capture:

• Venue/institution name and city (state/country)
• Exhibition title (conventionally italicized)
• Opening and closing dates
• Exhibition type — solo vs. group vs. loan
• Catalogue/checklist number ("cat. no." / "no.")
• Whether the work was illustrated ("ill.," and whether color or b/w) and page number
• The title under which it was shown, if different ("as …")
• Travelling venues and their dates

Illustrative example entry (in conventional catalogue-raisonné style):

1949 New York — Whitney Museum of American Art, New York, Juliana Force and American Art: A Memorial Exhibition, September 24–October 30, 1949, no. 46, ill. in b/w, p. 58, as "Calendars."

CDWA treats "Related Textual References" as a core category — citations to "published bibliographic materials, Web sites, archival documents, unpublished manuscripts, and references to verbal opinions expressed by scholars or subject experts." A single literature entry should capture:

• Author (last, first)
• Article title (in quotes) and/or book/journal title (italicized)
• Publisher and place, volume/issue
• Year (and date for periodicals)
• Page number(s), and plate ("pl.") or figure ("fig.") number
• An "illustrated" flag (vs. merely "discussed"), and the title under which the work was reproduced

Illustrative example entry:

Jordan, Jim M. "Catalogue Raisonné of Paintings." In The Paintings of Arshile Gorky: A Critical Catalogue. New York and London: New York University Press, 1982, no. 314, ill. in b/w, pp. 480–81.

Log non-sale loans (to museums, for photography, for exhibition) with lender/borrower, dates out and back, and condition on each leg. Standard abbreviations that recur in this event log: "ill." (illustrated), "cat. no." (catalogue number), "pl." (plate), "fig." (figure), "exh. cat." (exhibition catalogue), "p./pp." (page/pages).

The payoff A work with a documented exhibition history at reputable venues, a clean chain of sales, and literature references is more attractive to buyers, curators, and insurers, and appraises higher. As one practitioner puts it, "provenance turns your art into an asset with a measurable history." The entries you log casually over a career are exactly the dossier a future catalogue raisonné, estate, or museum acquisition committee will rely on.

Highest-leverage insightExhibition history is recorded as events, not as a list, because each entry has to answer where, when and under what title years after the fact.

Choosing a tool — three tiers (spreadsheet/relational/dedicated)

There is no single best tool; the right choice scales with the size of your practice, your budget, and your comfort with technology. Three tiers:

1. Spreadsheets (Excel, Google Sheets). Free, universal, portable. Perfectly adequate for a small or emerging practice. Weakness: no enforced relationships between works, sales, exhibitions, and contacts, so data drifts and reporting is manual.
2. Relational databases (Airtable, and similar no-code tools; Microsoft Lists). A step up: separate but linked tables for artworks, contacts, locations, exhibitions, and sales, with filtered views, roll-ups, and image galleries — "the key is to treat Airtable like a relational database, not a spreadsheet." Good for artists who want customization without dedicated software.
3. Dedicated art-inventory platforms (Artwork Archive, Artlogic, ArtCloud, GYST, Art Galleria, ArtMoi, and others). Purpose-built: image-first records, status/location tracking, consignment reports, invoices, exhibition and edition tracking, insurance and valuation reports, daily cloud backup, and often a public portfolio page. Artlogic's inventory, for instance, stores "provenance, location, condition, editions, literature, ownership history, shipping and more" per work. These reduce manual work and produce gallery-ready documents, at a subscription cost.

Evaluate any tool against a registrar's checklist: Does it enforce a unique ID? Can it separate location from storage? Does it track editions? Can it produce consignment and insurance reports? Does it back up automatically?

And can you export your data?

Because your inventory must outlive any single vendor (and, eventually, you), insist on export. The reputable platforms support CSV/XLS export of records and image/document archives — Artwork Archive states plainly, "your data is always yours. You can export your artwork records, contacts, reports, and more at any time." Treat the ability to get a clean CSV out — and periodic exports as a safeguard — as a hard requirement, not a nicety. This is also why saving images in standard, non-proprietary formats (JPEG, TIFF) matters for long-term accessibility.

Photograph every work — ideally as it is completed, before it leaves the studio or goes to the framer (so you capture the unframed state). A visual reminder is essential: as works amass, "it can be easy to forget which painting goes with what title." Store high-resolution originals; tools resize for web automatically. Add caption/detail images (installation shots, signature, detail of damage) as needed.

File-naming conventions Adopt a consistent, machine-friendly convention and never leave files as "DSC_2989.jpg." Principles from image-library standards:

• Use only letters, numbers, hyphens, and underscores; avoid spaces and special characters (< > : " / \ | ? *).
• Separate elements with underscores, words within an element with hyphens.
• Lead dates with ISO year-first format (YYYYMMDD) so files sort chronologically.
• A robust pattern for artists is to make the inventory number the file name (or its stem), so image and record are permanently linked — e.g., lastname_inventorynumber_title_year.jpg. This survives moves between drives and computers.
• Don't cram *all metadata into the filename — that just means cataloguing twice; keep rich metadata in the database.

The discipline of entering works at time of creation

The habit that makes or breaks the system: enter each work as you make it. The Joan Mitchell Foundation recommends integrating data entry into studio cycles — when you finish a body of work, when you prepare for a show, or on a set schedule every three to six months — and finishing each group (record updated, work labeled, packaged, and returned to its storage location) before starting the next. Retroactively cataloguing decades of work is the nightmare estates routinely inherit; entering at creation avoids it. If starting a backlog, work backwards from your most recent pieces to build momentum.

Your digital archive needs the same protection professional photographers give their files: the 3-2-1 rule, coined by photographer Peter Krogh in The DAM Book: Digital Asset Management for Photographers (O'Reilly Media, 2009) — Krogh distilled long-standing IT practice into what is now the standard formulation. Keep 3 copies of your data, on 2 different media types, with 1 copy off-site. In practice: the working copy on your computer, a backup on an external drive, and an off-site or cloud copy (rotating the off-site drive periodically, or using an automated cloud service). Cloud-based inventory platforms handle one leg of this by backing up daily to secure servers, but you should still keep your own exported copies.

A modern enterprise refinement is Veeam's 3-2-1-1-0 rule — adding one offline/immutable copy (ransomware resilience) and zero recovery errors verified by test-restore. Verify and refresh drives every few years to guard against bit rot; keep both digital and hard-copy records where feasible.

Borrow the museum discipline of audit — "systematically checking the accuracy and completeness of the information you have." On a regular cycle, reconcile your records against physical reality: walk the studio and storage, confirm each work's recorded location and status matches where it actually is, chase down anything consigned that should have sold or returned, and cross-reference third-party paperwork (shippers, storage facilities) against your records. Investigate and document every discrepancy. This catches lost works, unpaid consignments, and data errors before they become disputes.

Highest-leverage insightThe right tool is the one that matches the size of the practice; the wrong one is any tool the artist will not open on a Tuesday.

Stage 1 — Stand up a minimum viable system this month (any practice size).

• Pick a tool you will actually use. If unsure, start with a spreadsheet or a free/low-tier dedicated platform; the tool matters less than the habit.
• Define your inventory-number scheme now and write it down so it stays consistent. Favor a simple year-based or sequential scheme; avoid overloading the number with classification.
• Create records for your most recent works first (work backwards), record the core fields, attach one photo each, and label the physical works with their IDs.
• Benchmark to advance: every existing work has a record, a unique ID, an image, and a current location/status.

Stage 2 — Make it operational (within a few months).

• Add sales, exhibition, and consignment logging; generate a consignment sheet for every gallery relationship.
• Adopt a file-naming convention keyed to the inventory number and organize your image archive.
• Implement 3-2-1 backup.
• Benchmark to advance: you can, in under a minute, pull up any work's location, price history, and exhibition record, and produce a clean inventory or consignment report.

Stage 3 — Make it durable and portable (ongoing).

• Schedule data entry into your studio cycle (at creation, and a review every 3–6 months).
• Run an annual physical audit reconciling records to reality.
• Export a full CSV + image archive at least annually and store it off-site — proof against vendor lock-in and data loss.
• Fold the inventory into estate/legacy planning; it is the document your executor, heirs, or a catalogue raisonné will depend on. Estates routinely spend heavily reconstructing scattered, undocumented oeuvres — a lifetime inventory is the single most valuable thing you can leave.
• Triggers to upgrade tools: if you outgrow a spreadsheet (data drift, manual reporting pain), move to a relational or dedicated platform; if you begin working with multiple galleries or an estate advisor, prioritize tools with strong consignment, reporting, and multi-user access.

Image/file specifications for gallery or open-call submissions are covered under submission specifications. This piece is your internal system for knowing what you made, where it is, and what it did.

Highest-leverage insightWork backwards from the most recent pieces — a system that covers the last two years and is actually used beats a complete one abandoned halfway.