Bank Reconciliation report balances are off by voided checks
Description
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:

  1. In Cash Management, from the File menu, select Company Settings, CM Settings.
  2. Mark the box for Allow reconciliation status change in Register.
  3. Click OK.
  4. From the Tasks menu, select Edit Register.
  5. Find the voided check.
  6. Click the ...> button located after the Addition column.
  7. Change the Reconciliation Status to O, then change it back to R.
  8. Enter the Cleared Date with a date that is on or after the Void date.
  9. Click OK.
  10. Repeat steps 5 through 9 for any additional voided checks.
  11. Click Finish.
  12. In Cash Management, from the File menu, select Company Settings, CM Settings.
  13. Clear the box for Allow reconciliation status change in Register.
  14. 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)
Defect ID
Steps to duplicate
Related Articles