Learn more

About saving trial reconciliations

Saving trial reconciliations

Clearing trial reconciliations

Creating a query for finding transaction status changes made in 1-3 Journal Transactions

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:

  1. Open 1-3 Journal Transactions.

  2. Select File > Find to display the list of available queries.

  3. In the Query List window, select Open Ledger Transactions—by Period, and then click Edit.

  4. 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.

  5. Under Fields, double-click the following fields to select them for display:

    • lgtnln.lgract Account
    • lgtnln.dbtamt Debit Amount
    • lgtnln.crdamt Credit Amount

    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.

  6. Click Next through the Group Fields and Sort Fields windows.
  7. In the Selection Fields window, double-click the lgtnln.lgract Account field. It will be added to the list of fields under Fields to Select By.
  8. Click Next to display the Selection Criteria window, and then click Next again to return to the Query List 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.

  1. In the Query List, click the Open Ledger Transactions—by Period query, and then click Run.
  2. In the Selection Criteria window:
    1. Leave the Period, Record#, and Source fields blank.
    2. In the Status field, type 2 to display Cleared transactions.
    3. In the Account field, enter the cash account you want to reconcile.
    4. Click Run to display the transactions within the selection criteria. These results can be printed or exported.
  3. Click File > Print to print the information, or click File > Save As to export the information.