Financial Spreadsheet 33138 | Financial Fm, Monthly Report

Partial file snippet.

Sheet 1: 1. Progress Report

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Water Services Trust Fund
		

		

		

		

		

		

		

		

		

		

		

		

		

		Sheet 1
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Monthly Field Monitor Report (FINANCIAL)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Project name: 
		

		

		Project No.: 
		

		

		Month:
		

		

		
	
		WSP:
		

		

		Town:
		

		

		Name of Field monitor:
		

		

		
	
		WSB:
		

		

		Project area:
		

		

		E / S / F (4) : 
		

		
	
		Commencement date:
		

		

		Original estimated completion date: 
		

		

		Estimated completion date:
		

		

		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A
		Project Progress in Month
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Use bullet points to summarise the main project activities and progress during the last month. Any significant matters arising that adversely affect the timing and/or successful completion of the project should be detailed in the next section. (Photographs should be attached /submitted illustrating progress of physical items, events held & other matters of interest.)
		
	
		

		
	
		

		
	
		B
		Issues Arising/In Progress 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Give detail of issues that potentially threaten the successful completion of the project or have a significant impact on the timing of completion. Indicate the cause of the problem, it’s likely impact and what compensating actions are proposed or have been taken. If the estimated completion date has changed in the month then there must be an entry in this section. (Attach a separate sheet if necessary.)
		
	
		

		
	
		

		
	
		*):  E = Engineering Field monitor;  S = Social Field Monitor; F = Finance Field Monitor
		

		

		

		

		

		

		

	
	
		Field Monitor's signature:
		

		Date: 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		Checked by:
		

		Signed: 
		

		Date:
		

		



Sheet 2: 2. Activities & Progress

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Water Services Trust Fund
		

		

		

		

		

		

		

		

		

		

		

		

		

		Sheet 2
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Monthly Field Monitor Report (Financial Field Monitor)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Project name: 
		

		

		Project No.: 
		

		

		Month:
		

		

		
	
		WSP:
		

		

		Town:
		

		

		Name of FM:
		

		

		
	
		WSB:
		

		

		Project area:
		

		

		

		

		

		
	
		Commencement date:
		

		

		Orignial estimated completion date: 
		

		

		Estimated completion date:
		

		

		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		C
		Reporting on Milestones and Specific Activities 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Milestone
		Project Phase & Scope of Services  (1)
		Status (2)
		Progress (3)/Observations
		Issues arising 
		Recommendations
		
	
		

		

		Preparatory Activities 
		

		

		

		

		

		

		

		

		
	
		1
		Preparation of the detailed Work Plan
		

		

		

		

		

		

		

		

		
	
		

		

		Preparation of the technical works programme
		

		

		

		

		

		

		

		

		
	
		

		

		2
		Preliminary Project Planning Meeting (WSP, WSP, Municipality)
		

		

		

		

		

		

		

		
	
		

		

		3
		Conduct an assessment of the WSP (1) with respect to: setup of finance dept., accounting system and procurement process
		

		

		

		

		
	
		

		

		4
		Provide advice on the adequacy of the above and provide feasible recommendations on necessary improvements
		

		

		

		

		

		

		

		
	
		

		

		5
		Support the Company in preparation and implementation of the Procurement Plan
		

		

		

		

		

		

		

		
	
		

		

		6
		Support the WSP in preparing financial forecasts to prevent interruptions in project implementation due to cash-flow constraints 
		

		

		

		

		
	
		

		

		7
		Oversee the company's procurement process to ensure compliance with the Public Procurement and Disposal Act 2005 
		

		

		

		

		
	
		

		

		8
		Support the WSP during the preparation of financial records
		

		

		

		

		

		

		

		
	
		2
		9
		Support the WSP in ensuring that project funds are spent according to the requirements of the funding contract & report deviations
		

		

		

		

		
	
		

		

		Project implementation
		

		

		

		

		

		

		

		

		
	
		

		

		Community-based activities >>
		

		

		

		

		

		

		

		

		
	
		

		

		10
		Implement all improvements/system developed (see preparatory Activities) together with WSP staff
		

		

		

		

		

		

		

		
	
		

		

		11
		Provide support during the preparation of the water supply scheme/project management concept 
		

		

		

		

		

		

		

		
	
		

		

		12
		Support the billing section of the WSP in order to ensure that water kiosks are integrated in the billing system
		

		

		

		

		

		

		

		
	
		

		

		13
		Start of technical works
		

		

		

		

		

		

		

		
	
		

		

		14
		Coordinate with Engineering FM and Project Engineer (WSP) to ensure value for money for works done before payments are made
		

		

		

		

		
	
		

		

		15
		Strengthen the capacity and performance of the WSP staff responsible for water supply & sanitation in low income areas
		

		

		

		

		
	
		

		

		16
		Assist the WSP with establishing a strong presence in the project areas and other low income urban areas
		

		

		

		

		

		

		

		
	
		

		

		17
		Assist the WSP with the development and implementation of a (pro-poor) customer care concept 
		

		

		

		

		

		

		

		
	
		

		

		18
		Periodically brief the Managing Director of the WSP on the progress and the challenges facing the implementation of works
		

		

		

		

		
	
		

		

		19
		Prepare the operational phase of the project
		

		

		

		

		

		

		

		
	
		

		

		20
		Coordination of Technical Works and the Non-Technical Project Component 
		

		

		

		

		

		

		

		
	
		

		

		Training of Kiosk Operators >>
		

		

		

		

		

		

		

		

		
	
		3
		21
		Participate in the training of the Water Kiosk Operators & WSP staff
		

		

		

		

		

		

		

		
	
		

		

		Project commissioning and operation of the scheme 
		

		

		

		

		

		

		

		

		
	
		

		

		Commissioning of the project >>
		

		

		

		

		

		

		

		

		
	
		

		

		22
		Participate in the preparation of the commissioning of the project (kiosks)
		

		

		

		

		

		

		

		
	
		

		

		Operation of the project scheme >>
		

		

		

		

		

		

		

		

		
	
		

		

		23
		Support the WSP with the day-to-day management of the Operators and the kiosks/Training of Operators on-the-job
		

		

		

		

		

		

		

		
	
		

		

		24
		Monitor the financial performance of the project scheme (collection efficiency, revenue)
		

		

		

		

		

		

		

		
	
		

		

		25
		Monitor the supervision/inspection of the project scheme by the WSP
		

		

		

		

		

		

		

		
	
		

		

		26
		Monitor the implementation of the customer care concept
		

		

		

		

		

		

		

		
	
		4
		27
		Monitor the overall presence of the WSP in the project areas
		

		

		

		

		

		

		

		
	
		

		

		Activities taking place throughout the project
		

		

		

		

		

		

		

		

	
	
		

		

		28
		On-the-job training of the CSA
		

		

		

		

		

		

		

		
	
		

		

		29
		On-the-job training of other WSP staff
		

		

		

		

		

		

		

		
	
		

		

		30
		Periodically brief the WSP Managing Director on progress and (finacial) challenges facing implementation of works
		

		

		

		

		

		

		

		
	
		

		

		31
		Provide financial, customer care  and organisational advice to the WSP, the Task Team and the Contractor
		

		

		

		

		

		

		

		
	
		

		

		32
		Coordination with the of works and activities with the Task Team and other Field Monitors
		

		

		

		

		

		

		

		
	
		

		

		33
		Report all irregularities (acts of corruption, theft, misuse, etc.) 
		

		

		

		

		

		

		

		
	
		

		

		34
		Advice the WSTF on necessary actions/interventions (support measures and sanctions)
		

		

		

		

		

		

		

		
	
		

		

		35
		Monitor the performance & progress of the project and report problems to the WSTF
		

		

		

		

		

		

		

		
	
		

		

		36
		(First) Evaluation of the Kiosk Scheme
		

		

		

		

		

		

		

		
	
		Notes:
		

		1): 
		The Task Team may decide not to implement all activities mentioned in this sheet.  Progress, indicators and outputs should essentially be based upon the programme developed by the Task Team. 
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		2):
		N = Not yet started; I = Initiated;  P = In progress;  C = Completed; A = Activity not included or planned for; NA = Non-applicable 
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		3):
		G = Good progress;  F = Progress is fair;  U = Progress is unsatisfactory;  N = No progress; NA = Non-applicable 
		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: 3. Fin. Proj. Management

	
	
	
	
	
	
	
		FINANCIAL FIELD MONITOR REPORT FOR THE MONTH OF
		(Month-Year)
		January-2010
		
	
		Project Area/Name:
		>>
		

		
	
		Project Number:
		>>
		

		
	
		Name of Field Monitor:
		>>
		

		
	
		

		

		

		

		

		

		

		

		

	
	
		1. GENERAL PROGRESS/INFORMATION
		

		

		

		

		

		

		

		

	
	
		No.
		ITEM
		YES/NO
		if "NO" COMMENT
		
	
		1
		Bank statement available?
		

		

		
	
		2
		Are financial records properly kept/available?
		

		

		
	
		3
		Bank reconciliation up to date?
		

		

		
	
		4
		Have procurement procedures been followed?
		

		

		

		

		

		

		

	
	
		5
		All period expenses covered by receipts?
		

		

		
	
		6
		Are invoices/expenses in line with quotations?
		

		

		
	
		7
		Have expenses been allocated to budget line?
		

		

		
	
		8
		Are expenditure(s) in line with budget?
		

		

		
	
		9
		Are physical works in line with expenditure?
		

		

		
	
		10
		Overall financial procedures satisfactory? (no challenges?)
		

		

		
	
		11
		Has the Kiosk Operator training been done?
		

		

		

		

		

		

		

	
	
		12
		Is there WSP presence in the project area?
		

		

		

		

		

		

		

	
	
		13
		Is collection efficiency more than 95%?
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		2. FINANCIAL STATEMENTS
		

		KSh
		DATE
		% of TOTAL
		

		
	
		1
		Total approved project value (total budget)
		 10,000,000.00 
		

		

		
	
		2.1
		1st tranche received from WSTF
		 4,000,000.00 
		

		40%
		
	
		2.2
		2nd tranche received from WSTF
		

		

		0%
		
	
		2.3
		3rd tranche received from WSTF
		

		

		0%
		
	
		2.5
		Total funds received from WSTF
		 4,000,000.00 
		

		40%
		
	
		3
		Petty Cash Audit (count) at end of report period
		

		

		

		
	
		4
		Current bank balance on project account
		

		

		
	
		5
		Expected balance
		 4,000,000.00 
		

		
	
		

		

		

		

		

		

		

		

		

	
	
		3. BUDGET & EXPENDITURE
		

		

		

		

		

		

		

		

	
	
		No.
		BUDGET HEAD
		TOTAL BUDGET (KSh)
		CURRENT BUDGET     (KSh)
		EXPENDITURE B/F PREV. PERIODS (KSh)
		EXPENDITURE CURRENT PERIOD (KSh)
		TOTAL EXPENDITURE (KSh)
		UNDER/OVER SPENDING (current budget)
		% EXP. TOTAL BUDGET
	
	
		

		SOFTWARE
		

		

		

		

		

		

		

	
	
		1
		Administration Expenses
		

		

		

		

		

		0.00 
		0%
	
	
		2
		Field Equipment & Tools
		

		

		

		

		

		0.00 
		0%
	
	
		3
		Transport Costs
		

		

		

		

		

		0.00 
		0%
	
	
		4
		Accompanying Measures
		

		 -   
		

		

		 -   
		0.00 
		0%
	
	
		

		MATERIALS
		

		

		

		

		

		

		

	
	
		5
		Materials for Construction of Kiosks
		

		

		

		

		 -   
		0.00 
		0%
	
	
		6
		Materials for Pipeline Extensions
		

		

		

		

		 -   
		0.00 
		0%
	
	
		7
		Materials for Metering
		

		

		

		

		 -   
		0.00 
		0%
	
	
		8
		Materials for Construction of Yard Taps
		

		

		

		

		 -   
		0.00 
		0%
	
	
		

		LABOUR
		

		

		

		

		

		

		

	
	
		9
		Labour Cost for Construction of Kiosks
		

		

		

		

		 -   
		0.00 
		0%
	
	
		10
		Labour Costs for Pipeline Extensions
		

		

		

		

		 -   
		0.00 
		0%
	
	
		11
		Labour Costs for Construction of Yard Taps
		

		

		

		

		 -   
		0.00 
		0%
	
	
		12
		Labour Cost for Metering
		

		

		

		

		 -   
		0.00 
		0%
	
	
		

		TOTAL EXPENDITURE
		 -   
		 -   
		 -   
		 -   
		 -   
		 -   
		0%
	
	
		

		Bank Charges & WHT on interest earnings (*)
		

		

		

		

		 -   
		

		

	
	
		

		Interest Paid on Account
		

		

		

		

		 -   
		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		4. RECOMMENDATIONS
		

		

		

		

		

		

		

		

	
	
		1
		

		
	
		2
		

		
	
		3
		

		
	
		4
		

		
	
		5
		

		
	
		6
		

		
	
		7
		

		
	
		8
		

		
	
		9
		

		
	
		10
		

		
	
		*): 
		WHT = Witholding tax

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet progress report water services trust fund monthly field monitor financial project name no month wsp town of wsb area e s f commencement date original estimated completion a in use bullet points to summarise the main activities and during last any significant matters arising that adversely affect timing andor successful should be detailed next section photographs attached submitted illustrating physical items events held amp other interest b issues arisingin give detail potentially threaten or have impact on indicate cause problem it rsquo likely what compensating actions are proposed been taken if has changed then there must an entry this attach separate necessary engineering social finance signature checked by signed fm orignial c reporting milestones specific milestone phase scope status observations recommendations preparatory preparation work plan technical works programme preliminary planning meeting municipality conduct assessment with respect setup dept accounting system p...

Related files

Share

Help

FINANCIAL FIELD MONITOR REPORT FOR THE MONTH OF			(Month-Year)	January-2010
Project Area/Name:			>>
Project Number:			>>
Name of Field Monitor:			>>

1. GENERAL PROGRESS/INFORMATION
No.	ITEM	YES/NO	if "NO" COMMENT
1	Bank statement available?
2	Are financial records properly kept/available?
3	Bank reconciliation up to date?
4	Have procurement procedures been followed?
5	All period expenses covered by receipts?
6	Are invoices/expenses in line with quotations?
7	Have expenses been allocated to budget line?
8	Are expenditure(s) in line with budget?
9	Are physical works in line with expenditure?
10	Overall financial procedures satisfactory? (no challenges?)
11	Has the Kiosk Operator training been done?
12	Is there WSP presence in the project area?
13	Is collection efficiency more than 95%?

2. FINANCIAL STATEMENTS		KSh	DATE	% of TOTAL
1	Total approved project value (total budget)	10,000,000.00
2.1	1st tranche received from WSTF	4,000,000.00		40%
2.2	2nd tranche received from WSTF			0%
2.3	3rd tranche received from WSTF			0%
2.5	Total funds received from WSTF	4,000,000.00		40%
3	Petty Cash Audit (count) at end of report period
4	Current bank balance on project account
5	Expected balance	4,000,000.00

3. BUDGET & EXPENDITURE
No.	BUDGET HEAD	TOTAL BUDGET (KSh)	CURRENT BUDGET (KSh)	EXPENDITURE B/F PREV. PERIODS (KSh)	EXPENDITURE CURRENT PERIOD (KSh)	TOTAL EXPENDITURE (KSh)	UNDER/OVER SPENDING (current budget)	% EXP. TOTAL BUDGET
	*SOFTWARE*
1	Administration Expenses						0.00	0%
2	Field Equipment & Tools						0.00	0%
3	Transport Costs						0.00	0%
4	Accompanying Measures		-			-	0.00	0%
	*MATERIALS*
5	Materials for Construction of Kiosks					-	0.00	0%
6	Materials for Pipeline Extensions					-	0.00	0%
7	Materials for Metering					-	0.00	0%
8	Materials for Construction of Yard Taps					-	0.00	0%
	*LABOUR*
9	Labour Cost for Construction of Kiosks					-	0.00	0%
10	Labour Costs for Pipeline Extensions					-	0.00	0%
11	Labour Costs for Construction of Yard Taps					-	0.00	0%
12	Labour Cost for Metering					-	0.00	0%
	TOTAL EXPENDITURE	-	-	-	-	-	-	0%
	Bank Charges & WHT on interest earnings (*)					-
	Interest Paid on Account					-

4. RECOMMENDATIONS
1
2
3
4
5
6
7
8
9
10
*):	WHT = Witholding tax

Related files

Share

Share to social media

Help

Login Area