PEPFAR Program Expenditures

PEPFAR Program Expenditures

ER-Template (Data Collection Instrument) DS-4213 03-10-2020.xlsx

PEPFAR Program Expenditures

OMB: 1405-0208

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
Metadata and Error Checks
Expenditure Template


Sheet 1: Instructions

DS-4213 President's Emergency Plan for AIDS Relief (PEPFAR) Program Expenditures
OMB Control No. 1405-0208 OMB approval expires 03/31/2020 Burden-24 hours
This template should be used for reporting Fiscal Year 2019 (October 1, 2018 - September 30, 2019) PEPFAR program expenditures by Implementing Partners; a separate template should be completed for each separate Operating Unit (OU) and Award.
Please read through expenditure reporting guidance, instructions on this template prior to completing this form. All guidance and instructions can be found at https://datim.zendesk.com.
Public reporting burden for this collection of information is estimated to average 24 hours per response, including time required for searching existing data sources, gathering the necessary documentation, providing the information and/or documents required, and reviewing the final collection. You do not have to supply this information unless this collection displays a currently valid OMB control number. If you have comments on the accuracy of this burden estimate and/or recommendations for reducing it, please send them to: Office of the US Global AIDS Coordinator (S/GAC) U.S. Department of State, 1800 G Street, NW, 10th Floor, Washington, DC 20006.

Sheet 2: Metadata and Error Checks


METADATA
` Federal Agency
Recipient Organization (Partner Name)


Mechanism ID
Award Number


Mechanism Name
OU


Prime DUNS Number
Data Set Expenditure

Reporting Period FY19




























ERROR CHECKS

Does the Prime DUNS number fail to meet data entry criteria? (Exactly nine digits and cannot be 000000000)







Yes, the prime DUNS number fails to satisfy the data entry criteria. Use leading zeroes if necessary.







































Do program management costs still need to be entered?


Yes, program management costs still need to be entered in Intervention 1.







































Have interventions been defined with incomplete program area and beneficiary information? No, all interventions have been fully defined.







































If yes, which intervention(s) have not been fully defined? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
















































Have very unlikely combinations of program area and beneficiaries been selected?







No, there are not any very unlikely combinations that have been selected.







































If yes, in which intervention(s) do very unlikely combinations exist ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
















































Are there any subrecipient rows that have zero expenditures?






0 No, every subrecipient has been assigned a non-zero expenditure.







































Are there any subrecipient rows that have expenditures but are missing a DUNS number?






0 No, every subrecipient row with expenditures contains a DUNS number.















Or are missing a subrecipient name?





0 No, every subrecipient row with expenditures contains a name.















Or are missing both the subrecipient name and the DUNS number?





0 No, there are not any subrecipient rows with expenditures that are missing both a name and a DUNS number.















Or used 00000000 as a DUNS number?





0 No, every subrecipient row with expenditures contains a DUNS number.























Note: Every subrecipient must have a valid name and DUNS number. TBD subrecipients are not permitted.























Each DUNS number must be exactly 9 digits, including leading zeroes.






































Is there any data entered outside of the subrecipient rows that were specified?







No, there is no data that was entered outside of the specified subrecipient rows.















Subrecipient rows created:
0





















First row that should be empty:
32





















Cells expected to be blank:
2200





















Count of blank cells after last row:
2200





















Non-blank cells after last row:
0













































Sheet 3: Expenditure Template




Program
Management
Categorization of Intervention 2 Categorization of Intervention 3 Categorization of Intervention 4 Categorization of Intervention 5 Categorization of Intervention 6 Categorization of Intervention 7 Categorization of Intervention 8 Categorization of Intervention 9 Categorization of Intervention 10 Categorization of Intervention 11 Categorization of Intervention 12 Categorization of Intervention 13 Categorization of Intervention 14 Categorization of Intervention 15 Categorization of Intervention 16 Categorization of Intervention 17 Categorization of Intervention 18 Categorization of Intervention 19 Categorization of Intervention 20


Intervention Name (optional)

Program Management





















Program Area

Program Management





















Beneficiary

Non-Targeted Pop: Not disaggregated




















Cost Category

Program management expenditures Expenditures against Intervention 2 Expenditures against Intervention 3 Expenditures against Intervention 4 Expenditures against Intervention 5 Expenditures against Intervention 6 Expenditures against Intervention 7 Expenditures against Intervention 8 Expenditures against Intervention 9 Expenditures against Intervention 10 Expenditures against Intervention 11 Expenditures against Intervention 12 Expenditures against Intervention 13 Expenditures against Intervention 14 Expenditures against Intervention 15 Expenditures against Intervention 16 Expenditures against Intervention 17 Expenditures against Intervention 18 Expenditures against Intervention 19 Expenditures against Intervention 20 TOTAL % Total
Personnel: Salaries- Health Care Workers

NA


















$0 0%
Personnel: Salaries- Other Staff





















$0 0%
Fringe Benefits





















$0 0%
Travel: International Travel





















$0 0%
Travel: Domestic Travel





















$0 0%
Equipment: Health Equipment





















$0 0%
Equipment: Non-Health Equipment





















$0 0%
Supplies: Pharmaceutical

NA


















$0 0%
Supplies: Health- Non Pharmaceutical

NA


















$0 0%
Supplies: Other Supplies





















$0 0%
Contractual: Contracted Health Care Workers

NA


















$0 0%
Contractual: Contracted Interventions

NA


















$0 0%
Contractual: Other Contracts





















$0 0%
Construction





















$0 0%
Training





















$0 0%
Subrecipient Total

NA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0%
Other: Financial Support for Beneficiaries





















$0 0%
Other: Other





















$0 0%
Indirect Charges


NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA $0 0%
Total Expenditures per Intervention (Sum of Cost Categories)

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0%


























Number of Subrecipients (0-100)































































































































1

























2

























3

























4

























5

























6

























7

























8

























9

























10

























11

























12

























13

























14

























15

























16

























17

























18

























19

























20

























21

























22

























23

























24

























25

























26

























27

























28

























29

























30

























31

























32

























33

























34

























35

























36

























37

























38

























39

























40

























41

























42

























43

























44

























45

























46

























47

























48

























49

























50

























51

























52

























53

























54

























55

























56

























57

























58

























59

























60

























61

























62

























63

























64

























65

























66

























67

























68

























69

























70

























71

























72

























73

























74

























75

























76

























77

























78

























79

























80

























81

























82

























83

























84

























85

























86

























87

























88

























89

























90

























91

























92

























93

























94

























95

























96

























97

























98

























99

























100
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy