ElyxAI

Excel for internal auditors: which audit on the plan is open

The internal audit workbook on this page is the list you open before the morning review of the plan. One row is one audit on that plan. You type the audit, the period word, the type, the date, the owner, and how many days of warning you want on that row. The window says due when the days left are within that warning. Done and dropped rows stay on the sheet and leave the count. This file is not an audit preparation checklist. That checklist is the list of documents and reconciliations a team gathers before someone reviews the books. This list is the plan of audits you own: fieldwork, a report, a follow-up. It is not a quality inspection on the shop floor, and it is not a legal matter deadline. It does not say whether a control passed. You type the date and the status. The guide below builds that tracker. Elyx writes the days left and the window in the workbook you already keep. You still type the date and the owner. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What goes on an audit plan tracker?

One row per audit: name, period, type, date, owner, alert days you typed, and a window of due or later.

Is this the audit preparation checklist?

No. A preparation checklist lists documents to gather before a review of the books. This sheet lists the audits on your plan and the dates you typed.

Does the sheet say a control passed?

No. You type the date, the type, and the status. The sheet only counts which open rows are inside the warning you typed.

Essential
Popular