Pantone Spring 2012 Color Scheme - Light
*This package includes Handmade Bookkeeping Complete, Bookkeeping Tips - FAQs - and Know-How , and Handmade Bookkeeping Spreadsheet Cheat Sheet.
* Be sure to read the compatibility chart on the right>>>
Here is what Handmade Bookkeeping Complete ?
This robust bookkeeping system allows you to track the following data:
- Raw Materials
- Finished Inventory
- Monthly Sales
- Monthly Expenses
- Marketing data
- Social Media statistics
- Cash/Bank/PayPal Accounts
- Sales Tax
- IRS Mileage
- Bill Tracker
- COGS (Cost of Goods Sold) Calculator
- And more!
Handmade Bookkeeping Complete includes three exciting and requested features to increase the power of the first version of the Handmade Bookkeeping Spreadsheet.
1. Fee Analyzer - Look at your monthly Etsy fee in a new way and spot trends that tell you about the "freshness" of your Etsy shop.
2. Marketing Log - Keep track of your marketing activities and see how your actions impact your performance in key areas (sales, views, traffic, etc).
3. Traffic Log - Set goals for your direct traffic to your website or Etsy shop and watch your performance as your shop's SEO (Search Engine Optimization) improves.
Not only is the data entry created in a way that is very user friendly, but it has relevant and insightful reporting that is created automatically!
- Reports for each month (34 graphical reports to choose from)
- Reports for the year (155 graphical reports to choose from)
This bookkeeping system also allows you to customize the financial “books” to the unique needs of your small business through a custom setup function. Also, since this bookkeeping system is based in spreadsheet form (Microsoft Excel), it is also fully customizable to cover any unique needs of your business – you can also manually change the colors to match your business’ brand or add your logo for a personalized touch.
If you are overwhelmed about the bookkeeping responsibility of your handmade business—don’t sweat it! There are detailed instructions as well as bookkeeping hints and reminders specific to each transaction throughout the tool.
This product can be used by artists that use both a pc or a mac if Microsoft Excel or Open Office is installed. See the last product picture to answer the question, “Will this bookkeeping system work on my computer?”.
Never has a product been developed for bookkeeping that is this robust (in many ways, it rivals QuickBooks, but cuts out the nonsense, complexity, and higher costs). This system has also had developmental input from a CPA that is a small business expert and has “audited” the functionality and reporting—you know you are getting a product you can rely on.
Other key points:
- Jewelry sellers, all your beads and raw materials will be easy to track and get organized
- Tax nerds, full COGS (cost of goods sold) functionality and Schedule C expense categories
- Multiple selling venues = no problem
- Buy once and use year after year (no annual fees like some online bookkeeping systems)
- Use for multiple Etsy shops
- Secure data (don’t trust your financial data with a third party who has no fiduciary responsibility to you)
- User friendly (you don’t have to know a thing about spreadsheets to use this—navigates like the web)
- Visual numerical stories (graphs) that make financial trends, warning signs, and success easy to recognize
- Room to grow with your business’ future growth
Upon receipt of payment, this bookkeeping system will be emailed to your PayPal related email account within 24 hrs.
Get organized, be IRS audit ready, be at financial peace, and grow your business with Handmadeologybiz’s Handmade Bookkeeping Spreadsheet!
Here are some common questions you’ve had about this bookkeeping system and their answers:
Do I have to type in every single piece of data?
No, you will be able to easily “import” aka “copy and paste” key information from CSV (comma separated value) files, choose from drop down menus, and some sections are automatically updated when you complete other areas. No bookkeeping system is 100% free of data entry or work (assigning cost categories, revenue streams, etc)—the challenge of bookkeeping is to make this as automated as possible so you can focus on your business, not bookkeeping.
Can the tool track and analyze more than one Etsy shop?
Yes, you can either save and copy the file and use a separate system for each shop, or keep track of multiple shops in the one spreadsheet by creating unique revenue and expense categories unique to each shop during the bookkeeping setup section you will perform before you get started using the bookkeeping system.
I don’t know what I need to track for bookkeeping purposes. Will this cover it all?
Yes, if you are a sole proprietor—this will cover all of the bookkeeping you need to do for tax purposes. Filing Schedule C with the IRS will be a breeze.
Will I be able to use this bookkeeping tool year after year?
Absolutely. This spreadsheet is designed to be used year after year making this a valuable tool not only for this year, but many years to come. There will never be any monthly usage fees to keep up with. Your financial data will be private and in your control only.
I’ve had trouble with spreadsheet that use macros, visual basic coding, or other types of advanced features—Does this spreadsheet use any of those?
No, you don’t have to worry about any code “breaking” in this spreadsheet or causing errors down the road in the future. Only pure Excel formulas and features are used keeping the functionality easy to see and even customize personally for your business in the future (if you desire).
Do I need to know Excel to be able to use this bookkeeping spreadsheet?
No, this spreadsheet was designed to be used with no prior experience in Excel. The navigation and entries are intuitive and user friendly. Navigation is like surfing the web.
How are all of the reports created?
When you get all of your sales, expense, inventory, and marketing data into the system—all reports are created automatically—making it easy for you to spot trends, see encouraging areas in your business, and make any changes in your business’ operations the next month.
What is COGS?
COGS are Cost of Goods Sold. This is the raw material costs used in products that are sold. They are an important aspect of bookkeeping that often gets overlooked by most handmade artists. Keeping track of inventory levels and COGS helps make filing Schedule C annually a breeze.
What currency do I need to use in the spreadsheet?
Like all bookkeeping systems, you will need to choose one base currency. All transactions will need to be recorded in only one currency—otherwise you could not add or subtract any numbers, because they would be in different currencies. An exchange rate converting tool is included in the spreadsheet to help make sure all transactions are always recorded in this base currency. It is suggested you keep track of your bookkeeping in the currency that your taxes are filed.
Can income & expenses from craft shows be entered as a separate entity or will it be combined?
Technically, all of the sales revenues are combined, but you can see the unique source or stream of where the revenue comes from if you so desire. If you wanted it as a separate entity, you would just keep multiple versions of the spreadsheet (one for the shop, one for the craft show).
I have a supplies shop, would this work for me too?
I have a vintage shop, would this work for me too?
How does this bookkeeping system compare to other bookkeeping systems out there already?
It takes the good parts of much more expensive “Big Box” bookkeeping systems, but leaves out the complicated features you will never use or make your bookkeeping a burden. Unlike some “online bookkeeping tools”, it will never charge you a monthly fee and keeps you in control of your financial future by keeping your personal financial information out of the hands of 3rd parties who have no fiduciary responsibility to you. It does not require you to have multiple spreadsheets open at one time, causing confusion and lack of compatibility. It is not so simple that it skips out on tracking valuable information to your business for operating and tax purposes. It is not so detailed that it will be a burden to keep up. Sounds great? We think so! :)
What levels of integrity, excellence, trust, auditability, and experience have gone into this product?
All of the functionality in this bookkeeping system have been requested by handmade artists for their own unique needs—not created in general for small business owners that have nothing to do with the handmade community. A CPA has audited the functionality. This product has been in development for months—going through a whole year’s worth of transactions in multiple “test runs”. This product has also been designed with user experience in mind throughout—what use is a bookkeeping system if it is hard to use. . . Formulas have been checked and double checked for mathematical accuracy. No other bookkeeping system tracks so many non-financial data elements as this—showing how valuable marketing and social media are to a handmade artist—not just financial numbers. Lessons from years of handmade artist’s financial mistakes have been considered and solutions are presented—so you don’t have to make these mistakes too.
This package includes 3 products:
Handmade Bookkeeping Spreadsheet
Bookkeeping Tips - FAQs - and Know-How
Handmade Bookkeeping Spreadsheet Cheat Sheet