Running balance formula in Excel for a bank statement
Start with the confirmed opening balance and add each transaction in statement order. Use cumulative signed amounts, or cumulative deposits minus withdrawals when the statement has separate direction columns.
Set up the worksheet
Use the layout below for the formulas in this guide. Amounts are invented, and no currency is assumed. The formula assumes transactions run oldest to newest and the opening balance is immediately before the first transaction.
| Cell or column | Use |
|---|---|
| B1 | Opening balance: 1,000.00 |
| A | Date |
| B | Description |
| C | Withdrawal, as a positive value |
| D | Deposit, as a positive value |
| E | Signed Amount, if you need one combined column |
| F | Calculated running balance |
Confirm the date order, amount signs, and debit/credit labels from the source before entering formulas. Keep each row's date, description, and amounts together when sorting or rearranging data.
Formula for separate withdrawals and deposits
Assume positive withdrawals are in column C and positive deposits are in column D. In F4, enter the cumulative formula and fill it down the running-balance column:
=$B$1+SUM($D$4:D4)-SUM($C$4:C4)
The opening balance remains fixed at B1 while the transaction ranges extend as the formula is filled down. This is a running-balance formula for the stated cell layout. See Microsoft's current Excel running-balance instructions.
Formula when the statement already has signed amounts
If one signed Amount column uses negative values for withdrawals and positive values for deposits, put this in F4 and fill it down:
=$B$1+SUM($E$4:E4)
If you need to create the signed amount from positive withdrawal and deposit cells, enter =D4-C4 in E4 and fill it down. Do not convert an Amount column that is already signed, and do not add both the signed values and the split columns into one total. Microsoft explains the expanding range in its guide to running totals in Excel.
Synthetic worked example
The dates, descriptions, and figures are invented. The example uses DD/MM/YYYY and positive values in the separate Withdrawal and Deposit columns.
| Date | Description | Withdrawal | Deposit | Signed Amount | Running balance |
|---|---|---|---|---|---|
| 03/04/2026 | Studio supplies | 125.50 | — | -125.50 | 874.50 |
| 05/04/2026 | Project credit | — | 300.00 | +300.00 | 1,174.50 |
| 07/04/2026 | Service charge | 62.00 | — | -62.00 | 1,112.50 |
Confirm the date convention before interpreting values such as 03/04/2026: it means 3 April in DD/MM/YYYY and March 4 in MM/DD/YYYY. Read the date-format guide if the source is ambiguous.
Review the result against the statement
- Use the opening balance printed for the same account and period. Do not substitute the balance after its first transaction.
- Preserve the transaction row order and check each calculated balance against the source, not only the final total.
- For a newest-first statement, do not apply an oldest-to-newest formula without confirming the date order and rearranging complete rows in a separate copy.
- If a value differs, check the direction, sign, decimal separator, opening balance, and omitted or duplicate rows. Do not change signs or add an adjustment just to force a match.
- A matching final balance is a useful check, but it cannot prove that every row or description is correct. Compare the rows with the original source.
For statement conversions, use the balance-check guide to investigate discrepancies, and the amount-sign guide before changing signs. ExtractMint is in beta; no bank-specific format has been independently validated against real statements.