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