What Is an Opening Balance in Inventory?

An opening balance is the on-hand quantity of a product at the start of a planning horizon, the first entry a projected inventory roll-forward carries into every later period. It is the seed of the whole projection. Every future balance you read is built by starting from this number and then playing supply and demand forward.

This entry defines the opening balance and shows how it reads inside EDGEBIC by User Solutions. For the wider index of terms, see the manufacturing glossary; for the record it is drawn from, see what is an inventory ledger; and for the forward series it seeds, see projected available balance.

How it works

The clearest analogy is a cash-flow forecast. Your bank balance on the first day of the month, before any salary or bills post, is your opening balance. Every later day's balance is that figure plus what came in and minus what went out. Inventory works the same way, with stock instead of cash.

The opening balance is not typed fresh into each projection. It is read from the inventory ledger as the sum of every entry dated before the planning window begins. When a product is first created, its starting stock is recorded as a dedicated opening-balance ledger entry, so the audit trail has a known first point. From then on, receipts push the running balance up and issues push it down. Whatever the ledger sums to at the horizon's start is the opening balance.

This matters because it keeps the projection anchored to reality rather than to a remembered number. If a stock movement posted after you first recorded the product, the opening balance already reflects it, because the ledger is the single source of truth.

A concrete example

A product is created with 200 units of starting stock. That 200 is written as an opening-balance ledger entry, and the running balance reads 200. Over the following week, a job pulls 80 units from stock to satisfy an order, so an issue of minus 80 posts and the balance drops to 120. A cycle count then finds 5 more than the system thought, so an adjustment of plus 5 posts and the balance reads 125.

Now you run a projection whose window opens after all three movements. The opening balance it uses is 125, the ledger sum as of that date, not the original 200. From there the projection rolls forward: each bucket opens at the prior bucket's close, adds any scheduled receipts, and subtracts that bucket's demand. The opening balance did its one job, which was to give the roll-forward a truthful place to start.

How EDGEBIC uses it

In EDGEBIC, the opening balance is the first figure in the inventory calendar's projected available balance roll. The calendar takes the ledger sum before the window as the opening figure, then carries it forward across the horizon you chose, whether the buckets are days, weeks, or custom periods.

When a product is first set up, its starting stock is posted as an opening-balance transaction in the ledger, one of the recognized transaction types, so the balance history has a clean origin. Because the projection reads the ledger rather than a stored snapshot, the opening balance is always current: post a receipt, an issue, or an adjustment, and the next projection opens from the new sum with no extra step.

To follow what moves the balance after it opens, read what is an inventory issue transaction and EDGEBIC inventory ledger explained. To see the full forward roll worked out with numbers, continue with projected available balance.