Indirect Cost Rate Allocation Worksheet
Track approved indirect rates, MTDC exclusions, and award-level allocations in one worksheet. Use it to apply overhead consistently, reconcile to the GL, and document compliance for each grant period.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Higher Education · Nonprofit Organizations · Healthcare And Research · Government Contractors
Overview
The Indirect Cost Rate Allocation Worksheet is a finance and grants compliance form for applying an approved indirect rate, or a de minimis rate where allowed, to the correct direct cost base by award. It captures the rate source, the base methodology, award-level direct costs, MTDC exclusions, and the final allocation summary so the calculation can be reviewed and reproduced later.
Use this template when you need to allocate overhead across federal, pass-through, or private awards and want a clear audit trail from source data to posted indirect expense. It is especially useful when awards have different indirect rules, when some costs must be excluded from the base, or when the indirect amount posted in the GL needs to be reconciled to the worksheet. The review and approval section also helps document who validated the method and when.
Do not use this worksheet as a substitute for award-specific terms review or as a catch-all budget form. If an award prohibits indirect costs, caps recovery, or uses a special base definition, those rules should drive the calculation. It is also not the right tool for unrelated expense coding, payroll allocation, or direct cost billing. The value of the template is in making the indirect calculation transparent, consistent, and easy to audit.
Standards & compliance context
- The worksheet supports Uniform Guidance indirect cost documentation by recording the approved rate, allowable base, and award-level exclusions used in the calculation.
- Capturing award terms review, rate authorization, and record retention helps create an audit trail for federal and pass-through awards.
- Using MTDC exclusion fields for equipment, subcontracts, patient care, tuition, and offsite rental helps prevent overstatement of the indirect base.
- The form should collect only the award and accounting details needed for the allocation, consistent with GDPR data minimization and the minimum-necessary principle.
- If any PII is added in notes or attachments, the worksheet should include a clear disclosure of what is collected and why.
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 anchors the allocation to a specific organization, fiscal year, and reporting window so the calculation can be traced later.
- Organization / Entity Name
-
Fiscal Year
Enter the fiscal year this worksheet covers.
- Allocation Period Start Date
- Allocation Period End Date
- Prepared By (Name and Title)
- Date Prepared
- Department / Cost Center
-
Worksheet Version / Revision Number
Track revisions for audit trail purposes.
Indirect Cost Rate Details
This section records the rate source and base methodology, which determines how the indirect calculation should be applied.
-
Indirect Cost Rate Type
Select the rate type applicable to this organization for this period.
- If 'Other Approved Rate', describe the rate source and authorization
-
Cognizant Federal Agency (for NICRA rates)
The federal agency responsible for negotiating and approving the rate agreement.
-
NICRA Agreement Date
Date the current NICRA was executed.
-
Approved Indirect Cost Rate (%)
Enter the rate as a percentage (e.g., enter 10 for 10%, 26.5 for 26.5%). De minimis rate is always 10.00%.
-
Cost Base Methodology
Select the direct cost base to which the indirect rate is applied. MTDC is required for de minimis rate users per 2 CFR §200.1.
- If 'Other Approved Base', describe the base and cite authorization
-
This Rate Applies To
Select all award types covered by this rate on this worksheet.
-
Rate Documentation Attached
Confirm that the NICRA, de minimis election documentation, or other rate authorization is attached or on file.
-
Upload Rate Authorization Document (optional)
Upload NICRA, de minimis election letter, or other supporting documentation.
Award-Level Direct Cost Base and Exclusions
This section shows which awards are included and which direct costs are excluded so the allowable base is calculated correctly.
-
Award Direct Cost Base Table
Enter one row per award. All dollar amounts in USD. Exclusions apply only when using MTDC methodology.
-
Awards with Indirect Cost Restrictions or Caps
Some private funders prohibit or cap indirect costs. Document these here to ensure compliance and avoid over-recovery.
-
Awards Explicitly Prohibiting Indirect Cost Recovery
Per 2 CFR §200.414(c)(1), if a federal program statute or regulation prohibits recovery, document it here.
MTDC Exclusion Detail
This section breaks out each exclusion category to make the modified total direct cost calculation transparent and reviewable.
-
Equipment and Capital Expenditures Excluded ($)
Items with unit cost ≥ $5,000 and useful life >1 year, per 2 CFR §200.1 definition of ‘equipment’.
-
Subcontract Costs Excluded (amounts >$25,000 per sub) ($)
Only the portion of each subcontract exceeding $25,000 is excluded from MTDC per 2 CFR §200.1.
- Patient Care Charges Excluded ($)
- Tuition Remission Excluded ($)
- Off-Site Facility Rental Costs Excluded ($)
- Other Exclusions ($)
-
Description of Other Exclusions
Describe any exclusions not covered by the standard MTDC categories above and cite the regulatory or award-specific authority.
-
Total MTDC Exclusions – All Awards Combined ($)
Sum of all exclusion categories above. Should reconcile to the sum of MTDC Exclusions column in the Award Table.
Allocation Summary and Reconciliation
This section ties the worksheet to the posted indirect amount and explains any difference between the calculated total and the GL.
-
Total Direct Costs – All Awards ($)
Sum of Total Direct Costs column from the Award Table.
-
Total MTDC Exclusions – All Awards ($)
Sum of MTDC Exclusions column. Enter 0 if using TDC methodology.
-
Total Allowable Cost Base – All Awards ($)
Total Direct Costs minus Total MTDC Exclusions. This is the base to which the indirect rate is applied.
-
Total Indirect Costs Allocated – All Awards ($)
Sum of Indirect Cost Charged column from the Award Table. Should equal Total Allowable Base × Approved Rate.
-
Indirect Costs Not Recovered (due to funder restrictions) ($)
Amount of indirect cost that could not be charged due to funder caps or prohibitions. Document for internal cost analysis.
-
General Ledger Account(s) for Indirect Cost Allocation
Reference the GL account codes used to record indirect cost charges and recoveries.
-
Reconciliation Variance (if any) ($)
Difference between calculated indirect costs and amounts posted to the GL. Should be $0.00. Document any variance and explain below.
-
Variance Explanation
If a reconciliation variance exists, explain the cause and corrective action.
-
Supporting Schedules / Trial Balance Attached
Confirm that the supporting trial balance or cost detail reports are attached or referenced.
-
Upload Supporting Schedule (optional)
Upload trial balance, cost detail export, or other reconciliation support.
Compliance Attestations
This section captures the reviewer’s confirmation that the method, rate, and award terms were checked before approval.
-
Consistent Methodology
I confirm that the same indirect cost rate and base methodology has been applied consistently to all awards in this period, without cherry-picking rates by award.
-
No Double-Charging of Costs
I confirm that no costs included in the indirect cost pool have also been charged as direct costs to any award (per 2 CFR §200.405(c)).
-
Rate is Properly Authorized
I confirm that the rate applied is either a current NICRA from the cognizant federal agency or the de minimis rate elected per 2 CFR §200.414(f), and that supporting documentation is on file.
-
Award Terms Reviewed for Indirect Cost Allowability
I confirm that each award’s terms and conditions have been reviewed for indirect cost restrictions, caps, or prohibitions, and that this worksheet reflects those limitations.
-
Records Retention Compliance
I confirm that this worksheet and all supporting documentation will be retained for a minimum of 3 years after the final expenditure report per 2 CFR §200.334, or longer if required by award terms.
-
Additional Notes or Disclosures
Use this field to document any exceptions, pending rate negotiations, or circumstances that deviate from standard practice.
Review and Approval
This section creates the sign-off trail and sets the next review date so the worksheet stays current across allocation periods.
- Reviewed By (Name and Title)
- Review Date
-
Reviewer Signature
Electronic signature of the reviewing finance official.
-
Approved By (Name and Title)
Required for allocations exceeding organizational materiality threshold or involving federal awards.
- Approval Date
-
Approver Signature
Electronic signature of the approving official (CFO, Finance Director, or designee).
-
Next Scheduled Review / Reconciliation Date
Set the date for the next indirect cost reconciliation (typically monthly or quarterly).
How to use this template
- Enter the organization, fiscal year, allocation period, preparer, department cost center, and worksheet version so the calculation is tied to a specific reporting cycle.
- Select the rate type, enter the NICRA or cognizant agency details if applicable, and record the approved indirect rate percent and base methodology used for the allocation.
- List each award in the award table with its direct cost base, then flag awards with indirect restrictions or no-indirect terms before calculating the allowable base.
- Record MTDC exclusions by category, using the correct field for each exclusion type and adding an other description only when the standard categories do not apply.
- Review the allocation summary, compare the total indirect costs allocated to the GL indirect cost account, and explain any reconciliation variance before approval.
- Complete the compliance attestations, capture reviewer and approver signatures, and set the next review date for the following allocation period.
Best practices
- Use the award terms, not the budget, as the source of truth for whether indirect costs are allowed and which base applies.
- Mark required fields clearly and keep optional fields limited so the worksheet follows the minimum-necessary principle for PII and award data.
- Use conditional logic to hide rate-type-specific fields until they apply, which keeps the form readable and reduces entry errors.
- Separate MTDC exclusions by category instead of combining them in one note field so reviewers can verify the base calculation quickly.
- Reconcile the worksheet to the GL indirect cost account before approval, and explain any variance in plain language.
- Keep the award-level table aligned to the same period as the allocation period so partial-period awards do not distort the base.
- Document any award with indirect restrictions in the exclusions or notes section so the reviewer can see why the rate was not applied.
- Retain the source documents referenced by the worksheet, including the NICRA, award terms, and supporting ledger detail, in the audit trail.
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 applies an approved or de minimis indirect cost rate to each award’s allowable direct cost base and records the exclusions used to calculate MTDC. It also captures the reconciliation to the general ledger so finance can explain any variance. Use it when you need a repeatable allocation method across federal, pass-through, and private awards.
Who should complete the worksheet?
It is usually prepared by grants finance, sponsored programs, or accounting staff who understand the award terms and the organization’s indirect cost policy. A reviewer with budget or compliance responsibility should verify the rate, base, and exclusions before approval. If the organization uses a cognizant agency or NICRA, the preparer should attach or reference the authorization details.
How often should this be completed?
Most organizations complete it each month, quarter, or at the close of the grant period, depending on how often indirect costs are posted. The right cadence is the one that matches your GL close and award reporting cycle. If awards have different end dates, the worksheet should be updated whenever a new allocation period begins.
Does this worksheet work for both federal and private grants?
Yes, as long as the award terms allow indirect cost recovery and the base method matches the sponsor’s rules. The worksheet includes a field for award types and restrictions so you can separate awards that allow full recovery from those that cap or prohibit indirect charges. For private grants, the same structure helps document the sponsor-specific method you used.
What compliance issues does it help with?
It supports documentation for Uniform Guidance indirect cost treatment, including approved rates, allowable bases, and MTDC exclusions. It also helps show that you reviewed award terms, avoided double charging, and retained records for audit trail purposes. If your organization handles federal funds, this worksheet helps keep the allocation method consistent and defensible.
What are the most common mistakes when using it?
Common mistakes include applying the wrong rate type, leaving out MTDC exclusions, and using a direct cost base that does not match the award terms. Another frequent issue is failing to reconcile the allocated amount to the GL, which makes variance explanations harder later. The worksheet is designed to surface those issues before approval.
Can I customize the worksheet for our chart of accounts or ERP?
Yes. You can add fields for fund, project, grant number, cost center, or account code so the allocation ties cleanly to your ERP or accounting system. If you use a subledger or grant management tool, keep the worksheet fields aligned with the source data so the reconciliation step stays simple.
How does this compare with allocating indirect costs ad hoc in spreadsheets?
Ad hoc spreadsheets often miss exclusions, use inconsistent formulas, or lack a clear approval trail. This template gives you a standard field structure for the rate, base, exclusions, reconciliation, and attestations, which makes reviews faster and more repeatable. It is especially useful when multiple people touch the same award portfolio.
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...
-
Compare 9 top shift scheduling platforms for 2026—features, pricing, and workforce fit for frontline, retail, healthcare, and enterprise teams.
-
Discover 4 proven keys to successful project management and team collaboration — from transparent goal-setting to real-time communication and workflow...
-
Boost team collaboration with modern tools that improve visibility, accountability, and communication for stronger project outcomes.
-
Compare the best employee apps of 2026—MangoApps, Blink, WorkJam, Flip, and more—to find the right fit for your frontline workforce.
Ready to use this template?
Get started with MangoApps and use Indirect Cost Rate Allocation Worksheet with your team — pricing built for small business.
