Index &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A INDEX CRP Financial Reporting Templates Ref Description Responsibility 2012 2013 Comments Budget and Financial Reports L101 CRP Cumulative Financial Summary Lead Center Yes Yes Simplified format - no longer at Theme level L106 CRP Annual Funding Summary Lead Center Yes Yes Small changes in format L111 CRP Annual Financial Summary Lead Center Yes Yes Small changes in format L121 CRP - Expenditure by Natural Classification Report Lead Center Yes Yes Small changes in format L131 CRP - Themes Report Lead Center Yes Yes New report - but note this information was previously incorporated in L101 Analytical Financial Reports L201 CRP - Bilateral Grants Report Lead Center Yes Yes No changes in format L211 CRP Partnerships Report Lead Center Yes Yes No changes in format Cash Flow Reports L401 Funding - Windows 1 and 2 Cash Flows Lead Center Yes Yes No changes in format L411 Funding - Window 2 Report Lead Center Yes Yes New report, requested by Donors, Paris meeting Total of Reports Required 9 9 Notes For 2012, CRP Lead Centers are required to submit 9 financial reports for each CRP. Most reports are for current year only. Exceptions are L101 and L411, which are multi-year (cumulative). All reports shown here are for individual CRP's. The Consortium Office will prepare consolidated CRP reports. Report L101 &"-,Bold"&12L102 Report Description L101 Name of Report CRP Cumuative Financial Summary Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Period 1 January 2011 - 31 December 2012 CRP Nr (a) Cumulative budget per annual financial plans. (b) Actual Expenses - Cumulative (c) Variance - Cumulative Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Africa Rice 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 Bioversity 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 CIAT 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 CIFOR 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 CIMMYT 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 CIP 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 ICARDA 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 ICRISAT 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 IFPRI 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 IITA 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 ILRI 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 IRRI 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 IWMI 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 World Agroforestry 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 World Fish 1,200 1,200 1,200 300 3,900 200 50 150 30 430 300 150 250 130 830 Totals for CRP 18,000 18,000 18,000 4,500 58,500 3,000 750 2,250 450 6,450 4,500 2,250 3,750 1,950 12,450 31% 31% 31% 8% 100% 5% 1% 4% 1% 11% 36% 18% 30% 16% 100% Notes All figures shown here are illustrative only, and are in USD 000's Section (a) is cumulative - includes financial plan of current year as well as those of prior years. Section (b) is cumulative - refers to all costs since inception, not just current year. Section (c) amounts are the differences between Sections (a) and (b). Report L106 &"-,Bold"&12L102 Report Description L106 Name of Report CRP Annual Funding Summary Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Period 1 January 2012 - 31 December 2012 CRP Nr PART 1 - Annual FINANCE PLAN (Totals for Windows 1 and 2 combined) Approved Level for Year - Initial Approval 100 Approved Level for Year - Final Amount 120 PART 2 - Funding Summary for Year CRP 2012 Actual Funding Window 1 Window 2 Window 3 Bilateral funding Total Funding W1 Donors 1,000 1,000 DFID 100 10 20 130 USAID 50 30 80 DGIS 20 20 20 60 WBGF 100 100 IBRD 50 60 110 SIDA 100 100 Totals for CRP 1,000 320 90 170 1,580 Notes All figures shown here are illustrative only, and are in USD 000's Amount shown for Window 1 donors is total, as these funds are co-mingled Amounts shown for Window 2 donors are as per Report L411. Amounts shown for Window 3 donors are as per Report L201 Amounts shown for Bilateral funding are as per Report L201 Report L111 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description L111 Name of Report CRP Annual Financial Summary Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Period 1 January 2012 - 31 December 2012 (a) CRP2012 Fin plan approved budget (b) CRP 2012 Expenditure (c) Variance this Year Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Africa Rice 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 Bioversity 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 CIAT 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 CIFOR 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 CIMMYT 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 CIP 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 ICARDA 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 ICRISAT 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 IFPRI 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 IITA 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 ILRI 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 IRRI 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 IWMI 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 World Agroforestry 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 World Fish 200 50 150 30 430 200 50 150 30 430 200 50 150 30 430 Totals for CRP 3000 750 2250 450 6450 3000 750 2250 450 6450 3000 750 2250 450 6450 47% 12% 35% 7% 100% 47% 12% 35% 7% 100% 47% 12% 35% 7% 100% Notes All figures are for current year. Amounts shown here are illustrative only, and are in USD 000's Section (a) amounts are as per the latest financing plan Section (b) amounts are for actual expenses in current year. Section (c) amounts are the differences between Sections (a) and (b). Report L121 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description L121 Name of Report CRP Financial Report - Expenditure by natural classification (by Center) Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Period 1 January 2011 - 31 December 2012 Annual Budget Actual Expenses - This Year Unspent Budget Windows 1 and 2 Funds Window 3 Bilateral funding Center Funds Total Windows 1 and 2 Funds Window 3 Bilateral funding Center Funds Total Windows 1 and 2 Funds Window 3 Bilateral funding Center Funds Total Total CRP Personnel 1000 300 600 400 2300 1400 500 1500 1500 4900 400 200 900 1100 2600 Collaborator Costs - CGIAR Centers 200 100 100 400 400 300 300 1000 200 200 200 0 600 Collaborator Costs - Partners 500 200 400 1100 800 300 400 1500 300 100 0 0 400 Supplies and Services 600 200 700 1500 700 400 900 2000 100 200 200 0 500 Operational Travel 200 100 300 600 300 300 300 0 900 100 200 0 0 300 Depreciation 400 100 500 500 200 200 900 100 200 100 0 400 Sub-total of Direct Costs 2900 900 2200 400 6400 4100 2000 3600 1500 11200 1200 1100 1400 1100 4800 Indirect Costs 600 170 410 110 1290 820 490 430 430 2170 220 320 20 320 880 Total - all Costs 3500 1070 2610 510 7690 4920 2490 4030 1930 13370 1420 1420 1420 1420 5680 Amounts for each participating center below: Center 1 Personnel 200 100 150 50 500 210 110 160 60 540 10 10 10 10 40 Collaborator Costs - CGIAR Centers 20 0 10 30 30 10 20 10 70 10 10 10 10 40 Collaborator Costs - Partners 50 30 40 120 60 40 50 10 160 10 10 10 10 40 Supplies and Services 40 20 30 90 50 30 40 10 130 10 10 10 10 40 Operational Travel 70 40 60 170 70 40 60 0 170 0 0 0 0 0 Depreciation 20 10 10 40 30 20 20 10 80 10 10 10 10 40 Sub-total of Direct Costs 400 200 300 50 950 450 250 350 100 1150 50 50 50 50 200 Indirect Costs 80 40 60 10 190 90 50 70 20 230 10 10 10 10 40 Total - all Costs 480 240 360 60 1140 540 300 420 120 1380 60 60 60 60 240 Center 2 Personnel 180 80 120 50 430 190 90 130 60 470 10 10 10 10 40 Collaborator Costs - CGIAR Centers 20 10 30 60 30 20 40 10 100 10 10 10 10 40 Collaborator Costs - Partners 30 10 40 80 40 20 50 10 120 10 10 10 10 40 Supplies and Services 60 40 30 130 70 50 40 10 170 10 10 10 10 40 Operational Travel 40 10 40 90 40 10 40 0 90 0 0 0 0 0 Depreciation 50 10 60 60 20 10 10 100 10 10 10 10 40 Sub-total of Direct Costs 380 160 260 50 850 430 210 310 100 1050 50 50 50 50 200 Indirect Costs 40 20 40 10 110 50 30 50 20 150 10 10 10 10 40 Total - all Costs 420 180 300 60 960 480 240 360 120 1200 60 60 60 60 240 Center 3, 4, etc to be added Notes All figures shown here are illustrative only, and are in USD 000's Totals within this report must agree with amounts reported in L111. Report L131 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description L131 Name of Report CRP Themes Report (by Center, and Funding Source) Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Period 1 January 2012 - 31 December 2012 Annual Budget Actual Expenses this Year Unspent Budget Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding Windows 1 & 2 Window 3 Bilateral funding Center funds Total Funding CRP Report - by Themes Theme 1 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 Theme 2 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 Theme 3 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 Theme 4 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 Themes 5, 6, 7, etc 1700 470 1410 270 3850 13200 15600 13800 3300 45900 1700 470 1410 270 3850 Gender Strategies 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 CRP Management/Coordination 300 100 200 40 640 800 400 700 200 2100 300 100 200 40 640 Totals for CRP 3500 1070 2610 510 7690 18000 18000 18000 4500 58500 3500 1070 2610 510 7690 Amounts for each participating center below: Center 1 Theme 1 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 Theme 2 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 Theme 3 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 Theme 4 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 Gender Strategies 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 CRP Management/Coordination 80 40 60 10 190 200 200 200 50 650 80 40 60 10 190 Total – all Costs 480 240 360 60 1140 1200 1200 1200 300 3900 480 240 360 60 1140 Center 2 Theme 1 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 Theme 2 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 Theme 3 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 Theme 4 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 Gender Strategies 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 CRP Management/Coordination 70 30 50 10 160 200 200 200 50 650 70 30 50 10 160 Total – all Costs 420 180 300 60 960 1200 1200 1200 300 3900 420 180 300 60 960 Center 3, 4, etc to be added Notes All figures shown here are illustrative only, and are in USD 000's Centers 1 and 2 only are shown, for illustration. Where the template shows "Theme 1, Theme 2, etc", please enter the name of the CRP theme. The 2 Cross-cutting areas (CRP Management and Gender Strategies) should be reported in the same way as Themes. Totals within this report must agree with amounts reported in L111. Report L201 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description Name of Report CRP Financial Report - Bilateral Grants (by Center) Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months CRP Nr Period 1 January 2012 - 31 December 2012 Expenditure Annual Budget Actual Expenses this Year Variance Totals for CRP Window 3 CIDA 500 1000 500 AUSAID 570 1490 920 Sub-total 1070 2490 1420 Bilateral CIDA 500 700 200 USAID 500 700 200 DGIS 500 700 200 WBGF 500 800 300 IBRD 500 800 300 SIDA 110 330 220 Sub-total 2610 4030 1420 Totals for CRP 3680 6520 2840 Bilateral Grants for each participating center below: Center 1 (Africa Rice) Window 3 CIDA 200 240 40 AUSAID 40 60 20 Sub-total 240 300 60 Bilateral DFID 50 60 10 USAID 50 60 10 DGIS 90 100 10 WBGF 100 110 10 IBRD 50 60 10 SIDA 20 30 10 Sub-total 360 420 60 Totals for CRP 600 720 120 Center 2 (Bioversity) Window 3 CIDA 80 110 30 AUSAID 100 130 30 Sub-total 180 240 60 Bilateral AUSAID 50 60 10 USAID 50 60 10 DGIS 50 60 10 WBGF 50 60 10 IBRD 50 60 10 SIDA 50 60 10 Sub-total 300 360 60 Totals for CRP 480 600 120 Center 3, 4, etc to be added Notes All figures shown here are illustrative only, and are in USD 000's Donors shown are illustrative only. All donors of material amounts should be reported. Note that an individual donor may make grants through Window 3 and bilaterally. Totals within this report must agree with amounts reported in L111. Report L211 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description Name of Report CRP Partnerships Report Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Annual Budget Actual Expenses - This Year Unspent Budget Institute Country Windows 1 and 2 Window 3 Bilateral funding Center Funds Total Windows 1 and 2 Window 3 Bilateral funding Center Funds Total Windows 1 and 2 Window 3 Bilateral funding Center Funds Total Africa Rice NARS Uganda 20 5 25 30 7 37 10 0 2 0 12 NARS Sri Lanka 10 10 20 20 10 0 0 0 10 NARS Peru 10 10 20 12 12 24 0 2 2 0 4 NARS Egypt 10 10 12 12 0 0 2 0 2 Sub-total for center 30 10 25 0 65 50 12 31 0 93 20 2 6 0 28 Bioversity NARS Uganda 20 5 25 30 7 37 10 0 2 0 12 NARS Sri Lanka 10 10 20 20 10 0 0 0 10 NARS Peru 10 10 20 12 12 24 0 2 2 0 4 NARS Egypt 10 10 12 12 0 0 2 0 2 Sub-total for center 30 10 25 0 65 50 12 31 0 93 20 2 6 0 28 CIAT CIFOR CIMMYT CIP ICARDA ICRISAT IFPRI IITA ILRI IRRI IWMI World Agroforestry World Fish Totals for CRP 500 200 400 1100 800 300 400 1500 800 300 400 1500 Notes All figures shown here are illustrative only, and are in USD 000's Amounts reported are for actual expenditure, so unliquidated advances not included. Institutes should be clearly identifiable by name and/or acronym, plus country. Totals within this report must agree with amounts reported in L121 "Collaborator Costs - Partners". Report L401 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description Name of Report CRP Funding Statement, Windows 1 and 2 Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 3 months PART 1 - REPORT OF LEAD CENTER (CIAT used as example) Opening Balance - 1 January 0 W1 Receipts from Consortium Office (actual dates) 15-Mar-12 100 Total Receipts 100 W2 Receipts from Consortium Office (actual dates) 15-Mar-12 9-Sep-12 200 Total Receipts 200 Transfers to CG Partners Africa Rice -10 Bioversity -10 CIAT CIFOR -10 CIMMYT -10 CIP -10 ICARDA -10 ICRISAT -10 IFPRI -10 IITA -10 ILRI -10 IRRI -10 IWMI -10 World Agroforestry -10 World Fish -10 Total Disbursments -140 Expenditure by Lead Center (CIAT) -30 Unliquidated Advances to CIAT Partners -20 Funds held - end of Period 110 PART 2 - REPORT OF CGIAR CENTERS Funds held - start of Period Transfers from Lead Center Expenditure Unliquidated Advances to Partners Funds held - end of Period Africa Rice 5 10 -6 -3 6 Bioversity -5 10 -6 -1 CIAT CIFOR 5 10 -6 9 CIMMYT -5 10 -6 -3 -4 CIP -5 10 -6 -1 ICARDA -5 10 -6 -1 ICRISAT -5 10 -6 -1 IFPRI -5 10 -6 -3 -4 IITA 5 10 -6 9 ILRI -5 10 -6 -1 IRRI 5 10 -6 -3 6 IWMI -5 10 -6 -1 World Agroforestry 5 10 -6 9 World Fish -5 10 -6 -3 -4 Totals -20 140 -84 -15 21 Notes All figures illustrative only (taking CIAT as Lead Center) Amounts should be reported in USD 000's Report is for each financial year. Quarterly Reports during year are on a cumulative basis. Report L411 &"-,Bold"&12CRP 2012 and 2013 Financial Reporting Templates &"-,Bold"&12&A Report Description Name of Report CRP Funding Statement, Window 2 Reporting Line Lead Center Report to Consortium Office Frequency/Period Every 6 months Date Donor Currency USD Year 1 - 2011 Receipts from Donors DFID 7-Jul-11 GBP 1,000 1,500 USAID 10-Oct-11 USD 500 500 2,000 Transfers to Lead Center (via CO) (if applicable) Other Disbursments CSP paid to Window 1 12-Dec-11 (40) Funds held by Trustee - end of Period 31-Dec-11 1,960 Year 2 - 2012 Receipts from Donors DGIS GBP 400 600 IBRD SIDA USD 500 500 1,100 Transfers to Lead Center (via CO) Transfer 1 15-Mar-12 (200) Transfer 2 6-Jun-12 (1,500) Transfer 3 12-Dec-12 (1,338) Other Disbursments CSP paid to Window 1 10-Dec-12 (22) Funds held by Trustee - end of Period 31-Dec-12 - 0 Notes Amounts should be reported in USD 000's This reports is on a cumulative basis (prior periods also shown) Sheet1 Sheet2 Names CRP 1.1 CRP on Dryland Systems CRP 1.2 CRP on Humid Tropics CRP 1.3 CRP on Aquatic Agricultural Systems (AAS) CRP 2 CRP on Policies, Institutions and Markets CRP 3.1 CRP on Wheat CRP 3.2 CRP on Maize CRP 3.3 GRiSP: the Global Rice Science Partnership CRP 3.4 CRP on Roots, Tubers and Bananas (RTB) CRP 3.5 CRP on Grain Legumes CRP 3.6 CRP on Dryland Cereals CRP 3.7 CRP on Livestock and Fish CRP 4 CRP on Agriculture for Nutrition & Health CRP 5 CRP on Water, Land and Ecosystems CRP 6 CRP on Trees and Agroforestry CRP 7 CRP on Climate Change, Agriculture and Food Security (CCAFS) CRP for Genebanks 1 Africa Rice 2 Bioversity 3 CIAT 4 CIFOR 5 CIMMYT 6 CIP 7 ICARDA 8 ICRISAT 9 IFPRI 10 IITA 11 ILRI 12 IRRI 13 IWMI 14 World Agroforestry 15 World Fish