Reconciled Check problem

[peabodyumc]

I wrote a check for the pastor's insurance back in June. It was cashed and showed up on the June 30 bank statement and I marked it as cleared and printed out the reporting showing I marked it as cleared.

Today I balanced the October statement and there is that check showing up. How can a check become unreconciled? I don't even know anywhere except in reconciling where I could note that.

Now I don't know how to reconcile it. I've already taken it out of my balance. I balance when I ignore it but it will stay unreconciled until I do something with it.

How could this have happened and how do I fix it?

Thanks.

Laurie

[Matt]

Laurie,

It is possible to "unreconcile" a check on the bank reconciliation. This can happen if one clicks the "all data" button when initially running the reconciliation. This will cause all the transactions that have hit the checking account to appear, both reconciled and unreconciled. One could then click on a reconciled check to "unreconcile" it. The system will give you a warning message if you do this but will allow you to unreconcile the item if you click "Yes".

However, there's something else going on in your situation because if the check truly had cleared on the bank statement and you got your bank statement to reconcile back in June then if someone did later "unreconcile" this check you would not have been able to get the October bank reconciliation to balance. It almost appears as if the check got entered a second time. Run a history on the journal report for that check number for 2007 and see if the check has been input twice. If so, all you need to do is reverse the second posting to clear this off the bank reconciliation.

[peabodyumc]

Hi Matt,

Thanks for responding. When I reconcile I always check unreconciled data -- I didn't think about the ability to unreconcile an item -- I just don't want to have to scroll through things I have already reconciled.

There are only two of us that use PC+ and I am the only one with access to the accounting module so no one else could have gotten into reconcile and uncleared the check.

I'll try running the report when I get home but I did go into View Posted transactions and sorted and only found one instance of the check. It isn't possible to have one be hidden is it?

Thanks.

Laurie

[Matt]

Carefully recompare the data (e.g. date, check number, payee) on the check that cleared and was printed on the June bank reconciliation report from PowerChurch with the one that is now showing as uncleared on the bank recon in Powerchurch. If the data is exactly the same and you could only find one instance of the check in View Posted transactions this indicates that the check got "unreconciled". If so, since the October bank statement reconciled the only thing I can think of is that at the time the June check was "unreconciled" another outstanding check for the exact same amount that wasn't reconciled was erroneously clicked as reconciled. So the unreconciled check you are seeing may actually still be outstanding but the check number is incorrect.

To find this carefully recompare the deposits and checks that are on the bank statements with the deposits and checks that are shown as cleared on the bank reconciliation printouts from PowerChurch for the months of June through October. These two should be exactly the same. Be sure to pay close attention to the check and reference numbers as you do the comparisons.