Report of Transactions Posted

Generate a report of the transactions posted against any or all of the client accounts.

Avatar CFMS > Banking Reports > Report of Transactions Posted

• The report covers open accounts and those accounts that were closed within the selected date range.
• The report can be on any combination of transaction codes for a user-assigned date range.
• The requested report can be either a summary or detailed report.

This report displays fields from several forms.

1. In the Start Date field, enter the start date of the reporting range.
2. In the End Date field, enter the end date of the reporting range.
3. In the Individual Or All Or Grouped Codes field:
   • Select Individual to include only specific codes.
   • Select All to include all codes.
   • Select Group to include specific types of codes.
4. In the Group Of Codes field, check the desired code types.
5. In the Transaction Codes field, select the codes to include in the report. All client banking transaction codes are included in this list. Transaction codes are created in the Add or Edit Transaction Codes form.
6. In the Individual or All Clients field:
   • Select All to generate a report on all of the client accounts.
   • Select Individual to generate a report on a single client account.
7. In the Client ID field, enter the client name or ID number. Select a client from the list.
8. In the Summary or Detail field:
   • Select Detail to view all of the transactions posted under the selected code or codes. The detailed report includes the summary information.
   • Select Summary to view only the transaction code and system totals for the selected date range.
9. In the Only Include Clients Currently Active In Selected Programs field:
   • Select Yes to limit the report data to only active clients.
   • Select No to include all clients.
10. In the Programs field, select which programs to include in the report.
11. Click Process.
    In addition to the summary totals and totals by transaction code, this report contains the following information:

• Client Name
• Account Number
• Date Of Transaction
• Transaction Code
• Dollar Amount - Where CR=Credit, Db=Debit, CRH=Hold, DBH=Hold Release
• Description - As entered in the description field of the posting form.
• Check # / Receipt # / Withdrawal # - This column contains three different pieces of information:
  • Check # - If the number displays before the slashes it is the check number as entered at the time of posting. Check numbers are associated with debits to the account.
  • Receipt # - If the number displays between two slashes it is the receipt number as entered at the time of posting. Receipt numbers are associated with credits to the account.
  • Withdrawal # - If the number displays after two slashes it is the withdrawal number as entered at the time of posting. Withdrawal numbers are associated with debits to the account. The Withdrawal number is linked to the Require Withdrawal Number Field if Debit is Greater Than field of the Set Banking System Defaults form. It is required when the debit transaction is at or above the limit set in that field.