Sunday, October 9, 2011

Inventory and cost of goods sold for your Etsy or crafts business

Inventory and cost of goods sold can be a very confusing subject for many Etsy and crafts shop owners. Crafts makers have challenging issues:
  • They work with large quantities of small items (such as beads)
  • They work with items that are measured in yards or inches (yarn, threads, fabrics)
  • They work with items that have been previously owned personally by the business owner
  • They work with bits and pieces of materials (quilters, recycled or repurposed crafts, etc)
Here are some answers to some commonly asked questions:

Do you have to keep track of inventory?
Generally - yes. According to the IRS, “generally, if you produce, purchase, or sell merchandise in your business, you must keep an inventory.” There are some exceptions to this but unfortunately it does not apply to business owners who have a retail business or sell online.

What does inventory include?
Inventory includes:
  • Products not sold yet
  • Raw materials (materials used to make the things you sell)
  • Work in progress (merchandise that is not completed yet)
  • Supplies used to make the things you sell
How do you track inventory?
According to the IRS, “you must value your inventory at the beginning and end of each tax year to determine your cost of goods sold.”
Here is an easy way to do it:
a.     Do this on or around the last day of the year (around December 31)
b.     Gather items that would be considered inventory
c.      Make a list (quantity, description, and what you paid for it)
d.     Add up the total cost that you paid for it

How do I know what I paid for inventory?
First, you have to keep track of all receipts for your purchases. To determine what you paid for it – look at your receipts. If you don’t have receipts then look up the current cost online. Otherwise make your best estimate and write down that it’s an estimate.

Here are some suggestions that have worked for me:
  • Buy only supplies that you need to complete current orders - don't buy excess supplies
  • Add a note or sticker to the supplies you purchased that includes the date purchased, the store you purchased it from, the quantity purchased and the amount paid. For example, if you are using yarn, then write it on the yarn label. If you are using fabric, then write it down on a piece of paper and use a clothespin to pin it to the fabric. You may want to make yourself a label that looks something like this:

Do you really have to keep track of every little inventory item?
Technically - yes, but you also have to be reasonable. If you are a jewelry maker and you are using clasps or beading wire, maybe that is not major component of your jewelry. Your beads are probably the most expensive. You would probably be okay with not tracking the minor components and classifying them as supplies.

What is "Cost of Goods Sold"?
Cost of goods sold includes the cost of supplies used in making your products or the cost or merchandise bought for resale.  For example, if you make jewelry, then you would include the cost of beads and findings.  If you make crocheted hats, then this would include the cost of yarns and fibers. 

How do you calculate Cost of Goods Sold?
Cost of Goods Sold is calculated using the following formula:
   Beginning Inventory plus Purchases minus Ending Inventory = Cost of Goods Sold.

What are "Supplies"?
Supplies include the cost of small supplies that are not included in Cost of Goods Sold, such as glue, thread, needles, knitting needles, paint brushes, paints, etc.  You can also include the cost of books, and small equipment.  For example, if you make stuffies you would include the cost of needles, thread, buttons, scrap materials, fabrics and stuffing used to make samples.

Can you give me an example of what this looks like in real life?
Yes. Jane had the following activity in her business for the year:
  • $1,000 spent on bead purchases
  • $100 spent on jewelry findings (clasps, bead wire, etc)
  • $250 spent on jewelry display units
  • $300 in inventory at the beginning of the year
At the end of the year, Jane had some beads left. She also had 5 necklaces made which she did not sell. On December 31st, Jane used an inventory worksheet to count all of the beads. Her beads inventory at the end of the year totalled $245. She also calculated the cost of the beads and materials included in the 5 necklaces. This cost totaled $50. Based on this, her inventory at the end of the year is $245 plus $50 or $295.

She had only a few jewelry findings left, which she estimated at $25. She decided this was a minor amount and opted not to count it as inventory.

The jewelry display units are not inventory or cost of goods sold. They are considered supplies.

Her cost of goods sold for the year is calculated as: $300 (beginning inventory) plus $1,000 (purchases) less $295 (ending inventory) = $1,005.
Her inventory at the end of the year is $295.

Do you have an inventory worksheet I can use?
Yes, you can download a free Excel inventory worksheet at my website.

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Friday, September 16, 2011

Reviews of Outright accounting - a popular software package for Etsy shop owners

In case you haven't heard, Outright is a popular bookkeeping software for Etsy shop owners and crafts business owners. I have been curious about it for sometime and how it compares to QuickBooks. I am a QuickBooks expert and I use QuickBooks for my business so I wanted to know more about Outright from actual users.

Here are a few reviews:
The Work At Home Wife gives a very thorough review . She concluded that QuickBooks online will work better for her business.

Small Business Trends also has a very detailed review, including printscreens. They say "if you’re a sole proprietor, or a new entrepreneur, or you run a small home-based business, Outright is a great place to start keeping your books."

factoidz points out key differences between Outright and other programs such as QuickBooks. They also include customer feedback from actual users.

I hope that these reviews help you decide. You can always try Outright free for 30 days. Keep in mind ease of use, the size of your business, and what Outright will do versus other more robust software packages like QuickBooks.
For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Wednesday, September 14, 2011

Should you use QuickBooks for your Etsy shop or crafts business?

This is a very common question in the crafty and Etsy forums. Should you use QuickBooks for your Etsy shop or crafts business? It depends.

Newbies
If you are relatively new and don't have a lot of extra funds yet, you can use a simple Excel bookkeeping worksheet.

Your business is growing
If your business is growing and you have excess funds then you should consider using QuickBooks. Keep in mind that just because you use QuickBooks you are not guaranteed that your bookkeeping will be in order. Think of it this way, you don't drive a car if you haven't had driving lessons. When you purchase QuickBooks you may need to pay a QuickBooks expert to set it up for you and to show you how to use it correctly and specifically for your crafts business. You should budget approximately $150 for purchasing QuickBooks and at least $300 for paying the QuickBooks expert for their services.

You replaced your day job with your Etsy or crafts business
If you have been able to replace your day job then you really need to get your bookkeeping in order so that you can manage your business properly and pay your taxes. In this case, you should defintely be using QuickBooks and consider hiring a bookkeeper so you don't have to do it all yourself.

There are of course other software products out there for Etsy shop owners and craftypreneurs, including Outright. Check them out and determine what's best for you. The main thing to remember is that any accounting software that you purchase does not guarantee that you will set it up correctly or use it correctly. Consider the funds that you have available and the size of your business.

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Friday, September 9, 2011

Simple Excel bookkeeping spreadsheet for Etsy shop owners and craftypreneurs

If your crafts or Etsy business is small and you don’t want to get too complicated with your bookkeeping and accounting then you can use a simple Excel worksheet to track income and expenses.  If you use Excel, you can set up the worksheet on Excel. You can download a free Excel worksheet from my website when you join my mailing list.

The advantages of using a simple bookkeeping and accounting worksheet for your Etsy and crafts business are ease of use and low cost.  The disadvantage of using a worksheet is that you have to add up transactions manually to record onto the worksheet.  Also, a worksheet does not provide you with financial reports like a computerized bookkeeping and accounting system does. 

You can download a simple Excel bookkeeping and accounting worksheet from my website. You can use to it to track business income and expenses on a monthly basis.  The categories used match IRS “Schedule C”.  IRS “Schedule C” is the form that is used to report income or loss from a business organized as a sole proprietor on IRS Form 1040 – an individual tax return.  By using this form you will save lots of time when you file your individual tax return since everything will already be categorized. 

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Wednesday, September 7, 2011

Have you paid your estimated tax payments for your Etsy shop or crafts business?

Many small business owners and Etsy shop owners get into trouble with the IRS because they do not make estimated tax payments or they do not have the funds to pay the IRS for taxes on their crafty business when they file their income tax return.  This is what you need to know:

1.     If you are organized as a sole proprietor (you file Schedule C) - your business profits are subject to federal income taxes and also self employment taxes (due to the IRS).

2.     You have to set money aside to pay for federal income taxes and also self employment taxes.

The IRS wants you to make “estimated” payments on a quarterly basis for the taxes that you estimate you will owe.  If you do not make estimated tax payment the IRS may charge a penalty.  Estimated tax payments are due on April 15, June 15, September 15, (of the current tax year) and January 15 (of the following year). In other words, for 2011, you would pay estimated tax payments on April 15, June 15, and September 15 of 2011 and on January 15th of 2012. 

Most small business owners do not like to make estimated tax payments because they think it’s inconvenient. You can make estimated tax payments online or on the phone using www.EFTPS.com – it’s easy and convenient. Many small business owners also do not like to pay the IRS for income and self employment taxes because they don’t have the money or just don’t like to. I understand how they feel but look at it this way –your employer (if you are employed)  deducts taxes from your paycheck. In the end we all pay taxes. The best thing to do is to make sure that you put money aside to pay for estimated taxes. Make sure you do that or you may get into trouble with the IRS.  For more information, refer to Publication 505, Tax Withholding and Estimated Tax http://www.irs.gov/publications/p505/index.html.


For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Thursday, September 1, 2011

Business income and business expenses - a primer for Etsy shop owners and craftypreneurs

On my last post I talked about the importance of separating business income and expenses from personal income and expenses. Let's look at the definition of business income and business expense.
Business income refers to money you have earned in your business. Business expenses refers to money you have spent on your business. The IRS also defines business expenses as “the cost of carrying on a trade or business.”  The IRS also indicates that business expenses must be “ordinary and necessary.”  The IRS points out that “an ordinary expense is one that is common and accepted in your trade or business.  A necessary expense is one that is helpful and appropriate for your trade or business.”  For more information see IRS Publication 334 – IRS Tax Guide For Small Business.

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Tuesday, August 30, 2011

Keep your Etsy/crafts business income and expenses separate from your personal stuff

Many creative entrepreneurs and Etsy shop owners fail to separate their business income and expenses from their personal income and expenses. This is called “co-mingling of funds.” A good way to separate business income and expenses from personal income and expenses is to open a separate business bank account. Be sure to run all business income and expenses through the business bank account. The reason that you want to separate business from personal funds has to do with legal and tax purposes. First, when a business is organized as a limited liability company, corporation, or partnership, that business it is a separate legal entity from its owner or owners and it should have a separate bank account. Second, co-mingling of funds can bring up a lot of negative consequences in case of an IRS audit. On my next post I'll talk more about business income and business expenses.

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Thursday, August 25, 2011

Etsy and Crafts Business Tax Primer

Many small business owners are misinformed when it comes to taxes. There are many different types of taxes that businesses and individuals pay. I’ll go over some of them:

A business pays different kinds of taxes:

            Income Taxes:

§  Federal income taxes to the IRS (depending on the business structure selected)

§  State income taxes to the states where the business is doing business

§  State income tax rules vary from state to state – some states don’t have a state income tax on corporations or businesses

Sales taxes and use taxes:

·       Collected by the seller on taxable sales and services provided within the seller’s state

·       Sales and use taxes are paid to state and local authorities

·       Sales taxes are not considered “income” taxes. You collect sales taxes from the buyers that reside in your state and you submit the sales taxes collected to your state

·       You register to collect sales taxes with your state (not the IRS). Rules vary from state to state regarding what items or services are taxable. If you are unsure you need to contact your State’s “Department of Revenue.”

Payroll Taxes:

·       Paid to the IRS and the state where the business hires employees (this applies only if the business is paying employees)

·       Payroll taxes are not considered “income” taxes


An individual (a person) pays different kinds of taxes:

§  Federal income taxes to the IRS

§  State income taxes to their state (if the state has an income tax)

§  Self employment taxes to the IRS for certain business earnings

It's important that you now the differences in the kinds of taxes that you need to pay for your Etsy and crafts business. 

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Stop worrying. Save hours of research online. Check out these Tax, Business, Accounting and Bookkeeping PDF e-book guides written by a CPA and creative entrepreneur just like you. Available for instant download.

Tuesday, August 23, 2011

Is your Etsy or crafts business legal?

The process for making a business “legal” or obtaining a business license or permit can sometimes be confusing for Etsy shop owners and craftypreneurs. Here is what you must know.


You obtain a business license or permit from your state. This process is called “register to do business”. Rules vary from state to state. Some states require you to file an “assumed name” or “dba” if your business name is not the same as your name. You must check with your State’s “Secretary of State” office to determine what your state’s requirements are for registering to do business in the state. You can go to the IRS’s listing of state websites at  http://www.irs.gov/businesses/small/article/0,,id=99021,00.html to get the link to your state’s “Secretary of State website.” If you are unsure what to do you can call or e-mail your state's secretary of state office. You can also read information provided at MyCorporation.com.  This is an online service that will assist you with incorporating and forming a business for a fee.  Their website has a lot of free information that you can refer to.

You may be asking yourself, what about the IRS? Don’t you get a business permit or license from them? No, you don’t. You pay taxes to the IRS but you do not register to do business with the IRS. I'll cover that in the next post.

For a free article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" and for free Excel worksheets just for Etsy shop owners and creative entrepreneurs visit my website.

Thursday, August 11, 2011

Schedule C Basics for Creative Entrepreneurs and Etsy Shop Owners

What is Schedule C and do you have to file one? If you sell crafts on Etsy or other online venues you probably have tax questions. The most popular questions that crafts business people have pertain to Schedule C. Here are some basics. Schedule C is the form that you fill out to report "Profit or Loss from Business Sole Proprietorship." Schedule C is filed together with Form 1040 when you filed your federal U.S. income tax return. Generally, a small business owner who has chosen to be organized and taxed as a "sole proprietor" or a "Limited Liability Company" files Schedule C. A small business owner must file Form 1040 if the net profit from their business and self employment income for the calendar year (January through December) was more than $400. If you are required to file Form 1040, then the net profits from the business and self employment income are reported on Schedule C. In order to fill out Schedule C you need to know what your business income and expenses were for the calendar year. For more information, free downloads including a simple bookkeeping worksheet to use to fill out Schedule C, and for ebook guides and resources for Etsy business owners and creative entrepreneurs visit my website at www.MyCreativeCPA.com.

Tax Help For Crafters and Etsy Shop Owners - Tips For Working With A Tax Preparer Or CPA

Here are a few tips for working with a CPA or tax preparer. If you don't know how to find a CPA ask around for recommendations. Always ask them for an estimate before they do your taxes and shop around for rates. Most importantly, find a CPA or tax preparer that you like.
  1. Send everything to your tax preparer or CPA during the month of February. This way your return will be completed quickly. Most people wait until March and April. By this time, CPA’s and tax preparers are swamped with work and your return will not get done quickly.
  2. Never e-mail anything containing your social security number to your CPA or tax preparer and do not allow them to e-mail you copies of your tax return. E-mail is not secure.
  3. Send your CPA or tax preparer all of your information at one time. Do not send partial information. Your fees will be higher if they have to change your return several times because you keep sending additional information.
  4. Send your CPA or tax preparer your bank account number and ABA number so that the IRS can send your refund directly to your bank account. Be sure that you provide the correct numbers.
  5. Do not send your CPA or tax preparer a box full of receipts and records. They don’t need it. If they have to look for something they will generally bill you to look through your box. It’s best for you to hold on to your box of information and only send them something if they ask for it.
  6. If your CPA or tax preparer asks for any business receipts or documentation – send them only copies. Never send your CPA or tax preparer any original documentation. They may lose it.
  7. Your CPA or tax preparer is not the IRS. They don’t need to get all of your business receipts and documentation. They don’t have a responsibility to verify most of the information that you send them.
  8. Your CPA or tax preparer is not a mind reader or professional organizer.
    1. Do not send hand-written notes or papers with numbers and scribbles on them.
    2. Do not send documents that you think are tax related but are not
    3. Do not send disorganized information. It’s best if you paperclip together (do not staple) similar documentation.
  9. Respond promptly to CPA or tax preparer when they have questions. The longer you take to reply to them the more time that will pass. If you wait too long, your tax return will go to the bottom of the pile and other returns will be completed before yours is completed.

10 Things Every Creative Entrepreneur and Etsy Shop Owner Must Know About Taxes, Bookkeeping, and Business Licenses

I just wrote an article "10 Things You Must Know About Taxes, Bookkeeping, and Business Licenses" just for Etsy and crafts business owners who need help with taxes, bookkeeping, and business licenses. It is free for you to download from my website. Read this if you have an Etsy or crafts business or if you are thinking of starting one.

Tax Help For Etsy Sellers, Crafters, Indiepreneurs, and Creative Entrepeneurs

If you own an etsy shop, arts, design, or crafts business and need help with schedule C and getting ready for tax time - read this guide! I have just published my third e-book especially for creative entrepreneurs. This is a comprehensive tax guide to help you with your Etsy business or crafts, arts, design, or indie business. This ebook tax guide covers everything you need to know to get ready for tax time and tackle that dreaded Schedule C! Learn what is business income and expense. Learn what is deductible. Learn what records you need. You can read more about them at my website and download free worksheets - such as a simple bookkeeping and accounting worksheet, mileage log, inventory worksheet, and fixed assets worksheet. Don't ask for business advice in the forums anymore. Save yourself hours of research, frustrations, and headaches. Order my ebooks today!

New Website for Creative Entrepreneurs, Etsy Shop Owners, and Crafters

After 3 years my idea has finally developed into a website. Introducing MyCreativeCPA.com. A website specifically for creative entrepreneurs, crafters, artisans, artists, designers, indiepreneurs, and creative mompreneurs - anybody who sells crafts, arts, and designs. I have written a series of PDF e-book guides about business, tax, accounting, and bookkeeping topics specifically for you creative entrepreneurs. Do you sell crafts online? Are you an indie designer or crafter? Do you know what the IRS and state and local requirements are for engaging in a small business? These e-books are informative and easy to read and will provide you with everything you need to know to set up your business for legal and tax purposes, business, accounting, and tax topics. 

New Blog - Creative Biz*ology - Tax, Numbers, and Business Tips for Creative Entrepreneurs, Etsy Shop Owners, and Crafters

Introducing my brand new blog - Creative Biz*ology. The premier blog for providing valuable tax, accounting, bookkeeping, record keeping, and business resources and tips for creative entrepreneurs, Etsy shop owners, and crafters. Finally, information provided by a "CPA" (Certified Public Accountant) who is also a creative individual. When it comes to business matters, don't be afraid - be informed. Get your information from a reliable source.