Skip to content
logo Knowledgebase

Find unreconciled bank transactions

Created on  | Last modified on 

Summary

How to produce the Unreconciled Bank Transactions report in Sage Accounting.

Description

This report shows all bank transactions, which aren't reconciled at the date specified. This is helpful when reviewing past reconciliations. It shows missed transactions entered after reconciling but dated in the prior period.

Resolution

Produce the report

The report shows all unreconciled transactions up to the current date.

To search for a particular transaction, enter the reference or the value of the transaction in the search box.

  1. Go to Reports, then select All reports.
  2. Choose Unreconciled Bank Transactions.
  3. Enter the date you want to run the report up to.
  4. Choose the bank account you want to view the unreconciled transactions for. We'll show the bank balance and reconciled balance up to that date. The difference between these amounts is the total of your unreconciled transactions.
  5. Select a transaction to view the details. Select Back on your browser menu bar to return to the report.
  6. To save or print the report, from the Export menu, and then select CSV or PDF.
  • CSV – Depending on your Internet browser, the file automatically downloads to your Downloads folder. If prompted to Save the file, browse to where you want to save the file. Select Save
  • PDF – The PDF opens in a new window or tab. Open your browser’s File menu then choose to print or save the report

Find reconciled and unreconciled transactions for a certain date

Sometimes you need to see a list of both reconciled and unreconciled bank transactions at a given date. This is a common request when if audited, for example.

To do this, run the unreconciled transactions report and a list of reconciled transactions. Do this from the Reconciliations page for the bank for the same date range.

Find a list of reconciled transactions

From the Reconciliations page:

  1. From Banking, open the required bank account.
  2. Select Reconciliations.
  3. Open the reconciliation you want to view.
  4. Choose Print.

Once you've located the transactions, you can action your reconciliation.

Follow our article on how to reconcile your bank account.