Home Page link  

What file formats for Q2007?

 

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
What file formats for Q2007? Mr. 01-24-2007
Posted by John Pollard on January 25, 2007, 7:37 pm
Please log in for more thread options
Andrew wrote:
> John Pollard wrote:
>> Charlie K wrote:
>>> You can't import .qfx files into checking, savings,
>>> 401K, and investment files into Quicken 2005, so I
>>> doubt you can in any available upgrade to 2004
>>
>> I'm guessing you meant to say you can't import ".qif"
>> files into checking, savings, 401k, etc.
>>
>> I know that's what Intuit says and what Quicken Help
>> says ...
>
> It's also what Quicken enforces by not being allowed in
> the pulldown to accept those types of accounts as the
> object of the import. (Don't jump on me yet, read on!)

Ok. Can I jump on you later? :)

>> But you *can* import qif files into every account type
>> in every version of Quicken through Q2006 ... and I
>> believe Q2007 as well.
>
> But not directly, right? Don't you have some magically
> methodology to do this? When I try, indeed Quicken
> DOESN'T let me import into Checking, for example. But
> that's because those accounts aren't available in the
> drop down list. So, I assume you must mean you can via
> some other fashion John?
> I really am not trying to be cute here, but the average
> joe like me doesn't understand why you say this. I am,
> however, using Q2007 if that makes a difference.

I think Bob Wang has confirmed my suspicion: Q2007 is no
different in this respect that Q2006 and Q2005.

I always thought that you read all the posts here. If you did,
you would have seen that I have posted the way to do this
before.

Andrew: you can not seriously be saying that just because you
must now add a couple of simple records to the beginning of a
qif file you want to import ... that I am saying something that
is incorrect when I say you can import qif files into any
Quicken account in any Quicken version.

Are you saying I was trying to mislead someone? I have posted
the way to do the import in the Quicken forums; and I have
posted it, or reference to it, in this newsgroup several times.
I have never pretended that there was zero extra work involved
... indeed, when I comment on it I always say there is some
(minor) additional work involved.

As far as I am concerned, those who say you can not import qif
files to certain account types are (almost always
unintentionally) the ones passing on the incorrect information.

I am at a loss to understand your complaint.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Andrew on January 26, 2007, 1:39 am
Please log in for more thread options
John Pollard wrote:
> Andrew wrote:
>> John Pollard wrote:
>>> Charlie K wrote:
>>>> You can't import .qfx files into checking, savings,
>>>> 401K, and investment files into Quicken 2005, so I
>>>> doubt you can in any available upgrade to 2004
>>>
>>> I'm guessing you meant to say you can't import ".qif"
>>> files into checking, savings, 401k, etc.
>>>
>>> I know that's what Intuit says and what Quicken Help
>>> says ...
>>
>> It's also what Quicken enforces by not being allowed in
>> the pulldown to accept those types of accounts as the
>> object of the import. (Don't jump on me yet, read on!)
>
> Ok. Can I jump on you later? :)
>
>>> But you *can* import qif files into every account type
>>> in every version of Quicken through Q2006 ... and I
>>> believe Q2007 as well.
>>
>> But not directly, right? Don't you have some magically
>> methodology to do this? When I try, indeed Quicken
>> DOESN'T let me import into Checking, for example. But
>> that's because those accounts aren't available in the
>> drop down list. So, I assume you must mean you can via
>> some other fashion John?
>> I really am not trying to be cute here, but the average
>> joe like me doesn't understand why you say this. I am,
>> however, using Q2007 if that makes a difference.
>
> I think Bob Wang has confirmed my suspicion: Q2007 is no
> different in this respect that Q2006 and Q2005.
>
> I always thought that you read all the posts here. If you did,
> you would have seen that I have posted the way to do this
> before.
>
> Andrew: you can not seriously be saying that just because you
> must now add a couple of simple records to the beginning of a
> qif file you want to import ... that I am saying something that
> is incorrect when I say you can import qif files into any
> Quicken account in any Quicken version.
>
> Are you saying I was trying to mislead someone? I have posted
> the way to do the import in the Quicken forums; and I have
> posted it, or reference to it, in this newsgroup several times.
> I have never pretended that there was zero extra work involved
> ... indeed, when I comment on it I always say there is some
> (minor) additional work involved.
>
> As far as I am concerned, those who say you can not import qif
> files to certain account types are (almost always
> unintentionally) the ones passing on the incorrect information.
>
> I am at a loss to understand your complaint.

John - I wasn't complaining. I wasn't trying to be cute. I *was* trying to
understand your comment that you can still do QIF imports. I do remember
(that's the allusion to the "methodology") you mentioning some type of
procedure here in the past so I wanted to make sure I knew what you were
talking about.

I do see Bob Wang's reference to http://www.somacon.com/p468.php in a later
post on the subject, so I am also enclosing it in this thread in case
someone sees it and wants to know how, since, although you said it was
possible, there was no reference in this thread (I think) on how to do it.
I'm fine now. I've saved the referenced procedure offline to keep it handy
for the future. Thanks.


--
-------------------------------------------------------------
Regards -

- Andrew



Posted by Stewart Berman on July 2, 2007, 2:37 am
Please log in for more thread options
The method described in your reference, adding an account header, does
not work properly -- at least not for investment accounts. I tried it
using Quicken 2005 H&B and it did import the transactions.
Unfortunately, it imported them directly into the register and not
into the Downloaded Transactions area. Thus, instead of being able to
clear transactions with the import I wound up with duplicate entries
in the register.


>
>John - I wasn't complaining. I wasn't trying to be cute. I *was* trying to
>understand your comment that you can still do QIF imports. I do remember
>(that's the allusion to the "methodology") you mentioning some type of
>procedure here in the past so I wanted to make sure I knew what you were
>talking about.
>
>I do see Bob Wang's reference to http://www.somacon.com/p468.php in a later
>post on the subject, so I am also enclosing it in this thread in case
>someone sees it and wants to know how, since, although you said it was
>possible, there was no reference in this thread (I think) on how to do it.
>I'm fine now. I've saved the referenced procedure offline to keep it handy
>for the future. Thanks.


Posted by John Pollard on July 2, 2007, 9:35 am
Please log in for more thread options
Stewart Berman wrote:
> The method described in your reference, adding an account
> header, does
> not work properly -- at least not for investment accounts. I
> tried it
> using Quicken 2005 H&B and it did import the transactions.
> Unfortunately,

> it imported them directly into the register and not
> into the Downloaded Transactions area.

Noted long ago.

http://tinyurl.com/2qk6wk

But I don't think it has anything to do with the workaround
method; I get the same result when importing directly to a
Q2004 investment account, with no added header records in the
QIF file.

> Thus, instead of being able to
> clear transactions with the import

Not sure I understand what the goal was here.

> I wound up with duplicate entries
> in the register.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Stewart Berman on July 3, 2007, 1:10 am
Please log in for more thread options
>> it imported them directly into the register and not
>> into the Downloaded Transactions area.
>
>Noted long ago.
>
>http://tinyurl.com/2qk6wk
>
>But I don't think it has anything to do with the workaround
>method; I get the same result when importing directly to a
>Q2004 investment account, with no added header records in the
>QIF file.

Unfortunately, that web page as well as the other one often referenced
in this news group says it "you may not get the option to review the
transactions " instead of saying you will not get the option to review
the transactions . Actually the other frequently sited reference
simply says "it may not work with investment accounts".

If you know it doesn't provide the review option why do you say "MAY
not" instead of WILL not.

(Side comment: I wonder which version of Quicken introduced this "bug"
for investment accounts. Must have been about the time that Intuit
was pushing brokerage houses to go to web connect or direct import.)

>Not sure I understand what the goal was here.

The goal was to bring in the transactions for a reconciliation.

I have a 401K account that I normally update via Quicken's direct
import. Unfortunately, that appeared to have missed one or more
transactions as the cash balance was wrong. (Quicken apparently does
not check that -- only positions.) I wanted to go back and import two
years of transactions and check them against the account to see what
was missed. I do not know how to tell Quicken to do that (the lack of
transparency is a real pain) and thought I could import the
transactions via the QIF file into the Downloaded Transactions section
which would then allow me to match them against the register.
Hopefully, the missing transactions would show up as new.

Unfortunately, the work around doesn't work for investment accounts so
there isn't anyway to use a QIF file to clear transactions in an
investment account.


>Stewart Berman wrote:
>> The method described in your reference, adding an account
>> header, does
>> not work properly -- at least not for investment accounts. I
>> tried it
>> using Quicken 2005 H&B and it did import the transactions.
>> Unfortunately,
>
>> it imported them directly into the register and not
>> into the Downloaded Transactions area.
>
>Noted long ago.
>
>http://tinyurl.com/2qk6wk
>
>But I don't think it has anything to do with the workaround
>method; I get the same result when importing directly to a
>Q2004 investment account, with no added header records in the
>QIF file.
>
>> Thus, instead of being able to
>> clear transactions with the import
>
>Not sure I understand what the goal was here.
>
>> I wound up with duplicate entries
>> in the register.


Similar ThreadsPosted
How to shrink your .QPH file (quotes file) October 14, 2006, 11:55 pm
Q2007 July 22, 2006, 12:18 pm
Q2007 August 3, 2006, 2:37 am
Q2007 with IE7? April 23, 2007, 8:10 am
Web Connect - Q2007 August 6, 2006, 9:09 am
Q2007 Sounds August 8, 2006, 9:31 pm
Q2007 CD Backup August 11, 2006, 3:45 pm
Q2007 Price August 14, 2006, 1:25 pm
Q2007 Install August 16, 2006, 8:01 pm
Backup to DVD with Q2007 August 19, 2006, 2:08 am

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