COGS stands for Cost of goods sold.

It is the amount of money spent by a company on its labor, materials, and overheads to manufacture/purchase products of the goods that are sold to customers during the year.

For a Manufacturing unit:

The Cost of goods sold = Total cost of production + Opening stock of the Finished goods – Closing stock of the finished goods.

For a retailer/reseller:

The Cost of Goods Sold = Opening Stock + Purchase – Closing Stock

COGS is an important part of a Cost Sheet.

If you have any queries or questions, share them in comments below and I will be more than happy to help you.

Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Share
Published by
Shabbir Bhimani

Recent Posts

Download UK VAT Taxable Turnover Calculator Excel Template

To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…

4 years ago

Step By Step Guide TO UK VAT Registration Process

Every business has to register for VAT with HM Revenue and Customs if their VAT…

4 years ago

Download UK VAT Dual Currency Invoice Excel Template

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…

4 years ago

Download UK VAT Purchase Register Excel Template

We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…

4 years ago

Download UK VAT Sales Register Excel Template

We have created a simple and easy UK VAT Sales Register Excel Template with predefined…

4 years ago

Download UK VAT Progress Billing Invoice Excel Template

We have created a ready to use UK VAT Progress Billing Invoice template in excel…

4 years ago