Ideas Genie > General discussion

Importing .CSV files

(1/3) > >>

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.

Navigation

[0] Message Index

[#] Next page