Skip to content
logo Knowledgebase

Why don't transactions appear in the bank reconciliation window?

Created on  | Last modified on 

Summary

Check why a transaction doesn't appear in the Bank Reconciliation window in Sage 50 Accounts.

Description

There may be times when a transaction you'd expect to find in the bank reconciliation window, doesn't appear. Let's look at why.

Resolution

Common reasons for missing transactions

When you can't find a transaction in the Bank Reconcile window this is due to the following reasons:

  • Date - The transaction date doesn't match the reconciliation period
  • Wrong bank - The transaction is entered against the wrong bank account
  • Transaction type - The transaction is not a bank transaction
  • Grouped transactions - The transaction is grouped with other transactions. Find out more in our handy guide on Bank transaction grouping
  • Reconciled already - The transaction is already reconciled

Don't worry, this is normally easily resolved by following the steps below.


Why your transaction doesn't show

To identify why a transaction doesn't appear in the Bank Reconciliation window, in Transactions locate the transaction(s) that should be appearing, then check the following columns:

  • Type - Ensure it's a bank transaction. Only bank transactions appear in the Bank Reconciliation window

    EXAMPLE: BR, BP, CR, CP, VR, VP, SR, SA, SP, PP, PA, PR, JC or JD

  • Account / Nominal - Ensure it's the correct bank account. The bank reference appears in either of these columns, depending on the transaction type. The Bank Reconciliation window only displays transactions for the selected bank. If a transaction is posted to the wrong bank account, use our Correct transactions guide to edit the transaction to the correct one
    Image

  • Date - The date of the transaction should be on or prior to the reconciliation date. If the date of the transaction is wrong, use our Correct transactions guide to edit the transaction date

  • Amount Paid - If the date and reference are the same as other bank transactions, then the transactions may be grouped together in the bank reconciliation window . If the transaction is grouped, only the total value of the grouped transactions appears in the Bank Reconciliation window and this won't be the same as the Amount Paid column in the transactions or financials window. Find out more in our handy guide on Bank transaction grouping

  • Bank - Check the reconciliation status in the Bank column 

     The Bank column may display one of the following:
    Bank columnDescription
    RThe transaction has already been reconciled.
    NThe transaction hasn't yet been reconciled.
    - (dash)

    The transaction isn't applicable for bank reconciliation.


    To appear in the Bank Reconciliation window, the transaction should be N, as only transactions that have not been reconciled appear in the Bank Reconciliation window. 

    If the transaction shows R or '-', this is why it isn't showing.

Next steps

If the transactions still don't appear after checking the reasons above, you may have corruption in your data. To check this:

  • Click File then click Maintenance then click Check Data

If there are any errors, to correct them please visit www.sage.co.uk/mydata