B5.1 Connect a bank or upload a CSV
B5.2 Categorize the bank feed
B5.3 Match, split, transfer and spot duplicates
B5.4 The AI banking page: accept, edit or reject suggestions
B5.5 Automatic matches and the Needs attention list
B5.6 Statement extraction: turn a PDF statement into transactions
B5.7 Why the bank and your books disagree
B5 Skill check: Banking basics

Step 1 of 6

New words in this lesson

Bank statement

The bank's monthly list of every deposit and withdrawal, with opening and closing balances.

Transposition error

Two digits typed the wrong way round, such as 1,320 entered as 1,230. The difference always divides evenly by 9, which is a quick way to spot one. Example: $1,320.00 − $1,230.00 = $90.00, and 90 ÷ 9 = 10.

Look up any other word in the glossary

From PDF to transactions

Some accounts can't connect to QuickBooks. Instead, you can upload the PDF and let QuickBooks read the transactions from it. Newer versions use AI for this. It's fast, but it can misread numbers, so check what was extracted before you add it.

Here's an old account's October statement, and what was extracted from it:

Date	Bank statement says	Extracted from the PDF
10/02	DEPOSIT 1,084.50	DEPOSIT 1,048.50
10/05	CHECK 1101 −230.00	CHECK 1101 −230.00
10/09	SERVICE FEE −15.00	SERVICE FEE +15.00
10/12	CHECK 1102 −415.75	(nothing)
10/20	DEPOSIT 640.00	DEPOSIT 640.00

Compare the number of lines and the totals with the statement.
Look for digits swapped, the wrong sign (money in instead of out), and lines that were missed.
The starting balance plus the extracted lines must equal the statement's ending balance.

BookkeeperReady is an independent training product. It has not been approved, sponsored or endorsed by Intuit Inc. and is not affiliated with it. Intuit and QuickBooks are registered trademarks of Intuit Inc.