Balance Sheet Planning: Building a Planned Balance Sheet Step by Step (2026)

Building a planned balance sheet means deriving the company’s future asset and capital structure from its earnings plan. It is not produced by estimating balance sheet items but calculated: fixed assets follow from capital expenditure and depreciation, receivables and inventory from revenue and payment or inventory days, equity from the opening balance plus earnings less distributions. Cash is the closing item that falls out of the cash flow statement. That makes the planned balance sheet the connecting piece without which no earnings plan can produce a statement about solvency.

In practice it is the most frequently omitted part of a plan. Almost every company builds a planned P&L, many build a liquidity view, but the balance sheet in between is missing. The result is a plan that says what will be earned but not where the money sits.

Why it is not optional

The reason is mechanical. Balance sheet items sit between earnings and the bank balance: revenue first increases receivables and only raises cash once the payment terms have elapsed. A material purchase increases inventory before it reaches the P&L as an expense. Capital expenditure hits liquidity immediately but the P&L only across the useful life.

Without that intermediate layer, the only remaining assumption is that earnings and cash flow are identical. For a growing company that is systematically wrong, because growth absorbs working capital: revenue rises, receivables and inventory rise with it, and cash falls even as the P&L looks better than last year.

The four blocks and how they are derived

Cash is deliberately absent from that table: it is not an item to be planned but the outcome. Estimate it and you have inverted the logic and lost the balance sheet’s control function.

Step by step

1. Start from the planned P&L. There is no planned balance sheet without an earnings plan. Revenue, material cost, personnel cost, depreciation and interest are the inputs.
2. Derive turnover days from history. Days sales outstanding, inventory days and days payable outstanding can be calculated from the last closed years. These ratios are the actual bridge: they translate P&L quantities into balance sheet positions.
3. Roll forward fixed assets. Apply the capex plan, calculate depreciation by useful life, and net both against the opening balance. The separation matters: depreciation affects the P&L, the payment affects cash flow, and they happen at different times.
4. Build the liabilities side. Roll equity forward from earnings, financial liabilities per the amortisation schedule, provisions as circumstances require, trade payables from days payable outstanding.
5. Determine cash as the residual. From the indirect cash flow statement: net income plus depreciation, adjusted for the change in working capital, less capex, plus or minus financing.
6. Run the controls. See the next section.

Steps 2 and 3 are one-off modelling work. After that, the planned balance sheet is no longer a separate document but a consequence of the earnings plan.

The controls every balance sheet plan needs

A planned balance sheet without automatic checks is a liability, because errors in formula chains go unnoticed until somebody outside the company recalculates them. Three controls are mandatory:

• The balance sheet identity. Assets equal liabilities and equity, in every planned period. A difference is not a rounding issue; it points to a missing or duplicated linkage.
• Cash reconciliation. The closing cash figure from the cash flow statement must match the balance sheet line. If they diverge, some movement is not represented in both statements.
• Equity roll-forward. Closing equity equals opening equity plus earnings less distributions. This control catches errors that survived the balance sheet identity because a mistake was booked twice.

Without those three as formulas inside the model, you are relying on visual inspection, and experience with organically grown spreadsheet models shows that does not hold.

Who requires a planned balance sheet

It is more than best practice. Under IDW S 11, the German going-concern assessment rests on integrated business planning comprising earnings planning, asset planning and liquidity planning, over a forecast period of at least twelve months. Asset planning here means precisely the planned balance sheet. A bank’s assessment of debt service capacity presupposes it too, because without balance sheet development there is no way to tell whether debt service can be covered from operations.

For managing directors of limited-liability entities, § 1 StaRUG adds a duty to monitor developments that could threaten the survival of the company on an ongoing basis. An early-warning system that watches the earnings trend but ignores capital tied up in the business will not detect the classic growth trap.

Why spreadsheets are especially fragile here

The planned balance sheet is where spreadsheet models tip over. Every linkage is a formula chain across several sheets, every timing shift an offset, and the three controls have to be built and maintained by hand. In the BARC Planning Survey 26, based on 804 respondents, specialised planning tools score 8.4 on the business benefits index for transparency and traceability against 4.7 for spreadsheet-based planning. For a statement whose purpose is to be verifiable by third parties, that is the decisive gap.

Outlook

Balance sheet planning was long the reason integrated planning was considered the preserve of larger companies: it is the most laborious part and the one that requires technical knowledge. Yet it is also largely standardisable, because the linkage logic between P&L, balance sheet and cash flow is not company-specific. What stays company-specific are the turnover days and the capex plan, which are assumptions rather than mechanics. The effort therefore shifts from building to deciding, and the planned balance sheet becomes reachable without a controlling department. How it fits into the wider model is covered in integrated financial planning.

Frequently asked questions

How detailed does a planned balance sheet need to be?

Considerably less detailed than the actual balance sheet. For steering purposes the main items suffice: fixed assets, inventory, receivables, cash, equity, provisions, financial liabilities, trade payables. More detail raises maintenance effort but rarely adds insight.

What periods should the balance sheet be planned in?

Monthly for the current and following fiscal year, then quarterly or annually. Monthly periods matter because working capital effects and capex payments occur within a year and disappear in an annual view.

Where do turnover days come from without historical experience?

From the last closed years: days sales outstanding as receivables divided by revenue times 365, and analogously for inventory and trade payables. With several years available, the trend is more informative than a single value. Industry benchmarks are a fallback, because payment terms are highly customer-specific.

What should you do when the planned balance sheet does not close?

Search systematically instead of plugging the gap. Typical causes are capex without a payment, a repayment without reducing the liability, depreciation without reducing the asset, or earnings not carried into equity. A “miscellaneous” balancing item displaces the error rather than fixing it.

Does a small company really need one?

If it is a limited-liability entity, uses debt, or is growing: yes, though how it is implemented depends on size and structure. The scope can be small; the linkage cannot be missing. A company with no debt and no growth can in practice manage with an earnings and liquidity view.