TSP Interfund Transfer Decoder Wheel

[Rolo]

The biggest headache in tracking TSP transfers is that the IFT notifications show you your account before and after the transaction, and you have to figure out the actual transaction itself. The TSP Interfund Transfer Decoder Wheel makes entering your transactions into Quicken (or any financial program) a snap. Rather thandoing multipletedious calculations with a calculator, just paste the table from your IFT e-mail notification into the attached spreadsheet, then copy and paste the values (share price and totalamount)into your Quicken transactions and you are good to go!

Download and delete the ".txt" extension from the filename.

[Rod]

Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.

[Rolo]

Rod wrote: Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.




Rolo had already written:
Download and delete the ".txt" extension from the filename.

heh...RTFM before contacting technical support! :X ;)

Tom added xls to theallowed attachements--just download the file attached to the next message below.

[Rolo]

The biggest headache in tracking TSP transfers is that the IFT notifications show you your account before and after the transaction, and you have to figure out the actual transaction itself. The TSP Interfund Transfer Decoder Wheel makes entering your transactions into Quicken (or any financial program) a snap. Rather thandoing multipletedious calculations with a calculator, just paste the table from your IFT e-mail notification into the attached spreadsheet, then copy and paste the values (share price and totalamount)into your Quicken transactions and you are good to go!

Attached is the xls (Excel) file.

[Rod]

Don't get yer panties in a twist!:P;)

Humm, still having problems. Don't see .txt in the extention to delete.

[Rod]

MUCH BETTER!!!!!!!



:D

[Rod]

Thank you, Tom.:)

and YOU TOO, Rolo!:^

[Rolo]

Rod wrote: Don't get yer panties in a twist!:P;)

Humm, still having problems. Don't see .txt in the extention to delete.





hehehe...ever see Office Space? "I deal with the people so the engineers don't have to! I have PEOPLE SKILLS! WHAT'S WRONG WITH YOU PEOPLE!?" :X :dude:


You do not see the .txt extension because Windoze Explorer is hiding it. Togge the option "Hide extensions of known file types" in Tools | Options...

[Rod]

:D

Yeah, I finally got it downloaded with what Tom did.

Thanx for putting it together!:^

[Rolo]

Yes, entering IFT's into Quicken was a real PITA. As I was doing the calculator thing again, I thought, "This is stupid. Duh! Excel..."

Also, I was less likely to trade in the TSP because of the Hassle Factor; now, that is not the case.

[Frizz B.]

I still like my excell spreadsheet, quick and easy to track and make changes, and Rolo the :dude:is mine, it shows my Frizz. :dude:

[Rolo]

Frizz B. wrote: I still like my excell spreadsheet, quick and easy to track and make changes, and Rolo the :dude:is mine, it shows my Frizz. :dude:
Apples and oranges...this spreadsheet has an entirely different purpose, only to paste IFT confirmation, automatically do the calculations, and paste the figures into Quicken--a one-shot deal, no tracking.

Also, I still have to figure out that part of your spreadsheet. :D

[Boghie]

Rolo,

This was an oldie, but a goodie.

Me like...