To scan bank statements into QuickBooks, scan each paper statement to a PDF at 300 dpi in grayscale, one statement per file, then turn the pages into a QBO or CSV file and check every amount against the paper. A scan is harder to read than a bank-made PDF, so the checking step matters most.
Scanned bank statements versus downloaded PDFs
A downloaded PDF holds the exact characters the bank printed, while a scan is only a picture of paper. Software has to recognize each digit from the pixels before it can use it, and that guess can be wrong. This is the main reason scanned statements need more care than PDFs from online banking.
Open a downloaded statement and try to select a line of text with your cursor. If the text highlights, the file carries real characters. Open a scan and the same drag usually selects nothing, or selects the whole page as one block. That one test tells you which kind of file you have.
The difference shows up in the errors you can expect:
- A digital PDF rarely misreads a number. Its problems are layout problems, such as a description that wraps onto two lines.
- A scan can turn a 3 into an 8, a 1 into a 7, or drop a decimal point or a minus sign. The result still looks like a plausible number, so nothing flags it.
- A photo taken with a phone is a scan with extra trouble: shadows, a tilted page and a curled corner.
Paper statements are common for small businesses and freelancers. An old savings account that never went online and a box of last year's statements from before you switched banks all arrive this way. Nothing is wrong with having paper. The point is only that a scan adds one more step where a mistake can enter, so plan to check the result instead of trusting it.
QuickBooks Online itself says it can take statement PDFs and images (JPG, PNG or HEIC) and extract the data with AI, as described on Intuit's page on uploading transactions manually. Intuit's page also shows you the extraction beside the original so you can edit it. Whichever route you take, the checking routine below applies, because a person has to confirm the numbers.
Which scanner settings keep statement numbers readable?
Scan at 300 dpi in grayscale and save a PDF, with one statement per file. Those settings keep small print sharp without making the file huge. Color adds size and no accuracy on a black-on-white statement, and a low resolution blurs digits into each other, which is where misreads come from.
Here are the settings, with the reason for each. Treat the numbers as sensible starting points, not a standard that any software requires.
| Setting | Use this | Why |
|---|---|---|
| Resolution | 300 dpi | Statements use small type. At low resolution, 3, 5, 6 and 8 start to look alike. |
| Color mode | Grayscale | Keeps shading and light print legible. Pure black and white can erase faint digits. |
| File type | PDF, not a photo | A scanner PDF keeps pages flat and in order. A phone photo adds tilt and shadow. |
| Files | One statement per file | Keeps months apart so a file maps to one account and one period. |
| Page order | Page 1 first, every page | A missing back page can hide a whole run of transactions. |
| Duplex | Scan both sides | Some statements print on both sides of the sheet. |
Setting up the page
Settings are half of it. Before you press scan, flatten the staple edge and clear the glass. A smudge or a dust speck can sit on top of a decimal point and look like a different number. If your scanner has an automatic feeder, check that it pulled in one sheet at a time, since a double feed skips a page without any message.
Leave the scanner's automatic "enhance" and "sharpen" options off if you can. They help photographs and sometimes hurt text, thickening a thin line until a 1 reads as a 7.
What to do with a phone
A phone can work when no scanner is within reach. Lay the page on a dark, flat surface in good light, hold the phone directly above it, and fill the frame with the page. Use your phone's built-in scan mode instead of the camera app, because it straightens the edges for you. Then check the file at full zoom before you move on. If you can't read a number with your own eyes at 200 percent, software won't read it reliably either.
Checking a scanned bank statement line by line
Checking means comparing the numbers you ended up with against the paper. Start with the totals, then confirm the count of lines, then spot-check the amounts. The totals catch a misread digit or a missing line quickly, and the line check finds the exact row that is wrong.
Step 1: Match the opening and closing balances
Read the opening and closing balances off the paper and compare them with what the converted file or QuickBooks shows. If either is wrong, stop and fix the scan. Every other number rests on these two.
Step 2: Add up the money
Opening balance, plus all deposits and credits, minus all withdrawals and debits, must equal the closing balance. Most statements print summary totals for deposits and for withdrawals. Compare those two printed totals against the sums of your converted rows. A mismatch of a single digit means a misread number, and a mismatch of a whole transaction means a missing line.
The check after a conversion works the same way, and how to check the QBO file against the PDF totals walks through it for a QBO file.
Step 3: Work out the gap
When the totals disagree, the size of the gap points at the cause. Here is an example with made-up figures.
| Gap between paper and file | Likely cause |
|---|---|
| 5.00, 50.00 or 500.00 | A digit read as another, such as 3 for 8 |
| Exactly the amount of one line | A missed or doubled transaction |
| Twice the amount of one line | A sign read wrongly, so a debit became a credit |
| Several small gaps | A decimal point lost on a few lines |
Step 4: Count the lines and check the dates
Count the transactions on one printed page and compare that with the rows from the same page. Then scan the date column for anything outside the statement period, since a date can shift by a digit and still look valid. A date such as 03/18 that becomes 03/13 will not fail anything. It will quietly sit in the wrong day.
A worked example
Say a paper statement shows an opening balance of 4,200.00, deposits of 3,150.00, withdrawals of 2,873.45 and a closing balance of 4,476.55. Your converted file adds up to a closing balance of 4,478.55. The gap is 2.00, which suggests one digit in a withdrawal was read as a different digit, for example 86.42 turning into 84.42. Go down the withdrawals comparing each against the paper, and the odd one shows up quickly. All the figures here are examples.
Faded or handwritten statements: when to type them in
Typing is the better choice when the page is too poor for software or your eyes to read with confidence. That includes faded thermal printing, a photocopy of a photocopy, handwriting on top of the transactions and pages cut off at the margin. The test is simple: if checking would take longer than keying, key it.
Some signs that a statement belongs in the typing pile:
- You squint at a number and cannot say which digit it is.
- Handwritten notes or highlighter cover the amount column.
- The page was folded and a crease runs through a row of figures.
- Only a few transactions exist. Ten lines are quicker to enter than to scan, convert and verify.
For a short statement, enter the lines directly in QuickBooks. Adding a transaction by hand in QuickBooks Online is a separate topic, and you can treat each statement line as one entry. Keep the paper beside you, tick each line as you enter it, and finish by comparing your running total with the closing balance.
A middle path exists for pages that are mostly fine. Convert the clean pages and type the rows from the damaged one. Then run the same total check on the combined result. Mixing the two methods is fine as long as you check the end result against the printed closing balance.
Do not guess. If a number cannot be read, a bank copy is better than a guess, which leads to the next section.
Can you ask the bank for digital copies of old statements?
Yes, and it is often the best fix. Most banks let account holders download past statements as PDFs from online banking, and a downloaded PDF avoids the scanning errors above. If you still receive paper statements, a bank can usually tell you how to switch to online statements and how far back they go.
Ask the bank, or look in the statements section of your online account, for these:
- Statements as PDFs for the months you only have on paper. A bank-made PDF carries real characters, so it converts far more reliably than a scan.
- A transaction download for recent months. For a bank that offers one, a QBO file skips the PDF altogether. Downloading a QBO file from Bank of America shows what that looks like and where the window ends.
- A copy of a statement that went missing. Branches and phone support can often supply one, sometimes for a fee, so ask what it costs before you request many.
Credit card issuers work the same way. A card statement is usually available online even when the paper version came by post, and importing an American Express statement into QuickBooks covers one such case.
If you also hold paper checks or deposit slips, those are a different job. Check images are not statements, and importing checks into QuickBooks Online with check numbers explains how to keep the numbers.
SimpleBankConvert is built for digital PDF statements, and it tells you when a statement can't be read cleanly instead of handing back a file with mistakes. It is still in early access, so you can join the early access list for now.