Cost Of Goods Sold Spreadsheet

Inventory Cost & Pricing spreadsheet

$43.00

Description

Stop “just guessing” when setting your prices. Take control of your costs. Get organized. Increase your profits. Know your stuff.

The inventory costing and pricing process for a creative business with physical products can be time-consuming and stressful.

It takes time to sort, enter, and track all those materials & supplies you buy. It takes energy to determine how much of your supplies went into making each product you create. It is stressful to figure out how to correctly price your products to ensure a profit. Are you basing your prices on a proven formula, or are you just guessing at it?

It feels overwhelming to list and track all that inventory you make. What’s still out there for sale and what have I already sold? It takes research and time-consuming Googling to figure out how to calculate the numbers you need for your tax return.

Knowing just how much your products cost you to create and how much you should sell them for are two huge MUST DO’S for any creative biz owner that’s serious about building a profitable, sustainable business.

That’s exactly what the Inventory Cost & Pricing spreadsheet does for you – it takes the guesswork out of costing and pricing your goods.

What does the spreadsheet do?

A lot! This powerful tool will assist you with the following business tasks when it comes to handling your supplies & finished goods:

  • Keep you organized by logging your raw materials & supply expenses
  • Determine how much each finished item cost you to create to ensure accurate pricing for profit
  • Calculate your suggested overhead rate, an important {and often forgotten} component of your pricing formula
  • Calculate a wholesale and retail price, based on a formula that you have the flexibility to adjust
  • Automatically generate an inventory list of finished goods available for sale
  • Compute your sales and cost of goods sold on a monthly basis
  • Take the stress out of your taxes by making your year-end inventory count much less painful and more streamlined
  • Help you calculate purchases and ending inventory for your Schedule C
  • Provide you with the right financial data to determine if you’re making a profit, help you make educated business decisions, and set goals for the future

New updates make dealing with inventory on your tax return even easier.

Based on user feedback after selling hundreds of copies, I’ve added more features to the spreadsheet to make it even more helpful at tax time. New supply quantity tracking helps streamline your year end inventory count, and you can use your spreadsheet to verify your ending inventory cost. The spreadsheet also summarizes your total inventoriable supply purchases for the year. Get peace of mind by having exactly what you need to fill out the inventory section on your business’ tax return.

THE BOTTOM LINE – With this tool, you can log your supplies, cost & price your finished goods, track your inventory and tally your sales & cost of goods – ALL IN ONE PLACE!

What’s included in your purchase?

  • An instantly downloadable & ready-to-go multi-tabbed spreadsheet file, openable in Excel, Numbers, or Google Sheets
  • A detailed PDF instruction guide, with screenshots and explanations of applicable accounting terms and concepts used
  • Series of video tutorials with step-by-step instructions on how to use your spreadsheet

Who is this spreadsheet for?

The Inventory Cost & Pricing spreadsheet works for both newbie and experience creative biz owners who create and sell physical products. Sellers with any level (or no level!) of experience using a spreadsheet can use this tool to grow their biz. Our instructional package includes written, photographic, and video step-by-step guides on how to get the most out of your purchase.

Read more about the Inventory Cost & Pricing spreadsheet, and get a video sneak peek here.

Got procrastination issues? Need some help staying committed to your new bookkeeping spreadsheet on a consistent basis? Join the Accounting Accountability Club.

Have questions about any of our spreadsheets? Not sure which tool best fits your needs? Check out the Spreadsheet Resource page for FAQs, videos, and more info.

Reviews

There are no reviews yet.

Be the first to review “Inventory Cost & Pricing spreadsheet”

Your email address will not be published. Required fields are marked *

You may also like…