Grant Accounting Checklist
Quarterly grant accounting cycle for a nonprofit or municipal finance team — from award setup through monthly burn tracking, FFR/SF-425 reporting, Single Audit preparation, and grant closeout. Run this template per active grant, per quarter.
Grant Setup
-
Review the grant agreement and award letter
Read the agreement end-to-end. Capture the period of performance, allowable cost categories, matching/cost-share requirements, indirect cost treatment, drawdown method (reimbursement vs. advance), and reporting cadence (quarterly FFR vs. annual). Federal awards under 2 CFR 200 carry stricter procurement and time-and-effort rules than private foundation grants — flag the difference now.
Collects file -
Set up project codes in the GL
Create a class, location, or dimension in QuickBooks/Sage Intacct/NetSuite that segregates this grant's activity. Don't create a parallel chart of accounts — use existing GL accounts with a grant dimension so reports tie to the consolidated trial balance.
-
Load the approved budget by cost category
Mirror the grantor's budget categories exactly — personnel, fringe, travel, supplies, contractual, indirect. Variances must be reportable in the grantor's format. Many federal awards require prior approval for line-item shifts above 10% of the total award.
-
Confirm the federal vs non-federal award type
Federal awards (direct or pass-through) trigger 2 CFR 200 Uniform Guidance — procurement standards, indirect cost rate negotiation, and Single Audit eligibility. Pass-through funds keep their federal character; check the CFDA/Assistance Listing number on the subaward to be sure.
Collects list
Financial Management
-
Collect time and effort certifications
Under 2 CFR 200.430, payroll charged to a federal award must be supported by records reflecting actual work performed — not budget estimates. Collect signed time-and-effort sheets (or after-the-fact certifications for 100%-grant employees) for every staff member whose payroll hits this grant.
Collects file -
Code grant expenditures to the project
Review the AP register and credit-card feed for the period. Tag each charge with the grant dimension and verify documentation: vendor invoice, approval, and connection to the grant scope. Unallowable costs under 2 CFR 200 Subpart E (alcohol, lobbying, entertainment, fundraising) must be coded out of the grant even when they appear on a mixed invoice.
-
Apply the negotiated indirect cost rate
Use the organization's NICRA (negotiated indirect cost rate agreement) or the 10% de minimis rate if no NICRA exists. Apply to the modified total direct cost base — exclude pass-through subawards over $25K, equipment, and participant support costs from the base.
-
Review burn rate against budget
Run a budget-to-actual by category for the quarter and life-to-date. Flag any line projected to overrun by quarter end and any line under-spent below 50% at the midpoint — under-spend triggers grantor questions and clawback risk at closeout.
Revenue Recognition
-
Apply the ASC 958-605 conditional analysis
Most cost-reimbursement grants are conditional contributions under ASC 958-605 — recognize revenue only as the barrier (qualifying expenditure) is overcome. Unconditional grants with donor-imposed restrictions hit revenue at award and sit in net assets with restrictions until released.
-
Reconcile grant receivable and deferred revenue
Tie the GL receivable to expenditures earned but not yet drawn. Tie deferred revenue to advances received but not yet expended. The two should never coexist on the same grant in the same period — that's a sign coding is wrong.
-
Follow up on delayed drawdowns
For PMS/ASAP federal drawdowns, reimbursement should hit the bank within 3-5 business days of submission. For state and foundation grants, 30+ days is typical. Anything past 60 days warrants a call to the program officer — and a working-capital conversation with the ED if grant cash is a material funding source.
Reporting and Compliance
-
Prepare the SF-425 or grantor financial report
Federal awards use the SF-425 Federal Financial Report. State and foundation grantors use their own templates. Tie every line — federal share of outlays, recipient share, program income, indirect expense — to the GL with a workpaper. Submitted numbers are part of the audit trail for the next 3-7 years.
-
Sync the financial report to the program narrative
The program officer's progress narrative and the FFR get reviewed together. If the program report claims 80% of milestones are complete but you've spent 30% of the budget, the grantor will ask why. Reconcile both reports with the program lead before submission.
-
Verify cost allowability under 2 CFR 200
Sample 10-15% of the period's expenditures. Test against the four-part test: necessary and reasonable, allocable, conforms to limitations, consistent treatment. Document the test in a workpaper — auditors will replicate it.
Audit Preparation
-
Compile the grant workpaper binder
Pull the executed agreement, all amendments, FFRs filed to date, GL detail by project code, payroll allocation worksheets, indirect cost calculations, and procurement files for any contracts above the simplified acquisition threshold. Suralink or ShareFile keeps the auditors out of your inbox.
-
Determine Single Audit applicability
Under 2 CFR 200 Subpart F, an organization that expends $750,000 or more in federal awards in a fiscal year must have a Single Audit. Sum federal expenditures across all awards (direct + pass-through), not just this grant. Crossing the threshold mid-year is a common gotcha for organizations new to federal funding.
Collects list -
Prepare the SEFA schedule
The Schedule of Expenditures of Federal Awards lists each federal program by Assistance Listing (CFDA) number, pass-through identifier, and expenditures for the year. Tie totals to the GL and to the FFRs filed. Auditors test SEFA accuracy as a major-program selection input.
-
Walk auditors through grant transactions
Schedule a fieldwork kickoff. Walk the auditor through the grant lifecycle: how expenditures are coded, who approves, how time-and-effort is captured, how drawdowns are reconciled. A clear walkthrough cuts substantive testing time and reduces management-letter comments.
Closeout Procedures
-
Submit the final expenditure report
Federal awards: final SF-425 due within 120 days of period-of-performance end (2 CFR 200.344). Late closeout puts the organization on the federal high-risk list and can delay future awards. File even if expenditures equal zero.
Collects file -
Reconcile and zero out grant balances
Refund any unspent advance to the grantor. Confirm the receivable equals the final draw remaining. Release any net-asset restrictions in QBO/Intacct so the balance sheet reflects grant closure. Leftover balances on the GL after closeout are a recurring audit finding.
-
Archive grant records for the retention period
Federal: retain for 3 years after final FFR submission (2 CFR 200.334). Litigation, audit, or claim extends the period until resolved. Move the SmartVault/ShareFile folder to the archive structure with a retention-end date in the folder name so it's not deleted prematurely.
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Grant Accounting Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.