{"id":7463,"date":"2026-01-20T16:15:02","date_gmt":"2026-01-20T09:15:02","guid":{"rendered":"https:\/\/www.sterling-team.com\/news\/?p=7463"},"modified":"2026-04-10T15:42:59","modified_gmt":"2026-04-10T08:42:59","slug":"cogs-guide-how-to-calculate-cost-of-goods-sold","status":"publish","type":"post","link":"https:\/\/www.sterling-team.com\/news\/en\/cogs-guide-how-to-calculate-cost-of-goods-sold\/","title":{"rendered":"How to Accurately Calculate COGS: Formulas &#038; Examples"},"content":{"rendered":"<p>In managing a business, understanding financial health begins with one critical figure: <strong>Cost of Goods Sold (COGS)<\/strong>. Many first-time entrepreneurs fall into the trap of setting selling prices solely based on market rates, without truly understanding <strong>how to calculate COGS<\/strong> accurately.<\/p>\n<p>As a result, even when sales figures appear impressive, net profits may be negligible\u2014or worse, the business may operate at a loss.<\/p>\n<p>This article provides a comprehensive breakdown of the concept of COGS, its core components, and the technical steps required to calculate it properly, ensuring your business is built on a solid financial foundation.<\/p>\n    <nav class=\"toc-container\" aria-label=\"Table of Contents\">\n        <div class=\"toc-header\" onclick=\"toggleTOC()\">Table of Content<\/div>\n        <div class=\"toc-list\" id=\"toc-list\" style=\"display:block\">\n            <ul id=\"toc-items\"><\/ul>\n        <\/div>\n    <\/nav>\n    <div id=\"toc-schema\"><\/div>\n    \n<h2><strong>What Is COGS (Cost of Goods Sold)?<\/strong><\/h2>\n<p><strong>COGS<\/strong>, in simple terms, represents the total direct costs incurred by a company to produce the goods or services sold during a specific accounting period. In international accounting terminology, this is known as <em>Cost of Goods Sold<\/em> (COGS).<\/p>\n<p>COGS is far more than just a line item in the income statement. Understanding how to calculate it accurately is essential because:<\/p>\n<ul>\n<li><strong>Pricing Strategy:<\/strong> You cannot define a sustainable profit margin without knowing your true cost base.<\/li>\n<li><strong>Operational Efficiency:<\/strong> If your COGS is disproportionately high compared to industry benchmarks, it signals inefficiencies within your production process.<\/li>\n<li><strong>Tax Accuracy:<\/strong> COGS directly reduces gross revenue to determine taxable income.<\/li>\n<\/ul>\n<h2><strong>Core Components of the COGS Formula<\/strong><\/h2>\n<p>Before working with numbers, it is crucial to understand which elements are included in <strong>COGS in accounting<\/strong>. Generally, there are three primary components:<\/p>\n<h3><strong>1. Raw Material Costs<\/strong><\/h3>\n<p>These are the fundamental costs of all materials used to create a product. For example, if you sell bread, flour, eggs, and sugar constitute your raw material costs.<\/p>\n<h3><strong>2. Direct Labor Costs<\/strong><\/h3>\n<p>This category includes wages paid to employees directly involved in the production process. Administrative staff salaries are excluded; instead, this covers machine operators, technicians, or chefs.<\/p>\n<h3><strong>3. Manufacturing Overhead<\/strong><\/h3>\n<p>Overhead refers to indirect costs that support production activities, such as factory electricity, machine depreciation, or equipment maintenance expenses.<\/p>\n<table style=\"width: 100%; border-collapse: collapse; border: 1px solid #ddd;\">\n<thead>\n<tr style=\"background-color: #f2f2f2;\">\n<th style=\"padding: 10px; border: 1px solid #ddd;\">COGS Component<\/th>\n<th style=\"padding: 10px; border: 1px solid #ddd;\">Cost Examples<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Raw Materials<\/strong><\/td>\n<td style=\"padding: 10px; border: 1px solid #ddd;\">Wood (furniture), Fabric (garment manufacturing)<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Direct Labor<\/strong><\/td>\n<td style=\"padding: 10px; border: 1px solid #ddd;\">Tailors, Assembly line operators<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Overhead<\/strong><\/td>\n<td style=\"padding: 10px; border: 1px solid #ddd;\">Factory rent, Machine electricity, <em>Packaging<\/em> costs<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><strong>The Basic Formula for Calculating COGS<\/strong><\/h2>\n<p>For trading companies, the <strong>COGS formula<\/strong> is relatively straightforward, as there is no transformation of raw materials into finished goods. The standard formula is:<\/p>\n<p><strong>COGS = (Beginning Inventory + Net Purchases) \u2013 Ending Inventory<\/strong><\/p>\n<h3><strong>Variable Explanation:<\/strong><\/h3>\n<ul>\n<li><strong>Beginning Inventory:<\/strong> The value of inventory on hand at the start of the accounting period (month or year).<\/li>\n<li><strong>Net Purchases:<\/strong> Total merchandise purchases plus freight-in costs, minus purchase returns and discounts.<\/li>\n<li><strong>Ending Inventory:<\/strong> The value of inventory remaining in storage at the end of the period.<\/li>\n<\/ul>\n<h2>Step-by-Step Guide to Calculating COGS<\/h2>\n<p>To avoid critical errors in your financial statements, follow this structured <strong>COGS calculation<\/strong> process:<\/p>\n<ol class=\"howto-steps\">\n<li>\n<h3>Calculate Net Sales:<\/h3>\n<p>Total sales minus returns and discounts.<\/p><\/li>\n<li>\n<h3>Determine Beginning Inventory:<\/h3>\n<p>Refer to the balance sheet from the previous period.<\/p><\/li>\n<li>\n<h3>Aggregate Purchases During the Period:<\/h3>\n<p>Include all purchase invoices for the current month or year.<\/p><\/li>\n<li>\n<h3>Adjust for Freight and Discounts:<\/h3>\n<p>Add shipping costs and subtract supplier discounts.<\/p><\/li>\n<li>\n<h3>Conduct a Physical Stock Count:<\/h3>\n<p>Perform a <em>stock opname<\/em> to determine ending inventory.<\/p><\/li>\n<li>\n<h3>Apply the COGS Formula:<\/h3>\n<p>Insert the figures into the main COGS equation.<\/p><\/li>\n<\/ol>\n<h2><strong>COGS Calculation Example: A Practical Case<\/strong><\/h2>\n<h3><strong>1. Trading Company Example<\/strong><\/h3>\n<p>\u201cLangkah Maju\u201d Shoe Store reports the following data for January:<\/p>\n<ul>\n<li>Beginning Inventory: IDR 50,000,000<\/li>\n<li>January Purchases: IDR 100,000,000<\/li>\n<li>Freight-in Costs: IDR 2,000,000<\/li>\n<li>Ending Inventory: IDR 30,000,000<\/li>\n<\/ul>\n<p><strong>Calculation:<\/strong><\/p>\n<ul>\n<li>Net Purchases = IDR 100,000,000 + IDR 2,000,000 = IDR 102,000,000<\/li>\n<li>COGS = (IDR 50,000,000 + IDR 102,000,000) &#8211; IDR 30,000,000<\/li>\n<li><strong>COGS = IDR 122,000,000<\/strong><\/li>\n<\/ul>\n<h3><strong>2. Manufacturing Company Example<\/strong><\/h3>\n<p>In manufacturing, you must first calculate the Cost of Production (raw materials + direct labor + overhead). If total production costs amount to IDR 200 million, with beginning finished goods inventory of IDR 20 million and ending inventory of IDR 10 million, the resulting COGS is IDR 210 million.<\/p>\n<h2><strong>How to Calculate COGS in Excel \/ Google Sheets<\/strong><\/h2>\n<p>Many business owners seek <strong>Excel-based COGS calculation examples<\/strong> for automation. Below is a simple template setup:<\/p>\n<ol>\n<li>Create Column A for Account Names and Column B for Monetary Values.<\/li>\n<li>Cell B1: Enter Beginning Inventory.<\/li>\n<li>Cell B2: Enter Total Purchases.<\/li>\n<li>Cell B3: Enter Freight-in Costs.<\/li>\n<li>Cell B4: Enter Returns\/Discounts (as negative values).<\/li>\n<li>Cell B5 (Net Purchases): Use the formula <code>=SUM(B2:B4)<\/code>.<\/li>\n<li>Cell B6: Enter Ending Inventory.<\/li>\n<li>Cell B7 (COGS): Use the formula <code>=(B1+B5)-B6<\/code>.<\/li>\n<\/ol>\n<p>With this template, you only need to update the figures monthly to obtain instant results.<\/p>\n<h2><strong>How COGS Impacts Net Profit<\/strong><\/h2>\n<p>COGS is the first deduction from revenue. The relationship can be summarized as follows:<\/p>\n<ul>\n<li><strong>Gross Profit = Sales \u2013 COGS<\/strong><\/li>\n<li><strong>Net Profit = Gross Profit \u2013 Operating Expenses (office salaries, marketing, etc.)<\/strong><\/li>\n<\/ul>\n<p>When you successfully reduce COGS\u2014for instance, by sourcing more cost-effective yet high-quality suppliers\u2014your Gross Profit automatically increases. This is why <strong>the impact of COGS on profitability<\/strong> is a critical concern for financial managers. Uncontrolled COGS will erode your margins long before operating expenses are even addressed.<\/p>\n<h2>FAQ<\/h2>\n<h3>What is the difference between COGS and overhead costs?<\/h3>\n<p>COGS represents the total cost (including overhead) associated with producing goods that are <em>sold<\/em>. Overhead costs are one component of COGS and consist of indirect expenses such as electricity or facility maintenance.<\/p>\n<h3>How is COGS calculated for service-based businesses?<\/h3>\n<p>Service companies do not hold physical inventory, so they typically use the term \u201cCost of Services.\u201d The calculation focuses primarily on professional labor costs and tools used to deliver the service.<\/p>\n<h3>When should COGS be updated in financial statements?<\/h3>\n<p>COGS must be updated each time an income statement is prepared\u2014commonly on a monthly, quarterly, or annual basis.<\/p>\n<h3>Why is ending inventory subtracted in the COGS formula?<\/h3>\n<p>Because unsold inventory has not yet generated revenue, its cost should not be recognized as an expense in the current period. Instead, it becomes beginning inventory for the next period.<\/p>\n<h2><strong>Conclusion: Optimizing COGS for a More Sustainable Business<\/strong><\/h2>\n<p>Mastering <strong>how to calculate COGS<\/strong> is the first step toward effective financial management. With accurate COGS figures, you can set competitive pricing strategies, manage inventory efficiently, and ensure that reported profits are genuinely realized.<\/p>\n<p>However, manually calculating COGS in Excel is often prone to <em>human error<\/em>, especially for businesses with thousands of SKUs or complex production workflows. For real-time, automated accuracy, adopting an ERP (Enterprise Resource Planning) system is the most reliable solution.<\/p>\n<h3><strong>Optimize Your COGS Calculation with SAP Business One<\/strong><\/h3>\n<p>Do not let COGS miscalculations hinder your business growth. <strong>SAP Business One<\/strong> from <strong>PT Sterling Tulus Cemerlang (STEM)<\/strong> delivers an intelligent solution to automate your accounting and manufacturing processes.<\/p>\n<p>With SAP Business One, you can:<\/p>\n<ul>\n<li>Automatically and accurately calculate COGS (FIFO, Moving Average, or Standard Costing).<\/li>\n<li>Integrate warehouse inventory data with financial reports in <em>real time<\/em>.<\/li>\n<li>Monitor profit margins per product with a single click.<\/li>\n<\/ul>\n<p>Ready to elevate your business with greater financial transparency?<br \/>\n&#x1f449; <a href=\"https:\/\/www.sterling-team.com\" target=\"_blank\" rel=\"noopener\"><strong>Contact PT Sterling Tulus Cemerlang today for a Free Consultation &amp; SAP Business One Demo!<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.sterling-team.com\/sap-business-one\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1344\" title=\"What is SAP Business One?\" src=\"https:\/\/www.sterling-team.com\/news\/wp-content\/uploads\/2020\/05\/banner-sap-indonesia-cta-en.jpg\" alt=\"What is SAP Business One?\" width=\"600\" height=\"150\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In managing a business, understanding financial health begins with one critical figure: Cost of Goods Sold (COGS). Many first-time entrepreneurs&hellip;<\/p>\n","protected":false},"author":1,"featured_media":7464,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[392],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/7463"}],"collection":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/comments?post=7463"}],"version-history":[{"count":12,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/7463\/revisions"}],"predecessor-version":[{"id":9228,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/7463\/revisions\/9228"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/media\/7464"}],"wp:attachment":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/media?parent=7463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/categories?post=7463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/tags?post=7463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}