Transactions are missing from my bank reconciliation

Check cash account

• Verify you’re running the bank reconciliation for the correct cash account.
• Verify the cash account on the missing transaction. Someone possibly posted the transaction to a different cash account.
  • If you posted the transaction to the incorrect cash account, move to the correct cash account.

Verify statement and reconciliation dates

1. Go to CM, Transactions, Reconcile Checking Account.
2. Enter the last day of the month you’re reconciling for both the statement and reconciliation dates. For example, if you're reconciling for June 2026 enter 06/30/2026 for both fields.
3. Make sure the statement and reconciliation dates are in the current year. It’s possible when the year changes, someone enters the new year instead of the old year.
   For example, reconciling December 2025 in January 2026 and mistakenly enter 12/31/2026 for the dates.  This is common. 

Transaction entered in archive company

• If you have an archive company, check the other company for the transaction. 
• If the transaction exists in the archive company:
  • Void the transaction in your archive company
  • Enter the transaction in your live company

Transaction posted in General Ledger

Transactions you post directly in General Ledger don't post back to your bank reconciliation. 

1. Go to GL, Reports, Account Detail Report.
2. Run the report for the month you’re reconciling.
3. The first column on the report is the module identification where the transaction originated.
4. If the transaction shows GEN then it didn't post to your bank reconciliation.
5. Go to CM, Transactions, Enter Bank Transactions.
6. Select the type of transaction, that is, charge, credit, etc.
7. Enter the transaction date, amount, and description.
8. Uncheck the check box to Post to G/L.
9. Post the transaction.

Verify customer deposits posted from Accounts Receivable (AR)

If deposits are missing, make sure you deposited into your bank reconciliation from Accounts Receivable.

Review the Bank Deposits Report in CM

1. Go to CM, Reports, Bank Deposits Report.
2. Select the cash account you're reconciling.
3. Choose the month you’re reconciling.
4. Print or preview the report.  
5. If the transaction isn't on the report, make sure you deposited from AR.
6. Go to AR, Transactions, Bank Deposits.
7. Select the cash account and the date of the customer payment.
8. If there's no diamond next to the receipt, you haven't deposited to the bank reconciliation. 
   • Select the receipt and post to your bank reconciliation with the deposit date.
9. If there’s a diamond next to the receipt, this means you've deposited to your bank reconciliation.
   • Check CM Bank Deposits to see if you deposited to a future month.
   • Go to CM, Reports, Bank Deposits Report.
   • Select the next month. For example, if you're reconciling June, select July.
   • Print or preview the report, then review the report to see if the deposit shows.
   • If it shows, this means you deposited in a different month. 
     • To keep the deposit with the future month date, make a pencil note on your bank reconciliation. It will clear the next month.
     • To correct the deposit date, void the deposit in CM, Transactions, Void Bank Transactions.
     • Then go to AR, Transactions, Bank Deposits and redeposit using the correct deposit date.

If the transaction is still missing

• Back up your company data files, then rebuild Cash Management.
  • On the Accounts Payable menu, go to Utilities, and click Rebuild AP Data Files.
  • The Accounts Payable rebuild will rebuild both AP and CM modules.

If the transaction is still missing after rebuild

• Locate transactions that you cleared for a different bank reconciliation date range.
  • On the Cash Management menu, go to Reports, and click Custom Reports.
  • Select the data source for transaction types (for example, CM Bank Deposits).
  • Select the fields that identify the transactions, and include the ReconDate field.
  • Generate the report for a TxnDate date range that includes the missing transactions.
  • Whatever date appears for the ReconDate, this is the bank reconciliation date you cleared it on.
    Transactions with 12/30/1899 or 01/01/1900 in the ReconDate column means you haven’t reconciled.
  • To 'unclear' the transaction, perform the following.
    • Change the bank reconciliation statement end date to the date noted on the customized report (created above).
    • Clear the selections for those transactions.
    • Close and then regenerate the bank reconciliation for the current statement period. The transactions list as unreconciled.
• If you can't find the transaction after going through all the steps above.
  • Enter the bank transaction through CM, Transaction, Enter Bank Transactions and deselect the Post to GL option.

How to determine if an end of month close failed
Month-end close or data rebuild doesn’t finish successfully
How the reconciliation and statement dates affect the bank reconciliation