📁 Side Hustles

Build a Simple Pricing Sheet for Your Side Hustle

Most Etsy sellers guess their prices and lose money. Use this simple spreadsheet method to fix your margins and scale to $12k months.

By MyBizNerd Team · Published

Key Takeaways

  • Calculate your hourly rate by dividing your target monthly income by the actual hours you spend making products.
  • Include a 'hidden costs' buffer of 15% to cover marketplace fees, packaging, and shipping tape.
  • Compare your final price against the BLS.gov data for similar goods to ensure you remain competitive in the current market.
  • Update your material costs every 90 days to avoid eating the cost of inflation on raw supplies.

"How do I price my products so I actually make a profit?"

You take the cost of your materials, double it, and hope for the best. That is how most people start selling on Etsy or at local craft fairs. It is also why most side hustles never turn into real businesses. If you want to hit $12,000 in monthly revenue, you have to stop guessing and start using a spreadsheet.

A candle maker in Oregon was working 40 hours a week on top of her day job. She was bringing in $4,000 a month but her bank account was always empty. When we looked at her numbers, she was paying herself roughly $4 an hour after materials and shipping. She wasn't running a business; she was paying for an expensive hobby. By switching to a structured pricing sheet, she cut her low-margin items and scaled her winners to hit five-figure months.

The Three Columns Your Spreadsheet Needs

You do not need a degree in accounting to build this. Open a blank Google Sheet or Excel file. You need three main sections: Materials, Labor, and Overhead.

1. The Materials List List every single physical item that goes into one unit. If you make leather wallets, this isn't just the leather. It is the thread, the glue, the sandpaper, and the box it ships in. Do not round down. If a spool of thread costs $10 and you use 1/10th of it, put $1.00 in that row.

2. The Labor Rate This is where most owners fail. You must pay yourself a fair wage. If you would have to pay an employee $20 an hour to do this work, your spreadsheet must reflect that. If it takes you 30 minutes to finish a product, your labor cost is $10. If you omit this, you are working for free.

3. The Overhead (The 'Invisible' Costs) Overhead includes your Etsy listing fees, your website subscription, and the electricity to run your sewing machine. A safe bet for a new solo business is to add 15% on top of your subtotal to cover these. This ensures that when the IRS self-employment tax bill comes due, you have the cash sitting in the bank to pay it.

What this means for you: If your spreadsheet shows a product costs $25 to make (time included) but you’re selling it for $30, you aren't making $5. You're likely losing money after fees and taxes.

Testing the 'Market Value' Trap

Once your spreadsheet spits out a "Total Cost," you usually multiply that by two to get your wholesale price, and by four to get your retail price.

Let’s say your cost is $10. Your retail price should be $40.

If you look at Etsy and everyone else is selling that same item for $15, you have a choice. You can find cheaper materials, work faster, or find a way to make your product worth $40. Most people try to drop their price to $15 to compete. This is a trap. You cannot scale a business to $12,000 a month on $2 margins. You would have to sell 6,000 units a month just to break even.

Instead, use the Value-Trap Framework to justify your higher price. A premium brand is easier to run than a bargain brand.

Why $12,000/Month Requires This Sheet

When you are making $500 a month, you can feel your way through the dark. When you scale to $12k, a small mistake becomes massive. If you underprice an item by just $2 and you sell 500 of them, you just lost $1,000. That’s your rent or your car payment gone because of a math error.

A print shop owner in Ohio realized they were losing money on every "Free Shipping" order because they hadn't updated their shipping weights in their pricing sheet. By adding a simple weight-check column to their spreadsheet, they saved $800 in their first month.

What this means for you: Your pricing sheet is a living document. Open it once a month and check if your material costs have gone up. If your wood supplier raises prices by 10%, your retail price needs to move too.

Moving From Side Hustle to Full-Time

If your goal is to quit your job, your pricing must support your life. You can calculate your quit-date runway using your spreadsheet profits. If your sheet shows you take home $40 in clean profit per unit, and you need $4,000 a month to live, you know exactly what your sales target is: 100 units.

This clarity kills the anxiety of starting a business. You aren't guessing if you'll be okay; you’re looking at a math problem that has already been solved. Build the sheet today, plug in your real numbers, and see if your side hustle is actually a business yet.

Every profitable business is built on a spreadsheet. Yours should be too.

Related free tool

Break-Even Calculator — Find the number of customers you need to stop losing money. Free, no signup to start.


📋 Disclaimer

This article is for informational purposes only and does not constitute legal, tax, financial, or professional advice. Laws and regulations change frequently, and the information presented may not reflect the most current legal developments. Always consult with a qualified professional (CPA, attorney, financial advisor) before making business decisions based on this content. MyBizNerd may receive compensation through affiliate links, but this never influences our recommendations.