Use this query to list entries that were cleared on previous bank reconciliations, and to find entries that do not appear on the 1-5 Bank Reconciliation.
To construct a query to find transaction status changes:
Open 1-3 Journal Transactions.
Select File > Find to display the list of available queries.
In the Query List window, select Open Ledger Transactions—by Period, and then click Edit.
In the upper left area of the Display Fields window, click Ledger Transaction Lines.
That action selects the table from which you can pick fields for the query.
Under Fields, double-click the following fields to select them for display:
The new fields appear with the original fields under Fields to Display. If you select an incorrect field, click the field under Fields to Display, and press the Delete key. Then click Next to accept your changes in the Display Fields window.
To run the query:
Note: You can use this query to reconcile previous bank statements again and to look for journal transactions in the query results that are not on the bank statements. If you discover a transaction on the bank statement that is not in the query results, the transaction status has been changed from 2-Cleared to 1-Open or 3-Void.