Manual enter transactions

[reddragon]

Entering transactions for an account having good success until third year 2010. entering the third year started to be of by pennies. Went back double check my work several times and can not get the acct accurate. Example June off by 4 cents, july 4 cents, aug 6, sept 7, oct back to 3 cents and so on. triple checked my work all transactions are correct. Any advice?

[Mark]

Hi reddragon,

It sounds like you are checking "value". Start off my ensuring that all your investments reconcile with "shares" first. If all your shares balance, then the value is simply shares times the closing price on that date. Once you have all the shares balanced, check the investment balances, and make sure they are all correct. If one is off, check the recorded closing price.

[reddragon]

Checked all share balances and price close end of month everything is correct. Went back reviewed all money market flows everything is correct from a data entry stand point. still off a few cents every month. Any suggestions?

[Mark]

Hi reddragon,

If the portfolio value is off by a few cents, check the investment values. If you add up all the investment values you will get the portfolio value, so if the portfolio value is off, then one or more investment values are off. Find which one(s) are wrong, and correct them.

[reddragon]

Checked all of them the only thing is off is the money market position. In July the end of month price of several securities differ with Fund Manager of course causing the value to be off over 400 dollars. how does this happen when you down load prices? Every other month is correct. How do I correct? Thanks for all your responses

[Mark]

Hi reddragon,

If the money market is off, make sure you have all the closing prices set to 1, and check your shares. It sometimes happens that a money market is set to retrieve prices, and gets a non-1 price. Look at "Investment Properties... / Internet Retrieve", and make sure "Retrieve Price" is turned off for your money market. Then, in the Data Register with the "Prices" data type, verify all your closing prices are at 1. Correct any here that are not. Now that your pricing is good, verify your share balance. The share balance should match the market value. You can add/edit/delete any transactions in the Data Register again, but under "Transactions (all)" for the data type.

[reddragon]

Thanks, the problem I am having is when I download Historical Prices from Yahoo from time to time I have different share pricing at close market on the last business day of the month. This is causing me to be off from end of the month acct balance. Is ther anyway to correct the share price that is downloaded from Yahoo? These things are only off a penny or even half cent but it makes a difference.

[Mark]

Fund Manager updates the prices as provided by Yahoo. If you are finding them to be incorrect you can try using a different quote server, or manually update the prices for the dates where they are wrong. If you do manually update the prices, just make sure to not re-retrieve for that date range, as it would overwrite your manual price entries.