Bank Data problems

  • 1
  • Question
  • Updated 3 months ago
  • Answered
I am new to using Bank Data.   I can import data from bank but can't match it to the correct account.    When I get to the box "Select Bank Account" there are 2 choices *use existing account, or * create a new Reckon account.   I want to "use existing" however the "Continue" button is not highlighted so I can't go any further The only option is to cancel.  Then I loose the bank data download.   This is day 5 of trying to solve this problem.   Each day I have to wait until the next day when there is more data to download.   Help me please.  Thank you.
Photo of Caroline Davidson

Caroline Davidson

  • 70 Points
  • Frustrated

Posted 3 months ago

  • 1
Photo of Robert Smeallie

Robert Smeallie

  • 850 Points 500 badge 2x thumb
Hi Caroline

Have you checked your existing bank account column order and name.? In order to import the bank record into Reckon they need to match each other. Open your bank account and check which items are in which column and that they are called the same name, and if you have a previously successful bank statement import note which information is in which column. They tend to be in a spreadsheet layout either Comma Separated Values (CSV) or Tab Delimited (separated) format.

Robert Smeallie
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Welcome to the Reckon Community, Caroline,

Firstly, I have requested that your transactions be restored for download - I'll be in touch again when that has been completed.

When you are on the "Select Bank Account" screen, click on the option Use an existing Reckon account and the Continue button will unlock to allow you to proceed.

A guide to configuring your company file for bankdata and downloading transactions is available here.


Will contact you later today once the transactions are restored.


regards,
John.
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
hello Caroline,

Your past transactions have been restored for you to download again.  

If your import on the Reckon Accounts phase fails to produce a file in the Online Banking Centre, do not try another download but do the following:
  1. In RAB, File > Utilities > Import > Web connect files
  2. navigate to C:\Documents\Reckon Limited, and select the olacclst.qbo file
  3. follow the Import Module prompts.
When you start a new download request with Bankdata, the olacclst.qbo file is zero'd, so you can only import the data by this secondary method before another attempt at a bankdata download is made.

Hope this helps.


regards,
John.