Indirect Cost Rate Documentation Worksheet

Worksheet to document the negotiated indirect cost rate or the de minimis rate election under 2 CFR 200.414 and the cost allocation base.

Worksheet Header and Period

• Award Name
• Award Identifier
  Enter the grant, contract, or project identifier used internally or by the sponsor.
• Reporting Period Start
• Reporting Period End
• Prepared By
  Name or role of the preparer for internal audit trail purposes.
• Preparation Date

Indirect Cost Rate Election

• Rate Type
• Regulatory Reference
• Negotiated Rate Agreement Date
• De Minimis Election Date
• Rate Basis Description
  Describe how the rate was established or elected, including the approving entity or source documentation.

Cost Allocation Base

• Allocation Base Type
• Allocation Base Description
  Explain the base used and how it aligns with the approved rate agreement or de minimis election.
• Base Amount
• Excluded Cost Categories
  Select any categories excluded from the allocation base.
• Other Exclusion Details

Rate Calculation and Reconciliation

• Approved Rate (%)
  Enter the negotiated or de minimis rate as a percentage.
• Calculated Indirect Cost Amount
• Calculation Method
  Briefly explain the formula or method used to calculate the indirect cost amount.
• Reconciliation Notes
  Document any variances, adjustments, or rounding differences.

Compliance Attestation and Review

• Attestation
  I attest that this worksheet reflects the applicable indirect cost rate election, supporting documentation, and cost allocation base, and that the information provided is accurate to the best of my knowledge.
• Reviewer Name
• Review Date
• Approval Status
• Review Comments
  Add reviewer notes, requested corrections, or approval conditions.