Transaction Description - Import Issue

Discussion in 'Microsoft Money UK' started by Si, Oct 2, 2010.

  1. Si

    Si Guest

    Hi everyone,
    I hope this is still the right place to post this (and the forum is
    still active).

    I have an issues. I download my statement data from Alliance &
    Leicester into Money 2003.

    A&L recently upgraded their OLB, and where as I used to have a
    description like

    "S Order To Joe Bloggs" which imported nicely into Money, I now get,
    for the same transaction the following description downloaded:

    "STANDING ORDER VIA FASTER PAYMENT TO JOE BLOGGS REFERENCE A.N.
    OTHER , MANDATE NO 0003".

    In my case, Money is truncating the description to "STANDING ORDER VIA
    FASTER PAYMEN". This is happening for all my standing orders,
    therefore Money no longer recognises which payments are which, and I
    have to manually adjust each entry.

    Is there anyway for Money to accept the whole description and not
    truncate it? This is now happening on all my Direct Debits and
    Standing Orders, only since their upgrade!

    Many thanks,

    Simon
     
    Si, Oct 2, 2010
    #1
    1. Advertisements

  2. Si

    Cal Learner Guest

    You could make a script (program) to modify the downloaded data file
    each time before File->Import to Money. Money only looks at the
    first so many characters.
     
    Cal Learner, Oct 4, 2010
    #2
    1. Advertisements

  3. Si

    genexxer

    Joined:
    Oct 11, 2012
    Messages:
    3
    Likes Received:
    0
    or even simpler, import it into excel and parse the field into two fields and save as whatever imports into money.
     
    genexxer, Oct 11, 2012
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.