Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: LFA_EFR Review_3B

LFA review of Enhanced Financial Reporting template
LFA Organization / Responsible office:
GENERAL GRANT INFORMATION
Country:
Disease:
Grant Number:
Principal Recipient:
Program Start Date:
Currency:
Section 3B: ENHANCED FINANCIAL REPORTING PERIOD
Current Period |  |  | Beginning Date: | 2009-12-01 00:00:00 | End Date: | 2010-12-31 00:00:00
Cumulative Period |  |  | Beginning Date: | 2009-12-01 00:00:00 | End Date: | 2010-12-31 00:00:00
1.  CHECKLIST
The following information provided by the Principal Recipient in its EFR has been checked. |  |  |  |  |  |  |  |  | Comments if any:
 | Yes | The template has been fully completed. |  |  |  |  |  |  | None
1
 | Yes | The total figures in Tables A, B and C are equal. |  |  |  |  |  |  | None
2
 | Yes | The reporting dates are correct for both current period and cumulative period. |  |  |  |  |  |  | None
3
 | No | The total budget figure is accurate based on existing approved budgets. |  |  |  |  |  |  | The cumulative budget in the grant agreement for the period under review is Eur 1,838,031. The PR has however used Eur 1,902,135 which is based on a revised budget that has not been approved by the GF yet.
4
 | No | The PR expenditure in Table C is consistent with PR expenditure for the same period as provided in the Progress Updates/Disbursements Request (PU/DR). |  |  |  |  |  |  | There is a variance of Eur 157,976 between the cumulative expenditure reported in the PUDR  of Eur 1,526,224 and the cumulative expenditure reported in the EFR of Eur 1,368,698
5
 | Yes | The total expenditure is supported by appropriate documentation ( PR expenditure reports, bank reconciliations, SR expenditure reports to PR etc.) or reasonable assumptions. |  |  |  |  |  |  | None
6
2.  COMPLETION OF THE TEMPLATE
Comments on the process, assumptions and supporting documentation used by the PR to complete the template. (If space is insufficient, please provide comments in an addendum)
Process of capturing expenditure in the EFR  The PR uses the Sun system to process financial transactions. It then extracts financial information into Microsoft (MS) excel which is used to prepare financial reports in the form requested by The Global Fund. To ensure that the financial information is complete and accurate, reconciliation is performed between Sun and MS excel.  The reporting currency in the PR's accounting system is [NAME] (GMD).
3. [NAME]
Comments on the explanations for variances provided by the PR (LFA can also provide comment directly on the EFR template completed by the PR)
We reviewed the expenditure reported in the EFR and compared it to the cumulative expenditure in the PUDR. We noted a variance of Eur 157,976.    We further traced the budget amounts reported in the EFR to the approved budget and noted a variance of Eur 64,104 (PR budget Eur 1,902,135 less approved budget of Eur 1,838,031). The PR's budget is based on the revised budget which has not been approved by the GF.  We recommend that the PR review the EFR and resolve these variances for our final review.
Signed on behalf of the LFA:
Name: |  |  | [NAME]
Title: |  |  | Director
Date and Place: |  |  | 21st March 2011/Accra