Importing audit reports

An auditor's report or checklist often holds tens of findings. Instead of typing them over, import the report: Peilaro reads the findings, you check them, and only then are they created, each on its clause and linked to the audit.

Uploading the report

Under Findings, choose Import audit report. Choose the file: Excel (.xlsx), CSV, Word (.docx) or PDF. Then say whether it is an internal or an external audit, the date of the audit, a name for the report and, if you like, the auditor.

Under Belongs to you choose the audit the findings belong to:

• For an internal audit, one of the internal audits of your audit programme, or New internal audit from this report. The new audit is recorded as held on the date of the report.
• For an external audit, one of the audits of your certification body under Certificates and audits, or No certification audit.

Choose Read findings. Nothing is saved yet.

How Peilaro reads it

• A sheet or a Word table. Peilaro matches the columns by their headings, in Dutch or English: type, severity, clause, standard, finding, description, auditor, date, owner and deadline. When a column is matched wrongly, change it under Columns and read again. Auditors who do not work in Peilaro can use the Excel template, which you download on the same page.
• A report of a certification body. Findings marked in the text, such as [ NC: ... ], [ OFI: ... ], [ Minor: ... ], [ Major: ... ] or *** Observation: ..., are read with the clause of the heading they stand under. The summary at the start is matched to the same findings in the text, and findings of an earlier audit are left out.
• Other running text. When the optional AI is available to you, it reads the findings from the text; the text is sent with personal details masked. Otherwise Peilaro picks out the paragraphs that start with the kind of finding, such as Minor nonconformity or Observation.

A scanned PDF has no text to read. Save it as text, or use the Excel template.

Checking and importing

Every finding shows its type, title, description, clause, auditor, date, owner and deadline. Change what is not right, set an owner and a deadline, and untick what is not a finding. A clause Peilaro could not find in your standards is named as the report wrote it, so you can choose the right one.

Choose the import button at the bottom to create the ticked findings. The report itself is kept as evidence: an internal audit report on clause 9.2, an external one without a clause. Afterwards the list shows the findings of this report.

Following up

A non-conformity follows the corrective action path, and Microsoft Planner gets a task when you send that type there. Under the title, each finding names its audit. On Internal audits and on Certificates and audits, Findings (N) opens the findings of one audit, so you see per audit what is still open before the next one.