The Register Balance Adjusted for Future Period Voids uses a formula that is including all outstanding voids regardless of the void date. It should only include the voided amounts with a void date after the Statement Date.

Option I: Reconcile voided transactions using a Cleared date in the same month as the Void date

Refer to article 22176 DocLink: How do I change the reconciliation status of a transaction in Cash Management?

As best practice, when reconciling your bank statements, be sure to reconcile any voided checks that were voided in that statement period.

Option II: Modify the formula in the Bank Reconciliation report

As a temporary workaround, you can modify the Register Balance Adjusted for Future Period Voids total on the Bank Reconciliation report as follows:

1. In Report Designer, from the File menu, select Open Design.
2. Browse to and select the CM Bank Reconciliation.rpt.
3. From the Tools menu, select Formulas.
4. Select TTL-Voided Amount.
5. Click Change and enter the formula as follows:
   • ASUM(Bank Account [CM Transaction], IF(Void Date [CM Transaction] > Statement Date [Prompt Field], Voided Amount [CM Transaction]))
6. Click OK then Close.
7. Select File, Save Design As, enter a modified name (for example: CM Bank Reconciliation_fix future voids.rpt)
8. Using Reports Manager in Cash Management, you can either add this report to your Report menu or change the existing menu to use this modified report. See article ID 18607 DocLink: How do I save, add, and print a report design? for more information.

The Register Balance Adjusted for Future Period Voids total now balances with the General Ledger cash account total for the same period end date as the statement date. The Register Balance as of Statement Date total does not change.