{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FSRgr","Explanations "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":54,"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":"FSRgr","index":0,"n_rows":142,"n_cols":24,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[null,"%,AFF,FACCOUNT,UACCOUNT","%,AFF,FDESCR,UDESCR","%,QNIU_GL_FSRACTUAL_GFA_NS,CFIELD1_4,SPER",null,"%,QNIU_GL_FSRBUDGETF_NS,CA.POSTED_TOTAL_AMT,SLTD,R","%,QNIU_GL_FSROBLIGATION_NS,CA.POSTED_TOTAL_AMT,SYTD","%,QNIU_GL_FSRACTUAL_GFA_NS,CFIELD1_4,SYTD",null,null,null,null,null,null,null,null,null,null,null,"","",null,"",""]
[null,{"$f":"\"Business Unit:  \" &RBU","v":"Business Unit:  NIUDK"},null,null,null,"Financial Summary Report ",null,{"$f":"\"Report ID: \"&RID","v":"Report ID: FSRGRANT"},null,null,null,"Chemistry and Biochemistry","NIUDK"]
[null,"Manager :  Principal Investigator",null,null,null,{"$f":"IF(PER <> 998,TEXT(ASOD,\"mmmm\"),\"Adjustments\") &\" of FY \" &FY","v":"December of FY 2020"},null,"Project Dates: 09/01/2018-09/01/2023",null,null,null,"Klumpp,Douglas A","G1A62670"]
[null,"Project: G9B12345   Sponsored Programs Adminisration",null,null,null,{"$f":"\"Run Date: \" &TEXT(NvsEndTime,\"mmmm dd, yyyy at HH:MM AM/PM\")","v":"Run Date: January 09, 2020 at 06:17 PM"},null,{"$f":"\"Fund : \" & fund & \" - \" & fund_descr","v":"Fund : 44 - Current Restricted Funds"},null,null,null,"Current Restricted Funds","2020"]
[null,null,null,null,null,null,null,null,null,null,null,"2018-09-20","2019-12-31"]
[null,null,null,{"$f":"\"Activity of \"&IF(PER <> 998,TEXT(ASOD,\"mmmm\"),\"Adjustments\") &\" of FY \" &FY","v":"Activity of December of FY 2020"},null,null,null,{"$f":"\"As of \"&IF(PER <> 998,TEXT(ASOD,\"mmmm\"),\"Adjustments\") &\" of FY \" &FY","v":"As of December of FY 2020"},null,null,null,"2021-08-31","Period 6 - 2019-12-01",{"$f":"TEXT(M5,\"MMMM D, YYYY\")","v":"December 31, 2019"},null,"",{"$f":"TEXT(P6,\"MM/DD/YY\")","v":""}]
[null,"Assets",null,null,null,null,null,null,null,null,null,"44","FSRGRANT","6","Northern Illinois University"]
[".",null,"Cash",{"$f":"ROUND((-1*(D19+D10)),2)","v":30943.23},null,null,null,{"$f":"ROUND((-1*(H19+H10)),2)","v":-4963.1000000000004}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NNON-CASH_ASSETS",null,"Non-Cash Assets",0,null,0,0,0,null,null,null,null,null,null,null,"Project Dates :  - "]
[]
[null,null,"Total Assets",{"$f":"ROUND((D8+D10),2)","v":30943.23},{"$f":"D8:D10","v":{"$error":"#VALUE!"}},null,null,{"$f":"ROUND((H8+H10),2)","v":-4963.1000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project : %APN% - "]
[null,"Liabilities and Fund Equity (FE)"]
["%,FACCOUNT,TACCOUNT_RPT,X,NLIABILITIES",null,"Liabilities",0,null,0,0,0]
[]
[null,null,"Chg to FE (Rev. - Exp.)",{"$f":"ROUND((D32+D137),2)","v":-30943.23},null,null,null,{"$f":"ROUND((H32+H137),2)","v":4963.1000000000004}]
[]
[null,null,"Total Liabilities and Equity",{"$f":"ROUND((D15+D17),2)","v":-30943.23},null,null,null,{"$f":"ROUND((H15+H17),2)","v":4963.1000000000004}]
[]
[]
[]
[null,null,null,"Period",null,"Project",null,"Project","Available"]
[null,null,null,"Actual",null,"Budget","Obligations","To Date","Budget"]
[]
[null,"Revenues & Transfers"]
["%,V452650","452650","Recpts From Fed Grants/Contrct",-35906.33,null,-420529,0,-87362.11]
["%,FACCOUNT,TACCOUNT_RPT,X,NREVENUE",null,"Revenue",-35906.33,null,-420529,0,-87362.11,{"$f":"IF(FundNo=\"X\",F28-(G28+H28),F28-(G28+H28))","v":-333166.89}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NTRANSFERS",null,"Transfers",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F30-(G30+H30),F30-(G30+H30))","v":0}]
[]
[null,null,"Total Revenues & Transfers",{"$f":"D28+D30","v":-35906.33},null,{"$f":"F28+F30","v":-420529},{"$f":"G28+G30","v":0},{"$f":"H28+H30","v":-87362.11},{"$f":"I28+I30","v":-333166.89}]
[]
[null,"Direct Expenses"]
["%,FACCOUNT,TACCOUNT_RPT,X,NCOGS",null,"Cost of Goods Sold",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F35-(G35+H35),F35-(G35+H35))","v":0}]
[]
[null,"Personnel Services",null,null,null,null,null,null,{"$f":"IF(FundNo=\"X\",F37-(G37+H37),F37-(G37+H37))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NAPPROP_FUNDS_PAYROLL",null,"Appropriated Funds Payroll",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F39-(G39+H39),F39-(G39+H39))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NSERVICE_DEPARTMENT",null,"Service Department",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F41-(G41+H41),F41-(G41+H41))","v":0}]
[]
["%,V641000","641000","Pers Svc-Faculty",0,null,32575,0,11535.14]
["%,FACCOUNT,TACCOUNT_RPT,X,NREG_FACULTY_STAFF",null,"Regular Faculty",0,null,32575,0,11535.14,{"$f":"IF(FundNo=\"X\",F44-(G44+H44),F44-(G44+H44))","v":21039.86}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NFACULTY_SUMMER",null,"Faculty Summer",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F46-(G46+H46),F46-(G46+H46))","v":0}]
[]
["%,V644000","644000","Pers Svc-Grad Asst",1357.63,null,143593,24437.34,28223.85]
["%,FACCOUNT,TACCOUNT_RPT,X,NGRADUATE_ASSISTANTS",null,"Graduate Assistants",1357.63,null,143593,24437.34,28223.85,{"$f":"IF(FundNo=\"X\",F49-(G49+H49),F49-(G49+H49))","v":90931.81}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NGRAD_ASSISTANTS_SUMM",null,"Graduate Assistants Summer",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F51-(G51+H51),F51-(G51+H51))","v":0}]
[]
["%,V646000","646000","Pers Svc-Extra Help",671,null,0,0,1394.25]
["%,FACCOUNT,TACCOUNT_RPT,X,NEXTRA_HELP",null,"Extra Help",671,null,0,0,1394.25,{"$f":"IF(FundNo=\"X\",F54-(G54+H54),F54-(G54+H54))","v":-1394.25}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NOPERATING_STAFF",null,"Operating Staff",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F56-(G56+H56),F56-(G56+H56))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NOVERTIME",null,"Overtime",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F58-(G58+H58),F58-(G58+H58))","v":0}]
[]
["%,V648100","648100","Pers Svc-Students",0,null,18362,0,3744]
["%,FACCOUNT,TACCOUNT_RPT,X,NPERS_SVC_STUDENTS",null,"Personal Services - Students",0,null,18362,0,3744,{"$f":"IF(FundNo=\"X\",F61-(G61+H61),F61-(G61+H61))","v":14618}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NWORKSTUDY",null,"Work Study",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F63-(G63+H63),F63-(G63+H63))","v":0}]
[]
["%,V660100","660100","Retirement",0,null,6128,0,1420.84]
["%,V660130","660130","FICA",51.32,null,0,0,557.70000000000005]
["%,FACCOUNT,TACCOUNT_RPT,X,NALL_STAFF_BENEFITS",null,"All Staff Benefits",51.32,null,6128,0,1978.54,{"$f":"IF(FundNo=\"X\",F67-(G67+H67),F67-(G67+H67))","v":4149.46}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NLEAVE_BENEFIT_PAYOUT",null,"Sick/Vacation Payout",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F69-(G69+H69),F69-(G69+H69))","v":0}]
[]
[null,null,"Total Personnel Services",{"$f":"D39+D41+D44+D46+D49+D51+D54+D56+D58+D61+D63+D67+D69","v":2079.9500000000003},null,{"$f":"F39+F41+F44+F46+F49+F51+F54+F56+F58+F61+F63+F67+F69","v":200658},{"$f":"G39+G41+G44+G46+G49+G51+G54+G56+G58+G61+G63+G67+G69","v":24437.34},{"$f":"H39+H41+H44+H46+H49+H51+H54+H56+H58+H61+H63+H67+H69","v":46875.78},{"$f":"IF(FundNo=\"X\",F71-(G71+H71),F71-(G71+H71))","v":129344.88}]
[]
["%,V670330","670330","Student travel-reimb student",0,null,0,0,36.1]
["%,V690015","690015","R&M,Scientific/Medical Eqpmnt",0,null,0,0,259.2]
["%,V690050","690050","R&M,All Oth-inc music instrmts",0,null,0,1256,0]
["%,FACCOUNT,TACCOUNT_RPT,X,NALL_CONTRACTUAL_SVC",null,"Contractual Services",0,null,0,1256,295.3,{"$f":"IF(FundNo=\"X\",F76-(G76+H76),F76-(G76+H76))","v":-1551.3}]
[]
["%,V800210","800210","Office/Library Supplies-exc fa",0,null,0,0,42.79]
["%,V800220","800220","Scientific & Lab Supplies",1127.9000000000001,null,37820,7217.89,13176.98]
["%,V800320","800320","Med,Scient,Lab Eqp,$100 limit",0,null,0,0,231.34]
["%,FACCOUNT,TACCOUNT_RPT,X,NCOMMODITIES",null,"Commodities",1127.9000000000001,null,37820,7217.89,13451.11,{"$f":"IF(FundNo=\"X\",F81-(G81+H81),F81-(G81+H81))","v":17151}]
[]
["%,V830610","830610","Travel - Grants Administration",0,null,7500,0,0]
["%,FACCOUNT,TACCOUNT_RPT,X,NTRAVEL",null,"Travel",0,null,7500,0,0,{"$f":"IF(FundNo=\"X\",F84-(G84+H84),F84-(G84+H84))","v":7500}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NAUTOMOTIVE",null,"Automotive",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F86-(G86+H86),F86-(G86+H86))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NAWARDS_GRANTS",null,"Awards and Grants",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F88-(G88+H88),F88-(G88+H88))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NMATCHING_FUNDS",null,"Matching Funds",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F90-(G90+H90),F90-(G90+H90))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NSCHLRSHP/AWRD_NON_GR",null,"Scholarship/Award,Non-GR Funds",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F92-(G92+H92),F92-(G92+H92))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NGRANTS_IN_AID",null,"Grants-In-Aid",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F94-(G94+H94),F94-(G94+H94))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NALL_TELECOMM",null,"All Telecommunications",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F96-(G96+H96),F96-(G96+H96))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NEQUIPMENT/LIBRARY",null,"Equipment/Library Books",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F98-(G98+H98),F98-(G98+H98))","v":0}]
[]
["%,V860235","860235","Institutional Support",0,null,54022,0,3570]
["%,FACCOUNT,TACCOUNT_RPT,X,NINST_SUPPORT",null,"Institutional Support",0,null,54022,0,3570,{"$f":"IF(FundNo=\"X\",F101-(G101+H101),F101-(G101+H101))","v":50452}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NCAP_REPR/PERM_IMP",null,"Capital Repair/Perm Improv",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F103-(G103+H103),F103-(G103+H103))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NOTHER_EXPENSES",null,"Other Expenses",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F105-(G105+H105),F105-(G105+H105))","v":0}]
[]
[null,null,"Total Direct Expenses",{"$f":"D71+D76+D81+D84+D86+D88+D90+D92+D94+D96+D98+D101+D103+D105","v":3207.8500000000004},null,{"$f":"F71+F76+F81+F84+F86+F88+F90+F92+F94+F96+F98+F101+F103+F105","v":300000},{"$f":"G71+G76+G81+G84+G86+G88+G90+G92+G94+G96+G98+G101+G103+G105","v":32911.230000000003},{"$f":"H71+H76+H81+H84+H86+H88+H90+H92+H94+H96+H98+H101+H103+H105","v":64192.19},{"$f":"IF(FundNo=\"X\",F107-(G107+H107),F107-(G107+H107))","v":202896.58}]
[]
[null,"Indirect Expenses"]
["%,FACCOUNT,TACCOUNT_RPT,X,NOVERHEAD_EXP",null,"Overhead Expenses",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F110-(G110+H110),F110-(G110+H110))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NDIRECT_OVRHEAD_COSTS",null,"Direct Overhead Costs",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F112-(G112+H112),F112-(G112+H112))","v":0}]
[]
["%,V901200","901200","Indirect Overhead Costs",1755.25,null,120529,0,28133.02]
["%,FACCOUNT,TACCOUNT_RPT,X,NINDIRECT_COST",null,"Indirect Costs",1755.25,null,120529,0,28133.02,{"$f":"IF(FundNo=\"X\",F115-(G115+H115),F115-(G115+H115))","v":92395.98}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NMISC_BOND_EXP",null,"Misc Expenses & Debt Service",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F117-(G117+H117),F117-(G117+H117))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NPHYSPLNT_OHEAD_COSTS",null,"Physical Plant Overhead Costs",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F119-(G119+H119),F119-(G119+H119))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NWRITE-OFF_NONTAG",null,"Write-Off Non-Taggable Eqpment",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F121-(G121+H121),F121-(G121+H121))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NREAL/UNREAL_LOSS",null,"Realized/Unrealized Loss",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F123-(G123+H123),F123-(G123+H123))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NRESERVE_TSF",null,"Reserve Transfers",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F125-(G125+H125),F125-(G125+H125))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NEQUIPMNT_RES",null,"Equipment Reserves",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F127-(G127+H127),F127-(G127+H127))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NSTUDENT_INSURANCE",null,"Student Insurance",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F129-(G129+H129),F129-(G129+H129))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NSTDNT_LOAN_CANCEL",null,"Student Loan Cancellations/Exp",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F131-(G131+H131),F131-(G131+H131))","v":0}]
[]
["%,FACCOUNT,TACCOUNT_RPT,X,NEXPENSE_UNDEFND",null,"Expense Not Defined",0,null,0,0,0,{"$f":"IF(FundNo=\"X\",F133-(G133+H133),F133-(G133+H133))","v":0}]
[]
[null,null,"Total Indirect Expenses",{"$f":"D110+D112+D115+D117+D119+D121+D123+D125+D127+D129+D131+D133","v":1755.25},null,{"$f":"F110+F112+F115+F117+F119+F121+F123+F125+F127+F129+F131+F133","v":120529},{"$f":"G110+G112+G115+G117+G119+G121+G123+G125+G127+G129+G131+G133","v":0},{"$f":"H110+H112+H115+H117+H119+H121+H123+H125+H127+H129+H131+H133","v":28133.02},{"$f":"IF(FundNo=\"X\",F135-(G135+H135),F135-(G135+H135))","v":92395.98}]
[]
["EOF",null,"Total Expenses",{"$f":"D35+D71+D76+D81+D84+D86+D88+D90+D92+D94+D96+D98+D101+D103+D105+D108+D110+D112+D115+D117+D119+D121+D123+D125+D127+D129+D131+D133","v":4963.1000000000004},null,{"$f":"F35+F71+F76+F81+F84+F86+F88+F90+F92+F94+F96+F98+F101+F103+F105+F108+F110+F112+F115+F117+F119+F121+F123+F125+F127+F129+F131+F133","v":420529},{"$f":"G35+G71+G76+G81+G84+G86+G88+G90+G92+G94+G96+G98+G101+G103+G105+G108+G110+G112+G115+G117+G119+G121+G123+G125+G127+G129+G131+G133","v":32911.230000000003},{"$f":"H35+H71+H76+H81+H84+H86+H88+H90+H92+H94+H96+H98+H101+H103+H105+H108+H110+H112+H115+H117+H119+H121+H123+H125+H127+H129+H131+H133","v":92325.21},{"$f":"IF(FundNo=\"X\",F137-(G137+H137),F137-(G137+H137))","v":295292.56}]
[]
[]
[]
[]
[null,"                                      See next page for explanations on reading the FSR"]

{"sheet":"Explanations ","index":1,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[1,"Period Actual","Expenditures for month"]
[null,3207.85]
[]
[]
[2,"Budget","Award budget entered into the financial system using NIU account codes. "]
[null,300000,"It may not be exactly aligned with the internal/agency budget categories."]
[]
[]
[3,"Obligations ","Obligations that have not yet been charged to your award. "]
[null,32911.230000000003,"Obligations typically consist of personnel, purchase requisitions, subawards, and contracts. "]
[null,null,"Personnel obligations are for the full contract of an employee through the current fiscal year. "]
[null,null,"Fringes associated with personnel are NOT obligated. "]
[null,null,"Obligations are only for the current Fiscal Year."]
[]
[]
[4,"Project To Date","The cumulative total of all expenses that have been charged to the award since it began."]
[null,64192.19,"The far left of the FSR there is a list of Direct Expenses, this is a break down of the award budget & expenses"]
[null,null,"using NIU account codes. "]
[null,null,"Current fiscal year details on expenses can be found in the monthly HR report, the period detail report "]
[null,null," and the obligations report. "]
[]
[5,"Available Budget","Funds available to spend. "]
[null,202896.58,"The available budget is the sum of:"]
[null,null,300000,"Project Budget"]
[null,null,"-$32,911.23","Obligations"]
[null,null,"-$64,192.19","Project to Date "]
[null,null,202896.58,"Available Budget"]
[null,null," ***Reports only reflect what is in the financial system. "]
[null,null,"Any expense still in the approval process will NOT be accounted for in the reports.*** "]
[]
[]
[]
["Contact your GCA if you have questions about:"]
["Reports"]
["Invoicing"]
["Revenue"]
["Indirects"]
["Expenses Crossing Fiscal Years"]