Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #18  
Old 02-05-2007, 02:02 AM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:eCzb0FNSHHA.4076[at]TK2MSFTNGP05.phx.gbl...
- quote -

> I'll take that as a no.

Yes, it's a no.

- quote -

> Odd that Money would ascribe a value to "nothing".

Exactly. I have no idea why or what to do about it.

Bruce.


  #17  
Old 02-05-2007, 02:00 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Share balance goes negative

I'll take that as a no. Odd that Money would ascribe a value to "nothing".

"Bruce." <noone[at]nowhere.com> wrote in message
news:uLQScpHSHHA.4260[at]TK2MSFTNGP06.phx.gbl...
- quote -

> > Money does or does not show the $0.01 as the Ending Balance of the
> > Investment Cash Account register?

> Yes. The Account Register shows Account Value as $0.01 at the lower
> right. The associated Cash Account shows an Ending Balance of $0.00 at the
> lower right.



  #16  
Old 02-04-2007, 03:34 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:e%23CpnhHSHHA.3440[at]TK2MSFTNGP03.phx.gbl...
- quote -

> I'm still trying to follow this.

It's confusing. I assumed it was going to be simple when I first posted,
but it's mushroomed since then.

- quote -

> Money thinks there are no investments in the account.

Correct. No Investments. If I go to the Account Summary it says "This
account currently has no investments in it. You can add a new investment
here."

- quote -

> Money thinks the combined value for the Investment+Investment Cash
> accounts is $0.01.


Yes. If you go to the Account List, it shows the account balance as $0.01.

- quote -

> Money does or does not show the $0.01 as the Ending Balance of the
> Investment Cash Account register?


Yes. The Account Register shows Account Value as $0.01 at the lower right.
The associated Cash Account shows an Ending Balance of $0.00 at the lower
right.

Bruce.


  #15  
Old 02-04-2007, 03:22 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Share balance goes negative

I'm still trying to follow this.

Money thinks there are no investments in the account.

Money thinks the combined value for the Investment+Investment Cash accounts
is $0.01.

Money does or does not show the $0.01 as the Ending Balance of the
Investment Cash Account register?

"Bruce." <noone[at]nowhere.com> wrote in message
news:%23fxU2JHSHHA.1180[at]TK2MSFTNGP05.phx.gbl...
- quote -

> All for a penny. :-(


  #14  
Old 02-04-2007, 02:38 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

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

> You might consider doing a QIF export of the investment and
> associated cash account. Then delete the problem account. Create the
> new account, and File-> Import as recovered account into the new
> account. Import both QIF files at once with Ctrl+<click> .


This account is littered with transfers from a payroll deposits to a
checking account.

My understanding is that the only way to do an import correctly and get the
transfers right, is to import all the affected accounts at the same time.

Since the checking account is littered with transfers to other accounts like
credit cards, paypal, investments, etc., I'd basically have to export almost
every account I have and reimport everything.

All for a penny. :-(

Bruce.


  #13  
Old 02-04-2007, 04:10 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Share balance goes negative

In microsoft.public.money, Bruce. wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:e1aas2d0t2ojisf5cgefdj5ed4ctlr3qq2[at]4ax.com...
> > Suppose you just delete the account.

> That hosed the Account Worth Over Time chart as you might suspect it would.
> I restored from a backup.
> It's looking like I'll just have to close it as is, penny and all. I don't
> know if there will be long term implications of doing so.


You might consider doing a QIF export of the investment and
associated cash account. Then delete the problem account. Create the
new account, and File-> Import as recovered account into the new
account. Import both QIF files at once with Ctrl+<click> .

  #12  
Old 02-03-2007, 11:36 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

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

> Suppose you just delete the account.

That hosed the Account Worth Over Time chart as you might suspect it would.
I restored from a backup.

It's looking like I'll just have to close it as is, penny and all. I don't
know if there will be long term implications of doing so.

Bruce.


  #11  
Old 02-03-2007, 11:26 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Share balance goes negative

In microsoft.public.money, Bruce. wrote:

- quote -

> There's no symbol because it's not a real stock/fund. It's a 401(k)
> retirement account that I was tracking with a fake investment with a fixed
> $1.00 per share price.


Suppose you just delete the account.
  #10  
Old 02-03-2007, 10:53 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > Try
File-> RepairMoneyFile-> QuickFileRepair again.

No change. The penny is still there and I can't delete the Add Shares 1000.

- quote -

> Consider a 65535 for 1 split to see if you can un-hide that thing.

That was unexpected. It said it couldn't add the split due to insufficent
disk space! The drive has 58GB available.

- quote -

> Consider a 1 for 65535 split....

This one added but the account register was hosed. The share counts all
changed to 65535. But the penny was still there and the Add Shares 1000 was
sitll undeletable.

- quote -

> Try setting the price to zero

No change.

I removed the split and the price zeroing and the register is back the way
it was.

- quote -

> and blanking the symbol.

There's no symbol because it's not a real stock/fund. It's a 401(k)
retirement account that I was tracking with a fake investment with a fixed
$1.00 per share price.

Bruce.


  #9  
Old 02-03-2007, 10:39 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Share balance goes negative

In microsoft.public.money, Bruce. wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:ih5as25a725k5rdekdincc4ape421o2ai6[at]4ax.com...
> > So now that you have your 1000 shares, revisit that page, and try
> > the AccountUpdate to 0 shares.

> Didn't work. Using the Account Update to set 0 merely added a Remove Shares
> of 999.99 to the register. Now the penny is back again. I'm back where I
> started.
> The investment register shows an Account Value of $0.01 and the associated
> Cash Register shows an Ending Balance of $0.00.


Hmmm.

Try File-> RepairMoneyFile-> QuickFileRepair again.

Consider a 65535 for 1 split to see if you can un-hide that thing.
Consider a 1 for 65535 split....

Try setting the price to zero and blanking the symbol.

  #8  
Old 02-03-2007, 10:33 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

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

> So now that you have your 1000 shares, revisit that page, and try
> the AccountUpdate to 0 shares.


Didn't work. Using the Account Update to set 0 merely added a Remove Shares
of 999.99 to the register. Now the penny is back again. I'm back where I
started.

The investment register shows an Account Value of $0.01 and the associated
Cash Register shows an Ending Balance of $0.00.

Bruce.


  #7  
Old 02-03-2007, 10:11 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Share balance goes negative

In microsoft.public.money, Bruce. wrote:

- quote -

> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:uzqNXY1RHHA.1228[at]TK2MSFTNGP06.phx.gbl...
> > Account Summary|Account Update (hidden at the bottom). Set shares to 0.

> Uh oh. That explains it. There's nothing on that screen. I go to the
> Account Summary page and it's largely blank (except for the menus). On that
> page it just says "The account currently has no investments in it. You can
> add new investments here". As a result of the blank page, there's no
> Account Update at the bottom.
> Other accounts do have that Account Update at the bottom, just not the one I
> need to zero.
> Any ideas?


So now that you have your 1000 shares, revisit that page, and try
the AccountUpdate to 0 shares.


  #6  
Old 02-03-2007, 10:05 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OpadwT%23RHHA.1200[at]TK2MSFTNGP02.phx.gbl...
- quote -

> Check the Cash register...

Thanks Dick. That's where the penny was coming from, as a result of me
changing the Sell from 1234.55 to 1234.56. So I fixed the Cash Register and
now the account value is exactly $1000 (1000 shares).

But I still can't delete the Add Shares 1000 I added. The mentioned error
prevents me from doing so. The only way I can delete the Add Shares is to
change the Sell 1234.56 back to 12345.55.

Bruce.


  #5  
Old 02-03-2007, 09:47 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Share balance goes negative

Check the Cash register...

"Bruce." <noone[at]nowhere.com> wrote in message
news:uw$dx49RHHA.1036[at]TK2MSFTNGP03.phx.gbl...
- quote -

> Any more zeros and Money just drops the extra digits. No amount > 1234.55
> will sell. Yet, $0.01 is still shown in the register Account Total.



  #4  
Old 02-03-2007, 09:41 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uzqNXY1RHHA.1228[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Account Summary|Account Update (hidden at the bottom). Set shares to 0.

Update. It seems Money thinks I have zero shares in that investment which
is why it refuses to show in the Account Summary, and so no Account Update.

So I decided to try an Add Shares of 1000 shares (for a date prior to the
12345.55 Sell). Now the investment shows in Account Summary but the amount
of shares is exactly 1000. I've extended the decimal places and it shows
1000.00000 exactly. No fractional shares at all.

So I went back to the register and now I can change the Sell from 1234.55 to
1234.56 but the Account Value doesn't change from $1000.01 when I do. The
penny is stuck.

So I try deleting the 1000 Add Shares and it refuses. Says "Some or all of
of 'ING Retirement' aquired with this transaction have been sold or removed.
Before you can delete this transaction for the purchase of or addition of
'ING Retirement', you must first delete any sale or removal transactions."

If I first change the Sell 1234.56 back to 1234.56 then I can delete the Add
Shares 1000 again, but that just puts me back where I was, stuck at $0.01.

Bruce.


  #3  
Old 02-03-2007, 08:56 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Kevin" <nospam[at]nospam.com> wrote in message
news:eocv7i8RHHA.1036[at]TK2MSFTNGP03.phx.gbl...
- quote -

> Bruce,
> Is it possible to sell 1234.551shares or 1234.552 shares and so on.
> It's possible that you have a fractional share in the account that Money
> is displaying as .01.


I've tried selling:

1234.551
1234.5501
1234.55001
1234.550001

Any more zeros and Money just drops the extra digits. No amount > 1234.55
will sell. Yet, $0.01 is still shown in the register Account Total.

- quote -

> You may be able to see the fractional share by changing the current view
> of the portfolio with that account in it, and changing the Quantity column
> to more than 2 decimals.


The account name shows in the portfolio, but no investments do. The
underneath the account name is blank and shows no investments.

I can't find any way to display whatever shares there may or may not be in
that investment.

Bruce.


  #2  
Old 02-03-2007, 06:23 PM
Kevin
Guest
 
Posts: n/a
Default Re: Share balance goes negative

Bruce,

Is it possible to sell 1234.551shares or 1234.552 shares and so on.

It's possible that you have a fractional share in the account that Money
is displaying as .01.

You may be able to see the fractional share by changing the current view
of the portfolio with that account in it, and changing the Quantity column
to more than 2 decimals.

Let us know how you make out.

-Kevin

"Bruce." <noone[at]nowhere.com> wrote in message
news:eGxY0M0RHHA.3948[at]TK2MSFTNGP05.phx.gbl...
- quote -

> I have a 401(k) account with 1234.56 shares in it at a $1 a share. I want
> to sell all 1234.56 shares, but if I try Money won't let me do that,
> claiming that would cause "the share balance to go negative at some point".
> It will let me sell 1234.55 shares, leaving $0.01 in the account. I'm
> trying to get it to zero before I close the account. How can I get rid of
> that last penny?
> Thanks.
> Bruce.



  #1  
Old 02-03-2007, 05:20 PM
Bruce.
Guest
 
Posts: n/a
Default Re: Share balance goes negative

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uzqNXY1RHHA.1228[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Account Summary|Account Update (hidden at the bottom). Set shares to 0.

Uh oh. That explains it. There's nothing on that screen. I go to the
Account Summary page and it's largely blank (except for the menus). On that
page it just says "The account currently has no investments in it. You can
add new investments here". As a result of the blank page, there's no
Account Update at the bottom.

Other accounts do have that Account Update at the bottom, just not the one I
need to zero.

Any ideas?

Bruce.


 
Old 02-03-2007, 04:42 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Share balance goes negative

Account Summary|Account Update (hidden at the bottom). Set shares to 0.

"Bruce." <noone[at]nowhere.com> wrote in message
news:eGxY0M0RHHA.3948[at]TK2MSFTNGP05.phx.gbl...
- quote -

> It will let me sell 1234.55 shares, leaving $0.01 in the account. I'm
> trying to get it to zero before I close the account. How can I get rid of
> that last penny?



  #-1  
Old 02-03-2007, 02:27 AM
Bruce.
Guest
 
Posts: n/a
Default Share balance goes negative

I have a 401(k) account with 1234.56 shares in it at a $1 a share. I want
to sell all 1234.56 shares, but if I try Money won't let me do that,
claiming that would cause "the share balance to go negative at some point".

It will let me sell 1234.55 shares, leaving $0.01 in the account. I'm
trying to get it to zero before I close the account. How can I get rid of
that last penny?

Thanks.
Bruce.


 

Tags
balance, negative, share
Similar Threads
Thread Forum Replies Last Post
Entering Anual Fund Fee's as a negative share transaction?
wchp: My funds are set up to auto re-invest all dividends, L, M, and S term cap gains and all fees are to be paid from the respective fund/account. This...
Microsoft Money 12 10-18-2008 05:49 PM
401K Balance is negative
Dhana: Hello, I downloaded my 401K information from Fedelity NetBenefits. After autoupdate, my account is showing -($7.00) Balance, I assume its the...
Microsoft Money 4 08-15-2006 06:47 PM
"Share balance negative at some point"
wchp: I am trying to record a sale of some shares of a fund that I own. I have over 2900 shares of this fund and I am trying to record the sale of 68...
Microsoft Money 15 04-13-2006 06:02 PM
Negative Share Balance warning in MM03
MJ Ohm: In my recurring checking acct deposit, I have splits that go toward buying funds for a college savings plan. In the plan accounts, I do not...
Microsoft Money 3 05-18-2005 02:56 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 08:22 PM.