Soma · Paid pilot

Check movements and differences across documents

Analyze current and prior periods and reconcile worksheets, audit workpapers, and audit reports. Save calculated differences and reviewed explanations in an Excel workpaper.

Sign-in and access rights are required. Confirm the scope before starting a pilot.

Materials needed to begin

  • The loaded worksheet and audit report (DSD)
  • Audit workpaper files to reconcile
  • Current and prior period amounts and a ledger for variance analysis

We review the material you already have before agreeing on the pilot scope.

Pilot deliverables

  • Fluctuation-analysis workpaper

    Record period-to-period movements, items above the threshold, and reviewed explanations.

  • Three-way reconciliation workpaper

    Identify matches, mismatches, and missing items across worksheets, audit workpapers, and audit reports.

  • Follow-up items

    Keep uncertain matches and items needing explanation available for review.

Workflow

  1. 01

    Select inputs

    Select the inputs for variance analysis or three-way reconciliation.

  2. 02

    Check the comparison basis

    Check the periods, items, monetary units, and tolerance.

  3. 03

    Review differences

    Check calculated movements, mismatches, and missing items, then review the explanations.

  4. 04

    Save the workpaper

    Save the comparison and reviewed content as an XLSX workpaper.

What requires human approval
The reviewer determines the cause of differences and whether an adjusting entry is needed. Verify the comparisons and evidence before using them for closing or audit decisions.

Example results

Three-way reconciliation results

Worksheet
125,400,000Amount compared
Audit workpaper
125,400,000Match
Audit report
124,950,000Difference identified
difference
450,000Review explanation

Illustrative example. Actual fields and outputs depend on the selected workflow and supported format.