| Bank Reconciliation report balances are off by voided checks |
Cause | The voided checks are reconciled with a Statement date that is before the Void date.
For example, if a check with a check date of March is voided in May but reconciled in April, the April Bank Reconciliation will be off because that check should be considered as outstanding in April. |
Resolution | Unreconcile the voided check then re-reconcile with a Cleared Date/Statement Date on or after the Void date:
- In Cash Management, from the File menu, select Company Settings, CM Settings.
- Mark the box for Allow reconciliation status change in Register.
- Click OK.
- From the Tasks menu, select Edit Register.
- Find the voided check.
- Click the ...> button located after the Addition column.
- Change the Reconciliation Status to O, then change it back to R.
- Enter the Cleared Date with a date that is on or after the Void date.
- Click OK.
- Repeat steps 5 through 9 for any additional voided checks.
- Click Finish.
- In Cash Management, from the File menu, select Company Settings, CM Settings.
- Clear the box for Allow reconciliation status change in Register.
- Click OK.
When running the Bank Reconciliation report for a month after the check date but before the void date, the check should be included in the Register Balance Adjusted for Future Period Voids.
TIP: You can prevent voided checks from being reconciled before the void date by adding a condition when reconciling the bank statement in Reconcile for Void Date is Less than or equal to the statement date.
DocLink: Register Balance Adjusted for Future Period Voids may be incorrect on the Bank Reconciliation report DocLink: An Accounts Payable check or electronic payment was voided with a different date (void date is after the original check/payment date)
|
|