{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["1st Advance Payment","BM 1","INVOICE 1","INVOICE 1 REVISED","INVOICE 2","INVOICE 3","INVOICE 4","INVOICE 5","INVOICE 6","2nd Advance Payment","INVOICE 7","INVOICE 8","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","INVOICE 13","INVOICE 15","INVOICE 14","3rd Advance Payment","MODIFICATION REQUEST","Project Budget NARRATIVE","INVOICE DUE DATES","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":26,"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: 2480"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:","Adult Reentry Grant ",null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"ARSOLA's Distribution Center & Community Services"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 416-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 5520"}]
[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":"Oakland, CA 94605"}]
[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":"ARSOLASFOO-001"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2019-10-23",null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146589}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"BM 1","index":1,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,8,73,10],[73,15,73,16],[66,8,66,12],[67,8,67,12],[68,8,68,12],[69,8,69,12],[72,0,72,1],[72,8,72,10],[59,0,59,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[64,8,64,12],[65,8,65,12],[54,8,63,12],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[32,0,32,12],[33,0,33,12],[34,0,51,12],[53,0,53,2],[53,8,53,12],[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[19,0,20,0],[19,1,19,3],[19,4,19,6],[19,7,19,9],[19,10,19,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":"ARSOLA's Distribution Center & Community Services"},null,null,null,null,null,null,"Program:",{"$f":"'INVOICE 1 REVISED'!B5","v":"Adult Reentry Grant"}]
[]
["Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 5520"},null,null,null,null,null,null,"Project Title:",{"$f":"'INVOICE 15'!G7","v":"RA"}]
[]
[null,{"$f":"'INVOICE 15'!L58","v":"Oakland, CA 94605"}]
[]
["Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 416-19"},null,null,null,null,null,null,null,"Modification Request #",1]
[]
["Term:",{"$f":"'INVOICE 1 REVISED'!E9","v":"2019-08-01"},{"$f":"'INVOICE 1 REVISED'!F9","v":"TO"},{"$f":"'INVOICE 1 REVISED'!G9","v":"2023-02-28"},null,null,null,null,null,"Effective on Invoice #",1]
[]
["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",930300,0,{"$f":"SUM(B22:C22)","v":930300},{"$f":"'INVOICE 1 REVISED'!K15","v":833387},{"$f":"'INVOICE 1 REVISED'!L15","v":0},{"$f":"SUM(E22:F22)","v":833387},-96913,0,{"$f":"SUM(H22:I22)","v":-96913},{"$f":"SUM(B22,H22)","v":833387},0,{"$f":"SUM(K22:L22)","v":833387}]
["Services & Supplies",2027975,0,2027975,{"$f":"'INVOICE 1 REVISED'!K16","v":2042200},{"$f":"'INVOICE 1 REVISED'!L16","v":0},2042200,14225,0,14225,2042200,0,2042200]
["Professional Services",27700,0,27700,{"$f":"'INVOICE 1 REVISED'!K17","v":71000},{"$f":"'INVOICE 1 REVISED'!L17","v":0},71000,43300,0,43300,71000,0,71000]
["NGO Subcontracts",0,0,0,{"$f":"'INVOICE 1 REVISED'!K18","v":0},{"$f":"'INVOICE 1 REVISED'!L18","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",2170,0,2170,{"$f":"'INVOICE 1 REVISED'!K19","v":0},{"$f":"'INVOICE 1 REVISED'!L19","v":0},0,-2170,0,-2170,0,0,0]
["Data Collection & Progress Reporting",0,0,0,{"$f":"'INVOICE 1 REVISED'!K20","v":0},{"$f":"'INVOICE 1 REVISED'!L20","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",4360,0,4360,{"$f":"'INVOICE 1 REVISED'!K21","v":4360},{"$f":"'INVOICE 1 REVISED'!L21","v":0},4360,0,0,0,4360,0,4360]
["Indirect Costs",7495,0,7495,{"$f":"'INVOICE 1 REVISED'!K22","v":49053},{"$f":"'INVOICE 1 REVISED'!L22","v":0},49053,41558,0,41558,49053,0,49053]
["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 1 REVISED'!D25","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1 REVISED'!G25","v":0},"Allocating",{"$f":"I30","v":0},null,null,"Unallocated income balance",{"$f":"D32-I32","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
["ARSOLA’s\nBudget Mod #1\nEffective Invoice 1\n\nAt the outset of this project we had fiscal personnel writing the budget and managing the invoices who were not qualified and did not perform as they should have.  As a result, we have terminated those staff and have hired a consultant to clean up our budget and implement stricter fiscal controls.  As such, we are requesting to modify our budget, effective invoice #1 because, even though invoice #1 was submitted and approved, it was $100 for office supplies.  We are requesting to submit a revised $0 invoice #1 and those costs will be absorbed by the organization because we are actually planning to use indirect costs to cover office supplies.  We are also requesting to submit the modified budget as such because there were several miscalculations throughout each line item category in the initial budget.  Our modified budget would be as follows: \nSalaries and Benefits Line Item Category: \nPosition Title % FTE or Hourly Rate & Benefits Grant Funds\nProject Director $10,000*.75% FTE = $7,500x43 months - No Benefits \n $322,500\nAdministrative Coordinator $7,500*.25% FTE=$1,875x15 months - No Benefits $28,125\nFinancial Officer  $8,000*.25% FTE=$2,000x43 months - No Benefits\n   $ 86,000\nFinancial Assistant $6,400*.50% FTE=$3,200x17 months - No Benefits\n $54,400   \nData Manager $7,500*.50% FTE=$3,750x15 months - No Benefits\n    $56,250\nExecutive Assistant $4,320*.75% FTE=$3,240x28 months - No Benefits\n    $90,720\nProgram Manager $5,000*.75% FTE=$3,750x28 months - No Benefits\n  $105,000\nSalary Deductions Eliminated line item 0\nEmployer Payroll Taxes Total Salaries $742,995 average 10% of Wages for 43 months $74,300\nPayroll Processing Fees Total ADP average monthly payroll processing, Quarterly/Annual payroll reports, HR service fees for 43 months 10,932\nWorkers Compensation Insurance Estimated $120 for 43 months 5,160\n Total 833,387\nJustification:\nWe request the Project Director be increased by $7,500 to correct a miscalculation of the time of service from 3.5 years to 43 months. \nWe request for the Administrative Coordinator position to be a temporary position that will be funded from 8/1/2019-10/31/2020.  This position will be eliminated as of 10/31/2020 because it is being replaced by the Executive Assistant.  \nWe request to reduce the time allocation for the Financial Officer from .50 FTE to .25 FTE because we realized the Financial Officer was not spending .50 FTE to complete the responsibilities for that position. \nWe request to add a new detail line item allocation of $54,400 for a Financial Assistant position to be a temporary position to perform bookkeeping and payroll processing duties that will be funded from 9/1/2019-1/31/2021.  This position will be eliminated as of 1/31/2021 and duties will be incorporated by the Financial Officer.   \nWe request for the Data Manager position to be a temporary position that will be funded from 8/1/2019-10/31/2020.   This position will be eliminated as of 10/31/2020 because these duties are being incorporated into the Program Manager position. \nWe request to add a new detail line for an Executive Assistant allocating $90,720 because we realized we need a daily operating assistant to coordinate and maintain our program responsibilities as well as requirements (job description attached)\nWe request to add a new detail line for a Program Manager allocating $105,000 because we recognize that we need an employee that focuses on our program activities, participant recruitments, supportive services, outcomes and to further develop the program requirements (job description attached)\nWe are eliminating the Salary Deductions line item expenditures originally budgeted in this category because it did not relate to any payroll expenses.  \nWe request to add a new detail line for Employer Payroll Taxes allocating $74,300 because the original budget did not include the Payroll Tax portion paid by Employer.  Average amount is 10% of wages.\nWe request to add a new detail line for Payroll Process Fees allocating $10,932 because the original did not include payroll service fees.  These fees cover expenses such as Payroll Processing, Human Resource Support, Quarterly Reports and Annual Reports. \nWe request to add a new detail line for Workers Compensation Insurance allocating $5,160 because the original budget did not include Worker’s Compensation Insurance for staff. \n\nServices and Supplies Line Item Category: \nDescription of Service or Supplies Calculation for Expenditure Grant Funds\nOffice Rent $1,500 a month for 29 months $43,500\nParticipant Rent $1,500 a month for 68 participants for19 months $1,938,000\nSecurity Deposit $1,500 avg. rent deposits for 34 properties $51,000\nMove-In & Move Out Costs $125 Est. average cost x 30 units / $3,750\n$175 Est x   x 34 units / $5,950 $9,700\n Total $2,042,200\nJustification: \nWe are requesting to eliminate the detail lines for Office Supplies because we plan to address these costs via the Indirect Cost Line Item Category.\nWe are requesting to eliminate the detail line for Office Services because those costs were originally miscalculated and not properly identified.\nThe Rental Services detail line is being eliminated because utilities are included in the monthly rent amount.  \nWe are requesting to add a new detail line for Office Rent because it is necessary to have an office suite for the maintenance of the ARG program records and documents and to interview the incoming participants.  We secured the new office space effective 10/1/2020 in the amount of $1500 per month.  \nWe are requesting to add a new detail line for Security Deposits allocating $51,000 because this was originally included with the “Participant Rents” and we discovered that we will not likely need to pay deposits for each participant because we will backfill vacancies as participants are eligible to remain in housing for 19 months.  \nWe are requesting to add a new detail line for Move-In & Move-Out Costs allocating $8680 because the original budget did not include these costs.  Estimated average costs will cover: \n Cleaning, Furnishing & Supplies   $125 x 30 units = $3750\n Repairs & Maintenance         $175 x 34 units = $4930\n Total           = $8680\n\nWe are also requesting to change the detail line originally identified as “Rents” to “Participant Rents” and we are reducing that line from $1,968,000 to $1,938,000 because the original budget miscalculated rents for 32 units @ $1500 and included $4500 for deposits and expenses.  However, the “Participant Rents” should be calculated at $1500 x 19 months x 68 participants = $1,938,000.  \n\nProfessional Services: \nDescription of Professional Service  Calculation for Expenditure Grant Funds\nOperational Consultant Average $2,000 a month for 28 months 56,000\nAccountant (CPA) Average $3,000 a year for 2019-2023 reporting periods. 15,000\n Total 71,000\nJustification:\nWe are requesting to eliminate the original detail line items for Legal and Website Maintenance because these costs are more appropriately accounted for in the Indirect Cost Line Item Category.\nThe Project Assistant is being eliminated because we realized the duties and tasks that were originally identified are included in the salary position of the Program Manager, as such, this position was not necessary.\nThe Operational Consultant is a new addition and will support the projects State compliances requirements and to develop an operational system to provide computerized analysis of program financials & service outcomes.  The position will be paid an average of $2,000 each month; however, the actual monthly charges may vary each month.  \nThe CPA will be responsible for preparing Financial Statements and Tax Returns for the exclusive preparation of ARG program years 2019-2023.\n\nNon-Governmental Organizations (NGO) Subcontracts Line Item Category: \nNO CHANGE    $0\n\nEquipment/Fixed Assets Line Item Category:\nWe are eliminating the expenditures originally budgeted in this category.  \nJustification:\nWe are eliminating the items charged in the original budget because the expense is nominal and would be better accounted for in the Indirect Cost Line Item. \n\nData Collection and Progress Reporting Line Item Category: \nNO CHANGE    $0\nOther (Travel, Training, etc.) Line Item Category: \nNO CHANGE     $4360\n\nIndirect Cost Line Item Category: \n5% of total project cost  $49,053.\nJustification:\nTo correct a miscalculation of the original budget submitted which allocated $7,495.  We want to add $41,558 to this category to include indirect costs for operational rental assistance expenses.  Amount will be no more than allowed amount based on the calculation of the budget."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Jennifer Walker-Kemp, Operational Consultant"]
["Name, Title"]
["510) 798-1855"]
["Phone"]
["jennifersbie@sbcglobal.net"]
["Email"]
["2021-01-14"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(443) 253-0421"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2021-01-14"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-01-14",null,null,null,null,"Approved By:","Tanya Hill",null,null,"Date:","2021-01-15"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 1","index":2,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,0,68,1],[68,6,68,7],[68,8,68,10],[69,0,69,7],[69,8,69,10],[58,0,58,2],[58,11,58,13],[67,0,67,12],[59,11,59,13],[60,4,60,9],[60,11,60,13],[61,4,61,9],[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],[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,"Purchase Order: 2480"]
["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:","ARSOLA's Distribution Center & Community Services",null,null,null,"Project Title:","RA"]
[]
["Contract #:","BSCC 416-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",930300,0,{"$f":"SUM(B15:C15)","v":930300},0,0,{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":930300},0,{"$f":"SUM(K15:L15)","v":930300},"1st Advance [10/23/19]"]
["Services & Supplies",2027975,0,2027975,0,0,{"$f":"SUM(E16:F16)","v":0},100,0,100,2027875,0,2027875,{"$f":"'1st Advance Payment'!K20","v":1000000}]
["Professional Services",27700,0,27700,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,27700,0,27700]
["NGO Subcontracts",0,0,0,0,0,0,0,0,0,0,0,0,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",2170,0,2170,0,0,0,0,0,0,2170,0,2170,0]
["Data Collection & Progress Reporting",0,0,0,0,0,0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",4360,0,4360,0,0,0,0,0,0,4360,0,4360,"3rd Advance\n [enter date]"]
["Indirect Costs",7495,0,{"$f":"SUM(B22:C22)","v":7495},0,0,0,0,0,0,7495,0,7495,0]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,100,0,100,2999900,0,2999900,{"$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":100},null,null,"Grant funds claimed this period:",{"$f":"H23","v":100},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":999900},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":1E-4}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0},0]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":100},"$33-shipping to BSCC/$67-supplies (2 printer ink)",null,null,null,null,null,null,null,"See receipts attached"]
[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."]
["Candi Thornton, Project Director",null,null,null,null,null,null,null,null,null,null,146589]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510-830-7851",null,null,null,null,null,null,null,null,null,null,"ARSOLASFOO-001"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["arsolahouse@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,"P.O. Box 5520"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-07-16",null,null,null,null,null,null,null,null,null,null,"Oakland, CA 94605"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Laura McCoy, Financial Manager (Acting)"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"415-902-5249"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-07-16"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-07-17",null,null,null,"Approved By:",null,"Tanya Hill ",null,null,null,"Date: ","2020-07-20"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 1 REVISED","index":3,"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: 2480"]
["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:","ARSOLA's Distribution Center & Community Services",null,null,null,"Project Title:","RA"]
[]
["Contract #:","BSCC 416-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",833387,0,{"$f":"SUM(B15:C15)","v":833387},0,0,{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":833387},{"$f":"C15-F15-I15","v":0},{"$f":"SUM(K15:L15)","v":833387},"1st Advance [10/23/19]"]
["Services & Supplies",2042200,0,2042200,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,2042200,0,2042200,{"$f":"'1st Advance Payment'!K20","v":1000000}]
["Professional Services",71000,0,71000,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,71000,0,71000]
["NGO Subcontracts",0,0,0,0,0,0,0,0,0,0,0,0,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Data Collection & Progress Reporting",0,0,0,0,0,0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",4360,0,4360,0,0,0,0,0,0,4360,0,4360,"3rd Advance\n [enter date]"]
["Indirect Costs",49053,0,{"$f":"SUM(B22:C22)","v":49053},0,0,0,0,0,0,49053,0,49053,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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,146589]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,"ARSOLASFOO-001"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,"P.O. Box 5520"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-01-17",null,null,null,null,null,null,null,null,null,null,"Oakland, CA 94605"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(443) 253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-01-17"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-01",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-03-05"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 2","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 1 REVISED'!L2:N2","v":"Purchase Order: 2480"}]
["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 REVISED'!B7","v":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 1 REVISED'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 1 REVISED'!B9","v":"BSCC 416-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 REVISED'!B15","v":833387},{"$f":"'INVOICE 1 REVISED'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 1 REVISED'!E15,'INVOICE 1 REVISED'!H15)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F15,'INVOICE 1 REVISED'!I15)","v":0},{"$f":"SUM(E15:F15)","v":0},96036,0,{"$f":"SUM(H15:I15)","v":96036},{"$f":"B15-E15-H15","v":737351},0,{"$f":"SUM(K15:L15)","v":737351},{"$f":"'INVOICE 1 REVISED'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 1 REVISED'!B16","v":2042200},{"$f":"'INVOICE 1 REVISED'!C16","v":0},2042200,{"$f":"SUM('INVOICE 1 REVISED'!E16,'INVOICE 1 REVISED'!H16)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F16,'INVOICE 1 REVISED'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},38560,0,38560,2003640,0,2003640,{"$f":"'INVOICE 1 REVISED'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 1 REVISED'!B17","v":71000},{"$f":"'INVOICE 1 REVISED'!C17","v":0},71000,{"$f":"SUM('INVOICE 1 REVISED'!E17,'INVOICE 1 REVISED'!H17)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F17,'INVOICE 1 REVISED'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,71000,0,71000]
["NGO Subcontracts",{"$f":"'INVOICE 1 REVISED'!B18","v":0},{"$f":"'INVOICE 1 REVISED'!C18","v":0},0,{"$f":"SUM('INVOICE 1 REVISED'!E18,'INVOICE 1 REVISED'!H18)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F18,'INVOICE 1 REVISED'!I18)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 1 REVISED'!N18","v":"2nd Advance \n[enter date]"}]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1 REVISED'!B19","v":0},{"$f":"'INVOICE 1 REVISED'!C19","v":0},0,{"$f":"SUM('INVOICE 1 REVISED'!E19,'INVOICE 1 REVISED'!H19)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F19,'INVOICE 1 REVISED'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 1 REVISED'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 1 REVISED'!B20","v":0},{"$f":"'INVOICE 1 REVISED'!C20","v":0},0,{"$f":"SUM('INVOICE 1 REVISED'!E20,'INVOICE 1 REVISED'!H20)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F20,'INVOICE 1 REVISED'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 1 REVISED'!B21","v":4360},{"$f":"'INVOICE 1 REVISED'!C21","v":0},4360,{"$f":"SUM('INVOICE 1 REVISED'!E21,'INVOICE 1 REVISED'!H21)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F21,'INVOICE 1 REVISED'!I21)","v":0},0,417,0,417,3943,0,3943,{"$f":"'INVOICE 1 REVISED'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 1 REVISED'!B22","v":49053},{"$f":"'INVOICE 1 REVISED'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 1 REVISED'!E22,'INVOICE 1 REVISED'!H22)","v":0},{"$f":"SUM('INVOICE 1 REVISED'!F22,'INVOICE 1 REVISED'!I22)","v":0},0,6751,0,6751,42302,0,42302,{"$f":"'INVOICE 1 REVISED'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,0,0,0,141764,0,141764,2858236,0,2858236,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1 REVISED'!D25+I25","v":104},null,"Prior allocated income",0,"This Period",104,null,null,"Unallocated income balance",{"$f":"D25-G25","v":104}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":141764},null,null,"Grant funds claimed this period:",{"$f":"H23","v":141764},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":858236},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.141764}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":96036},"Project Director - Candi Thornton - $9,944.40 month @ .75% = $7,083.34  x  2 months =$14,166.68 Retro Pay Periods 8/1/2019-09/30/2019\nProject Director $9,944.40 month @ .75% = $7,083.34  x 1 month = $7,083.34 Retro Pay Period 10/1/2019 -10/31/2019\nProject Director $10,000.00 month @ .75% = $7,500.00 x 2 months = $15,000.00 Pay Period 11/1/2019 - 12/31/2019\n\nData Manager - Laura McCoy (Aug 2019) $7,500.00 month @ .50% = $3,750.00 x 1 month = $3,750.00 Retro Pay Periods 8/1/-31/2019\nData Manager - Letica Rivera $ 7,500.00 month @ .50% = $3,750.00 x 2 months = $7,500.00 Retro Pay Periods 9/1/2019-10/30/2019\nData Manager - Laura McCoy (Nov 2019) $7,500.00 month @ .50% = $3,750.00 x  1 month = $3,750.00 Pay Period 11/1-30/2019\nData Manager - Laura McCoy (Dec 2019) $7,500.00 month @ .50% = $3,750.00  x 1 month = $3,750.00 Pay Period 12/1-31/2019\n\nFinancial Assistant - Laura McCoy (Sep 2019) $3,066.64 month @ .50% = $1,533.32 x 1 month = $1,533.32  Retro Pay Period 9/1-30/2019\nFinancial Assistant - Bernice Tingle $3,333.36 month @ .50% = $1,666.68 x 2 months = $3,333.36 Retro Pay Periods 09/1/2019 - 10/31/2019\nFinancial Assistant - Laura McCoy  (Oct 2019)$3,066.64 month @ .50% = $1,533.32 x 1 month = $1,533.32 Retro Pay Period 10/1-31/2019\nFinancial Assistant - Laura McCoy (Nov 2019) $2,400.00 month @ .50% = $1,200.00 x 1 month = $1,200.00 Pay Period 11/1-30/2019\nFinancial Assistant - Bernice Tingle $4,000.00 month @ .50% = $2,000.00  x 2 months = $4,000.00 Pay Periods 11/1/2019 - 12/31/2019\nFinancial Assistant - Laura McCoy (Dec 2019) $2,400.00 month @ .50% = $1,200.00 x 1 month = $1,200.00 Pay Period 12/1-31/2019\n\nFinancial Officer - Laura McCoy (Aug 2019) $8,000.00 month @ .25% = $2,000.00 x 1 month = $2,000.00 Retro Pay Period  8/1/2019-08/01/2019\nFinancial Officer - Laura McCoy (Sep 2019) $8,000.00 month @ .25% = $2,000.00 x 1 month = $2,000.00 Retro Pay Period 9/1/2019-09/30/2019\nFinancial Officer - Laura McCoy (Oct 2019) $8,000.00 month @ .25% = $2,000.00 x 1 month = $2,000.00 Retro Pay Period 10/1/2019 -10/31/2019\nFinancial Officer - Laura McCoy (Nov 2019) $2,700.00 month @ .25% = $675.00 x 1 month = $675.00 Pay Period 11/1/2019 - 11/30/2019\nFinancial Officer - Laura McCoy (Dec 2019) $2,700.00 month @ .25% = $675.00 x 1 month = $675.00 Pay Period 12/1/2019 - 12/31/2019\n\nAdministrative Coordinator - Laura McCoy (Aug 2019) $3,333.36 month @ .25% = $1,333.34 x 1 month = $1,333.34 Retro Pay Periods 8/1-31/2019\nAdministrative Coordinator - Laura McCoy (Sep 2019) $7,500.00 month @ .25% = 1,875.00 x 1 month = $1,875.00 Retro Pay Periods 9/1-30/2019\nAdministrative Coordinator - Laura McCoy (Oct 2019) $7,500.00 month @ .25% = 1,875.00 x 1 month = $1,875.00 Retro Pay Period 10/1-30/2019 \nAdministrative Coordinator - Laura McCoy (Nov 2019) $7,500.00 month @ .25% = 1,875.00 x 1 month = $1,875.00 Pay Period 11/1-30/2019\nAdministrative Coordinator - Laura McCoy (Dec 2019) $7,500.00 month @ .25% = 1,875.00 x 1 month = $1,875.00 Pay Period 12/1-31/2019\n\nProgram Manager - Laura McCoy (Sep 2019) $2,233.36 month @ .75% = $1,675.02 x 1 month = $1,675.02 Retro Pay Period 9/1/2019-09/30/2019\nProgram Manager - Laura McCoy (Oct 2019) $2,233.36 month @ .75% = $1,675.02  x 1 month = $1,675.02 Retro Pay Period 10/1/2019 -10/31/2019\n\nPayroll Processing Fees $490.80, Workers Comp $382.90, Employer Payroll Taxes $7,828.99 "]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":38560},"13 Rents Participants $27,059.60,12 Rental Security Deposits $11,500.00 = $38,559.60"]
[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":417},"Travel & Per Diem $164.00, Mileage $252.52 = $416.52 for training in Sacramento"]
[null,"Project Income",{"$f":"I21","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H22","v":6751},"Total Expenses $135,013  x  5% = $6,750.65"]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":104},"Income is Interest Income from acounts saving $104 and checking $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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1 REVISED'!L52:N52","v":146589}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1 REVISED'!L54:N54","v":"ARSOLASFOO-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1 REVISED'!L56:N56","v":"P.O. Box 5520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-01-17",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1 REVISED'!L58:N58","v":"Oakland, CA 94605"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"443-253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-03-01"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-05",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-03-09"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 3","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 2'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 2'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 2'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 2'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 2'!E15,'INVOICE 2'!H15)","v":96036},{"$f":"SUM('INVOICE 2'!F15,'INVOICE 2'!I15)","v":0},{"$f":"SUM(E15:F15)","v":96036},56303,0,{"$f":"SUM(H15:I15)","v":56303},{"$f":"B15-E15-H15","v":681048},0,{"$f":"SUM(K15:L15)","v":681048},{"$f":"'INVOICE 2'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":2042200},{"$f":"'INVOICE 2'!C16","v":0},2042200,{"$f":"SUM('INVOICE 2'!E16,'INVOICE 2'!H16)","v":38560},{"$f":"SUM('INVOICE 2'!F16,'INVOICE 2'!I16)","v":0},{"$f":"SUM(E16:F16)","v":38560},76500,0,76500,1927140,0,1927140,{"$f":"'INVOICE 2'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 2'!B17","v":71000},{"$f":"'INVOICE 2'!C17","v":0},71000,{"$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,71000,0,71000]
["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":0},{"$f":"'INVOICE 2'!C19","v":0},0,{"$f":"SUM('INVOICE 2'!E19,'INVOICE 2'!H19)","v":0},{"$f":"SUM('INVOICE 2'!F19,'INVOICE 2'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 2'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 2'!B20","v":0},{"$f":"'INVOICE 2'!C20","v":0},0,{"$f":"SUM('INVOICE 2'!E20,'INVOICE 2'!H20)","v":0},{"$f":"SUM('INVOICE 2'!F20,'INVOICE 2'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 2'!B21","v":4360},{"$f":"'INVOICE 2'!C21","v":0},4360,{"$f":"SUM('INVOICE 2'!E21,'INVOICE 2'!H21)","v":417},{"$f":"SUM('INVOICE 2'!F21,'INVOICE 2'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 2'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 2'!B22","v":49053},{"$f":"'INVOICE 2'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 2'!E22,'INVOICE 2'!H22)","v":6751},{"$f":"SUM('INVOICE 2'!F22,'INVOICE 2'!I22)","v":0},6751,6640,0,6640,35662,0,35662,{"$f":"'INVOICE 2'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,141764,0,141764,139443,0,139443,2718793,0,2718793,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 2'!D25+I25","v":286},null,"Prior allocated income",0,"This Period",182,null,null,"Unallocated income balance",{"$f":"D25-G25","v":286}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":281207},null,null,"Grant funds claimed this period:",{"$f":"H23","v":139443},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":718793},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.28120699999999998}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":56303},"Project Director - Candi Thornton $10,000.00 month @ .75% = $7,500.00 x 3 months = $22,500.00 Pay Period 1/1/2020-03/31/2020\n\nData Manager - Laura McCoy (Jan- Mar 2020) $7,500.00 month @ .50% = $3,750.00  x 3 month = $11,250.00 Pay Period 1/1/2020-03/31/2020\n\nFinancial Assistant - Bernice Tingle $4,000.00 month @ .50% = $2,000.00 x 3months = $6,000.00 Pay Period 1/1/2020-03/31/2020\nFinancial Assistant - Laura McCoy (Jan-Mar 2020) $2,400.00 month @ .50% = $1,200.00 x 3 month = $3,600.00 Pay Period 1/1/2020-03/31/2020\n\nAdministrative Coordinator - Laura McCoy (Jan-Mar 2020) $7,500.00 month @ .25% = $1,875.00 x 3 month = $5,625.00 Pay Period 1/1/2020-03/31/2020\n\nProgram Manager - Laura McCoy (Jan-Mar 2020) $900.00 month @ .75% = $675.00 x 3 month = $2,025.00 \nPay Period 1/1/2020-03/31/2020\n\nPayroll Processing Fees $323.44, Workers Comp $258.11, Employer Payroll Taxes $4,721.56 "]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":76500},"17 Rents Participants $70,500.00, 4 Security Deposits $6,000.00 = $76,500.00"]
[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":6640},"Total Expenditures $132,803 x.5% = $6,640."]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":182},"Income is from Interest Income from accounts Savings $182 Checking $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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L52:N52","v":146589}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L54:N54","v":"ARSOLASFOO-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L56:N56","v":"P.O. Box 5520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-01-17",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!L58:N58","v":"Oakland, CA 94605"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"443-253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-03-01"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-08",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-03-09"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","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 3'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 3'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 3'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 3'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 3'!E15,'INVOICE 3'!H15)","v":152339},{"$f":"SUM('INVOICE 3'!F15,'INVOICE 3'!I15)","v":0},{"$f":"SUM(E15:F15)","v":152339},55531,0,{"$f":"SUM(H15:I15)","v":55531},{"$f":"B15-E15-H15","v":625517},0,{"$f":"SUM(K15:L15)","v":625517},{"$f":"'INVOICE 3'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":2042200},{"$f":"'INVOICE 3'!C16","v":0},2042200,{"$f":"SUM('INVOICE 3'!E16,'INVOICE 3'!H16)","v":115060},{"$f":"SUM('INVOICE 3'!F16,'INVOICE 3'!I16)","v":0},{"$f":"SUM(E16:F16)","v":115060},136932,0,136932,1790208,0,1790208,{"$f":"'INVOICE 3'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 3'!B17","v":71000},{"$f":"'INVOICE 3'!C17","v":0},71000,{"$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,71000,0,71000]
["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":0},{"$f":"'INVOICE 3'!C19","v":0},0,{"$f":"SUM('INVOICE 3'!E19,'INVOICE 3'!H19)","v":0},{"$f":"SUM('INVOICE 3'!F19,'INVOICE 3'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 3'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 3'!B20","v":0},{"$f":"'INVOICE 3'!C20","v":0},0,{"$f":"SUM('INVOICE 3'!E20,'INVOICE 3'!H20)","v":0},{"$f":"SUM('INVOICE 3'!F20,'INVOICE 3'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 3'!B21","v":4360},{"$f":"'INVOICE 3'!C21","v":0},4360,{"$f":"SUM('INVOICE 3'!E21,'INVOICE 3'!H21)","v":417},{"$f":"SUM('INVOICE 3'!F21,'INVOICE 3'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 3'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 3'!B22","v":49053},{"$f":"'INVOICE 3'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 3'!E22,'INVOICE 3'!H22)","v":13391},{"$f":"SUM('INVOICE 3'!F22,'INVOICE 3'!I22)","v":0},13391,9623,0,9623,26039,0,26039,{"$f":"'INVOICE 3'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,281207,0,281207,202086,0,202086,2516707,0,2516707,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 3'!D25+I25","v":353},null,"Prior allocated income",0,"This Period",67,null,null,"Unallocated income balance",{"$f":"D25-G25","v":353}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":483293},null,null,"Grant funds claimed this period:",{"$f":"H23","v":202086},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":516707},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.48329299999999997}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":55531},"Project Director - Candi Thornton $10,000.00 month @ .75% = $7,500.00 x 3 months = $22,500.00 Pay Period 4/1/2020-6/30/2020\n\nData Manager - Laura McCoy (Apr-Jun 2020) $7,500.00 month @ .50% = $3,750.00  x 3 month = $11,250.00 Pay Period 4/1/2020-6/30/2020\n\nFinancial Assistant - Bernice Tingle $4,000.00 month @ .50% = $2,000.00 x 3months = $6,000.00 Pay Period 4/1/2020-6/30/2020\nFinancial Assistant - Laura McCoy (Apr-Jun 2020) $2,400.00 month @ .50% = $1,200.00 x 3 month = $3,600.00 Pay Period 4/1/2020-6/30/2020\n\nAdministrative Coordinator - Laura McCoy (Apr-Jun 2020) $7,500.00 month @ .25% = 1,875.00 x 3 month = $5,625.00 Pay Period 4/1/2020-6/30/2020\n\nProgram Manager - Laura McCoy (Apr-Jun 2020) $900.00 month @ .75% = $675.00 x 3 month = $2,025.00 Pay Period 4/1/2020-6/30/2020\n\nPayroll Processing Fees $338.65, Workers Comp $249.66, Employer Payroll Taxes $3,942.56 "]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":136932},"30 Rents Participants $115,500, 14 Security Deposits $21,000.00, Move-In & Move-Out Cost $431.71 = Total $136,931.71"]
[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":9623},"Total Expenditures $192,462.58 @ 5% = $9,623.15 "]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":67},"Income is Interest Income from accounts Savings $67 and Checking $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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L52:N52","v":146589}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L54:N54","v":"ARSOLASFOO-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L56:N56","v":"P.O. Box 5520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-01-17",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!L58:N58","v":"Oakland, CA 94605"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"443-253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-03-01"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-05",null,null,null,"Approved By:",null,"Tanya Hill ",null,null,null,"Date: ","2021-03-09"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 5","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 4'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 4'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 4'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 4'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 4'!E15,'INVOICE 4'!H15)","v":207870},{"$f":"SUM('INVOICE 4'!F15,'INVOICE 4'!I15)","v":0},{"$f":"SUM(E15:F15)","v":207870},55540,0,{"$f":"SUM(H15:I15)","v":55540},{"$f":"B15-E15-H15","v":569977},0,{"$f":"SUM(K15:L15)","v":569977},{"$f":"'INVOICE 4'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 4'!B16","v":2042200},{"$f":"'INVOICE 4'!C16","v":0},2042200,{"$f":"SUM('INVOICE 4'!E16,'INVOICE 4'!H16)","v":251992},{"$f":"SUM('INVOICE 4'!F16,'INVOICE 4'!I16)","v":0},{"$f":"SUM(E16:F16)","v":251992},171860,0,171860,1618348,0,1618348,{"$f":"'INVOICE 4'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 4'!B17","v":71000},{"$f":"'INVOICE 4'!C17","v":0},71000,{"$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,71000,0,71000]
["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":0},{"$f":"'INVOICE 4'!C19","v":0},0,{"$f":"SUM('INVOICE 4'!E19,'INVOICE 4'!H19)","v":0},{"$f":"SUM('INVOICE 4'!F19,'INVOICE 4'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 4'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 4'!B20","v":0},{"$f":"'INVOICE 4'!C20","v":0},0,{"$f":"SUM('INVOICE 4'!E20,'INVOICE 4'!H20)","v":0},{"$f":"SUM('INVOICE 4'!F20,'INVOICE 4'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 4'!B21","v":4360},{"$f":"'INVOICE 4'!C21","v":0},4360,{"$f":"SUM('INVOICE 4'!E21,'INVOICE 4'!H21)","v":417},{"$f":"SUM('INVOICE 4'!F21,'INVOICE 4'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 4'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 4'!B22","v":49053},{"$f":"'INVOICE 4'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 4'!E22,'INVOICE 4'!H22)","v":23014},{"$f":"SUM('INVOICE 4'!F22,'INVOICE 4'!I22)","v":0},23014,11370,0,11370,14669,0,14669,{"$f":"'INVOICE 4'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,483293,0,483293,238770,0,238770,2277937,0,2277937,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 4'!D25+I25","v":391},null,"Prior allocated income",0,"This Period",38,null,null,"Unallocated income balance",{"$f":"D25-G25","v":391}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":722063},null,null,"Grant funds claimed this period:",{"$f":"H23","v":238770},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":277937},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.72206300000000001}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":55540},"Project Director - Candi Thornton $10,000.00 month @ .75% = $7,500.00 x 3 months = $22,500.00 Pay Period 7/1/2020-9/30/2020\n\nData Manager - Laura McCoy (Jul-Sep 2020) $7,500.00 month @ .50% = $3,750.00  x 3 month = $11,250.00 Pay Period 7/1/2020-9/30/2020\n\nFinancial Assistant - Bernice Tingle $4,000.00 month @ .50% = $2,000.00 x 3months = $6,000.00 Pay Period 7/1/2020-9/30/2020\nFinancial Assistant - Laura McCoy (Jul-Sep 2020) $2,400.00 month @ .50% = $1,200.00 x 3 month = $3,600.00 Pay Period 7/1/2020-9/30/2020\n\nAdministrative Coordinator - Laura McCoy (Jul-Sep 2020) $7,500.00 month @ .25% = 1,875.00 x 3 month = $5,625.00 \nPay Period 7/1/2020-9/30/2020\n\nProgram Manager - Laura McCoy (Jul-Sep 2020) $900.00 month @ .75% = $675.00 x 3 month = $2,025.00 \nPay Period 7/1/2020-9/30/2020\n\nPayroll Processing Fees $388.38 Workers Comp $249.66 Employer Payroll Taxes $3,901.56 "]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":171860},"39 Rent Participants $166,500, 9 Security Deposits $4,500.00, Move-In & Move-Out Cost $859.77= Total $171,859.77"]
[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":11370},"Total |Expenditures $227,399.37 @ 5% = 11,369.96"]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":38},"Income is Interest Income from accounts Savings $38 and Checking $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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L52:N52","v":146589}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L54:N54","v":"ARSOLASFOO-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L56:N56","v":"P.O. Box 5520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-01-28",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!L58:N58","v":"Oakland, CA 94605"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"443-253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-03-01"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-09",null,null,null,"Approved By:",null,"Tanya Hill ",null,null,null,"Date: ","2021-03-10"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","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 5'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 5'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 5'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 5'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 5'!E15,'INVOICE 5'!H15)","v":263410},{"$f":"SUM('INVOICE 5'!F15,'INVOICE 5'!I15)","v":0},{"$f":"SUM(E15:F15)","v":263410},57573,0,{"$f":"SUM(H15:I15)","v":57573},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 5'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":2042200},{"$f":"'INVOICE 5'!C16","v":0},2042200,{"$f":"SUM('INVOICE 5'!E16,'INVOICE 5'!H16)","v":423852},{"$f":"SUM('INVOICE 5'!F16,'INVOICE 5'!I16)","v":0},{"$f":"SUM(E16:F16)","v":423852},184500,0,184500,1433848,0,1433848,{"$f":"'INVOICE 5'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 5'!B17","v":71000},{"$f":"'INVOICE 5'!C17","v":0},71000,{"$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},5885,0,5885,65115,0,65115]
["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":0},{"$f":"'INVOICE 5'!C19","v":0},0,{"$f":"SUM('INVOICE 5'!E19,'INVOICE 5'!H19)","v":0},{"$f":"SUM('INVOICE 5'!F19,'INVOICE 5'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 5'!N19","v":0}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 5'!B20","v":0},{"$f":"'INVOICE 5'!C20","v":0},0,{"$f":"SUM('INVOICE 5'!E20,'INVOICE 5'!H20)","v":0},{"$f":"SUM('INVOICE 5'!F20,'INVOICE 5'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 5'!B21","v":4360},{"$f":"'INVOICE 5'!C21","v":0},4360,{"$f":"SUM('INVOICE 5'!E21,'INVOICE 5'!H21)","v":417},{"$f":"SUM('INVOICE 5'!F21,'INVOICE 5'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 5'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 5'!B22","v":49053},{"$f":"'INVOICE 5'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 5'!E22,'INVOICE 5'!H22)","v":34384},{"$f":"SUM('INVOICE 5'!F22,'INVOICE 5'!I22)","v":0},34384,12398,0,12398,2271,0,2271,{"$f":"'INVOICE 5'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,722063,0,722063,260356,0,260356,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":1000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 5'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",9,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},null,null,"Grant funds claimed this period:",{"$f":"H23","v":260356},null,null,null,"Percent of total disbursed"]
[null,null,null,null,null,null,"Advance Disbursement Balance:",{"$f":"N23-D27","v":17581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.98241900000000004}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":57573},"Project Director - Candi Thornton $10,000.00 month @ .75% = $7,500.00 x 3 months = $22,500.00 Pay Period 10/01/2020 -12/31/2020\n\nData Manager - Laura McCoy (Oct 2020) $7,500.00 month @ .50% = $3,750.00 x 1 month = $3,750\nPay Period 10/01/2020-10/31/2020\n\nFinancial Assistant - Laura McCoy (Oct 2020) $2,400.00 month @ .50% = $1,200.00 x 1 month = $1.200.00 Pay Period 10/01/2020-10/31/2020\nFinancial Assistant - Bernice Tingle $4,000.00 month @ .50% = $2,000.00 x 1months = $2,000.00 Pay Period 10/01/2020-10/31/2020\nFinancial Assistant - Bernice Tingle $6,400.00 month @ .50% = $3,200.00 x 2months = $6,400.00 Pay Period 11/01/2020-12/31/2020\n\nAdministrative Coordinator - Laura McCoy (Oct 2020) $7,500.00 month @ .25% = 1,875.00 x 1 month = $1,875.00 Pay Period 10/01/2020-10/31/2020\n\nProgram Manager - Laura McCoy (Oct 2020) $900.00 month @ .75% = $675.00 x 1 month = $675.00 \nPay Period 10/01/2020-10/31/2020\n\nExecutive Assistant - Succatti Shaw $$4,320.00 month @.75% = $3,240.00 x 2 months = $6,480.00 Pay Period 11/1/2020 - 12/31/2020\n\nProgram Manager - Sam Johnson, Sr. $5,000.00 month @.75% = $3,750.00 x 2 months = $7,500.00 Pay Period 11/1/2020 - 12/31/2020\n\nPayroll Processing Fees $429.02 Workers Comp $204.32 Employer Payroll Taxes $4,559.82"]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":184500},"40 Rent Participants $180,000.00. Office Rents $1,500.00 X 3 months = $4,500.00"]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":5885},"Operational Consultant $5885.00"]
[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":12398},"Total Expenditures $247,958.16 @ 5% = $12,397.90"]
[null,"Project Income",{"$f":"I22","v":0}]
["Project Income Earned",null,{"$f":"I25","v":9},"Income is Interest Income from accounts Savings $9.22 and Checking $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."]
["Jennifer Walker-Kemp, Operational Consultant",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L52:N52","v":146589}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["510 798 1855",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L54:N54","v":"ARSOLASFOO-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifersbie@sbcglobal.net",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L56:N56","v":"P.O. Box 5520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-03-09",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!L58:N58","v":"Oakland, CA 94605"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"443-253-0421"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-03-09"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-03-20",null,null,null,"Approved By:",null,"Tanya Hill",null,null,null,"Date: ","2021-03-23"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"2nd Advance Payment","index":9,"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: 2480"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1 REVISED'!B5","v":"Adult Reentry Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"ARSOLA's Distribution Center & Community Services"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 416-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 5520"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1 REVISED'!E9","v":"2019-08-01"},"TO",{"$f":"'INVOICE 1 REVISED'!G9","v":"2023-02-28"},null,null,null,{"$f":"'INVOICE 15'!L58","v":"Oakland, CA 94605"}]
[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 #","7"]
[]
[]
["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,"Jennifer Walker-Kemp, Operational Consultant",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,"(510) 798-1855"]
[null,"Phone"]
[null,"jennifersbie@sbcglobal.net"]
[null,"Email"]
[null,"2021-03-24"]
[null,"Date"]
[]
[null,null,null,null,null,null,"Latosha Reynolds, Financial Officer"]
[null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,"(443) 253-0421"]
[null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,"Tifon822@yahoo.com"]
[null,null,null,null,null,null,"Email"]
[null,null,null,null,null,null,"2021-03-24"]
[null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,"Latosha Reynolds "]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Tanya Hill",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'INVOICE 15'!L54","v":"ARSOLASFOO-001"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2021-03-23",null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146589}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"INVOICE 7","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 6'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 6'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 6'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 6'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 6'!E15,'INVOICE 6'!H15)","v":320983},{"$f":"SUM('INVOICE 6'!F15,'INVOICE 6'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 6'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":2042200},{"$f":"'INVOICE 6'!C16","v":0},2042200,{"$f":"SUM('INVOICE 6'!E16,'INVOICE 6'!H16)","v":608352},{"$f":"SUM('INVOICE 6'!F16,'INVOICE 6'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 6'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 6'!B17","v":71000},{"$f":"'INVOICE 6'!C17","v":0},71000,{"$f":"SUM('INVOICE 6'!E17,'INVOICE 6'!H17)","v":5885},{"$f":"SUM('INVOICE 6'!F17,'INVOICE 6'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 6'!C19","v":0},0,{"$f":"SUM('INVOICE 6'!E19,'INVOICE 6'!H19)","v":0},{"$f":"SUM('INVOICE 6'!F19,'INVOICE 6'!I19)","v":0},0,0,0,0,0,0,0,1000000]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 6'!B20","v":0},{"$f":"'INVOICE 6'!C20","v":0},0,{"$f":"SUM('INVOICE 6'!E20,'INVOICE 6'!H20)","v":0},{"$f":"SUM('INVOICE 6'!F20,'INVOICE 6'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 6'!B21","v":4360},{"$f":"'INVOICE 6'!C21","v":0},4360,{"$f":"SUM('INVOICE 6'!E21,'INVOICE 6'!H21)","v":417},{"$f":"SUM('INVOICE 6'!F21,'INVOICE 6'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 6'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 6'!B22","v":49053},{"$f":"'INVOICE 6'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 6'!E22,'INVOICE 6'!H22)","v":46782},{"$f":"SUM('INVOICE 6'!F22,'INVOICE 6'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 6'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 6'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":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 7'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 7'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 7'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 7'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 7'!E15,'INVOICE 7'!H15)","v":320983},{"$f":"SUM('INVOICE 7'!F15,'INVOICE 7'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 7'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":2042200},{"$f":"'INVOICE 7'!C16","v":0},2042200,{"$f":"SUM('INVOICE 7'!E16,'INVOICE 7'!H16)","v":608352},{"$f":"SUM('INVOICE 7'!F16,'INVOICE 7'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 7'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 7'!B17","v":71000},{"$f":"'INVOICE 7'!C17","v":0},71000,{"$f":"SUM('INVOICE 7'!E17,'INVOICE 7'!H17)","v":5885},{"$f":"SUM('INVOICE 7'!F17,'INVOICE 7'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 7'!C19","v":0},0,{"$f":"SUM('INVOICE 7'!E19,'INVOICE 7'!H19)","v":0},{"$f":"SUM('INVOICE 7'!F19,'INVOICE 7'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 7'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 7'!B20","v":0},{"$f":"'INVOICE 7'!C20","v":0},0,{"$f":"SUM('INVOICE 7'!E20,'INVOICE 7'!H20)","v":0},{"$f":"SUM('INVOICE 7'!F20,'INVOICE 7'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 7'!B21","v":4360},{"$f":"'INVOICE 7'!C21","v":0},4360,{"$f":"SUM('INVOICE 7'!E21,'INVOICE 7'!H21)","v":417},{"$f":"SUM('INVOICE 7'!F21,'INVOICE 7'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 7'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 7'!B22","v":49053},{"$f":"'INVOICE 7'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 7'!E22,'INVOICE 7'!H22)","v":46782},{"$f":"SUM('INVOICE 7'!F22,'INVOICE 7'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 7'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 7'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":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 8'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 8'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 8'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 8'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 8'!E15,'INVOICE 8'!H15)","v":320983},{"$f":"SUM('INVOICE 8'!F15,'INVOICE 8'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 8'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":2042200},{"$f":"'INVOICE 8'!C16","v":0},2042200,{"$f":"SUM('INVOICE 8'!E16,'INVOICE 8'!H16)","v":608352},{"$f":"SUM('INVOICE 8'!F16,'INVOICE 8'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 8'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 8'!B17","v":71000},{"$f":"'INVOICE 8'!C17","v":0},71000,{"$f":"SUM('INVOICE 8'!E17,'INVOICE 8'!H17)","v":5885},{"$f":"SUM('INVOICE 8'!F17,'INVOICE 8'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 8'!C19","v":0},0,{"$f":"SUM('INVOICE 8'!E19,'INVOICE 8'!H19)","v":0},{"$f":"SUM('INVOICE 8'!F19,'INVOICE 8'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 8'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 8'!B20","v":0},{"$f":"'INVOICE 8'!C20","v":0},0,{"$f":"SUM('INVOICE 8'!E20,'INVOICE 8'!H20)","v":0},{"$f":"SUM('INVOICE 8'!F20,'INVOICE 8'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 8'!B21","v":4360},{"$f":"'INVOICE 8'!C21","v":0},4360,{"$f":"SUM('INVOICE 8'!E21,'INVOICE 8'!H21)","v":417},{"$f":"SUM('INVOICE 8'!F21,'INVOICE 8'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 8'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 8'!B22","v":49053},{"$f":"'INVOICE 8'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 8'!E22,'INVOICE 8'!H22)","v":46782},{"$f":"SUM('INVOICE 8'!F22,'INVOICE 8'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 8'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 8'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":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 9'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 9'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 9'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 9'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 9'!E15,'INVOICE 9'!H15)","v":320983},{"$f":"SUM('INVOICE 9'!F15,'INVOICE 9'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 9'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":2042200},{"$f":"'INVOICE 9'!C16","v":0},2042200,{"$f":"SUM('INVOICE 9'!E16,'INVOICE 9'!H16)","v":608352},{"$f":"SUM('INVOICE 9'!F16,'INVOICE 9'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 9'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 9'!B17","v":71000},{"$f":"'INVOICE 9'!C17","v":0},71000,{"$f":"SUM('INVOICE 9'!E17,'INVOICE 9'!H17)","v":5885},{"$f":"SUM('INVOICE 9'!F17,'INVOICE 9'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 9'!C19","v":0},0,{"$f":"SUM('INVOICE 9'!E19,'INVOICE 9'!H19)","v":0},{"$f":"SUM('INVOICE 9'!F19,'INVOICE 9'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 9'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 9'!B20","v":0},{"$f":"'INVOICE 9'!C20","v":0},0,{"$f":"SUM('INVOICE 9'!E20,'INVOICE 9'!H20)","v":0},{"$f":"SUM('INVOICE 9'!F20,'INVOICE 9'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 9'!B21","v":4360},{"$f":"'INVOICE 9'!C21","v":0},4360,{"$f":"SUM('INVOICE 9'!E21,'INVOICE 9'!H21)","v":417},{"$f":"SUM('INVOICE 9'!F21,'INVOICE 9'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 9'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 9'!B22","v":49053},{"$f":"'INVOICE 9'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 9'!E22,'INVOICE 9'!H22)","v":46782},{"$f":"SUM('INVOICE 9'!F22,'INVOICE 9'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 9'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 9'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":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 10'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 10'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 10'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 10'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 10'!E15,'INVOICE 10'!H15)","v":320983},{"$f":"SUM('INVOICE 10'!F15,'INVOICE 10'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 10'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":2042200},{"$f":"'INVOICE 10'!C16","v":0},2042200,{"$f":"SUM('INVOICE 10'!E16,'INVOICE 10'!H16)","v":608352},{"$f":"SUM('INVOICE 10'!F16,'INVOICE 10'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 10'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 10'!B17","v":71000},{"$f":"'INVOICE 10'!C17","v":0},71000,{"$f":"SUM('INVOICE 10'!E17,'INVOICE 10'!H17)","v":5885},{"$f":"SUM('INVOICE 10'!F17,'INVOICE 10'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 10'!C19","v":0},0,{"$f":"SUM('INVOICE 10'!E19,'INVOICE 10'!H19)","v":0},{"$f":"SUM('INVOICE 10'!F19,'INVOICE 10'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 10'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 10'!B20","v":0},{"$f":"'INVOICE 10'!C20","v":0},0,{"$f":"SUM('INVOICE 10'!E20,'INVOICE 10'!H20)","v":0},{"$f":"SUM('INVOICE 10'!F20,'INVOICE 10'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 10'!B21","v":4360},{"$f":"'INVOICE 10'!C21","v":0},4360,{"$f":"SUM('INVOICE 10'!E21,'INVOICE 10'!H21)","v":417},{"$f":"SUM('INVOICE 10'!F21,'INVOICE 10'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 10'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 10'!B22","v":49053},{"$f":"'INVOICE 10'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 10'!E22,'INVOICE 10'!H22)","v":46782},{"$f":"SUM('INVOICE 10'!F22,'INVOICE 10'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 10'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 10'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":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 11'!L2:N2","v":"Purchase Order: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 11'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 11'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 11'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 11'!E15,'INVOICE 11'!H15)","v":320983},{"$f":"SUM('INVOICE 11'!F15,'INVOICE 11'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 11'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":2042200},{"$f":"'INVOICE 11'!C16","v":0},2042200,{"$f":"SUM('INVOICE 11'!E16,'INVOICE 11'!H16)","v":608352},{"$f":"SUM('INVOICE 11'!F16,'INVOICE 11'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 11'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 11'!B17","v":71000},{"$f":"'INVOICE 11'!C17","v":0},71000,{"$f":"SUM('INVOICE 11'!E17,'INVOICE 11'!H17)","v":5885},{"$f":"SUM('INVOICE 11'!F17,'INVOICE 11'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 11'!C19","v":0},0,{"$f":"SUM('INVOICE 11'!E19,'INVOICE 11'!H19)","v":0},{"$f":"SUM('INVOICE 11'!F19,'INVOICE 11'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 11'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 11'!B20","v":0},{"$f":"'INVOICE 11'!C20","v":0},0,{"$f":"SUM('INVOICE 11'!E20,'INVOICE 11'!H20)","v":0},{"$f":"SUM('INVOICE 11'!F20,'INVOICE 11'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 11'!B21","v":4360},{"$f":"'INVOICE 11'!C21","v":0},4360,{"$f":"SUM('INVOICE 11'!E21,'INVOICE 11'!H21)","v":417},{"$f":"SUM('INVOICE 11'!F21,'INVOICE 11'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 11'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 11'!B22","v":49053},{"$f":"'INVOICE 11'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 11'!E22,'INVOICE 11'!H22)","v":46782},{"$f":"SUM('INVOICE 11'!F22,'INVOICE 11'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 11'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 11'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":16,"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: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 12'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 12'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 12'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 12'!E15,'INVOICE 12'!H15)","v":320983},{"$f":"SUM('INVOICE 12'!F15,'INVOICE 12'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 12'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 12'!B16","v":2042200},{"$f":"'INVOICE 12'!C16","v":0},2042200,{"$f":"SUM('INVOICE 12'!E16,'INVOICE 12'!H16)","v":608352},{"$f":"SUM('INVOICE 12'!F16,'INVOICE 12'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 12'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 12'!B17","v":71000},{"$f":"'INVOICE 12'!C17","v":0},71000,{"$f":"SUM('INVOICE 12'!E17,'INVOICE 12'!H17)","v":5885},{"$f":"SUM('INVOICE 12'!F17,'INVOICE 12'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 12'!C19","v":0},0,{"$f":"SUM('INVOICE 12'!E19,'INVOICE 12'!H19)","v":0},{"$f":"SUM('INVOICE 12'!F19,'INVOICE 12'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 12'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 12'!B20","v":0},{"$f":"'INVOICE 12'!C20","v":0},0,{"$f":"SUM('INVOICE 12'!E20,'INVOICE 12'!H20)","v":0},{"$f":"SUM('INVOICE 12'!F20,'INVOICE 12'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 12'!B21","v":4360},{"$f":"'INVOICE 12'!C21","v":0},4360,{"$f":"SUM('INVOICE 12'!E21,'INVOICE 12'!H21)","v":417},{"$f":"SUM('INVOICE 12'!F21,'INVOICE 12'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 12'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 12'!B22","v":49053},{"$f":"'INVOICE 12'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 12'!E22,'INVOICE 12'!H22)","v":46782},{"$f":"SUM('INVOICE 12'!F22,'INVOICE 12'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 12'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 12'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":17,"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: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 14'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 14'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 14'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 14'!E15,'INVOICE 14'!H15)","v":320983},{"$f":"SUM('INVOICE 14'!F15,'INVOICE 14'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 14'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 14'!B16","v":2042200},{"$f":"'INVOICE 14'!C16","v":0},2042200,{"$f":"SUM('INVOICE 14'!E16,'INVOICE 14'!H16)","v":608352},{"$f":"SUM('INVOICE 14'!F16,'INVOICE 14'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 14'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 14'!B17","v":71000},{"$f":"'INVOICE 14'!C17","v":0},71000,{"$f":"SUM('INVOICE 14'!E17,'INVOICE 14'!H17)","v":5885},{"$f":"SUM('INVOICE 14'!F17,'INVOICE 14'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 14'!C19","v":0},0,{"$f":"SUM('INVOICE 14'!E19,'INVOICE 14'!H19)","v":0},{"$f":"SUM('INVOICE 14'!F19,'INVOICE 14'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 14'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 14'!B20","v":0},{"$f":"'INVOICE 14'!C20","v":0},0,{"$f":"SUM('INVOICE 14'!E20,'INVOICE 14'!H20)","v":0},{"$f":"SUM('INVOICE 14'!F20,'INVOICE 14'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 14'!B21","v":4360},{"$f":"'INVOICE 14'!C21","v":0},4360,{"$f":"SUM('INVOICE 14'!E21,'INVOICE 14'!H21)","v":417},{"$f":"SUM('INVOICE 14'!F21,'INVOICE 14'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 14'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 14'!B22","v":49053},{"$f":"'INVOICE 14'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 14'!E22,'INVOICE 14'!H22)","v":46782},{"$f":"SUM('INVOICE 14'!F22,'INVOICE 14'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 14'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 14'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":18,"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: 2480"}]
["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":"ARSOLA's Distribution Center & Community Services"},null,null,null,"Project Title:",{"$f":"'INVOICE 13'!G7:I7","v":"RA"}]
[]
["Contract #:",{"$f":"'INVOICE 13'!B9","v":"BSCC 416-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":833387},{"$f":"'INVOICE 13'!C15","v":0},{"$f":"SUM(B15:C15)","v":833387},{"$f":"SUM('INVOICE 13'!E15,'INVOICE 13'!H15)","v":320983},{"$f":"SUM('INVOICE 13'!F15,'INVOICE 13'!I15)","v":0},{"$f":"SUM(E15:F15)","v":320983},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":512404},0,{"$f":"SUM(K15:L15)","v":512404},{"$f":"'INVOICE 13'!N15","v":"1st Advance [10/23/19]"}]
["Services & Supplies",{"$f":"'INVOICE 13'!B16","v":2042200},{"$f":"'INVOICE 13'!C16","v":0},2042200,{"$f":"SUM('INVOICE 13'!E16,'INVOICE 13'!H16)","v":608352},{"$f":"SUM('INVOICE 13'!F16,'INVOICE 13'!I16)","v":0},{"$f":"SUM(E16:F16)","v":608352},0,0,0,1433848,0,1433848,{"$f":"'INVOICE 13'!N16","v":1000000}]
["Professional Services",{"$f":"'INVOICE 13'!B17","v":71000},{"$f":"'INVOICE 13'!C17","v":0},71000,{"$f":"SUM('INVOICE 13'!E17,'INVOICE 13'!H17)","v":5885},{"$f":"SUM('INVOICE 13'!F17,'INVOICE 13'!I17)","v":0},{"$f":"SUM(E17:F17)","v":5885},0,0,0,65115,0,65115]
["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":0},{"$f":"'INVOICE 13'!C19","v":0},0,{"$f":"SUM('INVOICE 13'!E19,'INVOICE 13'!H19)","v":0},{"$f":"SUM('INVOICE 13'!F19,'INVOICE 13'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 13'!N19","v":1000000}]
["Data Collection & Progress Reporting",{"$f":"'INVOICE 13'!B20","v":0},{"$f":"'INVOICE 13'!C20","v":0},0,{"$f":"SUM('INVOICE 13'!E20,'INVOICE 13'!H20)","v":0},{"$f":"SUM('INVOICE 13'!F20,'INVOICE 13'!I20)","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",{"$f":"'INVOICE 13'!B21","v":4360},{"$f":"'INVOICE 13'!C21","v":0},4360,{"$f":"SUM('INVOICE 13'!E21,'INVOICE 13'!H21)","v":417},{"$f":"SUM('INVOICE 13'!F21,'INVOICE 13'!I21)","v":0},417,0,0,0,3943,0,3943,{"$f":"'INVOICE 13'!N21","v":"3rd Advance\n [enter date]"}]
["Indirect Costs",{"$f":"'INVOICE 13'!B22","v":49053},{"$f":"'INVOICE 13'!C22","v":0},{"$f":"SUM(B22:C22)","v":49053},{"$f":"SUM('INVOICE 13'!E22,'INVOICE 13'!H22)","v":46782},{"$f":"SUM('INVOICE 13'!F22,'INVOICE 13'!I22)","v":0},46782,0,0,0,2271,0,2271,{"$f":"'INVOICE 13'!N22","v":0}]
["TOTAL",{"$f":"SUM(B15:B22)","v":3000000},0,3000000,982419,0,982419,0,0,0,2017581,0,2017581,{"$f":"SUM(N16+N19+N22)","v":2000000}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 13'!D25+I25","v":400},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D25-G25","v":400}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E23,H23)","v":982419},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":1017581},null,null,null,"funds expended to date:",null,{"$f":"D27/N23","v":0.49120950000000002}]
[]
[]
[]
[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":146589}]
["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":"ARSOLASFOO-001"}]
["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 5520"}]
["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":"Oakland, CA 94605"}]
["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":"3rd Advance Payment","index":19,"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: 2480"}]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1 REVISED'!B5","v":"Adult Reentry Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 15'!B7","v":"ARSOLA's Distribution Center & Community Services"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 416-19"},null,null,null,null,"Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 5520"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1 REVISED'!E9","v":"2019-08-01"},"TO",{"$f":"'INVOICE 1 REVISED'!G9","v":"2023-02-28"},null,null,null,{"$f":"'INVOICE 15'!L58","v":"Oakland, CA 94605"}]
[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":"ARSOLASFOO-001"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:",null,null,null,null,null,null,{"$f":"'INVOICE 15'!L52","v":146589}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"MODIFICATION REQUEST","index":20,"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":"ARSOLA's Distribution Center & Community Services"},null,null,null,null,null,null,"Program:",{"$f":"'INVOICE 1 REVISED'!B5","v":"Adult Reentry Grant"}]
[]
["Address",{"$f":"'INVOICE 15'!L56","v":"P.O. Box 5520"},null,null,null,null,null,null,"Project Title:",{"$f":"'INVOICE 15'!G7","v":"RA"}]
[]
[null,{"$f":"'INVOICE 15'!L58","v":"Oakland, CA 94605"}]
[]
["Contract #:",{"$f":"'INVOICE 15'!B9","v":"BSCC 416-19"},null,null,null,null,null,null,null,"Modification Request #"]
[]
["Term:",{"$f":"'INVOICE 1 REVISED'!E9","v":"2019-08-01"},{"$f":"'INVOICE 1 REVISED'!F9","v":"TO"},{"$f":"'INVOICE 1 REVISED'!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",833387,0,{"$f":"SUM(B22:C22)","v":833387},{"$f":"'INVOICE 15'!K15","v":512404},{"$f":"'INVOICE 15'!L15","v":0},{"$f":"SUM(E22:F22)","v":512404},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":833387},{"$f":"SUM(C22,I22)","v":0},{"$f":"SUM(K22:L22)","v":833387}]
["Services & Supplies",2042200,0,2042200,{"$f":"'INVOICE 15'!K16","v":1433848},{"$f":"'INVOICE 15'!L16","v":0},1433848,0,0,0,2042200,0,2042200]
["Professional Services",71000,0,71000,{"$f":"'INVOICE 15'!K17","v":65115},{"$f":"'INVOICE 15'!L17","v":0},65115,0,0,0,71000,0,71000]
["NGO Subcontracts",0,0,0,{"$f":"'INVOICE 15'!K18","v":0},{"$f":"'INVOICE 15'!L18","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",0,0,0,{"$f":"'INVOICE 15'!K19","v":0},{"$f":"'INVOICE 15'!L19","v":0},0,0,0,0,0,0,0]
["Data Collection & Progress Reporting",0,0,0,{"$f":"'INVOICE 15'!K20","v":0},{"$f":"'INVOICE 15'!L20","v":0},0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",4360,0,4360,{"$f":"'INVOICE 15'!K21","v":3943},{"$f":"'INVOICE 15'!L21","v":0},3943,0,0,0,4360,0,4360]
["Indirect Costs",49053,0,49053,{"$f":"'INVOICE 15'!K22","v":2271},{"$f":"'INVOICE 15'!L22","v":0},2271,0,0,0,49053,0,49053]
["TOTAL",{"$f":"SUM(B22:B29)","v":3000000},0,3000000,2017581,0,2017581,0,0,0,3000000,0,3000000]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 15'!D25","v":400},null,"Prior allocated income",{"$f":"'INVOICE 15'!G25","v":0},"Allocating",{"$f":"I30","v":0},null,null,"Unallocated income balance",{"$f":"D32-I32","v":400}]
[]
["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 NARRATIVE","index":21,"n_rows":205,"n_cols":7,"rows_kept":205,"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],[57,0,57,6],[9,0,9,5],[10,0,10,5],[11,0,11,5],[13,0,13,5],[14,0,14,6],[4,0,4,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[15,0,15,1],[15,2,15,5],[16,0,16,1],[16,2,16,5],[17,0,17,1],[17,2,17,5],[18,0,18,1],[18,2,18,5],[24,0,24,1],[24,2,24,5],[25,0,25,1],[25,2,25,5],[26,0,26,1],[26,2,26,5],[30,0,30,5],[32,0,53,6],[19,0,19,1],[19,2,19,5],[20,0,20,1],[20,2,20,5],[21,0,21,1],[21,2,21,5],[22,0,22,1],[22,2,22,5],[23,0,23,1],[23,2,23,5],[54,0,54,6],[58,0,58,6],[55,0,56,6],[27,0,27,1],[27,2,27,5],[28,0,28,1],[28,2,28,5],[29,0,29,1],[59,0,59,1],[59,2,59,5],[29,2,29,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],[92,0,92,1],[92,2,92,5],[60,0,60,1],[60,2,60,5],[61,0,61,1],[61,2,61,5],[62,0,62,1],[62,2,62,5],[63,0,63,1],[63,2,63,5],[64,0,64,1],[64,2,64,5],[93,2,93,5],[94,2,94,5],[95,2,95,5],[68,0,68,5],[69,0,69,2],[70,0,86,6],[90,0,90,6],[91,2,91,5],[89,0,89,6],[87,0,87,6],[88,0,88,6],[96,0,96,1],[96,2,96,5],[97,0,97,1],[97,2,97,5],[98,0,98,1],[98,2,98,5],[119,2,119,5],[120,0,120,1],[120,2,120,5],[117,0,117,6],[121,0,121,1],[121,2,121,5],[99,0,99,1],[99,2,99,5],[100,0,100,5],[102,0,114,6],[118,0,118,6],[127,2,127,5],[122,0,122,1],[122,2,122,5],[123,0,123,1],[123,2,123,5],[124,0,124,1],[124,2,124,5],[128,0,128,5],[129,0,129,6],[130,0,133,6],[137,0,137,6],[138,2,138,5],[125,0,125,1],[125,2,125,5],[126,0,126,1],[126,2,126,5],[127,0,127,1],[134,0,134,6],[135,0,135,6],[136,0,136,6],[139,0,139,1],[139,2,139,5],[140,0,140,1],[140,2,140,5],[141,0,141,1],[141,2,141,5],[142,0,142,1],[142,2,142,5],[143,0,143,1],[143,2,143,5],[160,0,160,5],[161,0,161,5],[162,0,162,5],[163,0,163,5],[164,0,164,5],[171,0,171,6],[173,0,173,6],[166,0,170,6],[144,0,144,1],[144,2,144,5],[158,0,158,5],[159,0,159,5],[145,0,145,1],[145,2,145,5],[146,0,146,1],[146,2,146,5],[147,0,147,5],[153,0,153,6],[154,0,154,6],[149,0,152,6],[156,0,156,6],[157,0,157,5],[155,0,155,6],[191,0,191,6],[183,0,183,5],[185,0,189,6],[193,0,193,6],[194,0,194,5],[174,0,174,6],[175,0,175,1],[175,2,175,5],[176,2,176,5],[192,0,192,6],[203,0,203,6],[204,0,204,6],[196,0,196,4],[197,0,197,5],[199,0,202,6],[93,0,93,1],[94,0,94,1],[95,0,95,1],[115,0,115,6],[116,0,116,6],[177,0,177,1],[177,2,177,5],[178,0,178,1],[178,2,178,5],[179,0,179,1],[179,2,179,5],[195,0,195,4],[180,0,180,1],[180,2,180,5],[181,0,181,1],[181,2,181,5],[182,0,182,1],[182,2,182,5],[190,0,190,6]]}
[]
["Project Budget and Budget Narrative for Rental Assistance (UPDATED 3.14.19)"]
["Name of Applicant CBO:",null,null,"Arsola's House"]
["Project Budget for Rental Assistance"]
["Budget Line Item",null,null,null,null,null,"Grant Funds"]
["1. Salaries and Benefits",null,null,null,null,null,{"$f":"G31","v":930300}]
["2. Services and Supplies",null,null,null,null,null,{"$f":"G69","v":2027975}]
["3. Professional Services",null,null,null,null,null,{"$f":"G101","v":27700}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,null,{"$f":"G129","v":0}]
["5. Equipment/Fixed Assets",null,null,null,null,null,{"$f":"G148","v":2170}]
["6. Data Collection and Progress Reporting",null,null,null,null,null,{"$f":"G165","v":0}]
["7. Other (Travel, Training, etc.)",null,null,null,null,null,{"$f":"G184","v":4360}]
["8. Indirect Costs ",null,null,null,null,null,{"$f":"G198","v":7495}]
["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]
["Candi Thornton, Project Director",null,".75 FTE @$90,000 x 3.5 yrs & no benefits = ",null,null,null,315000]
["Catherine Forbes, Administrative Coordinator",null,".75 FTE @$45,000/yr x 3.5 yrs & no benefits = ",null,null,null,157500]
["Thomas Forbes, Financial Officer",null,".50 FTE @$60,000/yr x 3.5 yrs & no benefits =",null,null,null,210000]
["Laura McCoy, Data Manager",null,"1.00 FTE @$60,000 x 3.5 yrs no benefits = ",null,null,null,210000]
["Salary Deductions",null,"assumes $225/month x 42 months x 4 employees",null,null,null,37800]
[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(G19:G30)","v":930300}]
["Salaries and Benefits Narrative for Rental Assistance:"]
["Benefits are not offered to any employees at this time.  Payroll deductions assumes $225/mo x 42 mos x 4 employees\n\nProject Director works with the Project Coordinator with identifying housing especially large-scale housing (5 units or more) and negotiating large scale housing contracts, troubleshoots issues with rental properties. Is responsible for the overall management of the rental assistance project.\n\nAdministrative Coordinator assists the Project Director to identify rental units and large-scale rental sources. Orders and oversees furnishing of rental units, identifies and liaison with vendors, responsible for preparing rental progress reports for project staff, conducts pre-move in and post-move out inspections of rental units, maintains list of potential rental properties, performs intake of reentry persons and works with Project Director to identify program participants; supervises project Administrative Assistant, is Office Manager for the project and serves the Human Resources officer.  Reports to the Project Director.\n\nProject Coordinator coordinates street outreach to homeless reentry persons, outreaches to prisons to identify pre-release persons, troubleshoots issues that may arise between tenants, assists Administrative Coordinator performs intake of potential clients and makes recommendations to Project Director of reentry persons to the Arsola’s House Reentry Housing program as needed.\n\nData Manager coordinates data collection, tallies and performs data analysis.  Creates data collection tool as needed or adapts existing survey tool.  Uses best practices to set survey parameters and protocol. Ensure participant privacy. Responsible for creating all systems, policies and procedures used for the rental housing program and for project office, ensuring smooth delivery of both project and project office operations.  Reports to the Project Director."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD 1 Effective Invoice 1 Revised  APPROVAL DATE: 1/15/2021 v.s.   "]
["Salaries and Benefits Line Item Category: \nPosition Title % FTE or Hourly Rate & Benefits Grant Funds\nProject Director $10,000*.75% FTE = $7,500x43 months - No Benefits \n $322,500\nAdministrative Coordinator $7,500*.25% FTE=$1,875x15 months - No Benefits $28,125\nFinancial Officer  $8,000*.25% FTE=$2,000x43 months - No Benefits\n   $ 86,000\nFinancial Assistant $6,400*.50% FTE=$3,200x17 months - No Benefits\n $54,400   \nData Manager $7,500*.50% FTE=$3,750x15 months - No Benefits\n    $56,250\nExecutive Assistant $4,320*.75% FTE=$3,240x28 months - No Benefits\n    $90,720\nProgram Manager $5,000*.75% FTE=$3,750x28 months - No Benefits\n  $105,000\nSalary Deductions Eliminated line item 0\nEmployer Payroll Taxes Total Salaries $742,995 average 10% of Wages for 43 months $74,300\nPayroll Processing Fees Total ADP average monthly payroll processing, Quarterly/Annual payroll reports, HR service fees for 43 months 10,932\nWorkers Compensation Insurance Estimated $120 for 43 months 5,160\n Total 833,387\n\n\nJustification:\nWe request the Project Director be increased by $7,500 to correct a miscalculation of the time of service from 3.5 years to 43 months. \nWe request for the Administrative Coordinator position to be a temporary position that will be funded from 8/1/2019-10/31/2020.  This position will be eliminated as of 10/31/2020 because it is being replaced by the Executive Assistant.  \nWe request to reduce the time allocation for the Financial Officer from .50 FTE to .25 FTE because we realized the Financial Officer was not spending .50 FTE to complete the responsibilities for that position. \nWe request to add a new detail line item allocation of $54,400 for a Financial Assistant position to be a temporary position to perform bookkeeping and payroll processing duties that will be funded from 9/1/2019-1/31/2021.  This position will be eliminated as of 1/31/2021 and duties will be incorporated by the Financial Officer.   \nWe request for the Data Manager position to be a temporary position that will be funded from 8/1/2019-10/31/2020.   This position will be eliminated as of 10/31/2020 because these duties are being incorporated into the Program Manager position. \nWe request to add a new detail line for an Executive Assistant allocating $90,720 because we realized we need a daily operating assistant to coordinate and maintain our program responsibilities as well as requirements (job description attached)\nWe request to add a new detail line for a Program Manager allocating $105,000 because we recognize that we need an employee that focuses on our program activities, participant recruitments, supportive services, outcomes and to further develop the program requirements (job description attached)\nWe are eliminating the Salary Deductions line item expenditures originally budgeted in this category because it did not relate to any payroll expenses.  \nWe request to add a new detail line for Employer Payroll Taxes allocating $74,300 because the original budget did not include the Payroll Tax portion paid by Employer.  Average amount is 10% of wages.\nWe request to add a new detail line for Payroll Process Fees allocating $10,932 because the original did not include payroll service fees.  These fees cover expenses such as Payroll Processing, Human Resource Support, Quarterly Reports and Annual Reports. \nWe request to add a new detail line for Workers Compensation Insurance allocating $5,160 because the original budget did not include Worker’s Compensation Insurance for staff. "]
[]
[]
["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]
["Rents",null,"assumes 32 units x $4,500 move in costs each = $144,000 + $1,500/month rent per unit x 32 units x 38 months",null,null,null,1968000]
["Rental Services",null,"PGE assumes $47.78/months x 38 months x 32 units = $29,052.50.  EBMUD (water) assumes $$47.78/months x 38 months x 32 units = $29,052.50.",null,null,null,50610]
["Office Supplies",null,"Windows software assumes $199 x 3.5 years for 1 PC = $597.00; Microsoft Office software assumes $12.50/month x 3.5 years MS Office for up to 5 tablets or 5 PCs laptops = $525.00; Copier paper assumes one case every 6 months @$32.99 per case = $230.93; general office supplies = $2,543.99 over 3.5 years",null,null,null,2897]
["Office Services",null,"Cell phone stipend for use of personal cell phones assumes $20.00/month x 42 months x 3 staff (Administrative Coordinator, Project Director and Data Manager) = $2,520.00; Internet Provider = $1,428.00 assuming $34/month x 42 months. Website Hosting assumes $60/months x 42 months = $2,520.00.  Office Rents at $14,400 for 3.5 years; PGE at $8,400 for 3.5 year, and Waste Management at $2,420 for 3.5 years are in kind from Arsola’s House.  ",null,null,null,6468]
[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(G62:G68)","v":2027975}]
["Services and Supplies Narrative for Rental Assistance:"]
["Rents assumes 32 units x $4,500 move in = $144,000 + $1,500/month rent per unit x 38/months x 32 units = $1,824,000\n\nRental Services:  PGE assumes $47.78/months x 38 months x 32 units = $29,052.50.  EBMUD (water) assumes $$47.78/months x 38 months x 32 units = $29,052.50. We will offer a flat rate per month for PGE and water to landlords that do not include these servies in the rental amount.  Program Participants will be expected to seek assistance from the service provider and other CBOs to cover any additional charge each month.  \n\nOffice Supplies:  office supplies needed for the project are calculated at a minimum to keep costs low.  It is estimated we will need the following:  Windows software for 1 PC = $597.00; Microsoft Office software for 3.5 years = $525.00;  one case of copier paper every 6 months @$32.99 per case = $231; general office supplies = $2,544 over 3.5 years.\n\nOffice Services:  Project staff will work remotely and receive a monthly stipend of $20.00 each (Administrative Coordinator, Project Director and Data Manager) = $2,520.00; Internet Provider = $1,428.00 assuming $34/month x 42 months. Website Hosting assumes $60/months x 42 months = $2,520.00.  Office Rents at $14,400 for 3.5 years; PGE at $8,400 for 3.5 year, and Waste Management at $2,420 for 3.5 years are in kind from Arsola’s House. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD 1 Effective Invoice 1 Revised  APPROVAL DATE: 1/15/2021 v.s.   "]
["Services and Supplies Line Item Category: \nDescription of Service or Supplies Calculation for Expenditure Grant Funds\nOffice Rent $1,500 a month for 29 months $43,500\nParticipant Rent $1,500 a month for 68 participants for19 months $1,938,000\nSecurity Deposit $1,500 avg. rent deposits for 34 properties $51,000\nMove-In & Move Out Costs $125 Est. average cost x 30 units / $3,750\n$175 Est x   x 34 units / $5,950 $9,700\n Total $2,042,200\nJustification: \nWe are requesting to eliminate the detail lines for Office Supplies because we plan to address these costs via the Indirect Cost Line Item Category.\nWe are requesting to eliminate the detail line for Office Services because those costs were originally miscalculated and not properly identified.\nThe Rental Services detail line is being eliminated because utilities are included in the monthly rent amount.  \nWe are requesting to add a new detail line for Office Rent because it is necessary to have an office suite for the maintenance of the ARG program records and documents and to interview the incoming participants.  We secured the new office space effective 10/1/2020 in the amount of $1500 per month.  \nWe are requesting to add a new detail line for Security Deposits allocating $51,000 because this was originally included with the “Participant Rents” and we discovered that we will not likely need to pay deposits for each participant because we will backfill vacancies as participants are eligible to remain in housing for 19 months.  \nWe are requesting to add a new detail line for Move-In & Move-Out Costs allocating $8680 because the original budget did not include these costs.  Estimated average costs will cover: \n Cleaning, Furnishing & Supplies   $125 x 30 units = $3750\n Repairs & Maintenance         $175 x 34 units = $4930\n Total           = $8680\nWe are also requesting to change the detail line originally identified as “Rents” to “Participant Rents” and we are reducing that line from $1,968,000 to $1,938,000 because the original budget miscalculated rents for 32 units @ $1500 and included $4500 for deposits and expenses.  However, the “Participant Rents” should be calculated at $1500 x 19 months x 68 participants = $1,938,000.  "]
[]
["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]
["Legal",null,"assumes $200/hr x 50 hrs over 3.5 years, as needed",null,null,null,10000]
["Website Maintenance",null,"assumes $60/mo x 42 mos for maintenance, $300 for redesign",null,null,null,2700]
["Project Assistant",null,"assumes @10 hrs/wk @$31.25/hr for 1 year. no benefits",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]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G94:G100)","v":27700}]
["Professional Services Narrative for Rental Assistance:"]
["Legal: assumes $200 per hour for 50 hours over 3.5 years. Services will be on an as needed basis for document review and advice.  \n\nWebsite Maintenance: assumes $300 flat rate for one-time update to existing website to include grant award announcement, project description, an application for housing as well as an inquiry form for potential landlords. Monthly website maintenance at $30/hour for 2 hours per month for project updates including announcements of upcoming orientations for potential landlords.  \n\nProject Assistant assumes 10 hours per week @$31.25/hour for one year. No benefits. Responsible for developing and administering the pre-release and the street outreach portions of the project.  Contacts prisons and establishes relationships with personnel to identify soon to be released persons who will be homeless upon release, perform intakes, assist Project Director and Administrative Coordinator with application review and makes recommendations on who to accept.   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD 1 Effective Invoice 1 Revised  APPROVAL DATE: 1/15/2021 v.s.   "]
["Professional Services: \nDescription of Professional Service  Calculation for Expenditure Grant Funds\nOperational Consultant Average $2,000 a month for 28 months 56,000\nAccountant (CPA) Average $3,000 a year for 2019-2023 reporting periods. 15,000\n Total 71,000\nJustification:\nWe are requesting to eliminate the original detail line items for Legal and Website Maintenance because these costs are more appropriately accounted for in the Indirect Cost Line Item Category.\nThe Project Assistant is being eliminated because we realized the duties and tasks that were originally identified are included in the salary position of the Program Manager, as such, this position was not necessary.\nThe Operational Consultant is a new addition and will support the projects State compliances requirements and to develop an operational system to provide computerized analysis of program financials & service outcomes.  The position will be paid an average of $2,000 each month; however, the actual monthly charges may vary each month.  \nThe CPA will be responsible for preparing Financial Statements and Tax Returns for the exclusive preparation of ARG program years 2019-2023."]
[]
["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(G122:G128)","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]
["Laser printer /copier/fax/scanner ",null,"high speed copier/fax and scanner to reproduce, send and store project documents",null,null,null,1025]
["2 -  HP Chromebook Model X2 12-F014DX ",null,"($398 each) for use by Administrative Coordinator and Data Manager;",null,null,null,796]
["1 - MS Surface Go Model MHN-0000 tablet",null,"($349 each) for use by Administrative Coordinator and Project Assistant for intakes",null,null,null,349]
[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(G141:G147)","v":2170}]
["Equipment/Fixed Assets Narrative for Rental Assistance:"]
["Laser printer /copier/fax/scanner @$ $1,025; 2 -  HP Chromebook Model X2 12-F014DX ($398 each) for use by Administrative Coordinator and Data Manager;1 - MS Surface Go Model MHN-0000 tablet ($349 each) for use by Administrative Coordinator and Project Assistant for intakes"]
[]
[]
[]
["MOD 1 Effective Invoice 1 Revised  APPROVAL DATE: 1/15/2021 v.s.   "]
["Equipment/Fixed Assets Line Item Category: We are eliminating the expenditures originally budgeted in this category.  \nJustification: We are eliminating the items charged in the original budget because the expense is nominal and would be better accounted for in the Indirect Cost Line Item. "]
[]
["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]
[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(G160:G164)","v":0}]
["Data  Collection and Progress Reporting Narrative for Rental Assistance:"]
["Data Collection and Reporting Efforts are captured elsewhere in the budget.  The Data Manager salary, necessary equipment (tablet and laptop), software, and travel to and from BSCC trainings and conferences are shown in the appropriate categories.  No additional costs for data collection and reporting are anticipated."]
[]
[]
[]
[]
["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]
["Travel and Per Diem",null,"assumes RT car travel 2x per year to BSCC in Sacramento = 4 one way trips @ 95 miles x .58 miles x 4 people (Project Director, Financial Director, Administrator Coordinator, Data  Financial Officer, Data Manager) + $66.00/M&IE x 4 persons",null,null,null,1000]
["Mileage",null,"assumes $20/month mileage stipend x 4 (Project Director, Fin Officer, Proj Admin, Data Mgr) x 42 months",null,null,null,3360]
[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(G178:G183)","v":4360}]
["Other (Travel, Training, etc.) Narrative for Rental Assistance:"]
["Travel and Per Diem:  assumes 4 staff will travel twice per year to BSCC Sacramento for training and reentry housing conference, using vernment mileage rate of .58 cents per mile.  Per diem assumes government rate of $66.00 per person. "]
[]
[]
[]
[]
["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":"G31*10%","v":93030},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(G184,G165,G129,G101,G69,G31)*5%","v":149516.75},7495]
["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(G196:G197)","v":7495}]
["Indirect Costs Narrative for Rental Assistance:"]
[]
[]
[]
[]
["MOD 1 Effective Invoice 1 Revised  APPROVAL DATE: 1/15/2021 v.s.   "]
["Indirect Cost Line Item Category: 5% of total project cost  $49,053.\nJustification: To correct a miscalculation of the original budget submitted which allocated $7,495.  We want to add $41,558 to this category to include indirect costs for operational rental assistance expenses.  Amount will be no more than allowed amount based on the calculation of the budget."]

{"sheet":"INVOICE DUE DATES","index":22,"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-02-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":23,"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."]