Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 12-30-2004, 05:01 PM
Mark
Guest
 
Posts: n/a
Default Re: retroactively update share purchases??

If you have both buys and sells for the same investment, and want to adjust
old transactions, the easiest way to avoid this error may be to enter a
"bogus" Buy dated well before all of the transactions for a huge quantity.

This overcomes the issue where you have a Sell in the register but haven't
yet entered the initial Buy (or that purchase was dated after the sell)

Then after you're all done (and confirm that the ending postition - current
number of shares is only off by the "bogus" purchase amount), then you can
delete that bogus Buy.

Another thing, since there could be some rounding difference, if you are not
entering whole shares, then be sure to enter the share quantity exactly and
let money calculate the price per share. i.e. if you purchased $100 worth of
shares priced at $33.33 enter it as 3.333 shares, put in $100 for the total
and let Money calculate the price as $33.33333...

-Mark

"Marianne Seckel" <marianne.seckel[at]us.army.mil> wrote in message
news:%23QSYBxn7EHA.1400[at]TK2MSFTNGP11.phx.gbl...
- quote -

> Cal,
> thanks for the quick response. That makes sense I'll change my recurring
> transactions. However, is there any way to get past this error message

and
> clean up my last few months?
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:j7o6t05idr5463oafh65iv832281erii7s[at]4ax.com...
> > In microsoft.public.money, Marianne Seckel wrote:
> > > > > > My checking account is debited for investment purchases every month. A

> few
> > > days after that, my funds purchase new shares in each of several funds

> from
> > > that same transaction. The way I have it set up, I have one

transaction
> > > which is split to make these purchases.
> > > > > for example
> > > on 1 December, my checking account is debited $100. Say, on december

> 5th,
> > > my fund company actually buys the shares for 4 funds at the closing

price
> > > for that day (fund1 - $25, fund2 - $25, fund3 = 35, fund4 = $15).
> > > The way I would handle this is to enter/change the debiting to a

> > Transfer:MutualFundAccount(cash) via using the SPECIAL categories at
> > the bottom of the Category list.
> > > Then on the 5th I would enter the Buys with the investment cash

> > account being the source of the funds.
> > > > > > As a result of this, I have to go back to update the actual "buy"

> figures
> > > of investment fund purchases for price and quantity.
> > > When I make the changes, I get an error message that says "the changes

> you
> > > are making will cause the share balance of XXX to become negative at

some
> > > point Please adjust your transactions to avoid this." It is not the

> same
> > > fund every time, and does not necessarily reflect the fund I am

updating.
> I
> > > have tried to fnd info on this, but have only found suggestions

relating
> to
> > > "sells". Why am I getting this error when I am buying and doing

nothing
> to
> > > remove shares? Any help on this would be great!
> > > That is strange. The only thing that comes to mind is that the

> > mutual fund account is somehow downloading balance information.
> > Money offered to do RemoveShares to make your holdings match what
> > was downloaded as fund holdings, and you accepted.
> > > It could be something else happening, but I can't think of what it

> > would be. Your method of entering estimated Buy transactions and
> > then changing the Quantity field later seems like it should work
> > without error.


  #2  
Old 12-30-2004, 01:51 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: retroactively update share purchases??

In microsoft.public.money, Marianne Seckel wrote:

- quote -

> thanks for the quick response. That makes sense I'll change my recurring
> transactions. However, is there any way to get past this error message and
> clean up my last few months?


I was only speculating. Yours is not a common problem.

If the hypothesis of RemoveShares transactions turns out to be
right, you might View:sortByActivity the register. That would put
them together. I would then void each (or at least the most recent)
and make your changes. After things are right, you can delete the
voided transactions. The advantage of keeping them voided for a
while is that you can un-void, turn them into Sell transactions as
appropriate, or whatever seems appropriate.

When making big changes it never hurts to have an extra backup file.

  #1  
Old 12-30-2004, 01:30 PM
Marianne Seckel
Guest
 
Posts: n/a
Default Re: retroactively update share purchases??

Cal,

thanks for the quick response. That makes sense I'll change my recurring
transactions. However, is there any way to get past this error message and
clean up my last few months?

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:j7o6t05idr5463oafh65iv832281erii7s[at]4ax.com...
- quote -

> In microsoft.public.money, Marianne Seckel wrote:
> > > My checking account is debited for investment purchases every month. A

few
> > days after that, my funds purchase new shares in each of several funds

from
> > that same transaction. The way I have it set up, I have one transaction
> > which is split to make these purchases.
> > > for example

> > on 1 December, my checking account is debited $100. Say, on december

5th,
> > my fund company actually buys the shares for 4 funds at the closing price
> > for that day (fund1 - $25, fund2 - $25, fund3 = 35, fund4 = $15).

> The way I would handle this is to enter/change the debiting to a
> Transfer:MutualFundAccount(cash) via using the SPECIAL categories at
> the bottom of the Category list.
> Then on the 5th I would enter the Buys with the investment cash
> account being the source of the funds.
> > > As a result of this, I have to go back to update the actual "buy"

figures
> > of investment fund purchases for price and quantity.
> > When I make the changes, I get an error message that says "the changes

you
> > are making will cause the share balance of XXX to become negative at some
> > point Please adjust your transactions to avoid this." It is not the

same
> > fund every time, and does not necessarily reflect the fund I am updating.

I
> > have tried to fnd info on this, but have only found suggestions relating

to
> > "sells". Why am I getting this error when I am buying and doing nothing

to
> > remove shares? Any help on this would be great!

> That is strange. The only thing that comes to mind is that the
> mutual fund account is somehow downloading balance information.
> Money offered to do RemoveShares to make your holdings match what
> was downloaded as fund holdings, and you accepted.
> It could be something else happening, but I can't think of what it
> would be. Your method of entering estimated Buy transactions and
> then changing the Quantity field later seems like it should work
> without error.



 
Old 12-30-2004, 01:05 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: retroactively update share purchases??

In microsoft.public.money, Marianne Seckel wrote:

- quote -

> My checking account is debited for investment purchases every month. A few
> days after that, my funds purchase new shares in each of several funds from
> that same transaction. The way I have it set up, I have one transaction
> which is split to make these purchases.
> for example
> on 1 December, my checking account is debited $100. Say, on december 5th,
> my fund company actually buys the shares for 4 funds at the closing price
> for that day (fund1 - $25, fund2 - $25, fund3 = 35, fund4 = $15).


The way I would handle this is to enter/change the debiting to a
Transfer:MutualFundAccount(cash) via using the SPECIAL categories at
the bottom of the Category list.

Then on the 5th I would enter the Buys with the investment cash
account being the source of the funds.

- quote -

> As a result of this, I have to go back to update the actual "buy" figures
> of investment fund purchases for price and quantity.
> When I make the changes, I get an error message that says "the changes you
> are making will cause the share balance of XXX to become negative at some
> point Please adjust your transactions to avoid this." It is not the same
> fund every time, and does not necessarily reflect the fund I am updating. I
> have tried to fnd info on this, but have only found suggestions relating to
> "sells". Why am I getting this error when I am buying and doing nothing to
> remove shares? Any help on this would be great!


That is strange. The only thing that comes to mind is that the
mutual fund account is somehow downloading balance information.
Money offered to do RemoveShares to make your holdings match what
was downloaded as fund holdings, and you accepted.

It could be something else happening, but I can't think of what it
would be. Your method of entering estimated Buy transactions and
then changing the Quantity field later seems like it should work
without error.

  #-1  
Old 12-30-2004, 12:47 AM
Marianne Seckel
Guest
 
Posts: n/a
Default retroactively update share purchases??

WinXp/MM2003

I need some expert advice. I have been playing catchup since I now have
some time to dedicate to my MS Money this week and I keep running into this
very frustrating problem.

My checking account is debited for investment purchases every month. A few
days after that, my funds purchase new shares in each of several funds from
that same transaction. The way I have it set up, I have one transaction
which is split to make these purchases.

for example
on 1 December, my checking account is debited $100. Say, on december 5th,
my fund company actually buys the shares for 4 funds at the closing price
for that day (fund1 - $25, fund2 - $25, fund3 = 35, fund4 = $15).

As a result of this, I have to go back to update the actual "buy" figures
of investment fund purchases for price and quantity.
When I make the changes, I get an error message that says "the changes you
are making will cause the share balance of XXX to become negative at some
point Please adjust your transactions to avoid this." It is not the same
fund every time, and does not necessarily reflect the fund I am updating. I
have tried to fnd info on this, but have only found suggestions relating to
"sells". Why am I getting this error when I am buying and doing nothing to
remove shares? Any help on this would be great!

thanks,

M. Seckel


 

Tags
purchases, retroactively, share, update
Similar Threads
Thread Forum Replies Last Post
Anyone able to get Ameritrade stocks purchases to update in their portfolio
Brian H: I'm sure I've seen this problem before and I can't remember what the fix is. (don't trade that often). Anyway seems that my downloaded stock...
Microsoft Money 1 12-10-2004 03:02 PM
B share to A share exchange
Kevin: Dear NG: Money 2004 Deluxe, Win XP Pro. I've held B shares of one of my mutual funds for 6 years and they have been automatically exchanged...
Microsoft Money 10 04-10-2004 12:00 AM
Money 2000. Update share prices for Swiss shares
Phil: Can Money 2000 get on-line share prices for shares traded on the Zurich stock market. I have the symbol (SYNN) but Money doesn't seem to be able to...
Microsoft Money 1 01-07-2004 07:10 PM
Cash purchases
Judith Simpson: How can I enter purchases made by cash into my accounts? For example my husband will buy groceries or other small items and pay with cash and I...
Microsoft Money 5 09-14-2003 03:41 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 04:38 AM.