Tags: retirement savings

06/14/13

  09:12:00 am, by The Dreamer   , 1412 words  
Categories: Healthcare, Quicken/TurboTax

Screwed by Quicken

A while back I was having trouble updating transactions in my TIAA-CREF account. I used to update my entering each transaction by hand every so often, but then a few years ago (when I rolled over a Rollover IRA, which I had parked my 401k of my previous employer, as the invisible money fee was huge....share counts would drop every month, with no explanation in the account statements.) I let them generate the funds I should spread my retirement into...which makes it much harder to be entering transactions by hand.

I had tried the Quicken download option, but the dates of the transactions didn't line up with my pay days or the website's transaction history. So, making the download match what I was entering was tedious, as was not entering any by hand and adjusting after download. Also, the download likes to splatter my register with placeholders, and the complain that the placeholders are missing information so it can't do gain calculations.

So, originally, I'd only like invest in 6 +/- 1 funds. Basically a fund out each slice and some multiple of 5% rather than the specific percentage an investment tool had suggested for me.

Now, I have my retirement funds spread of 12 funds in my Mandatory Plan, and 19 Funds in my Voluntary Plan (since the Voluntary has access to more choices than those specified by pension administrator.) The Mandatory Plan is funded by the mandatory 5.5% that comes out of every paycheck, plus an 8.5% match from employer. While the Voluntary Plan is money that came from other sources, which could be in the form of additional deductions from pay. But, in my case it represents what was in my previous 401k.

So, I just let the Quicken download be as it is....deleting most of the placeholder transactions, because the only transaction that doesn't appear anywhere is the share count growth of my TIAA-CREF Traditional Annuity. But, I just change them into reinvestment actions with a price of $1. Not sure how I would get quicken to tell me what the gain/loss % is from that....

Somebody had described how to do the math to get include re-investments into the overall gain, perhaps I'll have to look into that someday.

Anyways, I noticed that I somehow hadn't done a download in almost 2 months (since the download ranges are 30, 60, 90 or All), so I try to do it about every 30 days. Quicken doesn't seem too bright on knowing transactions that overlap the previous download aren't new, and it'll refuse to let me manually match them with the correct transaction, since it the transaction had already been matched (or created by a previous download). So, I have to delete some of the new transactions, along with all the placeholder entries...before accepting the rest.

Normally this works great....even if the dates happen a day or two before payday. It makes the transfer from my associated cash account for my Mandatory Plan...sure it might go negative...but it all zeros out in the end, usually.

But, then last fall, there was a weird extra $3 and change in my cash account. I kept looking for a missing transaction, but didn't see one. Eventually, I found that when it had done my annual birthday re-balancing...where it sells parts of some funds and Quicken transfers into my cash account, an then buys amounts in the other funds with Quicken transferring out of my cash account. It didn't do that when it added to my Wells Fargo Advantage Growth Fund Institutional. I fixed it by hand, somehow and continued on my way.

Full story »

Now instead of subjecting some poor random forum to a long rambling thought, I will try to consolidate those things into this blog where they can be more easily ignored profess to be collected thoughts from my mind.

Latest Poopli Updaters -- http://lkc.me/poop

bloglovin

There are 20 years 1 month 25 days 3 hours 10 minutes and 30 seconds until the end of time.
And, it has been 4 years 11 months 2 days 10 hours 52 minutes and 26 seconds since The Doctor saved us all from the end of the World!

Search

November 2017
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      
Google

Linkblog

  XML Feeds

Who's Online?

  • Guest Users: 0
This seal is issued to lawrencechen.net by StopTheHacker Inc.
powered by b2evolution free blog software

hosted by
Green Web Hosting! This site hosted by DreamHost.

monitored by
Monitored by eXternalTest
SiteUptime Web Site Monitoring Service
website uptime