{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["1st Advance Payment","INVOICE 1","INVOICE 2","INVOICE 3","INVOICE 4","INVOICE 5","INVOICE 6","INVOICE 7","INVOICE 8","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","INVOICE 13","INVOICE 14","INVOICE 15","2nd Advance Payment","3rd Advance Payment","MODIFICATION REQUEST","Project Budget","INVOICE DUE DATES","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":33,"macros":1,"external_links":0,"defined_names":25,"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":"1st Advance Payment","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,2,30,4],[29,2,29,4],[0,5,2,7],[12,6,14,11],[22,0,22,3],[22,6,22,10],[26,0,26,3],[17,0,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[26,6,26,10],[5,2,5,4],[12,2,12,3],[14,2,14,3],[7,2,7,4],[35,2,35,4],[36,2,36,4],[33,8,33,10],[31,8,31,10],[34,2,34,4],[31,2,31,4],[33,2,33,4],[7,8,7,11],[9,8,9,11],[0,9,0,11],[1,9,1,11],[5,8,5,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,{"$f":"'INVOICE 15'!L2","v":"Purchase Order: 2928"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:","Adult Reentry Grant ",null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"Victor Valley Family Resource Center"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 430-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 1248"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,{"$f":"'INVOICE 15'!L58","v":"Victorville, CA 92393"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #","1 ARG  2019",null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #",1]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",{"$f":"'INVOICE 15'!B23","v":3000000}]
[null,null,null,null,null,null,null,null,null,"1st Advance Total:",{"$f":"SUM(ROUNDUP(K19/3,0))","v":1000000}]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"SUM(K19-K20)","v":2000000}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Colleen Stoner",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'INVOICE 15'!L54","v":"VICTORVALL-020"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2020-03-06",null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146536}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"INVOICE 1","index":1,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[44,11,44,13],[45,11,45,13],[46,11,46,13],[47,11,47,13],[54,0,54,2],[53,11,53,13],[55,11,55,13],[57,11,57,13],[45,3,45,10],[46,0,47,0],[51,0,51,2],[53,0,53,2],[55,0,55,2],[56,0,56,2],[52,0,52,2],[50,0,50,2],[49,0,49,2],[46,3,46,10],[48,0,48,1],[34,0,35,0],[12,0,13,0],[12,1,12,3],[12,4,12,6],[25,0,25,12],[31,3,31,10],[30,0,30,2],[32,0,33,0],[32,3,32,10],[33,3,33,10],[34,3,34,10],[35,3,35,10],[27,11,27,12],[26,11,26,12],[31,11,31,13],[32,11,32,13],[41,3,41,10],[36,3,36,10],[37,3,37,10],[42,0,43,0],[44,0,45,0],[38,3,38,10],[39,3,39,10],[40,3,40,10],[43,3,43,10],[44,3,44,10],[42,3,42,10],[40,0,41,0],[36,0,37,0],[38,0,39,0],[43,11,43,13],[65,4,65,9],[49,4,49,9],[48,3,48,13],[54,11,54,13],[49,11,49,13],[59,11,59,13],[60,11,60,13],[50,4,59,9],[60,4,60,9],[56,11,56,13],[52,11,52,13],[51,11,51,13],[47,3,47,10],[65,10,65,12],[63,4,63,9],[38,11,38,13],[39,11,39,13],[40,11,40,13],[41,11,41,13],[42,11,42,13],[0,11,0,13],[1,11,1,13],[6,6,6,8],[4,10,6,13],[12,13,13,13],[8,12,8,13],[12,10,12,12],[0,5,2,7],[12,7,12,9],[33,11,33,13],[36,11,36,13],[37,11,37,13],[34,11,34,13],[35,11,35,13],[69,0,69,7],[67,0,67,12],[57,0,57,2],[58,0,58,2],[68,0,68,1],[68,6,68,7],[58,11,58,13],[64,10,64,12],[62,4,62,9],[64,4,64,9],[61,4,61,9],[68,8,68,10],[69,8,69,10],[65,0,65,2]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order: 2928"]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:","Victor Valley Family Resource Center",null,null,null,"Project Title:","RA"]
[]
["Contract #:","BSCC 430-19",null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",1,null,"Reporting Period:","2019-08-01","TO","2019-09-30","Due:","2019-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",684800,0,{"$f":"SUM(B15:C15)","v":684800},0,0,{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},{"$f":"C15-F15-I15","v":0},{"$f":"SUM(K15:L15)","v":684800},"1st Advance [3/6/20]"]
["Services & Supplies",2150000,0,2150000,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'1st Advance Payment'!K20","v":1000000}]
["Professional Services",0,0,0,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",0,0,0,0,0,0,0,0,0,0,0,0,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",7000,0,7000,0,0,0,0,0,0,7000,0,7000,0]
["Data Collection & Progress Reporting",18950,0,18950,0,0,0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",5000,0,5000,0,0,0,0,0,0,5000,0,5000,"3rd Advance\n [enter date]"]
["Indirect Costs",134250,0,{"$f":"SUM(B22:C22)","v":134250},0,0,0,0,0,0,134250,0,134250,0]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Sharon Green",null,null,null,null,null,null,null,null,null,null,146536]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["760-887-1909",null,null,null,null,null,null,null,null,null,null,"VICTORVALL-020"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sgreen@vvfrc.com",null,null,null,null,null,null,null,null,null,null,"P.O. Box 1248"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-03-27",null,null,null,null,null,null,null,null,null,null,"Victorville, CA 92393"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"MaryAnn McKinney-CFO"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"760-669-0300"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-03-27"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-03-27",null,null,null,"Approved By:",null,"Colleen Stoner",null,null,null,"Date: ","2020-08-02"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 2","index":2,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 1'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",2,null,"Reporting Period:","2019-10-01","TO","2019-12-31","Due:","2020-02-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":684800},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 1'!E15,'INVOICE 1'!H15)","v":0},{"$f":"SUM('INVOICE 1'!F15,'INVOICE 1'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 1'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":2150000},{"$f":"'INVOICE 1'!C16","v":0},2150000,{"$f":"SUM('INVOICE 1'!E16,'INVOICE 1'!H16)","v":0},{"$f":"SUM('INVOICE 1'!F16,'INVOICE 1'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 1'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":0},0,{"$f":"SUM('INVOICE 1'!E17,'INVOICE 1'!H17)","v":0},{"$f":"SUM('INVOICE 1'!F17,'INVOICE 1'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":0},{"$f":"'INVOICE 1'!C18","v":0},0,{"$f":"SUM('INVOICE 1'!E18,'INVOICE 1'!H18)","v":0},{"$f":"SUM('INVOICE 1'!F18,'INVOICE 1'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 1'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":7000},{"$f":"'INVOICE 1'!C19","v":0},7000,{"$f":"SUM('INVOICE 1'!E19,'INVOICE 1'!H19)","v":0},{"$f":"SUM('INVOICE 1'!F19,'INVOICE 1'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 1'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 1'!B20","v":18950},{"$f":"'INVOICE 1'!C20","v":0},18950,{"$f":"SUM('INVOICE 1'!E20,'INVOICE 1'!H20)","v":0},{"$f":"SUM('INVOICE 1'!F20,'INVOICE 1'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 1'!B21","v":5000},{"$f":"'INVOICE 1'!C21","v":0},5000,{"$f":"SUM('INVOICE 1'!E21,'INVOICE 1'!H21)","v":0},{"$f":"SUM('INVOICE 1'!F21,'INVOICE 1'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 1'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 1'!B22","v":134250},{"$f":"'INVOICE 1'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 1'!E22,'INVOICE 1'!H22)","v":0},{"$f":"SUM('INVOICE 1'!F22,'INVOICE 1'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 1'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I15","v":0},"N/A"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0},null,null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I20","v":0},"N/A"]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I21","v":0},"N/A"]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I22","v":0},"N/A"]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Sharon Green, CEO",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["760-887-1909",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sgreen@vvfrc.com",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["                        10/5/2020",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"MaryAnn Cross-McKinney, CFO"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"951-422-1711"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-11-19"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-02-04",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-08-17"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 3","index":3,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 2'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 2'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 2'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",3,null,"Reporting Period:","2020-01-01","TO","2020-03-31","Due:","2020-05-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 2'!B15","v":684800},{"$f":"'INVOICE 2'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 2'!E15,'INVOICE 2'!H15)","v":0},{"$f":"SUM('INVOICE 2'!F15,'INVOICE 2'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 2'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":2150000},{"$f":"'INVOICE 2'!C16","v":0},2150000,{"$f":"SUM('INVOICE 2'!E16,'INVOICE 2'!H16)","v":0},{"$f":"SUM('INVOICE 2'!F16,'INVOICE 2'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 2'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 2'!B17","v":0},{"$f":"'INVOICE 2'!C17","v":0},0,{"$f":"SUM('INVOICE 2'!E17,'INVOICE 2'!H17)","v":0},{"$f":"SUM('INVOICE 2'!F17,'INVOICE 2'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 2'!B18","v":0},{"$f":"'INVOICE 2'!C18","v":0},0,{"$f":"SUM('INVOICE 2'!E18,'INVOICE 2'!H18)","v":0},{"$f":"SUM('INVOICE 2'!F18,'INVOICE 2'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 2'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 2'!B19","v":7000},{"$f":"'INVOICE 2'!C19","v":0},7000,{"$f":"SUM('INVOICE 2'!E19,'INVOICE 2'!H19)","v":0},{"$f":"SUM('INVOICE 2'!F19,'INVOICE 2'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 2'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 2'!B20","v":18950},{"$f":"'INVOICE 2'!C20","v":0},18950,{"$f":"SUM('INVOICE 2'!E20,'INVOICE 2'!H20)","v":0},{"$f":"SUM('INVOICE 2'!F20,'INVOICE 2'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 2'!B21","v":5000},{"$f":"'INVOICE 2'!C21","v":0},5000,{"$f":"SUM('INVOICE 2'!E21,'INVOICE 2'!H21)","v":0},{"$f":"SUM('INVOICE 2'!F21,'INVOICE 2'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 2'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 2'!B22","v":134250},{"$f":"'INVOICE 2'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 2'!E22,'INVOICE 2'!H22)","v":0},{"$f":"SUM('INVOICE 2'!F22,'INVOICE 2'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 2'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 2'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I15","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I16","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I19","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I20","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I21","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
[null,"Project Income",{"$f":"I22","v":0},"N/A",null,null,null,null,null,null,null,"Funds not Received"]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Sharon Green, CEO",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["760-887-1909",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["Sharon Green, CEO",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-11-19",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"MaryAnn Cross-McKinney"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"951-422-1711"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-11-19"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-02-04",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-08-17"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","index":4,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 3'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 3'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 3'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",4,null,"Reporting Period:","2020-04-01","TO","2020-06-30","Due:","2020-08-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 3'!B15","v":684800},{"$f":"'INVOICE 3'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 3'!E15,'INVOICE 3'!H15)","v":0},{"$f":"SUM('INVOICE 3'!F15,'INVOICE 3'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 3'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":2150000},{"$f":"'INVOICE 3'!C16","v":0},2150000,{"$f":"SUM('INVOICE 3'!E16,'INVOICE 3'!H16)","v":0},{"$f":"SUM('INVOICE 3'!F16,'INVOICE 3'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 3'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 3'!B17","v":0},{"$f":"'INVOICE 3'!C17","v":0},0,{"$f":"SUM('INVOICE 3'!E17,'INVOICE 3'!H17)","v":0},{"$f":"SUM('INVOICE 3'!F17,'INVOICE 3'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 3'!B18","v":0},{"$f":"'INVOICE 3'!C18","v":0},0,{"$f":"SUM('INVOICE 3'!E18,'INVOICE 3'!H18)","v":0},{"$f":"SUM('INVOICE 3'!F18,'INVOICE 3'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 3'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 3'!B19","v":7000},{"$f":"'INVOICE 3'!C19","v":0},7000,{"$f":"SUM('INVOICE 3'!E19,'INVOICE 3'!H19)","v":0},{"$f":"SUM('INVOICE 3'!F19,'INVOICE 3'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 3'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 3'!B20","v":18950},{"$f":"'INVOICE 3'!C20","v":0},18950,{"$f":"SUM('INVOICE 3'!E20,'INVOICE 3'!H20)","v":0},{"$f":"SUM('INVOICE 3'!F20,'INVOICE 3'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 3'!B21","v":5000},{"$f":"'INVOICE 3'!C21","v":0},5000,{"$f":"SUM('INVOICE 3'!E21,'INVOICE 3'!H21)","v":0},{"$f":"SUM('INVOICE 3'!F21,'INVOICE 3'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 3'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 3'!B22","v":134250},{"$f":"'INVOICE 3'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 3'!E22,'INVOICE 3'!H22)","v":0},{"$f":"SUM('INVOICE 3'!F22,'INVOICE 3'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 3'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 3'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 5","index":5,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 4'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 4'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 4'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",5,null,"Reporting Period:","2020-07-01","TO","2020-09-30","Due:","2020-11-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 4'!B15","v":684800},{"$f":"'INVOICE 4'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 4'!E15,'INVOICE 4'!H15)","v":0},{"$f":"SUM('INVOICE 4'!F15,'INVOICE 4'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 4'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 4'!B16","v":2150000},{"$f":"'INVOICE 4'!C16","v":0},2150000,{"$f":"SUM('INVOICE 4'!E16,'INVOICE 4'!H16)","v":0},{"$f":"SUM('INVOICE 4'!F16,'INVOICE 4'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 4'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 4'!B17","v":0},{"$f":"'INVOICE 4'!C17","v":0},0,{"$f":"SUM('INVOICE 4'!E17,'INVOICE 4'!H17)","v":0},{"$f":"SUM('INVOICE 4'!F17,'INVOICE 4'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 4'!B18","v":0},{"$f":"'INVOICE 4'!C18","v":0},0,{"$f":"SUM('INVOICE 4'!E18,'INVOICE 4'!H18)","v":0},{"$f":"SUM('INVOICE 4'!F18,'INVOICE 4'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 4'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 4'!B19","v":7000},{"$f":"'INVOICE 4'!C19","v":0},7000,{"$f":"SUM('INVOICE 4'!E19,'INVOICE 4'!H19)","v":0},{"$f":"SUM('INVOICE 4'!F19,'INVOICE 4'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 4'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 4'!B20","v":18950},{"$f":"'INVOICE 4'!C20","v":0},18950,{"$f":"SUM('INVOICE 4'!E20,'INVOICE 4'!H20)","v":0},{"$f":"SUM('INVOICE 4'!F20,'INVOICE 4'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 4'!B21","v":5000},{"$f":"'INVOICE 4'!C21","v":0},5000,{"$f":"SUM('INVOICE 4'!E21,'INVOICE 4'!H21)","v":0},{"$f":"SUM('INVOICE 4'!F21,'INVOICE 4'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 4'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 4'!B22","v":134250},{"$f":"'INVOICE 4'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 4'!E22,'INVOICE 4'!H22)","v":0},{"$f":"SUM('INVOICE 4'!F22,'INVOICE 4'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 4'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 4'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","index":6,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 5'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 5'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 5'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",6,null,"Reporting Period:","2020-10-01","TO","2020-12-31","Due:","2021-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 5'!B15","v":684800},{"$f":"'INVOICE 5'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 5'!E15,'INVOICE 5'!H15)","v":0},{"$f":"SUM('INVOICE 5'!F15,'INVOICE 5'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 5'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":2150000},{"$f":"'INVOICE 5'!C16","v":0},2150000,{"$f":"SUM('INVOICE 5'!E16,'INVOICE 5'!H16)","v":0},{"$f":"SUM('INVOICE 5'!F16,'INVOICE 5'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 5'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 5'!B17","v":0},{"$f":"'INVOICE 5'!C17","v":0},0,{"$f":"SUM('INVOICE 5'!E17,'INVOICE 5'!H17)","v":0},{"$f":"SUM('INVOICE 5'!F17,'INVOICE 5'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 5'!B18","v":0},{"$f":"'INVOICE 5'!C18","v":0},0,{"$f":"SUM('INVOICE 5'!E18,'INVOICE 5'!H18)","v":0},{"$f":"SUM('INVOICE 5'!F18,'INVOICE 5'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 5'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 5'!B19","v":7000},{"$f":"'INVOICE 5'!C19","v":0},7000,{"$f":"SUM('INVOICE 5'!E19,'INVOICE 5'!H19)","v":0},{"$f":"SUM('INVOICE 5'!F19,'INVOICE 5'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 5'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 5'!B20","v":18950},{"$f":"'INVOICE 5'!C20","v":0},18950,{"$f":"SUM('INVOICE 5'!E20,'INVOICE 5'!H20)","v":0},{"$f":"SUM('INVOICE 5'!F20,'INVOICE 5'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 5'!B21","v":5000},{"$f":"'INVOICE 5'!C21","v":0},5000,{"$f":"SUM('INVOICE 5'!E21,'INVOICE 5'!H21)","v":0},{"$f":"SUM('INVOICE 5'!F21,'INVOICE 5'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 5'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 5'!B22","v":134250},{"$f":"'INVOICE 5'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 5'!E22,'INVOICE 5'!H22)","v":0},{"$f":"SUM('INVOICE 5'!F22,'INVOICE 5'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 5'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 5'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 7","index":7,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 6'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 6'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 6'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",7,null,"Reporting Period:","2021-01-01","TO","2021-03-31","Due:","2021-05-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 6'!B15","v":684800},{"$f":"'INVOICE 6'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 6'!E15,'INVOICE 6'!H15)","v":0},{"$f":"SUM('INVOICE 6'!F15,'INVOICE 6'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 6'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":2150000},{"$f":"'INVOICE 6'!C16","v":0},2150000,{"$f":"SUM('INVOICE 6'!E16,'INVOICE 6'!H16)","v":0},{"$f":"SUM('INVOICE 6'!F16,'INVOICE 6'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 6'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 6'!B17","v":0},{"$f":"'INVOICE 6'!C17","v":0},0,{"$f":"SUM('INVOICE 6'!E17,'INVOICE 6'!H17)","v":0},{"$f":"SUM('INVOICE 6'!F17,'INVOICE 6'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 6'!B18","v":0},{"$f":"'INVOICE 6'!C18","v":0},0,{"$f":"SUM('INVOICE 6'!E18,'INVOICE 6'!H18)","v":0},{"$f":"SUM('INVOICE 6'!F18,'INVOICE 6'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 6'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 6'!B19","v":7000},{"$f":"'INVOICE 6'!C19","v":0},7000,{"$f":"SUM('INVOICE 6'!E19,'INVOICE 6'!H19)","v":0},{"$f":"SUM('INVOICE 6'!F19,'INVOICE 6'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 6'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 6'!B20","v":18950},{"$f":"'INVOICE 6'!C20","v":0},18950,{"$f":"SUM('INVOICE 6'!E20,'INVOICE 6'!H20)","v":0},{"$f":"SUM('INVOICE 6'!F20,'INVOICE 6'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 6'!B21","v":5000},{"$f":"'INVOICE 6'!C21","v":0},5000,{"$f":"SUM('INVOICE 6'!E21,'INVOICE 6'!H21)","v":0},{"$f":"SUM('INVOICE 6'!F21,'INVOICE 6'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 6'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 6'!B22","v":134250},{"$f":"'INVOICE 6'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 6'!E22,'INVOICE 6'!H22)","v":0},{"$f":"SUM('INVOICE 6'!F22,'INVOICE 6'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 6'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 6'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 8","index":8,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 7'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 7'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 7'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",8,null,"Reporting Period:","2021-04-01","TO","2021-06-30","Due:","2021-08-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 7'!B15","v":684800},{"$f":"'INVOICE 7'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 7'!E15,'INVOICE 7'!H15)","v":0},{"$f":"SUM('INVOICE 7'!F15,'INVOICE 7'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 7'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":2150000},{"$f":"'INVOICE 7'!C16","v":0},2150000,{"$f":"SUM('INVOICE 7'!E16,'INVOICE 7'!H16)","v":0},{"$f":"SUM('INVOICE 7'!F16,'INVOICE 7'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 7'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 7'!B17","v":0},{"$f":"'INVOICE 7'!C17","v":0},0,{"$f":"SUM('INVOICE 7'!E17,'INVOICE 7'!H17)","v":0},{"$f":"SUM('INVOICE 7'!F17,'INVOICE 7'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 7'!B18","v":0},{"$f":"'INVOICE 7'!C18","v":0},0,{"$f":"SUM('INVOICE 7'!E18,'INVOICE 7'!H18)","v":0},{"$f":"SUM('INVOICE 7'!F18,'INVOICE 7'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 7'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 7'!B19","v":7000},{"$f":"'INVOICE 7'!C19","v":0},7000,{"$f":"SUM('INVOICE 7'!E19,'INVOICE 7'!H19)","v":0},{"$f":"SUM('INVOICE 7'!F19,'INVOICE 7'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 7'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 7'!B20","v":18950},{"$f":"'INVOICE 7'!C20","v":0},18950,{"$f":"SUM('INVOICE 7'!E20,'INVOICE 7'!H20)","v":0},{"$f":"SUM('INVOICE 7'!F20,'INVOICE 7'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 7'!B21","v":5000},{"$f":"'INVOICE 7'!C21","v":0},5000,{"$f":"SUM('INVOICE 7'!E21,'INVOICE 7'!H21)","v":0},{"$f":"SUM('INVOICE 7'!F21,'INVOICE 7'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 7'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 7'!B22","v":134250},{"$f":"'INVOICE 7'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 7'!E22,'INVOICE 7'!H22)","v":0},{"$f":"SUM('INVOICE 7'!F22,'INVOICE 7'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 7'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 7'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 9","index":9,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 8'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 8'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 8'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",9,null,"Reporting Period:","2021-07-01","TO","2021-09-30","Due:","2021-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 8'!B15","v":684800},{"$f":"'INVOICE 8'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 8'!E15,'INVOICE 8'!H15)","v":0},{"$f":"SUM('INVOICE 8'!F15,'INVOICE 8'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 8'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":2150000},{"$f":"'INVOICE 8'!C16","v":0},2150000,{"$f":"SUM('INVOICE 8'!E16,'INVOICE 8'!H16)","v":0},{"$f":"SUM('INVOICE 8'!F16,'INVOICE 8'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 8'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 8'!B17","v":0},{"$f":"'INVOICE 8'!C17","v":0},0,{"$f":"SUM('INVOICE 8'!E17,'INVOICE 8'!H17)","v":0},{"$f":"SUM('INVOICE 8'!F17,'INVOICE 8'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 8'!B18","v":0},{"$f":"'INVOICE 8'!C18","v":0},0,{"$f":"SUM('INVOICE 8'!E18,'INVOICE 8'!H18)","v":0},{"$f":"SUM('INVOICE 8'!F18,'INVOICE 8'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 8'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 8'!B19","v":7000},{"$f":"'INVOICE 8'!C19","v":0},7000,{"$f":"SUM('INVOICE 8'!E19,'INVOICE 8'!H19)","v":0},{"$f":"SUM('INVOICE 8'!F19,'INVOICE 8'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 8'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 8'!B20","v":18950},{"$f":"'INVOICE 8'!C20","v":0},18950,{"$f":"SUM('INVOICE 8'!E20,'INVOICE 8'!H20)","v":0},{"$f":"SUM('INVOICE 8'!F20,'INVOICE 8'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 8'!B21","v":5000},{"$f":"'INVOICE 8'!C21","v":0},5000,{"$f":"SUM('INVOICE 8'!E21,'INVOICE 8'!H21)","v":0},{"$f":"SUM('INVOICE 8'!F21,'INVOICE 8'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 8'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 8'!B22","v":134250},{"$f":"'INVOICE 8'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 8'!E22,'INVOICE 8'!H22)","v":0},{"$f":"SUM('INVOICE 8'!F22,'INVOICE 8'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 8'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 8'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 10","index":10,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 9'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 9'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 9'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",10,null,"Reporting Period:","2021-10-01","TO","2021-12-31","Due:","2022-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 9'!B15","v":684800},{"$f":"'INVOICE 9'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 9'!E15,'INVOICE 9'!H15)","v":0},{"$f":"SUM('INVOICE 9'!F15,'INVOICE 9'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 9'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":2150000},{"$f":"'INVOICE 9'!C16","v":0},2150000,{"$f":"SUM('INVOICE 9'!E16,'INVOICE 9'!H16)","v":0},{"$f":"SUM('INVOICE 9'!F16,'INVOICE 9'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 9'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 9'!B17","v":0},{"$f":"'INVOICE 9'!C17","v":0},0,{"$f":"SUM('INVOICE 9'!E17,'INVOICE 9'!H17)","v":0},{"$f":"SUM('INVOICE 9'!F17,'INVOICE 9'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 9'!B18","v":0},{"$f":"'INVOICE 9'!C18","v":0},0,{"$f":"SUM('INVOICE 9'!E18,'INVOICE 9'!H18)","v":0},{"$f":"SUM('INVOICE 9'!F18,'INVOICE 9'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 9'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 9'!B19","v":7000},{"$f":"'INVOICE 9'!C19","v":0},7000,{"$f":"SUM('INVOICE 9'!E19,'INVOICE 9'!H19)","v":0},{"$f":"SUM('INVOICE 9'!F19,'INVOICE 9'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 9'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 9'!B20","v":18950},{"$f":"'INVOICE 9'!C20","v":0},18950,{"$f":"SUM('INVOICE 9'!E20,'INVOICE 9'!H20)","v":0},{"$f":"SUM('INVOICE 9'!F20,'INVOICE 9'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 9'!B21","v":5000},{"$f":"'INVOICE 9'!C21","v":0},5000,{"$f":"SUM('INVOICE 9'!E21,'INVOICE 9'!H21)","v":0},{"$f":"SUM('INVOICE 9'!F21,'INVOICE 9'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 9'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 9'!B22","v":134250},{"$f":"'INVOICE 9'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 9'!E22,'INVOICE 9'!H22)","v":0},{"$f":"SUM('INVOICE 9'!F22,'INVOICE 9'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 9'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 9'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 11","index":11,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 10'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 10'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 10'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",11,null,"Reporting Period:","2022-01-01","TO","2022-03-31","Due:","2022-05-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 10'!B15","v":684800},{"$f":"'INVOICE 10'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 10'!E15,'INVOICE 10'!H15)","v":0},{"$f":"SUM('INVOICE 10'!F15,'INVOICE 10'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 10'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":2150000},{"$f":"'INVOICE 10'!C16","v":0},2150000,{"$f":"SUM('INVOICE 10'!E16,'INVOICE 10'!H16)","v":0},{"$f":"SUM('INVOICE 10'!F16,'INVOICE 10'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 10'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 10'!B17","v":0},{"$f":"'INVOICE 10'!C17","v":0},0,{"$f":"SUM('INVOICE 10'!E17,'INVOICE 10'!H17)","v":0},{"$f":"SUM('INVOICE 10'!F17,'INVOICE 10'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 10'!B18","v":0},{"$f":"'INVOICE 10'!C18","v":0},0,{"$f":"SUM('INVOICE 10'!E18,'INVOICE 10'!H18)","v":0},{"$f":"SUM('INVOICE 10'!F18,'INVOICE 10'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 10'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 10'!B19","v":7000},{"$f":"'INVOICE 10'!C19","v":0},7000,{"$f":"SUM('INVOICE 10'!E19,'INVOICE 10'!H19)","v":0},{"$f":"SUM('INVOICE 10'!F19,'INVOICE 10'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 10'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 10'!B20","v":18950},{"$f":"'INVOICE 10'!C20","v":0},18950,{"$f":"SUM('INVOICE 10'!E20,'INVOICE 10'!H20)","v":0},{"$f":"SUM('INVOICE 10'!F20,'INVOICE 10'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 10'!B21","v":5000},{"$f":"'INVOICE 10'!C21","v":0},5000,{"$f":"SUM('INVOICE 10'!E21,'INVOICE 10'!H21)","v":0},{"$f":"SUM('INVOICE 10'!F21,'INVOICE 10'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 10'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 10'!B22","v":134250},{"$f":"'INVOICE 10'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 10'!E22,'INVOICE 10'!H22)","v":0},{"$f":"SUM('INVOICE 10'!F22,'INVOICE 10'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 10'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 10'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 12","index":12,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 11'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 11'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 11'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",12,null,"Reporting Period:","2022-04-01","TO","2022-06-30","Due:","2022-08-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 11'!B15","v":684800},{"$f":"'INVOICE 11'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 11'!E15,'INVOICE 11'!H15)","v":0},{"$f":"SUM('INVOICE 11'!F15,'INVOICE 11'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 11'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":2150000},{"$f":"'INVOICE 11'!C16","v":0},2150000,{"$f":"SUM('INVOICE 11'!E16,'INVOICE 11'!H16)","v":0},{"$f":"SUM('INVOICE 11'!F16,'INVOICE 11'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 11'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 11'!B17","v":0},{"$f":"'INVOICE 11'!C17","v":0},0,{"$f":"SUM('INVOICE 11'!E17,'INVOICE 11'!H17)","v":0},{"$f":"SUM('INVOICE 11'!F17,'INVOICE 11'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 11'!B18","v":0},{"$f":"'INVOICE 11'!C18","v":0},0,{"$f":"SUM('INVOICE 11'!E18,'INVOICE 11'!H18)","v":0},{"$f":"SUM('INVOICE 11'!F18,'INVOICE 11'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 11'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 11'!B19","v":7000},{"$f":"'INVOICE 11'!C19","v":0},7000,{"$f":"SUM('INVOICE 11'!E19,'INVOICE 11'!H19)","v":0},{"$f":"SUM('INVOICE 11'!F19,'INVOICE 11'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 11'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 11'!B20","v":18950},{"$f":"'INVOICE 11'!C20","v":0},18950,{"$f":"SUM('INVOICE 11'!E20,'INVOICE 11'!H20)","v":0},{"$f":"SUM('INVOICE 11'!F20,'INVOICE 11'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 11'!B21","v":5000},{"$f":"'INVOICE 11'!C21","v":0},5000,{"$f":"SUM('INVOICE 11'!E21,'INVOICE 11'!H21)","v":0},{"$f":"SUM('INVOICE 11'!F21,'INVOICE 11'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 11'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 11'!B22","v":134250},{"$f":"'INVOICE 11'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 11'!E22,'INVOICE 11'!H22)","v":0},{"$f":"SUM('INVOICE 11'!F22,'INVOICE 11'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 11'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 11'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 13","index":13,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 12'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 12'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 12'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",13,null,"Reporting Period:","2022-07-01","TO","2022-09-30","Due:","2022-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 12'!B15","v":684800},{"$f":"'INVOICE 12'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 12'!E15,'INVOICE 12'!H15)","v":0},{"$f":"SUM('INVOICE 12'!F15,'INVOICE 12'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 12'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 12'!B16","v":2150000},{"$f":"'INVOICE 12'!C16","v":0},2150000,{"$f":"SUM('INVOICE 12'!E16,'INVOICE 12'!H16)","v":0},{"$f":"SUM('INVOICE 12'!F16,'INVOICE 12'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 12'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 12'!B17","v":0},{"$f":"'INVOICE 12'!C17","v":0},0,{"$f":"SUM('INVOICE 12'!E17,'INVOICE 12'!H17)","v":0},{"$f":"SUM('INVOICE 12'!F17,'INVOICE 12'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 12'!B18","v":0},{"$f":"'INVOICE 12'!C18","v":0},0,{"$f":"SUM('INVOICE 12'!E18,'INVOICE 12'!H18)","v":0},{"$f":"SUM('INVOICE 12'!F18,'INVOICE 12'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 12'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 12'!B19","v":7000},{"$f":"'INVOICE 12'!C19","v":0},7000,{"$f":"SUM('INVOICE 12'!E19,'INVOICE 12'!H19)","v":0},{"$f":"SUM('INVOICE 12'!F19,'INVOICE 12'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 12'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 12'!B20","v":18950},{"$f":"'INVOICE 12'!C20","v":0},18950,{"$f":"SUM('INVOICE 12'!E20,'INVOICE 12'!H20)","v":0},{"$f":"SUM('INVOICE 12'!F20,'INVOICE 12'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 12'!B21","v":5000},{"$f":"'INVOICE 12'!C21","v":0},5000,{"$f":"SUM('INVOICE 12'!E21,'INVOICE 12'!H21)","v":0},{"$f":"SUM('INVOICE 12'!F21,'INVOICE 12'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 12'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 12'!B22","v":134250},{"$f":"'INVOICE 12'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 12'!E22,'INVOICE 12'!H22)","v":0},{"$f":"SUM('INVOICE 12'!F22,'INVOICE 12'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 12'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 12'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 14","index":14,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 13'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 13'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 13'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 13'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",14,null,"Reporting Period:","2022-10-01","TO","2022-12-31","Due:","2023-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 13'!B15","v":684800},{"$f":"'INVOICE 13'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 13'!E15,'INVOICE 13'!H15)","v":0},{"$f":"SUM('INVOICE 13'!F15,'INVOICE 13'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 13'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 13'!B16","v":2150000},{"$f":"'INVOICE 13'!C16","v":0},2150000,{"$f":"SUM('INVOICE 13'!E16,'INVOICE 13'!H16)","v":0},{"$f":"SUM('INVOICE 13'!F16,'INVOICE 13'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 13'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 13'!B17","v":0},{"$f":"'INVOICE 13'!C17","v":0},0,{"$f":"SUM('INVOICE 13'!E17,'INVOICE 13'!H17)","v":0},{"$f":"SUM('INVOICE 13'!F17,'INVOICE 13'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 13'!B18","v":0},{"$f":"'INVOICE 13'!C18","v":0},0,{"$f":"SUM('INVOICE 13'!E18,'INVOICE 13'!H18)","v":0},{"$f":"SUM('INVOICE 13'!F18,'INVOICE 13'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 13'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 13'!B19","v":7000},{"$f":"'INVOICE 13'!C19","v":0},7000,{"$f":"SUM('INVOICE 13'!E19,'INVOICE 13'!H19)","v":0},{"$f":"SUM('INVOICE 13'!F19,'INVOICE 13'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 13'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 13'!B20","v":18950},{"$f":"'INVOICE 13'!C20","v":0},18950,{"$f":"SUM('INVOICE 13'!E20,'INVOICE 13'!H20)","v":0},{"$f":"SUM('INVOICE 13'!F20,'INVOICE 13'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 13'!B21","v":5000},{"$f":"'INVOICE 13'!C21","v":0},5000,{"$f":"SUM('INVOICE 13'!E21,'INVOICE 13'!H21)","v":0},{"$f":"SUM('INVOICE 13'!F21,'INVOICE 13'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 13'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 13'!B22","v":134250},{"$f":"'INVOICE 13'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 13'!E22,'INVOICE 13'!H22)","v":0},{"$f":"SUM('INVOICE 13'!F22,'INVOICE 13'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 13'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 13'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 13'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 13'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 13'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 13'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 15","index":15,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[62,4,62,9],[63,4,63,9],[64,4,64,9],[64,10,64,12],[65,0,65,2],[65,4,65,9],[65,10,65,12],[67,0,67,12],[68,0,68,1],[58,11,58,13],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[48,0,48,1],[48,3,48,13],[49,0,49,2],[49,4,49,9],[49,11,49,13],[50,0,50,2],[50,4,59,9],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[55,0,55,2],[55,11,55,13],[44,0,45,0],[44,3,44,10],[44,11,44,13],[45,3,45,10],[45,11,45,13],[46,0,47,0],[46,3,46,10],[46,11,46,13],[47,3,47,10],[47,11,47,13],[40,0,41,0],[40,3,40,10],[40,11,40,13],[41,3,41,10],[41,11,41,13],[42,0,43,0],[42,3,42,10],[42,11,42,13],[43,3,43,10],[43,11,43,13],[36,0,37,0],[36,3,36,10],[36,11,36,13],[37,3,37,10],[37,11,37,13],[38,0,39,0],[38,3,38,10],[38,11,38,13],[39,3,39,10],[39,11,39,13],[32,0,33,0],[32,3,32,10],[32,11,32,13],[33,3,33,10],[33,11,33,13],[34,0,35,0],[34,3,34,10],[34,11,34,13],[35,3,35,10],[35,11,35,13],[25,0,25,12],[26,11,26,12],[27,11,27,12],[30,0,30,2],[31,3,31,10],[31,11,31,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[0,5,2,7],[0,11,0,13],[1,11,1,13],[4,10,6,13],[6,6,6,8],[8,12,8,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 14'!L2:N2","v":"Purchase Order: 2928"}]
["Financial Invoice - Form BSCC 201 (Revised 06/2020)"]
[]
["Program:","Adult Reentry Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 14'!B7","v":"Victor Valley Family Resource Center"},null,null,null,"Project Title:",{"$f":"'INVOICE 14'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 14'!B9","v":"BSCC 430-19"},null,"Term:","2019-08-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",15,null,"Reporting Period:","2023-01-01","TO","2023-02-28","Due:","2023-04-14",null,null,"Final Invoice (Y/N):","Yes"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 14'!B15","v":684800},{"$f":"'INVOICE 14'!C15","v":0},{"$f":"SUM(B15:C15)","v":684800},{"$f":"SUM('INVOICE 14'!E15,'INVOICE 14'!H15)","v":0},{"$f":"SUM('INVOICE 14'!F15,'INVOICE 14'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":684800},0,{"$f":"SUM(K15:L15)","v":684800},{"$f":"'INVOICE 14'!N15","v":"1st Advance [3/6/20]"}]
["Services & Supplies",{"$f":"'INVOICE 14'!B16","v":2150000},{"$f":"'INVOICE 14'!C16","v":0},2150000,{"$f":"SUM('INVOICE 14'!E16,'INVOICE 14'!H16)","v":0},{"$f":"SUM('INVOICE 14'!F16,'INVOICE 14'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,2150000,0,2150000,{"$f":"'INVOICE 14'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 14'!B17","v":0},{"$f":"'INVOICE 14'!C17","v":0},0,{"$f":"SUM('INVOICE 14'!E17,'INVOICE 14'!H17)","v":0},{"$f":"SUM('INVOICE 14'!F17,'INVOICE 14'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 14'!B18","v":0},{"$f":"'INVOICE 14'!C18","v":0},0,{"$f":"SUM('INVOICE 14'!E18,'INVOICE 14'!H18)","v":0},{"$f":"SUM('INVOICE 14'!F18,'INVOICE 14'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 14'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 14'!B19","v":7000},{"$f":"'INVOICE 14'!C19","v":0},7000,{"$f":"SUM('INVOICE 14'!E19,'INVOICE 14'!H19)","v":0},{"$f":"SUM('INVOICE 14'!F19,'INVOICE 14'!I19)","v":0},0,0,0,0,7000,0,7000,{"$f":"'INVOICE 14'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 14'!B20","v":18950},{"$f":"'INVOICE 14'!C20","v":0},18950,{"$f":"SUM('INVOICE 14'!E20,'INVOICE 14'!H20)","v":0},{"$f":"SUM('INVOICE 14'!F20,'INVOICE 14'!I20)","v":0},0,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 14'!B21","v":5000},{"$f":"'INVOICE 14'!C21","v":0},5000,{"$f":"SUM('INVOICE 14'!E21,'INVOICE 14'!H21)","v":0},{"$f":"SUM('INVOICE 14'!F21,'INVOICE 14'!I21)","v":0},0,0,0,0,5000,0,5000,{"$f":"'INVOICE 14'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 14'!B22","v":134250},{"$f":"'INVOICE 14'!C22","v":0},{"$f":"SUM(B22:C22)","v":134250},{"$f":"SUM('INVOICE 14'!E22,'INVOICE 14'!H22)","v":0},{"$f":"SUM('INVOICE 14'!F22,'INVOICE 14'!I22)","v":0},0,0,0,0,134250,0,134250,{"$f":"'INVOICE 14'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,0,0,0,3000000,0,3000000,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 14'!D25+I25","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":0},null,null,"Grant funds claimed this period:",{"$f":"H23","v":0},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":1000000},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Data Collection & Progress Reporting","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Other (Travel, Training, etc.)","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":0}]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 14'!L52:N52","v":146536}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 14'!L54:N54","v":"VICTORVALL-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 14'!L56:N56","v":"P.O. Box 1248"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 14'!L58:N58","v":"Victorville, CA 92393"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date: "]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"2nd Advance Payment","index":16,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,8,9,11],[12,2,12,3],[7,2,7,4],[54,2,54,4],[55,2,55,4],[14,2,14,3],[24,6,24,10],[25,6,33,10],[49,2,49,4],[12,6,14,11],[17,0,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[24,1,24,4],[25,1,25,4],[0,9,0,11],[1,9,1,11],[5,2,5,4],[5,8,5,11],[7,8,7,11],[0,5,2,7],[31,1,31,4],[32,1,32,4],[22,0,22,3],[22,6,22,10],[45,0,45,3],[45,6,45,10],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[48,2,48,4],[34,6,34,10],[35,6,35,10],[36,6,36,10],[37,6,37,10],[38,6,38,10],[39,6,39,10],[40,6,40,10],[42,6,42,10],[41,6,41,10],[50,2,50,4],[50,8,50,10],[52,2,52,4],[52,8,52,10],[53,2,53,4]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,{"$f":"'INVOICE 15'!L2","v":"Purchase Order: 2928"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Adult Reentry Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"Victor Valley Family Resource Center"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 430-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 1248"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-08-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,{"$f":"'INVOICE 15'!L58","v":"Victorville, CA 92393"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #","2 RA 2019",null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",{"$f":"'1st Advance Payment'!K19","v":3000000}]
[null,null,null,null,null,null,null,null,null,"2nd Advance Total:",{"$f":"SUM(ROUNDUP(K19/3,0))","v":1000000}]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"SUM(ROUNDDOWN('1st Advance Payment'!K19-'1st Advance Payment'!K20-'2nd Advance Payment'!K20,0))","v":1000000}]
[]
[]
[]
[null,"PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,"Name, Title"]
[]
[null,"Phone"]
[]
[null,"Email"]
[]
[null,"Date"]
[]
[]
[null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,"Email"]
[]
[null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:",null,null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'INVOICE 15'!L54","v":"VICTORVALL-020"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:",null,null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146536}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"3rd Advance Payment","index":17,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,2,54,4],[55,2,55,4],[5,8,5,11],[7,8,7,11],[9,8,9,11],[5,2,5,4],[7,2,7,4],[12,2,12,3],[52,2,52,4],[52,8,52,10],[53,2,53,4],[42,6,42,10],[45,0,45,3],[45,6,45,10],[48,2,48,4],[49,2,49,4],[50,2,50,4],[50,8,50,10],[41,6,41,10],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[34,6,34,10],[35,6,35,10],[36,6,36,10],[37,6,37,10],[38,6,38,10],[39,6,39,10],[40,6,40,10],[20,10,20,11],[22,0,22,3],[22,6,22,10],[24,1,24,4],[24,6,24,10],[25,1,25,4],[25,6,33,10],[26,1,26,4],[27,1,27,4],[28,1,28,4],[19,10,19,11],[0,5,2,7],[12,6,14,11],[14,2,14,3],[17,0,17,11],[18,10,18,11],[0,9,0,11],[1,9,1,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,{"$f":"'INVOICE 15'!L2","v":"Purchase Order: 2928"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Adult Reentry Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"Victor Valley Family Resource Center"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 430-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 1248"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-08-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,{"$f":"'INVOICE 15'!L58","v":"Victorville, CA 92393"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #","3 RA 2019",null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Supplier Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",{"$f":"'1st Advance Payment'!K19","v":3000000}]
[null,null,null,null,null,null,null,null,null,"Advance Total Dispursed To Date:",{"$f":"SUM(ROUNDUP('1st Advance Payment'!K20:L20+'2nd Advance Payment'!K20:L20,0))","v":2000000}]
[null,null,null,null,null,null,null,null,null,"Final Advance Total:",{"$f":"K19-K20","v":1000000}]
[]
[]
[]
[null,"PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,"Name, Title"]
[]
[null,"Phone"]
[]
[null,"Email"]
[]
[null,"Date"]
[]
[]
[null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,"Email"]
[]
[null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:",null,null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'INVOICE 15'!L54","v":"VICTORVALL-020"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:",null,null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146536}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"MODIFICATION REQUEST","index":18,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[58,0,58,2],[19,4,19,6],[33,0,33,12],[53,0,53,2],[55,0,55,2],[57,0,57,2],[34,0,51,12],[56,0,56,2],[54,8,63,12],[53,8,53,12],[32,0,32,12],[19,0,20,0],[19,1,19,3],[19,7,19,9],[19,10,19,12],[73,15,73,16],[73,8,73,10],[72,8,72,10],[62,0,62,2],[59,0,59,2],[60,0,60,2],[61,0,61,2],[72,0,72,1],[68,8,68,12],[69,8,69,12],[64,8,64,12],[65,8,65,12],[66,8,66,12],[67,8,67,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 04/20)",null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
[null,"Line-Item Change",null,null,null,"Budget Modification",null,null,null,"Project Income Allocation"]
[null,"Check this box if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,"Check this box if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,"Check this box if you are allocating earned project income."]
[]
["Important Note: You must provide a detailed justification for all modification requests. All modifications require BSCC Field Representative approval.  "]
[]
["Grantee:",{"$f":"'INVOICE 15'!B7","v":"Victor Valley Family Resource Center"},null,null,null,null,null,null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Adult Reentry Grant"}]
[]
["Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 1248"},null,null,null,null,null,null,"Project Title:",{"$f":"'INVOICE 15'!G7","v":"RA"}]
[]
[null,{"$f":"'INVOICE 15'!L58","v":"Victorville, CA 92393"}]
[]
["Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 430-19"},null,null,null,null,null,null,null,"Modification Request #"]
[]
["Term:",{"$f":"'INVOICE 1'!E9","v":"2019-08-01"},{"$f":"'INVOICE 1'!F9","v":"TO"},{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,null,"Effective on Invoice #"]
[]
["Line Items","Current Budget",null,null,"Available Budget",null,null,"Changes (+/-)",null,null,"Modified Budget"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 15'!B15","v":684800},{"$f":"'INVOICE 15'!C15","v":0},{"$f":"SUM(B22:C22)","v":684800},{"$f":"'INVOICE 15'!K15","v":684800},{"$f":"'INVOICE 15'!L15","v":0},{"$f":"SUM(E22:F22)","v":684800},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":684800},{"$f":"SUM(C22,I22)","v":0},{"$f":"SUM(K22:L22)","v":684800}]
["Services & Supplies",{"$f":"'INVOICE 15'!B16","v":2150000},{"$f":"'INVOICE 15'!C16","v":0},2150000,{"$f":"'INVOICE 15'!K16","v":2150000},{"$f":"'INVOICE 15'!L16","v":0},2150000,0,0,0,2150000,0,2150000]
["Professional Services",{"$f":"'INVOICE 15'!B17","v":0},{"$f":"'INVOICE 15'!C17","v":0},0,{"$f":"'INVOICE 15'!K17","v":0},{"$f":"'INVOICE 15'!L17","v":0},0,0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 15'!B18","v":0},{"$f":"'INVOICE 15'!C18","v":0},0,{"$f":"'INVOICE 15'!K18","v":0},{"$f":"'INVOICE 15'!L18","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",{"$f":"'INVOICE 15'!B19","v":7000},{"$f":"'INVOICE 15'!C19","v":0},7000,{"$f":"'INVOICE 15'!K19","v":7000},{"$f":"'INVOICE 15'!L19","v":0},7000,0,0,0,7000,0,7000]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 15'!B20","v":18950},{"$f":"'INVOICE 15'!C20","v":0},18950,{"$f":"'INVOICE 15'!K20","v":18950},{"$f":"'INVOICE 15'!L20","v":0},18950,0,0,0,18950,0,18950]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 15'!B21","v":5000},{"$f":"'INVOICE 15'!C21","v":0},5000,{"$f":"'INVOICE 15'!K21","v":5000},{"$f":"'INVOICE 15'!L21","v":0},5000,0,0,0,5000,0,5000]
["Indirect Costs",{"$f":"'INVOICE 15'!B22","v":134250},{"$f":"'INVOICE 15'!C22","v":0},134250,{"$f":"'INVOICE 15'!K22","v":134250},{"$f":"'INVOICE 15'!L22","v":0},134250,0,0,0,134250,0,134250]
["TOTAL",{"$f":"SUM(B22:B29)","v":3000000},0,3000000,3000000,0,3000000,0,0,0,3000000,0,3000000]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 15'!D25","v":0},null,"Prior allocated income",{"$f":"'INVOICE 15'!G25","v":0},"Allocating",{"$f":"I30","v":0},null,null,"Unallocated income balance",{"$f":"D32-I32","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PERSON PREPARING REPORT",null,null,null,null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[]
["Name, Title"]
[]
["Phone"]
[]
["Email"]
[]
["Date"]
[]
[]
[null,null,null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,"Approved By:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"Project Budget","index":19,"n_rows":330,"n_cols":7,"rows_kept":330,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,2],[2,3,2,6],[3,0,3,6],[4,0,4,5],[11,0,11,5],[13,0,13,5],[16,0,16,6],[17,0,17,1],[17,2,17,5],[18,0,18,1],[18,2,18,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[10,0,10,5],[23,0,23,1],[23,2,23,5],[24,0,24,1],[24,2,24,5],[25,0,25,1],[25,2,25,5],[19,0,19,1],[19,2,19,5],[20,2,20,5],[21,0,21,1],[21,2,21,5],[22,0,22,1],[22,2,22,5],[29,0,29,1],[29,2,29,5],[30,0,30,1],[30,2,30,5],[31,0,31,1],[31,2,31,5],[26,0,26,1],[26,2,26,5],[27,0,27,1],[27,2,27,5],[28,0,28,1],[28,2,28,5],[65,0,65,1],[65,2,65,5],[66,0,66,1],[66,2,66,5],[67,0,67,1],[67,2,67,5],[32,0,32,5],[35,0,59,6],[62,0,62,6],[63,0,63,1],[63,2,63,5],[64,0,64,1],[64,2,64,5],[60,0,60,6],[61,0,61,6],[71,0,71,1],[71,2,71,5],[72,0,72,5],[74,0,74,2],[75,0,95,6],[98,0,98,6],[68,0,68,1],[68,2,68,5],[69,0,69,1],[69,2,69,5],[70,0,70,1],[70,2,70,5],[96,0,96,6],[97,0,97,6],[103,0,103,1],[103,2,103,5],[104,0,104,1],[104,2,104,5],[105,0,105,1],[105,2,105,5],[99,2,99,5],[100,0,100,1],[100,2,100,5],[101,0,101,1],[101,2,101,5],[102,0,102,1],[102,2,102,5],[133,0,133,6],[134,2,134,5],[135,0,135,1],[135,2,135,5],[136,0,136,1],[136,2,136,5],[106,0,106,1],[106,2,106,5],[107,0,107,1],[107,2,107,5],[108,0,108,5],[111,0,130,6],[131,0,131,6],[132,0,132,6],[140,0,140,1],[140,2,140,5],[141,0,141,1],[141,2,141,5],[142,0,142,1],[142,2,142,5],[137,0,137,1],[137,2,137,5],[138,0,138,1],[138,2,138,5],[139,0,139,1],[139,2,139,5],[172,0,172,1],[172,2,172,5],[173,0,173,1],[173,2,173,5],[174,0,174,1],[174,2,174,5],[143,0,143,5],[145,0,145,6],[146,0,166,6],[169,0,169,6],[170,2,170,5],[171,0,171,1],[171,2,171,5],[167,0,167,6],[168,0,168,6],[178,0,178,1],[178,2,178,5],[179,0,179,5],[182,0,199,6],[202,0,202,6],[203,0,203,5],[200,0,200,6],[201,0,201,6],[175,0,175,1],[175,2,175,5],[176,0,176,1],[176,2,176,5],[177,0,177,1],[177,2,177,5],[238,0,238,1],[238,2,238,5],[239,2,239,5],[235,0,235,6],[236,0,236,6],[204,0,204,5],[205,0,205,5],[206,0,206,5],[207,0,207,5],[208,0,208,5],[209,0,209,5],[210,0,210,5],[213,0,234,6],[237,0,237,6],[330,0,330,6],[271,0,271,6],[272,0,272,6],[246,0,246,5],[249,0,270,6],[273,0,273,6],[274,0,274,5],[275,0,275,4],[276,0,276,4],[277,0,277,5],[280,0,328,6],[329,0,329,6],[243,0,243,1],[243,2,243,5],[244,0,244,1],[244,2,244,5],[245,0,245,1],[245,2,245,5],[240,0,240,1],[240,2,240,5],[241,0,241,1],[241,2,241,5],[242,0,242,1],[242,2,242,5]]}
[]
["Project Budget and Budget Narrative for Rental Assistance (UPDATED 3.14.19)"]
["Name of Applicant CBO:",null,null,"Victor Valley Family Resource Center"]
["Project Budget for Rental Assistance"]
["Original Budget Line Item",null,null,null,null,null,"Grant Funds"]
["1. Salaries and Benefits",null,null,null,null,null,{"$f":"G33","v":684800}]
["2. Services and Supplies",null,null,null,null,null,{"$f":"G73","v":2150000}]
["3. Professional Services",null,null,null,null,null,{"$f":"G109","v":0}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,null,{"$f":"G144","v":0}]
["5. Equipment/Fixed Assets",null,null,null,null,null,{"$f":"G180","v":7000}]
["6. Data Collection and Progress Reporting",null,null,null,null,null,{"$f":"G211","v":18950}]
["7. Other (Travel, Training, etc.)",null,null,null,null,null,{"$f":"G247","v":5000}]
["8. Indirect Costs ",null,null,null,null,null,{"$f":"G278","v":134250}]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G6:G13)","v":3000000}]
[]
[]
["1. Salaries and Benefits for Rental Assistance"]
["Name and Title",null,"(% FTE or Hourly Rate) & Benefits  ",null,null,null,"Grant Funds"]
["Example (Hourly): Bob Smith, Fiscal Manager",null,"$60/hour x 10 hours/month x 3 years = $21,600 @ 22% = $4,752",null,null,null,4752]
["Example (FTE): Jane Doe, Counselor",null,".25 FTE @ $60,000 x 3 years = $45,000 @ 22% = $9,900",null,null,null,9900]
["CEO",null,"5% FTE @ $ 72,000  x 43 months = $ 154,800",null,null,null,154800]
["EPB Leader (Evidence-Base Program Manager)",null,"1 FTE @ $45,000 for 40 ms = $150,000",null,null,null,150000]
["Sr. Case Manager",null,"1 FTE @ $42,000 for 40 ms = $140,000",null,null,null,140000]
["Case Manager - Housing Locator/Navigator",null,"2 FTE @ $36,000 for 40 ms = $240,000",null,null,null,240000]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G21:G32)","v":684800}]
[]
["Salaries and Benefits Narrative for Rental Assistance:"]
["CEO - Program administration; ensures funds are expended according to contract; invoicing, contract compliance, budget review, plan goals for resources. Evidence Based Program Leader - puts evidence based program into practice; manages implementation of Rental Assistance Program, manages program ata, develops & maintains business model; oversees core program activities, incl. hiring, supervising, training staff. Oversees and coordinates outreach, participant recruitment. Sr. Case Mgr - provides CM services on-site; implements evidence based practices to engage and assist tenants in addressing behaviors that could lead to eviction; assists in accessing other housing, such as critical time intervention, trauma-informed care, motivational interviewing, assertive community treatment, cognitive behavioral therapy; assists clients to gain independence through life skills; provides intensive case management in coordination and alignment with Housing First, voluntary self-sufficiency model; develops, updates Individual Case Plan with program participants, using family case management approach, assists clients to set and prioritize short and long term goals; completes monthly home visits to support clients in performing tasks required to maintain housing stability.  Case Managers - Housing Locator/Navigator - They will work closely with potential land lords/property managers to promote permanent housing opportunities for homeless re-entry individuals and families using VVFR services; conduct outreach and provide educational information regarding rental subsidies, security deposit assistance, cost savings via low tenant turnover, and a 90% or higher housing retention rate; implement evidence based practices to engage and assist tenants in addressing behaviors that may lead to eviction, or to assist in accessing other housing, such as critical time intervention, trauma-informed care, motivational interviewing, assertive community treatment, cognitive behavioral therapy; maintain client data tracking system, including case notes and HMIS entries; review ViSpdat scores and match clients to housing type via CES protocols."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["2. Services and Supplies for Rental Assistance"]
["Description of Services or Supplies",null,"Calculation for Expenditure",null,null,null,"Grant Funds"]
["Example: Supportive Services (bus passes, gas cards, office supplies, uniforms)",null,"$350 x 50 Participants",null,null,null,17500]
["One-time Emergency causing housing instability",null,"back rent, car repair, medical bills, etc for 220 part @ $1636=$360,000",null,null,null,360000]
["Emergency Shelter incl stabilization services",null,"emergency shelter for 100 clients up to 90 days @ $65/day =$585,000",null,null,null,585000]
["Landlord Incentives",null,"funds to secure rental unit, $1,000 for 50 ms = $50,000",null,null,null,50000]
["Permanent Supportive Housing Subsidies",null,"rent subsidies 40 participants @ $24,000 (max) = $960,000",null,null,null,960000]
["Utility Deposits",null,"1-time asst past due utility bills, 200 part @ $150 = $30,000",null,null,null,30000]
["Rental Application fees",null,"applying for rental unit. $50 per app, 3 app for 100 part = $15,000",null,null,null,15000]
["Security Deposit",null,"payment of all or part of security deposit, 50 part $3,000 = $150,000",null,null,null,150000]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G66:G72)","v":2150000}]
[]
["Services and Supplies Narrative for Rental Assistance:"]
["One time emergency - this includes back rent to avoid eviction; any unexpected expense, such as a medical bill, car repair, so the participant can maintain the housing they currently occupy; back rent payments would max out at $2,000 per participant; other emergencies will max out at $1,200 per particpant. Emergency Shelter - up to 90 days of emergency housing, including case management, housing location/navigation, employment services/job readiness, and other services as needed. Landlord incentives - this will include paying the landlord for a possible empty unit to keep the unit available for a participant; paying for repair of any damage done by the participant; incentives will keep the landlord willing to rent to our program. Permanent Supportive Housing subsidies - payment of rent subsidy (up to 100% of the rent) for permanent housing plus wrap around services. Utility Deposits - one time payment to assist with past-due utility bill, up to $150 per household. Rental Application Fees - Assistance to offset the cost of applying for a rental unit. Up to $50 per application, and a maximum of 3 applications per household. Security Deposit - payment of all or part of the required security deposit, up to 2x rent forunfurnished and x rent for furnished unit."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["3. Professional Services for Rental Assistance"]
["Description of Professional Service(s)",null,"Calculation for Expenditure",null,null,null,"Grant Funds"]
["Example: Public Defender",null,"Statewide Program Rate",null,null,null,15000]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G102:G108)","v":0}]
[]
["Professional Services Narrative for Rental Assistance:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["4. Non-Governmental Organizations (NGO) Subcontracts for Rental Assistance"]
["Description of Subcontract",null,"Calculation for Expenditure",null,null,null,"Grant Funds"]
["Example: Private Industrial Council",null,"Training Class $450 x 25 participants",null,null,null,11250]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G137:G143)","v":0}]
[]
["Non-Governmental Organizations (NGO) Subcontracts Narrative for Rental Assistance:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["5. Equipment/Fixed Assets for Rental Assistance"]
["Description of Equipment/Fixed Asset",null,"Calculation for Expense",null,null,null,"Grant Funds"]
["Example: Purchase of Vehicle",null,"Toyota Prius @ Market Value",null,null,null,24000]
["purchase of laptop computers for staff",null,"5 laptop computers/software @ $1,400",null,null,null,7000]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G173:G179)","v":7000}]
[]
["Equipment/Fixed Assets Narrative for Rental Assistance:"]
["Lap top computers, including the appropriate software and net connection, are critical, so staff can take them when they do outreach, visit the clients. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["6. Data Collection and Progress Reporting for Rental Assistance"]
["Description",null,null,null,null,null,"Grant Funds"]
["Example: Data Collection & Reporting Efforts @ 7%",null,null,null,null,null,10329]
["Data Collection and  Reporting Efforts  @ 50% FTE @ $37,950",null,null,null,null,null,18950]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G206:G210)","v":18950}]
[]
["Data  Collection and Progress Reporting Narrative for Rental Assistance:"]
["Enter HMIS (Homeless Management Information Systems) withing 24 hours of intake or participant activity. Prepare data spreadsheets for statistical analysis, prepare pre/post participant evaluations. Prepare data of # of participants housed, Data # on the number of participants"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["7. Other (Travel, Training, etc.) for Rental Assistance"]
["Description",null,"Calculation for Expense",null,null,null,"Grant Funds"]
["Example: Training Classes",null,"$500/partipant x 30 participants",null,null,null,15000]
["BSCC training - mandatory",null,"5 staff members travel to Sacramento @ $1,000",null,null,null,5000]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G241:G246)","v":5000}]
[]
["Other (Travel, Training, etc.) Narrative for Rental Assistance:"]
["This will cover the travel for mandatory training in Sacramento."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
["8. Indirect Costs for Rental Assistance"]
["For this grant program, indirect costs may be charged using only one of the two options below:",null,null,null,null,null,"Grant Funds"]
["1.  Indirect costs will be charged as 10% of total direct salaries and wages, not to exceed:",null,null,null,null,{"$f":"G33*10%","v":68480},0]
["2.  Indirect costs will be charged as 5% of direct total direct project costs (except equipment) not to exceed:",null,null,null,null,{"$f":"SUM(G247,G211,G144,G109,G73,G33)*5%","v":142937.5},134250]
["If the amount entered above turns red, please adjust it to not exceed the line-item limit noted: TOTAL",null,null,null,null,null,{"$f":"SUM(G276:G277)","v":134250}]
[]
["Indirect Costs Narrative for Rental Assistance:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]

{"sheet":"INVOICE DUE DATES","index":20,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Invoice #","Reporting Period ","Due Date"]
["Invoice 1","August 1, 2019 to September 30, 2019","2019-11-15"]
["Invoice 2","October 1, 2019 to December 31, 2019","2020-02-14"]
["Invoice 3","January 1, 2020 to March 31, 2020","2020-05-15"]
["Invoice 4","April 1, 2020 to June 30, 2020","2020-08-14"]
["Invoice 5","July 1, 2020 to September 30, 2020","2020-11-16"]
["Invoice 6","October 1, 2020 to December 31, 2020","2021-02-15"]
["Invoice 7","January 1, 2021 to March 31, 2021","2021-05-14"]
["Invoice 8","April 1, 2021 to June 30, 2021","2021-08-16"]
["Invoice 9","July 1, 2021 to September 30, 2021","2021-11-15"]
["Invoice 10","October 1, 2021 to December 31, 2021","2022-05-15"]
["Invoice 11","January 1, 2022 to March 31, 2022","2022-05-16"]
["Invoice 12","April 1, 2022 to June 30, 2022","2022-08-15"]
["Invoice 13","July 1, 2022 to September 30, 2022","2022-11-15"]
["Invoice 14","October 1, 2022 to December 31, 2022","2023-02-15"]
["Invoice 15","January 1, 2023 to February 28, 2023","2023-04-14"]

{"sheet":"INSTRUCTIONS ","index":21,"n_rows":106,"n_cols":1,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Invoice Workbook"]
[]
["How to Locate the Invoice Workbook"]
["Invoice workbooks are located on the Board of State and Community Corrections (BSCC) website under the Corrections Planning and Grant Programs Division (CPGP) webpage: http://www.bscc.ca.gov/s_correctionsplanningandprograms/."]
[]
["On the CPGP webpage, locate the CPGP Quick Links and select Grantee Invoicing."]
[]
["Invoice Workbooks are located under the respective grantee program (e.g., California Violence Intervention and Prevention, Edward Byrne Memorial Justice Assistance Grant, Law Enforcement Assisted Diversion, Proposition 47, etc.)."]
[]
["How to Save the Invoice Workbook"]
["Right click on the file and select Save Link as. This will navigate the grantee to their computer files. The grantee shall navigate to a folder where they would like to save their Invoice Workbook. Do not rename the file. "]
[]
["The grantee should then exit the web browser and work directly from the saved file."]
[]
["Prior to each reporting period, it is the grantee’s responsibility to download and save the Invoice Workbook to their local computer. This will ensure the most current budget information is being used in the Invoice Workbook."]
[]
["Forms Included in the Invoice Workbook "]
["The Invoice Workbook is an Excel file arranged by worksheet tabs (located along the bottom). The tabs included in the Invoice workbook are listed below:"]
["\u0097 Invoice (Form BSCC 201) for each reporting period;"]
["\u0097 Advance Payment (Form BSCC 201) for each of three advance disbursements;"]
["\u0097 Modification Request (Form BSCC 223.1 Rev 4/20);"]
["\u0097 Original Budget"]
["\u0097 Project Budget Narrative"]
["\u0097 Invoice Due Dates"]
["\u0097 Instructions."]
[]
["Passwords and Formulas in the Invoice Workbook"]
["Each time the grantee opens the Invoice workbook, they will be prompted to enter a password. The password is the grant agreement number (e.g. 990-19, include the -, do not include BSCC)."]
[]
["The Invoice Workbook has specific functions which require macros to be enabled. A macro is a series of commands, such as calculations, that are stored within the document for tasks performed repeatedly. In most cases, Excel will prompt the grantee to enable macros. When this prompt appears, select Enable Editing then Enable Content. Enabling macros for the Invoice Workbook will not compromise the security of the local system nor the security of the agency's network."]
[]
[]
["Financial Invoice - Form BSCC 201"]
[]
["How to Complete a Financial Invoice "]
["Each Financial Invoice has a separate workbook tab titled, INVOICE #. The Financial Invoice will allow grantees to enter data into the green-shaded fields; all other fields are locked. "]
[]
["The following instructions are for the green-shaded fields the Invoice to be completed by the Grantee. "]
[]
[" THIS REPORTING PERIOD"]
["The grantee shall enter the line item expenditures incurred and project income earned during the reporting period."]
["All expenditures should be rounded to the nearest whole dollar; do not enter decimals."]
["If an amount entered into a cell is greater than the available balance, an Invalid Dollar error message will appear. If the error is typographical, select Retry and enter the correct amount. If the amount entered is correct, however greater than the available balance, select Cancel and submit a Budget Modification. See, Budget Modification details below. "]
["REPORTING EARNED PROJECT INCOME"]
["Any income you make from your award is considered project income and must be reported on the Financial Invoice form.  When project income is earned, grantee will report this earned income on the Project Income row of the Financial Invoice in the “This Period” section.  Grantee will also provide detail on the project income earned in the “Expenditure Descriptions – Units / $ Amounts” section in the “Project Income Earned” row of the Financial Invoice.  Examples may include: amount of client reimbursement to landlord/project for rent and/or interest generated on grant funds held in a bank account.  (See Grant Administration Guide, Section 13, Project and Other Income for more detail on project income and reporting requirements.)"]
[]
["EXPENDITURE DESCRIPTION"]
["For each dollar amount entered as an expenditure, enter a brief but detailed description. Your expenditures should correlate to Project Budget Narrative, which is listed on its own tab along with approved modification requests. "]
[]
[" PERSON PREPARING REPORT"]
["The grantee will designate an individual to prepare invoices. The Authorized Financial Officer cannot prepare invoices. "]
["The individual who prepares invoices will provide their contact information and the date the invoice was prepared under the PERSON PREPARING REPORT section. Then, forward the Invoice Workbook to the Authorized Financial Officer for review and approval."]
[]
[" AUTHORIZED FINANCIAL OFFICER"]
["The Authorized Financial Officer is the Financial Officer listed in the Grant Agreement, STD 213 and/or Grantee Contact Information Sheet, Form 227."]
["The Authorized Financial Officer cannot be the Project Director or the individual preparing the invoice."]
["The Authorized Financial Officer must review each line item expenditure and description. Then, approve the invoice by checking the certification box and providing their contact information and the date of approval."]
["Once the invoice is approved, the Authorized Financial Officer shall email the Invoice Workbook to the any grant inbox: adultreentrygrant@bscc.ca.gov. The Authorized Financial Officer is the only authorized party to submit an Invoice Workbook to the BSCC."]
["Approved Financial Invoice "]
["Once BSCC staff reviews and approves the Financial Invoice, an updated Invoice Workbook will be available on the BSCC website. All approved Financial Invoices will be locked from editing but will be viewable in the Invoice Workbook."]
[]
["Advance Payment Invoice – Form 201A"]
[]
["How to Complete the Advance Payment Invoice "]
["Each Advance Payment Invoice has a separate workbook tab titled, # ADVANCE PAYMENT. The Advance Payment Invoice will allow grantees to enter data into the green shaded fields; all other fields are locked. "]
["To complete the Advance Payment form, grantees must complete the following:"]
["\u0097 Idenitfy the effective invoice"]
["\u0097\u0097\u0097 Idenitfy the person preparing the report"]
["\u0097 Complete the information and signature for the Authorized Financial Officer."]
["Advance Disbursement Details"]
["Grantees will receive three advance payments throughout the life of the grant agreement. Each advance payment will be one-third of the total grant award."]
["Eighty percent of the total advance disbursement must be expended prior to requesting the next advance payment."]
["Approved Advance Payment Invoice"]
["Once BSCC staff reviews and approves the Advance Payment Invoice, the updated Invoice Workbook will be emailed to the Authorized Financial Officer and the individual that prepared the report. All approved Advance Payment Invoices will be locked from editing but will be viewable in the Invoice Workbook."]
[]
["Modification Request - Form BSCC 223.1"]
[]
["Modification Request Requirements "]
["It is the grantees responsibility to receive prior approval from the Field Representative for modifications to the budget or budget narrative. Once the Field Representative approves a modification to the budget or budget narrative, the grantee may complete and submit a Modification Request."]
["The Modification Request Form allows the grantee to:\n\u0097 Make a change within a line-item change that modifies the grant project narrative, but does not change the total dollar amount of the line item.\n\u0097 Modify the budget by moving funds from one line item to another; or\n\u0097 Allocate earned project income "]
[]
["The grantee must allow a minimum of 10 working days, for the modification form to be submitted and approved by the BSCC prior to completing the next invoice."]
[]
["How to Complete a Modification Request "]
["Grantees can access the Modification Request form by selecting the tab titled, MODIFICATION REQUEST. For the Modification Request form, grantees can enter data into the yellow-shaded fields; all other fields are locked. First, the grantee must select the purpose of the modification by checking the appropriate box in the yellow section at the top of the form."]
[]
["The following instructions are for the yellow-shaded fields in the Modification Request to be completed by the Grantee. "]
[]
["Modification Request # and Effective on Invoice #"]
["The grantee shall identify the budget modification number by selecting the next number in sequential order (1 if it's the first) and then identify on which invoice the modification becomes effective."]
[]
[" CHANGES (+/-) and JUSTIFICATION FOR MODIFIED BUDGET"]
["Line-item changes -   Complete only the JUSTIFICATION FOR MODIFICATION section below the budget table. The justification must: list the affected line-item(s), detail how the original budget narrative has changed, and explain why the change is necessary. Line-item changes do not change  the budget $$.\n\nBudget modifications - complete the CHANGES (+/-) section by using a + (plus symbol) followed by a whole dollar amount in the line item that is increasing and using a - (minus symbol) followed by a whole dollar amount in the line item that is decreasing. The TOTAL line must show zeros. In addition, complete the JUSTIFICATION FOR MODIFICATION section. The justification must: list the affected line-item(s), detail how the original budget narrative has changed, and explain why the change is necessary\n\nProject Income Allocation - use the Project Income column in the CHANGES (+/-) to show how the income will be allocated across line-items. In addition, complete the JUSTIFICATION FOR MODIFICATION section. The justification must: list the affected line-item(s) and provide narrative detail about how the project income will be used to advance program objectives. (See Grant Administration Guide, Section 13, Project and Other Income)"]
[]
["PERSON PREPARING REPORT"]
["The grantee will designate an individual to prepare Modification Requests. The Authorized Financial Officer cannot prepare Modification Requests."]
["The individual who prepares the request will provide their contact information and the date the modification was prepared under the PERSON PREPARING REPORT section. Then, forward the Invoice Workbook to the Authorized Financial Officer for review and approval."]
[]
[" AUTHORIZED FINANCIAL OFFICER"]
["The Authorized Financial Officer is the Financial Officer listed in the Grant Agreement, STD 213 and/or Grantee Contact Information Sheet, Form 227."]
["The Authorized Financial Officer cannot be the Project Director or the individual preparing the modification request."]
["The Authorized Financial Officer must review each line item change, narrative change and justifications. Then, approve the modification request by checking the certification box and providing their contact information and the date of approval."]
["Once the modification request is approved, the Authorized Financial Officer shall email the Invoice Workbook to the any grant inbox: adultreentrygrant@bscc.ca.gov. The Authorized Financial Officer is the only authorized party to submit it an Invoice Workbook to the BSCC."]
[]
["Approved Modification Request"]
["Once BSCC staff reviews and approves the Modification Request, the updated Invoice Workbook will be emailed to the Authorized Financial Officer and the individual who prepared the re quest. All approved modifications will be locked from editing but will be viewable in the Invoice Workbook."]