When it comes to keeping track of your artwork, there are four general options to consider: maintain a ledger or spreadsheet, create a database, purchase a database, or subscribe to a database service that stores the information in the cloud.
Maintain a ledger or spreadsheet
Here are some of the line items you might want to include in your spreadsheet.
- ID Number
- Orientation (horizontal or vertical)
- Framed (yes or no)
- Framed size
- Year of creation
- Signed (yes or no)
- Signature location
- Edition # ___ of ___
- Edition type (digital print, giclee)
- Edition publisher
- Edition printer
- Date created
- Status (available, on consignment, on proposal, sold, traded, donated, loaned, gifted, not for sale)
- wholesale price
- markup (percentage)
- retail price
Create Your Own Database
You could create your own database using FileMaker Pro or with your favorite database program.
Purchase a Database
Another option is to purchase a database that has been created specifically for artists. One example of such a database is eArtist. It sells for approximately $125.
Subscribe to Database Service
Artwork Archive is a cloud-based service that helps artists track inventory and sales. For $50 per year, you can manage 100 pieces of artwork at 10 locations. For $100 per year, you can manage an unlimited number of artwork at an unlimited number of locations.