General Ledger

How to view bank account transactions

View bank account transactions to track spending, identify unauthorized activity, manage your budget, and maintain accurate financial records.

Steps: 

  1. Navigate to ACCOUNTING > General Ledger > Bank Reconciliation. 
  2. Use the Filters to narrow down your search.
    Medium KB -Jul-26-2023-03-46-22-1696-PM

    Search Filter  Description
    Bank Account No.  Select a bank account number from the drop-down box. 
    Transaction Type  Leave blank to get a list of all transaction types or select from the list of transactions for the bank account, e.g., Receipts or Payments. 
    Transaction Number  Enter a specific cash transaction number or leave it blank to get a list of all transactions. 
    Payment Type 

    Leave blank or filter on a specific payment method defined by your agency, e.g., ACH.

    Show

    By default, the Bank Reconciliation Form only displays a listing of Un-Presented. Transactions (payments or receipts that have not yet been marked as having appeared on a bank statement).

    Choose whether to show unreconciled (Un-Presented), reconciled (Presented) GL transactions or both. 

    • Un-Presented Only 
    • Presented Only 
    • Presented and Un-Presented

    Transaction Date From 

    Transaction Date To 

    Start and end date of transaction. 

    Date Presented From 

    Date Presented To 

    Banking transaction date range. 

    Bank Statement Date 

    Date of the bank statement.

    Bank Statement Balance 

    The balance according to the Bank                    Statement for an account at the date selected. 

    Unreconciled amount

    The sum of items that have not been matched. 

    Lock to Date 

    Once a bank reconciliation is reconciled, users can lock it to prevent any changes from being made to that date and prior. 

Click on the Columns button to select which columns appear on the page, as well as determine the column and sort order.  Click here to learn more.