How to upload a bank statement to QuickBooks Online
- Convert the statement PDF and choose the QuickBooks / Sage Accounting export.
- In QuickBooks Online, go to Accounting, then Bank transactions, and select the tile for the account if you see one.
- Open the Link account menu and select Upload from file.
- Drag in the CSV, select Continue, and choose the QuickBooks account the transactions belong to.
- Match the columns in the file to the fields in QuickBooks: Date, Description and Amount. If asked for a date format, choose day, month, year.
- Select the transactions to import, select Continue, then Yes and Done.
The file rules Intuit sets, and how the export meets them
Intuit's guidelines for a transaction list are short and strict. The converter's general CSV and Excel exports break two of them, because they include Balance and Reference columns and write dates with hyphens. The QuickBooks / Sage Accounting export is built to meet them.
| Intuit asks for | The export has |
|---|---|
| 3 columns (Date, Description, Amount) or 4 columns | Date, Description, Amount |
| All dates in the same format, ideally dd/mm/yyyy | dd/mm/yyyy throughout, such as 15/03/2026 |
| No day of the week in the Date column | The date only |
| A file in English, 350 KB or less | Bank descriptions as printed; a monthly file is far below 350 KB |
Money out is negative and money in is positive, with two decimals and no thousands separators. For example: 15/03/2026, POS PURCHASE WOOLWORTHS, -150.50.
Limits, and what to do if an upload fails
- One upload can be up to 350 KB and 1,000 lines, one transaction per line. For a busy account, upload one month at a time.
- Intuit's guidelines ask for numbers to be removed from the Description column, and its troubleshooting checklist starts with special characters. Bank descriptions often contain card numbers and references, so if an upload fails, open the CSV, remove those from the descriptions, and save it as CSV again.
- If it still fails, Intuit suggests copying the data into a new spreadsheet in the correct layout and saving it as a Windows CSV.
- QuickBooks also uploads QBO and QFX files. If your bank offers one of those for the period, it is an alternative to the CSV.
Checking the upload against the statement
QuickBooks shows you the transactions before it imports them, which is the moment to catch a problem. A minute of checking here saves an afternoon of unpicking categorised transactions later.
- In the converter preview, note the number of transactions and the net figure, and check that the net figure added to the opening balance on the PDF gives the closing balance.
- On the step where you select transactions in QuickBooks, check that the number listed matches the preview.
- Look at two or three transactions you know: one salary or deposit and one card payment. Money in should show as a deposit and money out as a payment.
- If every amount has the wrong direction, go back to the column matching step and check how the Amount column was matched.
After the upload
Intuit's next steps after an upload are to match and categorise the transactions, then reconcile the account. Bank rules you set up beforehand help, because QuickBooks applies them to uploaded transactions too.
Intuit also advises that the transactions you upload start at least one day before the oldest transaction already in QuickBooks for that account, and that you check your chart of accounts first to avoid duplicates. Keep the original PDF statement with your records: the CSV is a working file, and the statement is the document SARS or an auditor would ask to see.
Before you upload
- A free account converts 5 pages a month. Each PDF page counts as one, and a CSV counts as one however long it is. After that you can buy credits, and Premium subscribers convert without a monthly page limit.
- One PDF upload can be up to 20 pages and 8 MB. Split anything longer by month.
- The PDF must have selectable text. A scanned or photographed statement has none, so download the digital version from online banking instead.
- Password-protected PDFs have to be unlocked first. Our guide to password-protected bank statements shows how.
- Where a statement prints dates without the year, the converter takes the year from the statement period. If a statement runs from December into January, check those dates in the preview.
- A PDF is read in memory over an encrypted connection and is not saved. A CSV never leaves your browser.
Frequently asked questions
Will the converted file upload to QuickBooks Online without editing?
Use the QuickBooks / Sage Accounting export and it meets Intuit's layout rules. If an upload fails, remove numbers and special characters from the descriptions, as Intuit suggests.
QuickBooks can read PDFs. Why convert first?
Converting lets you check every transaction in a preview before anything reaches your books, and gives you a file you can also use in Excel or send to your accountant. Either route works.
Which date format do I choose in QuickBooks?
Day, month, year. The export writes dates such as 15/03/2026, which is the dd/mm/yyyy format Intuit recommends.
Can I upload several months to QuickBooks at once?
Yes, as long as the file stays within 1,000 lines and 350 KB. Paste the months into one CSV under a single heading row, or upload each month separately.
Is QuickBooks Online available in South Africa?
Yes. Intuit sells QuickBooks Online in South Africa, with rand pricing.
Is converting a statement for QuickBooks free?
A free account converts 5 pages a month. After that you can buy credits, and Premium subscribers convert without a monthly page limit.