|
#2
| |||
| |||
| This is possible if your statements list periodic contributions by fund and you crank in lots of data. For each statement, enter appropriately dated Buy transaction(s) for the fund(s) in the amount of the invested contributions, but leave the transfer account field blank. The money for these Buys will appear as though from thin air. After entering the contribution Buys, compare Account Summary fund totals with the statement totals. Enter corrective Add/Remove shares transactions (I think these will be treated as "earnings/losses" but you may want to test to see for sure before getting crazed cranking in data) to match the statements. Repeat until done. Note that these "thin air" purchases may hose up other reports because they may appear as something like unassigned income. Test to find out. Note that performance reporting may still be distorted depending on your plan's mechanics. If it actually purchases weekly with a one day lag from contributions and you show it as purchasing quarterly from the statement data, this will affect the calculations. "DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message news:7B9B2700-C5A0-4170-9A3A-736B614EED14[at]microsoft.com... - quote - > Thanks for your answer, but I'm still missing a piece. What you suggest > works, but it doesnt allow me to see the growth in the fund from my > contributions vs. the 'earnings' as they're listed on my statement. I > need > to figure out a way to post my contributions separate from the earnings. > My > reference to past statements is that I'm just setting up my 401k tracking > with Money (I'm a quicken convert). I have statements back to 97 and I'd > like to enter all the quarterly data with the hope of being able to see > how > much of the current and future balance is from the growth. |
|
#1
| |||
| |||
| Thanks for your answer, but I'm still missing a piece. What you suggest works, but it doesnt allow me to see the growth in the fund from my contributions vs. the 'earnings' as they're listed on my statement. I need to figure out a way to post my contributions separate from the earnings. My reference to past statements is that I'm just setting up my 401k tracking with Money (I'm a quicken convert). I have statements back to 97 and I'd like to enter all the quarterly data with the hope of being able to see how much of the current and future balance is from the growth. "Dick Watson" wrote: - quote - > If you use the Account Summary|Account Update (or similar, I'm not sure of > the exact path and can't look from here) It will allow you to enter a > statement total for each holding/cash position. It will then enter either > Add Shares or Remove Shares to get back to the statement balance. This is > very similar to what you propose doing. As to entering previous statements, > once you get to a reconciled balance with a current statement, I'm not sure > there is any value to doing so. > "DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message > news:BFF001E8-0D32-4991-BBA5-CB00A8167416[at]microsoft.com... > > I'm new to Money and am posting my first question. I've looked through > the > > BB and also the FAQ, and didn't see anything that quite fit the bill. > > > My 401k statements tell me my contributions and display "earnings" to the > > fund, to give a current value. Obviously somewhere in the background are > > shares and prices, but that's not supplied on the statement. Any > > suggestions how to track that within Money? I'm attemping to show > > contributions as a Add Share transaction with a price of 1 and a quantity > the > > actual contribution. I do similar for Earnings but use Reinvest Interest. > > This seemed clunky, but functional, until you get to negative earnings. > If > > I had share price data that would simply be a drop in share price, but I > just > > have it as +/- earnings. I used Remove Shares for this one, but I'm sure > > there must be a more consistent technique. Before I get to far with > entering > > past statements, I thought I'd ask. > > > Thanks > > Scott |
| | |||
| |||
| If you use the Account Summary|Account Update (or similar, I'm not sure of the exact path and can't look from here) It will allow you to enter a statement total for each holding/cash position. It will then enter either Add Shares or Remove Shares to get back to the statement balance. This is very similar to what you propose doing. As to entering previous statements, once you get to a reconciled balance with a current statement, I'm not sure there is any value to doing so. "DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message news:BFF001E8-0D32-4991-BBA5-CB00A8167416[at]microsoft.com... - quote - > I'm new to Money and am posting my first question. I've looked through the > BB and also the FAQ, and didn't see anything that quite fit the bill. > My 401k statements tell me my contributions and display "earnings" to the > fund, to give a current value. Obviously somewhere in the background are > shares and prices, but that's not supplied on the statement. Any > suggestions how to track that within Money? I'm attemping to show > contributions as a Add Share transaction with a price of 1 and a quantity the > actual contribution. I do similar for Earnings but use Reinvest Interest. > This seemed clunky, but functional, until you get to negative earnings. If > I had share price data that would simply be a drop in share price, but I just > have it as +/- earnings. I used Remove Shares for this one, but I'm sure > there must be a more consistent technique. Before I get to far with entering > past statements, I thought I'd ask. > Thanks > Scott |
|
#-1
| |||
| |||
| I'm new to Money and am posting my first question. I've looked through the BB and also the FAQ, and didn't see anything that quite fit the bill. My 401k statements tell me my contributions and display "earnings" to the fund, to give a current value. Obviously somewhere in the background are shares and prices, but that's not supplied on the statement. Any suggestions how to track that within Money? I'm attemping to show contributions as a Add Share transaction with a price of 1 and a quantity the actual contribution. I do similar for Earnings but use Reinvest Interest. This seemed clunky, but functional, until you get to negative earnings. If I had share price data that would simply be a drop in share price, but I just have it as +/- earnings. I used Remove Shares for this one, but I'm sure there must be a more consistent technique. Before I get to far with entering past statements, I thought I'd ask. Thanks Scott |
| Tags |
| 401k, earnings, entries, post |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Post MS05 "fix" - Money crapping out.. :-( wiredup: Since updating Money yesterday, here's my new error: Money is not able to load some or all of your financial planner data. please note the error... | Microsoft Money | 7 | 11-22-2004 07:45 AM | |
| Money 2005: "Spending by Category" says "No data to display"? Bob Parker: Hi all, On the Home tab under "Spending by Category" I see: 8/30/04 through 9/28/04 No data to display Well, I do have spending during... | Microsoft Money | 1 | 09-29-2004 01:42 AM | |
| Money 2002 transaction status flags ("E", "C", "R") have all disappeared Nick Tonkin: Hi, After many months of using Money 2002, yesterday I suddenly noticed that the column in my resgister that shows the cleared status of each... | Microsoft Money | 4 | 02-28-2004 04:39 AM | |
| Deleting "Pay to" entries Crazy man: I've running Money 2000 v8 on ME. I got big list in my "PAY TO" category when I use withdrawal folder. I'd like to tidy this up and delete most... | Microsoft Money | 2 | 02-25-2004 03:46 PM | |
| Thread Tools | |
| Display Modes | |
| |