Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: EFR HIV AIDS Financial Data_3B

SECTION 3B: HIV/AIDS FINANCIAL REPORTING FORM
Country |  |  |  |  | PLEASE REFER TO THE "GUIDANCE FOR COMPLETION OF THE ENHANCED FINANCIAL REPORTING TEMPLATE" DOCUMENT TO ASSIST YOU IN COMPLETING THE TEMPLATE
Grant No.
PR |  |  |  |  | TO BE COMPLETED ONLY ONCE A YEAR EXCEPT AT MONTH 18 FOR PURPOSES OF PHASE 2 REVIEW
Currency |  | Please Select …
 |  |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  | Current Reporting Period | Start Date: |  |  | Cumulative Reporting Period | Start Date:
 |  |  |  |  | End Date: |  |  |  | End Date:
 |  |  |  |  |  |  | The end date for the current reporting period and cumulative reporting period must be the same
 |  |  |  | The "TOTAL" rows in Table A, B and C will have a RED background if the amounts in each table do not agree. If the Totals for each Table agrees, these rows will have a YELLOW background.
A- BREAKDOWN* BY  EXPENDITURE CATEGORY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period |  |  |  |  |  |  |  |  | Budget for Reporting Period | Actual Cash Outflow for Reporting Period | [NAME] | Reason for [NAME] |  | Cumulative Budget through period of Progress Update | Cumulative Actual Cash Outflow through period of Progress Update | [NAME] | Reason for [NAME]
# | Category |  |  | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME] |  |  |  | 1. Total PR cash outflow vs. budget
1 | Human Resources |  |  |  |  |  |  |  |  |  |  |  |  |  | 1a. PR's total expenditures
2 | Technical Assistance |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b. Disbursements to sub-recipients
3 | Training
4 | Health Products and Health Equipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget for Reporting Period* | Actual Cash Outflow for Reporting Period | [NAME] | Reason for [NAME] |  | Cumulative Budget through period of Progress Update | Cumulative Actual Cash Outflow through period of Progress Update | [NAME] | Reason for [NAME]
5 | Medicines and Pharmaceutical Products |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Total pharmaceutical & health product expenditures vs. budget
6 | Procurement and Supply Management Costs |  |  |  |  |  |  |  |  |  |  |  |  |  | 2a.  [NAME] and pharmaceutical products
7 | Infrastructure and Other Equipment |  |  |  |  |  |  |  |  |  |  |  |  |  | 2b.  Health products and health equipment
8 | Communication Materials
9 | Monitoring & Evaluation
10 | Living Support to Clients/Target Populations
11 | Planning and Administration
12 | Overheads
13 | Other
 |  |  | TOTAL
B- BREAKDOWN* BY PROGRAM ACTIVITY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period
# | Macro-category | Objectives | Service Delivery Area | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME]
 | Please Select… |  | Please Select…
 | Please Select… |  | Please Select…
 | Please Select… |  | Please Select…
 | Please Select… |  | Please Select…
 | Please Select… |  | Please Select…
TOTAL
To add additional rows, right click the row number (Row 39 in a blank template) to the left of the row above the row for TOTAL and select copy, then over the same number, right click again and select Insert Copied Cells. WARNING: Inserting Rows without copying a row as described above will cause the formula in the variance column to become invalid and will mean the overall information will be inaccurate.
C- BREAKDOWN* BY IMPLEMENTING ENTITY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period
# | PR/SR | Name | Type of Implementing Entity | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME]
 | Please Select … |  | Please Select…
 | Please Select … |  | Please Select…
 | Please Select … |  | Please Select…
 | Please Select … |  | Please Select…
 | Please Select … |  | Please Select…
 |  |  | TOTAL
To add additional rows, right click the row number (Row 51 in a blank template) to the left of the row above the row for TOTAL and select copy, then over the same number, right click again and select Insert Copied Cells. WARNING: Inserting Rows without copying a row as described above will cause the formula in the variance column to become invalid and will mean the overall information will be inaccurate.
* The sum of all three breakdowns should be equal (A- [NAME]-item, B- Program Activity, C- [NAME]).
** For the purposes of this report, the SDA Program management and administration should be included in the Supportive Environment Macro Category.
D- ADDITIONAL INFORMATION
Please disclose any relevant information concerning the information in the above tables. Refer to the Guidelines for Completing the Template if required.
E- DISBURSEMENTS BREAKDOWN BY IMPLEMENTING ENTITY |  |  |  | Cumulative Reporting Period
# | Name | Type of Implementing Entity | Cumulative Disbursements | Comments
 |  | Please Select…
 |  | Please Select…
 |  | Please Select…
 |  | Please Select…
 |  | Please Select…
 |  | TOTAL