Get a PDF bank statement into QuickBooks Online
Convert the PDF to a CSV in the format QuickBooks Online imports: Date, Description, Credit and Debit. Before you download, every page is checked against the balances printed on the statement, so what reaches your books matches the bank. Your first 10 pages each day are free.
Convert a statementWhat’s in the QuickBooks CSV
- Columns
- Date, Description, Credit, Debit, in that order: the four-column format in Intuit’s guide.
- Dates
- MM/DD/YYYY. Pick that format when the import asks for it.
- Credit and Debit
- As in Intuit’s example: money out goes in Credit, money in goes in Debit. Amounts are positive, with no currency symbol.
- Size
- QuickBooks Online takes up to 1,000 lines and 350 KB per upload. If your file is over, we tell you next to the download button.
- Cards in two currencies
- A QuickBooks account has one currency, so the file carries the statement’s main one. The others are in the Excel and CSV files.
QuickBooks details from Intuit: Manually upload transactions into QuickBooks Online (updated August 24, 2026), checked November 15, 2026.
How to import it into QuickBooks Online
- In QuickBooks Online, go to Bank transactions, under Accounting.
- Open the Link account menu and select Upload from file.
- Choose the QuickBooks CSV you downloaded, then the account it belongs to.
- Match the columns: Date (MM/DD/YYYY), Description, Credit and Debit.
- Select the transactions to import and confirm.
We imported a file in this format into QuickBooks Online (US) on November 12, 2026.
Menus change; if yours look different, the current steps are in Intuit: Manually upload transactions into QuickBooks Online (updated August 24, 2026), checked November 15, 2026.
QuickBooks can read a PDF too. Why convert it first?
QuickBooks Online can also take a statement PDF directly. Converting it here first gets you two things: every page is checked against the statement’s printed balances, to the cent, and you can fix a row that was read wrong before it reaches your books.
You also get the same transactions in Excel, for the client folder or your own review.
Convert it in three steps
- Upload the PDF on StatementTally. Scanned statements work too.
- Review it. Every page has to add up, to the cent, and start where the one before it ended. If something’s off, you see which page and by how much, and you can fix it.
- Download Excel, CSV or a QuickBooks CSV, as many times as you need.
Your PDF is deleted as soon as it’s read, and your transactions are removed within 24 hours. Security
Questions
Do I need to change anything in the file?
No. It already has the four columns QuickBooks Online asks for, in order, with one date format in the whole file.
What if my statement has more than 1,000 transactions?
You can still download the file, but QuickBooks may not take it in one upload. Split it into smaller files first, keeping the header row in each one.
Does it work with QuickBooks Desktop?
The QuickBooks CSV is made for QuickBooks Online’s file upload. We don’t make .QBO or .IIF files.
Is it free?
Yes, for 10 pages a day, with no account. After that, a page pack is US$2.99 for 20 pages and never expires, or Pro is US$24 a month for 600 pages.
What happens to my statement?
The PDF is deleted as soon as it’s read. The transactions are kept for up to 24 hours so you can review and download them, then they’re removed. You can delete them sooner yourself.
More ways to convert
QuickBooks is a trademark of Intuit Inc. StatementTally isn’t affiliated with or endorsed by Intuit.