Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 07-27-2005, 11:29 AM
Paul
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

David,

Thanks for the info! That's EXACTLY what was going on. I upgraded to 2006
this past weekend so it's good to know that they got this kink figured out.
I'm sure it was a real task for the developers to track this
sporadic bug down. I'm glad they succeeded!

Thanks again!

Paul


David wrote:
- quote -

> Paul,
> The bug appears to be fixed in the new Money 2006.
> The bug, specifically, was this:
> - Dividend amounts show as negative numbers, though they were entered
> as positive numbers.
> - The proceeds of the stock sales are treated as negative numbers
> though they should be positive.
> - It may or may not have something to do with sync'ing with MSN
> Money. All the reporters seem to have that in common.
> - It is not related to downloading transactions from OFX since it
> happens in accounts that are not linked to an OFX institution.
> - The recurs even if you manually fix the transactions. When you quit
> and restart Money, the numbers are negative again.
> Anyway, I tried first the trial version then the full version, and it
> is fixed. Or, I should say the transactions stayed correct after I
> manually fixed each and every one, then quit and restarted Money.
> Both the trial version and full versions are available for download.
> "Premium" is $50 after rebate.
> My steps:
> 1) Install Money 2006.
> 2) Allow it to upgrade my data file to the new version.
> 3) Did a standard file repair.
> 4) Did a quick file repair. (Can't hurt, right?)
> 5) Fixed dividends by typing the positive number over the negative
> number. 6) Fixed stock sales by deleting the proceeds number, then
> pressing Enter to force Money to recalculate it from the (quantity x
> price) - commission.
> The sales are tricky because they do not appear in red as obvious
> negative number. Instead, you need to notice that they are reducing
> rather than increasing your cash balance.
> - David
> "Paul" wrote:
> > I have been on Money Deluxe 2005 for a while now. Last week, I was
> > looking at my investment accounts and noticed that the cash accounts
> > associated all have negative cash-on-hand. Upon further review, I
> > found about 15 sale transactions that looked just fine in the
> > Investment Transactions registers but were marked as payments,
> > rather than deposits, in the related Cash Transaction accounts. I
> > did a standard repair but that didn't seem to help and it showed no
> > broken records when I viewed the log. I then voided each of the
> > incorrectly recorded transactions and re-entered them manually. All
> > was fine until I closed Money and went back in. At that point,
> > everything was back to negatives again. It seems that the errors
> > include dividends being listed as negative as well as sales of
> > equities.
> > > I went ahead and did a 'msmoney -s' but that made the problem worse

> > - now all the negative amounts have doubled. Fortunately, I kept a
> > backup to use in case the -s made things worse. So, I'm back to the
> > "less-worse" version of my portfolio.
> > > Can you please help me? This is happening on transactions

> > regardless of whether they come in from Scottrade via .ofx or
> > whether I enter them manually.
> > > Many thanks!!!



  #5  
Old 07-21-2005, 10:38 AM
David
Guest
 
Posts: n/a
Default RE: Negative amounts showing for investment transactions

Paul,

The bug appears to be fixed in the new Money 2006.

The bug, specifically, was this:
- Dividend amounts show as negative numbers, though they were entered as
positive numbers.
- The proceeds of the stock sales are treated as negative numbers though
they should be positive.
- It may or may not have something to do with sync'ing with MSN Money. All
the reporters seem to have that in common.
- It is not related to downloading transactions from OFX since it happens in
accounts that are not linked to an OFX institution.
- The recurs even if you manually fix the transactions. When you quit and
restart Money, the numbers are negative again.

Anyway, I tried first the trial version then the full version, and it is
fixed. Or, I should say the transactions stayed correct after I manually
fixed each and every one, then quit and restarted Money. Both the trial
version and full versions are available for download. "Premium" is $50 after
rebate.

My steps:
1) Install Money 2006.
2) Allow it to upgrade my data file to the new version.
3) Did a standard file repair.
4) Did a quick file repair. (Can't hurt, right?)
5) Fixed dividends by typing the positive number over the negative number.
6) Fixed stock sales by deleting the proceeds number, then pressing Enter to
force Money to recalculate it from the (quantity x price) - commission.

The sales are tricky because they do not appear in red as obvious negative
number. Instead, you need to notice that they are reducing rather than
increasing your cash balance.

- David


"Paul" wrote:

- quote -

> I have been on Money Deluxe 2005 for a while now. Last week, I was looking
> at my investment accounts and noticed that the cash accounts associated all
> have negative cash-on-hand. Upon further review, I found about 15 sale
> transactions that looked just fine in the Investment Transactions registers
> but were marked as payments, rather than deposits, in the related Cash
> Transaction accounts. I did a standard repair but that didn't seem to help
> and it showed no broken records when I viewed the log. I then voided each
> of the incorrectly recorded transactions and re-entered them manually. All
> was fine until I closed Money and went back in. At that point, everything
> was back to negatives again. It seems that the errors include dividends
> being listed as negative as well as sales of equities.
> I went ahead and did a 'msmoney -s' but that made the problem worse - now
> all the negative amounts have doubled. Fortunately, I kept a backup to use
> in case the -s made things worse. So, I'm back to the "less-worse" version
> of my portfolio.
> Can you please help me? This is happening on transactions regardless of
> whether they come in from Scottrade via .ofx or whether I enter them
> manually.
> Many thanks!!!

  #4  
Old 06-22-2005, 02:23 AM
Paul
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

no - these transactions are populated via ofx, not yodlee.

Dick Watson wrote:
- quote -

> What happens if you enter the transactions by hand? Is Yodlee
> involved?
> If you think Quicken is a better alternative, by all means, go for it:
> http://www.buy.com/retail/product.as...400&spf=1&sp=1
> If you think Excel is a better alternative, I'm betting you don't
> understand the problem. Money, with transactions entered by hand,
> saves all of these nightmares and is still a database. In Excel,
> you'll have little choice but to enter the transactions by hand and,
> once the data is there, there's still not much you can do with it
> like query and report and so forth.
> "Joe Banton" <jbanton[at]sbcglobal.net> wrote in message
> news:3ezte.1307$lv.598[at]newssvr33.news.prodigy.com...
> > This is definitely a problem in Money 2005. I experienced the same
> > problems and deleted all of my investment transactions after March,
> > 2005. That's when my problem started happening. Everything looked ok
> > until the next update and it went back to negative Reinvested
> > Dividends. I have only found this occurring on the Tax estimator
> > reports and Tax related Transactions reports. The portfolio balances
> > look ok. If it is not fixed soon I am looking at alternatives such
> > as Excel or Quicken.



  #3  
Old 06-22-2005, 02:21 AM
Paul
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

Hi all. I spoke with someone at support. He was perplexed as well and
suggested I first run a standard salvage, then a quick salvage. Then, I
made 3 new entries mirroring 3 of the erroneous transactions. Then, I blew
away (delete, not voided) the 3 original erroneous transactions. After each
cycle of 3 add/3 delete, we exited money (i have auto backup on by the way).
When we went back into Money, the three transactions were just fine. We
repeated this 3 at a time until all 6 of my investment accounts were back to
reality.

What fixed it? Don't know. Doing both salvages may have been part of the
equation. Maybe doing 3 at a time was critical. Don't know. But, I'm
happy. Try it - it's tedious and maybe you don't have to do in batches of
3. I just did what the technician told me and got the results I needed.
Email me if you have any questions. I do have a case number so if you have
to call support, you can reference the number and perhaps save some time.

Dick Watson wrote:
- quote -

> What happens if you enter the transactions by hand? Is Yodlee
> involved?
> If you think Quicken is a better alternative, by all means, go for it:
> http://www.buy.com/retail/product.as...400&spf=1&sp=1
> If you think Excel is a better alternative, I'm betting you don't
> understand the problem. Money, with transactions entered by hand,
> saves all of these nightmares and is still a database. In Excel,
> you'll have little choice but to enter the transactions by hand and,
> once the data is there, there's still not much you can do with it
> like query and report and so forth.
> "Joe Banton" <jbanton[at]sbcglobal.net> wrote in message
> news:3ezte.1307$lv.598[at]newssvr33.news.prodigy.com...
> > This is definitely a problem in Money 2005. I experienced the same
> > problems and deleted all of my investment transactions after March,
> > 2005. That's when my problem started happening. Everything looked ok
> > until the next update and it went back to negative Reinvested
> > Dividends. I have only found this occurring on the Tax estimator
> > reports and Tax related Transactions reports. The portfolio balances
> > look ok. If it is not fixed soon I am looking at alternatives such
> > as Excel or Quicken.



  #2  
Old 06-20-2005, 01:58 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

What happens if you enter the transactions by hand? Is Yodlee involved?

If you think Quicken is a better alternative, by all means, go for it:
http://www.buy.com/retail/product.as...400&spf=1&sp=1

If you think Excel is a better alternative, I'm betting you don't understand
the problem. Money, with transactions entered by hand, saves all of these
nightmares and is still a database. In Excel, you'll have little choice but
to enter the transactions by hand and, once the data is there, there's still
not much you can do with it like query and report and so forth.

"Joe Banton" <jbanton[at]sbcglobal.net> wrote in message
news:3ezte.1307$lv.598[at]newssvr33.news.prodigy.com...
- quote -

> This is definitely a problem in Money 2005. I experienced the same
problems
> and deleted all of my investment transactions after March, 2005. That's

when
> my problem started happening. Everything looked ok until the next update

and
> it went back to negative Reinvested Dividends. I have only found this
> occurring on the Tax estimator reports and Tax related Transactions

reports.
> The portfolio balances look ok. If it is not fixed soon I am looking at
> alternatives such as Excel or Quicken.



  #1  
Old 06-20-2005, 01:09 PM
Joe Banton
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

This is definitely a problem in Money 2005. I experienced the same problems
and deleted all of my investment transactions after March, 2005. That's when
my problem started happening. Everything looked ok until the next update and
it went back to negative Reinvested Dividends. I have only found this
occurring on the Tax estimator reports and Tax related Transactions reports.
The portfolio balances look ok. If it is not fixed soon I am looking at
alternatives such as Excel or Quicken.
"Paul" <palar1[at]REMOVEthisTEXTcomcast.net> wrote in message
news:N--dnW7ohN71QjHfRVn-iw[at]comcast.com...
- quote -

> I have been on Money Deluxe 2005 for a while now. Last week, I was looking
> at my investment accounts and noticed that the cash accounts associated all
> have negative cash-on-hand. Upon further review, I found about 15 sale
> transactions that looked just fine in the Investment Transactions registers
> but were marked as payments, rather than deposits, in the related Cash
> Transaction accounts. I did a standard repair but that didn't seem to help
> and it showed no broken records when I viewed the log. I then voided each
> of the incorrectly recorded transactions and re-entered them manually. All
> was fine until I closed Money and went back in. At that point, everything
> was back to negatives again. It seems that the errors include dividends
> being listed as negative as well as sales of equities.
> I went ahead and did a 'msmoney -s' but that made the problem worse - now
> all the negative amounts have doubled. Fortunately, I kept a backup to
> use in case the -s made things worse. So, I'm back to the "less-worse"
> version of my portfolio.
> Can you please help me? This is happening on transactions regardless of
> whether they come in from Scottrade via .ofx or whether I enter them
> manually.
> Many thanks!!!



 
Old 06-14-2005, 12:09 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Negative amounts showing for investment transactions

In microsoft.public.money, Paul wrote:

- quote -

> I have been on Money Deluxe 2005 for a while now. Last week, I was looking
> at my investment accounts and noticed that the cash accounts associated all
> have negative cash-on-hand. Upon further review, I found about 15 sale
> transactions that looked just fine in the Investment Transactions registers
> but were marked as payments, rather than deposits, in the related Cash
> Transaction accounts.


See if the amount is in the wrong Payment/Deposit column in the Cash
Transactions register. If so, try modifying the amounts in the
Transactions register. Delete the total. Rub out the least
significant digit in the Quantity and renter it. The total should
get put back then

If you get the changing reconciled transaction warning accept it.
Then check that the amount is now in the proper Deposit column in
the Cash Transactions.


- quote -

> I did a standard repair but that didn't seem to help
> and it showed no broken records when I viewed the log. I then voided each
> of the incorrectly recorded transactions and re-entered them manually. All
> was fine until I closed Money and went back in. At that point, everything
> was back to negatives again. It seems that the errors include dividends
> being listed as negative as well as sales of equities.
> I went ahead and did a 'msmoney -s' but that made the problem worse - now
> all the negative amounts have doubled. Fortunately, I kept a backup to use
> in case the -s made things worse. So, I'm back to the "less-worse" version
> of my portfolio.
> Can you please help me? This is happening on transactions regardless of
> whether they come in from Scottrade via .ofx or whether I enter them
> manually.


I don't know. I wonder if it could come from somehow matching a
transaction to the wrong thing, (sale proceeds matched with MMF buy,
for example), but I don't know. I had run into something similar,
but I did not figure out how to reproduce it.


  #-1  
Old 06-13-2005, 01:18 AM
Paul
Guest
 
Posts: n/a
Default Negative amounts showing for investment transactions

I have been on Money Deluxe 2005 for a while now. Last week, I was looking
at my investment accounts and noticed that the cash accounts associated all
have negative cash-on-hand. Upon further review, I found about 15 sale
transactions that looked just fine in the Investment Transactions registers
but were marked as payments, rather than deposits, in the related Cash
Transaction accounts. I did a standard repair but that didn't seem to help
and it showed no broken records when I viewed the log. I then voided each
of the incorrectly recorded transactions and re-entered them manually. All
was fine until I closed Money and went back in. At that point, everything
was back to negatives again. It seems that the errors include dividends
being listed as negative as well as sales of equities.

I went ahead and did a 'msmoney -s' but that made the problem worse - now
all the negative amounts have doubled. Fortunately, I kept a backup to use
in case the -s made things worse. So, I'm back to the "less-worse" version
of my portfolio.

Can you please help me? This is happening on transactions regardless of
whether they come in from Scottrade via .ofx or whether I enter them
manually.

Many thanks!!!


 

Tags
amounts, investment, negative, showing, transactions
Similar Threads
Thread Forum Replies Last Post
Some investment events not showing in history graph
Kemosabe: When I bring up history of a 529 Plan I have for my granddaughter most of the buying and/or selling events show up but 2 do not. They were entered...
Microsoft Money 1 04-23-2005 12:21 PM
Posting negative 401k transactions
Bob Becnel: I have a typical 401k account setup with a corresponding cash account. I am manually balancing my account at the end of the quarter. In other...
Microsoft Money 2 11-30-2003 06:00 AM
XP M2003 Investment cost basis not showing up in portfolio view
Peter Filipski: I have M2003 standard (came with Dell) on XP. For some investments (shares), in the portfolio view nothing shows up in the Cost Basis column. There...
Microsoft Money 4 11-20-2003 03:38 AM
Investment Prices showing in Cents
Amir: Has anyone come accross an anoying problem with Money 99 where it show the investment prices in cents for some days and not others. This occurs...
Microsoft Money 3 10-07-2003 07:31 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 11:51 AM.