Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 04-08-2006, 04:04 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding errors in manually entered investment account transaction

In microsoft.public.money, Matt Karger wrote:

- quote -

> I am tracking the performance of the investment subaccount of my life
> insurance policy in MS Money 2006 Premium. My insurer does not support
> online updates of investment subaccount performance, so I must enter
> statement data manually. Shares of investments are only reported with 3
> decimal places of accuracy on my statements. As a result, in some cases
> rounding errors in the number of shares purchased and sold accumulate over
> months so that after a while the total number of shares that I own as
> reported by Money differs from the number of shares reported by my insurer.
> How do I adjust the number of shares that I own in Money to match the figure
> reported on my statements?


One possibility is from the register,
AccountSummary(top left)-> AccountUpdate(bottom)

 
Old 04-08-2006, 04:00 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Rounding errors in manually entered investment account transaction

I'd get the number of shares right in the first place. Put the rounding
error in the price per share where it will do absolutely no harm. When
entering the transaction, set amount, and price, Money will compute number
of shares. Delete price, round number of shares to the same three decimal
places, then enter the transaction with Money's computed share price.

To fix a share balance that's incorrect, use Add Shares/Remove Shares
investment activity transactions. There is also the Account Update link at
the bottom of the Investment Account|Account Summary page. It lets you enter
an exact amount of shares and enters Add/Remove Shares transactions as
required to get back in balance.

"Matt Karger" <MattKarger[at]discussions.microsoft.com> wrote in message
news:EE45207E-1B80-4074-94E8-90348218F869[at]microsoft.com...
- quote -

> I am tracking the performance of the investment subaccount of my life
> insurance policy in MS Money 2006 Premium. My insurer does not support
> online updates of investment subaccount performance, so I must enter
> statement data manually. Shares of investments are only reported with 3
> decimal places of accuracy on my statements. As a result, in some cases
> rounding errors in the number of shares purchased and sold accumulate over
> months so that after a while the total number of shares that I own as
> reported by Money differs from the number of shares reported by my
> insurer.
> How do I adjust the number of shares that I own in Money to match the
> figure
> reported on my statements?



  #-1  
Old 04-08-2006, 03:24 PM
Matt Karger
Guest
 
Posts: n/a
Default Rounding errors in manually entered investment account transaction

I am tracking the performance of the investment subaccount of my life
insurance policy in MS Money 2006 Premium. My insurer does not support
online updates of investment subaccount performance, so I must enter
statement data manually. Shares of investments are only reported with 3
decimal places of accuracy on my statements. As a result, in some cases
rounding errors in the number of shares purchased and sold accumulate over
months so that after a while the total number of shares that I own as
reported by Money differs from the number of shares reported by my insurer.
How do I adjust the number of shares that I own in Money to match the figure
reported on my statements?
 

Tags
account, entered, errors, investment, manually, rounding, transaction
Similar Threads
Thread Forum Replies Last Post
52 wk high/low for manually entered quotes
aguy: Hi, There are mutual funds in my 401k for which I have to update the price by hand (I do it oncce/twice a month). In the customized porrtfolio...
Microsoft Money 1 05-01-2005 07:26 PM
E*Trade positions download rounding errors 2005
David: When I download an online "statement" from E*Trade, Money 2005 reports that most of my positions don't match the statement, and prompts me to "Add 0...
Microsoft Money 2 01-16-2005 12:50 PM
This Transaction Cannot Be Entered in Stock Options account
Tony: Ok, I've used Quicken since the dawn of time and recently downloaded the Money trial. I created an Employee Stock Option account and entered a...
Microsoft Money 3 02-01-2004 05:17 AM
Rounding on Investment transactions
_PC_: I've seen this problem for quite a while in Monday (at least 01, 02, 03, and 04). But when I'm entering my transactions, often times the final...
Microsoft Money 1 01-10-2004 11:39 PM
Keep manually entered date
JR: In Money 2004, when I download transactions from my bank and accept a match with a transaction I entered manually, the transaction is entered into...
Microsoft Money 2 12-08-2003 09:00 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 06:15 PM.