What is the Bank Transaction Report and how can I customize it?


This report is designed to show you all transactions (checks, deposits, etc.) that have been posted to your bank account(s). There are several options available to customize the report.

  1. To access the report: From the Checkbook screen, click on Reports and then Bank Transaction Report.
  2. To customize the report:
    1. Specify the Sort Order: This report can be sorted by any column on the report (Type, Date, Payee, etc). Find the Sort Order box at the top of the side bar. The report will be ordered by the criteria listed first in the box (example: Date). To change the sort order:
      1. Double click on any column heading to sort the report by that column first.
      2. Highlight any option in the Sort order box (i.e. Payee).
      3. Click the Up or Down arrow button to move the option.
      4. Double click the words "Sort Order" to reverse the sorting direction (i.e. payee would be listed in reverse alphabetical order).
    2. Specify the Date Range: Click on either the start or end date to change the date range. Choose the date you want to use from the calendar and click OK. To set the range to the entire fiscal year, double click on the words "Date Range."
    3. Specify Reconciled option: If you would like to see only reconciled or only unreconciled transactions, check the corresponding box just below the bank account selection box.
    4. Specify Payee: To see only those transactions with a specific payee, choose the payee from the payee box. Employees from payroll will be listed as "Last Name, First Name".
    5. Specify Transaction Type: To view only a certain type of transaction (i.e. Deposit), choose the transaction type from the drop down menu.
    6. Hide Columns: Check the "Hide Reconicled Col." or "Hide Balance Column" to remove these columns from the report. (Only available on NTS version 5.70 and above.)
    7. View/Hide Transaction Detail: Click the "Hide Transaction Detail >>" button on the left side of the screen. The detail box will no longer be visible and the detail will NOT print out if you print the report. Click the button again to view the detail.
  3. To print the report: Click the Print button in the top left corner of the report screen.
  4. To export the report: See Export Reports for instructions.
Report options