Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 01-04-2005, 04:51 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account

In microsoft.public.money, Angie wrote:

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Angie wrote:
> > > > > > I have also tried importing the investment account into a new money file as
> > > the only file. I was hoping I'd see the transactions for the checks I had
> > > written as they did not involve any transfers. However, I don't see those
> > > transactions either. I assume I should at least see those.
> > > When you did your QIF exports, you should have done two exports for

> > each investment account: the investment transactions, and the cash
> > transactions. Did you?

> I was not given the option of exporting the cash account. It did not appear
> on the list of accounts that could be exported.


I think there may be your problem. When you do File-> Export in Money
2005, you enter a filename for the QIF, then get a popup box asking
if you are exporting a regular or an investment account. To export
the cash portion of an investment account, you have to select
"Regular".


  #5  
Old 01-04-2005, 04:43 AM
Angie
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Angie wrote:
> > > I have also tried importing the investment account into a new money file as

> > the only file. I was hoping I'd see the transactions for the checks I had
> > written as they did not involve any transfers. However, I don't see those
> > transactions either. I assume I should at least see those.

> When you did your QIF exports, you should have done two exports for
> each investment account: the investment transactions, and the cash
> transactions. Did you?


I was not given the option of exporting the cash account. It did not appear
on the list of accounts that could be exported.

- quote -

> > > I could either live with the situation and use the workaround -- or finish
> > the rebuilding process. My concern is that my investment accounts may be
> > corrupt or have some bigger problem later. It sure would be many fewer hours
> > to live with the problem.
> > > > Do you see any other options I could try -- or am I really left with needed

> > to find a way to manually rebuild the file? I can see the accounts after I
> > import the QIFs. Just wish I had all the transaction history in the account
> > as well.

> You did import all of the QIF files all at once using Ctrl+<shift> ,
> right?


I did select all the QIFs when I imported so that it was done at one time.

I have also tried going back to earlier backups -- but non of the older
backups will let me open them. It wants a password using a single line
versus the account, password I see from .Net. I can't figure out how to get
it to open. I did change my passport during that time - -but it doesn't even
let me enter a different passport.

  #4  
Old 01-04-2005, 03:22 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account

In microsoft.public.money, Angie wrote:

- quote -

> I have also tried importing the investment account into a new money file as
> the only file. I was hoping I'd see the transactions for the checks I had
> written as they did not involve any transfers. However, I don't see those
> transactions either. I assume I should at least see those.


When you did your QIF exports, you should have done two exports for
each investment account: the investment transactions, and the cash
transactions. Did you?

- quote -

> I could either live with the situation and use the workaround -- or finish
> the rebuilding process. My concern is that my investment accounts may be
> corrupt or have some bigger problem later. It sure would be many fewer hours
> to live with the problem.
> Do you see any other options I could try -- or am I really left with needed
> to find a way to manually rebuild the file? I can see the accounts after I
> import the QIFs. Just wish I had all the transaction history in the account
> as well.


You did import all of the QIF files all at once using Ctrl+<shift> ,
right?

  #3  
Old 01-04-2005, 03:17 AM
Angie
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account

I have already tried both the quick and the standard repair. That did not
solve the issue.

I tried your suggestion to switch to the 2 field category (I was using 1).
It autocompletes if I enter the "Pay to" name -- and have already done a
similar transfer. However, when I tried doing a transfer by saying
"withdrawal" -- it wanted to setup the account for Charles Schwab One. I
figured I'd try -- but it did not give me an option to setup an investment
account as one of the options.

I have also tried importing the investment account into a new money file as
the only file. I was hoping I'd see the transactions for the checks I had
written as they did not involve any transfers. However, I don't see those
transactions either. I assume I should at least see those.

I could either live with the situation and use the workaround -- or finish
the rebuilding process. My concern is that my investment accounts may be
corrupt or have some bigger problem later. It sure would be many fewer hours
to live with the problem.


Do you see any other options I could try -- or am I really left with needed
to find a way to manually rebuild the file? I can see the accounts after I
import the QIFs. Just wish I had all the transaction history in the account
as well.

Thanks for your help.

Angie


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Angie wrote:
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Angie wrote:
> > > > > > I no longer see a list my investment account's associated cash accounts in
> > > > the drop down when I go to transfer money from my checking account to a cash
> > > > account associated with an investment account. I can work around it by
> > > > knowing what to type -- but that isn't any fun.
> > > > > For each investment account, go to the Account Details. Click
> > > Rename. Check the box for AllowAccountTransactions.
> > > I checked each account -- and they all had the check box checked. I can see

> > the account names with (cash) if I run an account balances report -- but it
> > does not show up on the account drop down list when I want to transfer.

> Strange.
> You might try changing the
> Tools-> Options-> Categories-> UseASingleListForCategoriesAndSubcategories....
> to the opposite that it is now.
> Also try typing transfer:accountName.... and see if it autocompletes
> as you type. Perhaps that will shake something loose.
> I assume you have already tried
> File-> RepairMoneyFile-> QuickFileRepair
> > > > > > > > > > After doing all the salvage stuff to no avail -- MS Support has suggested
> > > > that I rebuild my money file by exporting to QIF and importing. I now see
> > > > the accounts -- but have lots of cleanup to do to get my data accurate. (8
> > > > years of information) The resulting problem I am experiencing is that none of
> > > > the non-investment transactions in the cash accounts get exported. For
> > > > example, non of the checks drawn on my Schwab One account.
> > > > > > > Is the lack of transfer of checks by design? (I am already painfully aware
> > > > of the lack of stock options and calls/puts) If not -- is there a fix?
> > > > > I don't know what you mean by that.
> > > Support asked me to export all my accounts via QIF and then make a new Money

> > file. I am aware of some of the limitations of QIF in that it doesn't export
> > employee stock option accounts or any calls/puts within an investment
> > account. However, in my case it did not export any of the transactions in my
> > cash account (Schwab One (Cash)). I have

> A really non-obvious thing: Richard Bollar has discovered that it
> is important that the investment accounts be imported first in the
> process. How? Name the QIF files such that they come first
> alphabetically. So you could, for example, lead off each
> investment account's QIF file name with an underscore. That will
> alphabetize before numbers and letters.
> I don't know that that would have accounted for your symptom. But if
> you still have your QIF files, you could try that into a new Money
> file.
> > > > > > > > > > > > Is there some other way to address the original problem of not seeing the
> > > > cash accounts? (I don't see any investment accounts for which I download
> > > > statements. I do see the one account that does not get downloaded.)
> > > > > > > (I am using Money 2004 Premium. Problem originated when I tried to move
> > > > back to a backup after having tried Money 2005. It is a long story -- but
> > > > hopefully has a simple ending.)
> > > > > Was that a QIF export/import thing, or reverting to your .m12 copy?
> > > If QIF, can you re-import those?
> > > I am doing an QIF export/import thing from the backup that 2005 created

> > before it started the conversion. So - I am using .m12 versions of files.

> The .m12 file that I referred to is that Money 2005 made a *.m12
> copy of your Money 2004 file when it converted your Money 2004 file.
> That file would not have later transactions in it however.

  #2  
Old 01-04-2005, 01:58 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account

In microsoft.public.money, Angie wrote:

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Angie wrote:
> > > > I no longer see a list my investment account's associated cash accounts in
> > > the drop down when I go to transfer money from my checking account to a cash
> > > account associated with an investment account. I can work around it by
> > > knowing what to type -- but that isn't any fun.
> > > For each investment account, go to the Account Details. Click

> > Rename. Check the box for AllowAccountTransactions.

> I checked each account -- and they all had the check box checked. I can see
> the account names with (cash) if I run an account balances report -- but it
> does not show up on the account drop down list when I want to transfer.


Strange.

You might try changing the
Tools-> Options-> Categories-> UseASingleListForCategoriesAndSubcategories....
to the opposite that it is now.

Also try typing transfer:accountName.... and see if it autocompletes
as you type. Perhaps that will shake something loose.

I assume you have already tried
File-> RepairMoneyFile-> QuickFileRepair

- quote -

> > > > > > After doing all the salvage stuff to no avail -- MS Support has suggested
> > > that I rebuild my money file by exporting to QIF and importing. I now see
> > > the accounts -- but have lots of cleanup to do to get my data accurate. (8
> > > years of information) The resulting problem I am experiencing is that none of
> > > the non-investment transactions in the cash accounts get exported. For
> > > example, non of the checks drawn on my Schwab One account.
> > > > > Is the lack of transfer of checks by design? (I am already painfully aware
> > > of the lack of stock options and calls/puts) If not -- is there a fix?
> > > I don't know what you mean by that.

> Support asked me to export all my accounts via QIF and then make a new Money
> file. I am aware of some of the limitations of QIF in that it doesn't export
> employee stock option accounts or any calls/puts within an investment
> account. However, in my case it did not export any of the transactions in my
> cash account (Schwab One (Cash)). I have



A really non-obvious thing: Richard Bollar has discovered that it
is important that the investment accounts be imported first in the
process. How? Name the QIF files such that they come first
alphabetically. So you could, for example, lead off each
investment account's QIF file name with an underscore. That will
alphabetize before numbers and letters.

I don't know that that would have accounted for your symptom. But if
you still have your QIF files, you could try that into a new Money
file.



- quote -

> > > > > > > Is there some other way to address the original problem of not seeing the
> > > cash accounts? (I don't see any investment accounts for which I download
> > > statements. I do see the one account that does not get downloaded.)
> > > > > (I am using Money 2004 Premium. Problem originated when I tried to move
> > > back to a backup after having tried Money 2005. It is a long story -- but
> > > hopefully has a simple ending.)
> > > Was that a QIF export/import thing, or reverting to your .m12 copy?

> > If QIF, can you re-import those?

> I am doing an QIF export/import thing from the backup that 2005 created
> before it started the conversion. So - I am using .m12 versions of files.


The .m12 file that I referred to is that Money 2005 made a *.m12
copy of your Money 2004 file when it converted your Money 2004 file.
That file would not have later transactions in it however.

  #1  
Old 01-04-2005, 01:21 AM
Angie
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Angie wrote:
> > I no longer see a list my investment account's associated cash accounts in
> > the drop down when I go to transfer money from my checking account to a cash
> > account associated with an investment account. I can work around it by
> > knowing what to type -- but that isn't any fun.

> For each investment account, go to the Account Details. Click
> Rename. Check the box for AllowAccountTransactions.


I checked each account -- and they all had the check box checked. I can see
the account names with (cash) if I run an account balances report -- but it
does not show up on the account drop down list when I want to transfer.

- quote -

> > > After doing all the salvage stuff to no avail -- MS Support has suggested
> > that I rebuild my money file by exporting to QIF and importing. I now see
> > the accounts -- but have lots of cleanup to do to get my data accurate. (8
> > years of information) The resulting problem I am experiencing is that none of
> > the non-investment transactions in the cash accounts get exported. For
> > example, non of the checks drawn on my Schwab One account.
> > > Is the lack of transfer of checks by design? (I am already painfully aware

> > of the lack of stock options and calls/puts) If not -- is there a fix?

> I don't know what you mean by that.


Support asked me to export all my accounts via QIF and then make a new Money
file. I am aware of some of the limitations of QIF in that it doesn't export
employee stock option accounts or any calls/puts within an investment
account. However, in my case it did not export any of the transactions in my
cash account (Schwab One (Cash)). I have

- quote -

> > > Is there some other way to address the original problem of not seeing the
> > cash accounts? (I don't see any investment accounts for which I download
> > statements. I do see the one account that does not get downloaded.)
> > > (I am using Money 2004 Premium. Problem originated when I tried to move

> > back to a backup after having tried Money 2005. It is a long story -- but
> > hopefully has a simple ending.)

> Was that a QIF export/import thing, or reverting to your .m12 copy?
> If QIF, can you re-import those?


I am doing an QIF export/import thing from the backup that 2005 created
before it started the conversion. So - I am using .m12 versions of files.

 
Old 01-04-2005, 01:06 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Exporting and reimporting an Investment account

In microsoft.public.money, Angie wrote:

- quote -

> I no longer see a list my investment account's associated cash accounts in
> the drop down when I go to transfer money from my checking account to a cash
> account associated with an investment account. I can work around it by
> knowing what to type -- but that isn't any fun.


For each investment account, go to the Account Details. Click
Rename. Check the box for AllowAccountTransactions.

- quote -

> After doing all the salvage stuff to no avail -- MS Support has suggested
> that I rebuild my money file by exporting to QIF and importing. I now see
> the accounts -- but have lots of cleanup to do to get my data accurate. (8
> years of information) The resulting problem I am experiencing is that none of
> the non-investment transactions in the cash accounts get exported. For
> example, non of the checks drawn on my Schwab One account.
> Is the lack of transfer of checks by design? (I am already painfully aware
> of the lack of stock options and calls/puts) If not -- is there a fix?


I don't know what you mean by that.


- quote -

> Is there some other way to address the original problem of not seeing the
> cash accounts? (I don't see any investment accounts for which I download
> statements. I do see the one account that does not get downloaded.)
> (I am using Money 2004 Premium. Problem originated when I tried to move
> back to a backup after having tried Money 2005. It is a long story -- but
> hopefully has a simple ending.)


Was that a QIF export/import thing, or reverting to your .m12 copy?
If QIF, can you re-import those?


  #-1  
Old 01-04-2005, 12:39 AM
Angie
Guest
 
Posts: n/a
Default Exporting and reimporting an Investment account

I no longer see a list my investment account's associated cash accounts in
the drop down when I go to transfer money from my checking account to a cash
account associated with an investment account. I can work around it by
knowing what to type -- but that isn't any fun.

After doing all the salvage stuff to no avail -- MS Support has suggested
that I rebuild my money file by exporting to QIF and importing. I now see
the accounts -- but have lots of cleanup to do to get my data accurate. (8
years of information) The resulting problem I am experiencing is that none of
the non-investment transactions in the cash accounts get exported. For
example, non of the checks drawn on my Schwab One account.

Is the lack of transfer of checks by design? (I am already painfully aware
of the lack of stock options and calls/puts) If not -- is there a fix?

Is there some other way to address the original problem of not seeing the
cash accounts? (I don't see any investment accounts for which I download
statements. I do see the one account that does not get downloaded.)

(I am using Money 2004 Premium. Problem originated when I tried to move
back to a backup after having tried Money 2005. It is a long story -- but
hopefully has a simple ending.)

Any help would be greatly appreciated!!!
 

Tags
account, exporting, investment, reimporting
Similar Threads
Thread Forum Replies Last Post
Using Investment "Cash" account for a Savings Account?
Jeff P.: I just joined another credit union for the sole purpose of purchasing certificates of deposits there. To maintain a membership, they require that...
Microsoft Money 2 08-08-2004 08:41 PM
exporting into wrong bank account...
pat: exporting into wrong bank account b/c there is no dialog box that asks what account to export to when using a banks website. How do I get Money to...
Microsoft Money 1 04-24-2004 12:35 PM
Sweep Account Within an Investment Account question?
Retired Coal Miner: I can't figure out how I should be recording the monthly dividend paid by a money market fund, when used as the sweep fund, in an Investment...
Microsoft Money 1 01-18-2004 05:00 AM
Exporting *Multiple* Investment Accounts in M2003 to comma or tab delineated
William L. Oppenheim, M.D.: Want to create comma delineated or QIF exoports. Is there anyway to accomplish this easily for multiple investment accounts. Export only does...
Microsoft Money 2 10-05-2003 12:21 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 05:08 AM.