Skip to main content

Average Costing

The most commonly used costing method - calculates cost as weighted average of all purchases.


How Average Costing Works

Average Cost Calculation
─────────────────────────────────────────────────────────────────

Average Cost = Total Inventory Value / Total Quantity

After each receipt:
New Average = (Old Value + Receipt Value) / (Old Qty + Receipt Qty)

Example:
Starting: 100 units @ $10 = $1,000
Receipt: 50 units @ $14 = $700
─────────────────────────────────────
New: 150 units @ $11.33 = $1,700

Average Cost = $1,700 / 150 = $11.33

Cost Flow Diagram

Average Costing Flow
─────────────────────────────────────────────────────────────────

Receipt #1: 100 @ $10 Receipt #2: 50 @ $14
│ │
▼ ▼
┌─────────────────────────────────────────────┐
│ INVENTORY POOL │
│ │
│ 150 units @ $11.33 average │
│ Total value: $1,700 │
│ │
└─────────────────────────────────────────────┘

│ Sale: 75 units

COGS: 75 @ $11.33 = $850

Remaining: 75 units @ $11.33 = $850

Transaction Examples

Purchase Receipt

Purchase Receipt Example
─────────────────────────────────────────────────────────────────

Before Receipt:
On Hand: 100 units
Average Cost: $10.00
Total Value: $1,000

Receipt: 50 units @ $14.00 = $700

After Receipt:
On Hand: 150 units
New Average: ($1,000 + $700) / 150 = $11.33
Total Value: $1,700

GL Impact (Purchase)

AccountDebitCreditWhy?
Inventory Asset$700Add at purchase price (Asset ↑)
IRNB (or A/P)$700Liability for receipt

Note: No variance - inventory records at actual purchase price.

Sale

Sale Example
─────────────────────────────────────────────────────────────────

Before Sale:
On Hand: 150 units
Average Cost: $11.33
Total Value: $1,700

Sale: 75 units @ $11.33 average = $850

After Sale:
On Hand: 75 units
Average Cost: $11.33 (unchanged)
Total Value: $850

GL Impact (Sale)

AccountDebitCreditWhy?
COGS$850Cost of goods sold at average (Expense ↑)
Inventory Asset$850Reduce at average cost (Asset ↓)

Average Cost Recalculation

Average cost changes only on receipts, not sales:

Average Cost Timeline
─────────────────────────────────────────────────────────────────

Event Qty Cost Value Avg Cost
─────────────────────────────────────────────────
Starting 100 $10.00 $1,000 $10.00
Receipt +50 50 $14.00 $700 ─────
After Receipt 150 $1,700 $11.33 ← Recalculated
Sale -75 -75 $11.33 -$850 ─────
After Sale 75 $850 $11.33 ← Same
Receipt +100 100 $8.00 $800 ─────
After Receipt 175 $1,650 $9.43 ← Recalculated

Adjustments and Transfers

Inventory Adjustment

Adjustment Impact on Average Cost
─────────────────────────────────────────────────────────────────

Adjustment Increase (found inventory):
- Adds quantity at CURRENT average cost
- Average cost UNCHANGED

Adjustment Decrease (lost inventory):
- Removes quantity at current average cost
- Average cost UNCHANGED

Example:
Before: 100 units @ $10 = $1,000
Adjustment: +20 units (found)
After: 120 units @ $10 = $1,200
(Average stays $10 - adds at current average)

Inventory Transfer

Transfer Impact on Average Cost
─────────────────────────────────────────────────────────────────

Transfer between locations:
- Uses current average cost
- No cost change at either location
- Just moves quantity

Example:
Location A: 100 units @ $10
Transfer 50 to Location B

After:
Location A: 50 units @ $10 = $500
Location B: 50 units @ $10 = $500

Advantages and Disadvantages

Advantages

AdvantageDescription
SimpleEasy to understand and calculate
SmoothEvens out price fluctuations
No layersDon't need to track purchase batches
Matches cash flowCost approximates actual spending

Disadvantages

DisadvantageDescription
Not specificCan't trace actual cost
Requires recalcMust recalculate on each receipt
Inflation lagSlower to reflect current costs
Complex returnsReturns affect average calculation

Returns and Average Cost

Customer Returns

Customer Return Impact
─────────────────────────────────────────────────────────────────

Return adds inventory at CURRENT average cost (not original cost)

Before Return:
On Hand: 75 units @ $11.33 = $850

Customer Returns: 10 units

After Return:
On Hand: 85 units @ $11.33 = $963
(Returns added at current average)

Vendor Returns

Vendor Return Impact
─────────────────────────────────────────────────────────────────

Return removes inventory at CURRENT average cost

Before Return:
On Hand: 150 units @ $11.33 = $1,700

Return to Vendor: 20 units

After Return:
On Hand: 130 units @ $11.33 = $1,473
(Removed at current average)

Best Practices

PracticeBenefit
Regular receiptsKeeps average current
Avoid manual cost changesMaintains integrity
Monitor cost trendsCatch unusual fluctuations
Reconcile regularlyEnsure accuracy

Quick Reference

When Average Changes

EventAverage Cost Changes?
Purchase ReceiptYes - recalculates
Vendor BillNo (cost set at receipt)
SaleNo
Adjustment (qty only)No
Adjustment (with cost)Yes
TransferNo
Customer ReturnNo
Vendor ReturnNo

Next Steps