First page of the Whistleblower Case LogExcel workbook preview

Fraud risk (GAO framework)

Whistleblower Case Log

Whistleblower log in Excel: one row per report with live 7-day acknowledgment and 3-month feedback deadlines, case status, retaliation check and summary.

Excel workbook · 16 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A whistleblower case log records every report received through the speak-up channels: when and how it came in, who handles it, whether the reporter was acknowledged and given feedback in time, and how the case ended. The audit committee uses it to oversee the channel, and regulators or auditors ask for it to see that reports are followed up and that reporters are not retaliated against.

The deadlines come from Article 9(1) of Directive (EU) 2019/1937: acknowledgment within seven days and feedback within three months of the acknowledgment, or of the end of the seven-day period if none was sent. Both are settings you can change. The worked example is an invented group with 11 reports from the US, the UK and the Netherlands, and the Summary sheet gives on-time rates and counts for the committee.

Who it is for

The ethics or compliance officer who must show the audit committee or a regulator that every report was logged, acknowledged and answered on time.

What is inside

  • Case Log with 11 worked reports and 16 blank rows, 20 columns
  • Acknowledgment due and feedback due dates calculated from the date received (Directive (EU) 2019/1937, Article 9)
  • On time, Late, Due and Overdue status formulas with red and amber highlighting
  • Days open, plus an amber flag on closed cases without a retaliation check
  • Dropdowns for channel, entity, anonymity, category, case status and audit committee reporting
  • Settings sheet holding the 7-day and 3-month defaults with their source
  • Summary with 9 measures plus counts by category, entity, channel and case status

How to use it

Check the two deadlines on the Settings sheet against your national law, then replace the 11 sample reports with your own.

Files

  • XLSXwhistleblower-case-log.xlsx16 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What should a whistleblower log record?

At least the date received, the channel, whether the report was anonymous, the category, a summary without names, the handler, the acknowledgment and feedback dates, the case status, the outcome and the closing date. Article 18 of the Directive requires records of every report, kept no longer than necessary and in line with the confidentiality duty.

Who should have access to the whistleblower log?

Only the people authorized to receive or follow up reports. Article 16 of the Directive says the reporter's identity must not be disclosed beyond those staff without explicit consent, and that includes information from which the identity could be deduced. Keep the summary free of names and hold the detailed file separately.

What if a report arrives anonymously with no way to reply?

Record it, follow it up as far as the information allows, and leave the acknowledgment date empty. The status column will show the acknowledgment as Due or Overdue, so add a note in the outcome column that no contact route exists. A hotline with two-way messaging avoids this problem.