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

• Worksheet title
• Reporting period start date
• Reporting period end date
• Award or project ID
  Enter the grant, award, or project identifier used internally for this allocation.
• Prepared by name
  Enter the name of the staff member preparing this worksheet.
• Prepared by email

Indirect Cost Rate Basis

• Indirect cost rate basis
• Indirect cost rate percentage
  Enter the approved or elected rate as a percentage.
• Rate effective date
• Rate expiration date
  Leave blank if the rate is ongoing or not time-limited.
• Approval or election source
• If other, describe the approval source

Cost Allocation Base

• Cost allocation base type
• Base description
  Describe the cost base and any organization-specific rules used to define it.
• Base amount
  Enter the total amount of direct costs in the allocation base.
• Excluded costs summary
  Summarize any excluded costs, such as unallowable items or costs excluded from MTDC.
• Supporting schedule attached

Calculation and Reconciliation

• Calculation method
• Calculated indirect cost amount
• Reconciled to general ledger
• Reconciliation difference
  Enter the variance if the worksheet does not match the ledger exactly.
• Reconciliation explanation

Compliance Attestations and Review

• PII and disclosure notice acknowledged
• Compliance attestation
• Reviewer name
• Reviewer comments
• Approval status