Quicken 2012 breaks bank account reconcilliation

"JohnA" wrote

This appears to be broken. The reconciliation date is 9/30, but the screen will exclude non-deposit transactions dated 9/30 (which are cleared). Previously, they would be included but might not be checked if not cleared. There doesn't appear to be a way to add them other than change the reconciliation date to 10/1 which then picks them up but also deposit transactions dated 10/1 - at least I can uncheck them. However, this is not an ideal solution... What happened to regression testing?

--------------------------------------------------------------

Transaction date is not used by Quicken to determine whether a transaction belongs in a given reconcile: Quicken uses "Posting date" (the date the transaction cleared the financial institution). If the posting date is later than the reconcile statement ending date, the transaction does not qualify for the reconcile. Blank posting dates qualify for every reconcile.

The easy way to see the posting dates in Q2011 and later: In your account register, click Account Actions > Register Columns, and put a check mark in "Downloaded Posting Date".

This appears to be more complicated than I thought - evidently, it is just skipping over some transactions for reconciliation even though they are marked "cleared" - they also appear to be transfers. Not sure what the problem is but this is unacceptable. Anyone else reconcile lately with 2012 and not having a problem?

This appears to be broken. The reconciliation date is 9/30, but the screen will exclude non-deposit transactions dated 9/30 (which are cleared). Previously, they would be included but might not be checked if not cleared. There doesn't appear to be a way to add them other than change the reconciliation date to 10/1 which then picks them up but also deposit transactions dated 10/1 - at least I can uncheck them. However, this is not an ideal solution... What happened to regression testing?

Hi John,

Thanks for the tip - the posting date is indeed incorrect in these transactions missing from reconcilliation - the only way I know how to correct it is to set the reconciliation date to include the posting date. I did not have this problem in the previous version, did something change?

-- John

"JohnA" wrote

This appears to be broken. The reconciliation date is 9/30, but the screen will exclude non-deposit transactions dated 9/30 (which are cleared). Previously, they would be included but might not be checked if not cleared. There doesn't appear to be a way to add them other than change the reconciliation date to 10/1 which then picks them up but also deposit transactions dated 10/1 - at least I can uncheck them. However, this is not an ideal solution... What happened to regression testing?

--------------------------------------------------------------

Transaction date is not used by Quicken to determine whether a transaction belongs in a given reconcile: Quicken uses "Posting date" (the date the transaction cleared the financial institution). If the posting date is later than the reconcile statement ending date, the transaction does not qualify for the reconcile. Blank posting dates qualify for every reconcile.

The easy way to see the posting dates in Q2011 and later: In your account register, click Account Actions > Register Columns, and put a check mark in "Downloaded Posting Date".

"JohnA"

Hi John,

Thanks for the tip - the posting date is indeed incorrect in these transactions missing from reconcilliation - the only way I know how to correct it is to set the reconciliation date to include the posting date. I did not have this problem in the previous version, did something change?

---------------------------------------------

Nothing changed that I know of.

Posting dates come from the downloaded data. I do not recall ever seeing one of mine that was incorrect. If you Accept a downloaded transaction as a "Match" to the wrong register transaction, you'll get a posting date from the downloaded transaction ... which may not be correct for that register transaction.

To modify the posting date for a transaction: right-click the transaction, hold down CTRL while left-clicking "Copy transaction(s)". Modify the posting date and click OK.

Hi John,

Thanks again for the valuable info... I suspect that I did indeed accept the wrong transaction for some of them . It appears that if there are two transactions with the same amount but different days relatively close to one another, Qucken always matches the first one with the second transaction and the second one with the first. Don't know why, it's just an observation over the years.

-- John

"JohnA"

Hi John,

Thanks for the tip - the posting date is indeed incorrect in these transactions missing from reconcilliation - the only way I know how to correct it is to set the reconciliation date to include the posting date. I did not have this problem in the previous version, did something change?

---------------------------------------------

Nothing changed that I know of.

Posting dates come from the downloaded data. I do not recall ever seeing one of mine that was incorrect. If you Accept a downloaded transaction as a "Match" to the wrong register transaction, you'll get a posting date from the downloaded transaction ... which may not be correct for that register transaction.

To modify the posting date for a transaction: right-click the transaction, hold down CTRL while left-clicking "Copy transaction(s)". Modify the posting date and click OK.

"JohnA" wrote Thanks again for the valuable info... I suspect that I did indeed accept the wrong transaction for some of them . It appears that if there are two transactions with the same amount but different days relatively close to one another, Qucken always matches the first one with the second transaction and the second one with the first. Don't know why, it's just an observation over the years.

----------------------------------------------------------

Quicken certainly doesn't get all the "Match" and "New" status' correct, though I've had very good results in that area.

When Quicken looks for matches, it tends to try to match to the oldest viable candidate first ... I assume reasoning that if the downloaded transaction could match more than one register transaction, the older undownloaded register transaction is more likely to have cleared the bank.

When I process downloaded transactions, I start with the "Match" transactions. I select them one-by-one in the "Accept transactions into register" window and look in the register to see which transaction they "match". If the transaction should be new, or it should match a different register transaction; I correct that. Then (if it's still a Match) I Accept the Match and keep repeating the process until all Matches have been processed.

Then I just visually scan the "New" transactions (which is all that remains at this point); when I'm convinced they are all genuinely "New" transactions, I click "Accept All".