QuickBooks Desktop: Importing .ofx files

If you use QuickBooks Desktop you may want to import the records from your business checking account into QuickBooks. And like my bank, your bank may only provide downloads with a .ofx file extension instead of the .qbo files that QuickBooks expects. You may think it won't be possible. Or you may pay for a software add-on do convert .ofx files to .qbo file format.

This is a fairly specific topic, but if you are in this situation, here is how you can import ofx files into QuickBooks, and save yourself from hand entering the records from your business checking account.

The idea is that you will download the ofx file once a month and import the data into QuickBooks desktop.

First, open the ofx file that you downloaded from your bank in a text editor. The first lines will look like this:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE


<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20190218133654[-5:EST]
<LANGUAGE>ENG

<FI>
<ORG>Galaxy Plus
<FID>222080277
</FI>
</SONRS>
</SIGNONMSGSRSV1>

Add this line below the 'LANGUAGE' line

<INTU.BID>3000

and then save the file and exit the text editor.

Lastly, just rename the file extension from ofx to .qbo and you are done.

On a PC with QuickBooks Desktop installed, you can double click this .qbo file and QuickBooks Desktop will open and the import process will begin.

Running this import is a much easier process than importing the records manually. We hope this helps save you some time.

Comments are closed.