Bank Reconciliation Corrections in Auditor

Bank Rec Ending Date

In the back end, go to Tables / BankRecs. The Date column is the date the reconciliation was completed in Jewel. A Date of 1/1/1990 is assigned to Beginning Balances. A Date of 12/1/1994 is assigned to bank recs that have been "undone".

Correct the EndingDate column of the bank rec(s) that are incorrect.

Bank Rec Beginning Balance

Jewel uses the ending balance for the previous bank reconciliation as the beginning balance for the next bank rec. "Previous" is defined as the first-completed bank rec on the most recent date. This can cause problems when treasurers make mistakes with their ending dates.

If a beginning balance is incorrect, check the EndingDate column in Tables / BankRecs for any dates that are out of order. Remember you can sort by clicking on the column heading.

Cleaning Up the Bank Rec in Auditor

Start with Cleaning Up the Bank Rec in the Jewel Handbook

Stale Date Remittance Check

Duplicate?