Another question on converting Microsoft Money to Quicken

Posted by Tom Barnes on June 14, 2009, 4:51 pm

Please log in for more thread options

Sorry if this is redundant, but I couldn't find much on this. I am one of
the many who are making the jump from Microsoft Money Plus to Quicken
Premier 2009 utilizing the Quicken Data Conversion tool. Had a couple of
hiccups along the way, but was finally able to make the conversion and am
working on doing the cleanup following conversion. I had several loan
accounts, as well as a mortgage account that didn't make the trip, but the
transactions from my Checking Account showing payments to those accounts
did. Basically, Quicken is allowing me to make payments to accounts that
don't display anywhere in Quicken that I can see. I attempted to create the
car loan and mortgage accounts manually and Quicken tells me that the
account names exist already. They may exist, but not anywhere I can find
them. How do I go about fixing this?? Thanks.

Posted by Jeff M on June 15, 2009, 8:21 am

Please log in for more thread options

> Sorry if this is redundant, but I couldn't find much on this. =A0I am one=

> the many who are making the jump from Microsoft Money Plus to Quicken

> Premier 2009 utilizing the Quicken Data Conversion tool. =A0Had a couple =

> hiccups along the way, but was finally able to make the conversion and am

> working on doing the cleanup following conversion. =A0I had several loan

> accounts, as well as a mortgage account that didn't make the trip, but th=

> transactions from my Checking Account showing payments to those accounts

> did. =A0Basically, Quicken is allowing me to make payments to accounts th=

> don't display anywhere in Quicken that I can see. =A0I attempted to creat=

e the

> car loan and mortgage accounts manually and Quicken tells me that the

> account names exist already. =A0They may exist, but not anywhere I can fi=

> them. =A0How do I go about fixing this?? =A0Thanks.

They don't really exist. If you look at the transfers from the
checking account, they will have the name of the loan account that you
had from Money, but it is not really a transfer. The way you can tell
is to look at the category name in the transfer. If it is in
brackets, then it is a transfer. If it is not in brackets, it is not.

So the fix, is to create accounts in Quicken that match the loan
accounts you had set up in Money. Set up the original loan amount,
interest rate, etc. Then once it is created, now go back to your
checking account and change all of those transfers, changing the name
from the account name to [account name]. The transactions in the
checking account are probably splits, so you will have to look in the
split to see the transactions.

Now here's a nice feature in Quicken. Under "edit", there is a "find
and replace" feature and under that there is a "recategorize"
selection. You can use this to search for and recategorize every
transaction that meets your search. This will speed up the process
for you.

Hope this helps. I'm a recent convert as well. I've been using
Quicken Premier 2009 in parallel with Money since this year's version
came out as I suspected Microsoft was going to do this. No Money 09
was a pretty good clue.

Jeff

Posted by No One You Know on June 15, 2009, 8:55 am

Please log in for more thread options

Jeff M wrote:

>> Sorry if this is redundant, but I couldn't find much on this. I am

>> one of the many who are making the jump from Microsoft Money Plus to

>> Quicken Premier 2009 utilizing the Quicken Data Conversion tool. Had

>> a couple of hiccups along the way, but was finally able to make the

>> conversion and am working on doing the cleanup following conversion.

>> I had several loan accounts, as well as a mortgage account that

>> didn't make the trip, but the transactions from my Checking Account

>> showing payments to those accounts did. Basically, Quicken is

>> allowing me to make payments to accounts that don't display anywhere

>> in Quicken that I can see. I attempted to create the car loan and

>> mortgage accounts manually and Quicken tells me that the account

>> names exist already. They may exist, but not anywhere I can find

>> them. How do I go about fixing this?? Thanks.

> They don't really exist. If you look at the transfers from the

> checking account, they will have the name of the loan account that you

> had from Money, but it is not really a transfer. The way you can tell

> is to look at the category name in the transfer. If it is in

> brackets, then it is a transfer. If it is not in brackets, it is not.

> So the fix, is to create accounts in Quicken that match the loan

> accounts you had set up in Money. Set up the original loan amount,

> interest rate, etc. Then once it is created, now go back to your

> checking account and change all of those transfers, changing the name

> from the account name to [account name]. The transactions in the

> checking account are probably splits, so you will have to look in the

> split to see the transactions.

There is one problem with your approach: you can not have a Quicken
account with the same name as a Quicken category.

Apparently since the conversion process couldn't convert the loan
accounts, it created Quicken categories from the loan account names. Once
that name has been used as a category, you can not create an account with
that name. That's why the op is getting the duplicate account name.

The workaround is simple: when you create the new loan(s) in Quicken, give
them unique names ... names that are not the same as any exisiting account
or category.

Once the "new" loans are established in Quicken, use Find/Replace to
change the transfers of principal from "My old account name as category",
to "[My new account name]" (without the quotes). Once all the
transactions using the old account names as categories have been
modified, the old account names can be deleted from the Category List ...
and the new account names can be modified to be the old account names, if
desired.

> Now here's a nice feature in Quicken. Under "edit", there is a "find

> and replace" feature and under that there is a "recategorize"

> selection. You can use this to search for and recategorize every

> transaction that meets your search. This will speed up the process

> for you.

> Hope this helps. I'm a recent convert as well. I've been using

> Quicken Premier 2009 in parallel with Money since this year's version

> came out as I suspected Microsoft was going to do this. No Money 09

> was a pretty good clue.

> Jeff

--

John Pollard

Posted by Tom Barnes on June 15, 2009, 11:38 am

Please log in for more thread options

This sounds like what is going on.

Thanks for the work around, as well as the find/replace feature. Both are a
big help.

Tom

> Jeff M wrote:

>>> Sorry if this is redundant, but I couldn't find much on this. I am

>>> one of the many who are making the jump from Microsoft Money Plus to

>>> Quicken Premier 2009 utilizing the Quicken Data Conversion tool. Had

>>> a couple of hiccups along the way, but was finally able to make the

>>> conversion and am working on doing the cleanup following conversion.

>>> I had several loan accounts, as well as a mortgage account that

>>> didn't make the trip, but the transactions from my Checking Account

>>> showing payments to those accounts did. Basically, Quicken is

>>> allowing me to make payments to accounts that don't display anywhere

>>> in Quicken that I can see. I attempted to create the car loan and

>>> mortgage accounts manually and Quicken tells me that the account

>>> names exist already. They may exist, but not anywhere I can find

>>> them. How do I go about fixing this?? Thanks.

>> They don't really exist. If you look at the transfers from the

>> checking account, they will have the name of the loan account that you

>> had from Money, but it is not really a transfer. The way you can tell

>> is to look at the category name in the transfer. If it is in

>> brackets, then it is a transfer. If it is not in brackets, it is not.

>> So the fix, is to create accounts in Quicken that match the loan

>> accounts you had set up in Money. Set up the original loan amount,

>> interest rate, etc. Then once it is created, now go back to your

>> checking account and change all of those transfers, changing the name

>> from the account name to [account name]. The transactions in the

>> checking account are probably splits, so you will have to look in the

>> split to see the transactions.

> There is one problem with your approach: you can not have a Quicken

> account with the same name as a Quicken category.

> Apparently since the conversion process couldn't convert the loan

> accounts, it created Quicken categories from the loan account names. Once

> that name has been used as a category, you can not create an account with

> that name. That's why the op is getting the duplicate account name.

> The workaround is simple: when you create the new loan(s) in Quicken, give

> them unique names ... names that are not the same as any exisiting account

> or category.

> Once the "new" loans are established in Quicken, use Find/Replace to

> change the transfers of principal from "My old account name as category",

> to "[My new account name]" (without the quotes). Once all the

> transactions using the old account names as categories have been modified,

> the old account names can be deleted from the Category List ... and the

> new account names can be modified to be the old account names, if desired.

>> Now here's a nice feature in Quicken. Under "edit", there is a "find

>> and replace" feature and under that there is a "recategorize"

>> selection. You can use this to search for and recategorize every

>> transaction that meets your search. This will speed up the process

>> for you.

>> Hope this helps. I'm a recent convert as well. I've been using

>> Quicken Premier 2009 in parallel with Money since this year's version

>> came out as I suspected Microsoft was going to do this. No Money 09

>> was a pretty good clue.

>> Jeff

> --

> John Pollard

Posted by Jeff M on June 15, 2009, 12:44 pm

Please log in for more thread options

> Jeff M wrote:

> >> Sorry if this is redundant, but I couldn't find much on this. I am

> >> one of the many who are making the jump from Microsoft Money Plus to

> >> Quicken Premier 2009 utilizing the Quicken Data Conversion tool. Had

> >> a couple of hiccups along the way, but was finally able to make the

> >> conversion and am working on doing the cleanup following conversion.

> >> I had several loan accounts, as well as a mortgage account that

> >> didn't make the trip, but the transactions from my Checking Account

> >> showing payments to those accounts did. Basically, Quicken is

> >> allowing me to make payments to accounts that don't display anywhere

> >> in Quicken that I can see. I attempted to create the car loan and

> >> mortgage accounts manually and Quicken tells me that the account

> >> names exist already. They may exist, but not anywhere I can find

> >> them. How do I go about fixing this?? Thanks.

> > They don't really exist. =A0If you look at the transfers from the

> > checking account, they will have the name of the loan account that you

> > had from Money, but it is not really a transfer. =A0The way you can tel=

> > is to look at the category name in the transfer. =A0If it is in

> > brackets, then it is a transfer. =A0If it is not in brackets, it is not=

> > So the fix, is to create accounts in Quicken that match the loan

> > accounts you had set up in Money. =A0Set up the original loan amount,

> > interest rate, etc. =A0Then once it is created, now go back to your

> > checking account and change all of those transfers, changing the name

> > from the account name to [account name]. =A0 The transactions in the

> > checking account are probably splits, so you will have to look in the

> > split to see the transactions.

> There is one problem with your approach: you can not have a Quicken

> account with the same name as a Quicken category.

> Apparently since the conversion process couldn't convert the loan

> accounts, it created Quicken categories from the loan account names. =A0O=

nce

> that name has been used as a category, you can not create an account with

> that name. =A0That's why the op is getting the duplicate account name.

> The workaround is simple: when you create the new loan(s) in Quicken, giv=

> them unique names ... names that are not the same as any exisiting accoun=

> or category.

> Once the "new" loans are established in Quicken, use Find/Replace to

> change the transfers of principal from "My old account name as category",

> to "[My new account name]" (without the quotes). =A0Once all the

> transactions using the old account names as categories have been

> modified, the old account names can be deleted from the Category List ...

> and the new account names can be modified to be the old account names, if

> desired.

> > Now here's a nice feature in Quicken. =A0Under "edit", there is a "find

> > and replace" feature and under that there is a "recategorize"

> > selection. =A0You can use this to search for and recategorize every

> > transaction that meets your search. =A0This will speed up the process

> > for you.

> > Hope this helps. =A0I'm a recent convert as well. =A0I've been using

> > Quicken Premier 2009 in parallel with Money since this year's version

> > came out as I suspected Microsoft was going to do this. =A0No Money 09

> > was a pretty good clue.

> > Jeff

> --

> John Pollard- Hide quoted text -

> - Show quoted text -

Good catch and thanks. I had forgotten that I had taken that step.