Checks are missing from the bank reconciliation and check register

Solution Properties

Solution ID:

222924550020994

Last Modified Date:

Mon Apr 28 14:26:02 UTC 2025

Taxonomy Path:

Category//Data//Data management

Author:

sageadmin

Checks are missing from the bank reconciliation and check register

Description

Cause

Resolution

See How to determine if an end of month close failed for further information
If the system detects a failed month-end close, you'll want to restore a backup before the failed close

Open CM, Reports, Check Register
For Cash account, check All cash accounts
- Verify the check posted to the correct cash account
- Verify the checks posted to General Ledger
  - Open GL, Reports, Journal Detail Report
  - Run the report for the date that the checks were posted
  - Verify the check posted to the correct general ledger cash account
If you posted the check to the incorrect cash account, you’ll need to void and reenter the check for the correct cash account

On the Reconcile Cash Account screen, select Reconciliation Summary
If n/a appears for Adjusted bank balance, you have an item cleared with a future reconciliation date than the current reconciliation date
Change your reconciliation date, then clear the item and re-reconcile. For more information, see N/A displays for adjusted bank balance in reconciliation summary

Check months to keep history in CM, Utilities, Display C/M Status
Reconciled checks will purge from the system based on the reconciliation date and history retained. if you're keeping 24 months history, a check with a reconciliation date of 12/31/2023 will purge from the system when you close December 2025
If you don't select reconciled checks in CM, Utilities, Maintain C/M Parameters, checks will purge based on check date and history retained. For example, if the check date is 12/01/2023, the check will purge when you close December 2025
It's important to make sure you print the completed reconciliation report before closing

Back up the data files from the File, Backup
Open AP, Utilities, Rebuild Data Files
Rebuild the files
If the rebuild doesn’t resolve the issue, recreate and post the checks normally
You can recreate the checks in Instant Checks without posting to General Ledger
1. Open CM, Transactions, Instant Checks.
2. Recreate the checks.
3. Clear the Post to G/L check box to avoid posting to General Ledger.
4. If the checks are missing from the bank reconciliation, Check Register and General Ledger.

[BCB:163:Chat BusinessWorks US:ECB]

Steps to duplicate