Monthly Child Served Report.xlsm

This is a Monthly Child Served Report form used by child welfare service providers to submit census and billing data to the Rhode Island Department of Children, Youth and Families (DCYF). Providers must complete and submit this form by the fifth working day of each month following the service period. The form captures detailed information on individual children served, including demographic data, case identifiers, service authorization details, and service dates. Providers report on multiple service types including foster care (relative and non-relative), residential treatment, emergency shelter, family preservation services, mentoring, and various community-based programs. For each child served during the billing period, providers document total service days, absences due to hospitalization or other reasons, billable days, and current service delivery status (ongoing, successfully completed, or terminated for various reasons).

The form requires providers to calculate total costs based on contracted rates and billable days, with aggregated summaries of filtered days and total costs displayed at the form level. Service delivery status options include ongoing services as well as multiple termination categories such as successful completion, out-of-home placement, detention, aging out of program, family relocation, refusal of services, runaway status, client death, court order, service inappropriateness, and other reasons. The spreadsheet format allows for multiple service types and drop-down menus to ensure consistent data entry and reporting accuracy. This census data serves as the basis for provider invoicing and enables DCYF to track service utilization and outcomes across its contracted home-based and placement-based child welfare service network.