What Is a Running Balance, and Why Does It Matter?

What a running balance is, a worked example, the Excel formula to calculate one, and what it means when a converted statement's balance won't tie out.

A running balance is the amount in the account immediately after each transaction, printed on the same line as that transaction. Read down the column and you can see what the account held at every point in the period, not only at the start and the end.

It is also the most useful column on a bank statement for checking a conversion, and the one conversion tools most often drop.

What it represents

Each figure is the previous balance moved by that line's transaction. Row by row, the column satisfies one equation:

previous balance − debit + credit = current balance

A debit (money out) lowers the balance and a credit (money in) raises it. The chain starts from the opening balance, carried over from the previous statement, and ends on the closing balance, which becomes the next statement's opening balance. A balance below zero means the account is overdrawn; banks print it with a minus sign, in brackets, or with DR after it.

This is arithmetic the bank's own systems enforce, which makes the column a check rather than decoration: one pass down it tests every amount against a figure the bank wrote down independently. When extracted data disagrees with it, the extraction is almost always what went wrong. Almost: banks do occasionally misprint a figure or print a transaction twice.

A worked example

Here is a short, made-up statement for a current account. It opens at 1,200.00, and each line moves the balance by its debit or its credit:

Date	Description	Debit	Credit	Balance
1 Mar	Opening balance			1,200.00
3 Mar	Card payment, corner shop	45.60		1,154.40
5 Mar	Salary, Example Ltd		2,500.00	3,654.40
7 Mar	Rent, standing order	950.00		2,704.40
10 Mar	Electricity, direct debit	82.35		2,622.05
12 Mar	Refund, online shop		19.99	2,642.04

Take the rent line. The balance before it was 3,654.40, 950.00 went out, and 3,654.40 − 950.00 = 2,704.40, which is the figure printed beside it. Every line works the same way.

The same arithmetic holds across the whole statement: opening balance + total credits − total debits = closing balance. Here that is 1,200.00 + 2,519.99 − 1,077.95 = 2,642.04, the last figure in the column.

How to calculate a running balance in Excel

Put the statement in columns A to E as above, with headings in row 1, the opening balance in row 2 and the transactions from row 3 down. In F2, enter =E2 to start from the opening balance. In F3, enter:

=F2-C3+D3

Then fill it down to the last row. Each cell takes the balance on the row above, subtracts that row's debit and adds its credit; a blank counts as zero, so no IF is needed. In the example, F7 comes out at 2,642.04, the printed closing balance. With one Amount column in C and money out as a negative number, use =F2+C3 instead.

To check the printed balance against the one you rebuilt, put this in G3 and fill down. Every row should show TRUE:

=ROUND(F3,2)=ROUND(E3,2)

When a converted statement's balance does not tie out

If the rebuilt balance and the printed one disagree, something between the PDF and the spreadsheet went wrong, and the first FALSE is where to look. On a 400-row file, that turns a search through every row into a look at one.

The pattern after it says what happened, and it depends on which check you ran. The rebuilt running total above carries every error forward to the end. A row-by-row check, comparing each printed balance with the printed balance above it, does not:

=ROUND(E2-C3+D3,2)=ROUND(E3,2)

What went wrong	Rebuilt running total	Row-by-row check
An amount misread, or put in the wrong column	FALSE from that row to the end	FALSE on that row only
A printed balance misread	FALSE on that row only	FALSE on that row and the next
A row missing	FALSE from the gap to the end	FALSE on the row after the gap
A row read twice	FALSE from the copy to the end	FALSE on the copy only
A row lost or repeated at each page break	FALSE from the first page break on	FALSE at each page break
The wrong decimal separator	FALSE almost everywhere	FALSE almost everywhere

That is why the row-by-row check is the better one for finding faults: each shows up as one or two rows rather than as everything below it.

Converting a PDF statement with the bank statement PDF to Excel converter runs this row-by-row check for you. The workbook's Completeness sheet checks every row against the balance printed beside it, and either says every row agrees or lists the rows that disagree, each with how far the balance moved, what that row's figures say, and the difference. It also checks page totals and summary figures where the statement prints them. A statement with no running balance cannot be checked this way, and the workbook then shows no running-balance result rather than a pass.

What the balance chain cannot prove

A chain that holds proves the amounts it covers are right. It does not prove the file is complete. A row missing from the middle breaks it, as the table shows. Rows missing from the very end leave nothing after them to disagree, which is why a lost last page is the usual case, and rows missing from the very start are caught only if the opening balance line survived to be checked against. Missing rows that net to zero, such as a payment and its reversal printed one after the other, leave no trace in the balance either.

So pair the chain with two comparisons against the statement's own summary: the file should start from the printed opening balance and end on the printed closing balance, and its debit and credit totals should match the printed totals where the bank prints them. The chain proves the amounts; the totals prove nothing is missing. Balance-chain reconciliation walks through both checks.

When banks omit it

Situation	Balance printed?	Verification available
Most current and savings accounts	Every row	Full chain
HSBC UK, First Direct	Last row of each day	Day-level chain
Credit cards	Not at all	Totals comparison only
US sectioned statements	Often not	Totals comparison only

Without a balance column, only the totals comparison is left. It tells you whether something is missing, but not which row.

Frequently asked questions

What does running balance mean on a bank statement?

The balance in the account immediately after that line's transaction: the balance on the line above, minus any money out, plus any money in.

Is the running balance the same as the available balance?

Not always. A statement's running balance counts transactions that have posted. The available balance in a banking app can also take off pending card payments or holds, and some banks add an overdraft limit to it, so the two can differ on the same day.

Why do some converters drop the balance column?

It is often positioned differently from the other numeric columns, so extraction strategies tuned for the description column lose it. It is also, wrongly, treated as redundant.

What does it mean if only one row fails?

It depends on the check. Comparing each printed balance with the one above it, one failing row is usually a misread amount on that row, a row missing just before it, or a row read twice; a misread balance fails two rows in a row. With a running total rebuilt from the opening balance, one failing row is a misread balance, because a wrong amount would carry into every row after it.

Can I rebuild the balance if it was lost?

Yes, if you know the opening balance: use the running-total formula above. The rebuilt column cannot check the rows it was computed from, but its last figure should equal the closing balance printed on the statement. If it does not, something is missing or misread.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.