Lloyds TSB QIF File Import

Andrew Roberts's Avatar

Andrew Roberts

14 Jan, 2012 12:17 AM

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?

  1. 1 Posted by -Kevin N. on 14 Jan, 2012 01:30 AM

    -Kevin N.'s Avatar

    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. 2 Posted by Andrew Roberts on 14 Jan, 2012 07:57 AM

    Andrew Roberts's Avatar

    Yes it does allow CSV but surely that's not such a reliable format to import.

  3. 3 Posted by -Kevin N. on 14 Jan, 2012 01:55 PM

    -Kevin N.'s Avatar

    Hi Andrew,

    ...surely that's not such a reliable format to import.

    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.

  4. System closed this discussion on 31 Mar, 2015 03:40 PM.

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