How to track art inventory

How to Track Art Inventory: A Complete System for Artists and Galleries

Most artists and galleries don't lose track of their inventory all at once. It happens one untitled JPEG at a time — a piece sold at a fair with no record of the buyer, a work on loan nobody remembers to follow up on, a spreadsheet tab that hasn't been touched since March.

By the time it becomes a problem, it's usually a big one: an insurance claim with no documentation, a collector asking about provenance you can't produce, or a studio move where half the inventory has no clear status. Here's a system that holds up, whether you're tracking twelve works or twelve hundred.

What "tracking inventory" actually means

A usable system answers five questions for every single work, on demand:

• Where is it right now? (studio, on loan, consigned, in transit, sold)
• What is it worth? (insured value, asking price, last sale price)
• Who has touched it? (artist, gallery, collector, conservator)
• What proves it's authentic? (certificate, invoice, exhibition history)
• What happens to it next? (return date, payment due, renewal)

If your current system can't answer all five in under a minute, it's not really a system — it's an archive of good intentions.

The core fields every record needs

• Title, artist, year, medium, dimensions — the baseline catalogue data
• Edition information, if applicable (e.g. 2/5)
• Current status — in studio, on loan, consigned, sold, deaccessioned
• Location — physical, specific, and updated when it moves
• Price and value — asking price, insured value, last sale price, currency
• Provenance notes — prior owners, exhibition history, publications
• Associated contact — the collector, gallery, or institution connected to the work
• Condition notes — especially important for older or fragile works

Why spreadsheets stop working

• No single source of truth. One version lives on a laptop, another gets emailed to an assistant, and the two drift apart within a month.
• No relationship layer. A spreadsheet tells you what you own, not who's interested in it or who bought the last thing like it.
• No status visibility. "On loan" is a cell value, not a workflow — nothing reminds you the loan agreement expires in nine days.

A simple tracking workflow you can start today

1. Do one full pass. Log every work with the eight fields above, even roughly. A messy complete record beats a tidy incomplete one.
2. Assign a unique ID to each work. A sequential code (AUR-0001) prevents duplicate or ambiguous records once a title gets reused.
3. Log status changes as they happen, not in a monthly batch. The five-minute update the day a work leaves the studio is the one that saves you later.
4. Attach documentation at the point of creation. A photo, an invoice, a condition note — capture it while it's easy.
5. Review "needs attention" monthly. Expiring consignments, unpaid invoices, overdue follow-ups.

When to move off spreadsheets

If you're spending more than twenty minutes a week reconciling what's actually true about your inventory — chasing a status, cross-checking a price, hunting for a document — the spreadsheet now costs more time than a proper system would. That's usually between 50 and 100 works for an individual artist, or as few as a dozen active consignments for a gallery.

What to look for in dedicated software

• A workspace that separates inventory, clients, and status as connected layers, not one flat list
• The ability to export everything you put in, so you're never locked in
• A model built for provenance and history, not just current stock
• Support for how your practice actually works — artist, gallery, collector, or advisor each need a different view of the same data

Aurelian was built around exactly this: one private workspace where every work has a title, a status, a value, and a client attached to it — and everything is exportable any time you want.

FAQ