{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructional Guide","Template","Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Instructional Guide","index":0,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,0,44,9],[47,0,47,9],[50,0,50,9],[53,0,53,9],[41,0,41,9],[32,0,32,16383],[33,0,33,16383],[34,0,34,16383],[35,0,35,16383],[36,0,36,16383],[37,0,37,16383],[38,0,38,16383],[39,0,39,16383],[40,0,40,16383],[30,0,30,9],[27,0,27,16383],[4,4,4,9],[43,0,43,8],[56,0,56,16383],[25,0,25,9],[26,0,26,9],[4,0,4,3],[0,0,0,9],[3,0,3,9],[10,0,10,9],[11,0,11,9],[24,0,24,9],[21,0,21,9],[20,0,20,9],[5,0,5,9],[6,0,6,9],[28,0,28,9],[31,0,31,9],[29,0,29,8],[22,0,22,9],[23,0,23,9],[12,0,12,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[13,0,13,9],[1,0,1,9],[2,0,2,9],[45,0,45,9],[48,0,48,8],[51,0,51,8],[54,0,54,8],[49,0,49,9],[52,0,52,9],[55,0,55,9],[46,0,46,8],[42,0,42,9]]}
["This worksheet contains instructions to prepare the Single Audit Summary and contains one table spanning A15 through C20 with row 15 as the header row."]
["Guide to Completing the FY2024 Single Audit Summary (SAS) "]
["The SAS is no longer required to be mailed or uploaded, but must be maintained with the auditor's workpapers."]
[]
["The link to the SAS is at: ",null,null,null,"nj.gov/education/business/audit.htm"]
[]
["Section A - General Information"]
["• Complete all items in Sections A through F with D being optional.  Shaded items are automatically calculated.  Please enter a response for all items, including \"N/A\" or \"$0\" where applicable."]
["• The FY2024 SAS serves as a checklist of items specific to Single Audit testing performed by the Audit firm and summarizes related results.  Accordingly, all items must be completed and has been a requirement since FY2010."]
["• If links to other spreadsheets are used to populate data required for the FY2024 SAS, please be sure to select the entire spreadsheet following completion, choose Copy, followed by Paste Special and then Values, so that electronic copies of the document can be opened accordingly."]
[]
["Section B - Audit Items Submitted"]
["Please use the acronyms noted below only for document file names. Also, please use the exact file naming convention noted below when preparing the electronic files for the vendor. The program will automatically append the district code and a date stamp to each file name during the upload.  Please note that a broadcast memorandum will be released regarding the ACFR Repository."]
[]
["File Name","File Format","Audit Item"]
["ACFR",".PDF ","Annual Comprehensive  Financial Report "]
["AMR",".PDF ","Auditor's Management Report"]
["AQ",".PDF ","Audit Questionnaire (when a school-based budget is required)"]
["PR",".PDF ","Peer Review (not to be dated earlier than June 30, 2021)"]
["DCF",".PDF ","Single Audit Summary ( Data Collection Form-SF-SAC)(when federal expenditures exceed $750,000)"]
[]
["Section C - Single Audit Section"]
["• Refer to the FY2024 Audit Program, Single Audit Section."]
["Item 22 - total gross state expenditures subject to single audit determination (includes On-Behalf Contributions, if applicable)"]
["Item 23 - total state expenditures subject to major program determination (excludes On-Behalf Contributions)"]
["Item 24 - Type A/B threshold is determined by the auditor"]
["Item 25 - DOE threshold is calculated based on Item 25"]
[]
["• Refer to Uniform Grant Guidance Section .516 of 2 C.F.R. Part 200","Refer to Uniform Grant Guidance Section .516 of 2 C.F.R. Part 200"]
["Items 33, 36 and 39 - Audit Findings require specific reporting elements"]
[]
["• Audit Findings must include the following reporting elements:"]
["Finding Number"]
["Criteria or specific requirement"]
["Condition"]
["Questioned Costs"]
["Context"]
["Effect"]
["Cause"]
["Recommendation"]
["Views of responsible officials and planned corrective actions"]
[]
["• Refer to Uniform Grant Guidance Section .516 of 2 C.F.R. Part 200","Refer to Uniform Grant Guidance Section .516 of 2 C.F.R. Part 200"]
["Items 37 and 40 - Questioned Costs"]
[]
["• Refer to Uniform Grant Guidance Section .511 of 2 C.F.R. Part 200","Refer to Uniform Grant Guidance Section .516 of 2 C.F.R. Part 200"]
["Item 41 - Prior Year Findings"]
[]
["Section D - Comments (optional)"]
["• Forward spreadsheet to include additional information if applicable."]
[]
["Section E - Preparer's Information"]
["• Print name, signature (not stamped), date and email address."]
[]
["Section F - Audit Firm Information"]
["• Address and phone number."]
["end of worksheet"]

{"sheet":"Template","index":1,"n_rows":146,"n_cols":22,"rows_kept":146,"cut":false,"hidden":false,"merged":[[68,15,68,18],[126,1,126,12],[127,1,127,11],[128,1,128,11],[129,1,129,11],[126,15,126,23],[127,15,127,23],[128,15,128,23],[129,15,129,23],[36,15,36,18],[36,1,36,12],[37,1,37,13],[38,1,38,13],[47,0,47,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[65,15,65,18],[54,11,54,23],[54,1,54,10],[56,11,56,23],[56,1,56,10],[57,0,57,17],[61,0,61,12],[62,0,62,12],[65,1,65,12],[145,0,145,23],[7,0,7,4],[51,3,51,12],[98,4,98,12],[94,11,94,13],[116,0,116,4],[116,6,116,9],[116,13,116,14],[114,0,114,4],[108,6,108,9],[108,13,108,14],[105,0,105,4],[105,6,105,9],[105,13,105,14],[85,0,85,1],[85,3,85,9],[85,13,85,14],[82,0,82,1],[82,3,82,9],[82,13,82,14],[79,0,79,1],[125,0,125,14],[123,17,123,18],[144,5,144,11],[144,14,144,23],[140,5,140,11],[140,14,140,23],[135,0,135,23],[131,0,131,16383],[141,14,141,23],[142,14,142,23],[138,0,138,8],[138,13,138,23],[142,10,142,11],[142,5,142,8],[132,0,132,23],[133,0,133,23],[142,0,142,4],[140,0,140,4],[144,0,144,4],[144,12,144,13],[139,0,139,23],[134,0,134,23],[138,9,138,11],[119,0,119,4],[119,6,119,9],[119,13,119,14],[119,16,119,18],[119,21,119,23],[122,1,122,9],[122,11,122,13],[122,15,122,16],[122,17,122,18],[122,19,122,21],[122,22,122,23],[118,21,118,23],[117,0,117,4],[117,6,117,9],[117,13,117,14],[117,16,117,18],[117,21,117,23],[116,16,116,18],[116,21,116,23],[115,0,115,4],[115,6,115,9],[115,13,115,14],[115,16,115,18],[115,21,115,23],[118,0,118,4],[118,6,118,9],[118,13,118,14],[118,16,118,18],[114,21,114,23],[113,0,113,4],[113,6,113,9],[113,13,113,14],[113,16,113,18],[113,21,113,23],[112,0,112,4],[112,6,112,9],[112,13,112,14],[112,16,112,18],[112,21,112,23],[114,6,114,9],[114,13,114,14],[114,16,114,18],[111,21,111,23],[110,0,110,4],[110,6,110,9],[110,13,110,14],[110,16,110,18],[110,21,110,23],[109,0,109,4],[109,6,109,9],[109,13,109,14],[109,16,109,18],[109,21,109,23],[111,0,111,4],[111,6,111,9],[111,13,111,14],[111,16,111,18],[108,16,108,18],[108,21,108,23],[107,0,107,4],[107,6,107,9],[107,13,107,14],[107,16,107,18],[107,21,107,23],[106,0,106,4],[106,6,106,9],[106,13,106,14],[106,16,106,18],[106,21,106,23],[108,0,108,4],[105,16,105,18],[105,21,105,23],[98,14,98,15],[98,16,98,23],[97,0,97,23],[102,1,103,23],[96,0,96,16383],[100,0,100,4],[100,5,100,6],[94,15,94,16],[94,17,94,18],[94,19,94,21],[94,22,94,23],[93,1,93,9],[93,11,93,13],[93,15,93,16],[93,17,93,18],[93,19,93,21],[93,22,93,23],[94,1,94,8],[90,15,90,16],[90,17,90,18],[90,19,90,21],[90,22,90,23],[88,0,88,1],[88,3,88,9],[88,13,88,14],[88,16,88,18],[88,21,88,23],[90,1,90,11],[87,16,87,18],[87,21,87,23],[86,0,86,1],[86,3,86,9],[86,13,86,14],[86,16,86,18],[86,21,86,23],[87,0,87,1],[87,3,87,9],[87,13,87,14],[85,16,85,18],[85,21,85,23],[84,0,84,1],[84,3,84,9],[84,13,84,14],[84,16,84,18],[84,21,84,23],[83,0,83,1],[83,3,83,9],[83,13,83,14],[83,16,83,18],[83,21,83,23],[82,16,82,18],[82,21,82,23],[81,0,81,1],[81,3,81,9],[81,13,81,14],[81,16,81,18],[81,21,81,23],[80,0,80,1],[80,3,80,9],[80,13,80,14],[80,16,80,18],[80,21,80,23],[75,21,75,23],[72,1,73,23],[70,0,70,4],[74,0,74,23],[79,16,79,18],[79,21,79,23],[78,0,78,1],[78,3,78,9],[78,13,78,14],[78,16,78,18],[78,21,78,23],[77,0,77,1],[77,3,77,9],[77,13,77,14],[77,16,77,18],[77,21,77,23],[79,3,79,9],[79,13,79,14],[60,1,60,6],[60,7,60,9],[62,19,62,23],[65,19,65,21],[65,22,65,23],[64,0,64,23],[63,0,63,23],[57,18,57,23],[60,19,60,23],[61,19,61,23],[58,1,58,6],[58,7,58,9],[58,19,58,23],[59,1,59,6],[59,7,59,9],[59,19,59,23],[43,19,43,23],[41,1,41,6],[41,7,41,9],[41,15,41,16],[41,17,41,18],[41,19,41,21],[51,14,51,15],[51,16,51,23],[50,0,50,23],[44,1,44,6],[44,7,44,9],[46,19,46,23],[45,1,45,6],[45,7,45,9],[47,19,47,23],[44,19,44,23],[45,19,45,23],[51,0,51,2],[30,15,30,16],[30,17,30,18],[30,19,30,21],[30,22,30,23],[29,0,29,23],[33,19,33,21],[31,0,31,23],[33,22,33,23],[30,1,30,12],[33,1,33,12],[33,15,33,18],[0,0,0,23],[1,0,1,23],[7,5,7,8],[8,0,8,4],[8,5,8,13],[6,0,6,4],[6,5,6,13],[7,10,7,13],[4,0,4,23],[2,0,2,23],[3,0,3,22],[6,14,6,23],[7,14,7,16383],[8,14,8,23],[6,25,6,26],[8,25,8,26],[5,0,5,23],[9,25,9,26],[28,0,28,23],[49,0,49,16383],[23,22,23,23],[20,1,20,11],[19,1,19,11],[19,17,19,18],[19,22,19,23],[18,22,18,23],[16,1,16,11],[9,0,9,4],[18,1,18,11],[18,17,18,18],[16,22,16,23],[16,19,16,21],[9,5,9,13],[12,0,12,23],[13,0,13,23],[14,0,14,16383],[23,1,23,11],[23,15,23,16],[10,0,10,23],[11,0,11,23],[15,0,15,23],[17,0,17,23],[22,0,22,23],[24,0,24,23],[26,0,26,23],[27,0,27,23],[23,17,23,18],[23,19,23,21],[21,1,21,11],[25,1,25,13],[25,14,25,23],[16,17,16,18],[9,14,9,23],[39,0,39,23],[32,0,32,23],[35,0,35,23],[40,0,40,23],[42,0,42,17],[53,0,53,23],[52,0,52,23],[55,0,55,23],[37,14,37,23],[38,14,38,23],[36,19,36,21],[36,22,36,23],[34,0,34,23],[42,18,42,23],[43,1,43,6],[43,7,43,9],[66,0,66,23],[69,0,69,23],[67,0,67,16383],[71,0,71,23],[92,0,92,23],[95,0,95,23],[101,0,101,23],[104,0,104,23],[121,0,121,23],[68,1,68,10],[68,11,68,13],[68,19,68,21],[68,22,68,23],[76,0,76,1],[76,3,76,9],[76,13,76,14],[76,16,76,18],[76,21,76,23],[75,0,75,1],[75,3,75,9],[75,13,75,14],[75,16,75,18],[130,0,130,23],[136,0,136,23],[137,0,137,23],[141,0,141,13],[143,1,143,23],[124,0,124,23],[120,0,120,23],[123,19,123,21],[123,22,123,23],[123,11,123,13],[123,15,123,16],[123,1,123,8]]}
["Single Audit Summary"]
["For Fiscal Year Ended June 30, 2024"]
["The Single Audit Summary (SAS) report is no longer required to be mailed or uploaded but must be maintained with the auditor’s workpapers. The SAS can be accessed through the Audit Information webpage: nj.gov/education/business/audit.htm"]
[]
["A. General Information"]
[]
["Vendor Name:"]
["Vendor Code:",null,null,null,null,null,null,null,null,"EIN:"]
["County Number and Name:"]
["Audit Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
["B. Audit Items Submitted"]
[]
["Items 2 through 6 are submitted electronically."]
[]
[1,"The School District is required to use a school-based budget",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"N/A"]
[]
[2,"Comprehensive Annual Financial Report "]
[3,"Auditor's Management Report "]
[4,"Current Peer Review"]
[5,"Single Audit Summary (Data Collection Form-SF-SAC) "]
[]
[6,"Audit performed and signed and dated by a CPA",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[7,"Type of Auditor’s Report: Financial Statements"]
[]
[]
["C. Single Audit Section"]
[]
[8,"Single Audits required according to the Federal and State Expenditures",null,null,null,null,null,null,null,null,null,null,null,"Federal",{"$f":"IF((OR(H42>750000,H42=750000)),\"X\", \" \")","v":" "},"State",null,{"$f":"IF((OR(L55>750000,L55=750000)),\"X\",\" \")","v":" "},null,"N/A"]
[]
["K-1  Independent Auditor’s Report "]
[9,"Material weaknesses and/or significant deficiencies noted",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,"N/A"]
[]
["K-2  Independent Auditor’s Report of Federal and State Programs"]
[10,"Material weaknesses and/or significant deficiencies noted",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,"N/A"]
[11,"Type of Auditor’s Report: Federal"]
[12,"Type of Auditor’s Report: State "]
[]
["K-3  Schedule of Expenditures of Federal Awards"]
[13,"Total Federal Expenditures"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As of June 30, 2023"]
[14,"Type A/B Threshold",null,null,null,null,null,null,null,null,null,null,null,17,"Due to Grantor"]
[15,"DOE Calculation",null,null,null,null,null,{"$f":"IF(H42<750000,\"N/A\",(IF(AND(H42>=750000,H42<=100000000,(H42*0.03)>750000),ROUND(H42*0.03,0),IF(AND(H42>=750000,H42<=100000000,(H42*0.03)<=750000),750000,IF(AND(H42>=100000000,H42<=10000000000,(H42*0.003)>3000000),ROUND(H42*0.003,0),IF(AND(H42>=100000000,H42<=10000000000,(H42*0.003)<=3000000),3000000,IF(AND(H42>10000000000,(H42*0.0015)>30000000),ROUND(H42*0.0015,0),IF(AND(H42>10000000000,(H42*0.0015)<=30000000),30000000))))))))","v":"N/A"},null,null,null,null,null,18,"Adjustment/Cancellation"]
[16,"Difference",null,null,null,null,null,{"$f":"IF(OR(H45=\"na\",H45=\"N/A\", H44=\"na\",H44=\"N/A\"),\"N/A\",H45-H44)","v":"N/A"},null,null,null,null,null,19,"Refund Amount ",null,null,null,null,{"$f":"T44-T45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Repayment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Remaining Balance Due",null,null,null,null,{"$f":"T46-T47","v":0}]
[]
["C. Single Audit Section (cont'd)"]
[]
["Vendor Name:",null,null,{"$f":"F7","v":0},null,null,null,null,null,null,null,null,null,null,"County:",null,{"$f":"F9","v":0}]
[]
["K-4  Schedule of Expenditures of State Financial Assistance"]
[22,"Total State Expenditures Subject to Single Audit Determination (incl On-Behalf Contrib if applic)"]
[]
[23,"Total State Expenditures Subject to Major Program Determination (excl On-Behalf )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As of June 30, 2023"]
[24,"Type A/B Threshold",null,null,null,null,null,null,null,null,null,null,null,27,"Due to Grantor"]
[25,"DOE Calculation",null,null,null,null,null,{"$f":"IF(L57<750000,\"N/A\",(IF(AND(L57>=750000,L57<=100000000,(L57*0.03)>750000),ROUND(L57*0.03,0),IF(AND(L57>=750000,L57<=100000000,(L57*0.03)<=750000),750000,IF(AND(L57>=100000000,L57<=10000000000,(L57*0.003)>3000000),ROUND(L57*0.003,0),IF(AND(L57>=100000000,L57<=10000000000,(L57*0.003)<=3000000),3000000,IF(AND(L57>10000000000,(L57*0.0015)>30000000),ROUND(L57*0.0015,0),IF(AND(L57>10000000000,(L57*0.0015)<=30000000),30000000))))))))","v":"N/A"},null,null,null,null,null,28,"Adjustment/Cancellation"]
[26,"Difference",null,null,null,null,null,{"$f":"IF(OR(H60=\"na\",H60=\"N/A\", H59=\"na\",H59=\"N/A\"),\"N/A\",H60-H59)","v":"N/A"},null,null,null,null,null,29,"Refund Amount ",null,null,null,null,{"$f":"T59-T60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Repayment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Remaining Balance Due",null,null,null,null,{"$f":"T61-T62","v":0}]
[]
["K-5  Notes to the Schedule of Expenditures of Awards and Financial Assistance"]
[32,"Notes included",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,"N/A"]
[]
["K-6  Schedule of Financial Statement Findings"]
[33,"Audit Findings contain the required reporting elements",null,null,null,null,null,null,null,null,null,"Yes (number of findings)",null,null,null,null,null,null,null,"N/A"]
[]
["Federal Awards"]
["K-6 - Summary of Auditor's Results"]
[34,"List all Federal Programs exceeding the Type A Threshold and all Type B Programs determined to be major programs and audited in the current year. Include the applicable AL Numbers, classify the Programs as Type A or B and note the last periods audited with an “X” in the specific columns.  "]
[]
[]
["AL \nNumber",null,null,"Name of Federal Major Program or Cluster",null,null,null,null,null,null,null,"Type\nA or B",null,"Year 3 - 2024",null,null,"Year 2 - 2023",null,null,null,null,"Year 1 - 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[35," K-6 agrees with Data Collection Form",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,"N/A"]
[]
["K-6 - Schedule of Federal & State Award Findings & Questioned Costs"]
[36,"Audit Findings contain the required reporting elements",null,null,null,null,null,null,null,null,null,"Yes (number of findings)",null,null,null,null,null,null,null,"N/A"]
[37,"Questioned Costs",null,null,null,null,null,null,null,null,null,"Yes (amount,none,unknown)",null,null,null,null,null,null,null,"N/A"]
[]
["C. Single Audit Section (cont'd)"]
[]
["Vendor Name:",null,null,null,{"$f":"F7","v":0},null,null,null,null,null,null,null,null,null,"County:",null,{"$f":"F9","v":0}]
[]
["State Awards "]
["K-6 - Summary of Auditor's Results "]
[38,"List all State Programs exceeding the Type A Threshold and all Type B Programs determined to be major programs and audited in the current year.  Include the applicable GMIS Numbers, classify the Programs as Type A or B and note the last periods audited with an “X” in the specific columns.  "]
[]
[]
["GMIS Number",null,null,null,null,null,"Name of State Program",null,null,null,null,"Type \nA or B",null,"Year 3 - 2024",null,null,"Year 2 - 2023",null,null,null,null,"Year 1 - 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["K-6 Schedule of Federal & State Award Findings & Questioned Costs"]
[39,"Audit Findings contain the required reporting elements",null,null,null,null,null,null,null,null,null,"Yes (number of findings)",null,null,null,null,null,null,null,"N/A"]
[40,"Questioned Costs",null,null,null,null,null,null,null,null,null,"Yes (amount)",null,null,null,null,null,null,null,"N/A"]
[]
["K-7  Schedule of Prior Year Audit Findings "]
[41,"Prior Period Findings",null,null,null,null,null,null,null,null,null,null,null,"Number"]
[null,"Fully Correct",null,null,null,null,null,null,null,null,null,null,null,"Number"]
[null,"Not corrected",null,null,null,null,null,null,null,null,null,null,null,"Number"]
[null,"Partially Corrected",null,null,null,null,null,null,null,null,null,null,null,"Number"]
[]
["D. Comments (optional)"]
[]
[]
[]
[]
[]
[]
["E. Preparer's Information",null,null,null,null,null,null,null,null,null,null,null,null,"F. Audit  Firm Information"]
[]
["Print Name:",null,null,null,null,null,null,null,null,null,null,null,null,"Address:"]
[]
["Signature:",null,null,null,null,null,null,null,null,"Date:"]
[]
["Email Address:",null,null,null,null,null,null,null,null,null,null,null,"Phone Number:"]
["end of worksheet"]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Unmodified",null,"01 - Atlantic"]
["Modified",null,"03 - Bergen"]
["N/A",null,"05 - Burlington"]
["Adverse",null,"07 - Camden"]
["Disclaimer",null,"09 - Cape May"]
[null,null,"11 - Cumberland"]
[null,null,"13 - Essex"]
[null,null,"15 - Gloucester"]
[null,null,"17 - Hudson"]
[null,null,"19 - Hunterdon"]
[null,null,"21 - Mercer"]
[null,null,"23 - Middlesex"]
[null,null,"25 - Monmouth"]
[null,null,"27 - Morris"]
[null,null,"29 - Ocean"]
[null,null,"31 - Passaic"]
[null,null,"33 - Salem"]
[null,null,"35 - Somerset"]
[null,null,"37 - Sussex"]
[null,null,"39 - Union"]
[null,null,"41 - Warren"]