How to Build a Three Statement Forecast That Ties

A three-statement forecast is only useful when it can answer the operational questions behind the numbers: Can we make payroll on the 15th? What happens if a major customer pays 20 days late? Does a planned hire reduce runway, breach a covenant, or simply use cash already sitting in receivables?

To build a three statement forecast that answers those questions, start with reconciled history and preserve the accounting links between the income statement, balance sheet, and cash flow statement. A forecast that begins with an unverified P&L or treats cash as a plug may look complete while hiding the exact timing risk finance leaders need to manage.

What a three-statement forecast must prove

The three statements are not separate reports. They are one connected model viewed from three angles. The income statement measures performance over a period. The balance sheet records what the business owns and owes at a point in time. The cash flow statement explains why beginning cash changed to ending cash.

A model ties when each forecast period satisfies the core accounting relationships:

`Assets = Liabilities + Equity`

`Ending cash on the cash flow statement = Cash on the balance sheet`

`Net income flows into retained earnings, subject to dividends, owner distributions, and other equity activity.`

Those relationships are basic financial law, not presentation preferences. If they fail, the model has either omitted an operating event, double-counted one, or relied on a manual balancing entry that conceals the issue.

For small businesses, the most consequential links are usually working capital and financing. Revenue creates receivables when invoices are issued before cash arrives. Expenses create payables and accrued liabilities when bills are recognized before payment. Debt adds cash at funding, creates a liability, and reduces cash through principal payments. Depreciation lowers earnings but does not itself move cash. Every one of these mechanics must be represented once, in the correct period.

Start with a reconciled historical base

Do not forecast from a trial balance that has not been reconciled to bank activity, card feeds, processor settlements, loans, and other cash accounts. Historical errors do not disappear in a forecast. They compound across every projected month.

Establish a close through the latest actual period. Bank and card accounts should reconcile to $0.00. Open invoices should agree to accounts receivable. Unpaid vendor bills, payroll liabilities, tax balances, loan principal, deferred revenue, and fixed assets should have identifiable support. Every material balance should trace back to transactions, schedules, or source documents.

This step matters especially for payment processors. A business may record gross sales on the income statement, receive net settlement cash several days later, and carry fees or reserves in separate accounts. Treating the settlement as revenue corrupts revenue, accounts receivable, processor clearing, and cash timing at once. A proper opening balance sheet preserves the clearing account and its settlement schedule.

Historical actuals also reveal the drivers that a forecast needs. Measure invoice-to-cash collection behavior by customer or cohort, vendor payment cadence, payroll dates, sales-tax remittance cycles, processor settlement delays, loan amortization, and seasonal demand. Do not substitute a generic percentage when the business has observable transaction-level behavior.

Build the income statement from operating drivers

Forecast revenue from the mechanics that produce it. For a subscription business, use beginning customers, new bookings, churn, pricing, implementation timing, and revenue recognition rules. For a services firm, use signed backlog, utilization, bill rates, staffing capacity, and project start dates. For a commerce business, use unit volume, average selling price, returns, discounts, and channel mix.

Then forecast cost of revenue and operating expense according to their actual behavior. Some costs scale with sales, such as payment processing fees or fulfillment. Others are fixed until a deliberate decision changes them, including rent, core software, and leadership compensation. Payroll requires particular discipline because salary expense may be recognized evenly while cash leaves on specific pay dates, along with taxes and benefits.

Keep noncash expenses separate. Depreciation and amortization affect operating income and net income, but they are added back in an indirect cash flow statement. If you are using direct-method cash planning, their absence from bank cash movement should be explicit rather than implied.

Forecast the balance sheet before treating cash as an output

The balance sheet is where an operating plan becomes a cash forecast. Begin with the accounts that bridge earnings and receipts or payments.

Accounts receivable should be driven by invoice issuance and expected collection dates, not only by a single days-sales-outstanding assumption. DSO can be acceptable for a stable, diversified customer base. It is weak when one or two enterprise invoices determine whether payroll is covered. In that case, model the invoice, expected payment date, confidence range, and collection status directly.

Accounts payable should reflect vendor terms and payment practice. Businesses often pay some vendors on receipt, others weekly, and others only at month-end. Inventory, prepaid expenses, accrued payroll, sales tax payable, deferred revenue, and lease or debt obligations can each be material depending on the company. Include only balances that matter, but model every material one with a defined rule and source.

Fixed assets and debt deserve dedicated schedules. Capital expenditures create cash outflows and increase fixed assets. Depreciation reduces the asset over time and lowers income. Debt funding increases cash and debt principal. Principal repayments reduce both cash and debt, while interest expense affects earnings and cash without reducing principal. These schedules prevent common errors such as recording an entire loan payment as expense.

Build a three statement forecast through the cash bridge

Once the income statement and balance sheet schedules are in place, construct the cash flow statement. Under the indirect method, begin with net income, add back noncash expenses, then adjust for period-over-period changes in operating assets and liabilities. Add investing activity, financing activity, and any equity distributions to arrive at ending cash.

The sign logic is worth testing line by line. An increase in accounts receivable consumes cash because revenue has been recognized without collection. An increase in accounts payable provides cash because an expense has been recognized without payment. A decrease in deferred revenue consumes cash because services have been delivered against cash collected earlier.

Then link ending cash directly to the balance sheet. Do not type a cash balance to force the model to balance. A cash plug is an admission that the model cannot explain where cash came from or where it went.

A monthly three-statement model remains valuable for management reporting, lender discussions, and board planning. But monthly periods can hide a real liquidity event. A company can finish the month with positive cash while missing payroll on the 15th because receivables clear on the 28th. That is why a serious operating model pairs period-based statements with a day-level direct cash forecast.

Add direct cash timing and scenario controls

Direct cash forecasting models actual expected inflows and outflows: invoice collections, processor settlements, payroll batches, vendor payments, tax withdrawals, debt service, rent, and planned capital purchases. It does not derive cash backwards from net income and broad working-capital assumptions.

Use the three-statement forecast for financial coherence and use the direct cash forecast for timing control. The two views should reconcile over their shared horizon. If the direct cash plan says a customer payment arrives Friday while the accounts receivable schedule assumes collection next month, the discrepancy should be visible, attributable, and resolved.

Scenario modeling should modify named drivers, not overwrite outputs. A hiring scenario should add start date, compensation, employer taxes, benefits, equipment, and payroll timing. A delayed collection scenario should move specific invoices and show the effect on accounts receivable, cash, runway, and any borrowing need. A price increase may improve revenue, but its cash effect depends on billing terms, renewal dates, churn response, and collections.

Shekl applies this discipline by maintaining a reconciled ledger alongside direct-method cash visibility, so a scenario can be traced through the transactions, rules, statements, and projected cash dates that support it.

Test the forecast like a control system

A forecast deserves the same controls as the accounting records beneath it. For every projected period, test that the balance sheet balances, ending cash agrees across statements, retained earnings rolls forward correctly, and debt principal agrees with the debt schedule. Compare forecasted cash receipts and disbursements with the direct cash view.

Create variance reviews as actuals arrive. Separate timing variance from amount variance. If an invoice was paid late but in full, the revenue forecast may be correct while the cash timing rule needs revision. If gross margin misses because shipping costs changed, update the underlying cost driver rather than merely adjusting the next month’s total.

The goal is not a forecast that appears precise to the dollar six months out. It is a controlled financial system that states its assumptions, preserves evidence, and becomes more accurate as actual activity replaces projected activity. When the model can show exactly why cash changes and what action changes the outcome, it becomes an operating instrument rather than a spreadsheet ritual.