{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Important Info","Verification FAQs","Verification Summary","Sample Letters","Verification Summary - Example"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Important Info","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,2,15,15],[54,1,54,14],[25,0,34,16],[36,0,39,16],[19,1,19,5]]}
[]
[null,"INSTRUCTIONS FOR USING THIS CHECKLIST for VERIFICATION OF KSDE HOUSEHOLD ECONOMIC SURVEY (STATE AT-RISK WEIGHTING)"]
[]
[null,1,"Read Verification FAQs worksheet.  This worksheet contains important information regarding the verification."]
[null,2,"Read the Verification Summary worksheet for helpful information on completing the verification process."]
[null,3,"Complete a Verification Summary for EACH household selected for verification."]
[null,4,"Provide all Verification Summaries to your KSDE Auditor at audit time (Excel format preferred)."]
[]
[null,"IMPORTANT INFORMATION"]
[]
[null,"•","Orange highlighted cells indicate an area where the user should input information"]
[null,"•","Verification must be completed by 11/15/21."]
[null,"•","Verification Summary worksheet contains important information for completing the verification process."]
[null,"•","When sampling for verification, include only those KSDE Household Economic Surveys determined as \"free\" or \"reduced\" based on income."]
[null,"•","Sample notification letters are included in this file."]
[null,"•","Cutting data will cause formula errors in protected cells so we have disabled the cut function in the worksheet. Instead, please copy and paste, then go back to original cell and delete data."]
[]
[null,"EXAMPLE VERIFICATION SUMMARY WORKSHEET"]
[]
[null,"audit20"]
[]
[]
[]
[]
[]
["Verification of Household Economic Survey - At Risk Weighting 21-22\nUpdated 10/5/21\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Verification FAQs","index":1,"n_rows":89,"n_cols":3,"rows_kept":89,"cut":false,"hidden":false,"merged":[[97,1,97,7],[1,1,1,7],[2,1,2,7],[6,1,6,7],[23,1,23,7],[28,1,28,7],[34,1,34,7],[40,1,40,7],[49,1,49,7],[50,1,50,7],[54,1,54,7],[85,4,85,7],[88,0,95,7]]}
[]
[null,"Verification Frequently-Asked-Questions (FAQs)"]
[null,"KSDE Household Economic Survey for State At-Risk Weighting"]
[]
[]
[]
[null,"Which type of eligibility is subject to verification?"]
[null,"Each district must verify eligibility of students from a sample of KSDE Household Economic Surveys."]
[null,null,"Subject to verification:"]
[null,null,"  -KSDE Household Economic Surveys determined to have \"free\" or \"reduced\" eligibility based on income (includes error prone)"]
[null,null,"  -Surveys with questionable or incomplete information (verification for cause)"]
[]
[null,null,"Not subject to verification:"]
[null,null,"  -Food Assistance (FA)"]
[null,null,"  -Direct Certification (Temporary Assistance to Families, Foster Child)"]
[null,null,"  -Certified migrant, homeless or runaway"]
[null,null,"  -Income-eligible for Head Start"]
[null,null,"  -Residents in Residential Child Care Institutions (RCCI)"]
[null,null,"  -Non-applicants approved by local officials based on collateral contacts"]
[null,null,"  -KSDE Household Economic Surveys determined to have paid eligibility based on income"]
[]
[]
[]
[null,"When does the verification need to be completed?"]
[null,"Verification must be completed by November 15, 2021."]
[]
[]
[]
[null,"Which type of sample should be used to select the Household Economic Surveys to be verified?"]
[null,"Verification must be conducted on a random sample of 3% of all Household Economic Surveys determined to have free or reduced eligibility as of count day."]
[null,"See the Verification Summary worksheet (the next tab in this file) for help on selecting a random sample of 3%."]
[]
[]
[]
[null,"How do I notify the households that have been selected for verification?"]
[null,"Send the household a notification letter. Sample notification letters are located on the Sample Letters worksheet in this file.  "]
[null,"Deadline for the household to respond should be 10 calendar days from date of notification."]
[]
[]
[]
[null,"What if the household doesn't respond to the request for verification documents by the deadline in the letter?"]
[null,"Send a 2nd notification (can be by email or phone as long as it is documented).  See Sample Letters worksheet in this file."]
[null,"If the household doesn't respond to the 2nd notice:"]
[null,null,"change their status to \"paid.\" This does not affect their food service-related status, but does mean that State At-Risk Weighting will not be paid."]
[null,null,"if appropriate, send change in status letter to the household (if local fees have been reduced or waived based  on the Household Economic Survey)"]
[null,null,"Sample notification letters are located on the Sample Letters worksheet in this file.  "]
[]
[]
[]
[null,"How do I document the results of the verification for the KSDE auditor?"]
[null,"Complete the Verification Summary worksheet included in this file.  You can create a copy of the worksheet in this file or into a new Excel file as many times as needed (you will need to complete one Verification Summary for EACH Household Economic Survey verified)."]
[]
[]
[]
[null,"How do I complete the verification?"]
[null,"Notify the household of the results of the verification.  A sample notification of verification results letter is on the Sample Letters worksheet in this file."]
[null,"Update the data field D33 in your district's student information system with any changes in eligibility (status) for students."]
[null,"Keep the records related to the State At-Risk Weighting claim (including the verification documentation) for five years per KSA 72-1629."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Verification - Household Economic Survey - At Risk Weighting\nUpdated 10/5/21\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Verification Summary","index":2,"n_rows":80,"n_cols":7,"rows_kept":80,"cut":false,"hidden":false,"merged":[[61,5,61,6],[62,5,62,6],[64,3,64,6],[26,1,26,6],[14,1,14,2],[14,4,14,6],[58,5,58,6],[59,5,59,6],[19,3,19,4],[56,5,56,6],[27,1,27,2],[28,1,28,2],[76,3,76,6],[79,0,86,6],[1,0,1,6],[2,0,2,6],[11,0,11,6],[18,1,18,2],[19,1,19,2],[18,3,18,4],[15,4,15,6],[18,5,18,6],[19,5,19,6],[4,0,4,6],[8,3,8,4],[7,3,7,4],[60,5,60,6],[70,0,70,6],[88,0,88,6],[32,0,32,6],[45,0,45,6],[52,1,52,2],[53,1,53,2],[54,1,54,2],[52,4,52,5],[40,0,40,6],[51,1,51,2],[51,4,51,5],[42,1,42,6],[53,4,53,5],[54,4,54,5],[47,1,47,2],[48,1,48,2],[57,5,57,6]]}
[]
["Verification Summary"]
["KSDE Household Economic Survey (State At-Risk Weighting)"]
[]
["This worksheet must be completed by November 15, 2021 for EACH household selected for verification.  Provide to your KSDE Auditor at audit time."]
["You can copy this worksheet within this file or into a new file so you can create one for EACH household selected for verification."]
[]
[]
[null,"District Number",null,"District Name",null,null,"Date of this Form"]
[]
[]
["Select the 3% random sample."]
[1,"Count the number of KSDE Household Economic Surveys required for verification as of count day.  This is the sample pool.  Here is what to include and exclude from the sample pool."]
[null,"Include only those surveys that were:",null,null,"Do not include surveys that were:"]
[null,"   -determined eligible for free or reduced based on income only as of\n        count day.  Includes error prone surveys (within $100 per month of\n        the applicable Income Eligibility Guidelines).",null,null,"   -determined eligible based on Food Assistance, Direct Certification, Migrant, Homeless, \n      Runaway, Head Start, or RCCI."]
[null,"   -received by end of day on count day.",null,null,"  -determined eligible for paid."]
[null,null,null,null,"   -received after the end of the day on count day."]
[]
[null,"Enter number of surveys in the verification sample pool.",null,"This is the number of surveys to be verified (3%). *",null,"This is the selection interval."]
[null,null,null,{"$f":"ROUNDUP((B20*0.03),0)","v":0},null,{"$f":"IFERROR(ROUNDDOWN(B20/D20,0),0)","v":0}]
[null,"*Verify the lesser of 3% or 3,000 surveys.  Example: if 3% of the sample pool equals 3,500 surveys, you only need to verify 3,000 of those surveys."]
[]
[2,"Randomly select the surveys to be verified (3%)."]
[null,"   -Randomize the sample pool (mix the surveys up so they are not in any order)."]
[null,"   -Select the surveys that appear at the selection interval.  Example:  If the selection interval is 33, then every 33rd survey is selected."]
[]
[3,"Verification for Cause:  The district has an obligation to verify surveys containing questionable or incomplete information (Example: a survey shows 0 income when it is known that the family has income).  Surveys chosen for verification for cause should be in addition to the 3% selected in number 1 above.  Districts should balance administrative requirements and integrity with access to free or reduced price benefits (fees, text books, etc.) for eligible children."]
[]
[null,"Enter number of surveys verified for cause."]
[]
[]
[]
["Notify the households that have been selected for verification."]
[null,"A sample notification of selection for verification letter is on the Sample Letters worksheet in this file.  Deadline for household response should be 10 calendar days from notification date."]
[null,"If the household doesn't respond to the first notification, send a 2nd notification (can be by email or phone as long as it is documented).  See Sample Letters worksheet in this file."]
[null,"If the household doesn't respond to the 2nd notice, change their benefits to \"paid.\" This does not affect their food service-related status."]
[null,"If appropriate, send change in status letter to the household (if local fees have been reduced or waived based on the Household Economic Survey)"]
[null,"   (see Sample Letters worksheet in this file)"]
[]
[]
["Review the verification documentation provided by the household and determine any changes in eligibility."]
[null,"Written evidence is the primary source of eligibility confirmation for all households."]
[null,"Acceptable written evidence for income eligible households contains the name of the household member, amount of income received, frequency received, and the date the income was received.  For example, a pay stub with no dates would be insufficient."]
[]
[]
["Complete this section for each verification and provide to your KSDE auditor."]
[]
[null,"Head of Household's Name",null,null,"Today's Date"]
[]
[]
[null,"Student's Names"]
[]
[]
[]
[]
[]
[null,"Source of Employment/Income","Gross Pay from Income Documentation","Income Frequency\n(Weekly, Bi-Weekly, 2x Month, or Monthly)","Total # in Household","District Comment"]
[1]
[2]
[3]
[4]
[5]
[null,"Total Verified Income"]
[null,null,"Manually complete cell above"]
[null,null,null,"Enter Applicable Dates Below"]
[null,"Verified Eligibility (F, R or P)",null,"1st notification sent","2nd notification sent","Verification completed","Notification of change sent"]
[]
[]
[]
[]
["Finish the verification."]
[1,"If appropriate, notify the household of the results of the verification.  A sample notification of verification results letter is on the Sample Letters worksheet in this file."]
[2,"Update the data field D33 in the district's student information system with any changes in eligibility for students."]
[3,"Keep the records related to the State At-Risk Weighting claim (including the verification documents) for five years per KSA 72-1629."]
[]
[]
[]
[]
[]
["Verification of Household Economic Survey - At Risk Weighting 21-22\nUpdated 10/5/21\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Sample Letters","index":3,"n_rows":204,"n_cols":2,"rows_kept":204,"cut":false,"hidden":false,"merged":[[65,1,65,11],[119,1,119,11],[163,1,163,11],[205,1,205,7],[204,0,204,11],[203,0,203,11],[7,0,7,11],[9,0,9,11],[13,1,13,11],[1,0,1,11],[2,0,2,11],[5,0,5,11]]}
[]
["Sample Letters for Verification"]
["KSDE Household Economic Survey for State At-Risk Weighting"]
[]
[]
["There are 4 sample letters below for your use in the verification of KSDE Household Economic Surveys process."]
[]
["To modify the letters, double click on the letter you want below.  This will open up a Word window.  You can then modify and save the document to your computer. "]
[]
["If this process doesn't work on your computer, you can also download a word version of the letters at the Fiscal Auditing website (link below) under the heading \"Calculators.\""]
[]
["Fiscal Auditing Website"]
[]
[null,"Sample letter to notify household of selection for verification"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sample letter to notify household of selection for verification - 2nd Notice"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sample letter to notify household of increase in benefits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sample letter to notify household of decrease in benefits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Verification of Household Economic Survey - At Risk Weighting 21-22\nUpdated 10/5/21\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Verification Summary - Example","index":4,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[43,0,43,6],[45,1,45,6],[82,3,82,6],[85,0,92,6],[94,0,94,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[68,3,68,6],[75,0,75,6],[12,0,12,6],[56,1,56,2],[56,4,56,5],[60,5,60,6],[55,1,55,2],[55,4,55,5],[15,4,15,6],[51,1,51,2],[52,1,52,2],[57,1,57,2],[57,4,57,5],[58,1,58,2],[58,4,58,5],[29,1,29,2],[30,1,30,2],[31,1,31,2],[15,1,15,2],[49,0,49,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[34,0,34,6],[21,1,21,2],[21,3,21,4],[21,5,21,6],[16,4,16,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[28,1,28,6],[7,3,7,4],[8,3,8,4]]}
[]
["Verification Summary"]
["KSDE Household Economic Survey - State At-Risk Weighting"]
[]
["This worksheet must be completed by November 15, 2021 for EACH household selected for verification.  Provide to your KSDE Auditor at audit time."]
["You can copy of this worksheet within this file or into a new file so you can create one for EACH household selected for verification."]
[]
[null,77026,null,"Sunflower School System",null,null,"2021-11-15"]
[null,"District Number",null,"District Name",null,null,"Date of this Form"]
[]
[]
[]
["Select the 3% random sample."]
[1,"Count the number of KSDE Household Economic Surveys required for verification.  This is the sample pool.  Here is what to include and exclude from the sample pool."]
[null,"Include only those surveys that were:",null,null,"Do not include surveys that were:"]
[null,"   -determined eligible for free or reduced based on income only.\n     Includes error prone surveys (within $100 per month of the \n     applicable Income Eligibility Guidelines).",null,null,"   -determined eligible based on Food Assistance, Direct Certification, Migrant, Homeless, \n      Runaway, Head Start, or RCCI."]
[null,"   -received by end of day on count day.",null,null,"  -determined eligible for paid."]
[null,null,null,null,"   -received after the end of the day on count day."]
[]
[]
[null,"Enter number of surveys in the verification sample pool.",null,"This is the number of surveys to be verified (3%). *",null,"This is the selection interval."]
[null,781,null,{"$f":"ROUNDUP((B22*0.03),0)","v":24},null,{"$f":"IFERROR(ROUNDDOWN(B22/D22,0),0)","v":32}]
[null,"*Verify the lesser of 3% or 3,000 surveys.  Example: if 3% of the sample pool equals 3,500 surveys, you only need to verify 3,000 of those surveys."]
[]
[2,"Randomly select the surveys to be verified (3%)."]
[null,"   -Randomize the sample pool (mix the surveys up so they are not in any order)."]
[null,"   -Select the surveys that appear at the selection interval.  Example:  If the selection interval is 33, then every 33rd survey is selected."]
[]
[3,"Verification for Cause:  The district has an obligation to verify surveys containing questionable or incomplete information (Example: a survey shows 0 income when it is known that the family has income).  Surveys chosen for verification for cause should be in addition to the 3% selected in number 1 above.  Districts should balance administrative requirements and integrity with access to free or reduced price benefits (fees, text books, etc.) for eligible children."]
[]
[null,"Enter number of surveys verified for cause."]
[null,2]
[]
[]
["Notify the households that have been selected for verification."]
[null,"A sample notification of selection for verification letter is on the Sample Letters worksheet in this file.  Deadline for household response should be 10 calendar days from notification date."]
[null,"If the household doesn't respond to the first notification, send a 2nd notification (can be by email or phone as long as it is documented).  See Sample Letters worksheet in this file."]
[null,"If the household doesn't respond to the 2nd notice, change their benefits to \"paid.\" This does not affect their food service-related status."]
[null,"If appropriate, send change in status letter to the household (if local fees have been reduced or waived based on the Household Economic Survey)"]
[null,"   (see Sample Letters worksheet in this file)"]
[]
[]
[]
["Review the verification documentation provided by the household and determine any changes in eligibility."]
[null,"Written evidence is the primary source of eligibility confirmation for all households."]
[null,"Acceptable written evidence for income eligible households contains the name of the household member, amount of income received, frequency received, and the date the income was received.  For example, a pay stub with no dates would be insufficient."]
[]
[]
[]
["Complete this section for each verification and provide to your KSDE auditor."]
[]
[null,"Head of Household's Name",null,null,"Today's Date"]
[null,"Raymond Stone",null,null,"2021-11-01"]
[]
[null,"Student's Names"]
[null,"Joshua Stone"]
[]
[]
[]
[]
[null,"Source of Employment/Income","Gross Pay from Income Documentation","Income Frequency\n(Weekly, Bi-Weekly, 2x Month, or Monthly)","Total # in Household","District Comment"]
[1,"Susan Stone",1000,"Monthly",4,"2 year old in household"]
[2]
[3]
[4]
[5]
[null,"Total Verified Income",1000]
[]
[null,null,null,"Enter Applicable Dates Below"]
[null,"Verified Eligibility (F, R or P)",null,"1st notification sent","2nd notification sent","Verification completed","Notification of change sent"]
[null,"F",null,"2021-10-01","NA","2021-11-01","NA"]
[]
[]
[]
[]
["Finish the verification."]
[1,"If appropriate, notify the household of the results of the verification.  A sample notification of verification results letter is on the Sample Letters worksheet in this file."]
[2,"Update the data field D33 in the district's student information system with any changes in eligibility for students."]
[3,"Keep the records related to the State At-Risk Weighting claim (including the verification documents) for five years per KSA 72-1629."]
[]
[]
[]
[]
[]
[]
["Verification of Household Economic Survey - At Risk Weighting 21-22\nUpdated 10/5/21\n\n\nKansas leads the world in the success of each student."]