Import transactions without reconcile

Posted by Rajah on September 23, 2007, 9:16 pm

Please log in for more thread options

: quoted-printable

=20
Quicken 2001 Deluxe - already importing my checking account transactions =
with QIF files downloaded from my bank. How does one do this WITHOUT =
reconciling? That is, the import and acceptance process marks the items =
as reconciled.

------=_NextPart_000_00B2_01C7FE0D.E39E70B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1597" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2> 
<DIV>Quicken 2001 Deluxe - already importing my checking account =
transactions=20
with QIF files downloaded from my bank.  How does one do this =
WITHOUT=20
reconciling?  That is, the import and acceptance process marks the =
items as=20
reconciled.</DIV>
<DIV> </DIV></FONT></DIV></BODY></HTML>

------=

Posted by John Pollard on September 23, 2007, 9:53 pm

Please log in for more thread options

Rajah wrote:

> Quicken 2001 Deluxe - already importing my checking account

> transactions with QIF files downloaded from my bank. How does

> one do

> this WITHOUT reconciling? That is, the import and acceptance

> process

> marks the items as reconciled.

Q2001 is too old for me to remember what capabilities it had.

If you had a newer version of Quicken, I would suggest you tell
Quicken you do not want to "auto reconcile" ( and possibly that
you do not want to reconcile to an Online Balance"). Both
options are chosen in the "Reconcile" dialog.

[Please note that if you switch from reconciling to an Online
Balance, you will probably have to re-reconcile all the
transactions in the account ... though you should be able to do
that in a single "reconcile". Switching from doing an "auto
reconcile" does not create any problems I know of.]

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

Posted by John Pollard on September 24, 2007, 10:13 am

Please log in for more thread options

John Pollard wrote:

> Rajah wrote:

>> Quicken 2001 Deluxe - already importing my checking account

>> transactions with QIF files downloaded from my bank. How

>> does

>> one do

>> this WITHOUT reconciling? That is, the import and acceptance

>> process

>> marks the items as reconciled.

> Q2001 is too old for me to remember what capabilities it had.

> If you had a newer version of Quicken, I would suggest you

> tell

> Quicken you do not want to "auto reconcile" ( and possibly

> that

> you do not want to reconcile to an Online Balance"). Both

> options are chosen in the "Reconcile" dialog.

> [Please note that if you switch from reconciling to an Online

> Balance, you will probably have to re-reconcile all the

> transactions in the account ... though you should be able to

> do

> that in a single "reconcile". Switching from doing an "auto

> reconcile" does not create any problems I know of.]

After a sound sleep, I have one other thought.

Your financial institution may be putting a "Cleared status" of
"R" (or "X") in the QIF file you are importing. That's easy
enough to check: open the QIF file in Wordpad or Notepad and
look for records with a "C" in position one. If such records
are present and they have an "R" or "X" in position two, that is
the source of your "automatically" reconciled transactions.

The only way to prevent the effect is to modify the QIF file to
either delete those records with a "C" in position one, or to
change the "CR/CX" to "C" (or "Cc", if you want the transactions
to be "Cleared" when Accepted into Quicken).

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

Posted by Rajah on September 24, 2007, 11:33 pm

Please log in for more thread options

> John Pollard wrote:

> > Rajah wrote:

> >> Quicken 2001 Deluxe - already importing my checking account

> >> transactions with QIF files downloaded from my bank. How

> >> does

> >> one do

> >> this WITHOUT reconciling? That is, the import and acceptance

> >> process

> >> marks the items as reconciled.

> >

> > Q2001 is too old for me to remember what capabilities it had.

> >

> > If you had a newer version of Quicken, I would suggest you

> > tell

> > Quicken you do not want to "auto reconcile" ( and possibly

> > that

> > you do not want to reconcile to an Online Balance"). Both

> > options are chosen in the "Reconcile" dialog.

> >

> > [Please note that if you switch from reconciling to an Online

> > Balance, you will probably have to re-reconcile all the

> > transactions in the account ... though you should be able to

> > do

> > that in a single "reconcile". Switching from doing an "auto

> > reconcile" does not create any problems I know of.]

> After a sound sleep, I have one other thought.

> Your financial institution may be putting a "Cleared status" of

> "R" (or "X") in the QIF file you are importing. That's easy

> enough to check: open the QIF file in Wordpad or Notepad and

> look for records with a "C" in position one. If such records

> are present and they have an "R" or "X" in position two, that is

> the source of your "automatically" reconciled transactions.

> The only way to prevent the effect is to modify the QIF file to

> either delete those records with a "C" in position one, or to

> change the "CR/CX" to "C" (or "Cc", if you want the transactions

> to be "Cleared" when Accepted into Quicken).

> --

> John Pollard

> First initial underscore Last name at mchsi dot com

> Please reply to newsgroup

Success - Thanks for suggestion. Each transaction is as below. First, I
did a "find and replace" to remove the "C*" for all transactions and then
deleted the blank lines where the C* had been..
!Type:Bank
D06/26/2007

T-25.00

PMC-Vendor Name

C*

^