FinanceTier 120 minintermediate

Cash Flow Running Balance

Build a running balance down a column of cash inflows and outflows.

What you will learn

• Write a running-total formula that adds the current row to the previous running balance
• Explain why a running balance formula must be row-relative, not anchored to one fixed cell
• Recognise a negative running balance as a genuine cash-flow warning, not an error to hide

Excel skills

Cumulative SUM · Running Calculations

The task

Row 2 already holds the opening balance (59859). Starting at D3, build a running balance: each row's balance is the row above's balance plus that row's amount.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free