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. Depending on your QuickBooks Online edition and region, some schedules can run inside QuickBooks (QuickBooks Online Advanced, for example, can create depreciation schedules), but unless depreciation, prepaid amortization, and deferred revenue recognition are all set up, posted every month, and reconciled to the balance sheet, 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.
Fynease Automate runs your prepaid expense, deferred revenue, fixed asset, loan and lease schedules every close and writes the adjusting entries back to QuickBooks Online, so the supporting schedules exist before the auditor asks for them.
See how it works → Start free trialThe 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. Fynease Automate is built around that idea: the schedules run inside the close rather than beside it. 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.
Audit-ready workpapers are the documents an auditor's PBC list asks for: an adjusted trial balance, lead sheets for major balance sheet accounts, supporting schedules such as the prepaid schedule and fixed asset rollforward, and an audit trail for every adjusting entry. Together they let each number on the financial statements be traced through a lead sheet to its underlying support, so the auditor can conclude that the books are right.
Not the full set. QuickBooks Online Accountant has a report called Adjusted Trial Balance, but it means something narrower: the balances before and after the journal entries marked as adjusting entries in QuickBooks. The adjusted trial balance an auditor asks for is the trial balance after every close adjustment (schedules, accruals, reclassifications), each tied to a lead sheet and a supporting schedule that show where it came from. QuickBooks does not produce those lead sheets or supporting schedules; they are usually built outside it, in Excel. Unless recurring entries for depreciation, prepaid amortization, and deferred revenue recognition are set up and posted every month, the QuickBooks trial balance reflects a cash-adjacent view rather than the accrual view that audited financial statements require.
A lead sheet is a one-page summary for a major financial statement line item showing the prior year balance, the current year balance, a rollforward of material components, and cross-references to support. A supporting schedule sits behind the lead sheet and shows the detail, such as every prepaid item with its original cost, monthly amortization, and opening and closing balances. Auditors use lead sheets to navigate the package and schedules to verify the numbers.
Fynease Automate connects to QuickBooks Online, runs your prepaid expense, deferred revenue, fixed asset, loan, and lease schedules, consolidates multiple entities, applies IAS 21 FX translation, eliminates intercompany, and writes adjusting entries back, every close, automatically.
See Fynease Automate Start free trial