Turning a PDF bank statement into a spreadsheet saves hours. But no converter is perfect. It can skip a row that runs onto the next page, or misread a number on a scan. The worst part: the file still looks fine. You only find out when the books don't reconcile.
This guide gives you a 2-minute check that catches these mistakes before they reach QuickBooks, Xero or your spreadsheet.
What can go wrong
- A missing row. A line that wraps, or sits at the very top or bottom of a page, gets dropped.
- A misread number. On a scan, a 3 becomes an 8, or a decimal point goes missing.
- A wrong sign. Money out shows up as money in.
- A doubled row. The same line is read twice.
Each one makes your numbers wrong, and none of them look wrong at a glance.
The 2-minute check
You need the PDF statement and your converted file.
- Find the start and end balance on the PDF. They are usually at the top or in a summary box.
- Add up the amounts in your file. In Excel or Google Sheets, use =SUM() on the amount column.
- Do the math: start balance + your sum should equal the end balance.
- Count the rows. Compare it with the number of lines on the statement, if the statement shows one.
If the math works, no row is missing and no amount is wrong. If it's off, look for the size of the gap. A gap that matches one line's amount usually means that line is missing or doubled.
Let the converter do it for you
MyBankToExcel does this check for you. When your statement shows a balance on each line, it checks that the balances add up before you download:
- It adds up: you see the start, the money in, the money out and the end, and that they match.
- It doesn't: you see a plain warning above the Download button, with the numbers, so you know to look before you use the file.
For a scan, you also see how sure the reader was. If parts were hard to read, it says so.
When the check says something is off
- Look at the first and last rows of each page. That is where rows most often go missing.
- Look at big amounts on a scan. Compare them with the PDF.
- Try a clearer copy. Download the statement again from your bank's website. A PDF from the bank reads better than a scan.
Then reconcile the statement as usual.
Frequently asked questions
What is a balance check?
Take the starting balance, add the money in, and take away the money out. The answer should be the ending balance on the statement. If it isn't, a row is missing or a number was read wrong.
My statement has no balance on each line. Can I still check it?
Yes, with the totals. Add up the money in and the money out in your file, and compare them with the totals printed on the statement.
Why are scans more likely to be wrong?
A scan is a picture. Reading it means guessing each letter and digit. A smudge can turn a 3 into an 8, and the file still looks normal.
Does MyBankToExcel do this check for me?
Yes. When your statement shows a balance on each line, it checks that the balances add up before you download, and tells you in plain words if they don't.