Free Cost of Goods Sold Calculator

Our easy-to-use COGS calculator will have your monthly AND annual COGS tallied up in just minutes and ready to be plugged into your accounting.

Free Cost of Goods Sold Calculator

Learn how to calculate your COGS using our free-to-download cost of goods sold calculator! You can follow right along with the same template used in this video! Our excel COGS template will automatically calculate your COGS using our COGS formula.

Calculate Cost of Goods Sold in Minutes

Our template takes the cost of goods sold equation and automatically calculates your COGS for you

Our easy-to-use COGS calculator will have your monthly AND annual COGS tallied up in just minutes and ready to be plugged into your accounting.

How do I calculate the cost of goods sold?  

The calculation for cost of goods sold is starting inventory + purchases − ending inventory = cost of goods sold.  For example, at the beginning of each month you should calculate your starting inventory amount and at the end of the month calculate your ending inventory amount.  Add your inventory purchases for the month to your starting inventory and subtract your ending inventory amount to determine your cost of goods sold (COGS).

What is COGS?  

COGS stands for Cost of Goods Sold.

What should be included in COGS?

COGS should include the direct material expenses and direct labor expenses to produce your product or service.

What is an example of the cost of goods sold?  

An example of cost of goods sold would be the cost of food and ingredients at a restaurant as well as the labor cost for the cooks preparing the food.

Which expenses are included in the cost of goods sold?  

All direct materials and direct labor costs involved in producing your product or service should be included in your cost of goods sold.

Get the Template!

Check out our Highly Rated Financial Projection Templates

★★★★★
I recently used ProjectionHub for my business projections and was thoroughly impressed by the service I received. As a disabled veteran, I often need a bit of extra support, and Adam, the owner, went above and beyond to provide just that. He was incredibly quick to respond to my questions and personally assisted me in filling out my projections as well as provided a video of him walking thru the process. Adam's commitment to customer service is unparalleled. His expertise and willingness to help made the entire process smooth and stress-free. I highly recommend ProjectionHub to anyone in need of professional, reliable, and personalized financial projection services. Thank you, Adam, for your outstanding support and dedication!
Edward Mantanona
Microsoft
★★★★★
The template I used was GREAT! I wasn't sure how it would be for the money, but the value for my purchase was extremely worth it. I spent forever looking for suitable templates online, and nothing held a candle to the level of detail and ease of use of this template. I actually contacted Adam at ProjectionHub for help deciding on which template I needed because there were so many options and my client wanted to do something kind of unique, and Adam got back to me very quickly and offered to help me make any adjustments to the template to better fit my client's needs. My client was blown away by the impressive detail and I looked like a pro thanks to this template. I will be buying more in the future for all of my projection needs!
Ren Jett
Bright Road Financial Services