Effective Date: 01/01/2014; 07/01/15
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 convert to Monthly Self Employment Income by - multiplying Net Self Employment Income according to pay frequency by using one of the Formulas below:
    • If Weekly Amount: by 4.333
    • If Bi-weekly Amount: by 2.1666
    • If Semi-MonthlyAmount: by 2
    • If Monthly Amount: 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  Wages and Salary (including any regularly paid Overtime) from the Client's latest pay stub according to pay frequency.
  11. Enter the Date and Gross Wages and 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 Wages and Salary (including any regularly paid Overtime) from the 2nd parent/stepparent's latest pay stub according to pay frequency.
  13. Enter the Date and Aggregate Gross Wages and Salary (including any regularly paid Overtime) from all other adults, 21 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, 21 yrs of age and older, in the family - Use latest dated pay stub according to pay frequency.
  15. Worksheet computes Total for 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. Convert to Monthly Base Income from Wages and 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 enters the Monthly Base Income from Wages and Salary.
  19. Worksheet calculates and enters the Prospective Monthly Base Income from Wages and Salary for Family by: Adding Weekly, Bi-Weekly, Semi-Monthly, and Monthly Columns.
  20. a. Enter the Year-to-Date Amount of Recurrent Overtime, Incentives, and Bonuses if Y-T-D accounts for 15% or more of Y-T-D Gross Earnings.
    20b. Enter the Year-to-Date Weeks of Recurrent Overtime, Incentives and Bonuses
    20c. Worksheet calculates the Average Amount per Week
    20d. Worksheet converts the Average Amount per Week for client, 2nd parent, and other family members to Monthly.
  21. Worksheet calculates and enters Monthly Gross Employment Income
  22. 22a.  Enter all Monthly Child Support received for the family.
    22b.  Enter all Monthly TANF Cash Assistance received for the family.
    22c.  Enter all Monthly Other Federal Cash Assistance received for the family.
    22d.  Enter all Other Monthly Income received for the family.
  23. Enter Monthly Child Support Paid by Applicant and Other Family Members included in the family size - Worksheet will subtract.
  24. Worksheet calculates and enters the Total Additional Income per Month:  Add Lines 22a-22d, then Subtract Line 23.
  25. Worksheet calculates and enters Combined Gross Monthly Base Income for Family: By Adding Total Self-Employment Income (line 8), Total Monthly Gross Employment Income (line 21), and Total Additional Income per Month (line 24).

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