FAQ: How does Quicken determine which transactions qualify for a reconcile?

Howard Roark

Howard Roark

Quicken (for Windows) determines whether a transaction qualifies for a reconcile by comparing the transaction "Posting date" to the reconcile "Ending Statement Date".
If the transaction Posting date is later than the Ending Statement Date, the transaction won't appear in the reconcile.

Downloaded transactions contain a date called the "Downloaded Posting Date" (not the same as the "Posting date"). A downloaded transaction will set the Quicken "Posting date" field equal to the "Downloaded Posting Date" field. Transactions that have not been downloaded as New, or had a downloaded transaction "matched" to them; will have a blank Posting date - causing them to qualify for any reconcile.
To change which transactions appear in a reconcile, you can change the transaction Posting date or the reconcile Ending Statement Date.
To view and/or modify the transaction Posting date: right-click the transaction in the register; hold down CTRL while left-clicking "Copy transaction(s)"; chose, or key, the desired Posting date and click OK.
[To view the "Downloaded Posting Date" (different field than Posting date): Account Actions > Register columns. Put a check mark in "Downloaded Posting Date". Q2011 and newer.]
[The above pertains to non-investment accounts that utilize the standard Quicken reconcile dialog.]

Howard Roark

Note: There appears to have been a change in the rules for determining which transactions qualify for a reconcile. I can not say exactly when this change was made, but it is effective in Q2015.


The change is this: 


Transactions with a "transaction date" later than the reconcile statement ending date will not appear in the reconcile. 


["Transaction date" is the date appearing in the register column named "Date".]


This change makes sense, since a transaction can not clear the bank before it actually occurs.