Skip to main content

How to efficiently perform Revenue testing with DataSnipper Excel Agents

Use Excel Agents to automate revenue testing end to end, from reading source documents to reconciling data and producing traceable output. Requires DataSnipper v26.1 or later.

DataSnipper Excel Agents bring intelligence directly into Excel. Describe what you want to achieve and the Agent executes the complete revenue testing procedure end to end, producing transparent and traceable output ready for review.

Prerequisites

  • DataSnipper v26.1 or later

  • Accelerate or Elevate DataSnipper package

  • Access to the internet

Video tutorial

What the video covers: opening the Revenue Testing workpaper, importing supporting documents, initiating the Excel Agent from the DataSnipper ribbon, entering an instruction prompt, approving the Agent's plan, reviewing the completed output including Snips and Excel formulas, and applying professional judgement before sign-off.

Step-by-step tutorial

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

Revenue Testing workpaper with supporting documents imported

  1. Click the Excel Agent icon in the DataSnipper ribbon to initiate the Agent.

Excel Agent icon in the DataSnipper ribbon

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

Entering an instruction in the Excel Agent prompt

  1. The Agent analyzes your instruction and summarizes the procedure it plans to perform. Once it is ready to document the output, it will ask for your approval before updating the workbook.

Agent summary and approval request

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

Excel Agent completion summary

  1. The workpaper now includes all generated outputs, with the relevant Snips and Excel formulas in place.

Completed workpaper with Snips and formulas

  1. Apply your professional judgement to review the output and make any required edits.

To learn how to write effective prompts for Excel Agents, see the prompting guide.

Did this answer your question?