How to import bank transactions into QuickBooks Online
QuickBooks Online imports bank transactions from a bank feed, a CSV or a QBO (Web Connect) file. When the feed does not reach back far enough or your bank only gives PDFs, convert the file here first, then follow these steps.
Columns (only if we guess wrong)
Column numbers in your CSV or Excel file, counting the first column as 1.
No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.
1. Get a file from your bank
Download transactions as CSV, Excel, QBO or PDF from online banking. Use the tool above to turn CSV, Excel or PDF into a QBO file.
2. Upload in QuickBooks Online
Go to Transactions > Bank transactions, choose Link account > Upload from file, select the QBO file, and pick the QuickBooks account it belongs to.
3. Review and accept
Imported transactions wait in the For review tab. Match or categorise them, exclude anything already recorded, then accept. Nothing touches your books until you accept.
If the upload fails
The usual causes are dates in the wrong order, the wrong sign on charges, or a missing bank ID. A file converted here fixes all three. Back up your company file first if you use QuickBooks Desktop.
Pricing
Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.
1 file
$9 per file
$9
10 filesBest value
$2.90 per file
$29
Unlimited files every month
$0.08 per file, billed monthly, cancel any time, fair use 500 files a month
$39/mo
Deleted after 24 hours
Your upload and the result are removed automatically.
Never used for training
Files are processed only to make your result.
Refund if it is wrong
If a result is unusable, we fix it or refund you.
Questions
CSV or QBO?
QBO keeps payee names and avoids the column-mapping step in QuickBooks. CSV works too but you map columns each time.
How many transactions can I upload at once?
QuickBooks Online accepts files of up to about 350 KB; split very long years into a few files.
Where is the upload option in QuickBooks Online?
Transactions > Bank transactions, then the arrow next to Link account > Upload from file. In some layouts it is a button called Upload transactions.
Can I upload credit card transactions the same way?
Yes. Pick the credit card account in QuickBooks when you upload, and convert the file with Credit card as the account type so charges and payments land on the right side.