Why a converted bank statement doesn’t add up (and how to fix it)

By Kayabyte · Last updated 28 October 2026

You converted a PDF bank statement to CSV or Excel, added up the rows, and the total doesn’t match the statement. Or you imported it into accounting software and the balance is off by a few dollars, or exactly double a transaction. This is the most common problem with statement conversion, and it almost always has one of a small set of causes. Here is how to find yours.

1. Do the check first

Every statement is a closed system: opening balance plus all credits, minus all debits, equals closing balance. If the statement has a running balance column, each row must also equal the previous balance plus that row.

In your spreadsheet, put the signed amounts in one column (money in positive, money out negative).
Sum it.
Add the opening balance.
Compare to the closing balance. The difference is your clue.

If the statement has a running balance, add a column that recomputes it row by row and subtract the printed one. The first row where the difference changes is where the error is. That turns a vague mismatch into one specific line.

2. Reading the difference

Difference equals one transaction amount. A row was dropped (or duplicated if the difference is the same amount with the opposite sign). Look for rows at page breaks, and rows with an empty amount cell because the description wrapped onto two lines.

Difference equals twice an amount. A sign is flipped. Common with credit card statements, where purchases are printed as positive, and with “CR” and “DR” suffixes or trailing minus signs (45.00-).

Difference is tiny (cents). Rounding or a misread digit: a scan that read 8 as 3, or a comma and period swapped.

Difference is a large round number. A thousands separator problem. 1.234,50 read as 1.23450, or a European amount treated as text and left out of the sum.

Difference equals an interest, fee or “brought forward” line. Summary lines were included as transactions, or real fee rows were left out.

Balances are right but totals are wrong across months. Your statement period may start with a transaction that posted on the previous statement, so the opening balance belongs to a different date than your first row.

3. Fixing it by hand

Jump to the first row where the running balance goes wrong and compare it to the PDF line by line.
Search for rows with a blank amount, text in an amount cell, or a date in the wrong format.
Delete repeated page headers and subtotals (“Total this page”, “Balance carried forward”).
Re-merge descriptions that wrapped.
Re-check dates: 03/04 means different days in different countries, and mixing formats won’t change the sum but breaks ordering and monthly reports.

Do not fix a mismatch with a balancing row. It makes the sheet add up and hides the error you were looking for.

4. Where Balanced helps

Balanced is a Mac app we make, built around exactly this check. It reads text PDFs, scanned PDFs and photos (using Apple’s on-device text recognition) and CSV or TSV files, from any bank, with headers and months in 10 languages. In the preview you see the table it found and can change each column’s role (date, description, debit, credit, amount, balance), the date order and the sign handling, which fixes most flipped signs and swapped dates before they reach the export.

Then it runs the totals check: opening balance plus transactions must equal the closing balance, and the running balance per row when the statement has one. If it doesn’t add up, Balanced says where, with the rows involved and the difference, and exporting then needs an explicit “Export anyway”. So a mismatch can’t quietly slip into your accounting software.

There is no AI guessing: every number is copied from your statement and checked. Everything is processed on your Mac and never leaves it.

Limits: a conversion can still fail on odd layouts, so check the preview against your PDF; heavily skewed or low-quality scans can lose digits; for a password-protected PDF, unlock the PDF first with the password from your bank. We can’t promise every bank works, and a check passing means the numbers match the statement, not that your bookkeeping is correct.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file, so you can see whether your statement balances before paying. Pro is USD 59 per year or USD 7.99 per month, up to 3 Macs, cancel anytime, with a 30-day money-back on the first payment. See pricing and help. macOS 14 or later.

5. When the statement itself is the problem

Occasionally the bank’s own statement doesn’t foot: pending items, a correction posted later, or a statement that begins mid-cycle. If your hand check and Balanced agree with each other but not with the bank’s printed closing balance, ask the bank for a corrected statement rather than adjusting your data.