Skip to main content

How to efficiently perform Trial Balance and Financial Statements reconciliation with DataSnipper Excel Agents

Use Excel Agents to automate Trial Balance and Financial Statements reconciliation end to end. Requires DataSnipper v26.1 or later.

DataSnipper Excel Agents bring intelligence directly into Excel. Describe your Trial Balance and Financial Statements reconciliation procedure and the Agent executes it 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 reconciliation workpaper and importing supporting documents, initiating the Excel Agent, entering a reconciliation prompt, approving the Agent's plan, reviewing the completed output with Snips and formulas, and applying professional judgement before sign-off.

Step-by-step tutorial

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

Reconciliation 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 a reconciliation 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 reconciliation workpaper with Snips and formulas

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

Did this answer your question?