Excel workbook previewAllowable Cost Checklist (2 CFR 200 Subpart E)
3 free downloads per account. Just your email and a 6-digit code.
About this template
An allowable cost checklist shows, item by item, how an organization decides whether a cost may be charged to a Federal award. Subpart E of 2 CFR 200 sets general allowability factors and then 57 sections on selected items of cost, from advertising to trustees. Auditors test charges against these sections in every Single Audit, and program officers ask for the same reasoning when they question a cost.
This workbook lists every section from 200.420 to 200.476 with its number, title, a plain summary of what the section says and its default treatment, all checked against the current eCFR text. A second sheet tests individual transactions against the factors in 200.403 and the prior approval list in 200.407, and a summary sheet counts the results by formula.
Who it is for
The grants accountant who must show an auditor or program officer how each type of cost charged to a Federal award was tested against 2 CFR 200.
What is inside
- 57 rows, one for each section from 200.420 to 200.476, in 7 groups
- Plain-language summary of each section and its default treatment, colour coded
- Status dropdown per row with a live compliance percentage
- Transaction test sheet: 8 tests per cost from 200.403 and 200.407, with 10 worked transactions and 20 blank rows
- Live result per transaction (Allowable, Question, Incomplete) and the amount questioned
- Summary sheet with counts per group and per default treatment, all by formula
- Freeze panes, filters and dropdowns on both working sheets, landscape print fit on all sheets
How to use it
Map your general ledger accounts to each section in column G, then mark the status of each row.
Files
- XLSXallowable-cost-checklist.xlsx21 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What makes a cost allowable under 2 CFR 200?
Under 200.403 a cost must be necessary, reasonable and allocable to the award, conform to the limits in Subpart E and the award, be treated consistently with other funds, follow generally accepted accounting principles, not be used as cost share on another Federal award, be adequately documented and fall in the budget period. The transaction sheet tests each of these.
Is a cost unallowable if Subpart E does not mention it?
No. Section 200.420 says the list of selected items is not complete and that leaving an item out does not make it allowable or unallowable. The cost is judged on the treatment of similar items and the principles in 200.402 to 200.411, and the terms of the specific Federal award govern where they differ.
Which costs need prior written approval?
Section 200.407 lists the cases, among them cost sharing, program income, budget and program revisions, fixed amount subawards, equipment and other capital expenditures, exchange rates, fines and penalties, fundraising, goods for personal use, insurance, organization costs, pre-award costs, rearrangement costs and certain travel. The Cost Test sheet asks for every transaction whether a required approval was obtained.




