Convert a bank statement to QuickBooks
Drop a PDF statement below and download a QBO file — the format QuickBooks imports directly, with an account, a currency, and a stable id on every transaction so nothing arrives twice.
This is the route for the transactions a bank feed cannot reach: a closed account, a period older than the feed goes back, a bank QuickBooks does not connect to, or a gap left by a connection that dropped.
Drag a PDF bank statement here, or tap to choose a file
PDF only · up to 25 MB · up to 60 pages
Importing into QuickBooks Online
- Convert the statement above and export as QuickBooks (QBO).
- In QuickBooks, go to Transactions → Bank transactions.
- Choose Upload from file, or Link account → Upload from file if you have not connected anything yet.
- Select the .qbo file and pick the account it belongs to.
- Review the transactions in the For review tab before accepting them. QuickBooks will flag anything it thinks it already has.
Why duplicates happen, and what we do about it
Every transaction in a QBO file carries an identifier QuickBooks uses to decide whether it has seen that transaction before. Get it wrong and you get one of two bad outcomes: re-importing a corrected file adds a second copy of everything, or two genuinely different transactions on the same day for the same amount collapse into one.
Most converters number the rows. That is stable until you edit anything — delete a row that was not really a transaction, or reorder two entries the statement printed out of sequence, and every id below the change shifts by one. The next import then looks entirely new to QuickBooks.
Ours is derived from the transaction itself, so it does not move when the table does. Edit freely before exporting; the identity of each transaction goes with the transaction.
Check the balances before you import
A missing transaction in an accounting system is more expensive than a missing row in a spreadsheet, because it propagates into every reconciliation after it. Before the export unlocks, StatementSnap adds its transactions to the opening balance and compares the total with the closing balance on your statement.
A green badge means the set is complete to the cent. It is worth waiting for on this page in particular — you are about to put these numbers into your books.
More on working without feeds: importing bank transactions into QuickBooks without bank feeds.
Questions
- Will importing create duplicates of transactions I already have?
- QuickBooks decides that using the transaction id inside the file, and duplicates happen when a converter generates a new id every time you export. Ours does not: the id is derived from the transaction's own date, amount and description, so re-exporting the same statement produces the same ids. It also survives you deleting or reordering rows in the table first, which is where id schemes based on row position fall over.
- Should I use QBO or CSV?
- QBO if QuickBooks will take it. It carries the account number, the currency and a transaction id per row, so QuickBooks can match against what it already has. A CSV carries none of that and asks you to map columns by hand on every import.
- Why can't I just use the bank feed?
- Often you can, and when you can it is less work than this. The feed cannot help you with a closed account, with a period further back than the feed offers (usually about 90 days), with a bank QuickBooks does not connect to, or when a connection breaks and leaves a gap that never backfills. Those four are why this page exists.
- Does this work with QuickBooks Desktop as well as Online?
- The file is OFX-based, which both accept — QuickBooks Online takes it through Transactions → Upload from file, Desktop through File → Utilities → Import → Web Connect Files. Desktop is fussier about the file extension, so keep it as .qbo.
- What about Xero, Wave, or FreeAgent?
- They read OFX too, and the same file works. Export OFX rather than QBO where the option is offered — QBO is Intuit's variant of the same format and some tools reject the extension even though they can read the contents.
Other formats
- PDF bank statement to ExcelReal number and date cells, not text that looks like numbers.
- Bank statement to CSVUTF-8, quoted properly, opens the same everywhere.
- Credit card statement to ExcelHandles the sign convention that catches most converters out.
Looking for your bank specifically? 150 institutions have their own download instructions — see the list.