Cost Of Goods Sold Excel Templates

Cost of goods sold is typically based on beginning inventory plus purchases and related costs minus ending inventory, subject to the chosen accounting method. Keep direct product costs separate from general overhead.

Editable downloads and previews

Download the editable Excel workbook

Private, non-commercial use. Download help and usage terms.

Download Cost of goods sold reconciliation (.xlsx)

Open in Microsoft Excel. Replace the fictional example data in the highlighted input cells; keep formula cells intact so the summaries update.

Cost of goods sold reconciliation — Excel workbook preview — Cost of goods sold reconciliation: preview of the editable Excel workbook.

More template previews and sources

Use the file links where provided. Links labeled “View original source” open another website; check its current format, availability and terms. A preview image alone is not an editable document.

Template previews and source links

Bonus template: Cost of goods sold reconciliation worksheet

Use this simplified merchandise example to reconcile the inventory figures behind a cost-of-goods-sold calculation. Record amounts at cost, using a consistent method.

Set up the record

Business / period: [details]
Currency: [currency]
Inventory method and reviewer: [details]

Illustrative entries: copy the layout and replace these examples.
Component	Illustrative amount
Beginning inventory	5,000.00
Net purchases and included acquisition costs	12,000.00
Goods available for sale	17,000.00
Less ending inventory	4,000.00
Cost of goods sold	13,000.00

How to use this template

Reconcile opening inventory to the previous period’s closing record.
Document purchases, returns and other included costs without adding the same cost twice.
Support ending inventory with the appropriate count and valuation records. Manufacturing and tax reporting can require additional treatment.

Worked example: 5,000.00 plus 12,000.00 minus 4,000.00 gives 13,000.00. Selling prices are not substituted for inventory cost in this illustration.

Check before use

Use the same reporting period.
Keep general operating expenses separate from the inventory reconciliation.
Confirm the method used for actual financial or tax reporting.

Reference: IRS Publication 334, cost-of-goods-sold guidance for U.S. businesses.

Calculate cost of goods sold with a consistent inventory method

Worked example: If beginning inventory is $8,000, eligible purchases are $20,000, and ending inventory is $6,000, the simplified COGS is $22,000. The calculation changes if purchase returns, freight or work in progress require separate treatment.

Check before use: State the period, valuation method and source of inventory counts. Check tax and financial-reporting requirements before treating a sample spreadsheet as official accounts.

What’s Included in the Cost of Goods Sold Template

Beginning inventory field: Space to record the value of inventory at the start of the period.
Purchases or production costs: A field for tracking additional inventory acquired or produced during the period.
Ending inventory field: Space to record the value of inventory remaining at the end of the period.
Built-in COGS formula: An automatic calculation that combines these figures into the final cost of goods sold.
Period or date fields: Space for identifying the specific reporting period the calculation covers.
Notes section: An area for additional details about specific cost categories or adjustments.

How to Start Using the Template in 3 Simple Steps

Step 1 — Choose a template style: Browse the the options below and select the format that best fits your business.
Step 2 — Enter your inventory and cost figures: Fill in beginning inventory, purchases, and ending inventory.
Step 3 — Review the calculated result: Check the automatically calculated COGS figure and use it in your financial statements.

Cost of Goods Sold vs. Operating Expenses

While both figures reduce a company’s overall profit, cost of goods sold and operating expenses represent different types of costs. Cost of goods sold covers the direct costs of producing or acquiring the specific goods a company sells, such as materials and direct labor. Operating expenses, by contrast, cover the broader costs of running the business that aren’t tied directly to production, such as rent, utilities, and administrative salaries. Separating these two categories correctly is important because COGS is subtracted from revenue to calculate gross profit, while operating expenses are subtracted later to calculate net income.

How COGS Affects Gross Profit and Pricing

Cost of goods sold directly determines a company’s gross profit, since gross profit is calculated by subtracting COGS from total revenue. A business with a high COGS relative to its revenue has a thinner gross margin, which can limit how much is available to cover operating expenses and generate net profit. Understanding this relationship helps business owners set prices that adequately cover production costs while still leaving room for a healthy profit margin, and it makes COGS one of the most closely watched figures when evaluating a product line’s overall profitability.

Calculating COGS for Service-Based Businesses

While cost of goods sold is most commonly associated with businesses that sell physical products, some service-based businesses calculate a similar figure known as cost of services or cost of revenue. This figure typically includes direct labor and materials tied to delivering the service, such as a consultant’s billable hours or the supplies used in providing a service. Although the underlying formula differs slightly from a traditional product-based COGS calculation, the same principle of separating direct costs from general overhead still applies, and many of these templates can be adapted for that purpose.

Using COGS in Inventory Management Decisions

Beyond its role in financial reporting, tracking cost of goods sold over time gives business owners valuable insight into inventory management and purchasing decisions. A rising COGS trend that isn’t matched by a corresponding increase in sales volume can signal supplier price increases, inefficient purchasing, or inventory shrinkage that deserves closer attention. Reviewing COGS alongside inventory turnover rates on a regular basis helps businesses identify slow-moving stock, negotiate better terms with suppliers, and make more informed decisions about how much inventory to keep on hand.

Preparing COGS Figures for Tax Filings

Cost of goods sold plays an important role in business tax filings, since an accurately calculated COGS figure directly reduces the taxable income reported by a business. Keeping detailed, well-organized records throughout the year, rather than trying to reconstruct figures at tax time, makes the filing process considerably smoother and reduces the risk of errors that could trigger questions from tax authorities. Many business owners find it helpful to reconcile their COGS template against their accounting software or tax preparer’s records before filing to confirm the figures match.

Choosing an Inventory Valuation Method

The method a business uses to value its inventory, such as FIFO (first-in, first-out), LIFO (last-in, first-out), or weighted average cost, directly affects the resulting cost of goods sold figure, especially during periods of fluctuating prices. FIFO typically results in a lower COGS and higher reported profit during periods of rising prices, since older, cheaper inventory is counted as sold first, while LIFO has the opposite effect. Choosing a valuation method usually depends on a combination of factors including industry norms, tax implications, and how closely inventory costs actually fluctuate, and most businesses stick with the same method consistently once selected to keep their financial reporting comparable across periods.

Comparing COGS Across Multiple Product Lines

Businesses that sell multiple products or product lines often benefit from calculating cost of goods sold separately for each category rather than relying on a single combined figure. Breaking down COGS by product line makes it much easier to identify which products carry the healthiest profit margins and which may be underpriced relative to their production costs. This level of detail can inform decisions about which products to promote more heavily, which to reprice, and which might no longer be worth carrying if their margins have become too thin to justify the shelf space or production effort involved.

Frequently Asked Questions

Are these cost of goods sold templates free to download?

Yes, the templates on this page are free to download and use.

What file format are these templates available in?

These templates are available in Excel format, making them easy to edit and customize with formulas.

Can I customize the fields on these templates?

Yes, since the templates are fully editable, you can add your own inventory categories, cost fields, and formulas.

What’s the difference between COGS and operating expenses?

COGS covers the direct costs of producing or acquiring goods sold, while operating expenses cover broader costs like rent and administrative salaries.