Hello,

There are 5 cheques from 2009 that still appear in bank rec that have actually cleared our bank. Our bank reconciliation balances to our statement.

How do we clear these items and still balance to the actual bank statement?

Note: at December 31, our Bank Rec totals did not balance to our GL. An adjusting entry was made to the GL balance as Bank Rec did balance to our bank statement.

Thanks,
Lisa

The way to purge transactions that have cleared the bank and have been reconciled in BankRec is to do a period end. You can set a date for which all reconciled transactions prior to that date get purged - default this is determined by the number of days for which you keep history, set in the Company Profile.

Transactions that are still outstanding (not yet reconciled) will not be purged. Are these 5 checks still marked as outstanding?

Purging reconciled transactions does not affect the balance for today. If you are not sure about this, then definitely make a backup of your BankRec data prior to purging anything.

The cheques do still show outstanding, even though they have cleared the bank and we have posted weekly reconciliations since that time.

None of the reconciliation status changes allow leaving the bank balance unchanged. You would need to Clear the 5 checks, which would change the balance. And then create and post an entry in BankRec to restore the balance back to what it was. Assuming those 5 checks were payments, you would do a receipt with no customer number. It doesn't matter about the distribution account, just the amount.

Ensure that this 'reversing' BankRec batch entry does not get posted in Ledger or anywhere else.

Another thought is to Clear with Error and set to 0.00. This won't touch the balance in BankRec, but you should ensure that these entries that will get retrieved into Ledger are deleted, not posted.

Thanks!