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?
Answers
-
Yes, I was having a moment ! Mixing up QBOs and QIFs !!!
0 -
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.
0 -
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
1 -
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.
0 -
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
1 -
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.
1
Reckon Staff 
