{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Reimbursement Request Guide","FAQs","1 Project Expenditures","2 Labor","3 Equipment","4 Reimbursement Request Form","5 Reconciliation of Advance"],"not_rendered":{"images":5,"defined_names":9,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Reimbursement Request Guide","index":0,"n_rows":56,"n_cols":2,"rows_kept":56,"hidden":true}
[]
[null,"Reimbursement Request Guide"]
[null,"•  This guide offers instruction on how to prepare and submit a reimbursement request.  "]
[null,"•  An organized and complete request will shorten review and approval time.  "]
[null,"•  Reference your approved grant scope of work and budget to confirm eligible costs PRIOR to expending funds."]
[null,"•  Ineligible costs and/or expenses with incomplete documentation cannot be reimbursed. "]
[null,"•  Need help identifying eligible expenses or the right backup documents? See FAQs or contact your Grant Administrator."]
[null,"5 Steps to Submitting A Reimbursement Request"]
[null,"STEP 1 - ORGANIZE AND COMPILE BACKUP DOCUMENTS"]
[null,"•  Organize invoices/receipts for paid project expenditures. "]
[null,"•  Combine invoices/receipts into single pdfs of no more than 50 pages each."]
[null,"•  Make sure all invoices are legible. If helpful, write clarifying notes on invoices to assist Grant Administrator review."]
[null,"•  Name the PDF \"Invoices.\" If multiple PDFs of 50 pages, add numbers to file names e.g., \"Invoices 1,\"  \"Invoices 2,\" etc."]
[null,"Scan invoices in the same order the corresponding expense is listed on the Project Expenditures Form (Tab 1). This is an example of "]
[null,"scanned invoices. Red numbers at top right corner of each invoice refer to line numbers in the Project Expenditures Form.   "]
[null,"See example of a completed  Project Expenditures Form under Step 2 below."]
[]
[null,"STEP 2 - FILL OUT APPLICABLE WORKSHEETS IN THIS WORKBOOK "]
[null,"•  There are three worksheets for listing different types of expenses."]
[null,"•  The Project Expenditures Form is where you list most direct project costs, including materials, supplies, contracted or consultant services, travel expenses, mileage, etc. "]
[null,"•  The Grantee Labor Costs Form is for your employee labor costs related to the grant project."]
[null,"•  The Grantee-Owned Equipment Costs Form is where you invoice the grant for use of your equipment on the grant-funded project."]
[null,"•  Once you have filled out all applicable worksheets, name this workbook \"Workbook\" and attach it to your reimbursement request email as an Excel document. "]
[null,"This is an example of a completed Project Expenditures Form. Note line numbers in the far left column."]
[null,"Backup invoices should be scanned in the same order expenses are listed here."]
[]
[null,"STEP 3 - FILL OUT, SIGN and DOWNLOAD THE REIMBURSEMENT REQUEST FORM"]
[null,"Tab 2 shows the total amount of tabs 1a-1c.  Confirm the Total Amount of Request shown. "]
[null,"Click the form link to open the RR form. "]
[null,"See the form preview below for the information you'll need onhand to fill out the form. "]
[null,"Docusign will collect signatures and email the final RR form to the day-to-day contact listed. "]
[null,"Download and save using this naming convention: XRR_[GrantNumber]_Request, in this example 1RR_GF1029-0_Request"]
[]
[null,"Step 4 - Update your Payment Tracking Sheet"]
[null,"Update your Payment Tracking Sheet* to reflect this request. "]
[null,"Save using the following naming convention:  [GrantNumber]_Tracking, in this example GF1029-0_Tracking."]
[null,"*provided by your Grant Administrator at the start of your grant"]
[]
[null,"Step 5 - Submit Reimbursement Request "]
[null,"Attach all four files and email them to bgpayments@resources.ca.gov, as shown below. "]
[null,"You will receive an email confirming receipt within 2 business days."]
{"$rows_empty":11}
[null,"Your Grant Adminstrator will reach out with questions, if needed, during the approval process. "]
[null,"Once your request is approved,  the CNRA Accounting Department will process and mail your payment in 6-8 weeks. "]
[]
[null,"Questions? Check the FAQs tab or contact your Grant Administrator for help completing your request."]

{"sheet":"FAQs","index":1,"n_rows":55,"n_cols":2,"rows_kept":55,"hidden":true}
[null,"FAQs"]
[null,"How do I know if an expense is eligble?"]
[null,"•  Expenses must be part of your approved grant agreement in order to be reimbursed. "]
[null,"•  Check the following documents to confirm eligible costs PRIOR to spending funds: "]
[null,"          Grant Agreement Exhibit A (scope of work): do you see a \"home\" for your expense in the grant deliverables and;"]
[null,"          Grant Agreement Exhibit A-1 (cost-estimate): do you see a line item/task number that corresponds to your expense and;"]
[null,"          Payment Tracking Sheet: do you have funds remaining in the line item/task number for your expense?"]
[null,"•  Consult the grant program guidelines. Most contain an appendix or section on eligible expenses."]
[null,"•  If you are unsure about eligiblity, contact your Grant Administrator. "]
[]
[null,"What are Project Expenditures and what backup do I need to include in my Reimbursement Request? "]
[null,"•  Project expenditures include most direct project costs, including materials, supplies, contracted or consultant services, travel expenses, mileage, etc. "]
[null,"•  Submit an invoice or receipt for each expenditure showing the date of issue or purchase, the payee name, items/services, and total cost."]
[null,"•  Some expenses require additional or alternative backup documents: "]
[null,"     Food backup (only eligible in select grant programs)"]
[null,"     –  Food receipts should include a note indicating: 1) event date; 2) purpose for food expense; and 3) number of participants fed."]
[null,"     Mileage backup"]
[null,"     –  Mileage should be billed at the rate reimbursed to the employee, but no  greater than the IRS mileage rate at the time of travel."]
[null,"     –  For grantee-owned vehicles: submit a mileage log showing destination, miles, and grant purpose for travel in lieu of an invoice/receipt."]
[null,"     –  For personal vehicles: submit a signed employee expense form (per grantee's standard business practice)  in lieu of an invoice/receipt."]
[null,"     Youth Stipends "]
[null,"     – Youth stipends for program projects should be entered on this form as a project expenditure."]
[]
[null,"How should I organize my invoices/receipts for Project Expenditures?"]
[null,"•  Assemble invoices/receipts in the same order as the expenses listed on the Project Expenditure form (column A) into one PDF. "]
[null,"•  If an invoice is partially paid with grant funds, indicate the amount billed to the grant and the amount billed to other funding sources. "]
[null,"•  If an invoice includes costs for several grant budget tasks, provide a breakdown of the amounts charged to each task.   "]
[]
[null,"What are Grantee Labor Costs and what backup do I need to include in my Reimbursement Request? "]
[null,"•  Grantee labor costs are your in-house employee costs for working on the grant-funded project.  "]
[null,"•  You may bill the grant for your employee salary and benefits for work performed on the grant-funded project."]
[null,"•  Only salary plus benefits are eligible. No indirect rates or overhead costs may be folded into the hourly rate. No billable rates may be used."]
[null,"•  Salary and benefits should be combined into one hourly rate for each employee. "]
[null,"•  Employee labor must be computed on actual time spent on the project as evidenced by time sheets describing work performed."]
[]
[null,"For Equipment Costs, submit the Equipment Form  only. Backup documention should be retained by the grantee. "]
[null,"The following backup documentation should be retained in the event of an audit or provided at a Grant Administrator's request."]
[null,"For Project Expenditures this includes but is not limited to: "]
[null,"               a.  Proof the expenses claimed were paid in full"]
[null,"               b.  If a credit card was used to pay the expense, proof the amount charged to the credit card was paid off"]
[null,"               c.  For indirect costs, a cost allocation plan or other method for determining indirect rates"]
[null,"For Labor (in-house) costs this includes but is not limited to: "]
[null,"            a.  Pay stubs or payroll records showing employees' pay rates or salaries and showing employees were paid."]
[null,"            b.  Documentation supporting employee benefits billed to the grant."]
[null,"            c.  Documents used to calculate employees' hourly rates, including the Employee Compensation Chart, if applicable."]
[null,"For Equipment Costs this includes but is not limited to: "]
[null,"            a.  Grantee's Equipment Rate Policy "]
[null,"            b.  Log of equipment use, identifying operator, hours, hourly rate, and signed by operator and supervisor"]
[]
[null,"When can I seek reimbursement for contractor retention?"]
[null,"Retention withheld from construction contractor invoices must be paid by the grantee before seeking reimbursement."]
[]
[null,"Other possible FAQs: An expense I submit was denied. Can I resubmt?"]
[null,"How often should I submit a reimbursement Request?"]
[null,"I need an Advance or Advance to Escrow/How do I reconcile an advance?"]

{"sheet":"1 Project Expenditures","index":2,"n_rows":116,"n_cols":10,"rows_kept":116}
[null,"Project Expenditures Form"]
[null,"Use this form to list paid, eligible project expenditures to be reimbursed or to be reconciled against advanced grant funds. "]
[null,"•  List expenditures in the same order that corresponding receipts are scanned into your Invoices PDF. "]
[null,"•  Fill in ALL columns for every expenditure listed. Incomplete and/or missing information may result in a denied payment."]
[null,"•  Do not adjust formulas or insert hyperlinks. "]
[null,"Refer to the Reimbursement or Advanced Funds Request Guides and your Grant Administrator for additional instructions. "]
[null,"*Unhide rows for additional lines"]
[null,"**Hover over header cells with red flags at the top right corner of a field for instructions"]
[]
[null,"Grantee Name","Grant Number",{"$nulls":6},"CNRA Approved Total"]
[{"$nulls":9},{"$f":"SUM(G116,-(H116))","v":0}]
[{"$nulls":7},"Columns H - J for CNRA Use Only"]
["Line #","Payment Recipient","Task No.","Payment Date","Payment Type","Invoice Date","Payment Amount","Disallowed Amount","Reason","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[null,"                                                                                                   ",null,"Subtotal                                                                      ",null,null,{"$f":"SUBTOTAL(109,G14:G113)","v":0}]
[{"$nulls":3},"Indirect Costs for Expenditure Period"]
[{"$nulls":3},"Total to Be Reimbursed or Reconciled                                                             ",null,null,{"$f":"SUBTOTAL(109,ProjectExpenditures[Payment Amount])","v":0},{"$f":"SUBTOTAL(109,ProjectExpenditures[Disallowed Amount])","v":0}]

{"sheet":"2 Labor","index":3,"n_rows":111,"n_cols":11,"rows_kept":111}
[null,"Grantee Labor Costs Form"]
[null,"Use this tab to request reimbursement or reconciliation of advanced funds for Grantee's in-house labor used on the grant-funded project."]
[null,"Refer to the Reimbursement or Advanced Funds Request Guides and your Grant Administrator for additional instructions. "]
[null,"*Unhide rows for additional lines"]
[null,"**Hover over header cells with red flags at the top right corner of a field for instructions"]
[]
[null,"Grantee Name","Grant Number",{"$nulls":7},"CNRA Approved Total"]
[{"$nulls":10},{"$f":"SUM(H111,-(I111))","v":0}]
[{"$nulls":8},"Columns I - K for CNRA Use Only"]
["Line #","Person Performing Work ","Task No.","Date Work Began","Date Work Ended","No. of Hours Worked","Hourly Rate","Amount","Disallowed Amount","Reason for Dispute","Comments"]
[1,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[2,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[3,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[4,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[5,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[6,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[7,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[8,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[9,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[10,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[11,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[12,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[13,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[14,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[15,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[16,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[17,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[18,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[19,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[20,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[21,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[22,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[23,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[24,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[25,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[26,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[27,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[28,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[29,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[30,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[31,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[32,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[33,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[34,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[35,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[36,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[37,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[38,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[39,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[40,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[41,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[42,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[43,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[44,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[45,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[46,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[47,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[48,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[49,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[50,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[51,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[52,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[53,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[54,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[55,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[56,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[57,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[58,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[59,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[60,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[61,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[62,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[63,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[64,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[65,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[66,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[67,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[68,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[69,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[70,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[71,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[72,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[73,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[74,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[75,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[76,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[77,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[78,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[79,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[80,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[81,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[82,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[83,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[84,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[85,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[86,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[87,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[88,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[89,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[90,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[91,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[92,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[93,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[94,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[95,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[96,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[97,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[98,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[99,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[100,{"$nulls":6},{"$f":"ROUND(GranteeLabor[[#This Row],[No. of Hours Worked]]*GranteeLabor[[#This Row],[Hourly Rate]],2)","v":0}]
[null,"Total",{"$nulls":5},{"$f":"SUBTOTAL(109,GranteeLabor[Amount])","v":0},{"$f":"SUBTOTAL(109,GranteeLabor[Disallowed Amount])","v":0}]

{"sheet":"3 Equipment","index":4,"n_rows":36,"n_cols":11,"rows_kept":36}
[null,"Grantee-Owned Equipment Costs Form"]
[null,"Use this tab to invoice for the use of grantee-owned equipment when requesting reimbursement of costs."]
[null,"Grantee-owned vehicles used to transport personnel and supplies should not be charged as equipment. "]
[null,"Refer to the Reimbursement and Advanced Funds Request Guides and your Grant Administrator for additional instructions. "]
[null,"**Hover over header cells with red flags at the top right corner of a field for instructions"]
[]
[null,"Grantee Name","Grant Number",{"$nulls":7},"CNRA Approved Total"]
[{"$nulls":10},{"$f":"SUM(H36,-(I36))","v":0}]
[{"$nulls":8},"Columns I - K for CNRA Use Only"]
["Line #","Equipment Description","Task No.","Date Used","Work Performed","No. of Hours Used","Hourly Rate","Total Amount","Disallowed Amount","Reason for Dispute","Comments"]
[1,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[2,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[3,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[4,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[5,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[6,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[7,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[8,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[9,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[10,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[11,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[12,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[13,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[14,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[15,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[16,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[17,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[18,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[19,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[20,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[21,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[22,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[23,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[24,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[25,{"$nulls":5},0,{"$f":"ROUND(GranteeLabor3[[#This Row],[No. of Hours Used]]*GranteeLabor3[[#This Row],[Hourly Rate]],2)","v":0}]
[null,"Total",{"$nulls":5},{"$f":"SUBTOTAL(109,GranteeLabor3[Total Amount])","v":0},{"$f":"SUBTOTAL(109,GranteeLabor3[Disallowed Amount])","v":0}]

{"sheet":"4 Reimbursement Request Form","index":5,"n_rows":15,"n_cols":6,"rows_kept":15}
[]
[null,"Fill out the Reimbursement Request Form"]
[null,"Step 1: Confirm the total amount is correct",{"$nulls":3},"CNRA Approved Total"]
[null,"Total Amount of Request:",{"$f":"SUM(ProjectExpenditures[[#Totals],[Payment Amount]],GranteeLabor[[#Totals],[Amount]],GranteeLabor3[[#Totals],[Total Amount]])","v":0},"Enter this amount on the Reimbursement Request Form",null,{"$f":"SUM('1 Project Expenditures'!J11,'2 Labor'!K8,'3 Equipment'!K8)","v":0}]
[null,"(Sum of all worksheets)"]
[]
[null,"Step 2: Click the link below to launch the tool and access the form"]
[null,"Reimbursement Request Form"]
[]
[null,"Step 3: Download the signed form "]
[null,"Docusign will send an email with the final signed form attached. "]
[null,"Download the form and save it to your computer. A suggested name for the file is \"Request Form.\" "]
[]
[null,"Step 4: Email your request to bgpayments@resources.ca.gov"]
[null,"Attach the signed Request Form, Invoices, Workbook, and Payment Tracker."]

{"sheet":"5 Reconciliation of Advance","index":6,"n_rows":15,"n_cols":6,"rows_kept":15}
[]
[null,"Fill out the Advance Reconciliation Form"]
[null,"Step 1: Confirm the total amount is correct",{"$nulls":3},"CNRA Approved Total"]
[null,"Total Amount of Reconciliation:",{"$f":"SUM(ProjectExpenditures[[#Totals],[Payment Amount]],GranteeLabor[[#Totals],[Amount]],GranteeLabor3[[#Totals],[Total Amount]])","v":0},"Enter this amount on the Advance Reconciliation Form",null,{"$f":"SUM('1 Project Expenditures'!J11,'2 Labor'!K8,'3 Equipment'!K8)","v":0}]
[null,"(Sum of all worksheets)"]
[]
[null,"Step 2: Click the link below to launch the tool and access the form"]
[null,"Advance Reconciliation Form"]
[]
[null,"Step 3: Download the signed form "]
[null,"Docusign will send an email with the final signed form attached. "]
[null,"Download the form and save it to your computer. A suggested name for the file is \"Reconciliation Form.\" "]
[]
[null,"Step 4: Email your request to bgpayments@resources.ca.gov"]
[null,"Attach the signed Reconciliation Form, Invoices, Workbook, and Payment Tracker."]