How to extract Audit data in the GMS

POSTED BY Hortense Regnaut | 22 September 2021 | GMS Quick Tip

  1. What is the Audit Report and where to access it in the GMS?
  2. How to generate an Audit Report (filters)?
  3. What is included in the Audit Report extract?

 

  1. What is the Audit Report and where to access it in the GMS?

The GMS allows the users to download all audit data as a working Excel document where multiple partners can be selected. For more information on the project audit, please see the dedicated article on Project Audit on the Help Portal.

 To generate such a document, go to report > report > Audit report 

2. How to generate an Audit Report (filters)? 

In the Audit Report page, enter your research requirements using the filter options, and click on [export to excel]. If you click on [export to excel] without applying filters, you will generate a full dump of all audit reports of the Pooled Funds in which you are registered.

A description of the filters is available below the screenshot.

Filters description:

  • Pooled Fund: Select from the drop-down list the Pooled Fund. You will only be able to select the Pooled Fund(s) in which you are registered.
  • Allocation year: select from the drop-down list the allocation year by ticking its checkbox. You can select multiple allocations.
  • Partner type: Select from the drop-down list the Organization type by ticking its checkbox. You can select multiple organizations.
  • Partner: Select from the drop-down list the Organization by ticking its checkbox. You can select multiple organizations.

Then, click on [export to excel]. The excel will be downloaded in your computer, by default in the ‘Downloads’ folder, except if you configured it differently.

 

      3. What is included in the Audit Report extract? 

The Audit Report excel extract is broken down into two tabs: the Audit Report sheet, which will display all the information relevant to the audit findings and recommendations, and the Audit Closure Report sheet, which will provide an overview of all the key dates of the project instances.

 Field Description (Audit Report sheet):

  • Fund Name
  • Organization Name
  • Project Code
  • Audit completion Date
  • Eligible Expenditure (as per the audit report)
  • Recommendation and findings (including its type and risk level)
  • Justifications and implementing partner’s responses

 

Field Description (Audit Closure Report sheet):

  • Fund Name
  • Project Code
  • Partner
  • Due Diligence and Capacity Assessment status
  • Project submission, signature dates
  • Tranches disbursement amounts and dates
  • Financial and Narrative reports submission date
  • Audit activation and actual completion dates