nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reckon Bank Data issue. Account numbers not autofilling correctly

george_7029022

Hi all,

I am running Reckon accounts Premier edition 2014.

Trying to set up Reckon Bank data feed for a NAD Cheque account. I get to the step where I click 'Bankdata import' on the Online banking Centre screen.

I select the account I wish to import to (which has been set up for online banking) . When the account details come up there are errors.

The BSB is filled with my account number.

My account number is AUD.

The account type is an abbreviation of my account name.

I try to correct this in the Chart of accounts screen and the information entered on the Online Bank Details screen is correct. In the set up information it says

(Bank details will populate automatically according to the configuration in Chart of Accounts.)

Any ideas on where I am going wrong?

thanks in advance

George

Comments

george_7029022

should read NAB (National Australia Bank) cheque account. . . . . sorry George

John G

Hi George,

Welcome to the Reckon community.

Please review your setup of Banking Preferences and your Bank Account Configuration against our BankData guide at:
https://community.reckon.com.au/reckon/topics/setting_up_reckon_bankdata_for_accounts_business_2014

If you still have an issue please let us know.

regards,
John

george_7029022

Hi John,

thanks for getting back to me.

I have followed the configuration guide and cant get it to change.

As a test I set up a new dummy account using the correct bank details ie bsb and account number. I was able to import from Bankdata successfully. So the feed works. Password's are correct etc.

Below is a screen shot. You can see the data has populated in the wrong boxes. The bank details would have been entered when I was running QB2012.

The strange this is if I modify the acc number in Edit chart of accounts it will change in the Import Bank data screen. The only problem is it is putting the bank account number in the BSB box.

Any ideas?

Cheers

George

John G

Hi George,

It looks like your bank account configuration is incorrect.

Go to Lists > Chart of Accounts > right click your bank account and select Edit Account>

This is how it should end up looking:

This information will then populate into the Import Data screen.

regards,
John

george_7029022

Hi John,

Thanks again for you reply. I agree it looks like the bank details configuration is incorrect however I believe I have it set right. Screen show below. It appears that the info is not migrating correctly. When I set up the dummy account it worked fine. So my problem is only with this one account. You can see from the screen shot that it is migrating the info to the incorrect box. What is really strange if for account type it uses an abbreviated account name?

thoughts?

Cheers

George

John G

Hi George,

Then maybe in the Online Banking Centre you have indicated another bank that is not properly setup.

Choose the correct bank from the Financial Institution dropdown menu:

Hope this gets you the correct configuration.

regards,
John

george_7029022

Hi John,

Unfortunately no luck there either. I have other accounts set up there that are identified. My NAB credit card data import works fine. I can select between the different accounts.

I can't to a QIF import either because the BSB and Acc# details are incorrect. Is there any where else within Reckon I can change the online banking details. As you can see from my last post I have the details correct in online banking details but the info is not migrating across to the correct areas.

Failing that I will have to set up a new account and import the data into it. I am trying to catch up on over 12 months worth of book keeping. My main problem is that paid invoices have been recorded manually but outgoings have not been entered. I was looking forward to using the matching facility in online banking to easily add this information.

My final questions are:

Is there a back door or other area where I can edit online banking details manually?

Is there a way to bulk delete information from the chart of accounts register rather than having to delete each payment individually in the received payments area.

thanks in advance

George

John G

Hi George,

Sorry the problem is persisting.

So there is no bank or credit card account, active or inactive, with details that are appearing when you try to import bankdata?

In that case I suggest your Rebuild you data file and then Verify (when you create the backup make sure you don't overwrite existing backups). Examine the QBwin.log file and follow up on any errors.

Does the import work properly now?

If not, then create a new bank account called Test with the same configuration and try to import into it. Is this successful?

If yes, then the bank account is corrupt beyond repair. However, you can merge it to the Test bank account created by renaming it to Test like above. Once merged you can rename the bank account to the original name.

Hope one of these 2 steps overcomes this problem.

regards,
John

george_7029022

Hi John,

thanks for the response.

The second option worked a treat!

Very very happy with the help and service you have given me!

Have a great day

Thanks

George

John G

Glad that worked George.

cheers,
John.