To import bank transactions into QuickBooks Online, open the Bank transactions page, choose Upload from file, pick your CSV or QBO file, select the QuickBooks account the money belongs to, match the columns if the file is a CSV, then choose which rows to bring in. The rows then wait for your review.
Which files does the QuickBooks Online bank upload accept?
The upload accepts QBO, QFX and CSV files, and Intuit's help page also lists OFX and plain text. Intuit suggests a QBO file when you have a choice. A file must be in English, 350 KB or smaller, and hold at most 1,000 lines, with one transaction on each line, according to Intuit's help article on manual uploads.
Those limits shape how you work. A bank that lets you download a full year of activity may hand you a file with thousands of lines. Intuit's advice for a large history is to shorten the date range and download in smaller batches, so a busy account becomes a series of monthly or quarterly files rather than one big one.
QBO versus CSV in plain words
A QBO file is a structured file that carries its own labels. Each transaction already says which part is the date, which is the amount and which is the description, so QuickBooks has nothing to ask you about. A CSV is a plain table of text, and QuickBooks can't know which column is which until you tell it. That is why a CSV upload has an extra screen for matching columns and a QBO upload does not.
If your bank offers a QBO download, use it. If it only offers a CSV, or if your data lives in a spreadsheet, the CSV route works too. It just needs the file to be laid out in a shape QuickBooks understands, which the post on mapping CSV columns in QuickBooks covers in detail.
What about a PDF statement?
The same upload button also takes a PDF or an image of a statement, such as a JPG, PNG or HEIC file, according to Intuit's page. In that case QuickBooks reads the statement and shows you the extracted data next to the original so you can correct it before saving. That route has its own checks, and it is covered in the guide to uploading bank statements to QuickBooks Online. The rest of this post is about a file of transactions, meaning a QBO, QFX or CSV.
Checking the file before you start
Spend two minutes on the file before you upload it. Open a CSV in a spreadsheet and look at the first and last rows. Confirm that the earliest and latest dates match the period you meant to export, that no row is a total or a blank line, and that the amounts look like money. A file that is wrong in an obvious way is far cheaper to fix before the upload than after.
Picking the right bank account for the QuickBooks Online upload
The account you pick on the upload screen decides where every row in the file lands, so it must be the QuickBooks account that matches the bank or card account the file came from. A checking file belongs to your checking account, and a card file to a credit card account. QuickBooks will not warn you if you choose wrongly.
Accounts that already exist
Most businesses already have the account in their chart of accounts, set up when the books were created. Choose it from the QuickBooks account dropdown on the upload screen. If you have two similar accounts, such as an operating account and a savings account at the same bank, check the last four digits of the account number printed on the bank file against the name you gave the account in QuickBooks. Many mistakes come from picking the first account in the list.
Accounts that don't exist yet
If the account is missing, the dropdown offers Add New. Choose it, name the account the way you would want to see it on a report, and pick the matching account type, bank for a checking or savings account. Name it for the real account and not the file. "Business checking 4417" is a better name than "March upload".
Why the account type matters
A bank account and a credit card account treat the same number in opposite ways. A payment out of a checking account lowers the balance, while a payment into a credit card account lowers the balance too, even though the money moves the other way. If a card file goes into a checking account, every sign ends up backwards. The post on importing credit card transactions into QuickBooks Online explains how to avoid this.
The opening date of the file
Intuit's page also says the file should start at least one day before your oldest QuickBooks transaction in that account. That gap leaves room for the first imported row and lets you see where history ends and the new file begins. Choose the start date of the export with this in mind.
Walking through the QuickBooks Online upload screens step by step
The upload runs through a short series of screens: pick the file, pick the account, match the columns when the file is a CSV, choose the rows, and confirm. Intuit's own help article lists the steps below. Menu names change from time to time, so treat the wording as a guide and look for the same idea on your screen.
A five-row sample file
Here is a small CSV in the three-column layout, with made-up values for illustration. It is the kind of file the steps below use.
| Date | Description | Amount |
|---|---|---|
| 03/04/2026 | Coffee supplier | -86.40 |
| 03/05/2026 | Customer payment | 1250.00 |
| 03/09/2026 | Office rent | -950.00 |
| 03/12/2026 | Software subscription | -29.00 |
| 03/15/2026 | Customer payment | 640.00 |
Money going out is negative and money coming in is positive. The five rows are all the file holds, plus the header row.
The steps
- Open Bank transactions. In the current menu this sits under Accounting, and older screens call it Transactions, then Bank transactions.
- If you see a tile for your account, select it. This takes you to the transactions for that one account.
- Open the Link account dropdown and choose Upload from file. If the account is not connected to a bank, the page offers an upload link directly.
- Drag your file onto the box, or select it from your computer, then choose Continue. For the sample file, that is the CSV above.
- On the next screen, open the QuickBooks account dropdown and choose the account the file belongs to. If it does not exist, choose Add New. Then choose Continue.
- For a CSV, QuickBooks now shows the mapping screen. Say whether the first row is a header, pick the date format the file uses, and match each file column to a QuickBooks field. In the sample, Date goes to Date, Description to Description and Amount to Amount. For a QBO file, this screen does not appear. The details are in the post on matching CSV headers on the mapping screen.
- On the review screen, check whether the amounts show as positive or negative the way you expect. If they come out reversed, Intuit says to select the option to reverse all values. In the sample file, the rent should read as money out.
- Select the transactions to import. Untick any you do not want, then choose Continue.
- Confirm with Yes, then choose Done.
What you should see at each step
At step 4, the file name appears on the screen. If nothing happens, the file may be too large or in a format the upload does not take. At step 6, the sample rows should appear in a preview with the right columns above them. If the date column shows odd values, the date format setting is wrong. At step 8, the count of rows should match the lines in your file. If it is lower, some rows were skipped, which the CSV guide explains.
Making the file from a PDF statement
If your only copy of the data is a PDF from the bank, the upload cannot take it as a list of transactions. You need a CSV or QBO first. The post on fixing statement dates and money columns before the QBO step shows what to repair on the way. SimpleBankConvert is built to turn a PDF statement into a CSV or QBO file with the dates tidied and money out shown as a minus. It is not open yet, and you can ask for access on the get started page.
Where do imported bank transactions show up in QuickBooks Online?
Imported transactions show up on the Bank transactions page, under the account you chose, as items waiting for review. They are not posted to your books yet. Nothing appears in your reports until you accept each one, so an import alone does not change your profit and loss.
The review step
Each imported row appears with a suggested category, or a blank one if QuickBooks has no match. You can add the transaction as an expense or deposit, match it to something you already entered, or exclude it. Matching matters when you have already typed in an invoice payment by hand. Accepting a match links the imported row to your entry instead of creating a second one.
Checking the count and the total
After the import, do a quick check. Count the rows waiting for review and compare that number with the lines in your file. Then add up the file's amounts and compare the result with the change in the bank's balance over the same days. If both agree, the file arrived whole. If the count is off, look at the rows QuickBooks skipped, which are listed in the CSV guide linked above.
Where to look if nothing appears
If the page looks empty, check that you are viewing the account you chose and that the filters are not hiding older dates. A common cause is a date format mix-up, which can push rows into the wrong year. Open the account's register and sort by date to find them.
Uploading the same bank transactions twice and undoing it
If you upload the same file twice, QuickBooks can show the rows a second time, and you must remove the extra ones before accepting them. The cleanest fix is to catch the repeat at the review step, where you can untick the rows. Intuit's page does not describe an undo button for an upload.
Preventing a repeat
Intuit advises setting the date range carefully so that files do not overlap. Keep a note of the last date you imported for each account, and start the next export on the following day. A file named with its first and last dates, for example "checking-2026-03-01-to-2026-03-31", makes it hard to upload March twice without noticing.
If you already accepted the duplicates
If the rows were accepted, they are now real transactions. Open the account's register, sort by date and amount, and look for pairs that match. Delete the second of each pair, not the first, so that any matching or categorizing you did is kept. Then run the check from the previous section again and compare against the bank balance.
Overlap with a bank feed
Duplicates also appear when a file covers dates that a connected bank feed has already filled. If the account has a feed, upload only the dates the feed is missing. The post comparing every way to import transactions into QuickBooks explains when to use a feed and when to use a file.