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
- 01
Select inputs
Select the inputs for variance analysis or three-way reconciliation.
- 02
Check the comparison basis
Check the periods, items, monetary units, and tolerance.
- 03
Review differences
Check calculated movements, mismatches, and missing items, then review the explanations.
- 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.