Upload Transactions to QuickBooks Online: Import Bank Transactions From a PDF Statement
The bank feed is not the only way in. QuickBooks Online has a manual upload sitting right next to it, and it is the route every bookkeeper falls back on when the feed will not connect, stops at 90 days, or skips half a month.
Quick answer
To upload transactions to QuickBooks Online, go to Transactions, then Bank transactions, open the Link account dropdown and choose Upload from file. QuickBooks Online accepts CSV, QBO, QFX and OFX, up to 1,000 transaction lines per file. It does not read PDF bank statements, so a PDF has to be converted first. A .qbo file is the cleanest option because it carries the account details and a unique ID on every transaction, which means no column mapping and working duplicate detection.
Last updated August 2026
Turn a statement into an upload file
Upload a PDF bank or credit card statement and download a .qbo QuickBooks Online takes without mapping.
No credit card required to try your first statement.
The two ways transactions get into QuickBooks Online
There are exactly two, and confusing them is the reason so many searches for this end in a support thread. The first is the bank feed: you connect the account once and Intuit's aggregator pulls new activity in on a schedule. The second is the manual upload, where you hand QuickBooks a file you produced yourself. Both land in the same For Review queue, both create the same transactions, and QuickBooks does not treat one as second class.
The manual upload exists because the feed fails in predictable ways. Plenty of smaller banks and credit unions were never wired up to the aggregator at all. Feeds that do connect usually reach back only about 90 days, which is useless the moment you are cleaning up a prior year. Business credit cards drop off after a security change at the issuer and quietly stop syncing. And feeds occasionally deliver a partial month, which is the source of the very common complaint that QuickBooks is not importing all bank transactions.
In every one of those situations the fix is the same: get the history into a file QuickBooks accepts and upload it yourself. The only real decision left is which format, and that decision has more consequences than most people expect.
What QuickBooks Online accepts, and what each format costs you
All four formats reach the same review queue. What separates them is how much work you do before the upload and how well QuickBooks can protect you from duplicates afterwards.
| Format | Where you get it | Column mapping | Duplicate detection | Account routing |
|---|---|---|---|---|
| QBO (Web Connect) | Bank download, or converted from a PDF statement | None | Per transaction ID | Carried in the file |
| QFX | Bank download, Quicken flavored | None | Per transaction ID | Carried in the file |
| OFX | Bank download, generic open format | None | Per transaction ID | Carried in the file |
| CSV | Bank download, or built by hand in a spreadsheet | Every single file | Weak, matched on values | You pick the account |
| PDF statement | Your bank, every month | Not accepted | Not accepted | Convert it first |
Every one of these paths is capped at 1,000 transaction lines per file, so a busy account will need splitting by month or by quarter whichever format you pick.
The limits that stop an upload, and what to do about each
Most failed uploads are not really failures. They are one of these five ceilings, and each has a routine answer once you know which one you hit.
| Limit | Value | What you see | What to do |
|---|---|---|---|
| Lines per upload | 1,000 transactions | The upload is rejected, or only part of the file appears | Split the period into smaller files and upload oldest first |
| CSV file size | 350 KB per Intuit's guidance | Upload refused before any preview appears | Shorten the date range, or use a .qbo instead |
| Bank feed history | Roughly 90 days on connection | Older months simply never arrive | Upload the earlier months manually from statements |
| Accounts per file | One | Everything lands in whichever account you selected | Keep one account per file, always |
| File formats | CSV, QBO, QFX, OFX | PDF and XLSX are not offered in the picker | Convert the statement to .qbo before uploading |
Why the PDF you already have will not upload
Almost everyone arrives at the upload screen holding the one document the bank definitely gave them: the monthly PDF statement. It is not in the picker, and it never has been. A PDF describes where ink goes on a page. It has no concept of a transaction, a date field or an amount field, and two statements from the same bank in the same year can lay those out differently. QuickBooks would have to interpret the document rather than read it, and Intuit chose not to build that into the banking upload.
You can attach a PDF to a transaction as supporting documentation, which is useful for an audit trail and useless for data entry. Nothing is extracted from it. So the PDF has to become one of the four accepted formats first, and that is where the choice between CSV and .qbo starts to matter in a way that shows up months later during reconciliation.
Building a CSV by hand from a statement means typing or pasting every line, then mapping the columns again on every upload, then living without real duplicate detection. A .qbo built from the same statement carries the routing and account number, plus a unique identifier on every transaction. QuickBooks reads those identifiers, drops the ones it has already seen, and files the rest against the right account with nothing for you to map. On a single month the difference is a few minutes. Across a year of cleanup for several clients it is the difference between a clean set of books and a register full of doubled entries.
How to upload transactions to QuickBooks Online from a statement
One account, one period
Collect the PDF statements for the months the feed missed. Keep checking and credit card statements in separate files, because an upload file describes exactly one account.
Convert and read it back
Upload the statement here and check the extracted dates, descriptions and amounts on screen. Fixing a misread line now is trivial. Fixing it after it has posted into the books is not.
Tie out the closing balance
Compare the converted total against the closing balance printed on the statement. A missed continuation page shows up here as a mismatch, which is much cheaper than discovering it mid reconciliation.
Upload it in QuickBooks
Go to Transactions, then Bank transactions, open the Link account dropdown and choose Upload from file. Select the .qbo, pick the matching account, and work oldest period forward.
Intuit moves these menu labels around between releases. If Bank transactions is not where you expect it, look for Banking or Transactions in the left navigation; the Upload from file option lives under the same dropdown as Link account in current versions.
CSV or QBO for a manual upload
Both work. They fail differently, and the failure modes only appear once you are past a handful of transactions.
| Question | CSV upload | QBO upload |
|---|---|---|
| Setup per file | Map date, description and amount columns each time | None, the file already says what everything is |
| Re-uploading an overlapping month | Risky, near identical rows can post twice | Safe, QuickBooks suppresses IDs it has seen |
| Debits and credits | Three column or four column layouts, sign errors are common | Signed in the file, nothing to decide |
| Date formatting | Must be consistent and match what QuickBooks expects | Handled by the format |
| Best for | A one off month you already hold as a clean spreadsheet | Multi month cleanups, several accounts, recurring client work |
If you are already living in spreadsheets and the data is clean, CSV is fine for one month. For anything repeating, the mapping step and the duplicate risk compound, and that is what pushes most firms onto Web Connect .qbo files permanently.
When a manual upload is the right call
The bank was never supported
Smaller regional banks and credit unions frequently have no feed at all. Statements are the only export they offer, and uploading them is the whole workflow rather than a fallback.
Cleanup and catch up work
A client hands you eighteen months of nothing. The feed reaches back about 90 days, so everything before that comes in as uploaded files, period by period. See QuickBooks cleanup from statements.
A feed that dropped out
Business cards in particular stop syncing after an issuer security change. The gap has to be filled by hand before anything reconciles again.
Several companies at once
Firms running many QuickBooks Online files often skip feeds entirely and standardize on uploads, because one repeatable process beats thirty different bank connections breaking at different times.
Closed and legacy accounts
You cannot connect a feed to an account that no longer exists. If the prior year needs the history of a closed account, the statements are the only source.
Feeds that skip transactions
When QuickBooks is not importing all bank transactions, the statement is the authoritative record. Uploading the full month and letting duplicate detection do its job closes the gap.
When QuickBooks is not importing all bank transactions
This complaint has three common causes and they need different fixes. The first is the 1,000 line ceiling: the file went through, part of it did not, and nothing told you clearly. Count the lines in the source, count what landed in For Review, and if the source is over a thousand, split it.
The second is duplicate suppression doing exactly what it should. If a period overlaps something already imported, QuickBooks drops the transactions it recognizes by ID. That looks like missing data and is actually correct behavior. Check the register for the dates in question before re-uploading anything.
The third is a genuine gap in what the bank sent. Feeds sometimes deliver a partial period, and pending transactions that later settle at a different amount can go missing entirely. Reconcile against the printed statement rather than against the feed, then upload the missing period from the statement itself. If the upload is rejected outright rather than incomplete, that is a different problem: see fixing a .qbo file that will not import.
Questions people ask before their first upload
How do I upload transactions to QuickBooks Online?
Go to Transactions, then Bank transactions, open the Link account dropdown and choose Upload from file. Select a CSV, QBO, QFX or OFX file, choose the QuickBooks account it belongs to, confirm the mapping if it is a CSV, and the transactions land in the For Review queue ready to be added or matched.
Can I upload bank transactions to QuickBooks Online manually?
Yes. The manual upload is a standard feature and works whether or not the account is connected to a bank feed. It is the supported route for banks with no feed, for history older than the feed reaches, and for filling gaps a feed left behind. Uploaded transactions behave identically to fed ones.
What file format does QuickBooks Online accept for bank transactions?
CSV, QBO, QFX and OFX. QBO is the Web Connect format Intuit designed for this and it needs no column mapping. QFX and OFX behave much the same. CSV works but has to be mapped on every upload and gives QuickBooks far less to match duplicates against. PDF is not accepted.
How many transactions can I upload to QuickBooks Online at once?
Up to 1,000 transaction lines per file, with one transaction per line. Intuit also states a 350 KB size cap for CSV uploads. Busy accounts and long cleanup periods therefore need splitting, and the cleanest way is one file per statement month, uploaded oldest first.
Can I upload a bank statement to QuickBooks Online?
Only after converting it. The statement itself is a PDF and the upload picker will not take one. Convert the statement into a .qbo file first and the entire month uploads in one step, correctly signed, routed to the right account and protected by duplicate detection.
Can QuickBooks Online read a PDF bank statement?
No. You can attach a PDF to a transaction as documentation, but QuickBooks Online will not extract transactions from it. The data has to be converted into one of the four accepted formats first, and .qbo is the one that imports without any column mapping.
How do I upload a credit card statement to QuickBooks Online?
Exactly as you would a bank statement, but select the credit card account in QuickBooks rather than a bank account. Keep the card in its own file. Charges should import as increases to the liability and payments as decreases, which a properly signed .qbo handles without any manual correction.
How far back can I upload transactions to QuickBooks Online?
As far back as you have statements. The roughly 90 day limit people run into belongs to the bank feed, not the upload. Manual uploads have no date restriction, which is exactly why they are the standard tool for prior year cleanups and catch up bookkeeping.
Do I need to connect my bank to upload transactions?
No. You need a QuickBooks account of the right type to upload into, but no bank connection. Create the bank or credit card account in your chart of accounts, then upload files against it. Many firms run entirely this way to avoid feed outages.
How do I delete transactions I uploaded by mistake?
If they are still in For Review, select them and use Exclude, then delete them from the Excluded tab. Once you have clicked Add they are real transactions in the register and have to be deleted there. Reviewing before you add is far quicker than unpicking afterwards.
Get the month QuickBooks missed into a file you can upload
Upload one PDF statement, check the transactions against the closing balance, and download a .qbo that QuickBooks Online accepts with no column mapping.
Convert a statement nowRelated tools and guides
QuickBooks Online QBO import
Uploading a .qbo file inside QuickBooks Online, screen by screen.
QuickBooks Web Connect files
What the .qbo format carries and why it uploads without mapping.
Convert a PDF bank statement
The conversion step itself, from statement to upload ready file.
Batch converting statements
Handling a year of history without doing months one at a time.
IIF files in QuickBooks Online
Why the format is not accepted, and the three routes that do work.
Reviewing what you uploaded
Add, Match, Exclude and which of those you can undo later.