All calculators

Cost of Goods Sold Calculator

Calculate cost of goods sold from the client’s opening stock, purchases and closing stock.

Trading-period balances

Use the opening value for this trading period.

After returns, discounts and rebates.

Only costs excluded from net purchases.

Use the approved closing valuation for the same period.

Cost of goods sold

$127,500

Opening stock plus net purchases and extra costs, less closing stock.

Opening plus costs less closing

Opening stock
$38,750.00
Plus net purchases
$126,400.00
Plus extra acquisition costs
$4,650.00
Less closing stock
$42,300.00

Use one entity, period and GST basis. Stock values and adjustments remain your responsibility. Entries stay on this device.

The COGS Formula

Cost of goods sold (COGS) is opening stock plus net purchases and extra acquisition costs, less closing stock. This trading-stock reconciliation calculates the period’s cost from your entered balances.

Net purchases means purchases after returns, discounts and rebates. Enter freight inward or another acquisition cost separately only when purchases exclude it. Count each adjustment once.

The fictional example opens with stock of $38,750. Net purchases of $126,400 and extra acquisition costs of $4,650 bring goods available to $169,800. Less closing stock of $42,300 gives cost of goods sold of $127,500.

Suppose gross purchases are $131,900 and purchase returns are $5,500. Net purchases are $126,400. With opening supplier payables of $18,200 and closing payables of $24,600, cash paid is $120,000, assuming no other movements.

Entering that $120,000 payment as purchases would understate this example’s cost of goods sold by $6,400. Supplier payments settle liabilities; purchases record the goods acquired for the period.

Use Matching Stock Values

Use one entity and trading period. Opening stock must reconcile to the previous closing balance. Apply the chosen reporting basis consistently and keep recoverable GST out of inventory costs.

AASB 102 inventory guidance measures ordinary inventory at the lower of cost and net realisable value. Net realisable value deducts completion and selling costs from expected selling proceeds.

A $2,000 reduction in entered closing stock increases this reconciliation by $2,000. If you enter stock after a write-down, avoid adding the same expense again. The accountant decides its presentation and any tax adjustment.

A missing stock count leaves the closing input unsupported. Obtain a count or an accountant-approved reconstruction, including cut-off adjustments. Entering zero tells the calculator that no closing stock value remains.

Financial-reporting values and tax values can differ. The ATO’s business stock instructions explain the tax-return treatment, including simplified trading-stock rules. This calculator chooses neither a valuation policy nor a tax concession.

Production and Other Cost Records

This tool reconciles purchased trading stock. Manufacturing needs a separate production workpaper for raw materials, work in progress and finished goods. AASB 102 includes conversion costs, with direct labour and allocated production overheads.

Reconcile production transfers before entering a finished-goods balance. Putting all wages into extra acquisition costs can overstate stock costs and duplicate amounts already included in finished goods.

Service businesses need their own direct-cost classification. The broader label cost of sales can include service costs. This four-field stock calculation cannot allocate service labour or determine contract work in progress.

Understand and Calculate Cost of Goods Sold

Cost of goods sold is the inventory cost charged against the period’s sales. Unsold closing stock remains an asset on the chosen valuation basis. Operating expenses, such as general administration and selling costs, sit outside this stock reconciliation.

Gross profit is sales less cost of goods sold. Fictional sales of $210,000 less the example’s $127,500 give gross profit of $82,500, before other operating expenses.

A negative result means entered closing stock exceeds opening stock plus entered costs. The calculator keeps that difference visible. Reconcile omitted purchases, stock valuation and cut-off entries before carrying the amount into the accounts.

Negative net purchases trigger a separate warning because credits or returns exceed purchases. Confirm the underlying entries and their period. A warning identifies a reconciliation question; it does not automatically change the amount.

Give the accountant the stock valuation workpaper and purchase reconciliation with the result. Keep any further journal or tax adjustments separate so the same cost enters the accounts once.