Transaction Description - Import Issue


S

Si

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
 
Ad

Advertisements

C

Cal Learner

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!
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.
 
Ad

Advertisements

Joined
Oct 11, 2012
Messages
3
Reaction score
0
or even simpler, import it into excel and parse the field into two fields and save as whatever imports into money.
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top