How do we connect stock management and financial reporting in Business Central?
Learn how Business Central connects stock movements, inventory costs and the general ledger, with practical reconciliation and reporting controls.
What is the quick answer?
Connect stock and finance by configuring inventory posting correctly, recording physical movements promptly, maintaining costing data, processing cost adjustments and reconciling inventory values to the general ledger. Business Central links quantities and costs through its item and value entries, but reliable reporting still depends on consistent dates, complete transactions and clear ownership between operations and finance.
Why can the warehouse quantity look right while the accounts look wrong?
A stock quantity and an inventory value answer different questions. The warehouse may correctly show ten units while finance is still waiting for an invoice, an additional freight charge or a cost adjustment. Alternatively, an accounting balance may include a manual journal that has no corresponding stock movement. Both teams can therefore be reading their screens accurately while reaching different conclusions.
The solution is to understand the chain from physical event to financial entry. Business Central implementation and support can connect these records, but configuration and daily routines determine whether the connection remains dependable. Start by agreeing which quantity and value reports matter, the cut-off used and who investigates differences. Avoid treating every discrepancy as a reporting problem before checking the underlying transactions.
↑ Back to contentsWhich records connect stock movements to accounting values?
Business Central records inventory quantity movements in item ledger entries and the associated values in value entries. Inventory values then need to reach the relevant general ledger accounts. These are linked stages, with different records serving different purposes, rather than one universal stock balance.
Microsoft explains the relationship in its inventory and general-ledger reconciliation guidance. Finance and operations should learn to follow one purchase and one sale through those records. The aim is not to make every warehouse employee an accountant. It is to give the people investigating an issue a common way to establish what happened and which stage needs attention.
↑ Back to contentsWhat should we agree before changing inventory setup?
Document the current accounting policy, costing methods, locations, item categories and reporting requirements. List who may create items, change posting groups, adjust quantities and post directly to inventory-related accounts. Capture the current reconciliation method and any balances that already need investigation.
Business Central finance implementation can help translate this into a controlled configuration. Do not change settings in the live company merely to see whether a difference disappears. Test the proposed treatment on representative transactions and obtain finance approval. Some configuration choices affect future transactions without correcting existing records, so the plan may need both a better setup and a separate, documented treatment for historical issues. Preserve a clear explanation of what changed and why.
↑ Back to contentsHow do posting groups affect the connection?
Posting groups help determine where inventory-related transactions reach the accounts. Their configuration should reflect the business's accounting structure and the way items and locations are classified. An incorrect or missing combination can cause posting errors or place values in an unexpected account.
Create a small set of test items covering the important combinations. Buy, receive, invoice, sell, return and adjust them in a test environment. Ask finance to verify the resulting entries rather than only checking whether the document posted successfully. Keep ownership of posting-group changes with appropriately authorised staff. A warehouse user should not need to invent a new accounting classification to receive an ordinary delivery, and a routine item creation process should not bypass financial review.
↑ Back to contentsHow should we choose and maintain costing methods?
The costing method should follow an approved accounting approach suitable for the item and business process. It influences how inbound costs relate to outbound transactions and how inventory and margin are understood. A familiar label is not enough; staff responsible for finance need to understand its effect on their own examples.
Demonstrate purchases at different prices, a later sale and a returned item. For manufacturing, include component consumption and finished output. Business Central for manufacturing can help assess these production-specific flows. Record the assumptions and restrict unplanned changes to important costing data. The objective is consistent, explainable valuation. A method that produces a plausible unit cost today may still be inappropriate if the business cannot maintain the information it relies on.
↑ Back to contentsWhy do receipt and invoice dates matter?
The physical arrival of goods and the supplier's invoice are different events and may occur in different periods. If staff wait until an invoice arrives before recording a receipt, the warehouse view can become unreliable. If finance assumes every receipt is fully invoiced, month-end interpretation can also become misleading.
Agree how received-not-invoiced goods are identified and reviewed. Test the accounting treatment using the configured expected-cost approach rather than assuming all systems behave the same way. Business Central supply chain and distribution can help align purchasing and receiving responsibilities. Make it easy for staff to record the event they actually know has happened, then give finance a controlled way to investigate outstanding documents and valuation consequences.
↑ Back to contentsWhat does cost adjustment do?
Costs can become known after an item has moved or been sold. Business Central's cost adjustment process forwards relevant cost changes through the applicable cost chain. This is important when the final inbound cost differs from the cost available when the outgoing transaction was recorded.
Microsoft's cost adjustment documentation explains the standard mechanism and its relationship with inventory valuation. Agree how and when your business runs and monitors it. The right routine should consider volume, performance, posting dates and close requirements. A scheduled task is not a control by itself: someone must confirm that it completed and investigate failures before relying on the resulting margin or inventory figures.
↑ Back to contentsIs automatic cost adjustment the same as automatic cost posting?
No. Adjusting costs and posting inventory values to the general ledger are distinct activities. The configured process needs to complete both as appropriate. A business can otherwise have updated inventory value entries while the corresponding accounting values are not fully reflected in the general ledger.
Document the sequence in plain language and include it in the month-end checklist. Identify which tasks run automatically, which require a person and what evidence confirms completion. Test a deliberately missing posting setup in a safe environment so the team understands how an error appears. Do not assume that the absence of a user complaint means every inventory cost reached the accounts. Check task outcomes and reconciliation evidence directly.
↑ Back to contentsHow should landed costs and late supplier charges be handled?
Freight, duty and other relevant purchasing costs can arrive separately from the goods invoice. Finance needs an agreed treatment for costs included in inventory and a consistent way to associate them with the appropriate receipt or items. The correct accounting policy should be confirmed by the business's finance advisers.
Use a realistic scenario where some stock has already sold before an additional cost arrives. Follow the impact on remaining inventory and the related cost of sales after processing. Avoid spreading a charge across unrelated items merely to clear an invoice quickly. Preserve the allocation basis and supporting reference so a later margin review can distinguish a genuine trading issue from a charge assigned inconsistently.
↑ Back to contentsHow do warehouse movements affect financial reporting?
A movement between bins is different from a transfer between locations, and both may differ from a sale between legal entities. The warehouse process should record the actual event using the appropriate document. Otherwise, reporting can misrepresent availability or ownership even if the total quantity appears unchanged.
Explain these distinctions to staff using common examples from their working day. Test goods in transit, damaged stock and urgent transfers. For businesses with several selling channels, Business Central for retail can help align the availability shown to customers with physical and accounting controls. Decide who investigates a transfer that has left one location but has not been received at the other. Unfinished operational documents should be visible rather than silently treated as a reporting adjustment.
↑ Back to contentsHow should we handle negative stock and late transactions?
A negative quantity may indicate that a real movement was recorded late, a receipt was missed or staff used the wrong item or location. Investigate the cause rather than treating the negative figure as an ordinary operating condition. Repeated issues can make availability promises and cost interpretation difficult.
Agree an exception process that corrects the underlying record with suitable authorisation. Check dates and quantities before inserting a balancing adjustment. If staff regularly dispatch before the system receipt is entered, examine the workflow and staffing constraints. The answer may involve a better receiving routine, device access or clearer responsibilities. Software controls work best when they support a process that people can realistically follow during busy periods.
↑ Back to contentsWhat does a useful stock-to-ledger reconciliation look like?
Choose a defined reporting date and a consistent scope, including companies, locations and inventory accounts. Complete the required cost processing, then compare the inventory valuation information with the relevant general ledger balances. Differences need categorisation and evidence, not a single unexplained balancing number.
Common investigation areas include incomplete cost posting, timing, posting configuration and direct journals to inventory-related accounts. Assign an owner and reference to each item. Keep the report parameters and completion date with the reconciliation so another reviewer can reproduce it. Finance should be able to explain the closing balance and unresolved differences without asking the warehouse to provide a separately invented valuation spreadsheet every month.
↑ Back to contentsShould users post manual journals directly to inventory accounts?
Access should follow the approved control design. A direct journal can alter a general ledger balance without changing the item-level records, which may create a reconciliation difference. There can be legitimate accounting reasons for an adjustment, but its purpose and later treatment need to be explicit.
Review who has this permission and how exceptions are approved. Where a correction belongs in the stock process, use the appropriate operational route rather than a general journal chosen only because it is quicker. Keep a register of any finance-only adjustments affecting reconciliation. Review outstanding items regularly so a temporary year-end treatment does not become a permanent unexplained difference carried from one period to the next.
↑ Back to contentsHow should stock counts feed into the accounts?
A count provides evidence about physical quantities. It should have a defined scope, cut-off, instructions and approval process. Control movements during the count or record them carefully enough to explain the timing. The person investigating a variance needs to know whether the difference reflects a genuine loss, an unposted movement or a counting error.
Post approved adjustments through the appropriate inventory process so quantities and values remain connected. Review material variances and recurring patterns by item or location. Counting more often is not a complete answer if the same process error recreates the difference. Feed the findings back into receiving, picking, transfers and item setup. A disciplined count improves both financial confidence and operational availability.
↑ Back to contentsHow should reporting dimensions be designed?
Dimensions should support decisions the business actually needs to make, such as profitability by department, product group or channel. Agree the definition of each dimension and where the value should originate. Avoid asking users to supply information they cannot reasonably know at the point of transaction.
Test how the chosen values travel through purchases, stock transactions and sales. Decide how missing or inconsistent values are detected and corrected. Do not assume adding a dimension to a report will reconstruct information that was never captured. Keep the design proportionate: excessive choices can reduce data quality. A small number of well-maintained classifications is often more useful than a large reporting structure that staff complete inconsistently.
↑ Back to contentsCan Power BI help us see stock and financial performance together?
Yes, reporting can bring related operational and financial information into a useful view, provided the data model is designed carefully. Quantities, values and general ledger balances exist at different levels of detail. Joining them carelessly can duplicate amounts or produce totals that look convincing but cannot be reconciled.
Power BI consultancy can help establish the model, measures, refresh arrangements and access controls. Display the reporting date and explain whether costs are provisional or fully processed. Start with a small set of trusted measures rather than a crowded dashboard. Useful questions include which stock is slow moving, where availability is unreliable and whether margin changes remain after late costs have been included.
↑ Back to contentsWhat should we check when external systems manage stock?
An external warehouse, ecommerce or manufacturing application can create another source of timing differences. Define which system owns each event and the point at which Business Central receives it. A shipment status in a third-party platform is not necessarily a posted stock transaction in the ERP.
Use system integration services to document message identifiers, units of measure, failure handling and duplicate prevention. Reconcile business outcomes such as dispatched quantities and completed receipts, not only successful connection responses. Agree who investigates messages waiting in a queue and how manual corrections prevent a later duplicate. Test an unavailable system and a repeated message before launch. The stock-to-finance connection depends on these neighbouring systems delivering complete and accurate events.
↑ Back to contentsCan approvals and alerts reduce recurring reconciliation work?
They can help make exceptions visible and route decisions to the right person. For example, a workflow may request approval for a material stock adjustment or notify an owner about an overdue integration exception. It should support a clear business control rather than add messages that everyone learns to ignore.
Power Platform consulting can help assess appropriate automation around these activities. Define the trigger, evidence required, approver and escalation path. Include an absence arrangement so a control does not stop when one manager is away. Measure whether the workflow reduces unresolved issues and whether staff can distinguish urgent exceptions from routine information. Keep the final accounting review proportionate to the risk and value involved.
↑ Back to contentsHow should the month-end routine change?
Bring operations and finance into the same close timetable. Include late receipts and shipments, uninvoiced transactions, stock adjustments, production completion, cost processing, reconciliation and reporting review. Specify cut-off rules and the point at which a period is considered ready for release.
Support arrangements matter during the close. managed IT support can help ensure authorised staff have reliable access, while managed cloud services planning can consider any supporting workloads and maintenance windows. Record who covers each task if its usual owner is absent. Keep a short exception list with impact and resolution dates. A predictable month-end should rely on repeatable evidence and shared responsibilities rather than a last-minute search for the person who understands one particular spreadsheet.
↑ Back to contentsHow do we know the connection is improving?
Track the number and age of reconciliation differences, incomplete cost-processing tasks, stock adjustments and late operational postings. Also measure the time finance and warehouse teams spend resolving them. Establish a baseline and review trends after changes so the business can distinguish improvement from a temporary clean-up.
Choose a few meaningful measures and assign owners. If differences recur, investigate the process that creates them rather than repeatedly clearing the closing balance. Use training, configuration changes or improved integration controls where the evidence points. Celebrate a report only when its figures can be explained and reconciled. The practical goal is that operations trusts availability while finance trusts valuation, with both teams understanding how the same events connect them.
↑ Back to contentsWhat is the best first step if our stock and accounts do not agree?
Take one recent period and preserve the reports, parameters and balances used. Confirm that you are comparing the same company, date, scope and accounting basis. Identify whether the gap concerns physical quantities, inventory values or the general ledger before proposing a correction.
Then trace a small number of representative transactions and review unfinished cost processing and known manual adjustments. This creates an evidence-based starting point for remediation. To review the configuration and daily routines, contact NetMonkeys with your current reconciliation method and examples of unexplained differences. A focused investigation is usually more useful than replacing dashboards or posting a balancing journal before the underlying cause is understood.
↑ Back to contentsWhat else do businesses ask?
Does a correct stock quantity guarantee a correct inventory value?
No. Quantity and value are linked but different. Late invoices, additional costs, incomplete cost processing and accounting adjustments can affect valuation even when the physical quantity is correct.
Are cost adjustment and posting inventory cost to the general ledger the same?
No. They are distinct processes. The configured routine must ensure costs are adjusted and the relevant values reach the general ledger, with errors investigated before reporting is finalised.
Should we fix an unexplained stock difference with a general journal?
Investigate the cause first. A general journal changes financial balances without necessarily correcting item-level records, so it may create or conceal a reconciliation difference.
Who wrote this guide, and how was it checked?
Written by Caleb Adoh, Growth Marketing Manager at NetMonkeys. Microsoft Learn inventory-to-general-ledger reconciliation and cost adjustment documentation checked on 27 October 2026. The control framework and investigation scenarios are original practical guidance. Finance should approve accounting treatments and configuration changes.
How can NetMonkeys help your business?
Talk to our team about your priorities and agree a practical next step.
Speak to NetMonkeys
