=IF(C4-F1<0, "Warning: Overspent", C4-F1)
A common mistake in Excel-based grant reporting is confusing the two formats. For example, a grantee might accidentally enter cash drawdowns into an FFR-1 cumulative cost column. This error misrepresents actual expenditures and can trigger a federal audit or suspension of payments.
This is the hallmark of an FFR-2. Create a table with these fields: ffr-1 and ffr-2 format in excel
Working with FFR-1 and FFR-2 formats in Excel requires some knowledge of Excel functions and formatting. Here are some steps to help you get started:
Use to restrict certain columns. For example, in FFR-2’s indirect cost section, restrict the "Rate Type" column to only: Provisional, Final, Fixed, Predetermined . This is the hallmark of an FFR-2
| Source | Amount | Deducted from? | Remaining | | :--- | :--- | :--- | :--- | | Sales | $5,000 | Total Outlays | =Previous - Amount |
The FFR-1 format is a 10-line summary. In Excel, you want to create a dynamic dashboard that feeds into a clean output table. For example, in FFR-2’s indirect cost section, restrict
The difference between a rejected FFR and an instantly accepted one is often . Whether you are using the FFR-1 format for a straightforward training grant or the FFR-2 format for a multimillion-dollar research cooperative agreement, your spreadsheet must be:
: Profit before tax, Depreciation, Increase in Capital, and Increase in Term Liabilities. Uses of Funds
: Required within 8 weeks of the end of each half-year. Excel Format Structure