Home Page link  

Import transactions without reconcile

  
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
Import transactions without reconcile Rajah 09-23-2007
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>&nbsp;
<DIV>Quicken 2001 Deluxe - already importing my checking account =
transactions=20
with QIF files downloaded from my bank.&nbsp; How does one do this =
WITHOUT=20
reconciling?&nbsp; That is, the import and acceptance process marks the =
items as=20
reconciled.</DIV>
<DIV>&nbsp;</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*

^


>



Similar ThreadsPosted
reconcile not showing all transactions August 13, 2008, 6:57 pm
export transactions ten import ? January 19, 2008, 6:22 pm
How to import historical investment transactions October 25, 2006, 2:29 pm
Reconcile goof up February 24, 2007, 7:34 pm
Reconcile method November 9, 2007, 11:46 am
Reconcile data January 18, 2008, 10:02 pm
how to reconcile old accounts May 24, 2006, 7:02 am
Reconcile/Download problem January 13, 2007, 9:50 am
How do I reconcile transfers to other accounts? April 6, 2007, 6:03 pm
Reconcile error after cleanup August 12, 2007, 1:16 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