Cost of Goods Sold (COGS) Calculator

Know the real cost behind every sale in seconds. Enter three numbers-Beginning Inventory, Purchases, Ending Inventory-and the calculator reveals your COGS instantly. No spreadsheets, no guesswork.

QuickBooks logo
Xero logo
Wagepoint logo
Trustpilot logo
Google logo
Clutch logo
The Globe and Mail logo
GoodFirms logo
CPA Canada logo
Hubdoc logo
Ownr logo
Stripe logo

Cost of Goods Sold Calculator

Goods Available

$55,000.00

Cost of Goods Sold

$43,000.00

Ending Inventory

$12,000.00

COGS Ratio

78.18%

Inputs

78%COGS Ratio

Goods Available

$55,000.00

Cost of Goods Sold$43,000.0078%
Ending Inventory$12,000.0022%

Beginning

$15,000.00

+ Purchases

$40,000.00

− Ending

$12,000.00

COGS = Beginning Inventory + Purchases − Ending Inventory. Confirm final figures with your records and inventory method (FIFO or weighted average).

How the Cost of Goods Sold Calculator Works

Open Inventory ($)

The value of all stock on hand at the start of the period.

Where to Find It

Last period's closing inventory figure (from your balance sheet).

Purchases ($)

Total cost of raw materials or finished goods bought during the period.

Where to Find It

Supplier invoices plus freight-in and duties.

Closing Inventory ($)

The value of stock still on hand at period-end.

Where to Find It

Latest physical count or POS/ERP report.

The tool applies the standard cost of goods sold formula:

COGS = Opening Inventory + Purchases − Closing Inventory

The answer appears instantly, along with a simple chart that compares COGS to revenue so you can spot margin squeeze at a glance.

Why COGS Matters

Cost of goods sold drives your gross profit, your tax bill, and your pricing decisions. Tracking it accurately keeps every downstream number honest.

Tax savings

COGS is a tax-deductible expense. Recording it right lowers your taxable profit.

True profit picture

Subtract COGS from revenue to see gross profit. If margins look thin, you know where to act fast.

Pricing insight

Rising COGS without a matching price-rise signals shrinking margins.

What Counts in COGS

Exclude
  • Sales & marketing spend
  • Office rent & utilities
  • R&D costs
  • Customer shipping (post-sale)
Include
  • Raw materials & ingredients
  • Direct labour tied to production
  • Freight-in, import duties
  • Factory overhead (if using absorption costing)

COGS = Opening Inventory + Purchases − Closing Inventory

Example Calculation

Scenario: A coffee roaster starts the quarter with $15,000 of green beans on hand. They buy another $40,000 during the quarter and finish with $12,000 left.

  • COGS = 15,000 + 40,000 − 12,000 = $43,000

  • If sales were $75,000, gross profit equals $32,000 and gross margin is 42.7%.

Scenario Snapshot

Opening Inv.

$15,000

Purchases

$40,000

COGS

$43,000

Gross Margin

42.7%

Adjust the inputs in the calculator above to model your own COGS scenarios in seconds.

How to Use Your COGS Result

Compare against budget

Compare against budget

Are you overspending on inputs?

Benchmark your industry

Benchmark your industry

Search “average COGS in ___ sector” to gauge efficiency.

Adjust reorder points

Adjust reorder points

High closing inventory? Reduce next purchase to free cash.

Refine pricing

Refine pricing

Feed COGS into your markup targets to protect margins.

Five Ways to Lower COGS

Tip 01

Negotiate supplier rates

Even 2% off materials lifts margins.

01
Tip 02

Buy in economic order quantities

Reduces carry costs.

02
Tip 03

Track waste

Small scraps add up fast.

03
Tip 04

Automate stock counts

Less human error, tighter numbers.

04
Tip 05

Review pricing quarterly

Pass unavoidable cost hikes to the market promptly.

05

Keep Your Margins Sharp All Year

A clean COGS number starts with clean books. Our team helps Canadian businesses track inventory, time purchasing, and protect gross margins month after month.

Frequently Asked Questions

Latest Blogs

Other Featured Posts