Fixing Missing Reconciled Transactions in Check Reconciliation

🟢 Audience: Training

Quick Summary:

“If reconciled transactions aren’t appearing in the Check Reconciliation screen, adjust the batch dates temporarily to display and reverse them, then restore the correct date range.”

---

🔹 Issue Example

• Scenario: July transactions were reconciled in Batch 10 (10/1–10/31) by mistake.

• Problem: Debit memos don’t display when trying to reverse them.

---

🔹 Steps to Resolve

1. Run the “Only Reconciled Transactions” Report:

   • This report lists all transactions reconciled in the selected batch.

   • Note the dates of the incorrectly reconciled debit memos.

---

2. Adjust Batch Dates:

   • Go to Setup → Reconciliation.

   • Select Batch 10 in the grid.

   • Change the Start Date to cover the dates of the transactions in question (e.g., 6/29).

   • Click Save.

---

3. View and Reverse Transactions:

   • Search the batch again.

   • Select View Only Reconciled Transactions.

   • The transactions will now appear.

   • Reverse them so they can be reconciled in the correct batch.

---

4. Restore Batch Dates:

   • Reset Batch 10’s date range back to its original 10/1–10/31.

   • Save your changes.

---

📝 Tip:

• Always run the Only Reconciled Transactions report first to confirm which memos were incorrectly reconciled.

• Adjusting the date range temporarily is a safe way to surface and correct reconciliation mistakes.