Nicole Hanna Jewelry
  • Home
  • Blog
  • Gallery
  • Learn To Wire Wrap
    • PDF Tutorials
    • Video Tutorials
    • Tutorial Membership 2022
  • Shop
    • SIGNATURE COLLECTION
    • GODDESS COLLECTION
    • PDF Tutorials >
      • Beginner Wire Weaving
      • Intermediate Weaving
      • PDFs for Cabochons
      • Advanced Weaving
      • Wire Wrap Workshops

Record Keeping for Your Home Jewelry Business

7/13/2017

9 Comments

 
Disclaimer: I am not a tax professional and this is not a comprehensive look at keeping records for your home or jewelry business. Please contact a tax professional for a complete list of IRS or tax requirements.
While I have devised a record-keeping system that meets my needs, here are some resources to help you establish a system of your own:

  • Record Keeping for Small Business
  • IRS Small Business Record Keeping
  • Jewelry Designer Manager Pro 
  • GoDaddy Online Bookkeeping
  • Intuit Quickbooks Bookkeeping
Getting Started

The system by which I've chosen to keep my records is electronic. I scan all receipts, and import into electronic files all mileage, cost of goods, and sales or expenses as they occur (ideally) or as an end-of-month record keeping task. These files are not only stored on my laptop, but on an external hard-drive, a secondary business computer and a cloud service. While at least one is always current, the other redundancies are updated monthly.
Picture
These e-files are broken down into the following categories:
  • Tax Year
    • Income & Expenses
      • Shipping Fees
        • Packaging Supplies
        • PayPal Shipping Fees
        • USPS Shipping Receipts
      • Website Sales: Imported from my sales platform on a monthly, or quarterly or bi-yearly basis. This tracks transaction number, payment portal, customer contact information, date of purchase and purchase amount.
      • Non-Website Sales: Includes screenshots of PayPal invoices sent and paid.
      • Mileage Includes (Spreadsheet): Starting yearly mileage, date of trip, beginning and ending address, purpose of the trip, starting and ending mileage of the trip, total trip mileage, ending yearly mileage, total yearly mileage.
        • Trips to Include (but are not limited to): post office for the delivery of customer purchases, post office for passport photos (when required for business-related international travel), airport, lunch with business prospects, hobby or craft or office supply stores, trips to tax professionals.
    • Inventory (Spreadsheets)
      • Cost of Goods
      • Cost of Goods Sold
      • Cost of Goods (Gifts and Promotions)
      • End Inventory (Raw Materials)
      • Start Inventory (Raw Materials)
    • Receipts (Possible Categories Include):
      • Advertising
      • Bookkeeping
      • Office Supplies
      • Electronic Devices
      • Gemstones, Beads, Wire
      • Payment Processing Fees
      • Meals and Entertainment
      • Displays
      • Travel
      • Tools
Inventory (Raw Materials)

While most of the sub-categories listed above are self-explanatory, let's take a closer look at one possible way of maintaining records for inventory. I have, in the past, used Jewelry Designer Manager Pro, but found the program rather cumbersome for my needs. I've discovered, through the years, that keeping a minimum amount of materials on hand is most beneficial to me when calculating the tax benefits or disadvantages involved with ones inventory records. Purchasing materials as needed, verses an inventory surplus, means my capital is not tied up in unused materials. Remember: you can only claim deductions on materials in your costs of goods sold in any given tax year, not necessarily on materials purchased. However, inventory purchasing habits are entirely dependent upon the needs of your business, the nature of your product, and the market to which you sell.

Since my inventory of materials is limited, I find spreadsheets sufficient for my needs. Let's take a look at how I've set up my spreadsheets for inventory maintenance.
Picture
My categories include: Wire & Sheet Metal, Metal Findings & Incidentals, Seed Beads, Swarovski, Gemstone Beads, Gemstone & Glass Cabochons. Each category is listed alphabetically and these materials are stored in their containers alphabetically, so conducting an inventory checklist (quarterly, ideally) is as painless and seamless as possible.

When new materials are purchased, each are broken down by item name, size, number of items purchased, price per number purchased, price per each, and total cost in inventory. For wire, while most calculate the cost of wire used by inch, I have decided to calculate by weight, into price per gram. Sheet metal is broken down in price by sheet, but may be broken down further in my Cost of Goods spreadsheet, depending on how many pieces I'm able to complete from a single sheet. When a strand of beads are purchased, the strand is broken down by price per strand, price per bead, and total cost of beads available. Every time a bead is used in a piece of jewelry, for example, the amount of beads is subtracted from the Inventory spreadsheet and added to the Cost of Goods Spreadsheet.

Cost of Goods
Picture
When determining the cost of goods, each item used is transferred from the Inventory spreadsheet to the Cost of Goods spreadsheet and adjusted to reflect the amount used in the goods. So, for instance, I copy and paste the line "Copper Round Wire, Dead Soft 28g" from the Inventory spreadsheet, then adjust the "Grams/Pieces" column to accurately reflect the number of grams used in the piece while also subtracting that amount from the Inventory Spreadsheet. This way, both spreadsheets accurately reflect the transfer of inventory as each piece is constructed.

While this may sound complicated, once the spreadsheets are initiated, it's only copy and paste to keep each updated. I always maintain an unedited record of my inventory at the start of the year, and create a separate inventory list which is modified in real time, as jewelry is made and supplies are purchased or used. When an item is used entirely, the line item remains at zero in my End Inventory spreadsheet. This allows me to accurately determine all the supplies utilized from the beginning of the year, including supplies purchased and used throughout the year. At the end of the year, however, all lines with zero items is deleted, and this creates a "Start Inventory" list that will remain unedited in the following year. In essence, the "2017 End Inventory" list becomes the "2018 Start Inventory" list, minus all zeroed line items.

Cost of Goods is copied and pasted to the Cost of Goods SOLD list as each piece is sold. Customer name and date of purchase is added beneath the photo.

Now, using a program like Jewelry Designer Manager can certainly simplify the process for some, since it's all-inclusive in a single program and tax documents can be individually exported as needed, I personally found it more work towards its initial set-up than I was willing to invest and, upon discovering that tech support was not offered for the life of the program, I hesitated to perpetually re-purchase. I once had to transfer the program to a new computer, my files were lost and no tech support was offered to help recover those files, so I had to start from scratch. Insert the use of spreadsheets, especially those created in a free cloud service, which are updated and saved in real time and can be accessed from any device.

A Note On Bookkeeping Software

I admit that I am woefully unskilled in utilizing programs like Quickbooks to their fullest potential. For a couple years, I used GoDaddy Bookkeeping, which was incredibly intuitive and easy to navigate, though still (for me) an unnecessary monthly expense. While it tracked sales, payment processing fees, returns, in-state purchases (for state sales tax reports), receipts and quarterly tax payments made, I discovered these were all things easily exported from my sales platform and payment processors, into quarterly spreadsheets, and it proved itself a redundancy I just didn't need. I'm saving myself a yearly bookkeeping fee and only adding 10 minutes of work to my monthly bookkeeping processes. And, honestly, most of this bookkeeping and exporting of data would keep until my end-of-year review.

Ultimately, however, your sales, platform, payment processors will all determine your need for a specific bookkeeping software.
In Conclusion

Bookkeeping, inventory, taxes are all evil words.

Evil, evil words.

Though I have an understanding with my bookkeeping process, and me and my process are cordial to one another and exist as a working business partnership, I will admit I wont be inviting my inventory out for a drink any time soon.

And while I understand this article is only a quick outline of things to consider, I hope you found it useful during the discovery and establishment of your own evil, evil bookkeeping system.
9 Comments
Daune Price-Hannah link
7/14/2017 06:47:20 am

Thank you for your hard work and sharing your process and guidance. I know that this will come in hand as things start coming together. Again thank you for leading the way.

Daune Price-Hannah

Reply
Donna Hirsch
7/14/2017 09:01:27 pm

I feel your pain. I was responsible for the inventory, accounts payable, asset management, payroll and many other areas for 30 years for multiple locations. I still have nightmares after 16 years of retirement.

Reply
Christine Gray
8/1/2017 07:05:00 am

Lots to think about, thanks for trying to make it sound manageable and doable lol. I really need to get my ass in gear and get my own accounts in order.

Reply
Deb link
8/3/2017 11:02:12 pm

I use my husband - he normally says "easy on the checkbook".... other than that good to go but in all honesty I am a newbie so I have a good record of what I have spent ...so far.

Reply
Spencer Wong link
5/20/2018 06:54:31 am

Thanks so much for sharing !!! I just started my own jewelry business last month and this is my first time of doing business alone lol! You know everything is so difficult to deal with at the first place, but this article saved me! This is a good way to make your business being organized ! Thanks again, I will try !

Reply
Diana link
12/24/2021 06:27:40 am

Nice blog! Thanks for sharing this blog with us.

Reply
Sharon A Lange
1/4/2022 03:42:49 pm

What have I gotten myself into? Oh, had I only known.
Thank you so much for this.

Reply
Eleni Rethimiotakis
1/23/2022 08:31:35 pm

I love your ideas for record keeping. Thank you !

Reply
Alexa Martha Designs link
2/5/2022 12:33:27 pm

Thank you so much Hannah. For us jewelry designers, makers these are evil words lol. As you I had the Jewelry Designer Manager for years and was totally hanging in the air when she announced she is closing, I went to Craftybase which works with Shopify. At first I thought I absolutely love it , because they do everything for you and charge you good for it which I don't love. It's online only so all your stuff is unavailable when they have a server crash, which has happened and than I could not work on my stuff for the whole day, really? No, the time has come where I, need to learn it. So yesterday I googled intensely and found Paper& Spark. I hope this will set the course right for me. They are a momentary one time investment, I got the whole package, not as much as an two hours is with a bookkeeper, yikes. If you want more info you have to copy/paste. I don't want to post links here. I hope you check it out. I for sure starting to feel comfortable, knowing I will get this evil tax monster as I like to call it, handled, taken care off and conquered.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Enjoy my content?

    Categories

    All
    Articles
    Blog
    Contests
    Giveaways
    Reviews
    Tutorials

    Archives

    January 2022
    July 2021
    November 2020
    September 2020
    July 2020
    June 2020
    May 2020
    August 2019
    May 2019
    April 2019
    February 2019
    January 2019
    October 2018
    September 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    January 2018
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    December 2015
    October 2015
    August 2015
    July 2015
    June 2015
    April 2015
    March 2015


    Follow Me!


    Search My Site!


    Feed your creative spirit! Shop now!

    Picture

Check out my private Facebook group for live chats, giveaways and more! CLICK HERE!
FAQ
Contact
​
Gift Cards
NEWSLETTER
Jewelry Care
Privacy Policy
Permissions & Copyright
​Returns & Exchanges
​Shipping Policy
  • Home
  • Blog
  • Gallery
  • Learn To Wire Wrap
    • PDF Tutorials
    • Video Tutorials
    • Tutorial Membership 2022
  • Shop
    • SIGNATURE COLLECTION
    • GODDESS COLLECTION
    • PDF Tutorials >
      • Beginner Wire Weaving
      • Intermediate Weaving
      • PDFs for Cabochons
      • Advanced Weaving
      • Wire Wrap Workshops