OFX to QBO converter

I am in New Zealand. I export the bank files for my client's rental property for importing into Reckon Hosted once a year. Their bank no longer supports QBI exports. I can get CSV, OFX, JSON, PDF. This is just a small set of accounts but there are quite a few transactions. If I'd known there would no longer be QBI files I might have keyed the data once a month. Hindsight is a wonderful thing. I'm looking for a safe cheap, or free, converter for an annual conversion of files. It is not worth paying a full subscription, I may as well key the data in. Any recommendations?

Accepted answers

All comments

Rav

Hi @MCD2

Just to clarify, when you say the bank no longer offers QBI exports, do you mean a QIF file export?

CDK

Yes, I was having a moment ! Mixing up QBOs and QIFs !!!

Rav

I've had a look around and while I've found some online sites on Google that offer conversions of file types eg. OFX to QIF, they're all 3rd parties which we have no affiliation with so can't recommend or endorse them.

While they may do what you're looking for, using a 3rd party file conversion is at your own risk and discretion.

This thread is open though so perhaps fellow Community members may be able to offer some insights or reviews on whether any conversion tools or services.

Datarec

@Rav

I tried this online CSV converter

https://csvconverter.biz/

Provided it with an example CSV

And it generated the following QIF

And as you indicated "using a 3rd party file conversion is at your own risk and discretion."

If a user is familiar with or proficient with Excel, a script could be written.

CDK

Thanks for the info. I'm a bit concerned about security when converting a file on line so I might get some test data to try first.

Datarec

Hi @CDK

If an online tool (free/paid) is not preferred, then likely a paid desktop software may be available.

Alternatively, you may want to develop your own CSV to QIF conversion tool in Excel if you are familiar with scripting or can get someone to do it for you.

If feeling adventurous, you may even be able to get a satisfactory result using the aid of an AI LLM like ChatGPT or similar to help you create the VBA code that can run in Excel.

CDK

I tried ChatGPT. It gave me a Python file which did not work in Excel. I asked for a VBA script instead but it had errors that I couldn't fix. After a lot of messing around, I asked it to convert the Python file to VBA. Whoo, hoo, it converted the CSV file to QIF without issues. I then converted the QIF file to QBO in Reckon several times and it wouldn't import. I was about to give up when I decided to check the CSV layout. I'd put the value and description the wrong way around. Changed them around. Works like a dream. The end result below. I hope it's helpful for someone else.

Provisio: only on one transaction line but I'm going to assume a whole transaction file will work.

And, I did have to sign up to free ChatGPT in the end because I messed around and made too many changes but if I'd know what I was doing from the outset, I could probably have done it without signing up.

Thank you for the help. I would never have thought of using AI myself.

Datarec

Hi @CDK

Glad to hear you've had success with this and solved an issue with an added bonus of learning something new along the way.

Reckon Accounts Hosted Announcements & Important Info

Don't miss announcements and important info for Reckon Accounts Hosted

Button

Reckon Accounts Hosted Ideas & Feature Requests 💡

Do you have an idea for a feature in Reckon Accounts Hosted? Let us know here!

Button