Missing transactions that are actually there while reconciling.

dougcolemandec

I have been reconciling my checking account going back 7 years. The transactions were all entered and categorized. They are mostly correct, and most were downloaded over the years.

Most times the reconciliation shows a zero deviance, and all is good. Sometimes, and I have no idea of a common thread when this happens, the balance will be out by, let's say, one deposit. (not always, sometimes a debit also). If I go to "New" or "Edit" and look for the transaction, it is there, and is correctly dated. I will copy the transaction, paste it as a new transaction, go back to the reconciliation window, and see the transaction and the balance is fine. I will complete the reconciliation and return to the register. I will see the reconciled transaction, and the cleared, not reconciled, transaction, which I then delete (otherwise the current account balance is wrong).

So why is this a pretty constant, nothing more than irritating occurrence?

The Keeper

If I understand correctly, when you perform a reconciliation, a transaction is not showing in the reconcile window?

If this is the case, I have learned over the years that on occassion, the reconciliation date will default to an incorrect date. Your bank statements may have a different date but my statements close on the last day of the month. The 30th or 31st for example. The reconciliation window will sometimes display the 30th instead of the 31st. As a result, a transaction dated the 31st will not display in the reconciliation window because that window shows a date of the 30th. The missing transaction is displayed when I change the reconciliation window date to the 31st.

Sometimes I have a transaction on the 31st day of the month, it is displayed in the register but not in the reconciliation window. In the register, I will change the transaction date to an earlier date, let us say the 25th, and the transaction will then show in the reconciliation window. When I complete the reconciliation, I find the transaction in the register, change the date to the 31st, and click save.

You didn't indicate your missing reconciliation transactions were at the end of the month or the end of your statement date, but if you are experiencing the same problem I have, the above information may be helpful. If this is the case, perhaps change the date of the transaction instead of copying, pasting, and then deleting the duplicate transaction.