FIELDWORK

Audit fieldwork that lives inside Excel.

First Pass on Autopilot

AICPA · IFRS · PCAOB

Built for AICPA, IFRS, and PCAOB engagements.

What first-year staff actually spend time on.

Most of fieldwork is rote work that doesn't need judgment. Illustrative breakdown of a typical mid-market private audit.

From engagement setup to signed exception report.

  1. 01

    Engagement Setup

    Capture client, framework, industry, materiality, PY audit, and CY trial balance.

  2. 02

    Assertion-Risk Matrix

    AI maps every significant account to risks, assertions, and a planned approach. You review.

  3. 03

    Workpaper generation

    Lead sheets, scoping documents, and per-account workpaper shells, all in Excel.

  4. 04

    Substantive testing

    Sample selection, tickmarks, ratio + variance flagging, and an exception report you sign.

HARTWELL MANUFACTURING CO. — DSO & AGING ANALYTICS
FY 2024 Audit  |  AR Analytical Procedures  |  Completeness & Valuation  |  WP Reference: AR-03

SCOPING RATIONALE (AR): Positive confirmations on concentrated customers, subsequent-cash testing, aged-AR analytics, and cut-off testing around year-end. Concentration + fraud risk elevates this to High.

TESTING PROCEDURE: Performed substantive analytical procedures over AR in two parts. (1) DSO trend — computed Days Sales Outstanding (AR ÷ Revenue × 365) for the prior and current fiscal year and compared the YoY change to the industry benchmark (~72 days). (2) Aging mix — compared CY vs. PY aging distribution by bucket. Tied opening figures to PY audited balances and CY to the CY TB.

DAYS SALES OUTSTANDING (DSO) — TREND ANALYSIS
MetricFY 2022FY 2023FY 2024YoY ChangeYoY %
Revenue6,820,0007,610,0008,240,000630,0008.3%
AR, net1,390,0001,620,0001,840,000220,00013.6%
DSO (days) = AR / Revenue × 36574.477.781.53.84.9%
Industry benchmark7272720.0%
DSO CONCLUSION: DSO increased from 77.7 days (FY23) to 81.5 days (FY24), a 3.8-day increase (4.9%). This exceeds the industry average of ~72 days. The increase is primarily attributable to C004 Pinnacle Precision Parts (slow payer) and C009 Keystone (large balance, longer collection cycle). DSO trend is a mild risk indicator — corroborates the elevated risk rating on this account but does not indicate material misstatement.

A generated workpaper — built from your trial balance, AR aging, and prior-year audit

Built for firm-grade trust.

Per-seat pricing.

14-day free trial. No card required during beta. 30-day money-back guarantee on paid plans.

Starter

$249/user/mo

For small CPA firms with 1–5 users. Limited engagements and AI runs.

Start free trial
Most popular

Pro

$499/user/mo

Full testing workflows and integrations. The full Fieldwork.

Start free trial

Enterprise

Custom

SSO, audit logs, advanced controls, and dedicated support for large firms.

Talk to sales

Start your 14-day trial.

No card during beta. Walk one engagement through Fieldwork and decide if it pays for itself.