It appears I can't import my banking .qif or .qbo data files into reckon WITHOUT providing all my private bank details

  • 1
  • Question
  • Updated 9 months ago
  • Answered

I can't import my bank data files.

I'm using Reckon Accounts Premier Contractor Edition 2014 offline on a desktop computer.   I am trying to save data entry time by importing my data from my bank accounts into Reckon.  

I have easy access to all the data files downloaded and available on my desktop in QIF, QBO and CSV formats if required.   None of them will work and my research indicates that it is because I haven't entered all my online banking details and given them to Reckon. 

This seems a major intrusion and security risk that Reckon seems to be forcing me to provide all my personal banking details in order to simply import data.  Having been a victim of cyber and identity fraud in the past I don't want all my actual banking account numbers and details in my Reckon accounting files as I keep it all separate - both for privacy and security reasons.

Do I have to provide all my banking details to Reckon to use the import function with a simple data import?

If so, why?

Or am I misunderstanding how to use what should be a most basic import function?

Thank you for any assistance you can provide to clarify this for me.

Photo of Peter

Peter

  • 160 Points 100 badge 2x thumb
  • very frustrated

Posted 9 months ago

  • 1
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Hello Peter,

Thanks for asking.

Importing your bank transactions through QIF formatted files you create on your bank website is a fairly straightforward process and does not require any interact with Reckon.

When creating your export file, make sure it is a QIF file, and if your bank offers more than one QIF format, select the AUS Quicken option, or choose the date format as dd/mm/yyyy.

In your company file go to Banking > Import Bank Statements and follow the prompts to select your imported file and assign to a bank ledger account.

Only if you wish to utilise the automated bank transaction update through BankData (a paid service) will you be required to submit a bank authority form for approval, or where your connection needs to be done through our alternative channel provided by Yodlee Inc, provide your bank online credentials to them to access your accounts daily.  


regards,
John.
Photo of Peter

Peter

  • 160 Points 100 badge 2x thumb
Thankyou John.

My Westpac Ignite card offers QIF (which is one that didn't work when I have tried it earlier) / QIF abbreviated / QIF for Mac and QIF abbreviated for Mac. I was choosing the date format you describe but there is another DD/MM/CCYY.   I have no idea if the CC reference might help?

The other problem I'm finding is that at the point of importing, I am supposed to select my account in reckons dropdown list - but it isn't showing up to select.

Kind regards
Peter
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Thanks Peter,

You may have to click on the Use an existing Reckon Account option to unlock the account options to select.





regards,
John 
Photo of Peter

Peter

  • 160 Points 100 badge 2x thumb
Thanks again John,
I found I had to go into my Chart of accounts,
Right click on the account I want to import to and select 'Edit account'
Then select the Online Bank Details tab
Tick the online account access
and then enter banking info (which is what I didn't want to do)
But I found I could enter minimal details in there and it worked
Once done, this results in a lightning bolt showing up next to this account in the Chart of Accounts.
It has all worked reasonably well from there.
Thank you for your responses and assistance.
Peter