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 latest possible date. This can cause problems when treasurers accidentally save reconciliations with future ending dates and then try to correct the problem themselves.

If a beginning balance is incorrect, compare the Date column to the EndingDate column to ensure that everything makes sense. There shouldn't be any Ending Dates that are after the Date of reconciliation, such as the 4/30/26 reconciliation done on 4/7/26. And there shouldn't be any duplicate Ending Dates. If you find an error or duplicate, simply type in the correct Ending Date. Duplicates can be separated by changing the date by one day, so you have 4/29/26 and 4/30/26 instead of two 4/30/26's. This also resolves a known issue with the Bank Rec report, where only one reconciliation per date can be viewed.

Cleaning Up the Bank Rec in Auditor

Start by reading Cleaning Up the Bank Rec in the Jewel Handbook. By the time tech support gets involved, outstanding checks are often several years old, so can simply be voided and cleared, without any real need for investigation. The exception is remittance checks, see below.

Stale Date Remittance Check

Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.