Importing from Bank Statement

  • 2
  • Question
  • Updated 3 years ago
  • Answered
Upgraded today to Reckon Accounts Plus 2017.  Am attempting to import bank statements for first time, despite being a long-time user of Reckon/Quickbooks. 
am being asked "which app" to open the QIF files. 
Have a few choices:  Money Wallet,Explore Excel, Editable Word, Editable PDF.
Being completely new to this process .. can I please have a SUGGESTION??
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
  • unsure and needing expert advice that works!!

Posted 3 years ago

  • 2
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,814 Points 50k badge 2x thumb
Are you using the import function?
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
Yes Kevin.  Have the window open "Import Bank Statement" and have the "File to convert" already from the bank.    But need an app to open it?
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,814 Points 50k badge 2x thumb
No you dont. Are you importing the qif file?
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
It's downloaded already .. now I'm completing the window which says "QIF file to convert.  Have the file number in there. 
Next box says "Save Converted File As"  and when I browse all the Reckon Accounts 2017 folders come up .. 
Don't know which one to select.   ABA/ABAPages/ADT/certs/Components/Contractors/Convert02/Data/navigator
that will be saved as a QBO File
Doesn't mean much to me I'm sorry.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,814 Points 50k badge 2x thumb
Save it as a qbo file.
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
And don't worry about all those folder names?
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,814 Points 50k badge 2x thumb
Nope
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
Next line says "Account to Import into".  What kind of account?   It doesn't give any kind of guidance and it won't bring up the "what if my account doesn't appear in the above list?" which might have given me a clue.
Sorry if I'm seeming thick.  It's just foreign at present .. once I "get it" I'll be fine.
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Margot,

Have a look at the guide for importing BankData transactions here.  Go to the section "Import your bank transactions" three quarters way down the article for steps and pictures of this process.


Hope this helps.


regards,
John
Photo of Margot

Margot

  • 422 Points 250 badge 2x thumb
Thank you John.  I'll certainly look.  Have just quickly scrolled through: am on another project till a bit later.   
Looking around since my last post I found this, on good ole' Dr Google:
  
"The Import Bank Statement window will appear
  1. Click the Browse button to the right of the QIF File to Convert field.
  2. Select the location of your saved bank statement file.
  3. Select your bank account from the drop down menu of theQuickBooks Account to Import into field.
  4. Click OK to continue."
Will try both and let you know!   

Thanks again!