CLR column shows 'c' after reconciled

Posted by watchdog2001 on October 29, 2009, 9:00 pm

Please log in for more thread options

I’m running Quicken 2009 using Windows XP. I have a problem that has
developed for some unknown reason. When I perform an “update now” for my
credit card I am able to receive (download) the credit card transactions
with no problem. I accept all of the transactions which were downloaded,
then click finish to complete the reconciliation process. Each of the
transactions, which have been accepted, all have their ‘CLR’ column set to
‘c’ rather than ‘R’ as they should to show they have been reconciled. This
only happens for the one credit card account and other functions seem to
be fine. I’ve run a ‘validate’ on the file and it came up clean.

Any ideas on how to correct this would be appreciated,

John Acosta

##-----------------------------------------------##
Newsgroup Access Courtesy
http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access
to your favorite newsgroup -
alt.comp.software.financial.quicken - 19020
messages and counting!
##-----------------------------------------------##

Posted by John Pollard on October 30, 2009, 12:09 am

Please log in for more thread options

watchdog2001 wrote:

> I'm running Quicken 2009 using Windows XP. I have a problem that has

> developed for some unknown reason. When I perform an "update now" for

> my credit card I am able to receive (download) the credit card

> transactions with no problem. I accept all of the transactions which

> were downloaded, then click finish to complete the reconciliation

> process. Each of the transactions, which have been accepted, all have

> their 'CLR' column set to 'c' rather than 'R' as they should to show

> they have been reconciled. This only happens for the one credit card

> account and other functions seem to be fine. I've run a 'validate' on

> the file and it came up clean.

Your assumption that the downloaded transactions should automatically be
treated as "reconciled" is not a good assumption. [In my opinion, it's
not even a good desire.]

The normal way to treat downloaded transactions is: they are "cleared"
transactions: that is; they have "cleared" your real-world account.

To assume that a downloaded transaction is correct is, in my opinion, a
leap of faith. But:

Quicken does not assume that every account reconcile should be treated the
same way. If you want a Quicken account to "Reconcile to" an "Online
Balance", and to"Auto reconcile .... ": you must select those options in
the "Reconcile" dialog for the account in question.

And you had better be sure that is what you want to do, since changing the
reconcile method for a given Quicken account can create problems.

--

John Pollard

Posted by watchdog2001 on October 30, 2009, 10:40 am

Please log in for more thread options

watchdog2001 had written this in response to
http://www.rockryno.com/quicken/Re-CLR-column-shows-c-after-reconciled-19618-.htm
:
John thanks for the response,
Maybe I was unclear, I don't want to have Quicken mark all downloaded
transactions as an "R" but rather only the transactions that I have
accepted and which have matching transactions in the register. I realize
that you don't want Quicken to automatically accept all transactions and
tag them with a clr flag of "R", as you said that would be a disaster.
Until a couple of weeks ago, Quicken was marking all downloaded
transactions I accepted with a clr column "R" once I went successfully
thru the reconcile process. I had problem with my credit card institution
allowing transactions to be downloaded via the "update all" button so I
switched to a manual reconcile process. Now that I am able to do a "update
all" by downloading from my credit card institution, the problem described
above exists. It almost seems as though a date got logged within Quicken
when I did the manual reconcile and it thinks I haven't gone thru a
successful reconcile session now that I reverted by to downloading
transactions.

Regards,
John Acosta
-------------------------------------
John Pollard wrote:

> watchdog2001 wrote:

>> I'm running Quicken 2009 using Windows XP. I have a problem that

>> has

>> developed for some unknown reason. When I perform an "update

>> now" for

>> my credit card I am able to receive (download) the credit card

>> transactions with no problem. I accept all of the transactions

>> which

>> were downloaded, then click finish to complete the reconciliation

>> process. Each of the transactions, which have been accepted, all

>> have

>> their 'CLR' column set to 'c' rather than 'R' as they should to

>> show

>> they have been reconciled. This only happens for the one credit

>> card

>> account and other functions seem to be fine. I've run a 'validate'

>> on

>> the file and it came up clean.

> Your assumption that the downloaded transactions should automatically

> be

> treated as "reconciled" is not a good assumption. [In my

> opinion, it's

> not even a good desire.]

> The normal way to treat downloaded transactions is: they are

> "cleared"

> transactions: that is; they have "cleared" your real-world

> account.

> To assume that a downloaded transaction is correct is, in my opinion, a

> leap of faith. But:

> Quicken does not assume that every account reconcile should be treated

> the

> same way. If you want a Quicken account to "Reconcile to" an

> "Online

> Balance", and to"Auto reconcile .... ": you must select

> those options in

> the "Reconcile" dialog for the account in question.

> And you had better be sure that is what you want to do, since changing

> the

> reconcile method for a given Quicken account can create problems.

##-----------------------------------------------##
Newsgroup Access Courtesy
http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access
to your favorite newsgroup -
alt.comp.software.financial.quicken - 19034
messages and counting!
##-----------------------------------------------##

Posted by John Pollard on October 30, 2009, 11:36 am

Please log in for more thread options

watchdog2001 wrote:

> watchdog2001 had written this in response to

http://www.rockryno.com/quicken/Re-CLR-column-shows-c-after-reconciled-19618-.htm

> John thanks for the response,

> Maybe I was unclear, I don't want to have Quicken mark all

> downloaded transactions as an "R" but rather only the transactions

> that I have accepted and which have matching transactions in the

> register. I realize that you don't want Quicken to automatically

> accept all transactions and tag them with a clr flag of "R", as you

> said that would be a disaster. Until a couple of weeks ago, Quicken

> was marking all downloaded transactions I accepted with a clr column

> "R" once I went successfully thru the reconcile process. I had

> problem with my credit card institution allowing transactions to be

> downloaded via the "update all" button so I switched to a manual

> reconcile process. Now that I am able to do a "update all" by

> downloading from my credit card institution, the problem described

> above exists. It almost seems as though a date got logged within

> Quicken when I did the manual reconcile and it thinks I haven't gone

> thru a successful reconcile session now that I reverted by to

> downloading transactions.

First: Accepting downloaded transactions isn't really reconciling, despite
the fact that Quicken will allow you to combine the two steps.

Second: I didn't say anything about automatically "accepting" downloaded
transactions; I mentioned "auto reconciling" downloaded transactions ...
automatically giving downloaded transactions a Cleared Status of "R" when
you click "Accept".

Third: Rephrasing what I said before; if you tell Quicken to "reconcile to
a printed statement", Quicken will mark all Accepted downloaded
transactions (New or Match) with a Cleared Status of "c" (and you will
need to "manually" reconcile them in a separate step); if you tell Quicken
to "reconcile to an online balance" and you tell Quicken to "Auto
reconcile ....", Quicken will mark all Accepted downloaded transactions
(New or Match) with a Cleared Status of "R". Those reconcile options are
set at the account level, and they are in the initial reconcile dialog box
(for non-investment accounts activated for downloading).

Quicken does remember those options from reconcile to reconcile; so if
they are not currently set correctly, you need to reset them when you
start your next reconcile (or by initiating a reconcile and cancelling it
after you have set the options but without doing the actual reconcile).

If you have told Quicken to reconcile to a printed statement or to
reconcile to an online balance but not to "auto reconcile" (what I think
of when you refer to a "manual reconcile process"), and you initiate a
reconcile, and you tell Quicken to "mark" the appropriate transactions as
"reconciled" (or Quicken "marks" them for you), and you "Finish" the
reconcile and those "marked" transactions do not have an "R" in their
Cleared Status, I'm not sure what the problem is.

--

John Pollard

Posted by watchdog2001 on October 30, 2009, 1:10 pm

Please log in for more thread options

watchdog2001 had written this in response to
http://www.rockryno.com/quicken/Re-CLR-column-shows-c-after-reconciled-19626-.htm
:
John,
Thanks for the insight... it allowed me to figure out the problem.
Although Quicken was set to "reconcile to an online balance" and to "Auto
reconcile", it would still mark all Accepted (new/matched) downloaded
transactions with a Cleared Status of "c". I unchecked the "Auto
reconcile" box and exited Quicken. I started Quicken back up and went back
and checked the "Auto reconcile" box. Now the "update all" all works just
as you described (and the way it did previously) all downloaded
transactions that are Accepted now get tagged with a Cleared Status of "R"
when I return to the register. The only thing I can figure is the switch
got confused because of me switching reconciling methods a while back. In
any event, your excellent explaination gave me the clues I needed.

I appreciate it,

John Acosta
-------------------------------------
John Pollard wrote:

> watchdog2001 wrote:

>> watchdog2001 had written this in response to

http://www.rockryno.com/quicken/Re-CLR-column-shows-c-after-reconciled-19618-.htm

>>>

>> John thanks for the response,

>> Maybe I was unclear, I don't want to have Quicken mark all

>> downloaded transactions as an "R" but rather only the

>> transactions

>> that I have accepted and which have matching transactions in the

>> register. I realize that you don't want Quicken to automatically

>> accept all transactions and tag them with a clr flag of

>> "R", as you

>> said that would be a disaster. Until a couple of weeks ago,

>> Quicken

>> was marking all downloaded transactions I accepted with a clr

>> column

>> "R" once I went successfully thru the reconcile process.

>> I had

>> problem with my credit card institution allowing transactions to

>> be

>> downloaded via the "update all" button so I switched to

>> a manual

>> reconcile process. Now that I am able to do a "update

>> all" by

>> downloading from my credit card institution, the problem described

>> above exists. It almost seems as though a date got logged within

>> Quicken when I did the manual reconcile and it thinks I haven't

>> gone

>> thru a successful reconcile session now that I reverted by to

>> downloading transactions.

> First: Accepting downloaded transactions isn't really reconciling,

> despite

> the fact that Quicken will allow you to combine the two steps.

> Second: I didn't say anything about automatically "accepting"

> downloaded

> transactions; I mentioned "auto reconciling" downloaded

> transactions ...

> automatically giving downloaded transactions a Cleared Status of

> "R" when

> you click "Accept".

> Third: Rephrasing what I said before; if you tell Quicken to

> "reconcile to

> a printed statement", Quicken will mark all Accepted downloaded

> transactions (New or Match) with a Cleared Status of "c" (and

> you will

> need to "manually" reconcile them in a separate step); if you

> tell Quicken

> to "reconcile to an online balance" and you tell Quicken to

> "Auto

> reconcile ....", Quicken will mark all Accepted downloaded

> transactions

> (New or Match) with a Cleared Status of "R". Those reconcile

> options are

> set at the account level, and they are in the initial reconcile dialog

> box

> (for non-investment accounts activated for downloading).

> Quicken does remember those options from reconcile to reconcile; so if

> they are not currently set correctly, you need to reset them when you

> start your next reconcile (or by initiating a reconcile and cancelling

> it

> after you have set the options but without doing the actual reconcile).

> If you have told Quicken to reconcile to a printed statement or to

> reconcile to an online balance but not to "auto reconcile"

> (what I think

> of when you refer to a "manual reconcile process"), and you

> initiate a

> reconcile, and you tell Quicken to "mark" the appropriate

> transactions as

> "reconciled" (or Quicken "marks" them for you), and

> you "Finish" the

> reconcile and those "marked" transactions do not have an

> "R" in their

> Cleared Status, I'm not sure what the problem is.

##-----------------------------------------------##
Newsgroup Access Courtesy
http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access
to your favorite newsgroup -
alt.comp.software.financial.quicken - 19037
messages and counting!
##-----------------------------------------------##