The running balance on a PDF bank statement is the account total the bank printed after each transaction. It lets you test a conversion row by row: start from the opening balance, apply each converted amount, and your total should equal the printed figure on every line. The first row where it doesn't is where the error sits.
What the running balance column on a PDF statement records
The running balance column shows what the account held right after each line posted. The bank works it out by taking the previous balance and adding or subtracting that line's amount. So every printed balance depends on every line above it, which is what makes it useful for checking.
Look at the column as a chain. The first link is the opening balance at the top of the statement. Each transaction moves the chain up or down, and the last link should equal the closing balance printed in the summary. Because the bank produced the chain from its own records, it is a second copy of the activity, written in a different form.
A conversion copies the amounts but usually not the balances. That is fine. You keep the PDF beside your converted rows and use its balances as the answer key.
Checking converted rows against the running balance
To check a conversion, recompute the balance yourself. Take the opening balance, apply the first converted amount, and compare your result with the first printed balance. Keep going down the rows. While the two figures agree, every row so far is right. The first disagreement marks the problem row.
Here is an example with made-up figures. The opening balance is 1,000.00, and the converter has copied the 45.00 card purchase twice.
| Row | Description (example) | Converted amount | Your running total | Printed balance |
|---|---|---|---|---|
| 1 | Deposit, client payment | 600.00 | 1,600.00 | 1,600.00 |
| 2 | Card purchase, stationery | -45.00 | 1,555.00 | 1,555.00 |
| 3 | Card purchase, stationery | -45.00 | 1,510.00 | (no such line) |
| 4 | Phone bill | -130.00 | 1,380.00 | 1,425.00 |
| 5 | Service fee | -10.00 | 1,370.00 | 1,415.00 |
Rows 1 and 2 agree. Row 3 has no partner on the statement: the PDF goes straight from the stationery purchase to the phone bill. From that point on, your total sits 45.00 below every printed balance. A gap that appears at one row and stays the same size afterwards means the converted file holds an extra 45.00 line. Delete the duplicate and every remaining row lines up.
A spreadsheet makes this quick. Put the opening balance in one cell, add a column that adds each amount to the cell above, and a second column that subtracts the printed balance. Any row where the difference is not zero is worth a look.
Which conversion errors does a running balance expose?
A running balance exposes any error that changes money: a missed row, a doubled row, a wrong sign or a misread digit. Each one leaves its own mark in the gap between your total and the printed balance, so the size of the gap tells you what kind of mistake to look for.
- Missed row: your total is off by that row's amount, from that point on.
- Doubled row: the same, in the other direction, as in the table above.
- Flipped sign: the gap is twice the row's amount. This usually means a figure from the money-out column was copied as positive. How debit and credit columns become one signed amount explains which way each should go.
- Misread digit: the gap is an odd figure such as 50.00 or 0.50, typical of a 3 read as an 8 on a scan.
What the balance cannot catch is an error that leaves the money alone. A row with the wrong year still adds up. A statement printed as "01/04" in a December to January period can be stamped with the wrong year and pass this check, so fixing PDF bank statement dates without a year is a separate step. A wrong payee name also adds up, so read the description column too.
Statements with daily or missing running balances
Not every statement prints a balance after each line. Some print one balance per day, after the last transaction of that day. Others, credit card statements in particular, print none at all. You can still check them, but the check gets coarser, so a failure narrows the search to a day or a statement rather than a row.
With a daily balance, add up all of a day's rows and compare the result with that day's printed figure. A mismatch tells you which day to read again, which on most business accounts is a handful of lines.
With no running balance, fall back on the statement totals. Previous balance, plus purchases and fees, minus payments and credits, should equal the new balance. Card statements also tend to group lines into separate tables, which makes it easy to skip one. The post on importing an Amex statement into QuickBooks walks through a card statement where this statement-level check is the only one available.
Should the running balance column go into QuickBooks?
No. A QuickBooks bank upload takes the date, the description and the amount for each row, and works out its own balance from them. Leave the running balance out of the import file. Keep it in your checking sheet and on the PDF, where it does its job.
Once the rows are in, QuickBooks shows a balance for the account. Compare that figure on the statement's closing date with the closing balance on the PDF. If they agree, the import holds the same activity as the statement.
The description column deserves more attention than the balance at this stage. It is the text you match against when you assign each line to a payee, and that work goes faster when the payees already exist in your vendor list. If you are setting up a new company, importing vendors into QuickBooks Online before the bank lines saves a lot of one-by-one matching.
SimpleBankConvert is being built to turn a statement PDF into a CSV or QBO file, and to tell you when a statement can't be read cleanly instead of passing on a file with mistakes. It is not open yet; you can ask to be told when it is.