Working paper preparation

Working paper preparation covers a lead schedule for every major balance sheet and income statement account, each one reconciled to supporting detail and cross-referenced to the exact trial balance line it supports. Roll-forward schedules for accruals, reserves, fixed assets and any other rolling balance show opening balance, period activity and closing balance in one view, tied to prior-period comparatives. Variance explanations are written directly onto the schedule where a balance moves more than a routine amount, rather than left for someone to reconstruct verbally during a review call. A consistent file-naming and version convention runs across the entire set, and a revision log tracks every change made after an initial review comment, with the reason for the change noted alongside it.

We start from your reconciled trial balance and current chart of accounts, then build or update the lead schedule for each material account, drawing the supporting detail from your accounting software, bank records, and any subledgers involved such as fixed assets or accounts receivable aging. Each schedule is cross-referenced by a consistent tick-mark or reference-number system back to the trial balance, so an experienced reviewer with no prior connection to the file can trace any figure without asking a follow-up question. Once the draft set goes to your audit firm, review comments come back on a rolling basis; we update the affected schedule, log the change with a short note on what shifted and why, and keep the previous version rather than deleting it, so the file's history stays intact through every round.

Businesses in an active audit, review, or examination engagement where the audit firm expects a defined set of schedules rather than raw exports from the accounting system. Companies working through a first-year audit where nobody on staff has built a working paper set to an auditor's standard before. Multi-entity businesses where the working papers need consolidation eliminations built in alongside the entity-level schedules. Finance teams that already maintain reconciliations internally but need them reformatted and cross-referenced into an auditor-reviewable set on a defined timeline, rather than starting from scratch under deadline pressure.

The most frequent problem is a schedule that presents a number without showing how it was derived, so the first review comment simply asks for a breakdown that should have been on the page already. Another is a roll-forward that shows only the closing balance and skips the opening balance and activity, which forces a reviewer to request the missing detail separately. We also see file sets where a revised schedule silently replaces the original with no note explaining what changed, which slows the next review round because nobody can tell what was corrected versus what was simply reformatted. Inconsistent file naming across a large set, where two schedules for the same account carry different version numbers, is a smaller but common source of confusion we clean up at the outset.

Most engagements run on Excel, built from a trial balance export pulled directly out of QuickBooks Online, Xero or NetSuite so the starting figures match the general ledger exactly rather than being retyped. Where your audit firm uses a dedicated audit software platform with its own workpaper module, we build directly into that format instead of a parallel Excel set, so nothing needs to be re-keyed at handoff. Cross-references between schedules and source documents point to the actual bank statement, invoice, or subledger export rather than a generic label, so a reviewer can open the underlying document in one step.

Working paper preparation is typically scoped around the number of major accounts needing a lead schedule and the number of review rounds the engagement is expected to run, since both drive the actual hours involved. It runs as an add-on to your ongoing bookkeeping or audit-ready books engagement rather than a standalone monthly fee, and multi-entity work with consolidation eliminations is scoped separately from a single-entity set. Current bookkeeping tiers and the pricing calculator are on the pricing page; the exact fee for a working paper set is confirmed in writing once we know the account count and expected review cadence.

Every schedule is checked against the AICPA's experienced-auditor standard before it goes out: could someone with no prior connection to this engagement understand what was done, why, and what it concluded, from the schedule alone. Every figure on a lead schedule must trace to the trial balance without a gap, and any variance beyond a routine threshold carries a written explanation rather than being left implicit. We track how many review rounds each engagement needs and which specific schedules generate the most comments, and use that pattern to tighten the initial build on the next cycle rather than repeating the same gap.

Building the initial set typically takes one to three weeks depending on how many major accounts need a schedule and how much of the underlying reconciliation work is already done through audit-ready books. Review rounds then run in parallel with the audit firm's own fieldwork schedule, which for a small to mid-sized company usually spans one to three weeks. A repeat engagement starts from the prior year's schedules updated for the current period, which is markedly faster than a first-year build where every schedule is constructed from a blank template.