How to view bank account transactions

Step by Step Guide:

1. Navigate to ACCOUNTING > General Ledger > Bank Reconciliation.

2. Use the Filters to narrow down your search:

1. Bank Account No. - Select a bank account number from the drop-down box.
2. 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.
3. Transaction Number - Enter a specific cash transaction number or leave it blank to get a list of all transactions.
4. Payment Type - Leave blank or filter on a specific payment method defined by your agency, e.g., ACH.
5. 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. a. Un-Presented Only b. Presented Only c. Presented and Un-Presented
6. Transaction Date From, Transaction Date To - Start and end date of transaction.
7. Date Reconciled From, Date Reconciled To - Banking transaction date range.
8. Bank Statement Date - Date of the bank statement.
9. Bank Statement Balance - The balance according to the Bank Statement for an account at the date selected.
10. Unreconciled amount - The sum of items that have not been matched.
11. 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.

3. Click on the Layout button

Tip: Select which columns appear on the page, as well as determine the column and sort order. Click here to learn more.