Grant Drawdown and Expenditure Tracker
3 free downloads per account. Just your email and a 6-digit code.
About this template
A grant drawdown and expenditure tracker keeps three things in line on a federal award: what has been spent, what has been requested from the payment system, and what is left in each budget category. The funder asks for it at a monitoring visit, the auditor tests it in a single audit, and finance needs it to prepare the Federal Financial Report. Without it, drawdowns are hard to tie to costs and unspent balances show up only at closeout.
The workbook has an Award Setup sheet for the award terms and the approved budget, an Expenditures register, a Drawdowns register that sums the supporting costs for each request period, and a Budget vs Actual sheet that compares spending with the share of the period that has passed. The checks follow 2 CFR 200.302 and 200.305: identifying awards, comparing spending with budget, minimising time between receipt and disbursement, payment of reimbursement requests within 30 days and the USD 500 interest limit.
Who it is for
The grants accountant or finance manager who has to show the funder or the auditor what was spent, what was drawn and what is left on a federal award.
What is inside
- Award Setup sheet with 11 award inputs and the approved federal budget in 9 categories, with a check against the award total
- Expenditures register with 12 worked rows and 20 blank rows: period-of-performance test, request status and days not yet requested by formula
- Drawdowns register with 8 worked requests and 16 blank rows: supporting expenditures summed by date range, differences and days to receive funds
- Red flag on any request that took more than 30 days to pay and on any request that does not match its supporting costs
- Budget vs Actual sheet with spend, remaining balance, percent spent against percent of the period elapsed and a pace flag per category
- Cash and interest block: expended not yet received, unsupported request amounts, remaining award and interest above the USD 500 a year that may be kept
- Dropdowns, conditional formatting, frozen headers, filters and print fit on every register
- How to use sheet with the 2 CFR 200.305 sources behind every check
How to use it
Fill in the Award Setup sheet from your notice of award, then post each grant expenditure on the Expenditures sheet.
Files
- XLSXgrant-drawdown-and-expenditure-tracker.xlsx18 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
How quickly must a federal agency pay a reimbursement request?
Under 2 CFR 200.305(b)(3), when the reimbursement method is used, the federal agency or pass-through entity must make payment within 30 calendar days after it receives the payment request, unless it reasonably believes the request is improper. The tracker counts the days from request to receipt and flags any request that took longer.
Can we keep interest earned on federal advances?
Section 200.305(b)(12) lets a recipient or subrecipient keep up to USD 500 per year of interest earned on federal funds for administrative expenses. Any interest above that must be returned each year to the Payment Management System of the Department of Health and Human Services, whichever payment system paid the award.
What should a grant budget versus actual report compare?
Section 200.302(b)(5) requires a comparison of expenditures with budget amounts for each federal award. A useful report also shows the share of the period of performance that has passed, so a category that is far ahead of or behind plan is visible early enough to request a budget revision.




