Indirect Cost Rate Documentation Worksheet

This worksheet captures the indirect cost rate basis, the cost allocation base, the calculation method, and the reconciliation to the ledger in one place. It is meant to support grant budgeting, award administration, and audit documentation. Use it when you need a clear record of how the rate was selected and applied.

Yes, the template is structured to document either basis. Select the rate basis field to match the approved negotiated rate or the de minimis election, then attach the approval source and effective dates. If your organization uses both across different awards, create a separate worksheet per award or rate basis.

Complete it whenever a new award uses an indirect cost rate, when the rate changes, or when you need to document a new period of performance. Many organizations also refresh it at year-end or during closeout to confirm the calculation still reconciles to the ledger. If the rate is reused across awards, keep one worksheet per award or fiscal period as needed.

Finance, grants management, or accounting staff usually prepare the worksheet because they can document the rate basis, base amount, and reconciliation. A reviewer with budget or compliance responsibility should confirm the approval source, the excluded costs, and the final approval status. If your process requires it, route it to a grant manager or controller for sign-off.

Use the base type and description fields to identify what the rate is applied to, such as modified total direct costs or another approved base. Include only the costs that belong in the base and summarize excluded costs separately so the calculation is traceable. Avoid mixing in unallowable or excluded items, since that can distort the rate application.

Common issues include using the wrong rate basis, leaving the effective or expiration date blank, and failing to reconcile the indirect cost amount to the ledger. Another frequent problem is listing excluded costs without explaining why they were excluded. The worksheet works best when every number can be traced back to a source schedule or accounting record.

Yes, you can add fields for funder name, award terms, internal approval routing, or supporting schedule references. Keep the core fields intact so the worksheet still documents the rate basis, base, calculation, and reconciliation. If you collect any PII, keep the disclosure language and required fields limited to what you actually need.

The worksheet can be used alongside accounting exports, grant management systems, or document storage tools. The supporting schedule upload and reconciliation fields make it easier to link back to ledger reports, rate approvals, and workpapers. If you automate it, preserve an audit trail for edits and approvals.

A dedicated worksheet creates a repeatable record with defined fields, validation points, and review status instead of scattered email threads. That makes it easier to confirm the rate basis, the base amount, and the ledger tie-out during review or audit. It also reduces the risk of missing a date, approval source, or excluded-cost explanation.