Trouble reconciling checking account

twemcd

My bank recently changed its online banking software. Finally I can download transactions as before. When I attempted to reconcile the account this month the Quicken screen that shows the opening balance has a different amount than the banks opening balance on their statement. I have gone through each transaction on the statement, removed duplicate transactions and even manually changed the opening balance in Quickens reconciliation screen. The amount on that screen keeps returning to the original figure and my register is off by the difference between the two opening amounts.

Tom Young

"...and even manually changed the opening balance in Quickens reconciliation screen."

Although you can change that number on the screen, it's actually a calculated number that you can't actually affect for purposes of the reconciliation.  Something has changed in a transaction with an "R" in the Clr column entered as of or before the opening date.  Maybe a transaction was deleted, the dollar amount changed, a new transaction with an "R" in the Clr column was added, or something.  You need to try and run down the change or changes to get that opening balance to agree to the statement.  If you can't do that you'll have to make an adjustment in this month's reconciliation. 

sakraf

Trying to reconcile a checking account and Quicken says there are no uncleared items. My register shows uncleared items in red in the left most column.

UKR

https://community.quicken.com/discussion/comment/20499413#Comment_20499413

"Uncleared items" looks at the "Clr" field in each transaction, whether it's marked uncleared (blank), "c"(cleared) or "R"(reconciled).

Starting a Reconcile, please be sure to select the correct Reconcile End Date, e.g., the end of last month for a checking account. If you select an older date where all transactions have already been marked "R", then message "no uncleared items" would be expected.

Chris_QPW

Almost every time Quicken posts the "No uncleared items" message it is because the user is reconciling to the online balance, and it hasn't been updated, or even more importantly the online balance date hasn't been updated. As such, you are reconciling to a date in the past, and that is why it is ignoring the more current cleared transactions.

The Online Balance/date is downloaded with the transactions, but in some cases has been known not to be updated properly in the downloaded information.

If you change one of your past reconciled transactions from R to c and start the reconcile. The reconcile window will come up. From there you can select the Balances button, and it will tell you both the Online Balance and the date. If running One Step Update doesn't properly update this date you will have to switch to manually entering the ending date and amount.

You can do that by right clicking on the account name in the Account bar and selecting Edit/Delete account → Online Services tab → deselect "Reconcile using online balance".