Effective Date: 01/01/2014
Reference: 89 Ill. Adm. Code, Chapter IV, §50.235 


Parent Income Calculation Worksheet

The Parent Income Calculation Worksheet can also be used if you are completing the on-line Child Care Management System's (CCMS) Child Care Assistance Program Application.  You may have been directed to this page because you "clicked" the link found on the on-line Application.

The Parent Income Calculation Worksheet has two (2) spreadsheet tabs - See the tabs at the bottom of the spreadsheet screen:

Income Calculation - The Income Calculation tab allows users to input basic income information from pay documentation to calculate income eligibility for the Child Care Assistance Program (CCAP).  Please Note: The results are considered an estimate and require CCAP Specialists review.

If you have any questions about how to use the Parent Income Calculation Worksheet, please contact the CCAP Policy Unit at: DHS.CCAP.Policy@illinois.gov.


How to Complete a Parent Income Calculation Worksheet

The following step-by step instructions must be used when completing the Parent Income Calculation Worksheet:

  1. Upon opening the document, the current date will appear.
  2. Enter the client's first and last name.
  3. Enter the client's case identification number or social security number.
  4. Enter the Net Self Employment Income from client's documentation according to payment frequency.
  5. Enter the Net Self Employment Income from other family member(s) documentation according to payment frequency.
  6. Worksheet will adjust to Monthly Self Employment Income by - multiplying Net Self Employment Income according to pay frequency by:
    • If Weekly: by 4.333
    • If Bi-weekly: by 2.1666
    • If Semi-monthly: by 2
    • If Monthly: by 1
  7. Worksheet will calculate the results of line 6, the Adjusted Monthly Self Employment Income.
  8. Worksheet will calculate and enter the Total Monthly Self Employment Income.
  9. Enter the Date (xx/xx/xxxx) and Gross salary (including any regularly paid Overtime) from the Client's earliest pay stub according to pay frequency.
  10. Enter the Date and Gross salary (including any regularly paid Overtime) from the Client's latest pay stub according to pay frequency.
  11. Enter the Date and Gross salary (including any regularly paid Overtime) from the 2nd parent/stepparent's earliest pay stub according to pay frequency.
  12. Enter the Date and Gross salary (including any regularly paid Overtime) from the 2nd parent/stepparent's latest pay stub according to pay frequency.
  13. Enter the Date and combined gross salary (including any regularly paid Overtime) from all other adults, 19 yrs of age and older, in the family - Use earliest dated pay stub according to pay frequency.
  14. Enter the Date and combined gross salary (including any regularly paid Overtime) from all other adults, 19 yrs of age and older, in the family - Use latest dated pay stub according to pay frequency.
  15. Worksheet totals the income amounts entered in each of the four columns: Weekly, Bi-weekly, Semi-monthly, and Monthly.
  16. Worksheet averages the two pay stubs by - dividing the results by (2).
  17. Adjustment to Monthly Income from Salary - Worksheet Multiplies the Averaged Income from Wages according to pay frequency by the following as appropriate:
    • If Weekly: by 4.333
    • If Bi-weekly: by 2.1666
    • If Semi-monthly: by 2
    • If Monthly: by 1
  18. Worksheet calculates the Adjusted Monthly Income from Salary.
  19. Total Annual Bonuses or One-Time Payments:
    1. Enter the Total Annual Bonus or One-time Payment as labeled.
    2. Worksheet calculates and enters the Pro-rated Annual Bonus as labeled.
  20. Worksheet calculates and enters the Total Prospective Monthly Income for Family by:  Adding - Weekly, Bi-Weekly, Semi-Monthly, Monthly Columns and the Pro-rated Annual Bonus
  21. *Other Seasonal/Sporadic Overtime:
    1. Enter the Year-to-Date Amount of Other Seasonal/Sporadic Overtime as labeled.
      *Note: This is income occurring only during certain times of the year, occasionally, may be longer than one pay period and can include:
      • Overtime, Incentive Pay, Commission, Bonuses, or similar type income that is not included in line items 9 - 14 above.
    2. Enter the Year-to-Date Weeks of Other Seasonal/Sporadic Overtime as labeled.
    3. Worksheet calculates the Average Amount per Week.
    4. Worksheet converts the Average Amount per Week for client, 2nd parent and other family members to Monthly.
  22. Worksheet calculates and enters Monthly Gross Employment Income.
  23. Additional Income per Month, include all Family Members:
    1. Enter all Monthly Child Support Received for the family, then enter the Lump Sum Child Support.
    2. Enter all Monthly TANF Cash Assistance received for the family.
    3. Enter all Monthly Other Federal Cash Income received for the family.
    4. Enter all Other Monthly Income received for the family.
  24. Enter Monthly Child Support Paid by Applicant and Other Family members included in family size - Worksheet will subtract.
  25. Worksheet calculates and enters the Total Additional Income per MonthAdd lines 23a -23d, then Subtract line 24.
  26. Worksheet calculates and enters Total Monthly Income for Family by:  Adding Total Monthly Self Employment Income (line 8), Total Monthly Gross Employment Income (line 22), and Total Additional Income per Month (line 25).

Congratulations - You Have Just Completed the Parent Income Calculation Worksheet for CCAP!