IATI Registry Demonstration and Country Pilot Overview Simon

IATI Registry Demonstration and Country Pilot Overview Simon Parrish IATI Technical Advisory Group, DIPR July 2010

Objectives 1. To raise awareness of the main concepts of the IATI architecture 2. To demonstrate that the proposal for how IATI will be implemented are practical and feasible 3. To demonstrate how IATI data can be made accessible 4. To highlight the successful practical tests of these proposals through the country pilots www. aidtransparency. net

Overview A. Demonstration of three main concepts: 1. What the registry will look like and how it will work 2. How donors publish data in IATI format and link to the registry 3. Some examples of how the data can be used B. An overview of the main finding of the country pilots www. aidtransparency. net

Donor Website Conversion IATI Registry Conversion 5. 6. Data from partner Exchange with AIMS To demonstrate how IATI country systems can data be used to and be published automatically update available via IATI AIMS registry 3. Automated donor publication and update. An Overview Registering data directly from WB & DFID website Users 4. Basic visualisation. AIMS To demonstrate how IATI data can be simply made accessible of the Registry Demonstration 8. Finally, an 7. Others in the example of community canmore advancedregistry 1. The 2. Donor data also provide data visualisations Overview of to the registry e. g. that publishing & registering. can be developed aiddata. org Uploading data in IATI functions and how it with more detailed XML or Excel format will work data

XML

Text File 1 Free. Text. doc Text File 2 Structured. Data. xml A project called is ‘health sector reform’ is being implemented in Kenya health sector reform Kenya

Donor Format Differ But can be converted to a common IATI format

IATI Registry 1. The registry Overview of functions and how it will work

The data can be accessed via The registry is a list of links to data. In this a link to the original data in case, a list of recently added data. IATI XML format Users can subscribes to feeds This will typically be a set of data from a The registry will also allow which will provide automatic The registry will provide a donor for a specific country users to download the data in notifications when new data is search facility to enable users Excel format available to find data sets e. g. all data The registry displays metadata about these related to Rwanda links: the source of data, the country and the date of registration

When you search, a list of results is Clicking on a line will take you to more displayed: details about that dataset This is all data available for Rwanda from all donors “Rwanda”

It will be possible to register data directly with the registry as a manual process …but we don’t anticipate this being the norm

Donor Website Conversion IATI Registry 2. Donor data publishing & registering Uploading data in IATI XML or Excel format

The link to UNDP data has been registered

Donor Website Conversion IATI Registry 3. Automated donor publication and update. Registering data directly from WB & DFID website

The registry can also link directly to data already being published on donor website This is the DFID projects database on their website……… They already provide this data as raw data and in an XML format. However, it is not in the IATI XML format…. .

We used this data for the country pilots, and built a tool to automatically translate the donor specific XML format to IATI XML

This link to the DFID data is dynamically accessing the DFID websites database, and converting it to IATI XML format. www. iaticonverter. org/DFID/rwanda This is done through no effort required from DFID (but they need a database with an API first)

IATI Registry Conversion Users 4. Basic visualisation. To demonstrate how IATI data can be simply made accessible

IATI Registry 5. Exchange with AIMS To demonstrate how IATI data be used to automatically update AIMS Conversion Users AIMS

Insert AIMS import slide here

IATI Registry 6. Data from partner country systems can be published and available via IATI registry Conversion Users AIMS

IATI Registry Conversion Users 7. Others in the community can also provide data to the community e. g. aiddata. org

IATI Registry Conversion Users 8. Finally, an example of more advanced visualisations that can be developed with more detailed data

Country Pilots Overview

Headlines • A successful proof of concept – Converting data from multiple donor systems it into the draft standard IATI format – automatic exchange of data between multiple donor and country systems – IATI could help reduce transaction costs & add significant value to the processes • Confirmation of previous analysis on the key challenges and needs of partner countries – more detailed, timely information on current and future aid flows – more systematic and comprehensive reporting processes for donors, NGOs and other providers of assistance www. aidtransparency. net

Findings – Partner Country Information Needs • A range of stakeholders within Government • Commonality around the basic requirements • AIMS – – – • Differences in emphasis IATI covers a majority of needs Phase 1 covers most needs and the data that changes regularly (e. g. disbursements) Line Ministries – – – More detailed spending breakdown Unit & administration costs Traceability www. aidtransparency. net

Budget Alignment • • Budget alignment is a key priority Beyond classifications – – • • Timeliness of information Expenditure and details of counterpart funding Details of forward spending plans More details about what the money is being spent on (e. g. consultancy, goods, travel) Budget classification alignment is happening in country (manual double coding) Budget working group involving PWYF, IBP (to add) – Considering alternatives to double coding www. aidtransparency. net

Finding (2) – Country Processes • • • NO IATI awareness amongst donor staff in country Access to central systems – definitive source Manual reporting – – – OR – – – • • • Donor keys data into their own management system. Donor prints report from their system. Donors enter in AIMS Donor keys data into a spreadsheet. Donor emails spreadsheet to ministry Ministry keys data into AIMS Variable compliance Time consuming for both parties Error prone www. aidtransparency. net

Findings (3) – Donor data • Six donors: World Bank; UNDP; UK; Spain; Netherlands; Global Fund • Incomplete coverage, but most of data required • Projects in donor and country systems are aligned • Minor definitional and compatibility issues • Consistent data held within donor and country system • Most IATI phase 1 data is available in pilot donor systems • Most donor systems do not have later phase data, but are currently reporting it manually www. aidtransparency. net

Conclusions Impact of IATI on country systems & processes • IATI (inc. Phase 1) has the potential to add significant value for both Government and donors – timeliness, accuracy & consistency, lower transaction costs • IATI could help address lack of effective systematic processes for regular and consistent reporting • IATI could provide a greater breadth of data, depending on scope of agreed standard www. aidtransparency. net

Concerns Constraints and Lessons • Manual reporting will still be necessary in short term • IATI alone is not enough – processes and systems need to adapt and there will be costs involved – many of the issues involved are political • Data compatibility and consistency issues mean change will not happen overnight • The details are important (dates, codes etc. ) www. aidtransparency. net

Recommendations • IATI phase 1 standard should include the information of key concern to partner countries • IATI needs to prioritise planned work to focus on budget alignment • Emphasis should be given phase 2 & 3 data elements • IATI should consider additional needs identified • Engage donor country offices in the IATI process • Build on the success of the pilots undertake ‘live’ pilots over a year period as part of IATI implementation www. aidtransparency. net

Thank You Simon Parrish DIPR simon@devinit. org www. aidtransparency. net