This package includes 8 templates for someone who wants all the best tools to organize everything in their handmade business. This includes all the upgrades on 2 of my most popular items-
The Raw materials inventory system – This contains 3 templates in 1 file, all linked together. Made for high volume sellers, it can handle up to 1,000 finished items and track up to 100,000 raw materials. This system includes a Pricing Template and COGS sheet, for up to 1,000 items. The raw materials inventory, pricing worksheet and cogs page are all linked together, saving you a ton of time and effort and keeping track of when your raw materials are running low, just by entering the sales of your finished items.
The monthly sales and expenses template – this is a comprehensive template to track everything in your business and then view the monthly and annual profit totals. There are several pages in this template that are all linked to the main summary page, including a page to enter sales, expenses, and several pages where you can import sales/fees from etsy, paypal and amazon handmade via csv (directions included). There is a 1 page summary for every month and an annual/running total summary as well. The summary will include expense category totals for –
•Shipping labels bought through etsy, paypal or amazon (via csv upload/importer)
•Shipping labels – other – you can manually enter them too
•Education / Training
•Etsy listing and transaction fees (via csv upload/importer)
•Etsy Direct checkout/paypal processing fees (via csv upload/importer)
•Transaction fees Amazon (via csv upload/importer)
•Cost of Goods Sold
•Other Listing/ Transaction fees – you can enter these in expenses page
Plus these favorite templates are included as well:
•Mileage tracker – print and keep in your car for business trips and excursions – it’s tax deductible!
•Overhead expenses template – up to 21 expense categories- you customize/choose the categories
•Timesheet – to track what you are spending your time on.
•Sale Receipts (and donation)
- Annual inventory worksheet – this is for tracking inventory when you plan to do an end of year inventory count.
Overall this package includes 8 templates, bought separately would be over $90, but with the package deal it is $75. You will receive your excel templates via email.
All of my templates come with detailed directions with pictures and are designed to be easy to use. If you have any questions, please feel free to contact me.
The spreadsheets are designed in MS Excel. You will need Excel 2007 or newer to use this particular template, although I have other templates that will work with excel 2003. You can purchase the individual templates (not linked together) and those are compatible with earlier versions of excel and Open Office.