Excel formula guide

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.

Excel cell and column layout
Cell or columnUse
B1Opening balance: 1,000.00
ADate
BDescription
CWithdrawal, as a positive value
DDeposit, as a positive value
ESigned Amount, if you need one combined column
FCalculated 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.

Invented example with a 1,000.00 opening balance
DateDescriptionWithdrawalDepositSigned AmountRunning balance
03/04/2026Studio supplies125.50—-125.50874.50
05/04/2026Project credit—300.00+300.001,174.50
07/04/2026Service charge62.00—-62.001,112.50
Closing check: 1,000.00 + 300.00 − 187.50 = 1,112.50. Compare every calculated balance with the printed running balance when available.

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.