Detailed Account Ledger

Generate the CFMS Account Ledger for a single client account or all client accounts in the system.

Avatar CFMS > Banking Reports > Detailed Account Ledger

Select All Clients to generate the detailed account ledgers for all clients and accounts for the selected date range.
Select Individual Client to generate the detailed account ledger for the client selected in the Client ID field. When an individual client is selected, the account ledger is generated for a single selected account (open or closed).

In the Start Date field, enter the start date of the reporting range.
In the End Date field, enter the end date of the reporting range.
In the Client ID field, enter the client name or ID number. Select a client from the list.
In the Account Number field, select the account number. The list consists of all of the open and closed account numbers assigned to the selected client in the Client ID field.
Click Process to generate the report.
This report starts with a beginning balance and amount of hold. These are the amount of money in the account and the amount on hold (Hard and Soft) prior to the selected date range. It also contains the following information:

Client Name and ID (STAT)#
Account Number
Current Hard Holds - Funds reserved in hard hold account
Current Soft Holds - Funds reserved in soft hold account
Current Account Balance - Total balance for selected account
Date Of Transaction
Dollar Amount
CR DB - CR=Credit, Db=Debit, CRH=Hold, DBH=Hold Release
Transaction Code
Description - As entered in the description field of the posting form
Balance - Available balance after the transaction
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.