help with investment transactions

Use the 401(k) Wizard to enter your statement. If should guide you to do the correct things. It will buy the number of shares that makes up the difference between the opening balance and the closing balance for the amount contributed, and then enter a price valuation for the reported closing price to correctly reflect Market Value for your holdings, thus allowing you to see the profit/loss on your investment.

"Mike B" wrote in news:42619f16_4 @news1.prserv.net:

Thanks, Mike. I'll look for the wizard.

"Mike B" wrote in news:42628e36 snipped-for-privacy@news1.prserv.net:

By all transactions, what do you mean? My quarterly statement (from this particular FI) combines the fund activities and only provides me with x shares of say, Vanguard 500 Index with an ending value. The only other transactional data I would have access to is the paycheck deductions that go to the 401k... which of course do not tell me what the individual transactions are once the financial company splits it out per my investment elections.

I'm not sure if I'm just not seeing the forest for the trees here.. of if the FI in question doesn't provide enough info to set this up properly.

Continued in next post...

"Mike B" wrote in news:42628e36_3 @news1.prserv.net:

This 401k began Oct.1, 2004.

What I'm seeing is this (in the Q transaction list):

-1 All the Xin's from the paycheck deductions up to 12/31/2004

-2 Fund purchases on 12/31/2004 (from the 4th quarter 2004 statement) (no Xout here)

-3 More Xin's continuing from January 1, 2005 until the last Xin on March

25th, 2005, just before the end of the 1st quarter (3/31/05)

-4 One Xout for shares purchased with cash balance... which equals the cash balance in the account. However, the actual buys are short of this amount.. equal to one paycheck's deduction. So maybe it's just a time lag thing? But then I'd think the cash balance would reflect that difference.

-5 Fund purchases on 3/31/05 (from 1st quarter 2005 stmt).

-6 a remaining cash balance

If I add the Xout amount to the cash balance, I have the correct amount equaling the paycheck deductions (as shown on the transactions page).

If I add the buys to the cash balance (as shown on the summary page), I am one paycheck short (deduction wise). Make sense?

I may have used the wrong terminology when I referred to the Xout and cost basis being equal in the earlier post.

Continued in following post...

"Mike B" wrote in news:42628e36 snipped-for-privacy@news1.prserv.net:

Ah... I didn't realize that. So then it appears that I need to dig up all the info I can, and begin from that point forward.

Or, do I really need to use the Wizard?

I think I set them up from scratch, Mike. I set them up at a time when I knew even less than I do now. ;)

I used the wizard to try and update this 401k. I selected the securities from the dropdown list. And once done, discovered the duplicates.

I think it's time to toss in the towel on this one... delete and rebuild from scratch. I think I can find most of the transactions. That's gonna be a job for another day.. outta time right now.

Thanks for your assistance. Much appreciated.