Bank statement PDFs to CSV for QuickBooks

When the bank only gives you a PDF, QuickBooks can't read it. RapidStatements turns the statement into a CSV you can map in QuickBooks' import, and checks that the rows add up to the statement's closing balance first.

How it works

1. Upload the statement PDF and download the CSV.
2. QuickBooks reads 3- or 4-column files, so delete the Account and Balance columns to keep Date, Description, Debit and Credit.
3. In QuickBooks Online, go to Bank transactions, open the Link account menu and choose Upload from file.
4. Pick the QuickBooks account, match Date, Description, Debit (money out) and Credit (money in) to its fields, then choose the transactions to import.

QuickBooks steps and limits are from Intuit's help article on uploading bank transactions.

Want to see the output first? See a sample result, with the Excel and CSV to download.

FAQ

Can I import the CSV into QuickBooks as it is?

It's a CSV you can map in QuickBooks' import, not a file in QuickBooks' own layout. It has six columns (Account, Date, Description, Debit, Credit, Balance), dates as YYYY-MM-DD, and a blank cell where a row has no debit or credit. QuickBooks recommends dd/mm/yyyy dates, so if its import doesn't read the dates, change the Date column's format in Excel first.

Is there a limit on how much QuickBooks takes at once?

Intuit's limit is 1,000 lines and 350 KB per upload. For a long statement, split the rows over a few uploads.

Do you connect to QuickBooks directly?

No. You download the CSV and upload it in QuickBooks yourself, so nothing is sent to QuickBooks from our side.