Accounting working-paper builder

Purpose

Create a structured workpaper that shows what was tested, what supports it, what remains unresolved, and how the conclusion follows.

Scope

Defined accounting or assurance sections with a stated objective, population, evidence set, and review program. Excluded: audit opinion, client approval, and procedures not supported by the supplied program.

Data basis

• Section balance or population, evidence folder, prior-year workpaper, review program, accounting policy, and materiality guidance.
• The fixed records, tables, or folders in the skill scope that hold the relevant history or schema.

Result

A workpaper document, evidence index, and findings sheet with conclusion and open points.

Quality criteria

• The objective, population, period, and procedure are explicit.
• Every conclusion cites evidence or identifies the missing support.
• Sample selections and exclusions are documented when sampling is used.
• Findings distinguish error, exception, limitation, and unresolved question.
• The conclusion follows from the documented procedures and evidence.

Instructions

Use the current-period data as the primary basis and prior-year work only for comparison or continuity. Tie each test to the stated objective. Apply materiality and sampling guidance from scope; never invent a threshold. Preserve contradictory evidence and explain how it affects the conclusion. Ensure the evidence index points to the exact document, page, row, or record.

Adapt before use

Keep the source trail close to every conclusion and preserve the difference between a source fact, a calculated value, an assumption, and a recommendation. Use stable identifiers across the document and sheet so a reviewer can move from a summary statement to the underlying row and source. Prefer a complete, transparent partial result over a confident answer built on missing evidence.

• Add the firm workpaper template, review program, and evidence-index format.
• Define materiality, sampling, and exception rules.
• Specify acceptable evidence and reviewer sign-off fields.
• Set terminology for assurance, bookkeeping, or advisory engagements.