APEX Financial Reporting 2.0 Template 09102024.xlsx
XLSX spreadsheet 193 KB Posted
- Attached to
- APEX Accelerator Program
- Opportunity number
- DOD2025APEXACCELERATOR
- Issued by
-
Department of Defense
About this file
This document appears to be a financial reporting template for an APEX Accelerator program awarded under a Department of Defense cooperative agreement. The template includes detailed spreadsheets for tracking personnel, fringe benefits, indirect costs, travel, other expenditures, program income, and in-kind contributions related to the grant.
The federal grant opportunity associated with this template is the APEX Accelerator Program, which provides funding for cooperative agreements to county governments, special district governments, nonprofits, city/township governments, and tribal governments. The program is funded under the Procurement Technical Assistance for Business Firms grant (CFDA 12.002) administered by the Department of Defense. The template indicates the agreement number is W56KGU-XX-2-XXXX and the total funded amount is xxx,xxx.xx. The reporting period covers fiscal quarters and includes detailed tracking of expenditures in distressed and non-distressed areas.
APEX Financial Reporting 2.0 Template 09102024
View the file
Other files
Show all 32
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
0_Cover Page
FINANCIAL
REPORT
| ORGANIZATION | APEX Accelerator | LEGEND | Cells shaded in white require your input. |
| AGREEMENT NUMBER | W56KGU-XX-2-XXXX | Cells shaded in gray automatically populate data and do not require your input. |
| AGREEMENT PERIOD | MM/DD/YYYY - MM/DD/YYYY |
| TOTAL FUNDED AMOUNT | xxx,xxx.xx |
| PROJECT QUARTER | Quarter No. X |
| REPORTING PERIOD | MM/DD/YYYY - MM/DD/YYYY |
| REPORTING DATE | MM/DD/YYYY |
| SUBMITTED BY | Name, Position |
F1_Personnel
| Agreement Number | W56KGU-XX-2-XXXX |
| Expenditure Category | Personnel |
| Voucher Number | Name | Position | Distressed Status (Drop-down menu) | FT or PT | ||||||
| (Drop-down menu) | Vacant (Drop-down menu) | Actual Expenditure ($) | Actual Hours for NAPEX Suppport (Board Duties Only) | |||||||
| Q1 | Q2 | Q3 | Q4 |
| Please validate that the data from all preceding rows are included in the formulas for the totals | |||||
| Total | 0.00 | 0.00 | 0.00 | 0.00 |
F2_Fringe & Indirect
| Agreement Number | W56KGU-XX-2-XXXX | Agreement Number | W56KGU-XX-2-XXXX |
| Expenditure Category | Fringe Benefits | Expenditure Category | Indirect Costs |
Voucher Number Distressed/ Non-distressed Area (Drop-down menu)
| Actual Expenditure | |||
| Q1 | Actual Expenditure | ||
| Q2 | Actual Expenditure | ||
| Q3 | Actual Expenditure | ||
| Q4 | Voucher Number | Distressed/ |
Non-distressed Area
| (Drop-down menu) | Actual Expenditure |
| Q1 | Actual Expenditure |
| Q2 | Actual Expenditure |
| Q3 | Actual Expenditure |
Q4
Total 0.00 0.00 0.00 0.00 Total 0.00 0.00 0.00 0.00
Please validate that the data from all preceding rows are included in the formulas for the totals. Please validate that data from all preceding rows are included in the formulas for the totals
F3_Travel
| Agreement Number | W56KGU-XX-2-XXXX |
| Expenditure Category | Travel |
Voucher Number Description Distressed/ Non-distressed Area
| (Drop-down menu) | Is this travel in support of NAPEX? | ||||
| (Yes / No) | Is this travel for NAPEX Conference attendance? | ||||
| (Yes / No) | Traveler | Destination | Travel Begins | Travel Ends | Actual Expenditure ($) |
| Q1 | Actual Expenditure ($) | ||||
| Q2 | Actual Expenditure ($) | ||||
| Q3 | Actual Expenditure ($) |
| Please validate that the data from all preceding rows are included in the formulas for the totals | |||||
| Total | 0.00 | 0.00 | 0.00 | 0.00 |
F4_Other Expenditure
| Agreement Number | W56KGU-XX-2-XXXX |
| Expenditure Category | Other Expenditure |
| Voucher Number | Category Budgeted | |
| (Drop-down menu) | Distressed/ |
Non-distressed Area
| (Drop-down menu) | Description | Actual Expenditure ($) |
| Q1 | Actual Expenditure ($) | |
| Q2 | Actual Expenditure ($) | |
| Q3 | Actual Expenditure ($) |
equipment supplies contractual other direct costs
| Please validate that data from all preceding rows are included in the formulas for the totals | |||||
| Total | 0.00 | 0.00 | 0.00 | 0.00 |
F5_Financial Summary
| Organization | APEX Accelerator |
| Agreement Number | W56KGU-XX-2-XXXX |
| Agreement Period | MM/DD/YYYY - MM/DD/YYYY |
| Reporting Period | MM/DD/YYYY - MM/DD/YYYY |
| Reporting Date | MM/DD/YYYY |
Total Funded Amount ($) xxx,xxx.xx
| Type of Expenditure | Notes | |||||||||||||||
| (If not applicable, N/A) | Awarded FYXX Budget** | Actual Expenditure (%) | Spending Variance ($) | Spending Rate (%) | ||||||||||||
| Non-Distressed | Distressed | Q1 Non-Distressed | Q1 Distressed | Q2 Non-Distressed | Q2 Distressed | Q3 Non-Distressed | Q3 Distressed | Q4 Non-Distressed | Q4 Distressed | Total Non-Distressed | Total Distressed | |||||
| Personnel | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Fringe Benefits | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Travel | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Equipment | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Supplies | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Contractual | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Other | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Indirect Costs | $ - 0 | $ - 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! | ||
| Total | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Quarter | Cumulative Actual Spend ($) | Cumulative Spending Variance ($) | Cumulative Spending Rate (%) | Projected Expenditure Budgeted ($) | Actual Quarterly Expenditure ($) | Quarterly Spending Variance ($) | Quarterly Spending Rate (%) |
| Q1 | 0.00 | 0.00 | ERROR:#VALUE! | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Q2 | 0.00 | 0.00 | ERROR:#VALUE! | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Q3 | 0.00 | 0.00 | ERROR:#VALUE! | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Q4 | 0.00 | 0.00 | ERROR:#VALUE! | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Total | N/A | N/A | N/A | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
** Awarded budget input should include any transfers performed IAW Section L of the Program Requirements found in the APEX Accelerator Award Specific Terms and Conditions.
Section L. Transfer of Funds among direct cost categories General Terms and Conditions FMS Article IV addresses prior approval requirements for the transfer of funds among direct cost categories (i.e., personnel, fringe benefits, travel, etc.) when the cumulative amount of such transfers exceeds or is expected to exceed 10 percent of the total budget. In the case of an award that includes a distressed and non-distressed area budget, this requirement applies to each of the two budgets individually.
F6 Program Income
| Agreement Number | W56KGU-XX-2-XXXX | |||
| Expenditure Category | Program Income | |||
| Date | Description Program Income Earned | Date | Program Income Expended | Balance of Program Income |
K1_In-Kind Ledger
| Agreement Number | W56KGU-XX-2-XXXX |
| Expenditure Category | Third-Party In-Kind |
| Donation | Source of Donation | Date Provided and Utilized | Approved Third Party In-Kind Contribution | Actual Quarterly Amount Realized | |||
| Q1 | Q2 | Q3 | Q4 |
Total 0.00 image1.png image2.png
File details come from the government source that posted it. Updated .