2020-JAII-04 Attachment D RD Grant Capital Budget and Invoice Template-Match.xlsx

XLSX spreadsheet 100 KB Posted

Attached to
2020-JAII-04 Collaborative Research Matching Grant Program Request for Grant Applications
Solicitation number
BD-20-1367-1367C-1367L-46253
Issued by
Worcester County, Massachusetts

About this file

This document is a budget and invoice template for a Request for Grant Applications (RFA) issued by the John Adams Innovation Institute, a division of the Massachusetts Technology Collaborative. The RFA offers matching funds for capital expenditures related to collaborative research projects sponsored by public, private, and nonprofit entities in Massachusetts. The budget template provides guidelines for allowable capital and non-capital costs, match requirements, and invoicing procedures. It includes sections for applicant information, budget period, cost elements, capital expenditures, and other project expenses. The template also specifies documentation requirements, variance allowances, and the need for prior approvals from the Program Manager for certain budget changes. The RFA is a rolling solicitation that will remain open until closed by the Massachusetts Technology Collaborative.

The budget template outlines the required cost elements and format for submitting invoices and match documentation. It specifies that match can be provided in the form of cash or in-kind contributions, and that match expenditures must be directly relevant and beneficial to the project. The template also provides guidelines for determining the valuation of in-kind contributions and the need to properly document the source and nature of all match funds.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Budget&Invoice_Template

Line NumberBudgetingLEGEND:
2Applicant InformationTabThese tabs need to be completed and submitted with proposal
3Applicant:Solicitation No.:TabThese tabs are guidelines for Budget and Match requirements
4Budget Period:Title of Proposed Project:CellFormula cell
5Address:CellData entry cell
6
7This section is for post-contract invoicing only. Do not complete with proposal.
8MTC Funding Requested:
9Total Project Cost:Invoicing Year 1Invoicing Year 2Invoicing Year 3Invoicing Year 4Invoicing Year 5
10Cost ElementsTotal ProjectMatch FundsMTC FundingCheck (should be zero)Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Cumulative
11CAPITALPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYY
12The acquisition cost of capital assets or the expenditures to make improvement to capital assets that materially increase their value. Acquisition cost includes the cost of putting the asset in place.AmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountExpendedRemaining
13I. Equipment, land, building, etc.
14$0$0$ - 0$ - 0
15$0$0
16$ - 0$0
17$ - 0$0
18$ - 0$0
19Total Capital Expenditures$0$0$0$0
20
21II. Capital Labor
22name/titleAnnual SalaryPercent Effort
23$0$0$0$0$ - 0$ - 0
24$0$0$0$0
25$0$0$0$0
26$0$0$0$0
27Total Labor$0$0$0$0
28
29II. Direct Labor Fringe CostRate (%):$0$0$0-$0$ - 0$ - 0
30
31III. Capital Subcontractors/Consultants
32Firm name/title of consultant/type of services to be providedhoursrate/hr
33$0$0$ - 0$ - 0
34$0$0
35$0.00$0
36$0.00$0
37Total Subcontractors/Consultants$0$0$0$0
38
39IV. Capital Direct Materials
40$0.00$0.00$ - 0$0.00
41$0.00$0.00
42$0.00$0.00
43Total Direct Materials$0$0$0$0
44
45V. Other Capital Costs (list by type)
46$0.00$0.00$ - 0$0.00
47$0.00$0.00
48$0.00$0.00
49Total Other Capital Costs$0$0$0$0
50
51VI. Capital Overhead/Indirect CostsRate (%):0%$0.00$0$ - 0
52TOTAL Capital Project Expenditures$0$0$0-$0.00$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
53Other Project Expenses
54(not capitalizable under GAAP and not reimbursable)
55I. Direct Labor
56name/titleHRSRate
57$0$0
58$0$0
59$0$0
60$0$0
61Total Direct Labor$0$0
62
63II. Direct Labor Fringe CostRate (%):
64
65II. Subcontractors/Consultants
66Firm name/title of consultant/type of services to be providedhoursrate/hr
67$0$0
68$0$0
69$0$0
70$0$0
71Total Subcontractors/Consultants$0$0
72
73III. Direct Materials
74$0.00
75$0.00
76Total Direct Materials$0$0
77
78IV. Travel$0.00
79
80V. Other Direct Costs (list by type)
81$0.00
82$0.00
83$0.00
84Total Other Direct Costs$0$0
85
86VI. General & Administrative Expense/OverheadRate (%):0%$0
87
88Total Other Project Costs$0$0
89
90Total PROJECT COSTS$0$0$0
91Cost ShareERROR:#DIV/0!ERROR:#DIV/0!
92Contractual Minimum Cost Share Met (Yes/No)11YESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYES
Additional detail in support of the budget should be provided on the Budget Assumptions tab
Upon invoicing, additional detail in support of the match expenditures should be provided on the Supporting Schedule

&"Arial,Bold"&11Massachusetts Technology Collaborative

Research and Development Standard Budget and Invoice Template Invoiced Costs

Budget- Cost by Fiscal Year

FY'22 (July 1, 2021-June 30, 2022)FY'23(July 1, 2022-June 30, 2023)FY'24 (July 1, 2023-June 30, 2024)FY'23(July 1, 2024-June 30, 2025)FY'24 (July 1, 2025-June 30, 2026)TotalCheck Against Approved Budget Totals
Capital Expenditures Budget
Equipment, Land, Buildings, etc.$0.00$0.00
Labor$0.00$0.00
Direct Benefits/Fringe Cost$0.00$0.00
Subcontractors/Consultants$0.00$0.00
Direct Materials$0.00$0.00
Other Capitalizable Costs$0.00$0.00
Capital Overhead/Indirect Costs$0.00$0.00
Total Capital$0.00$0.00$0.00$0.00$0.00$0.00
Non-Capital Budget Costs
Direct Labor$0.00$0.00
Direct Benefits/Fringe Cost$0.00$0.00
Subcontractors/Consultants$0.00$0.00
Direct Materials$0.00$0.00
Other Direct Costs$0.00$0.00
Overhead/Indirect Costs$0.00$0.00
Total Non-Capital$0.00$0.00$0.00$0.00$0.00$0.00
Total Project Costs$0.00$0.00$0.00$0.00$0.00$0.00
Grant Funds Expenditures by Fiscal Year**$0.00$0.00$0.00$0.00$0.00$0.00
Match/Costs Share Funds$0.00$0.00$0.00$0.00$0.00$0.00

** Project the costs from the budget template annually based upon the Participants anticipated timing of expending the grant funds. Availability of funds from MassTech is subject to authorization from the Commonwealth, and is not guaranteed at the levels requested.

Budget Breakdown: Annually

Budget Assumptions

Budget Assumptions -- Standard Budget Form
Please provide supporting details to line items on the budget template if not self explanatory.
Budget Line #Item detailed description, basis of budgeted costs, explanation of determination of capitalize costs vs. non-capital costs, basis of indirect cost rate and approving authority, and any other relevant details to support budget costs
Example: Line 86G&A % is based upon our federally approved rate, indirect cost rate agreement is attached.

Budget Guidelines

PARTICIPANT BUDGET/INVOICE GUIDELINES

These guidelines apply to MassTech R&D grants that require Participants to incur expenditures in line with approved budgets within their contracts. In developing these guidelines, MassTech has drawn heavily from the policies and practices applied by federal and other state agencies that also require adherence to grant budgets. Adherence to approved budgets ensures that MassTech is expending funds in a fiscally responsible manner and, managing to the legislation of the state appropriated funds.

Capital Grant Expenditure Categories:

• Capital Labor: Direct labor at actual cost to the Participant, based upon an hourly rate, or percent effort of an annual base salary.

• Capital Fringe: Benefits related to direct labor costs, can either be incurred as a direct expense or an allocated cost with an approved rate. Documentation of Participant approved rates should be submitted at the time of proposal.

• Capital Consultants/Subcontracts: contracted services to perform a specific task related to the project or, subcontracts granting funds for performance of a key aspect of the project.

• Capital Direct Materials: Materials and supplies needed in direct support of the project, in order to obtain the objectives as stated in the approved budget and contract.

• Other Capital Direct Costs: This includes categories such as travel and materials.

• Capital General & Administrative Expense/Overhead: An allocated cost that must be capital and based upon an approved rate. Indirect cost rates shall be assessed in accordance with your institutions rate agreement as it pertains to capital expenditures. Documentation of Participant approved rates should be submitted at the time of proposal.

Capital Expenditure Guidelines:

• Participant may only be reimbursed for capital cost incurred and expenditures must be properly recorded as capital, and verifiable in the Participant’s records.

• MassTech may allow up to a 5% annual increase in the direct labor rates set forth in the budget to account for actual cost of living increases over multiyear reimbursement periods. This variance must be explained in the supporting schedule when invoicing and is subject to approval by the Program Manager.

• MassTech may allow up to a 20% variance from the rates on services/consultants if estimates where used in creating the budget. This variance must be explained in the supporting schedule when invoicing and is subject to approval by the Program Manager.

• MassTech may allow up to a 10% variance from cost categories set forth in the approved budget and explained in the supporting schedule when invoicing.

• Any variance greater than the thresholds listed above, must be formally approved by the Program Manager prior to invoice submission and may require formal amendment to the contract.

• Participant must incur costs within the grant period. Pre-award spending is only allowed when incorporated through a provision in the grant agreement.

• Participant may not be reimbursed for grant expenditures by any other source.

• Direct replacement of personnel with similar roles and rates should be explained in the supporting schedule. Any newly added staff/roles meant to be in addition to personnel identified in the approved budget must be approved by the Program Manager prior to invoice submission.

Participant Documentation Requirements:

• To the extent the Participant can produce accounting-system generated reports, deemed acceptable by MassTech, to verify expenditure amounts consistent with the budget categories that tie to invoice amounts and categories, they should be submitted with all invoices. MassTech reserves the right to request additional supporting documentation at any time.

• To the extent the Participant can’t provide, or MassTech does not accept the form of accounting-system generated reports, the Participant must provide supporting documentation that could include, but is not limited to, vendor invoices, labor reports listing hours and rates by employee.

• Participant must submit with its invoice, the certification relating to the appropriateness of the reimbursable costs and amounts of match costs, as attached to the contract, with a signature by an individual with knowledge of the information to which the certification relates and who is authorized to certify on behalf of the organization.

Match Guidelines

PARTICIPANT MATCH GUIDELINES

These guidelines apply to MassTech grants that require Participant’s to secure and provide matching funds to cover the portion of the project expenses not to be reimbursed by MassTech. In developing this policy, MassTech has drawn heavily from the policies and practices applied by federal and other state agencies that require match under their programs.

Forms and Source of Match:

• Cash Contribution: Cash contributions specifically to cover a portion of the actual costs incurred of the grant-funded project.

• In-kind Contribution: In-Kind donations can be in the form of necessary services, volunteers, materials, and equipment if it’s directly related to the project objectives.

• Source: The cash and in-kind contributions can come from the Participant or from third parties, so long as it is not sourced by, or considered discretionary funds under the control of, a state agency as defined in Mass. Gen. Laws Ch. 6, § 39.

Match Fund Guidelines:

• Participant must include use of match funds in the approved budget, within the MassTech grant agreement.

• At project start, Participant must clearly document the direct relevance and benefit of the proposed match to the project. MassTech will review the source and nature of the match, and document approval internally.

• Participant must document match met within the invoice period, and to the extent possible it should be ratable with the expenditure of the MassTech grant funds .

• Participant must incur match expenditures and receive in-kind contributions within the grant period. Prior approval is required to allow match that falls outside that period.

• Participant must properly document the basis for determining the valuation for items such as volunteer services and donated property, if the matching funds include in-kind contributions.

• Participant may not apply approved match amounts as match on any other award.

Participant Documentation Requirements:

•Participant should provoide a narrative explanation of the source of match as well as the relevance of the match to the funded project, if this is not included as part of the proposal it shoudl be done wiht the first invoice and then any necessary updates to that narrative should be provided during the grant period to the extent there are changes or addtional match items.

•Participant should record amounts considered as match in the Participant’s books and this must be verifiable from the Participant’s records.

• Invoices shall provide reasonable documentation including system-generated detailed activity reports showing income and expenses to provide evidence of costs incurred for the required match met (just as it is for reimbursable costs). Additional documentation to support costs may be requested by MassTech from time to time and may include vendor invoices and effort reports listing percent effort and annual base salary by employee/volunteer. • When In-Kind contributions are booked on the Participants accounting records, this should be documented using a detailed system-generated report. To the extent it is not booked, we will need a donation letter from the donor stating its value and intent to support the project. For any in-kind contributions not recorded on the Participants books, the basis for determining the valuation must be documented within the donation letter.

• Participant must submit with its invoice, the certification relating to the appropriateness of the matching funds, as attached to the contract, with a signature by an individual with knowledge of the information to which the certification relates and who is authorized to certify on behalf of the organization.

Invoice Form_Match Recorded

Line NumberBudgetingLEGEND:
2Applicant Information
3Applicant:Solicitation No.:Formula cell
4Budget Period:Title of Proposed Project:Data entry cell
5Address:0
6
7This section is for post-contract invoicing only. Do not complete with proposal.
8MTC Funding Requested:$0
9Total Project Cost:$0Match Year 1Match Year 2Match Year 3Match Year 4Match Year 5
10Cost ElementsTotal ProjectMatch FundsMTC FundingCheck (should be zero)Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4Cumulative
11CAPITALPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYYPeriod: MM/DD/YYYY-MM/DD/YYYY
12The acquisition cost of capital assets or the expenditures to make improvement to capital assets that materially increase their value. Acquisition cost includes the cost of putting the asset in place.AmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountAmountExpendedRemaining
13I. Equipment, land, building, etc.
14$ - 0$0.00$0.00$0$ - 0$ - 0
15$ - 0$0.00$0.00$0
16$ - 0$0.00$0.00$0
17$ - 0$0.00$0.00$0
18$ - 0$0.00$0.00$0
19Total Capital Expenditures$0$0$0$0
20
21II. Capital Labor
22name/titleAnnual SalaryPercent Effort
230$0$0$0$0$0$ - 0$ - 0
240$0$0$0$0$0
250$0$0$0$0$0
260$0$0$0$0$0
27Total Labor$0$0$0$0
28
29II. Direct Labor Fringe CostRate (%):0%$0$0$0-$0$ - 0$ - 0
30
31III. Capital Subcontractors/Consultants
32Firm name/title of consultant/type of services to be providedhoursrate/hr
330$0$0$0$0$0$ - 0$ - 0
340$0$0$0$0$0
350$0$0$0$0$0
360$0$0$0$0$0
37Total Subcontractors/Consultants$0$0$0$0
38
39IV. Capital Direct Materials
40$0.00$0.00$0.00$0.00$ - 0$0.00
41$0.00$0.00$0.00$0.00
42$0.00$0.00$0.00$0.00
43Total Direct Materials$0$0$0$0
44
45V. Other Capital Costs (list by type)
46$0.00$0.00$0.00$0.00$ - 0$0.00
47$0.00$0.00$0.00$0.00
48$0.00$0.00$0.00$0.00
49Total Other Capital Costs$0$0$0$0
50
51VI. Capital Overhead/Indirect CostsRate (%):0%$0$0$0$0.00$0$0
52TOTAL Capital Project Expenditures$0$0$0-$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
53Other Project Expenses
54(not capitalizable under GAAP)
55I. Direct Labor
56name/titleAnnual SalaryPercent Effort
570$0$0$0$0$ - 0$ - 0
580$0$0$0$0
590$0$0$0$0
600$0$0$0$0
61Total Direct Labor$0$0$0
62
63II. Direct Labor Fringe CostRate (%):0%$0$0$0$ - 0$ - 0
64
65II. Subcontractors/Consultants
66Firm name/title of consultant/type of services to be providedhoursrate/hr
670$0$0$0$0$ - 0$ - 0
680$0$0$0$0
690$0$0$0$0
700$0$0$0$0
71Total Subcontractors/Consultants$0$0$0
72
73III. Direct Materials
74$0.00$0.00$0.00$ - 0$0.00
75$0.00$0.00$0.00
76Total Direct Materials$0$0$0
77
78IV. Travel$0.000$0.00$ - 0$ - 0
79
80V. Other Direct Costs (list by type)
81$0.00$0.00$0.00$ - 0$0.00
82$0.00$0.00$0.00
83$0.00$0.00$0.00
84Total Other Direct Costs$0$0$0
85
86VI. General & Administrative Expense/OverheadRate (%):0%$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$ - 0
87
88Total Other Project Costs$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$ - 0
89
90Total PROJECT COSTS$0$0$0-$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$ (0.00)
91Cost ShareERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
92Upon invoicing, additional detail in support of the match expenditures should be provided on the Supporting Schedule, in the sixth tab of this workbook.

&"Arial,Bold"&11Massachusetts Technology Collaborative

Standard Budget and Invoice Template Match Costs

Invoice Supporting Schedule Supporting Schedule -- Standard Invoicing Form

Invoice Period (Y#Q#) & Line #Please provide below, a detailed explanation for any categorical variance within 10%, labor rate variance within 5%, and consultant/subcontractor cost variance within 20% from approved budget amounts. The following require prior written approval from your Project Manager before submitting the invoice, variance above the thresholds mentioned here, new line items to the approved budget, and any changes to indirect cost allocation methodologies. Any such approvals should also be listed with any helpful explanation that might be helpful in reviewing the supporting documentation.
Example: Y1Q1 Line 15Example: XYZ equipment was 12% over budget. The variance was due to finding out that the vendor with the most competitive quote amount, could not deliver within the schedule. So the equipment ended up costing more then projected in the approved budget, but within the allowable variance per the budget guidelines.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .