Skip to content
logo Knowledgebase

Transactions missing from the bank reconciliation window

Created on  | Last modified on 

Summary

How to check why transactions don't appear in the Bank Reconciliation window in Sage 50 Accounts.

Description

If you can't find a transaction in the bank reconciliation window, there are a few things that cause this:

  • The transaction date doesn't match the reconciliation period
  • You used a different bank account for the transaction
  • The transaction isn’t a bank transaction
  • The transaction is grouped
  • The transaction is already reconciled
  • It's a foreign bank revaluation journal created when you completed the Foreign Bank revaluation wizard 
  • Data corruption

 

Resolution

To find out why your transaction doesn't appear:

Check your transaction information

  1. Go to Transactions and locate the transaction.
  2. Check the Type column and make sure it's a bank transaction. 
  3. Check that the Account or Nominal column displays the bank account you're reconciling. 
  4. Make sure the Date column shows a date on or before the reconciliation date. 
  5. Check whether the Bank column displays N.
  6. When you reconcile the transaction, the system displays 'R'.
  7. If it doesn't apply for reconciliation, it shows a hyphen.  

Use our article to correct your transaction if it's incorrect. 

Check for grouped transactions

If you entered the transaction at the same time as others, the program groups transactions together.

Use our article to check whether the program grouped the transaction. 

Check for data corruption

If the transactions still don't appear, check for corruption in your data. 

  1. Go to File, select Maintenance then Check Data.
  2. Use our A-Z of check data errors to resolve any errors that appear. 

Reset the SAGE.INI file

Use our article for help with resetting your SAGE.INI file.