Keeping records of tack is something that not everyone does. Some tack makers are so low volume that it just isn't necessary, or they don't expect to become high volume and have nothing set up. I started out in the second category; I didn't keep records until 2009, and even then my attempts were sporadic and short lived. It wasn't until 2010 that I started my current digital version.
Keeping a close record of previously made pieces isn't always imperative, but I find it very helpful. I like knowing what I've made in the past, and if a customer needs a repair or replacement part, it's especially nice to know what kind of dye I used. Not only is it great to keep the details of each order straight, records are also extremely helpful when dealing with deposits and time payments.
My first attempts at record keeping were aimed at finding a way to gather the pertinent information about an order in one place. I cycled through an index card and binder system before settling on Microsoft Excel. Excel and similar programs like Google's Spreadsheets are useful for a variety of reasons. Information can be sorted via filters, easily changed, and tabs make it easy to keep track of different sections of your hobby endeavors. It also made it much easier for me to be consistent with the information I took down, as well as keeping track of non-commissioned pieces.
Excel is part of Microsoft's Office Suit and does not come standard on
Windows machines. If you don't want to buy a program, there are
alternatives like Google Spreadsheets and OpenOffice.org. I have used
Google Spreadsheets for other projects and really like it, but am
hesitant to use it for tracking orders. The great thing is that it can
be accessed from any computer, and that's also my concern. Spreadsheets
can be marked as private, but I still worry about hackers. The most
sensitive information I keep in my spreadsheets are email addresses, but
I don't want some unsavory person getting into any of the information I
have on there.
The information I include in my spreadsheet has evolved over time and is still evolving. I have tabs to keep track of current orders, finished pieces (which includes finished commissions, donations, sales pieces, and personal projects), and accounting. Instead of just keeping the details of an order straight, I'm also tracking the numbers made, how many times a customer comes back, when certain things were finished, and even trends in dye and style. Don't forget the accounting possibilities with Excel and other spreadsheet programs!
Here are two screen shots to give you an idea of how I have this set up. Click on the photo to view larger. Some information has been removed or fabricated to protect the innocent.
The first screen shot is of my tack log. I track finished pieces here whether they're sales, orders, donations, or personal pieces. Items are added to this sheet after they are completed. In the past I only tracked orders and donations, but when I closed my books it became more important to track all of my work.
Originally the "details" column included what mold(s) the set was fitted to and what dyes were used, but when I redid my Excel file at the beginning of the year I split those out so that I could track trends more easily.
This second screen shot is of my orders page.
I hope this post is somewhat helpful; I always feel a little out of my depth when I write informational pieces for this blog. Comments are welcome, as always, and so are topic suggestions!