Skip to content
Free Business Central assessment
Written, scoped proposal after the assessment
Dynamics GP support ends December 31, 2029
Independent, not affiliated with Microsoft
A division of Sataware Technologies
Weekday support on Mountain Standard Time
Free Business Central assessment
Written, scoped proposal after the assessment
Dynamics GP support ends December 31, 2029
Independent, not affiliated with Microsoft
A division of Sataware Technologies
Weekday support on Mountain Standard Time
Free assessment →

Expected cost Business Central teams see on receipts and shipments

Expected cost Business Central records is the estimated value of goods you have received or shipped but not yet invoiced. It lets finance see stock and accruals before the paperwork catches up. This guide explains where the figure comes from, the interim accounts it uses and how it reverses when you post the invoice.

Last updated

📦The concept

What expected cost Business Central uses means

Say you post a purchase receipt without the invoice. The goods are on the shelf, but the final price is not confirmed. Business Central then creates a value entry using the cost on the purchase order line. It stores that figure in the Cost Amount (Expected) field.

Once you post the invoice, the expected amount reverses. The invoiced amount goes into Cost Amount (Actual). If the vendor charged a different price, the actual figure simply replaces the estimate. You need not correct anything by hand, as long as you post receipts from the order.

Ask how receipts should post →
Loaded container ship and a tugboat at sea
Where you see it
  • ✓Value Entries page
  • ✓Item Ledger Entries page
  • ✓Inventory Valuation report
  • ✓Posted purchase receipts
  • ✓Posted sales shipments
🎚️One switch

The Expected Cost Posting to G/L setting

In Inventory Setup there is a field called Expected Cost Posting to G/L. With it off, expected cost lives only in the inventory subledger. The general ledger sees nothing until the invoice. With it on, each receipt and shipment also posts to interim accounts. So the balance sheet shows goods received not invoiced.

Switching it on suits companies with long gaps between receipt and invoice. It also suits auditors who want an accrual for uninvoiced receipts at each period end. Same-day invoicers often leave it off. Decide early, because turning it on later only affects documents you post from that point.

Discuss which setting fits →
Good reasons to enable
  • ✓Long receipt to invoice gaps
  • ✓Accrual for uninvoiced receipts
  • ✓Import shipments in transit
  • ✓Drop shipments invoiced later
  • ✓Auditor request for interim balances
🏦Interim accounts

Interim accounts for expected cost Business Central needs

Expected cost posting uses its own set of accounts, so estimates never mix with invoiced values. Inventory Posting Setup holds Inventory Account (Interim). General Posting Setup holds Invt. Accrual Acc. (Interim) for purchases and COGS Account (Interim) for sales. Fill these in for each combination you use.

A receipt debits the interim inventory account and credits the interim accrual account. Then the invoice reverses both and posts to the real inventory and payables accounts. If a combination is missing, the receipt stops with a posting setup error. So test one purchase and one sale for each posting group in a sandbox before you go live.

Have us map the accounts →
Fields to complete
  • ✓Inventory Account (Interim)
  • ✓Invt. Accrual Acc. (Interim)
  • ✓COGS Account (Interim)
  • ✓WIP account for production
  • ✓Direct Cost Applied account
🧾Period end

Reconciling expected cost Business Central holds at period end

The Inventory Valuation report has an Include Expected Cost option. Run it with the option on. The expected column should then agree with the interim inventory account. The Inventory to G/L Reconcile report breaks the same figures into received not invoiced and shipped not invoiced.

Old balances in the interim accounts usually point to receipts that nobody invoiced. Often the vendor invoice was entered as a separate document, not from the order. Find them by filtering purchase lines on quantity received not invoiced. Then invoice them properly, or undo the receipt if the goods went back.

Get help clearing old receipts →
Clean-up steps
  • ✓Filter received not invoiced lines
  • ✓Match vendor invoices to orders
  • ✓Undo receipts for returned goods
  • ✓Close fully invoiced orders
  • ✓Rerun the reconcile report
⚠️Common mistakes

Mistakes that distort expected cost in Business Central

The most frequent problem is a purchase order with no price, or a placeholder price, on the line. The receipt then posts an expected cost of zero. So margin on anything shipped before the invoice looks far too good. Make the direct unit cost a required check before anyone posts a receipt.

Another mistake is forgetting that item charges such as freight arrive on the invoice. They are never part of the expected figure. Cost adjustment then corrects earlier shipments. If the interim balances in your company no longer make sense, our consultants can trace them back entry by entry.

Request an interim account check →
Watch out for
  • ✓Order lines with no cost
  • ✓Invoices not linked to receipts
  • ✓Missing interim posting setup
  • ✓Setting changed mid period
  • ✓Freight added after receipt
Questions

Questions about expected cost Business Central users ask

Is expected cost recorded if the G/L setting is off?

Yes. Business Central always writes the expected amount to value entries in the inventory subledger. The setting only controls whether that amount also posts to interim accounts in the general ledger. Valuation reports can include the expected figure either way. So expected cost Business Central tracks never disappears when the setting is off.

What happens when the invoice price differs from the order?

The expected value entry is reversed in full, and a new entry posts with the invoiced amount. The cost adjustment batch job then corrects outbound entries that already used the estimate. So cost of goods sold ends up reflecting the real invoice. Run the batch job before you read margin reports, or the old estimate may still show.

Can I turn on Expected Cost Posting to G/L later?

You can, but it applies to new postings. For receipts and shipments you already posted and still have not invoiced, run Post Inventory Cost to G/L. It creates the interim entries for them. Test the switch in a sandbox copy first. Then pick a quiet moment in the period, so your auditors can follow the change easily.

Does expected cost apply to production orders?

Yes. Output posted on a released production order is valued at expected cost until you finish the order. With the setting on, that value sits in the WIP account. Finishing the order then converts it to actual cost on the produced item. So watch your open production orders when you check interim balances at period end.

Why is my interim accrual account never zero?

It holds the value of everything received and not yet invoiced, so a balance is normal. It only signals a problem when old receipts stay in it. List uninvoiced receipt lines by posting date and chase the oldest ones first. That keeps expected cost Business Central reports show clean and easy to explain.

Book a discovery call

Let's talk through your move to Business Central.

A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.

What happens after you send the form

1
We read your request
A consultant reads your details before the call. There is no long questionnaire to fill in.
2
Discovery call
We go through your processes, your current systems and the problems you want solved.
3
Written plan and proposal
You receive a written proposal covering scope, phases and licensing.
✓A consultant replies by email
✓NDA available on request
✓No cost, no obligation
✓Senior BC consultants

Request your discovery call

Takes under a minute. A consultant replies by email.

Free

Your details stay with our consulting team. We never share or sell them.

▦ IndependentDynamics 365Business Central consultants
C Clutch5.0 from 1 reviewSataware on Clutch
G GoodFirmsParent company profileSataware on GoodFirms
S SatawareOur parent company14+ years, 1000+ projects listed
▦ IndependentDynamics 365Business Central consultants
C Clutch5.0 from 1 reviewSataware on Clutch
G GoodFirmsParent company profileSataware on GoodFirms
S SatawareOur parent company14+ years, 1000+ projects listed
Book a free call