Show open commitments without double-counting actual costs

The procurement team may ask how much order value remains undelivered. Finance may ask what has been received but not invoiced. Project controls may ask what future cost remains to complete the work. These are related questions with different answers.

State which measure the report calls an open commitment. In this article, the simple operational bridge distinguishes the unperformed order portion from accepted supply awaiting invoice. A company may use different labels, but it should preserve the distinction and explain its formula.

ERPNext's purchase order documentation describes received and billed quantities against order items. These fields support reconciliation, but quantity percentages alone may not represent value accurately when rates, charges or partial billing arrangements differ.

Begin with the current authorised order value, including valid amendments and cancellations. Use line-level quantities, rates and applicable charges on a consistent basis. Record currency and whether tax or other amounts are included in the management measure.

Link receipts, service acceptances, invoices, credits and returns to the relevant order lines. A header-level percentage can hide one fully delivered item and another untouched item. It can also misstate the remaining value when lines have different prices.

Separate physical progress from accounting recognition. Material accepted into inventory is not necessarily expense consumed by the project. The commitment report should provide the operational bridge, while finance and project controls define how it feeds the actual-cost and forecast views.

Consider a synthetic order with a current value of ₹20 lakh. Accepted supply is valued at ₹8 lakh, and ₹6 lakh of that accepted supply has been invoiced. Assume consistent valuation, no taxes, advances, returns, price differences or amendments for this example.

The ₹2 lakh may already have a receipt-related accounting entry. ERPNext's stock-received-but-not-billed documentation shows one inventory receipt and clearing-account pattern. Check the configured accounting before proposing an additional accrual.

The ₹12 lakh is the remaining order portion under these assumptions. It is not necessarily the project's entire cost to complete: the project may need additional uncommitted work, and some ordered material may remain in inventory rather than be consumed immediately.

A forecast can combine actual cost, appropriately recognised or estimated unbilled work, remaining commitments and additional uncommitted cost only when the populations are defined without overlap. Map each source to one place in the bridge.

If a package forecast already includes the full expected cost of an order, do not add the open commitment again as a central adjustment. If an accrual is already in actuals, do not add the same accepted-but-unbilled amount a second time. Reconcile by source identity rather than relying on matching totals.

Label whether a forecast input is total expected cost or remaining cost. Confusing those two forms is a common way to double-count expenditure. The report should make the calculation visible enough that a reviewer can reproduce it from the source records.

An approved order amendment changes the current commitment basis. A proposed amendment remains pending until the required authority is recorded. Keep the original value, approved changes and current value as a traceable bridge.

Cancellation may reduce the unperformed balance, but check any termination charge, delivered material or other remaining obligation. Closing an order administratively does not prove that all costs and liabilities have disappeared. Record the commercial decision and outstanding settlement items.

Returns and credits also need distinct treatment. A physical return may precede the supplier credit. The report should show the pending credit or replacement rather than forcing the received and billed values to match before the evidence exists.

Advance invoices, milestone billing and service arrangements may not follow receipt-then-invoice logic. Define the appropriate performance or acceptance measure for each population. Do not apply the ₹20 lakh example mechanically to every contract type.

Where an invoice exceeds recorded acceptance, show an exception for review. It may reflect a missing acceptance record, an authorised advance, a price difference or an error. The system should preserve the reason instead of allowing a negative unbilled balance to pass unnoticed.

Foreign-currency movements and valuation differences need a consistent reporting basis and finance review. Keep quantity completion separate from exchange-rate effects so the procurement team can still understand what remains to be delivered.

Create a sample order, partial receipt, partial invoice, return, credit and approved amendment. At each stage, reconcile the current order basis to the defined portions. Check that the same receipt cannot be counted under two invoices without the appropriate allocation.

Review old open commitments with buyers and package owners. Some represent genuine remaining supply; others are stale balances after scope completion or cancellation. Close or amend them through the authorised process, preserving any unresolved financial items.

Measure unexplained differences and aged unperformed balances alongside the headline commitment total. A lower total is not automatically better if it results from premature order closure or missing amendments.

A reliable commitment report explains the path from the authorised order to accepted supply, invoicing and remaining performance. That makes it useful for procurement, finance and project forecasting.

1. Define the commitment measure and valuation basis.
2. Reconcile orders, acceptance and invoices at line level.
3. Separate unbilled accepted supply from unperformed scope.
4. Remove overlap before combining commitments with actuals and forecasts.
5. Resolve stale balances through supported amendments, credits or closure decisions.