Country Office Composite Audit
Data Owner
Availability in Data Warehouse
Available
Data Refresh Rate
Daily
Accountability Weighted Scoring
30%
Introduction
Calculation of Scoring
Part 1: Country Office Performance Audit (50% by default)
Last CO Performance Audit
How do we determine the overall weight of Part 1?
0-2 years: 50% weight
2+ years: 40% weight
3+ years: 30% weight
4+ years: 20% weight
We score only using each country's latest CO audit reports. Previous historical audit ratings are shown in the indicator drill down but are not considered in the scoring methodology.
For each audit result, we assign the following scores:
Fully Satisfactory
100
Satisfactory / Some Improvement Needed
80
Partially Satisfactory / Major Improvement Needed
60
Unsatisfactory
0
Unsatisfactory is rated as zero. We want to significantly reduce the aggregate scores if even a small number of country offices in a region have Unsatisfactory audit ratings because these are so important to the organisation.
For Regional Bureau aggregation, we take an average of all the scoring, and the global average is calculated as an average of all country scores, not as an average of the Regional Bureau aggregation. This is to avoid skewed results, as different Regional Bureaus have different numbers of country offices. No weight is attached to country population size, amount of programming, or office size/budget.
Part 2: Project Audits (70% of [Indicator minus Part 1])
Let's start with some definitions:
DIM/DEX — Direct Implementation Modality, this is where UNDP is the implementor.
NIM — National Implementation Modality, this is where the Government is the implementor.
NGO/Other — Non-Governmental Organization, IFIs (International Financial Institutions) or another UN Agency.
These can be further broken down as
DIM/DEX
NIM (non-HACT)
NIM (HACT & Not Using National Auditors)
NGO/Other (non-HACT)
NGO/Other (HACT)
Qualified vs Unqualified Audit Opinions
All project audits will have one to three Qualified/Unqualified audit opinions:
CDR (Combined Delivery Report): All project audits will have this. Auditors do not review 100% of financial statements, and they look for financial misstatements.
Assets: Evaluates the value and condition of physical assets.
Cash on hand: Assesses the actual cash available with the implementing partner at the time of the audit.
In the Performance App, we only consider point 1, the financial statement from the CDR (Combined Delivery Report , due to the potential duplication across the three categories.
Some project audits will also have a audit rating as well, this is displayed in the Performance App but does not affect the scoring of this indicator.
Calculation of Scoring
For HACT Audits, we will use the previous FY (Financial Year) reports for this only. This data set is updated once per year, around June. For Non-HACT Audits, these are closer to real time as the audit are published.
Sum of all $ amount of Qualified Reports = "Total Financial Misstatement |Absolute Value|" in the above report
Confirmed that Audited Expenditure is the Total audited expenditure for that project, inclusive of financial misstatement.
$TotalReports = "Audited Expenditure" in the above report
The OAI Datasets includes a % calculation called "% NFM CY to Audited"
So for this part of the indicator, we get the weighted average.
So it SUM of Total Financial Misstatement / Sum of Audited Expenditure
We take the "% NFM CY to Audited" and multiply 20 to get the Indicator Adjustment Score.
100 - Indicator Adjustment Score = Indicator Score
Part 3: Long Outstanding Audit Recommendations ≥18 months (30% of Indicator minus Part 1)
This is calculated from the Audit Issue date fro any Outstanding Audit Recommendations that are "open"
0
100
1
60
1+
30
We take the Audit Issue date and then calculate as of today. We count anything with "Yes" in the below table as Open, and then calculate the age etc..
The field is reco_oai_status: Status of the recommendation (e.g., Implemented, In Progress, Not Implemented, Withdrawn).
Implemented
This is done to a satisfactory level
No
In Progress
Country Office is working on the recommendation actions.
Yes
Not Implemented
This is the default status. So the Country Office has not updated the status as "In Progress"
Yes
Withdrawn
OAI has decided to withdraw this, because the recommendation is no longer applicable
No
N/A
Not Applicable.
No
Last updated