# QuickBooks Online vs Desktop: Importing Bank Statements and Which File Types Each Accepts _Canonical: https://qbomaker.com/blog/quickbooks-online-vs-desktop-importing.html_ The short answer: QuickBooks Online accepts CSV, QBO, QFX, and QIF files for bank imports, while QuickBooks Desktop accepts only the .QBO (Web Connect) format for bank feeds. Desktop will not take a raw CSV into its bank feed, so if your bank only gives you a spreadsheet, you have to convert it to .QBO first. ## The one difference that matters most Both products import bank transactions, but they do not accept the same files.QuickBooks Online can read a plain .csv file directly. It also reads .qbo, .qfx, and .qif files through the same upload screen.QuickBooks Desktop (Pro, Premier, Enterprise) does not import CSV into its bank feed at all. For bank transactions it expects a .qbo Web Connect file and nothing else.This is the trap most people hit. They export a CSV from the bank, open Desktop, and find no way to bring it in. Desktop's CSV import tool is for lists (customers, vendors, items, the chart of accounts), not for bank activity. If you are on Desktop and you have a CSV, you need a .QBO file. You can build one in seconds with our free converter. ## QuickBooks Online: accepted file types In QuickBooks Online the path is Transactions > Bank transactions > Link account > Upload from file (older layouts say Banking > Upload transactions). The upload screen accepts:CSV (most common). Use a 3-column layout (Date, Description, Amount) or a 4-column layout (Date, Description, Credit, Debit). You map the columns during upload.QBO (Web Connect), QFX, and QIF. These carry the dates, amounts, and descriptions already structured, so there is no column mapping step.Two limits to plan around. A single CSV upload is capped at roughly 350 KB (about 1,000 to 1,500 rows), so a long history may need to be split into several files. And CSV dates must all use one consistent format, or QuickBooks rejects the file. A clean .qbo file avoids both problems because the format is fixed and the dates are unambiguous. ## QuickBooks Desktop: accepted file types QuickBooks Desktop brings bank transactions in through Bank Feeds. The menu path is File > Utilities > Import > Web Connect Files, or from inside the account, Banking > Bank Feeds > Import Web Connect Files. The only file it will accept there is a .qbo file.There is no CSV option in that workflow. The CSV import you may have seen in Desktop lives under File > Utilities > Import and is meant for lists, not for posting transactions to a register. So for a bank or credit card statement that arrived as a spreadsheet, the practical route is to convert the CSV (or Excel file) to .qbo and then import it as a Web Connect file. Our tool produces a Desktop-ready .QBO; see importing into Online for the sister workflow. ## Why .QBO works for both versions If you keep one file type in your back pocket, make it .qbo. Online reads it and Desktop requires it, so a single converted file covers either product. That matters for bookkeepers who serve clients on both platforms, and for anyone who might migrate from Desktop to Online later.The .qbo format is Intuit's flavor of OFX. Each transaction carries a unique ID (the FITID), which is how QuickBooks recognizes duplicates. A well-formed converter assigns stable IDs so that re-importing the same statement does not double-post your transactions. If you also use Quicken or another tool, see CSV to QFX and CSV to OFX. ## The 90-day limit, and how file import beats it A direct bank connection (the live feed inside QuickBooks) usually pulls only about 90 days of history. That is fine for ongoing bookkeeping, but it is a problem when you are setting up a new file, cleaning up a prior year, or onboarding a client mid-stream.Manual file import has no such cap. If you download (or convert to) a .qbo, .qfx, or .ofx file, you can bring in as much history as the file contains, years if needed. So when you need older transactions, do not fight the live feed. Pull the full CSV from online banking, convert it, and import the file. This applies to both Online and Desktop. ## A simple decision guide Use this to pick your path in under a minute.On Online with a CSV? Upload it directly, or convert to .QBO first if the dates are messy or the file is too large.On Online with a QBO/QFX/QIF from your bank? Upload it as-is.On Desktop with a CSV or Excel file? Convert to .QBO, then File > Utilities > Import > Web Connect Files.On Desktop with a .QBO from your bank? Import it as a Web Connect file.Whichever version you run, the conversion is the same job: turn your bank's export into a structured file QuickBooks trusts. Drop your CSV or Excel file into the QBO Maker tool, map the columns once, and download a clean .QBO. Nothing leaves your browser. **Can QuickBooks Desktop import a CSV of bank transactions?** No. QuickBooks Desktop does not import CSV files into its bank feed. It accepts only the .qbo (Web Connect) format for bank transactions. Desktop's CSV import is limited to lists such as customers, vendors, and items. Convert your CSV to .QBO first, then import it through Bank Feeds. **What file types does QuickBooks Online accept for bank imports?** QuickBooks Online accepts CSV, QBO, QFX, and QIF files on its upload screen. CSV is the most common; the others carry their structure already, so they skip the column-mapping step. **Does a .QBO file work in both Online and Desktop?** Yes. A properly formatted .qbo file imports into QuickBooks Online and is the required format for QuickBooks Desktop bank feeds, so one converted file covers both products. **Why can I only see 90 days of transactions?** That limit applies to the live bank connection, not to file imports. If you convert your full statement to a .qbo or .qfx file and import it manually, you can bring in years of history with no 90-day cap. **How do I convert a CSV to .QBO for QuickBooks Desktop?** Use the QBO Maker tool. Upload your CSV or Excel export, map Date, Description, and Amount, and download a Desktop-ready .QBO file. The conversion runs entirely in your browser, so nothing is uploaded. --- Convert free at https://qbomaker.com/#tool, runs entirely in your browser.