Disaster Cost Recovery & Grant Tracking Toolkit

Track disaster-recovery awards from cost review through reporting and closeout. Organize award budgets, reviewed costs, federal and local allocations, reimbursement submissions, cash receipts, supporting documents and deadlines.

What's included

• Blank Excel workbook: seven sheets—Overview, Awards, Costs, Requests, Cash, Documents and Tasks—with capacity for 200 records per register.
• Worked-example Excel workbook: a separate fictional example showing how transactions flow into the overview.
• Five-page editable Word guide: setup instructions, field definitions, reconciliation steps and an example walkthrough.
• Quick-start text file: file guide and getting-started steps.

Useful workbook features

• Reviewed-cost totals and federal/local allocations using your entered share rate.
• Award-level budget and cash summaries.
• Separate reimbursement-request and cash-receipt registers.
• Document references, owners and retention-review reminders.
• Task countdowns based on an editable reporting date.
• Dropdowns and checks for duplicate IDs, missing inputs and unmatched award references.

Who it's for

Emergency management, finance and program staff coordinating disaster-recovery awards and maintaining financial and documentation records.

How to use it

Practice with the worked example, then save a copy of the blank workbook. Register awards and documents, enter costs, record requests and receipts, and assign reporting tasks. Correct flagged entries and reconcile totals with your official records before reporting.

Choosing the right tracker

This toolkit covers award administration, costs, requests, cash, documents and tasks. For a narrower expense-documentation tool, compare the Cost Recovery / FEMA Reimbursement Documentation Tracker. For planning applications and deadlines before an award, see the Grant Funding Calendar & Planner.

Formats and requirements

Four downloadable files: two Excel workbooks (.xlsx), one Word guide (.docx) and one text file. Microsoft Excel and Word are recommended. No macros, subscription, live funding feed or automated agency connection is included. Other spreadsheet applications have not been tested. Digital product; no physical item is shipped.

The workbook uses your review decisions and entered allocation rates. It does not determine eligibility, track in-kind match, guarantee reimbursement or replace your accounting system. Review award-specific requirements. Formula totals have been checked with the fictional example; desktop Excel and purchase-to-download delivery testing remain outstanding.