Upload a CSV File to QuickBooks Online
To upload a CSV file to QuickBooks Online, go to Transactions → Bank transactions → Upload from file, select your CSV file, choose the bank account, map the Date, Description, and Amount columns, review the preview, and click Import. Uploaded transactions appear in the For Review tab, where you categorize, match, or add them to the books. Nothing posts to your registers until you accept it.
This guide covers the upload workflow itself. If your file needs formatting first — column layout, date formats, templates, or fixing rejected files — see the QuickBooks CSV format and errors guide.
Step-by-Step CSV Upload Walkthrough
Step 1: Open Bank Transactions
In QuickBooks Online, select Transactions from the left menu, then choose Bank transactions.
Step 2: Start File Upload
Click the account dropdown or account tile and select Upload from file. If no account is connected yet, QuickBooks may display the upload option during account setup.
Step 3: Select Your CSV File
Click Drag and drop or select files, choose your CSV file, and continue to the next step. QuickBooks Online caps bank-transaction CSV uploads at 350 KB per file — for larger histories, split the file into smaller date ranges and upload them oldest first.
Step 4: Choose the Destination Account
Select the bank or credit card account where the transactions belong. Verify that the account matches the statement source before importing — uploading into the wrong account is the most tedious mistake to undo later.
Step 5: Map Your Columns
QuickBooks will ask you to identify the Date, Description, and Amount columns — or Date, Description, Credit, and Debit if your bank exports separate columns. Pick the date format that matches your file. If QuickBooks rejects the file or the columns will not map, the file itself needs fixing — see the CSV format requirements and error fixes.
Step 6: Review Before Importing
QuickBooks displays a preview screen. Check the first transaction date, last transaction date, total number of rows, and deposit and withdrawal direction. If deposits show as withdrawals, return to the mapping step and switch the amount handling.
Step 7: Finish the Import
Click Import. The transactions appear in the For Review tab where they can be categorized, matched, or added to the books.
Avoiding Duplicate Transactions
Duplicates usually appear when an uploaded date range overlaps with an active bank feed, or when the same file is uploaded twice. Before uploading, check which date ranges already exist in the account.
For catch-up projects spanning many months, upload older periods first and work forward chronologically — it keeps the For Review queue manageable and makes overlaps obvious.
QuickBooks does not post anything automatically: every uploaded transaction waits in For Review until you accept it, so a duplicated upload can still be caught and excluded before it touches the books.
When CSV Is the Wrong Tool
CSV uploads work well when your bank already provides clean transaction exports.
The problem is that many banks only allow CSV or QBO downloads for the last 12–24 months. Older records are often available only as PDF statements. For catch-up bookkeeping projects covering several years, cleaning CSV files, fixing signs, and mapping columns can take longer than expected. In those situations, a PDF-to-QBO converter such as Bank Parser can generate a QuickBooks Web Connect (.QBO) file directly from historical bank statements, which skips the CSV column-mapping step entirely — see how to upload transactions to QuickBooks Online from PDF statements.
A related concern we hear from bookkeepers is whether converters collect business bank account information. Bank statement conversion does not require bank login credentials. Files are uploaded for processing and then deleted after conversion. The converter reads the statement document itself rather than connecting to the bank account.
Another common objection is, “My bank already exports CSV or QBO.” That is often true for recent activity. The issue usually appears during cleanup bookkeeping projects when the client needs transactions from several years ago and the bank only provides historical records as PDF statements.
Frequently Asked Questions
Where is Upload from file in QuickBooks Online?
Go to Transactions in the left menu, then Bank transactions. Click the account dropdown or account tile and select Upload from file. If no bank account is connected yet, QuickBooks may show the upload option during account setup.
Can I upload more than 90 days of transactions?
Yes. CSV uploads are not limited to the last 90 days. The limitation usually comes from the bank's export tools, not QuickBooks itself. Many bookkeepers use CSV uploads for catch-up bookkeeping projects covering months or years of activity.
How do I avoid duplicate transactions when uploading?
Before importing, check whether the same date range already exists in QuickBooks through a bank feed or previous upload. Import each date range only once and review the For Review tab before accepting transactions.
What happens after the upload finishes?
Uploaded transactions land in the For Review tab of the selected account. From there you categorize, match, or add each transaction to the books. Nothing touches your registers until you accept it.
Is a CSV or a QBO file better for uploading to QuickBooks Online?
A QBO (Web Connect) file is generally easier because it is designed specifically for QuickBooks: it skips the column-mapping screen entirely. CSV files are more flexible but require correct formatting and manual mapping during upload.
Can I upload a CSV to QuickBooks Desktop the same way?
No. The Upload from file flow is a QuickBooks Online feature. QuickBooks Desktop does not import bank-transaction CSV files natively — supported Desktop versions import Web Connect .QBO files instead.