Importing .CSV files

[pamarn]

I downloaded my statement but found that the debits were downloaded as credits and visa versa.
Also the credit amounts were not transferred.
There appears to be no way to edit the credit/debit entries so I have had to delete the entry and insert the correct entry as a new transaction.
Please can anyone help?

[ideasguy]

Welcome to the forum Arnold!

I have had only one report of this previously, and in response, I provided a permanent solution.
You've obviously done everything correctly so far.
Try again, and when you get to the staging screen BS412S02, use the Reverse button as explained here in the User Guide.
http://www.bankgenie.net/UserGuide/412/412S02/412s02.html#Reverse

Check what happens, and if all looks OK, click the Process button.

Does that solve the problem for you?

PS When this is resolved, I will move this topic from Ideas Genie to the Bank Genie section. It may help others

[pamarn]

The reverse button worked to change the credit to debit and visa versa but my credit amounts are still not being transferred. Although this is not a problem as on average I only get 9 credit entries a month I wondered if there was a solution?

[ideasguy]

Half way there

Ive never has reports of Credits not coming through Arnold.
What format of file did you download (e.g. csv, QIF OFX)?

Are they appearing in the Staging screen?
If no, I'd need to look at the file you've downloaded to see what's going on.
Use a normal text editor (Notepad is fine) to edit your downloaded file.
Edit out any personal details and edit amounts if necessary.
I'm looking for some Credits and some Debits in the file.
You can edit and delete most of the file, leaving at least one Credit record and one Debit.
Then please email to me as an attachment.

[pamarn]

My .CSV file attached as requested.

[ideasguy]

Gottit Arnold

Ive deleted your attachment. I meant you to send it by email
I'll look at it this afternoon.

[ideasguy]

I haven't seen that type of file before Arnold.

I can see your Credits, so will be able to make it work.
Another button required in the screen BS412S01 for that Bank.

Which Bank is it?
Reply by email if you wish or if not sensitive (I'm sure it isn't) please answer here as it may make others aware that a solution will be provided.

[pamarn]

The bank is the Nationwide Building Society FlexAccount.

Thanks for your help.

[ideasguy]

Thanks for the additional info Arnold.

I'll work on this and have something for you early next week (after the holidays ).
Have a nice Easter weekend

[ideasguy]

Hi Arnold

Download your file into a folder called Nationwide.
Use the program Online Banking Transactions-BS412
When you click the Get Downloaded file button and select the file in the Nationwide folder, two Nationwide buttons will be enabled.
Try the one on the right.
That works on the file you sent me. Let me know how it works for you.

[pamarn]

I have just downloaded a statement with credits on it and I used the right
hand Nationwide button and it worked perfectly. I didn,t have to use the
reverse button for the credits and debits.

Thanks once again for your help and prompt action.

[ideasguy]

Thanks for posting this Arnold.
I'm pleased I didn't have to make any changes