Close this search box.

Create OFX (.QBO) Files from an Excel Spreadsheet with Banking data

Most US major banks give QuickBooks users the ability to download a .QBO file which enables “Online Banking” or now in 2014 called: “Bank Feeds”.  This allows the user to significantly speed up data entry from bank transactions are matching cleared transactions to increase efficiency when reconciling the banks.

But, what if the Bank you are working on does not give you the ability to download a QBO file?

Instead it lets you download a .QIF or .CSV (Excel) file.  Then I got good news, so, assuming that you got a spreadsheet like this already:


Contains date, check number, payee, memo/description, and amount.. and these are all transactions that cleared the bank.  Even if the spreadsheet is NOT exported from the bank, but manually created, this technique works great…

with this program:

QIF to OFX Converter from Big Red Consulting

You can within excel, convert the spreadsheet to a QBO file:



With options such as bank name, account number etc.. once you convert to .QBO it will import into Online Banking within QuickBooks just like a regular bank would!




You can even download a free trial to see how it works, for $59 its a steal and It has saved me personally hundreds of data entry hours in the last few years.



Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published. Required fields are marked *

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course


30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022