Solution Properties
Solution ID:
220924160100890
Last Modified Date:
Wed Mar 19 18:43:05 UTC 2025
Taxonomy Path:
Category//Transactions
Author:
[email protected]
How does the check void date affect the Bank Reconciliation?
Description
Cause
Resolution

Void date is in a month after the check date

DATE               ACTION                                                                      
06/30/2024 Check #123 posted using the 06/30/2024 date
07/01/2024 Check #123 voided using the 07/01/2024 date
06/30/2024 Bank reconciliation uses the 06/30/2024 date

 

 ▼ How the void date affects the bank reconciliation
  • Voiding a check removes it from the bank reconciliation
  • The general ledger uses the check date and void date to post the journal entry

In the example above, the bank reconciliation will be off with the general ledger by $100.00 

  • In June 2024, the system posts the check to the general ledger and bank reconciliation. Bank reconciliation agrees to GL
    image showing bank reconciliation with check before void.       Image showing reconciliation summary balancing before void of check.

  • After the void, the bank reconciliation for June 2024 doesn't include the original check
    Image of bank reconciliation screen with check missing after void.      
  • The general ledger doesn't know about the void until July 2024, causing a discrepancy 
    Image of reconciliation summary with discrepancy.

 ▼ To reconcile your bank statement

Option 1: Make a pencil note

  • Make a pencil note regarding the issue, noting that the issue will clear itself in the following month.

Option 2:  Paper audit trail of the transaction

Post a bank transaction to represent the original check

  1. Select CM, Transactions, Enter Bank Transactions.
  2. For Transaction Type, select Charge.
  3. Enter the Amount of the original check.
  4. Enter a Description that’s easy to identify.
  5. Use the Date of the original check.
  6. UNCHECK the Post to GL checkbox.
  7. Post.

Post a bank transaction to represent the void 

  1. Select CM, Transactions, Enter Bank Transactions.
  2. For Transaction Type select Credit.
  3. Enter the Amount of the original check.
  4. Enter a Description that’s easy to identify. 
  5. Use the Date of the VOID.
  6. UNCHECK the Post to GL.
  7. Select Post.

Clear the transactions in your bank reconciliation

  1. In the June bank reconciliation, DO NOT clear the charge. Your bank reconciliation will still be in balance with your bank and will also balance to GL.
  2. In the July bank reconciliation, CLEAR both the charge and the credit together. This will offset the check and void to stay in balance.
[BCB:163:Chat BusinessWorks US:ECB]
Steps to duplicate
Related Solutions