Skip to main content

How to perform ITGC access controls testing with Excel Agents

Use DataSnipper Excel Agents to streamline ITGC access controls testing: import evidence, prompt the agent, confirm the plan, and review the traceable output. Requires v26.1 or later.

Learn how to streamline access reviews, reduce manual effort, and improve audit consistency for ITGC access controls testing with Excel Agents.

What are Excel Agents?

DataSnipper Excel Agents move beyond automation to bring intelligence directly into Excel. Instead of working through manual steps, you describe what you want to achieve and the agent takes care of the execution. From reading source documents and reconciling data to applying audit and finance logic, Excel Agents execute complete tests end to end. The result is transparent, explainable output that is fully traceable back to the underlying evidence and ready for review.

Prerequisites

  • DataSnipper v26.1 or later

  • Accelerate or Elevate DataSnipper package

  • Access to the internet

Video walkthrough

What the video covers

The walkthrough shows importing ITGC supporting documents, prompting an Excel Agent to perform the access controls test, confirming the planned procedure, and reviewing the agent's output and snips.

Step-by-step tutorial

1. Open your ITGC Excel workpaper and import the relevant supporting documents.

Importing ITGC supporting documents

2. To start the Excel Agent, click the icon in the DataSnipper ribbon.

Excel Agent icon in the DataSnipper ribbon

3. Enter your instruction in the prompt to tell the Excel Agent what to do.

Entering an instruction in the Excel Agent prompt

4. The Excel Agent analyses your instructions and summarises the procedure it plans to perform. If the summary looks correct, confirm to proceed.

Reviewing the Excel Agent's planned procedure

5. Once the procedure finishes, the Excel Agent provides a detailed summary of the actions completed.

Summary of completed actions

6. The workpaper now includes all generated outputs, along with the relevant snips and explanations for the differences noted.

Workpaper output with snips and explanations

7. Use your professional judgement to review the output and make any required edits.

To understand how to structure prompts effectively, see How to write effective prompts for Excel Agents.

Did this answer your question?