Standard vs Actual Costing in Business Central: The Complete Guide

Most companies don’t choose their costing method — they inherit it. Somebody set it up years ago, and now it’s just how things work. Until month-end close produces a purchase price variance that’s €40,000 in the wrong direction and suddenly everyone cares deeply about costing methodology.

Standard costing and actual costing (FIFO, Average, Specific, LIFO) serve fundamentally different purposes. Standard costing is a management control tool — it tells you when reality deviates from plan. Actual costing is a financial accuracy tool — it tells you what things actually cost. Pick the wrong one and you’ll spend years compensating with Excel workarounds.

This article is a cluster post supporting our complete Business Central costing methods guide, which covers all five methods in depth. Here, we focus on the standard vs actual decision: when to use each, how to set them up in Business Central, and how to read the variance reports that make standard costing either your best friend or your worst nightmare.

---

First: What Are We Actually Comparing?

The confusion starts with terminology. “Actual costing” isn’t one thing — it’s the family of methods that value inventory and COGS based on real transaction costs as they happen: FIFO, Average, Specific, and LIFO. When people say “actual costing,” they usually mean FIFO or Average — the two most common methods in production and distribution environments.

Standard costing is the outlier. Instead of valuing inventory at whatever you paid, you set a predetermined “standard” cost for each item. When you buy at a price different from the standard, the difference posts to variance accounts. When you produce at a cost different from standard, the difference posts to production variance accounts.

Here’s the core difference in one sentence: actual costing values inventory at what happened; standard costing values inventory at what should have happened, and tells you by how much reality differed.

---

A Concrete Example: Same Transaction, Two Methods

Let’s walk through the same purchasing scenario under both methods. You’re buying 100 units of Widget A. Your last purchase price was €10/unit. This time, the supplier charges €11/unit.

Under Average Costing (Actual)

The system recalculates your weighted average. If you had 200 units at €10 (€2,000 total value) and you buy 100 at €11 (€1,100), your new average is €3,100 / 300 = €10.33/unit. Future sales use €10.33. The price increase is absorbed into your inventory value and flows through COGS gradually as you sell. You don’t see a separate “someone paid more than last time” number anywhere — it’s just baked into your costs.

Under Standard Costing

You set the standard cost at €10/unit. The invoice arrives at €11. The system does three things:

1. Posts the inventory receipt at standard: 100 units × €10 = €1,000 to inventory
2. Posts the purchase price variance: 100 units × €1 = €100 to the Purchase Variance account
3. Your item card still shows a unit cost of €10 (the standard)

The variance of €100 lands immediately in your P&L. You see it. You can’t ignore it. If the variance is material, you investigate. That’s the point.

---

Standard Costing: The Setup

Standard costing in Business Central requires specific configuration on three levels: the item card, the standard cost worksheet, and the general posting setup. Here’s the step-by-step.

Step 1: Item Card

On the item card, the Costing Method field must be set to Standard. Once you set this and the item has ledger entries, you can’t change it without the write-off/create-new-item workaround.

The Unit Cost field on the item card is your standard cost. This is the cost the system uses for all valuations until you change it. Update it through the Standard Cost Worksheet — never directly on the card if you want clean audit trails.

The Standard Cost field (separate from Unit Cost on some card versions) is informational — it shows the active standard cost.

Step 2: Standard Cost Worksheet

The Standard Cost Worksheet is where you calculate and propose new standard costs. It’s found under: Inventory → Costing → Standard Cost Worksheet.

The worksheet works like other BC worksheets (Item Journal, Revaluation Journal):

1. Calculate Standard Cost: This function populates the worksheet lines based on your parameters. You can calculate from the item’s BOM (roll up material and capacity costs), from the last direct cost, or enter costs manually.
2. Suggested Standard Cost: The system proposes a new standard cost per item.
3. Implement Standard Cost Change: This batch job posts the changes. It creates revaluation entries that adjust inventory value from the old standard to the new standard, posting the difference to the Inventory Adjustment account.

Step 3: General Posting Setup

Variance accounts must be configured in the General Posting Setup and Inventory Posting Setup:

• Purchase Variance Account: Debited or credited when purchase prices differ from standard
• Material Variance Account: The difference between expected material consumption (per BOM) and actual consumption in production
• Capacity Variance Account: The difference between expected labour/machine time and actual time
• Subcontracting Variance Account: Variance on outsourced production operations
• Manufacturing Overhead Variance: Applied vs actual overhead

If these accounts aren’t configured, BC posts variances to the default inventory adjustment account — functionally correct but useless for analysis. You want separate variance accounts so your P&L shows which variances are happening, not just that they’re happening.

Step 4: Production BOM and Routing Setup

If you manufacture, standard cost flows through your BOMs and routings:

• Production BOM: Lists materials and quantities. The system multiplies each material’s standard cost by the quantity per to get the material cost component.
• Routing: Lists operations (labour, machine time) with setup time, run time, and cost per unit of time. The system calculates the capacity cost component.
• Total standard cost = material cost per + capacity cost per + subcontracting cost per + overhead per.

When you post a production order, the system calculates both expected cost (based on standard) and actual cost (based on real consumption and time postings). The difference between them posts to the variance accounts.

---

Actual Costing: How Setup Differs

Setting up actual costing (FIFO or Average) is simpler because there are fewer moving parts. No standard cost to maintain, no variance accounts to configure, no worksheet to run.

FIFO Setup

1. Set the item card Costing Method to FIFO
2. That’s basically it at the item level

The system now tracks every purchase receipt as a cost layer. When you sell:

• BC applies the oldest cost layer first
• If the sale exceeds the oldest layer, it applies the next oldest, and so on
• The Adjust Cost – Item Entries batch job recalculates COGS based on actual layer application

This is critical: under FIFO, your COGS isn’t final until the cost adjustment batch runs. If you post a sales shipment on the 15th and the matching purchase invoice doesn’t arrive until the 20th, the cost on the 15th is provisional. The adjustment batch corrects it when the invoice posts. Run this batch at least weekly, and always before month-end reporting.

Average Costing Setup

1. Set the Costing Method to Average
2. Set the Costing Period (Day, Week, Month, or custom) — this determines how often the average recalculates

Under Average, the system maintains a single weighted-average unit cost that recalculates every time a new purchase is posted within the active costing period. Sales use the current average. At period-end, the average is frozen.

The costing period matters enormously:

• Day: High precision, high recalculation overhead, lots of cost adjustment postings
• Month: Simpler administration, but any late purchase invoices posted to a closed period will retroactively recalculate that period’s average — and your financials from that period will have been based on provisional costs
• Custom (e.g., Quarter): Used when purchase prices are stable and you want minimal recalculations

---

Variance Analysis: How to Read Standard Costing Reports

The entire point of standard costing is variance analysis. If you’re running standard costing and not reviewing variances monthly, you’ve got the overhead of standard costing without the benefit.

Purchase Price Variance (PPV)

What it measures: The difference between what you planned to pay (standard cost) and what you actually paid (invoice cost).

How it appears: On the purchase invoice, BC posts the receipt at standard and the difference to the PPV account.

Good PPV: Negative variance (actual < standard) — you bought below standard. Your procurement team negotiated well or market prices dropped.

Bad PPV: Positive variance (actual > standard) — you paid more than planned. Either your standard is outdated (fix the standard), your supplier raised prices (renegotiate or accept it), or someone bought from the wrong supplier at the wrong price (fix the process).

What to watch for: A PPV that’s consistently positive and growing means your standards are stale — you’re understating inventory value and overstating COGS. A PPV that swings wildly month to month means your purchasing isn’t stable — either you have price volatility that standard costing isn’t suited for, or your purchasing process has control issues.

Material Usage Variance (MUV)

What it measures: The difference between the material quantity the BOM says you should have used and the quantity you actually consumed in production.

How to read it:

• Negative variance: You used less material than planned. Either production is more efficient than expected, or the BOM overestimates waste/scrap.
• Positive variance: You used more material than planned. Scrap, rework, or theft. Investigate immediately — material over-consumption gets expensive fast.

A common trap: material variance shows you used less than planned, and everyone celebrates. But it’s actually because the BOM was set up with inflated waste percentages that nobody ever corrected. You’re not saving material — you’re comparing against a wrong standard. Clean BOMs, clean variances.

Capacity (Labour/Overhead) Variance

What it measures: The difference between planned labour/machine time (per routing) and actual time, multiplied by the planned cost rate.

How to read it:

• Absorption: Positive variance (actual hours > planned). Higher-cost operations took longer than the routing estimated. Either the routing is optimistic, the workers are slower, or there were unexpected setup/changeover delays.
• Over-absorption: Negative variance (actual hours < planned). Operations ran faster than estimated. Great news — but update the routing so future production orders have accurate cost forecasts.

Production Variance Summary

A monthly production variance report should answer three questions:

1. Are my BOMs and routings accurate? If material variances are consistently high, your BOM quantities need review. If capacity variances are high, your routing times need review.
2. Is procurement delivering at planned prices? PPV tells you directly. If it’s trending up, either the market moved or your standards haven’t.
3. Are variances material enough to adjust standards? A €50 variance on a €100,000 production run is noise. A €5,000 variance on a €20,000 run needs investigation and possibly a standard cost update.

---

When to Use Standard Costing

Standard costing works best when:

1. You have stable, predictable costs

If your material prices and production costs don’t change dramatically from month to month, standard costing gives you a clean baseline and lets you spot deviations. If you’re buying copper on spot markets with 30% price swings every quarter, standard costing will bury you in variances that are meaningless noise.

2. You need cost control, not just cost accounting

Standard costing forces accountability. When a purchase price variance hits the P&L, someone has to explain it. Under average costing, a 10% price increase just shifts your average cost imperceptibly — nobody sees it until margins start compressing six months later.

3. You manufacture with BOMs and routings

Standard costing integrates with manufacturing in a way actual costing doesn’t. The production order posts expected cost at standard, actual cost at actual, and the variance tells you whether production is in control. Under FIFO or Average, the production order uses whatever the current item cost is — useful for valuation but useless for performance measurement.

4. Your finance team has the discipline to maintain standards

Standard costing is not “set it and forget it.” Standards need periodic review — quarterly at minimum, monthly if your costs are volatile. If your finance team doesn’t have the bandwidth to maintain standard costs, don’t adopt standard costing. Stale standards generate meaningless variances, and meaningless variances generate bad decisions.

---

When to Use Actual Costing (FIFO or Average)

1. Your costs are volatile or market-linked

If your raw materials are commodities with daily price fluctuations, standard costing becomes a variance-reporting exercise that produces no actionable insight. Under FIFO or Average, your costs track the market automatically — no standard to maintain, no artificial variances to explain.

2. You’re a pure distributor (no manufacturing)

If you buy finished goods and sell them, the primary costing concern is accurate inventory valuation and COGS matching. Actual costing handles this directly. Standard costing adds complexity without the manufacturing variance analysis that justifies it.

3. You need precise per-transaction profitability

Under average costing, each sale reflects the actual blended cost of all recent purchases. Under FIFO, each sale reflects the cost of the specific purchase batch it came from. Under standard costing, each sale reflects the standard cost — and the variance sits in a separate account, disconnected from the sale that generated the margin. If you need transaction-level cost accuracy, use actual costing.

4. Your team doesn’t have the bandwidth for standard cost maintenance

This is the honest reason many companies use actual costing: standard costing is more work. You need someone who understands cost accounting well enough to set up BOMs correctly, maintain standard costs, and analyse variances monthly. If you don’t have that person, running standard costing means running it badly — and running it badly is worse than running actual costing well.

---

Common Pitfalls (And How We Learned Them)

Pitfall 1: Setting standards once and never updating them

What happens: Your standard costs are from 2023. Purchase prices have gone up 15%. Every purchase generates a large PPV, and inventory is systematically undervalued. Your balance sheet is wrong and your margin reports look artificially good because standard COGS is below actual costs.

The fix: Schedule standard cost reviews. Quarterly is good. Monthly is better if your costs move. The Standard Cost Worksheet makes updates to batches efficient — an afternoon of work once you’ve done it a few times.

Pitfall 2: Using standard costing for items with unreliable standards

Not every item in your catalog should be standard-costed. Raw materials bought on commodities markets, items purchased infrequently at negotiated prices, and imported goods with significant currency exposure are candidates for FIFO or Average — even if the rest of your catalog uses Standard.

Business Central allows mixed costing methods across items. Use them. A manufacturer might use Standard for finished goods and manufactured components (stable costs, BOM/routing integration) and Average for traded components and raw commodities (volatile costs, no manufacturing layer).

Pitfall 3: Ignoring small variances because they’re small

A €200 variance every month for 12 months is €2,400. It’s probably a BOM quantity that’s off by 2%. Fixing it takes 5 minutes. Letting it accumulate costs you €2,400 and embeds an error in your standards that compounds over time.

Small, consistent variances are a signal that your standards need micro-adjustments. Fix them when they’re small.

Pitfall 4: Running FIFO or Average without running the Adjust Cost batch

We covered this in the costing methods guide, but it bears repeating: the Adjust Cost – Item Entries batch recalculates COGS to match your chosen costing method. If you don’t run it, your COGS reflects provisional costs, not actual costs per your method.

Under FIFO, unadjusted costs mean the system hasn’t applied cost layers — your oldest purchases may not have been assigned to the right sales. Under Average, unadjusted costs mean your average hasn’t incorporated the latest purchases. Either way, your margin reports are wrong.

Run the batch weekly. Run it before month-end. Run it before you send financials to anyone who will actually read them.

Pitfall 5: Confusing the Item Card Unit Cost with the costing method

The Unit Cost field on the item card serves different purposes under different methods:

• Standard: Unit Cost IS the standard cost. Change it through the worksheet, not on the card.
• FIFO: Unit Cost is the last direct cost — informational only. COGS doesn’t use it.
• Average: Unit Cost is the weighted average — it’s what COGS actually uses.

Under FIFO or Average, manually changing the Unit Cost on the item card doesn’t revalue inventory. It updates the field, which affects future transactions that reference the unit cost on the card (purchase orders that default to last direct cost), but it doesn’t retroactively adjust COGS. If you need to revalue inventory, use the Revaluation Journal — not the item card.

---

Setting Up the Revaluation Journal (When Standards Change)

When you update standard costs through the worksheet, the system posts revaluation entries that adjust your inventory from the old standard to the new standard. But sometimes you need to revalue outside the worksheet — for write-downs to net realisable value, physical inventory corrections, or cost adjustments that don’t flow through the standard cost change process.

The Revaluation Journal (Inventory → Costing → Revaluation Journal) handles this:

1. Enter the item number, location, and variant
2. Enter the new unit cost
3. The system calculates the revaluation amount: (new cost − current cost) × quantity on hand
4. Posting the journal debits or credits the Inventory account and the offsetting account you specify (typically Inventory Adjustment)

The Revaluation Journal is also how you handle the write-off/create-new-item workaround when you need to change an item’s costing method after ledger entries exist. Write off the old item (adjust cost to zero, move quantity out), create the new item with the correct costing method, re-enter the quantity at the correct cost.

---

Linking Back: How This Fits the Full Costing Picture

This article focuses on the standard vs actual decision — the framework for choosing between them and the setup specifics. For the complete picture:

• Our Business Central costing methods guide covers all five methods (FIFO, Average, Standard, Specific, LIFO) with business scenarios, pros/cons, and a decision matrix
• The costing method you choose per item determines your COGS calculation, inventory valuation, reporting granularity, and operational overhead
• Standard vs actual is the primary architectural decision — the rest (FIFO vs Average vs Specific) is implementation detail within the actual costing family

If you’re early in your costing journey, start with the pillar post. If you’ve already read it and you’re leaning toward standard costing, this article gives you the setup steps and variance analysis framework.

---

FAQ

Can I change from average costing to standard costing?

Technically yes, but you can’t change the costing method on an existing item with ledger entries. The practical approach: write off the stock of the old item (Average), create a new item card with the Standard costing method, and re-enter the quantity at the standard cost. Plan this for a low-activity period — you’ll need to block transactions on the old item during the switch.

How often should I update standard costs?

Quarterly is the minimum for most manufacturers. Monthly if your raw material costs move more than 5% in a quarter. Annually is almost certainly insufficient — by month 8, your variances will be large enough that the standard cost is functionally useless for management decisions.

Do I need separate variance accounts for each variance type?

Not strictly required — BC will post to the default adjustment account if you don’t configure specific accounts. But separate accounts give you visibility into which variances are occurring. A P&L that shows a €20,000 total inventory adjustment tells you nothing. A P&L that shows €15,000 purchase price variance and €5,000 material usage variance tells you procurement needs attention.

What’s the Adjust Cost batch and when should I run it?

The Adjust Cost – Item Entries batch recalculates COGS to align with your chosen costing method. Under FIFO, it applies cost layers to sales. Under Average, it recalculates the weighted average. Under Standard, it mainly handles production order actual cost posting. Run it at least weekly, and always before month-end close. In high-volume environments, daily runs prevent month-end processing bottlenecks.

Does standard costing work with LS Retail?

Yes, but with caveats. LS Retail adds POS transactions that generate high volumes of item ledger entries. The standard cost worksheet and variance analysis work the same way, but the transaction volume means:

• The Adjust Cost batch takes longer (more entries to process)
• Variance reports need to aggregate at a higher level (store/week rather than transaction level)
• Staff discount and promotional pricing create additional variance categories you’ll need to account for

We’ve implemented standard costing with LS Retail for manufacturing companies that run factory outlets — it works, but it needs more rigorous process discipline than a distribution-only environment.

---

Need help deciding which costing method fits your business? We do this every day. Book a free consultation → We’ll walk through your specific products, volumes, and reporting needs — no obligation, no pitch deck, just a practical recommendation.