How do I view and customize the Transaction Detail Report?


This report allows you see a listing of every line of detail for every transaction posted to the checkbook. There are several options that will allow you to customize the report. This can be used to search for a certain transaction or to view only those transactions that meet specific criteria. After changing any the available options, the report will automatically update. Multiple options/filters can be selected.

  1. To access the report, go to the Checkbook screen, click on Reports and then Transaction Detail report.
  2. Set any filters necessary:
    Sort Order: You can sort the transactions based on any of the columns in the report. In the example below, the transactions are sorted first by Fiscal Year and then by date, etc. If you want to sort the list by Amount first instead, click on amount and then click the up arrow button to move Amount to the top of the list. You can sort the list in reverse order by double clicking on the words Sort Order.
    Date Range and Fiscal Year(s): You can select any date range you need. Click on either the start date or end date to change the date range. If your date range crosses a fiscal year boundary (includes dates from more than one fiscal year), you must change the Fiscal Year range to correspond to the dates selected. Move your mouse over either the start or end fiscal year. Two small arrow buttons will appear. Click the up or down button to change the fiscal year range and then click OK on the Change Fiscal Year confirmation box.
    Bank Accounts: To see transactions from only one specific bank account, choose the account from the Bank Account selection box.
    Transaction Type: To see only one type of transaction, choose the transaction type from the Transaction type selection box. There are also a few special filters such as Checks + E-Checks. This option will show all checks both Check and E-Checks. If you select Checks, only checks will be on the report. E-Checks will be excluded.
    Payee: To see transactions for a specific payee, select the payee's name in the payee box. You can select more than one payee by pressing the Control (CTRL) key and then clicking on each payee you want to include. You can also select a group of payees by clicking on one payee, press the shift key, and then click on the last payee you want to include. All payees between the two payees selected will be highlighted and included on the report.
    Expense Category, Group and Account: You can select a specific Expense Category, Group or account. Before selecting a specific expense account, you must first select the appropriate category and group, just like when posting a check. If you only select a category, only transactions in that category will be on the report.
    Internal Category and Account: This filter is just like the expense filters.
    Amount: Use this filter to see only those transactions that fall within the specified amounts. To see transactions more than a specific amount, type in the amount in the first amount box. To see transactions less than a specific amount, type in the amount in the second amount box. You can specify both an upper and lower end. Remember, that checks will be negative amounts.
    Comment: You can specify a specific comment. Type in the first few letters or word of a comment. You can also type in an entire comment. Only comments that begin with what you have specified will be on the report. This filter is NOT case sensitive.
    Show Option: Next to each option/filter is a "Show" Option. You can hide a specific column on the report by un-checking the Show box. For more information, please see the links below.
    Font Size: To change the size of the font on the screen, click the up or down arrow button at the top of the report screen with the RIGHT mouse button. This does not affect the size of the font on the printed report.
  3. To print the report, click the print button at the top of the screen. See the link below if your report printout is too small to read.
  4. To export the report, see Export Reports for instructions.
  5. To obtain totals for the various fields, see Transaction Detail Report totals instructions.
Report Filters