| Register Balance as of Statement Date does not match Adjusted Bank Balance on my Bank Reconciliation report (item's Cleared date is before the Reference date) |
Cause | Items are cleared with a date prior to the Reference Date. |
Resolution |
- Verify all entries are posted in Cash Management.
- Compare the Cleared Date with the Reference Date:
- From the Inquiry menu, select Bank Register.
- Double-click the bank account.
- Click Conditions (blue funnel button).
- From the Field list, select Cleared Date.
- Under Operator, select Less than.
- Under Value, click List and select Reference Date then click OK.
- Click OK.
- Click Add.
- From the Field list, select Cleared Date.
- Under Operator, select Not equal to.
- Leave the Value blank then click OK.
- Click OK.
- Add columns for Cleared Date and Reference Date.
- If the Cleared Date is prior to the Reference Date correct one of two ways:
- If the reconciliation status us Cleared (C), in Tasks, Edit Register change the Cleared Date to match or be later than the Reference Date.
- If the reconciliation status is Reconciled (R), correct the Statement Date. For more information, see the link below for article 23970 "What do I do if I entered a wrong statement date for my bank reconciliation?"
- Change the item to be Open, void or delete the entry, re-enter with a correct Reference Date, re-reconcile in Edit Register. Refer to article ID 22176 "How do I change the reconciled status of a transaction in Cash Management?"
DocLink: A Check or Bank transaction Cleared date is before the Reference/Check date. DocLink: How do I change the reconciliation status of a transaction in Cash Management? DocLink: Wrong statement date entered for bank reconciliation
|
|