Budget Template

Budget Templates

ORSP is responsible for approving budget(s) of all proposals to outside granting agencies, and negotiates awards with funding agencies. Budget development should be detailed, realistic, and as comprehensive as possible to ensure that all costs of the project have been accounted for.

The Budget Template is used by faculty and staff in the preparation of their grant budgets.

  • The budget template includes auto-calculating features to calculate the most current approved fringe benefits and facilities and administrative costs (F&A) as established by the current Rutgers rate agreement, as well as imposing the correct calculation rules regarding those purchases or services that do not incur F&A.

  • Please also see the cost share policy for information regarding when a budget with cost share detail is required.

  • Once completed, the budget template and a complete budget justification (including cost-share detail when applicable) should be sent electronically to the Grants Specialist for review and comment. The Grants Specialist will respond back with any questions, concerns, request for correction(s), or suggestions on how to clarify the budget or justification.

Please note that the total funds awarded/granted by the sponsor at the time of award may not reflect the total amount of funds requested at the time of the proposal submission. As a result, your Grants Specialist will request a revised budget when necessary to reflect the exact amount of funds (in MTDC or TDC) and F&A received from the sponsor as stated in the award document.

System/Software Requirements:

PC : Please be sure you are using the most recent version of of Microsoft Excel available.

Mac: Please be sure you are using the most recent version of of Microsoft Excel available.

Instructions (Budget Template)

  1. Begin using the template by completing the Welcome worksheet. This must be completed in order for the template to calculate correctly.
  2. Continure on to the Personnel Worksheet. This information will automatically populate the Budget Worksheet.    
  3. Complete the Consultant Worksheet to include any consultants on the project (optional). These totals will be carried to the Budget Worksheet.    
  4. Complete the Subcontractor Worksheet to identify any outgoing subcontracts. The totals will be carried over to the Budget Workseet.    
  5. Complete the remainder of the Budget Worksheet.    
  6. The Notes section is optional and may be used to enter freeform notes regardng the budget.    
  7. The Effort Calculator is available for use in determining effort in person months.

Instructions (Advanced Budget Template incliding Cost Sharing)

This template may be used when there is need for a more complex budget preparation/estimation that will calculate F&A across fiscal years and/or if cost sharing is a component of the project.

  1. Begin using the template by completing the Welcome worksheet. This must be completed in order for the template to calculate correctly.
  2. Continue by lcicking on the Personnel worksheet. This information will populate the the respective sections on the individual Budget Period and Budget Summary worksheets.
  3. If applicable, use the Personnel (Cost Sharing) worksheet to include as part of the overall request. The categories and names will carry-over from the Personnel worksheet. This information will populate the the respective sections on the individual Budget Period and Budget Summary worksheets.
  4. If applicable, complete the Consultant worksheet to include any consultants on the project. This information will populate the the respective sections on the individual Budget Period and Budget Summary worksheets.    
  5. If applicable, complete the Subcontractor Worksheet to identify any outgoing subcontracts. This information will populate the the respective sections on the individual Budget Period and Budget Summary worksheets.
  6. Complete the worksheets BP1 through BP5 for each of the budget periods. Note that there for each fiscal period the budget spans, a default allocation will be applied (by percentage) based on the number of days the project is in that given fiscal period. The default allocation may be overridden to meet specific needs for each individual line item. Salary allocations must be changed on the respective salary worksheets.
  7. The Budget Summary is not editable and reflects the total amounts of the information provided on BP1 through BP5.
  8. The Notes section is optional and may be used to enter freeform notes regardng the budget.    
  9. The signature page may be used to obtainin the necessary signatures when cost share is involved. You may enter the cost sharing distribution for each line there will be a summation at the bottom of the page.