APEX Financial Reporting 2.0 Template 09102024.xlsx
XLSX spreadsheet 193 KB Posted
- Opportunity number
- DOD2025APEXACCELERATORMAIN
- Issued by
-
Department of Defense
About this file
This is a financial reporting Excel template for APEX Accelerator Program cooperative agreement recipients to track and report quarterly expenditures. The template contains multiple worksheets for detailed tracking of personnel costs, fringe benefits, indirect costs, travel expenses, and other expenditures, with separate tracking for distressed and non-distressed areas. The template is designed for cooperative agreements under number format W56KGU-XX-2-XXXX.
The template corresponds to a Department of Defense grant opportunity (DOD2025APEXACCELERATORMAIN) for the APEX Accelerator Program in Massachusetts and Indiana, which falls under CFDA 12.002 - Procurement Technical Assistance For Business Firms. The funding instrument is a cooperative agreement available to tribal governments, nonprofits, special district governments, county governments, and city/township governments. The program aims to strengthen the U.S. supply chain and support diverse businesses through procurement assistance and fostering participation in government contracts.
EX Financial Reporting 2.0 Template 09102024
View the file
Other files
Show all 11
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 .