A&L statement download

Cliff Baughen · Joined: 07 Jan 2008 Posts: 4

I have downloaded my statement (.ofx format) from Alliance & Leicester
(bank). When I import it I get the following message: File Import:
Your statement contained a default currency (GBP) which was unrelated to the
currency of the account 'Alliance & Leicester Current'. Money does not
support statements containing unrelated default currencies.

Have I set something up wrong or not set something up that I should have
done? Is there a way round this error?
The account has 'Pound' as the currency.
The offending parameter reads GBP

Cliff

Archived from group: microsoft>public>uk>money

Glyn Simpson, MVP · Joined: 02 Aug 2007 Posts: 33

See http://money.mvps.org/faq/article/38.aspx - it's a little buried in
there, so I'll separate it into a new article.

--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org

See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx

I do not respond to any unsolicited email regarding Money

"Cliff Baughen" wrote in message @microsoft.com...
>I have downloaded my statement (.ofx format) from Alliance & Leicester
> (bank). When I import it I get the following message: File Import:
> Your statement contained a default currency (GBP) which was unrelated to
> the
> currency of the account 'Alliance & Leicester Current'. Money does not
> support statements containing unrelated default currencies.
>
> Have I set something up wrong or not set something up that I should have
> done? Is there a way round this error?
> The account has 'Pound' as the currency.
> The offending parameter reads GBP
>
> Cliff

Cliff Baughen · Joined: 07 Jan 2008 Posts: 4

Thanks. That has resolved the initial problem. I have changed all of the
accounts to British Pound. However in my Investments where there are shares
and cash the Transactions are still in 'Pound' whilst the Cash is 'British
Pound' (View in 'Your Portfolio'). To make sure I've gone back into editing
the accounts, set the currency to 'Pound', converting everything to 'Pound'
and clicking 'Done' followed by the same steps but back to 'British Pound' -
but no change. As a result I can't delete the 'Pound' currency.

Cliff
PS I don't have the Planner Currency default set.
"Glyn Simpson, MVP" wrote:

> See http://money.mvps.org/faq/article/38.aspx - it's a little buried in
> there, so I'll separate it into a new article.
>
> --
> Glyn Simpson, Microsoft MVP - Money
> http://money.mvps.org
>
> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
> To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
>
> I do not respond to any unsolicited email regarding Money
>
> "Cliff Baughen" wrote in message
> @microsoft.com...
> >I have downloaded my statement (.ofx format) from Alliance & Leicester
> > (bank). When I import it I get the following message: File Import:
> > Your statement contained a default currency (GBP) which was unrelated to
> > the
> > currency of the account 'Alliance & Leicester Current'. Money does not
> > support statements containing unrelated default currencies.
> >
> > Have I set something up wrong or not set something up that I should have
> > done? Is there a way round this error?
> > The account has 'Pound' as the currency.
> > The offending parameter reads GBP
> >
> > Cliff
>
>
>

Glyn Simpson, MVP · Joined: 02 Aug 2007 Posts: 77

If everythign you can find is now in British Pound, then there will be
something well hidden. Perhaps a closed account or old investment - they
will take a while to find, but if you can now download statements, then
you're halfway there to removing the curreny.
--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org

See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx

I do not respond to any unsolicited email regarding Money

"Cliff Baughen" wrote in message @microsoft.com...
> Thanks. That has resolved the initial problem. I have changed all of the
> accounts to British Pound. However in my Investments where there are
> shares
> and cash the Transactions are still in 'Pound' whilst the Cash is 'British
> Pound' (View in 'Your Portfolio'). To make sure I've gone back into
> editing
> the accounts, set the currency to 'Pound', converting everything to
> 'Pound'
> and clicking 'Done' followed by the same steps but back to 'British
> Pound' -
> but no change. As a result I can't delete the 'Pound' currency.
>
> Cliff
> PS I don't have the Planner Currency default set.
> "Glyn Simpson, MVP" wrote:
>
>> See http://money.mvps.org/faq/article/38.aspx - it's a little buried in
>> there, so I'll separate it into a new article.
>>
>> --
>> Glyn Simpson, Microsoft MVP - Money
>> http://money.mvps.org
>>
>> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS
>> Money.
>> To send Microsoft your product wishes see
>> http://money.mvps.org/wishes.aspx
>>
>> I do not respond to any unsolicited email regarding Money
>>
>> "Cliff Baughen" wrote in message
>> @microsoft.com...
>> >I have downloaded my statement (.ofx format) from Alliance & Leicester
>> > (bank). When I import it I get the following message: File Import:
>> > Your statement contained a default currency (GBP) which was unrelated
>> > to
>> > the
>> > currency of the account 'Alliance & Leicester Current'. Money does not
>> > support statements containing unrelated default currencies.
>> >
>> > Have I set something up wrong or not set something up that I should
>> > have
>> > done? Is there a way round this error?
>> > The account has 'Pound' as the currency.
>> > The offending parameter reads GBP
>> >
>> > Cliff
>>
>>
>>

Cliff Baughen · Joined: 07 Jan 2008 Posts: 4

Thanks again. I have made progress in identifying some closed accounts. I've
been through every line in the Account List report (What I have/Account
Balances with Details) and found about a dozen cases where I have now reset.
I am still unable to delete the currency. Do you have any further suggestions
for other cases?

Thanks
Cliff

"Glyn Simpson, MVP" wrote:

> If everythign you can find is now in British Pound, then there will be
> something well hidden. Perhaps a closed account or old investment - they
> will take a while to find, but if you can now download statements, then
> you're halfway there to removing the curreny.
> --
> Glyn Simpson, Microsoft MVP - Money
> http://money.mvps.org
>
> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
> To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
>
> I do not respond to any unsolicited email regarding Money
>
>
> "Cliff Baughen" wrote in message
> @microsoft.com...
> > Thanks. That has resolved the initial problem. I have changed all of the
> > accounts to British Pound. However in my Investments where there are
> > shares
> > and cash the Transactions are still in 'Pound' whilst the Cash is 'British
> > Pound' (View in 'Your Portfolio'). To make sure I've gone back into
> > editing
> > the accounts, set the currency to 'Pound', converting everything to
> > 'Pound'
> > and clicking 'Done' followed by the same steps but back to 'British
> > Pound' -
> > but no change. As a result I can't delete the 'Pound' currency.
> >
> > Cliff
> > PS I don't have the Planner Currency default set.
> > "Glyn Simpson, MVP" wrote:
> >
> >> See http://money.mvps.org/faq/article/38.aspx - it's a little buried in
> >> there, so I'll separate it into a new article.
> >>
> >> --
> >> Glyn Simpson, Microsoft MVP - Money
> >> http://money.mvps.org
> >>
> >> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS
> >> Money.
> >> To send Microsoft your product wishes see
> >> http://money.mvps.org/wishes.aspx
> >>
> >> I do not respond to any unsolicited email regarding Money
> >>
> >> "Cliff Baughen" wrote in message
> >> @microsoft.com...
> >> >I have downloaded my statement (.ofx format) from Alliance & Leicester
> >> > (bank). When I import it I get the following message: File Import:
> >> > Your statement contained a default currency (GBP) which was unrelated
> >> > to
> >> > the
> >> > currency of the account 'Alliance & Leicester Current'. Money does not
> >> > support statements containing unrelated default currencies.
> >> >
> >> > Have I set something up wrong or not set something up that I should
> >> > have
> >> > done? Is there a way round this error?
> >> > The account has 'Pound' as the currency.
> >> > The offending parameter reads GBP
> >> >
> >> > Cliff
> >>
> >>
> >>
>

Cliff Baughen · Joined: 07 Jan 2008 Posts: 4

Following on from my reply yesterday I have noticed that in the Portfolio
view the 'Shares' part shows up as 'Pound' and the 'Cash' part as 'British
Pound'. Clicking on the 'Change Account Details' shows the currency as
'British Pound'. I tried deleting the transactions and then reentering them
but it still shows 'Pound'. I can't see anywhere to change the Investment
part. Do you have any suggestions?

Cliff

"Glyn Simpson, MVP" wrote:

> If everythign you can find is now in British Pound, then there will be
> something well hidden. Perhaps a closed account or old investment - they
> will take a while to find, but if you can now download statements, then
> you're halfway there to removing the curreny.
> --
> Glyn Simpson, Microsoft MVP - Money
> http://money.mvps.org
>
> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
> To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
>
> I do not respond to any unsolicited email regarding Money
>
>
> "Cliff Baughen" wrote in message
> @microsoft.com...
> > Thanks. That has resolved the initial problem. I have changed all of the
> > accounts to British Pound. However in my Investments where there are
> > shares
> > and cash the Transactions are still in 'Pound' whilst the Cash is 'British
> > Pound' (View in 'Your Portfolio'). To make sure I've gone back into
> > editing
> > the accounts, set the currency to 'Pound', converting everything to
> > 'Pound'
> > and clicking 'Done' followed by the same steps but back to 'British
> > Pound' -
> > but no change. As a result I can't delete the 'Pound' currency.
> >
> > Cliff
> > PS I don't have the Planner Currency default set.
> > "Glyn Simpson, MVP" wrote:
> >
> >> See http://money.mvps.org/faq/article/38.aspx - it's a little buried in
> >> there, so I'll separate it into a new article.
> >>
> >> --
> >> Glyn Simpson, Microsoft MVP - Money
> >> http://money.mvps.org
> >>
> >> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS
> >> Money.
> >> To send Microsoft your product wishes see
> >> http://money.mvps.org/wishes.aspx
> >>
> >> I do not respond to any unsolicited email regarding Money
> >>
> >> "Cliff Baughen" wrote in message
> >> @microsoft.com...
> >> >I have downloaded my statement (.ofx format) from Alliance & Leicester
> >> > (bank). When I import it I get the following message: File Import:
> >> > Your statement contained a default currency (GBP) which was unrelated
> >> > to
> >> > the
> >> > currency of the account 'Alliance & Leicester Current'. Money does not
> >> > support statements containing unrelated default currencies.
> >> >
> >> > Have I set something up wrong or not set something up that I should
> >> > have
> >> > done? Is there a way round this error?
> >> > The account has 'Pound' as the currency.
> >> > The offending parameter reads GBP
> >> >
> >> > Cliff
> >>
> >>
> >>
>

Statement Download Hi All, I hope you can help me I have just started using Money2004 and set up the various bank accounts and CC accounts that I have. I find that my Nationwide accounts work well downloading statements automatically when I open money but all the rest eith

statement download I am new to statement downloading, I have 2 questions. 1. is there anyway to make money change the transaction description to the downloaded data rather than the data I have entered ? 2. Is downloading and reconciling this way the same as balancing the ac

Bank Statement Download When I try to download a bank statement (First Direct or HSBC) I see a box which says that it is downloading to a temporary folder but nothing happens after the download is complete, and I can't find the temporary folder anywhere. It used to work ok and I

Natwest Statement download Hi, thanks for previous advice but van u help with the following? Money seems to have problem with natwest statement (as did quicken.) a downloaded OFX file gets saved in my documents but wont open in Money 2004 trial version. why doest money recognise it

Statement download not working I seem to remember this happening before and someone telling me what to do. My Natwest statement download file arrives, I click "open", but my account details are not updated - nothing happens. Any ideas? Doug