UK
QuickBooks Desktop imports bank data through Web Connect, which expects a QBO file — so if your transactions are sitting in an Excel sheet, you need to turn them into one. This guide covers what that takes, the one limitation that trips everyone up, and an honest shortcut. The shortcut: Export Bank Statement can *produce* a QBO file, but from a PDF statement rather than from your Excel sheet. If you still have the PDF, that's the cleaner path.
What a QBO file needs
A QBO is an OFX document with QuickBooks-specific tags, so converting Excel to QBO means building all of OFX's requirements plus Intuit's:
- Each row needs a type (credit or debit), formatted dates (YYYYMMDD), and a unique transaction id so re-imports don't duplicate.
- A currency has to be declared.
- An `INTU.BID` bank identifier is required — and this is the catch. QuickBooks checks that id against its directory of participating banks and rejects files it doesn't recognise with an OL-301 error.
That bank-id requirement is why a generic Excel-to-QBO conversion often fails to import: the file can be perfectly valid yet still be refused because the bank id isn't one QuickBooks accepts.
How to convert Excel to QBO
- Tidy the Excel columns. Make sure you have a clear date, amount (with credits and debits signed consistently), and description column.
- Use a CSV/Excel-to-QBO converter that lets you set the bank id. The ability to enter an `INTU.BID` your QuickBooks recognises is what makes the difference between an import and an OL-301.
- Set a currency and account type. QBO, like OFX, needs a valid currency declared.
- Test the import on a small file first. Confirm QuickBooks accepts the bank id and that transactions aren't duplicated before importing months of data.
- Consider OFX instead — it's more forgiving. Plain OFX carries no bank id, so it imports into more tools without the OL-301 problem. See CSV to OFX.
Where Export Bank Statement fits — honestly
Export Bank Statement does not take an Excel or CSV file and convert it to QBO — its input is a PDF statement. It *can* export a QBO from a converted PDF, with stable transaction ids built in. Be aware of the same bank-id limitation: because Export Bank Statement isn't a registered financial institution, the QBO it produces uses a placeholder bank id, so QuickBooks Desktop may reject it until you set your own bank's id — and OFX is the more universally importable choice. None of that is hidden: the tool flags it on the export itself.
Frequently asked questions
Can I upload Excel to Export Bank Statement and get a QBO?keyboard_arrow_down
No. It converts PDF statements and can export QBO from the PDF. It does not take Excel or CSV as input.
Why does QuickBooks reject my QBO file?keyboard_arrow_down
Almost always the `INTU.BID` bank id isn't one QuickBooks recognises (an OL-301 error). You need a converter that lets you set a bank id QuickBooks accepts — or use OFX, which has no bank id.
Should I use QBO or OFX?keyboard_arrow_down
OFX is the safer, more widely importable format because it carries no bank id. Reach for QBO only when you specifically need QuickBooks Web Connect. See QBO to Excel.
Is it free?keyboard_arrow_down
Converting a PDF statement and exporting OFX or QBO is free to start.
Try it on your own statement
Clean Excel/CSV, with every transaction checked to balance.