Bank Reconciliation Corrections in Auditor: Difference between revisions
(Created page with "==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...") |
|||
| Line 6: | Line 6: | ||
==Bank Rec Beginning Balance== |
==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. |
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 and try to correct them themselves. |
||
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. |
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== |
==Cleaning Up the Bank Rec in Auditor== |
||
Revision as of 22:47, 22 April 2026
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 and try to correct them themselves.
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?