Skip to content
  • Register

    • OFX to QBO converter

    MCD2
    MCD2 Member Posts: 1 Novice Member Novice Member
    edited March 28 in Accounts Hosted

    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?

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Answers

    • Rav
      Rav Administrator, Reckon Staff Posts: 13,653 Reckon Community Manager Community Manager

      Hi @MCD2

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

    • CDK
      CDK Member Posts: 11 Reckoner Reckoner

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

    • Rav
      Rav Administrator, Reckon Staff Posts: 13,653 Reckon Community Manager Community Manager

      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
      Datarec Reckon Staff Posts: 1,282 Reckon Staff Reckon Staff

      @Rav

      I tried this online CSV converter

      https://csvconverter.biz/

      Provided it with an example CSV

      image.png

      And it generated the following QIF

      image.png

      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

      #TipTuesday - A Picture Paints A Thousand Words

      How do I add an image or screenshot to my discussion?

    • CDK
      CDK Member Posts: 11 Reckoner Reckoner

      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
      Datarec Reckon Staff Posts: 1,282 Reckon Staff Reckon Staff

      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

      #TipTuesday - A Picture Paints A Thousand Words

      How do I add an image or screenshot to my discussion?

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Quick Links

    Categories