QuickBooks Web Connect: Convert PDF Bank Statements to Web Connect QBO Files
Your bank stopped offering the download, or the account only goes back ninety days, and the statements you actually need are sitting in a folder of PDFs. A Web Connect file is what closes that gap.
Quick answer
QuickBooks Web Connect is Intuit's name for the .qbo bank file format, a branded variant of OFX that carries the account number, routing details, dates, amounts, payees and a closing balance. QuickBooks Desktop imports it through File, Utilities, Import, Web Connect Files, and QuickBooks Online accepts it as an upload on the Transactions screen. Banks publish these files themselves, but only for recent history. PDFQBO writes the same format from any PDF statement you already have, including scans, so you can import periods your bank no longer offers.
Last updated August 2026
Make a Web Connect file from a PDF statement
Upload a PDF bank or credit card statement and download a .qbo file QuickBooks accepts.
No credit card required to try your first statement.
What is a QuickBooks Web Connect file?
A Web Connect file is a plain text financial file with a .qbo extension. Inside it is OFX, the open banking exchange format, with Intuit's own tags added: a financial institution ID, a bank ID, an account number, an account type, and then one block per transaction holding the posted date, the amount, a transaction ID and a description. It usually ends with a ledger balance and the date that balance was struck.
Those extra identifiers are the whole point. Because the file names the account it belongs to, QuickBooks can route the transactions to the right register without you mapping a single column. Because every transaction carries its own ID, QuickBooks can tell a line it has already seen from a new one, which is what stops the same deposit landing twice when you import two overlapping periods. A CSV has none of that, which is why a CSV import asks you which column is the date and then trusts you.
Banks generate Web Connect files on demand from online banking, usually behind a link labelled "Download to QuickBooks". The catch is history. Most US banks expose somewhere between 90 days and 24 months through that link, and once a period falls off the end, the download stops being an option. The PDF statements, meanwhile, are archived for years and are frequently the only record left. Converting those PDFs back into Web Connect format is how you get the older periods into the register in the format QuickBooks handles best.
Web Connect and Web Connector are two different things
This trips up more people than any other part of the topic, and it sends them downloading the wrong software. The names differ by two letters and the products have nothing to do with each other.
| Web Connect (.qbo) | Web Connector (.qwc) | |
|---|---|---|
| What it is | A data file. One statement period of bank or credit card transactions. | A Windows application installed alongside QuickBooks Desktop. |
| What it is for | Getting bank transactions into the register. | Letting a third party web app (a CRM, a payroll tool, an ecommerce platform) exchange data with QuickBooks Desktop over SOAP web services. |
| Where the file comes from | Your bank's website, or a converter that writes the format from a PDF or CSV. | The software vendor whose app you are connecting. The .qwc holds the connection and authorisation details. |
| Works with QuickBooks Online | Yes, uploaded from the Transactions screen. | No. Desktop only, and Windows only. |
| Do you need it here | Yes, if you are importing statements. | No. Importing a statement never requires it. |
A third name you will meet: Direct Connect
Direct Connect is the automatic version of the same job. QuickBooks logs into your bank on a schedule and pulls transactions with no file involved, and at many banks it carries a monthly fee and a separate enrolment. Web Connect is the manual route: you fetch a file and import it. Express Web Connect, on QuickBooks Online, sits between the two and is Intuit fetching on your behalf. When any of those connections break or a bank drops support, a Web Connect file is the fallback that still works, because nothing has to authenticate.
Web Connect compared with the other import formats
QuickBooks Online accepts CSV, QBO, OFX and QFX for a bank upload, with a limit of 1,000 lines per file. QuickBooks Desktop accepts Web Connect and, through a different menu, IIF. They are not equivalent, and the differences show up in how much cleanup you do afterwards.
| Format | Carries the account ID | Duplicate detection | Column mapping needed | Where it fits |
|---|---|---|---|---|
| QBO (Web Connect) | Yes | Yes, per transaction ID | None | The default choice for bank and credit card history in Online or Desktop. |
| QFX | Yes | Yes | None | Quicken's branded variant. QuickBooks Online accepts it, Desktop Web Connect import does not. |
| OFX | Yes | Yes | None | The unbranded parent format. Accepted by QuickBooks Online. |
| CSV | No | No | Yes, every time | The fallback when nothing else is available. Carries description only, so payee and check number are lost. |
| IIF | By account name | No | No, but the layout is strict | Desktop only, and it posts straight to the register rather than to a review queue. Powerful and unforgiving. |
If you are weighing the last two against each other, the practical difference is where the transactions land. Web Connect drops them into the review queue so you approve each one, while IIF writes them into the register immediately. There is more on that trade off in our guide to converting a PDF statement to an IIF file.
How to turn a PDF statement into a Web Connect file
Four steps, and the third one is the step people skip and later regret.
One PDF per account, per period
Keep statements separate the way the bank issued them. A combined PDF holding checking and savings will produce a file QuickBooks cannot route cleanly, because a Web Connect file describes exactly one account.
Upload and read the transactions
Every date, description and amount appears on screen before any file is written. Scanned and photographed statements go through the same path, with OCR included rather than sold as an add on.
Tie out the closing balance
Compare the converted total against the closing balance printed on the statement. Catching a missed continuation page here takes a minute. Catching it after import means unwinding a reconciliation.
Download the .qbo and import it
You get a genuine Web Connect file, not a renamed CSV. Import oldest period first so the running balance builds in order.
Where the import lives in each version of QuickBooks
QuickBooks Online
- Open Transactions, then Bank transactions.
- Use the Link account dropdown and pick Upload from file.
- Select the .qbo file and choose the QuickBooks account it belongs to.
- QuickBooks reads the account details itself, so there is no mapping screen to fill in.
- The transactions arrive in the For review tab. Categorize and add them from there.
Keep each upload under the 1,000 line limit. A year of a busy operating account usually needs splitting by quarter.
QuickBooks Desktop
- Go to File, then Utilities, then Import, then Web Connect Files.
- Pick the .qbo file.
- Choose Use an existing QuickBooks account and select the register, or create a new one if the account is not set up yet.
- Confirm the prompt and let QuickBooks process the file.
- Open the Bank Feeds Center to match and add the transactions.
Desktop treats the import as a real bank feed, so rename rules and vendor matching apply exactly as they do on a live connection.
When a Web Connect file will not import
Almost every rejection comes down to one of four things, and the format itself is rarely the culprit.
| What you see | What is usually happening | What to do |
|---|---|---|
| OL-301 or OL-393 | The bank ID inside the file does not match what QuickBooks has recorded against the account, often after a bank merger or an account being reopened. | Edit the account, open Bank Feed Settings, deactivate all online services, restart QuickBooks and import again against the clean account. |
| "Not a valid Web Connect file" | The file is a CSV or QFX that has been renamed to .qbo, or it was opened and saved in a text editor which broke the structure. | Produce a real .qbo rather than renaming one. Never edit the file by hand: fix the data before it is written. |
| It imports, but nothing appears | The transactions went to a different account than the one you are looking at, or every line was suppressed as a duplicate of an earlier import. | Check the register you selected during import, then check whether the period overlaps something already imported. |
| Everything imported twice | Two files covering the same period were built with different transaction IDs, so QuickBooks had no way to recognise the overlap. | Import one file per statement period and do not re-cut the same period from a different source. If duplicates are already in, exclude them from the review queue before adding. |
If the file is rejected outright rather than misrouted, the step by step diagnosis is in what to do when a QBO file will not import into QuickBooks. If the register balance is wrong after the import rather than the import failing, start with fixing a wrong opening balance after a QBO import.
Who ends up needing to build their own Web Connect files
Bookkeepers doing catch up work
A client hands over eighteen months of PDFs and a bank portal that only downloads ninety days. The PDFs are the only complete record, and Web Connect is the format that gets them in without hand keying.
Firms whose bank feed broke
Connections drop after a bank migration or a login change, sometimes for weeks. Rather than wait, you keep the books current from statements and reconnect the feed later.
Accounts a feed never covered
Small credit unions, trust and escrow accounts, foreign accounts and some business card programs are simply not supported by QuickBooks feeds. Statements are the only route in.
Questions people ask about QuickBooks Web Connect
What is a QuickBooks Web Connect file?
It is a .qbo file holding one account's bank or credit card transactions in Intuit's branded version of the OFX format. It carries the institution and account identifiers, each transaction's date, amount, payee and unique ID, and a closing balance, which is what lets QuickBooks route the import and suppress duplicates without any column mapping.
How do I import a Web Connect file into QuickBooks?
In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, choose the .qbo and select the matching account. In QuickBooks Online, open Transactions, then Bank transactions, use the Link account dropdown, choose Upload from file, and pick the .qbo. Both then send the transactions to a review queue.
What is the difference between Web Connect and Web Connector?
They are unrelated. Web Connect is the .qbo bank transaction file format. QuickBooks Web Connector is a separate Windows application that lets third party web apps such as CRMs and payroll tools exchange data with QuickBooks Desktop using .qwc configuration files. Importing a bank statement never requires the Web Connector.
Does QuickBooks Online accept Web Connect files?
Yes. QuickBooks Online accepts CSV, QBO, OFX and QFX for a manual bank upload, with a limit of 1,000 transaction lines per file. The .qbo Web Connect format is the best of those to use, because it identifies the account and every individual transaction rather than relying on you to map columns.
Can I convert a PDF bank statement to a Web Connect file?
Yes, with a converter. QuickBooks itself cannot read a PDF statement as transactions, so the PDF has to be turned into a .qbo first. Upload the statement here, check the extracted transactions against the printed closing balance, and download a genuine Web Connect file. Scanned and photographed statements work the same way.
What is the difference between Direct Connect and Web Connect?
Direct Connect is automatic: QuickBooks signs into your bank and pulls transactions itself, often for a monthly fee and a separate enrolment. Web Connect is manual: you obtain a .qbo file and import it. Web Connect works for any period you can produce a file for, which is why it remains the fallback when a connection fails.
Why does my bank not offer a Web Connect download anymore?
Two common reasons. Some institutions have retired the QuickBooks download link in favour of aggregator based feeds, and others still offer it but only for recent history, typically 90 days to 24 months. Either way the PDF statements remain in the archive, and converting them reproduces the same format.
Can I just rename a CSV file to .qbo?
No, and it is the single most common cause of a "not a valid Web Connect file" error. The extension is not the format. A real .qbo contains OFX structure with institution, account and transaction tags that a comma separated file has no way to express, and QuickBooks validates that structure before it reads anything.
How far back can I import Web Connect files?
QuickBooks itself imposes no age limit on the transactions inside a .qbo file, so multi year cleanups are normal. The limit is on the bank side, in how much history it will still generate a file for. Working from PDF statements removes that constraint, since the archive usually goes back much further than the download.
Will importing a Web Connect file create duplicates?
Not normally. Each transaction in a .qbo carries a unique ID, and QuickBooks checks incoming IDs against what is already in the account. Duplicates appear when the same period is imported from two sources that assigned different IDs, so import one file per statement period and avoid re-cutting a period you have already brought in.
Build a Web Connect file from the statement in front of you
Upload one PDF, check the transactions against the closing balance, and download a .qbo that QuickBooks Online and Desktop both import.
Convert a statement nowRelated tools and guides
Convert PDF bank statement to QuickBooks
The main converter page, covering both QBO and IIF output.
PDF bank statement to QuickBooks Desktop
The Desktop side of the Web Connect import in detail.
QuickBooks Online QBO import
Uploading a .qbo file inside QuickBooks Online, screen by screen.
PDF to IIF converter
The Desktop only alternative, and when it beats Web Connect.
When the QuickBooks bank feed stops working
Keeping the books current while a connection is down.
Best PDF to QBO converter
The roundup of tools that write Web Connect files, compared honestly.