The bank reconciliation is missing transactions

Summary

There are various reasons why transactions are missing in your bank reconciliation in Sage 50 Accounting. Review the options below to troubleshoot and resolve the missing transactions.

Resolution

Verify selections in the Reconciliation & Deposit window 

  1. Select Banking, Reconcile Accounts.
  2. Ensure you’ve selected the correct account.
  3. The Statement Start Date must match your bank statement start date.
     NOTE: You can't change the start date if you've reconciled previously.
  4. The Statement End Date matches your bank statement end date and differs from the Statement Start Date.
    Statement End Date must be different than the Start Date in the Reconciliation & Deposits window.

Missing transactions after performing reset for bank reconciliation

Restore backup before the reset into a new company

  1. Keep the original company open and open a new instance of Sage 50.
  2. Restore the backup made before a reset of the bank reconciliation into a new company.

Locate missing transactions

  1. Once the company is open, select Reports, Banking, Account Reconciliation Report.
  2. Use Report type: Summary report with Outstanding transaction detail.
  3. Select the bank account.Fo
  4. Set the Start date and Finish date to the Statement End date of the previous reconciled period.
    For example, if reconciling January 1 to January 31, use December 31 as the Start and Finish Dates for the Report. 
  5. Click OK to view the report, then select Print or Open in Excel to save this report.

Add missing transactions in the original company

  1. Select Banking, Reconcile Accounts in the original company.
  2. Select the Account, then select the Add Prior Outstanding button.
  3. Use the report to add the transactions.
  4. Select the transactions before the date window or inserting all outstanding transactions and click OK.
  5. Verify missing transactions are present.
  6. Discard the restored company and continue using your original company. 

Verify the General Ledger report has the correct transaction accounts

  1. Select Reports, Transaction Details or Journal Entries, All.
  2. Select the correct year.
  3. Select Date for Report By.
  4. Enter the correct Start Date and Finish Date.
  5. Select the Corrections checkbox under Show.
  6. Select OK.
  7. Verify the accounts to the transactions.
     NOTE: If the transaction doesn't affect the AP or AR account, adjust the transaction to Cash or Cheque. Or use the Receipt or Payment module.

Transactions posted while doing bank reconciliation

  1. In the Account Reconciliation window, click the Save button.
  2. Close the Reconciliation & Deposits window.
  3. Open the Reconciliation & Deposits window again.
  4. Verify the transactions are now showing.

Verify the account transactions for this period

  1. Go to Reports, Financials, Transactions by Account/General Ledger.
  2. Select the account.
  3. Set the Start and Finish dates to be the same as your bank reconciliation.
  4. Add a checkmark to Corrections.
  5. Select OK.
  6. If transactions show on the report, then run the Advanced Database Check.
    • When running the General Ledger report, set the Finish date to the Latest Transaction Date found in Setup, Settings, Company, Information
  7. If the report shows no transactions, then this company file has no transactions for the selected period.
    • Check if you entered the transactions on the wrong date, in the wrong company, or if you entered them at all



Need more help?

Chat now



 

 

 

 

 

Related Solutions

 How do I reset the bank reconciliation?

Solution Properties

Solution ID
221924850013203
Last Modified Date
Mon Jun 23 20:40:08 UTC 2025
Attributes
Product Details
Integrated Product: Blueprints
Views
0