Entering an Existing 401k in Quicken

Good morning,I have a long standing question - that I am hoping I can find an answer to here!Is there a simple way for me to enter my current state 401k in Quicken?Seriously - it was an impossible task in Quicken 2005.  Spent days entering securities, price bought, number of shares, and adding cash input on a weekly basis.  Was an impossible task to balance. (I had a theory on this, but have forgotten it). Anyway, I recently upgraded to Quicken 2008 and decided to start over again on entering my 401k plan (as my best efforts in Quicken 2005 have left me with a 20% discrepency). I have backed up my quicken file and deleted my old 401k account.  So here is my question: Is there a sure fire way for me to enter the securities, shares, and price for each of my 401k holdings as they are today, record the cash in from by future weekly paychecks (I have set up my paycheck in Quicken), and then balance transactions quarterly?   Seems like a straightforward task - but never seems to work right!It would be great if anyone could provide me with a set of tested steps or a link to a tutorial (something besides what's in the Quicken help files!)  thanks,Chris

Answer

Just a quick update..  I bit the bullet and re-entered my 401k.I entered in each security 3 times:  (1 time for my culmalitve balance for my current company,  1 time for employer match,  and 1 for rollover). My 401k is with Nationwide.  Their breakdown is by units.  So for each entry I entered units rather than shares and price per unit, arriving at my total.  Much like when I attempted this in 2005, here are the results:- My current total is off by 3%.  Which is odd.  I entered each transaction as Bought, which got me my total amount.  Then I made a phantom cash deposit to try to balance (who cares about proper accounting at this point).  Rather than balancing out, this caused the value of my securities to erode by 2%.- Used Quicken Service to lookup 3 symbols.  Succesful on two, the third Quicken found the correct symbol, but in downloading it made up it's own security.Anyway, so I can live with the above (I'll figure out the security issue).  As I mentioned in my earlier post, my goal was to get my total 401k value correct, and then day-forward track investments.  From past experience, this will not work.  I predict that my cash in from a biweekly paycheck will work.  Then when I try to match up transactions from Nationwide - it will not.  Soon, my 401k balance will be off by giant amounts.I suspect the issue has to do with me recording unit price rather than share. When Quick checks the share price it won't match my unit price and it'll adjust my totals.  Anyway, that's my theory. Thanks again for any help you can provide! - Chris
Was this answer helpful? Yes No
18 additional answers

No answers have been posted

More Actions

People come to Quicken Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Do you still have a question?

Ask your question to the community. Most questions get a response in about a day.

Post your question to the community
or contact us