jagomart
digital resources
picture1_Financial Spreadsheet 33099 | Financial Financialmanagementsystemdiagnostic Tool En


 170x       Filetype XLSX       File size 0.11 MB       Source: www.theglobalfund.org


File: Financial Spreadsheet 33099 | Financial Financialmanagementsystemdiagnostic Tool En
sheet 1 general instructions purpose this tool seeks to support grant implementers that would like to perform a deepdive review of their financial management systems by responding to a questionnaire ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: General Instructions

Purpose:
















This tool seeks to support grant implementers that would like to perform a deep-dive review of their financial management systems. By responding to a questionnaire, grant implementers will be able to:
- assess, analyze and evaluate the root causes of financial management issues/ bottlenecks; and
- measure and demonstrate improvement in the financial management systems over a period of time.













Process:
















Financial Management Systems are reviewed using a questionnaire-type approach, targeting 10 key areas. A weighted average score is assigned to each key area which is dependent on average scores obtained for a related set of sub-questions and the relevance (or weight) assigned to that key area of financial management. If the organization is implementing various grants using the same institutional arrangements, information system and staff, one grant review should be performed representing for all grants.

Implementers are required to provide a response by selecting the appropriate score in "Column F". The reviewer only needs to compare relevant available information for each question against criteria 4-1 and report appropriate score in "Column F". If the available information does not fit into any of the available criteria, the reviewer is required to use professional judgement to score the respective question and provide the rationale in "Column N". Furthermore, the reviewer can also use the guidance provided in "Column M", which assists in scoring each of the listed questions.



Sheet 2: Summary
Financial Management System Diagnostic/Self Review Tool








Financial Management Systems Diagnostic/Self Review


Summary of Outcomes






Financial Management Review Areas Average Score Weighted Average Score Remarks/Conclusion
1. INSTITUTIONAL AND OVERSIGHT ARRANGEMENT 4.00 0.46
2. INTERNAL CONTROLS 4.00 0.29
3. HUMAN RESOURCES 4.00 0.46
4. PLANNING, BUDGETING AND FUNDS FLOW MANAGEMENT 4.00 0.35
5. ACCOUNTING AND RECORD KEEPING 4.00 0.58
6. PROCUREMENT MANAGEMENT 4.00 0.29
7. TREASURY MANAGEMENT 4.00 0.46
8. ASSET AND INVENTORY MANAGEMENT 4.00 0.17
9. FINANCIAL MANAGEMENT OF SUB-RECIPIENTS/SUB-OFFICES 4.00 0.35
10. FINANCIAL REPORTING AND ASSURANCE ARRANGEMENT 4.00 0.58
Average weighted score
4.00




Financial Management Components Average Score Weighted Average Score Remarks/Conclusion
People 4.00 0.81
Process 4.00 2.72
System 4.00 0.46
Average weighted score
4.00




Integrated Risk Tool Areas Average Score Weighted Average Score Remarks/Conclusion
Flow of Fund Arrangement 4.00 0.23
Internal Controls 4.00 1.68
Corruption and Theft 4.00 0.06
Accounting and Financial Reporting 4.00 0.81
Value for Money 4.00 0.87
Auditing Arrangement 4.00 0.35
Average weighted score
4.00




Legends


Capacity Review - Classification Corresponding Risk - Classification
Category Score Range Score Range Category
No Issues/ Meet Expectation 3.6 - 4.0 0 - 1.5 Low
Minor Issues 2.6 - 3.5 1.6 - 2.5 Medium
Moderate Issues 1.6 - 2.5 2.6 - 3.5 High
Major Issues 0 - 1.5 3.6 - 4.0 Very High

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

...Sheet general instructions purpose this tool seeks to support grant implementers that would like perform a deepdive review of their financial management systems by responding questionnaire will be able assess analyze and evaluate the root causes issues bottlenecks measure demonstrate improvement in over period time process are reviewed using questionnairetype approach targeting key areas weighted average score is assigned each area which dependent on scores obtained for related set subquestions relevance or weight if organization implementing various grants same institutional arrangements information system staff one should performed representing all grantsimplementers required provide response selecting appropriate quot column f reviewer only needs compare relevant available question against criteria report does not fit into any use professional judgement respective rationale n furthermore can also guidance provided m assists scoring listed questions summary diagnosticself outcomes re...

no reviews yet
Please Login to review.