Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: LFA_Cash Reconciliation_5A

[NAME] On-going Progress Review and Disbursement Recommendation
DISBURSEMENT REQUEST PERIOD
Grant number:
Disbursement Request  - Disbursement Period: |  |  | Cycle: |  | Number:
Disbursement Request  - Period Covered: |  |  | Beginning Date: |  | End Date:
Disbursement Request  - Number:
Section 5:  [NAME]-verified Cash Reconciliation & Disbursement Recommendation
[NAME] CASH RECONCILIATION FOR PERIOD COVERED BY PROGRESS UPDATE
 |  |  |  |  | PR-reported amounts | LFA-verified amounts | LFA Comments on verified amounts (if they are different from those reported by the PR) and PR's explanation of reconciliation adjustments (line 9)
1.  Cash Balance: Beginning of period covered by Progress Update (line 10 from Cash Reconciliation section of the period covered by the previous Progress Update): |  |  |  |  |  | 7588
Add: |  |  |  |  |  | 984665
 | 2.  Cash received by the PR from the Global Fund during the period covered by this progress update: (1)
 | 3.  Cash disbursed to third parties by the Global Fund on behalf of the PR during the period covered by this progress update: (1) |  |  |  |  | 64081
 | 4.  Interest received on bank account |  |  |  |  | 0
 | 5.  Revenue from income-generating activities (if applicable) |  |  |  |  | 0
 | 6.  Other income, if applicable (e.g. income from disposal of fixed assets, tax refunds) |  |  |  |  | 0
Less: | 7.  Total PR cash outflow during period covered by Progress Update (value entered in Section 3A "Total cash outflow"): |  |  |  |  | 535804 | Our initial review of the PUDR resulted in a net adjustment of Eur64,235 which has been taken up by the PR and adjusted in the current PUDR:  The total reconciliation is made up of:   The total expenditure reported by the PR in the initial PUDR  - Eur 471,569  Add : Exchange losses computed by LFA using Central Bank of Gambia average monthly rates to translate total Q4 expenditure in [NAME] 280 Add : Direct payments by the GF to VPP, but not included in PUDR expenditure  - Eur 64,081   Add:  Bank charges not included in PUDR expenditure - Eur 125  Less : Long outstanding reconciling items in Dalasi account bank reconciliation - Eur 251
 | 8.  Net exchange rate gains/losses (gains should be shown with a minus sign; losses should be shown with a plus sign) |  |  |  |  | 217 | This represents exchange loss on translation of cash balance denominated in the Gambian Dalasi as at 31 December 2010.   Cash balances  [NAME] account    - Eur 493,628 Dalasi account - Eur   39, 194
 | 9. Reconciliation adjustments (gains should be shown with a minus sign; losses should be shown with a plus sign) |  |  |  |  | -12509 | The cash balance was  Eur 7,588.11 as at the end of September 2010.   This should have been adjusted by Eur 12,509 to arrive at Eur 20,097.08.  The adjustment was due to an exchange gain of  Eur 5,196, which the PR omitted and an amount of Eur 7,313 which was an error in the expenditure for period 2.
10.  Cash Balance: End of period covered by Progress Update: |  |  |  |  |  |  | The balance per the LFA represents the cash balance as at 31 December 2010 as follows;  Cash balance on Euro account -  493,628 Cash balance on Dalasi account -  39,194 (Dalasi 1,468,200 translated at D 37.46 : Eur 1)