Sage X3 Costing and Valuation

How to Review Overhead and Landed Cost Variances in Sage X3

A month-end guide to overhead and landed cost variances in Sage X3: where they come from, how to separate absorption, spending, and timing, and how to keep them under control.

By Phillip Hoffman, Founder and Principal Consultant· Updated October 17, 2026

Overhead and landed costs have something in common. Both are real costs that are hard to assign to individual products, so both are usually applied through rates and estimates. When the rates are right, the variances are small and easy to explain. When they are not, the variances grow every month and become one of the least understood lines in cost of goods sold.

This guide covers how overhead and landed cost variances arise in Sage X3, how to separate the different kinds of variance so each can be explained, and how to keep the rates behind them realistic.

Talk to a Senior Sage X3 Consultant

Signs these variances need a closer look

  • Overhead variance is large every month and always in the same direction.
  • Overhead absorbed into products changes sharply when production volume changes.
  • Some products appear to carry overhead twice, or none at all.
  • Freight, duty, or brokerage invoices arrive weeks after the goods and post to an unexpected account.
  • Landed cost variances are concentrated on a few suppliers, origins, or shipping routes.
  • Nobody can say how much of the variance is caused by rates, volume, or timing.

How overhead reaches product cost

Under standard costing, overhead is applied to products through rules and rates. Depending on how the system is configured, overhead may be calculated as a rate per labor or machine hour, a percentage of material cost, or an amount per unit, and applied by cost category, product group, or work center.

Actual overhead, such as indirect labor, utilities, depreciation, and maintenance, is recorded in the general ledger as it is incurred. The difference between the overhead absorbed into products and the overhead actually incurred is the overhead variance. Our guide to setting up standard costing in Sage X3 covers how overhead rules are structured.

Three kinds of overhead variance

Overhead variance is easier to explain when it is split into its parts.

Absorption, or volume

Overhead rates are usually based on an expected level of production. When actual production is lower than expected, less overhead is absorbed into products than is incurred, and the shortfall appears as unfavorable variance. When production is higher, the reverse happens. This is the most common source of large overhead variances, and it reflects volume, not inefficiency.

Spending

Actual overhead costs may be higher or lower than the amounts the rates were based on: higher utilities, unplanned maintenance, or changes in indirect staffing. This is a spending variance and is a genuine cost question for the business.

Rate and rule errors

Some variances come from the setup rather than the business:

  • Overlapping rules that apply overhead twice to the same product.
  • Missing rules that leave some products with no overhead.
  • Rules keyed to the wrong cost category or product group.
  • Outdated rates that were never updated after the business changed.
  • Incorrect routing times, which absorb too much or too little overhead when rates are based on hours.

These need to be corrected in the setup, not explained month after month.

How landed costs create variances

Landed costs, such as freight, duty, brokerage, insurance, and handling, can be treated in two main ways under standard costing:

  • Included in standard as an estimated amount or rate per unit. The variance is the difference between the actual landed cost and the estimate.
  • Excluded from standard. The full landed cost appears as a variance, usually alongside purchase price variance.

Either approach is valid, but each produces different variances, and the treatment needs to be consistent. Our guide to validating standard cost updates covers how to make that decision.

Common causes of landed cost variances

  • Estimated rates that are out of date, for example freight rates that changed significantly during the year.
  • Allocation method. Landed costs allocated by value, weight, volume, or quantity produce different results by item. An allocation method that does not reflect how the cost is actually incurred can overstate some products and understate others.
  • Late invoices. Freight and duty invoices often arrive after the goods have been received, and sometimes after they have been sold. Depending on configuration, the cost may post to inventory, a variance account, or cost of goods sold, and may land in a different period from the receipt.
  • Missing invoices. If a landed cost invoice has not been received by period end, the cost is missing from the month unless it is accrued.
  • Currency. Duty and international freight may be charged in a different currency from the goods, with their own exchange rate differences.
  • Shipments covering many items. One freight invoice may relate to a container with hundreds of products, which makes allocation errors easy to miss.

A month-end review sequence

  1. 1. Confirm the period is complete.

    Production completions, receipts, landed cost invoices received, and stock accounting for the period should be posted.

  2. 2. Accrue known landed costs.

    Where freight or duty is known but not yet invoiced, agree with Finance whether to accrue it so the month reflects the full cost.

  3. 3. Split overhead variance into absorption, spending, and setup issues.

    Compare actual production volume to the volume the rates assume, and actual overhead spending to the budgeted amounts.

  4. 4. Check for overhead rule problems.

    Look for products with unusually high or zero overhead, and confirm that changes to rules or routings since the last review were intended.

  5. 5. Review landed cost variances by supplier, origin, and route.

    Compare actual landed cost per unit to the standard or estimated rate.

  6. 6. Check timing.

    Identify landed cost invoices posted this month that relate to receipts from earlier periods, and the reverse.

  7. 7. Classify and explain.

    Record whether each significant variance reflects volume, spending, rates, allocation, timing, or an error.

  8. 8. Correct the setup

    where rules, rates, routings, or allocation methods are wrong, and note what needs to change at the next standard cost update.

As with the other reviews in this series, a custom report that brings production volume, overhead absorbed, actual spending, and landed costs by receipt into one view makes this review far quicker than working product by product.

Use trends to tell volume from problems

Monthly trends are especially useful for overhead, because volume-driven variances follow production levels. Plot overhead variance next to production volume each month. If the variance moves with volume, the rates are behaving as expected. If the variance stays large even when volume is normal, the cause is spending or setup.

For landed costs, track actual landed cost per unit by supplier or origin over time. A steady upward trend means the estimated rate needs updating. Sudden spikes usually point to a specific shipment, allocation, or invoice.

A note on accounting treatment

When overhead variances are large, the accounting treatment deserves attention. Inventory is generally expected to carry overhead based on normal production levels, and costs related to abnormally low production are usually expensed rather than added to inventory. Significant landed cost variances may also relate partly to inventory still on hand. Agree the treatment of significant variances with your auditors, particularly at year-end.

Preventing avoidable variances

  • Review overhead rates against expected production volume before each standard cost update.
  • Check overhead rules for overlaps and gaps whenever products, product groups, or cost categories change.
  • Keep routing times realistic when overhead is applied by hours.
  • Update landed cost estimates when freight or duty rates change significantly.
  • Choose allocation methods that reflect how each landed cost is actually incurred.
  • Agree a process for accruing landed costs that have not been invoiced by period end.

When to bring in help

    Outside help is usually worthwhile when overhead variance is consistently large and cannot be split into volume, spending, and setup, when overhead rules have grown over time without documentation, when landed costs are significant and allocated inconsistently, or when auditors have questioned how variances are treated. In those situations, the work involves reviewing rates, rules, routings, and allocation together.

    Overhead and landed cost questions

    What is under-absorbed overhead?

    It is the amount by which actual overhead incurred exceeds the overhead applied to products. It usually happens when production is lower than the volume the overhead rates were based on.

    Why does overhead variance change when production volume changes?

    Because overhead rates spread expected costs over an expected volume. When actual volume differs, the amount absorbed into products differs too, even if the costs themselves have not changed.

    Should landed costs be included in standard cost?

    When they are significant and predictable, including them in standard reduces variances and gives a truer product cost. When they are small or highly variable, many businesses exclude them and review the variance separately. Either way, apply the rule consistently.

    Why do freight invoices post to the wrong period?

    Freight and duty invoices often arrive after the goods. Depending on configuration, they may post when the invoice is entered rather than when the goods were received. Accruing known landed costs at period end keeps each month's cost complete.

    How should landed costs be allocated across items?

    Use the method that best reflects how the cost is incurred: weight or volume for freight on heavy or bulky goods, value for duty and insurance. The right method varies by cost type, and the choice should be documented.

    Related reading

    Need help explaining these variances?

    If overhead or landed cost variances are large every month and the explanations keep changing, a review of your rates, rules, and allocation methods usually shows where the differences are coming from. Schedule a discovery call to talk it through with a senior Sage X3 consultant.

    Need help with Sage X3?

    PRH Consulting can review the issue or the project with you and tell you plainly what it will take to resolve. Most conversations start with a short discovery call.