When your auditor sends the PBC (prepared by client) list, the first few items are almost always the same: adjusted trial balance, lead sheets for major balance sheet accounts, schedule of prepaid expenses, fixed asset rollforward, deferred revenue schedule, and loan amortization table. These are standard asks because they tell an auditor everything they need to know about whether the books are right.
The problem for most QuickBooks Online users is that none of these documents exist in QuickBooks. They have to be built externally — usually in Excel — every time an audit comes around. This article explains what audit-ready workpapers look like, why QuickBooks doesn't produce them natively, and what it takes to get from raw QuickBooks data to a workpaper package an auditor can actually rely on.
The adjusted trial balance (ATB) is the foundation of the audit. It shows every account balance after all adjusting journal entries have been posted — accruals, prepaid amortization, depreciation, deferred revenue recognition, and any audit adjustments. The unadjusted trial balance from QuickBooks is the starting point, but the ATB must reflect every adjustment made during the close. The ATB must tie to the financial statements: the sum of income statement accounts must match net income, and the balance sheet must balance.
A lead sheet is a one-page summary for each major financial statement line item or grouping that shows: the prior year balance, the current year balance, a rollforward of material components, and cross-references to supporting schedules. Auditors use lead sheets to navigate the workpaper package — each number on the financial statements should be traceable through a lead sheet to its underlying support.
Common lead sheets: cash (ties to bank reconciliations), accounts receivable (ties to AR aging), prepaid expenses (ties to prepaid schedule), fixed assets (ties to depreciation schedule), accounts payable (ties to AP aging), deferred revenue (ties to deferred revenue rollforward), and long-term debt (ties to loan amortization schedule).
Behind each lead sheet is a schedule that shows the details. The prepaid schedule lists every prepaid item, its original cost, the monthly amortization, the balance at the beginning of the period, and the balance at the end. The fixed asset rollforward shows every asset, its original cost, accumulated depreciation at the start, current-period depreciation, and net book value at month-end. These schedules exist independently of QuickBooks — they are the source of truth that QuickBooks balances need to reconcile to.
Every adjusting journal entry needs to be supported: what it is, why it was posted, who posted it, and when. For a standard prepaid amortization entry, the support is the prepaid schedule. For an accrued liability, the support is the contract or vendor invoice. For an intercompany elimination, the support is the intercompany agreement. The audit trail is not a nice-to-have — it is the evidence that allows an auditor to conclude that the entries are correct.
QuickBooks Online records transactions as they happen. It is not designed to enforce accrual basis accounting automatically. Unless someone has manually set up recurring journal entries for depreciation, configured prepaid amortization entries, and is consistently posting deferred revenue recognition entries every month, the QuickBooks trial balance reflects a cash-adjacent view of the world, not the accrual view that audited financial statements require.
Specific gaps that auditors commonly find in raw QuickBooks data:
None of these are QuickBooks failures. They are process failures that QuickBooks is not designed to prevent. The controller's job is to catch and correct these before the auditor does.
Auditor time is expensive: When auditors find these gaps during fieldwork, they extend their procedures to assess the scope of the issue. Every hour of additional auditor work because the books weren't close-ready when they arrived is audit fee that could have been avoided with a cleaner close process.
The most important change a controller can make to their close process is to maintain schedules as living documents throughout the year, not build them for the first time when the auditors arrive. The prepaid schedule should be updated every month when the amortization entries are posted. The fixed asset rollforward should be updated every month when depreciation is recorded. By year-end, these schedules are complete and current rather than being reconstructed from historical transactions.
Audit-ready books are produced by a sequence, not a scramble. The sequence matters: bank reconciliations first, then AR and AP cutoffs, then accrual schedule entries, then balance sheet account reconciliations, then intercompany, then consolidation. Doing these in the wrong order — or skipping steps when time is short — produces a trial balance that looks balanced but has errors buried in the detail.
If adjusting entries made during the close are not posted back to QuickBooks, the QuickBooks trial balance and the correct adjusted trial balance are two different documents. Auditors working directly in QuickBooks will see different numbers from the financial statements you gave them — which creates confusion and additional audit work. Every material adjusting entry should have a corresponding QuickBooks journal entry so the two sources of truth are the same source of truth.
Workpapers should be produced as a natural output of the close process, not assembled in a separate effort after audit fieldwork is announced. A controller who closes the books correctly generates the ATB, lead sheets, and supporting schedules as a byproduct of the work they are already doing. If producing those documents requires significant additional effort, the close process has a gap that should be fixed before the next audit cycle, not during it.
Fynease Automate connects to QuickBooks Online, runs your accrual schedules, consolidates multiple entities, applies IAS 21 FX translation, eliminates intercompany, and writes adjusting entries back — every close, automatically.
See Fynease Automate Join waitlist