Home Page link  

Q08 and Valic

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Q08 and Valic speedlever 12-30-2007
Posted by Han on December 30, 2007, 2:42 pm
Please log in for more thread options
 speedlever <speedlever.at.yahoodotcom> wrote in

>
>
>> I am guessing that this is a retirement/pension account. As such, it
>> may not need exacting detail of purchases (price, date, quantity). I
>> would just start a new account with the positions as of December 31,
>> then go on with that. Make an adjusting transaction(s) in the old
>> account to zero it out.
>>
>> Now for the paycheck transactions. Change the deduction for the
>> pension to go as a transfer to a "holding" account. I use a bogus
>> asset account. Over time the net amount here should be zero.
>> Deduction from paycheck to Valic goes to the holding account. Then
>> when Valic's purchasing information becomes available, you "purchase"
>> with a transfer from the holding account. This better reflects real
>> life: Employer sends money from your paycheck to Valic. Then
>> (eventually) Valic uses this to purvhase securities (or whatever) as
>> you have directed. A 2-step process.
>>
>
> Yes, your assumption is correct.
>
> The holding account makes a lot of sense. Now I'll just hafta figure
out
> how to make the adjusting ta and setup the holding account. It would be
> simpler if Valic would update their system to allow downloads to the
> latest Q spec.
>
> Thanks for your help.
>
I have always used a holding account since Cornell and/or TIAA (or
Vanguard) never processed my paycheck deduction on the date of the
paycheck.

--
Best regards
Han
email address is invalid

Posted by treasur2 on December 31, 2007, 3:15 am
Please log in for more thread options
> speedlever <speedlever.at.yahoodotcom> wrote innews:Xns9A168E1092846speedl=
everyahoocom@66.250.146.128:
>
>
>
>
>
>
> >> I am guessing that this is a retirement/pension account. =A0As such, it=

> >> may not need exacting detail of purchases (price, date, quantity). =A0I=

> >> would just start a new account with the positions as of December 31,
> >> then go on with that. =A0Make an adjusting transaction(s) in the old
> >> account to zero it out.
>
> >> Now for the paycheck transactions. =A0Change the deduction for the
> >> pension to go as a transfer to a "holding" account. =A0I use a bogus
> >> asset account. =A0 =A0Over time the net amount here should be zero.
> >> Deduction from paycheck to Valic goes to the holding account. =A0Then
> >> when Valic's purchasing information becomes available, you "purchase"
> >> with a transfer from the holding account. This better reflects real
> >> life: =A0Employer sends money from your paycheck to Valic. =A0Then
> >> (eventually) Valic uses this to purvhase securities (or whatever) as
> >> you have directed. =A0A 2-step process.
>
> > Yes, your assumption is correct.
>
> > The holding account makes a lot of sense. Now I'll just hafta figure
> out
> > how to make the adjusting ta and setup the holding account. It would be
> > simpler if Valic would update their system to allow downloads to the
> > latest Q spec.
>
> > Thanks for your help.
>
> I have always used a holding account since Cornell and/or TIAA (or
> Vanguard) never processed my paycheck deduction on the date of the
> paycheck.
>
> --
> Best regards
> Han
> email address is invalid- Hide quoted text -
>
> - Show quoted text -

Would/could you port the file to excel and do your clean up there.
There are many more tools in excel than quicken as I"m sure your aware
to batch process data strings, etc. Not knowing more about the
specifics of your needs of course I may be going in the wrong
direction. However.......perhaps it worth your consideration.

Posted by Han on December 31, 2007, 7:34 am
Please log in for more thread options
treasur2@hotmail.com wrote in news:e84745cc-6f40-4318-b1fd-366384fee312
@s8g2000prg.googlegroups.com:

> Would/could you port the file to excel and do your clean up there.
> There are many more tools in excel than quicken as I"m sure your aware
> to batch process data strings, etc. Not knowing more about the
> specifics of your needs of course I may be going in the wrong
> direction. However.......perhaps it worth your consideration.
>
I don't think that will work too well. In Excel, editing references of
transfers between accounts (paycheck - holding account - pension investment
account) will prevent the file from being imported correctly, AFAIK. Qif
was the preferred method for doing export/import, but it has been crippled
by Intuit. From their point of view that was logical, since qif provided a
way for financial institutions to use sort of public domain software to let
clients import their data, and Intuit lost revenue (poor things). So they
came up with a proprietary way of doing things (OFX/QFX), and forced the
FIs to pay, and you to be frustrated.

Remember, backup are your friends.

--
Best regards
Han
email address is invalid


Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap