Indirect Cost Rate Documentation Worksheet
Document your negotiated indirect cost rate or de minimis election, the allocation base, and the rate calculation in one worksheet. Use it to support grant compliance, review, and audit trail.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Nonprofit Grants Management · Higher Education Research Administration · Healthcare And Public Health Programs · State And Local Government
Overview
This worksheet captures the documentation needed to support an indirect cost rate election and the calculation behind the amount charged to an award. It is built for grant and finance teams that need to show whether they used a negotiated rate or a de minimis election, what cost allocation base was used, which costs were excluded, and how the final indirect cost amount was derived.
Use it when an award requires clear support for indirect cost treatment, when you are preparing a budget or reimbursement package, or when you want a consistent internal record for review and audit trail purposes. The worksheet is especially useful when multiple people touch the file, because it separates the preparer, reviewer, and approver roles and keeps the rate basis in one place.
Do not use it as a substitute for the actual rate agreement, sponsor terms, or your organization’s accounting policy. It also should not be used to justify a rate if the award does not allow indirect costs, if the rate basis is unknown, or if the calculation depends on data you have not verified. If your process includes multiple funding sources, unusual exclusions, or a changing allocation base, add notes or supporting schedules so the worksheet reflects the real method rather than a simplified estimate.
Standards & compliance context
- This worksheet supports documentation practices aligned with 2 CFR 200.414 by capturing the rate election, base, and calculation in one record.
- The attestation and review fields help create an audit trail that can support grant monitoring and internal control expectations.
- Recording only the fields needed for the award supports data minimization and reduces unnecessary collection of PII or unrelated financial detail.
- If the worksheet is shared externally, limit access to the minimum necessary users and retain supporting documents according to your records policy.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Worksheet Header and Period
This section ties the documentation to one award and one reporting window so the record is easy to trace later.
- 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
This section shows which rate path applies and where the authority for that choice comes from.
- 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
This section defines the denominator for the calculation and makes exclusions visible to reviewers.
- 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
This section proves how the indirect cost amount was derived and explains any differences that need context.
-
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
This section records who confirmed the worksheet and whether the documentation is approved for use.
-
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.
How to use this template
- Enter the award name, award identifier, reporting period, preparer, and preparation date so the worksheet is tied to one specific funding record.
- Select the indirect cost rate election type and record the CFR reference, agreement date, or de minimis election date that supports the rate basis.
- Describe the allocation base, enter the base amount, and list any excluded cost categories so the calculation reflects only the allowable base.
- Calculate the indirect cost amount using the approved rate percent and document the method and any reconciliation notes that explain differences or adjustments.
- Complete the attestation, route the worksheet to a reviewer, and record the approval status, review date, and comments before filing or submitting it.
- Store the worksheet with the related budget, rate agreement, and supporting schedules so future reviewers can trace the numbers without rebuilding the calculation.
Best practices
- Use the exact rate type that applies to the award and do not mix negotiated and de minimis language in the same record.
- Match the allocation base type to the calculation method, and avoid free-text descriptions that do not clearly identify what is included.
- List excluded cost categories explicitly so reviewers can see which costs were removed from the base and why.
- Use numeric fields for base amounts, approved rate percent, and indirect cost amount to reduce transcription errors.
- Add reconciliation notes whenever the calculated amount differs from a prior estimate, budget, or system-generated value.
- Keep the preparer and reviewer fields separate so the audit trail shows who created the worksheet and who approved it.
- Update the worksheet whenever the rate agreement changes, the election changes, or the reporting period is revised.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this worksheet used for?
This worksheet records the indirect cost rate election, the allocation base used to apply it, and the resulting calculation or reconciliation. It is meant to support grant file documentation and make the basis for indirect cost recovery easy to review. Use it when you need a clear audit trail for a negotiated rate or a de minimis election under 2 CFR 200.414.
When should I use a negotiated rate versus a de minimis rate?
Use the negotiated rate section when your organization has an approved indirect cost rate agreement and you need to document the applicable rate and agreement date. Use the de minimis section when your organization elects the allowable simplified rate and needs to record the election date and basis. The worksheet is designed to capture either path without forcing extra fields that do not apply.
Who should complete and review this worksheet?
It is usually prepared by grants, finance, or accounting staff who understand the award terms and the organization’s cost allocation method. A reviewer with budget, compliance, or fiscal oversight should confirm the rate basis, exclusions, and calculation before approval. The review section helps separate preparation from approval so the record is easier to trust later.
How often should this be completed?
Complete it at the start of the award period, whenever the rate election changes, and again when the base or calculation is updated. Many organizations also refresh it during closeout or periodic internal review to confirm the indirect cost amount still matches the approved method. If the award spans multiple periods, keep a separate record for each period or rate change.
What common mistakes does this template help prevent?
A common mistake is listing a rate without documenting the source, such as the negotiated agreement date or the de minimis election date. Another is using the wrong allocation base or failing to exclude unallowable or excluded cost categories from the base amount. The worksheet also helps prevent calculation errors by requiring the method, reconciliation notes, and reviewer signoff.
How does this support audit readiness?
It creates a single record that shows what rate was used, what base it was applied to, and who reviewed the result. That makes it easier to explain indirect cost treatment during monitoring, desk review, or audit. The attestation and review fields also help show that the documentation was checked before submission or posting.
Can I customize this for different grants or departments?
Yes. You can add fields for fund code, sponsor name, project code, or department if those are needed for your internal workflow. Keep the core fields intact so the worksheet still captures the rate election, allocation base, calculation, and approval trail.
What should I connect this worksheet to in my workflow?
It pairs well with grant budgets, general ledger detail, cost allocation schedules, and indirect cost rate agreements. If your process includes approvals, connect it to your document management system or workflow tool so the reviewer comments and approval status are retained. That reduces back-and-forth when someone needs to trace the numbers later.
Related templates
Go deeper on the topic
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
Job hazard analysis (JHA) — also called job safety analysis (JSA) — is the structured exercise of breaking a work task into sequential steps, identifying the...
-
A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
-
AI governance is the framework a company uses to decide what AI tools are allowed to do, who's accountable for their outputs, what data they're allowed to...
-
See how MangoApps Forms helps teams collect, track, and analyze employee data in real time — with mobile access, file uploads, and enterprise-grade security.
-
Eliminate workforce operations setup tax with automated sync, passwordless access, and faster employee readiness.
-
Discover the 5 essential communication platform features every start-up needs—from mobile-first access and security to employee engagement and real-time...
-
Discover how digital transformation improves healthcare employee experience—streamlining communication, reducing admin burden, and boosting frontline...
Ready to use this template?
Get started with MangoApps and use Indirect Cost Rate Documentation Worksheet with your team — pricing built for small business.
