Lloyds TSB QIF File Import
I know that there have been several discussions about the fact that Lloyds TSB seem to invert the sign on all of the amounts in the QIF files, and that you are reluctant to fix what is actually a problem with their export. Unfortunately they don't seem interested in fixing it either and so 18 months have passed since I first encountered the problem and I'm still doing manual reconciliations.
I understand that you don't want to start hard-coding bank-specific workarounds in your product, but is there any way you could have an 'Invert Amounts during Download' checkbox against the Bank configuration as a way of handling this?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by -Kevin N. on 14 Jan, 2012 01:30 AM
Hi Andrew,
Does Lloyds TSB allow for downloads in any other formats?
With a .CSV file for example it would be easy to reverse the amounts prior to importing the data.
-Kevin N.
2 Posted by Andrew Roberts on 14 Jan, 2012 07:57 AM
Yes it does allow CSV but surely that's not such a reliable format to import.
3 Posted by -Kevin N. on 14 Jan, 2012 01:55 PM
Hi Andrew,
Unfortunately, I think the same could be said for QIF. From a user standpoint, the data in a .CSV file is much easier to manipulate.
Give the Text File Importer Extension (TFI) a try on a new, seperate MD data file to see if it works for you.
The one caveat is that due to the different register format, the TFI does not import into Investment Accounts in MD.
-Kevin N.
System closed this discussion on 31 Mar, 2015 03:40 PM.