{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS - UNIVERSITY ","University ECC Template","Subcontractor Summary Template","Sample University ECC","General Ledger Detail Sample","Sample Subcontractor Summary "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"INSTRUCTIONS - UNIVERSITY ","index":0,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[42,0,42,10],[43,0,43,10],[29,1,29,10],[30,1,30,10],[31,1,31,10],[35,0,35,10],[37,0,37,10],[38,0,38,10],[39,1,39,10],[28,1,28,10],[18,1,18,10],[19,1,19,10],[25,1,25,10],[20,1,20,10],[22,1,22,10],[23,1,23,10],[24,1,24,10],[27,1,27,10],[21,1,21,10],[26,1,26,10],[17,1,17,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[6,0,6,1],[7,0,8,10],[9,2,9,10],[10,0,10,10],[12,0,12,10],[13,0,13,10],[16,1,16,10]]}
[]
[" Sandia National Laboratories"]
["Contract Audit"]
["ECC Instructions "]
[]
["Cost Reimbursable (University) Type Contracts"]
["User Information:"]
["The following information does not supersede any statute, regulation or policy that is, was or will be in effect. It is designed as a tool to answer general questions that are commonly posed by contractors that are subject to audits from the Sandia Contract Audit Department, Organization 851 (hereinafter, Contract Audit). For specific questions pertaining to your contract, contact the appropriate Subcontracting Professional (SP) listed on your contract."]
[]
[]
["In preparing the ECC, we require each contractor reconcile their claim to the general ledger amount to ensure that all costs are properly accounted for. Costs previously invoiced/not invoiced in error can be adjusted on your claim. "]
[]
["**All ECCs should be submitted in a single Excel workbook with separate worksheets for each contract. There should be a separate submission for each fiscal year."]
["If extra rows are needed:  Ctrl + Shift + R "]
[]
[]
[null,"1. Header: Please fill out the university name, contract number, period of performance of the contract (beginning and end dates of contract), contract ceiling price and fiscal year for which the claimed costs apply."]
[null,"2. Month: This will auto populate once University Fiscal Year End is updated. "]
[null,"3. Direct Labor: Insert actual direct labor costs by level of effort and non-level of effort for each labor category. "]
[null,"4. Direct Labor Fringe: Insert the fringe rates associated with your claimed direct labor charges if these are being billed and claimed. If there is more than one direct labor fringe rate used, list them separately. Examples include: Off-site direct labor fringe, on-site direct labor fringe, overtime direct labor fringe. All claimed indirect rates must be allowable, allocable, and audited or approved by your cognizant agency. Please see the “Indirect Rate” section below in this document for additional information."]
[null,"5. Direct Supplies/Materials: List the actual direct material costs for each accounting period."]
[null,"6. Tuition/Fees: List the actual tuition being claimed for each accounting period."]
[null,"7. Direct Travel: List applicable domestic and foreign travel charges for each accounting period.  Domestic travel charges should be listed on a separate row than foreign travel charges."]
[null,"8. Subcontracts/Consultant/Temporary Labor: List the costs incurred by Subcontractors/Consultants. If subcontractor costs are being claimed, complete the \"Subcontractor Summary\" template tab. "]
[null,"9. ODCs (Other Direct Costs): For any other direct costs that you are claiming, segregate those costs accordingly. Some examples may include: Licensing fees, equipment leases, shipping and handling, taxes, etc. All other direct costs should be grouped together in this column. If you need to explain what the group consists of please include a comment in the comments section (use column T)."]
[null,"10. On-Site, Off-site & other F&A costs: must be segregated according to their rates and basis. All claimed indirect rates must be allowable, allocable, and audited or approved by your cognizant agency. Please see the “Indirect Rate” section below in this document for additional information."]
[null,"11. Equipment: List all equipment claimed in the appropriate accounting period when the cost was incurred. "]
[null,"11. Total per General Ledger: This will auto populate. "]
[null,"12. Adjustments by month and cost element: Include any amounts that you have over billed or under billed to Sandia and discovered subsequent to the billings. This could be due to errors or omissions. This is an opportunity to claim any corrections noted as part of your review. Please provide a detailed explanation in the comments column indicating which cost category the adjustment is in reference to and why the adjustment was made."]
[null,"13.Total Amount Claimed: This will auto populate."]
[null,"14.Comments: Use this column to describe any adjustments or other important aspects of your electronic cost claim."]
[null,"15. Indirect Rates. If Sandia is the cognizant agency and you are claiming and billing indirect rates, then then the DCAA Incurred Cost Electronically (ICE) Model, General Ledger and Financial Statements must be submitted with the ECC. The DCAA ICE is located at https://www.dcaa.mil/.  If Sandia is not the cognizant agency, you are required to provide the latest rate report(s) from the cognizant agency as part of your cost claim.  The rate report sheets may be e-mailed to us. Additionally, please provide the cognizant agency’s contact information including auditor’s name and phone number."]
[null,null,null,null,"Please email any questions to snlaudit@sandia.gov "]
[]
["Submission Requirements "]
["ECCs should be submitted annually for each contract to which Sandia has audit rights. The annual submissions are due within 90 days after a contractor’s fiscal year end.  Please note that it is imperative that you check for accuracy and completeness prior to your submission.  "]
["Please include any indirect rate required information and General Ledger Detail with submission"]
["Additional information and points of contact may be found at the Contract Audit website at: http://www.sandia.gov/working_with_sandia/current_suppliers/contract_audit/index.html"]
["Send ECCs via e-mail to: snlaudit@sandia.gov"]
[]
[]
[]
["Sandia is a multiprogram laboratory operated for the U.S. Department of Energy’s National Nuclear Security Administration"]
["by National Technology and Engineering Solutions of Sandia LLC under Contract DE-NA0003525. "]
[]
[]
[]
[{"$f":"'University ECC Template'!A55","v":"Template Revised: 11/8/2023"}]
["SAND2023-135130"]

{"sheet":"University ECC Template","index":1,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,2,8,3]]}
["Contractor Name",null,null,null,"Please fill out one cost claim template for each auditable contract that you have with Sandia National Laboratories. "]
["Contract Number: "]
["Period of Performance: "]
["Contract Estimated Cost: $"]
[]
["Send to: snlaudit@sandia.gov ","University Fiscal Year End",null,null,"Enter amounts as recorded on your General Ledger (make any corrections in the adjustment row with comments)"]
[null,"Current Fiscal Year"]
[null,null,null,null,{"$f":"EDATE(C6,1)","v":"1900-01-31"},{"$f":"EDATE(E8,1)+1","v":60},{"$f":"EDATE(F8,1)","v":"1900-03-29"},{"$f":"EDATE(G8,1)","v":"1900-04-29"},{"$f":"EDATE(H8,1)","v":"1900-05-29"},"1900-06-29","1900-07-29","1900-08-29","1900-09-29","1900-10-29","1900-11-29","1900-12-29"]
[null,null,"Month",null,{"$f":"TEXT(E8,\"mmmm\")","v":"January"},{"$f":"TEXT(F8,\"mmmm\")","v":"February"},"March","April","May","June","July","August","September","October","November","December"]
[null,null,null,"Accounting Period",1,2,3,4,5,6,7,8,9,10,11,12]
["Account Title","Level of Effort or Non-Level of Effort","GL Acct. Number","Indirect Rate %",null,null,null,null,null,null,null,null,null,null,null,null,"Total Per General Ledger","Adjustments by Cost Element","Total Amount Claimed","Comments",null,null,null,null,null,null,"Labor Category",null,"Fiscal Year End"]
["Academic/Faculty Salaries",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(E12:P12),2)","v":0},0,{"$f":"ROUND(Q12+R12,2)","v":0},null,null,null,null,null,null,null,"Level of Effort",null,"2020-01-31"]
["Faculty Science Lab",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(E13:P13),2)","v":0},0,{"$f":"ROUND(Q13+R13,2)","v":0},null,null,null,null,null,null,null,"Non-Level of Effort",null,"2020-02-28"]
["Graduate Assistants",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-03-31"]
["Hourly Employees",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-04-30"]
["Student Employees",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-30"]
["Academic/Faculty Fringe",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-07-31"]
["Faculty Science Lab Fringe",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-08-31"]
["Graduate Assistants Fringe",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-09-30"]
["Hourly Employees Fringe",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-10-31"]
["Student Employee Fringe",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"2020-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-31"]
["Supplies/Materials",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tuition/Fees",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Domestic Direct Travel",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Foreign Direct Travel",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Direct Costs",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["F&A On-Site - Research",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F&A On-Site - Instruction",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F&A Off-Site - Research",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F&A Off-Site - Instruction",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F&A Other",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Subcontracts",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Capital Equipment",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Non-Capital Equipment",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total per General Ledger",null,null,null,{"$f":"ROUND(SUM(E12:E39),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(R12:R38),2)","v":0},0]
[]
["Adjustments by Month",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Claimed",null,null,null,{"$f":"ROUND(E40+E42,2)","v":0},{"$f":"ROUND(F40+F42,2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S40","v":0}]
[]
[]
[]
[]
[]
["(1) Refer to the Instructions tab for assistance in filling this out."]
["(2) Provide indirect rate substantiation as discussed in the Electronic Cost Claim Instructions if you are claiming any indirect rates."]
["     If you made no payments or have chosen to net any audit findings at the close-out of your contract, please state this in the \"Comments\" section."]
["(3) The adjustments by month should agree with the Adjustments by Cost Elements."]
[]
["Template Revised: 11/8/2023"]

{"sheet":"Subcontractor Summary Template","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,6]]}
["Summary of Subcontractor/Consultant/Temp Labor Charges"]
["List all subcontractors/consultants/temporary labor used on the contract. A cost claim for these may be required during the audit."]
[]
[null,"Dollar Amount"]
["Subcontractor A (Insert name here)",0]
["Subcontractor B  (Insert name here)"]
["Subcontractor C  (Insert name here)"]
["Subtotal",{"$f":"SUM(B5:B7)","v":0}]
[]
["Consultant A  (Insert name here)"]
["Consultant B  (Insert name here)"]
["Subtotal",{"$f":"SUM(B10:B11)","v":0}]
[]
["Temp A  (Insert name here)"]
["Temp B  (Insert name here)"]
["Subtotal",{"$f":"SUM(B14:B15)","v":0}]
[]
["Total Charges",{"$f":"SUM(B8,B12,B16)","v":0}]
[]
[]
[{"$f":"'University ECC Template'!A55","v":"Template Revised: 11/8/2023"}]

{"sheet":"Sample University ECC","index":3,"n_rows":55,"n_cols":28,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,2,8,3]]}
["ABC University",null,null,null,"Please fill out one cost claim template for each auditable contract that you have with Sandia National Laboratories. "]
["Contract Number: 1234"]
["Period of Performance: 01/01/2016-1/01/2022"]
["Contract Estimated Cost: $1,250,000"]
[]
["Send to: snlaudit@sandia.gov ","University Fiscal Year End","2020-06-30",null,"Enter amounts as recorded on your General Ledger (make any corrections in the adjustment row with comments)"]
[null,"Current Fiscal Year",2019]
[null,null,null,null,{"$f":"EDATE(C6,1)","v":"2020-07-30"},{"$f":"EDATE(E8,1)+1","v":"2020-08-31"},{"$f":"EDATE(F8,1)","v":"2020-09-30"},{"$f":"EDATE(G8,1)","v":"2020-10-30"},{"$f":"EDATE(H8,1)","v":"2020-11-30"},"2020-12-30","2021-01-30","2021-02-28","2021-03-28","2021-04-28","2021-05-28","2021-06-28"]
[null,null,"Month",null,{"$f":"TEXT(E8,\"mmmm\")","v":"July"},{"$f":"TEXT(F8,\"mmmm\")","v":"August"},"September","October","November","December","January","February","March","April","May","June"]
[null,null,null,"Accounting Period",1,2,3,4,5,6,7,8,9,10,11,12]
["Account Title","Level of Effort or Non-Level of Effort","GL Acct. Number","Indirect Rate %",null,null,null,null,null,null,null,null,null,null,null,null,"Total Per General Ledger","Adjustments by Cost Element","Total Amount Claimed","Comments",null,null,null,null,null,"Labor Category",null,"Fiscal Year End"]
["Academic/Faculty Salaries","Level of Effort",2011,null,5668.72,4588.8900000000003,10244.44,12654.23,12654.23,10658.98,12654.23,12654.23,10524.32,12654.23,20564.21,12654.23,{"$f":"ROUND(SUM(E12:P12),2)","v":138174.94},0,{"$f":"ROUND(Q12+R12,2)","v":138174.94},null,null,null,null,null,null,"Level of Effort",null,"2020-01-31"]
["Faculty Science Lab","Level of Effort",2011,null,null,null,null,5900,null,5900,null,null,null,null,null,null,{"$f":"ROUND(SUM(E13:P13),2)","v":11800},0,{"$f":"ROUND(Q13+R13,2)","v":11800},null,null,null,null,null,null,"Non-Level of Effort",null,"2020-02-28"]
["Graduate Assistants","Level of Effort",2311,null,5000,5000,0,5000,5000,0,0,5000,0,0,0,0,25000,0,25000,null,null,null,null,null,null,null,null,"2020-03-31"]
["Hourly Employees","Non-Level of Effort",2351,null,1500,0,0,1500,0,1500,1500,0,0,1500,0,0,7500,0,7500,null,null,null,null,null,null,null,null,"2020-04-30"]
["Student Employees",null,2352,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"2020-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-30"]
["Academic/Faculty Fringe",null,2012,0.53,{"$f":"E12*$D$18","v":3004.4216000000001},{"$f":"F12*$D$18","v":2432.1117000000004},5429.5532000000003,6706.7419,6706.7419,5649.2593999999999,6706.7419,6706.7419,5577.8896000000004,6706.7419,10899.031300000001,6706.7419,73232.72,0,73232.72,null,null,null,null,null,null,null,null,"2020-07-31"]
["Faculty Science Lab Fringe",null,2025,0.02,{"$f":"E13*$D$19","v":0},{"$f":"F13*$D$19","v":0},0,118,0,118,0,0,0,0,0,0,236,0,236,null,null,null,null,null,null,null,null,"2020-08-31"]
["Graduate Assistants Fringe",null,2312,0.2,{"$f":"$D$20*E14","v":1000},{"$f":"$D$20*F14","v":1000},{"$f":"$D$20*G14","v":0},1000,1000,0,0,1000,0,0,0,0,5000,0,5000,null,null,null,null,null,null,null,null,"2020-09-30"]
["Hourly Employees Fringe",null,2380,0.01,{"$f":"$D$21*E15","v":15},{"$f":"$D$21*F15","v":0},0,15,0,15,15,0,0,15,0,0,75,0,75,null,null,null,null,null,null,null,null,"2020-10-31"]
["Student Employee Fringe",null,2313,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"2020-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-31"]
["Supplies/Materials",null,"3540/4290",null,500,null,320,0,365,0,0,0,0,0,0,0,1185,-300,885,"Prior audit adjustment for FY 2018, booked in FY 2019"]
["Tuition/Fees",null,4600,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Domestic Direct Travel",null,"3110/3120/3130",null,1153.1400000000001,0,0,0,810.59,0,0,0,0,0,0,0,1963.73,null,1963.73]
["Foreign Direct Travel",null,3111,null,0,0,2500,0,0,0,0,0,0,0,0,0,2500,0,2500]
["Other Direct Costs",null,4350,null,0,895,0,0,0,0,0,0,0,0,0,null,895,0,895]
[]
["F&A On-Site - Research",null,9500,0.49,{"$f":"SUM(E12:E24,E26:E28)*$D$30","v":8742.227984000001},{"$f":"SUM(F12:F24,F26:F28)*$D$30","v":6818.8408330000002},9062.0566680000011,16118.046231000002,13002.915331,11682.207305999998,10229.226231000001,12426.876231,7890.0827040000004,10229.226231000001,15416.988237,9486.8762310000002,131105.57,0,131105.57]
["F&A On-Site - Instruction",null,9501,0.49,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["F&A Off-Site - Research",null,9502,0.26,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["F&A Off-Site - Instruction",null,9503,0.26,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"ROUND(Q33+R33,2)","v":0}]
["F&A Other",null,9504,0.2,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[]
["Subcontracts",null,5250,null,0,0,5000,6000,0,0,0,5000,2700,0,0,0,{"$f":"SUM(E36:P36)","v":18700},0,18700]
["Capital Equipment",null,4578,null,7000,0,0,0,0,0,0,0,0,0,0,0,7000,0,7000]
["Non-Capital Equipment",null,4579,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total per General Ledger",null,null,null,{"$f":"ROUND(SUM(E12:E16,E18:E22,E24:E28,E30:E34,E36:E38),2)","v":33583.51},20734.84,32556.05,55012.02,39539.480000000003,35523.449999999997,31105.200000000001,42787.85,26692.29,31105.200000000001,46880.23,28847.85,424367.97,{"$f":"ROUND(SUM(R12:R38),2)","v":-300},424067.97]
[]
["Adjustments by Month",null,null,null,0,0,0,0,-300,0,0,null,0,0,0,0,0,0]
[]
["Total Claimed",null,null,null,{"$f":"ROUND(E40+E42,2)","v":33583.51},{"$f":"ROUND(F40+F42,2)","v":20734.84},32556.05,55012.02,39239.480000000003,35523.449999999997,31105.200000000001,42787.85,26692.29,31105.200000000001,46880.23,28847.85,{"$f":"ROUND(Q40+Q42,2)","v":424367.97},-300,{"$f":"S40","v":424067.97}]
[]
[]
[]
[]
[]
["(1) Refer to the Instructions tab for assistance in filling this out."]
["(2) Provide indirect rate substantiation as discussed in the Electronic Cost Claim Instructions if you are claiming any indirect rates."]
["     If you made no payments or have chosen to net any audit findings at the close-out of your contract, please state this in the \"Comments\" section."]
["(4) The adjustments by month should agree with the Adjustments by Cost Elements."]
[]
[{"$f":"'University ECC Template'!A55","v":"Template Revised: 11/8/2023"}]

{"sheet":"General Ledger Detail Sample","index":4,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["GL Account Code","Account Name","Cost Category","DESCRIPTION","TRANSACTION DATE","REF.","REV/EXP","Contract #","Month","FY "]
[3120,"COMMON CARRIER","Travel","Smith, Jim","2018-07-04","T878951",989,1234,"Jul",2019]
[3120,"COMMON CARRIER","Travel","Smith, John","2018-07-04","T879174",164.14,1234,"Jul",2019]
[4290,"LD TELEPHONE CHARGE","Materials/Services","Jones, Sam","2018-07-19","T421423",500,1234,"Jul",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-07-30","5511-3",5668.72,1234,"Jul",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-07-30","5511-3",3004.42,1234,"Jul",2019]
[2311,"GRA SALARY","GRA Salary","Smith John","2018-07-30","5504-2",5000,1234,"Jul",2019]
[2312,"GRA FRINGE","GRA Fringe","Smith John","2018-07-30","5504-2",1000,1234,"Jul",2019]
[2351,"HOURLY","HOURLY","Smith Jim","2018-07-30","11354-2",1500,1234,"Jul",2019]
[2380,"HOURLY FRINGE","Hrly Fringe","Smith Jim","2018-07-30","5504-2",15,1234,"Jul",2019]
[4578,"EQUIPMENT","Capital Equip","Jones, Sam","2018-07-31",8578,7000,1234,"Jul",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-07-31",953,8742.23,1234,"Jul",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-08-02","5511-3",4588.8900000000003,1234,"Aug",2019]
[4350,"OTHER DIRECT COSTS","ODC","Smith, John","2018-08-19","T421423",895,1234,"Aug",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-08-29",953,6818.84,1234,"Aug",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-08-30","5511-3",2432.11,1234,"Aug",2019]
[2311,"GRA SALARY","GRA Salary","Smith John","2018-08-30","5504-2",5000,1234,"Aug",2019]
[2312,"GRA FRINGE","GRA Fringe","Smith John","2018-08-30","5504-2",1000,1234,"Aug",2019]
[5250,"SUBCONTRACTS","Subs/Consultants","Subs Inc.","2018-09-19","T42189",5000,1234,"Sept",2019]
[3111,"FORGN TRAVEL","Forgn Travel","Jones, Sam","2018-09-28","T819047",2500,1234,"Sept",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-09-30",5511,10244.44,1234,"Sep",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-09-30","5511-3",5429.55,1234,"Sept",2019]
[3540,"BOOKS/PERIOD/SUBSCRIP","Materials/Services","ABC Book","2018-09-30",402311,320,1234,"Sep",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-09-30",953,9062.06,1234,"Sep",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-10-02","5511-3",6706.74,1234,"Oct",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-10-13",5511,12654.23,1234,"Oct",2019]
[2011,"FACULTY SALARY","Faculty Science Lab","Smith, Joe","2018-10-14","5511-3",5900,1234,"Oct",2019]
[2025,"FACULTY SCIENCE FRINGE","Faculty Sci Fringe","Smith, Joe","2018-10-14","5511-3",118,1234,"Oct",2019]
[5250,"SUBCONTRACTS","Subs/Consultants","Sub 3","2018-10-19","T42190",6000,1234,"Oct",2019]
[2311,"GRA SALARY","GRA Salary","Smith John","2018-10-30","5504-2",5000,1234,"Oct",2019]
[2312,"GRA FRINGE","GRA Fringe","Smith Jim","2018-10-30","11354-2",1000,1234,"Oct",2019]
[2351,"HOURLY","HOURLY","Smith Jim","2018-10-30","11354-2",1500,1234,"Oct",2019]
[2380,"HOURLY FRINGE","Hrly Fringe","Smith Jim","2018-10-30","5504-2",15,1234,"Oct",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-10-31",953,16118.05,1234,"Oct",2019]
[3110,"MISC TRAVEL","Travel","Jones, Sam","2018-11-02","T819047",175.42,1234,"Nov",2019]
[3110,"MISC TRAVEL","Travel","Jones, Sam","2018-11-02","T819047",-9,1234,"Nov",2019]
[3110,"MISC TRAVEL","Travel","Jones, Sam","2018-11-02","T819047",-23,1234,"Nov",2019]
[3130,"OSET PER DIEM","Travel","Jones, Sam","2018-11-02","T819047",667.17,1234,"Nov",2019]
[3540,"BOOKS/PERIOD/SUBSCRIP","Materials/Services","ABC Book","2018-11-03",404275,365,1234,"Nov",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-11-15",5511,12654.23,1234,"Nov",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-11-21","5511-3",6706.74,1234,"Nov",2019]
[2311,"GRA SALARY","GRA Salary","Smith John","2018-11-30","5504-2",5000,1234,"Nov",2019]
[2312,"GRA FRINGE","GRA Fringe","Smith John","2018-11-30","11354-3",1000,1234,"Nov",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-11-30",953,13002.92,1234,"Nov",2019]
[2025,"FACULTY SCIENCE FRINGE","Faculty Sci Fringe","Smith, Joe","2018-12-14","5511-3",118,1234,"Dec",2019]
[2011,"FACULTY SALARY","Faculty Science Lab","Smith, Joe","2018-12-15","5511-3",5900,1234,"Dec",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2018-12-15",5511,10658.98,1234,"December",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2018-12-28","5511-3",5649.26,1234,"Dec",2019]
[2351,"HOURLY","HOURLY","Smith Jim","2018-12-30","11354-2",1500,1234,"Dec",2019]
[2380,"HOURLY FRINGE","Hrly Fringe","Smith Jim","2018-12-30","5504-2",15,1234,"Dec",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2018-12-31",953,11682.21,1234,"Dec",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-01-13",5511,12654.23,1234,"January",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-01-15","5511-3",6706.74,1234,"Jan",2019]
[2351,"HOURLY","HOURLY","Smith Jim","2019-01-30","11354-2",1500,1234,"Jan",2019]
[2380,"HOURLY FRINGE","Hrly Fringe","Smith Jim","2019-01-30","5504-2",15,1234,"Jan",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-01-30",953,10229.23,1234,"Jan",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-02-16",5511,12654.23,1234,"February",2019]
[5250,"SUBCONTRACTS","Subs/Consultants","A123 Inc.","2019-02-19","T5782",5000,1234,"Feb",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-02-28","5511-3",6706.74,1234,"Feb",2019]
[2311,"GRA SALARY","GRA Salary","Smith John","2019-02-28","5504-2",5000,1234,"Feb",2019]
[2312,"GRA FRINGE","GRA Fringe","Smith John","2019-02-28","11354-3",1000,1234,"Feb",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-02-28",953,12426.88,1234,"Feb",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-03-17",5511,10524.32,1234,"March",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-03-18","5511-3",5577.89,1234,"Mar",2019]
[5250,"SUBCONTRACTS","Subs/Consultants","123 Inc.","2019-03-19","T42245",2700,1234,"Mar",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-03-31",953,7890.08,1234,"Mar",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-04-12",5511,12654.23,1234,"April",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-04-26","5511-3",6706.74,1234,"April",2019]
[2351,"HOURLY","HOURLY","Smith Jim","2019-04-30","11354-2",1500,1234,"April",2019]
[2380,"HOURLY FRINGE","Hrly Fringe","Smith Jim","2019-04-30","5504-2",15,1234,"April",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-04-30",953,10229.23,1234,"April",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-05-14",5511,20564.21,1234,"May",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-05-30",5511,10899.03,1234,"May",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-05-30",953,15416.99,1234,"May",2019]
[2011,"FACULTY SALARY","Faculty Salary","Jones, Sam","2019-06-15",5511,12654.23,1234,"June",2019]
[2012,"FACULTY FRINGE","Faculty Fringe","Jones, Sam","2019-06-30",5511,6706.74,1234,"Jun",2019]
[9500,"FAC & ADM CHARGE","F&A ","Indirect Costs","2019-06-30",953,9486.8799999999992,1234,"Jun",2019]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G2:G78)","v":424367.97000000003}]
[]
[]
[]
[]
[{"$f":"'University ECC Template'!A55","v":"Template Revised: 11/8/2023"}]
[{"$f":"'University ECC Template'!A56","v":0}]

{"sheet":"Sample Subcontractor Summary ","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Summary of Subcontractor/Consultant/Temp Labor Charges"]
[]
[null,null,null,null,"This is a Sample \"Summary of Subcontractor/Consultant/Temp Labor Charges\" - (These numbers serve only as an example)"]
[null,"Dollar Amount",null,null,"Use the \"Subcontractor Summary Template\" Sheet"]
["Subcontractor A",5500]
["Subcontractor B",4500]
["Subcontractor C",7300]
["Subtotal",{"$f":"SUM(B5:B7)","v":17300}]
[]
["Consultant A",1100]
["Consultant B",300]
["Subtotal",{"$f":"SUM(B10:B11)","v":1400}]
[]
["Temp A"]
["Temp B"]
["Subtotal",{"$f":"SUM(B14:B15)","v":0}]
[]
["Total Charges",{"$f":"SUM(B8,B12,B16)","v":18700}]
[]
[]
["Total Charges need to reconcile to the total Subcontractor/Consultant/Temp Labor Charges on your ECC."]
[]
["During an audit, a detailed ECC may be required for any of the subcontractors/consultants/temp labor listed above."]
[]
[{"$f":"'University ECC Template'!A55","v":"Template Revised: 11/8/2023"}]