Revised 12/6/2010
EOM Reports & Checklist
E nd o f M o nt h Re p o r t i ng & Ch ec kli st
DMS Solutions™
Page 1 of 9
Revised 12/6/2010
EOM Reports & Checklist
Table of Contents Table of Contents ....................................................................................................................................... 2 Crystal Reports Version in Use.................................................................................................................. 3 “As Needed” Reports Can Be Viewed/Printed at Any Time .................................................................... 3 Report Viewer ............................................................................................................................................. 3 Report Parameters & Report Viewer Tabs ................................................................................................ 4 Trust Account (Required) .......................................................................................................................... 5 Trust Account (As Needed) ........................................................................................................................ 5 Accounts Receivable (Required)................................................................................................................ 6 Accounts Receivable (As Needed) ............................................................................................................. 6 Counseling Fees (Required) ...................................................................................................................... 6 Debt Management (Required) ................................................................................................................... 7 Debt Management (As Needed) ................................................................................................................. 7 Creditors (As Needed) ................................................................................................................................ 8 US Bankruptcy Counseling (Required) .................................................................................................... 8 US Bankruptcy Counseling (As Needed) .................................................................................................. 8 Appointments (Required) ........................................................................................................................... 9 Appointments (As Needed) ........................................................................................................................ 9
DMS Solutions™
Page 2 of 9
Revised 12/6/2010
EOM Reports & Checklist
Crystal Reports Version in Use It should be noted that all DMS Solutions™ reports have been created using the Developer’s Version of Crystal Reports version 8.0 or later. Agencies may run these reports without purchasing Crystal Reports. If you desire to copy & modify an existing CPR report, or create brand new reports though, you must purchase a Developer’s Version of Crystal Reports. CPR staff will also be available to make modifications and create new reports at no additional cost to your agency.
“As Needed” Reports Can Be Viewed/Printed at Any Time There will be a large number of reports that were required printing in DMS Core that will not be required printing in DMS Solutions™. This is due to the fact that we are not purging data files like in DMS Core. If you feel more comfortable printing these optional listings now, this is fine! Remember that you will be able to view/print them later as needed.
Report Viewer All EOM reports are located in the Report Viewer icon (circled above) at the top of DMS Solutions. It has a red background with a white letter R. All Crystal Report templates must be stored in a “CrystalRPT” folder which resides in another shared folder called “DMS Templates” on your main agency’s server. When this folder is opened, currently 11 report folders listed. See screen shot below.
DMS Solutions™
Page 3 of 9
Revised 12/6/2010
EOM Reports & Checklist
It should be noted that as CPR releases new reports and modifies existing reports, these templates will be released to all agencies on the new DMS Solutions™ release.
Over time, many agencies will have developed customized reports which will reside in an agencyspecific report folder.
Report Parameters & Report Viewer Tabs Each Crystal Report consists of 2 tabs, Report Viewer and Report Parameters. Report Parameters is used to key parameters that will be used for selection or sorting of the report. Common parameter input fields would be date ranges, choose sorting orders, certain code descriptions to find, special messages to appear on the report, etc.
DMS Solutions™
Page 4 of 9
Revised 12/6/2010
EOM Reports & Checklist
Trust Account (Required) Folder
Template Name
Accounting
Client Balance.rpt
Accounting
Trust Account Detail.rpt
Accounting EOM
Possible Report Parameters
Sorting
Quick Balance.rpt
Show inactive client Show active clients Show accounts with positive balance Show accounts with negative balance Show accounts with zero balance (in Trust) Beginning & ending date range All transaction types Ending date to report through
By location then by counselor ID
N/A
Transaction Summary.rpt
Beginning & ending transaction date
N/A
N/A
Trust Account (As Needed) Folder
Template Name
Accounting
Deposit Detail Report.rpt
Accounting
Creditor Refunds.rpt
Accounting
Creditor Voids.rpt
Accounting
Client Refunds.rpt
Accounting
Client Refund Checks Voided.rpt
Disbursements
Client Overage.rpt
Disbursements
Client Shortage.rpt
Accounting
DISBUnequal.rpt
Accounting
Reconciliation.rpt *Reconciliation of Trust checks may not coincide with EOM reporting so it can be pulled from this checklist.
DMS Solutions™
Possible Report Parameters Specific batch ID or all Posted, unposted or all Transaction date range Transaction date range Posted, unposted or all Transaction date range Posted, unposted or all Transaction date range Posted, unposted or all Transaction date range
On or before client start date Choose a counselor name or ALL Choose a location name or ALL Choose a counselor name or ALL “Exclude clients with no deposit” option “Please select a Counselor” Specific bank account Transaction date range Reconciled or unreconciled checks
Sorting By By By By
client ID client name sequence # sequence number
By sequence number By Trust check number By client ID By check amount By check date By check number
By client ID By counselor name, then by Client ID By check date By check number By payee ID By payee name By clear date
Page 5 of 9
Revised 12/6/2010
EOM Reports & Checklist
Accounts Receivable (Required) Folder
A/R
Template Name
Possible Report Parameters Transaction date range
A/R
Cash Receipts By Location By Counselor.rpt Adjustments.rpt
A/R
Summary Aging.rpt
A/R
Invoice Report.rpt
Single invoice cycle or all cycles Aging date Invoice date range ALL cycles ALL (posted, unposted) Sort by invoice number Y-Include details
Transaction date range
Sorting By Location, then by Counselor Name N/A Creditor name Creditor ID By invoice number, by invoice date, by creditor ID, by print date
Accounts Receivable (As Needed) Folder
Template Name
A/R
Detail Aging.rpt
A/R
Invoice Report By Category.rpt
A/R
Billed Contributions by Satellite.rpt
Possible Report Parameters Specific batch ID or all Posted, unposted or all Transaction date range Invoice date range Invoice cycle Printed/Unprinted/All Sorting (see next box) Include Details Y/N Invoice date range
Sorting By creditor name By creditor ID By By By By
invoice number invoice date Creditor ID Print Date
N/A
Counseling Fees (Required) Folder
A/R
Bankruptcy
A/R Appointments
DMS Solutions™
Template Name
Possible Report Parameters
Client Invoice Detail Aging.rpt Client Invoice Summary Aging.rpt Client Invoices by Location.rpt
Aging Date (defaults to today)
Bankruptcy Appointment Counseling Client Invoices by Location.rpt
Invoice date range ALL or specific location name All or specific counselor name All or specific service types Invoice type
Aging Date (defaults to today) Invoice date range ALL or specific location name All or specific counselor name All or specific service types
Sorting By client name By client number By client name By client number By counselor name By service type description By location name By counselor name By service type description
Page 6 of 9
Revised 12/6/2010
EOM Reports & Checklist
Debt Management (Required) Folder
Template Name
Report Parameters
EOM
Drop Reason.rpt
Drop date range
DMP Clients
Discontinued Report.rpt
DMP Clients
Discontinued Clients Statistical.rpt
Select ALL drop statuses or a single drop status Drop date range Drop date range
DMP Clients
Demographic Statistics.rpt
Counselors
New DMPs By Case Counselor.rpt
Counselor
Counselor Activity Historical by Location.rpt Contribution & Fees by Satellite.rpt
Accounting EOM EOM
Active Clients Debt & Balance Analysis by Dollar Range.rpt Active Clients Debt & Balance Analysis by Months on DMP.rpt
Ending date Select ALL locations or a single location Select All Counselors or a single counselor Select a status code Client start date range Date range Counselor name or all Activity Date Range Choose “Billed” or “Received” N/A N/A
Sorting By By By By
client ID client first name client last name Counselor Name
By Client ID By Client name By location By location by counselor name By location by debt ranges By location by months on DMP
Debt Management (As Needed) Folder
Template Name
Counselor
Counselor Activity Historical.rpt
DMP Clients
Dropped Clients Debt & Balance Analysis by Months on DMP
EOM
Branch Activity
Accounting
Summary Operating/Trust Account Statistical.rpt Disbursements, Contributions & Fees by Satellite.rpt
Disbursements
DMS Solutions™
Report Parameters Date range Counselor name or all N/A Date range Single or all locations Single or all counselors Transaction date range Transaction date range
Sorting By Location Name, then by Counselor Name By Location Name then by Counselor Name
By Location
Page 7 of 9
Revised 12/6/2010
EOM Reports & Checklist
Creditors (As Needed)
Creditor
Category Masterfile Listing.rpt
N/A
By category code
Creditor
Creditor YTD Totals by Status.rpt
N/A
By BDN status
Creditor
Creditor Contribution.rpt
Transaction date range Sorting order Ascending or descending
By BDN status By creditor ID By creditor name By YTD disbursements By YTD contributions requested By YTD fairshare requested By active clients By YTD contributions received By YTD contributions received By Total Owed
EOM
Creditor Fairshare Summary.rpt
Transaction date range
By BDN status
US Bankruptcy Counseling (Required)
Bankruptcy Bankruptcy
Bankruptcy Certificate Report.rpt Bankruptcy Certificate Plus.rpt
Choose an appt date range Choose Choose Choose Choose
an appt date range all or individual locations all or individual counselor names all or individual service types
By By By By
Location Counselor Interview Method Service Type
US Bankruptcy Counseling (As Needed)
Bankruptcy
DMS Solutions™
Bankruptcy Lawyer Fees.rpt
Choose ALL lawyers or specific lawyer Choose an appt date range Check ‘Include paid items’ if fees that were paid are to be included
Page 8 of 9
Revised 12/6/2010
EOM Reports & Checklist
Appointments (Required) Folder
Appointments Appointments Appointments Appointments Appointments Appointments
Template Name Pending Appointment List by Location Appointment Summary Report.rpt Referral Spreadsheet.rpt Appointment Demographic Report for Counseled.rpt Appointment DMP Results Not Opened.rpt DMP FCO Listing.rpt
Possible Report Parameters
Sorting
Choose an appointment date range
By location
Date range to process
By location by counselor By referral code by month
Ending date to process Choose an appointment date range Choose a result date range Appointment date range
By result code by client ID
Appointments (As Needed) Folder
Appointments
Appointments
Appointments
Template Name Appointments Never Filled by Date.rpt Workshop Report.rpt
Possible Report Parameters
Sorting
Choose an appt date range Workshop date range
By workshop
Appointment Show Report.rpt
Appointment date range
Appointments
No Show Report.rpt
Appointments
Appointment Counts by State and County
Appointment Appointment
Appointment Results by Counselor.rpt Appointment Results
Appointments
Community Spreadsheet.rpt
Single location or all locations Appointment date range Appointment date range Client Details YES/NO drop down Select state to report Check if you wish Counseled only Choose an appointment date range Single or all result codes Appointment date range Single or all result codes Ending date to process
By appointment date & time By location by appointment date & time By client ID
DMS Solutions™
By ascending county name then by client ID By Counselor name By result code then by client ID N/A
Page 9 of 9