AttestWork demo tour · Part 4 of 6
Import the numbers once. Everything downstream agrees.
The FS workspace carries the engagement's number spine: trial balances (up to ten years, QuickBooks Online exports import directly), the general ledger, a TB-vs-GL tie-out, account mapping to fieldwork sections and statement captions, adjusting entries, and the CPA report - one set of balances feeding every workpaper.
Illustrative engagement: Hudson & Vale CPAs, LLP (Albany, NY) auditing Riverbend Community Services, Inc. (Rochester, NY) - a NYS-funded nonprofit, GAAS audit, FYE December 31, 2025, with a NYS CFRDec25 Examination add-on. Fictional firm, client, and data.
Trial balance
Ten years of TB, one Import button
QuickBooks Online Trial Balance exports import directly from the Import Excel button.
| Account # | Account name | Debit | Credit |
|---|---|---|---|
| 0001 | First Harbor Checking - Operating | 214,382.40 | 0.00 |
| 0002 | First Harbor Savings - Reserve | 96,110.25 | 0.00 |
| 0004 | Right-of-use asset | 182,449.17 | 0.00 |
| 0005 | Accounts payable and accrued expenses | 0.00 | 41,534.77 |
| 0008 | Operating lease liability | 0.00 | 173,280.72 |
| 0011 | OPWDD program revenue | 0.00 | 684,210.00 |
| 0012 | OMH contract revenue | 0.00 | 302,466.00 |
The bot does the heavy lifting
- Runs the TB-to-GL tie-out and reports matched rows, variances, GL-only and TB-only accounts - with parent/child roll-up diagnostics.
- Maps accounts to fieldwork sections and FS captions in the Mapping tab, and keeps the Combined TB's unadjusted → adjustments → adjusted columns live per year.
- Carries mapped balances into the Master Workbook - Combined TB with real formulas flowing into the statements.
You stay in control
- You upload the client's TB and GL - or drop the QBO exports straight in.
- You review every proposed mapping and every variance explanation.
- Calculation-heavy schedules stay in the Master Workbook where formulas recalculate in Excel or OnlyOffice.
Adjustments
AJEs that tell you where they touched
Every entry carries workpaper references and memos, and posting flows through mapping, statements, analytics, and materiality - no re-keying, no stale columns.
AJE-2025-001 Correct opening lease balances at Jan 1, 2025 for FY2024 lease amortization/accretion not posted by the client.
Posted| Account | Debit | Credit | WP ref | Memo |
|---|---|---|---|---|
| 0008 Operating lease liability | 23,280.72 | AjA | Reduce opening lease liability for FY2024 payments/accretion. | |
| 0010 Prior-period adjustment - depreciation true-up | 1,136.84 | AjA | Record opening prior-period adjustment for lease correction. | |
| 0004 Right-of-use asset | 24,417.56 | AjA | Record opening amortization of right-of-use asset. |
AJE-2025-002 Record FY2025 operating lease accounting under ASC 842.
PostedCombined Trial Balance PREPAREDAR07/08/26
| Fieldwork | FS element | Account | 2025 Unadj | 2025 Audit Adj | 2025 Adj Bal | 2024 Unadj | 2024 Audit Adj | 2024 Adj Bal |
|---|---|---|---|---|---|---|---|---|
| F1 - Cash | Assets | First Harbor Checking - Operating | 214,382.40 | - | 214,382.40 | 96,120.15 | - | 96,120.15 |
| F10 - Debt, Borrowings & Leases | Assets | Right-of-use asset | 182,449.17 | (24,417.56) | 158,031.61 | - | - | - |
| F6 - Property & Equipment | Assets | Accumulated depreciation | (84,030.86) | (2,250.92) | (86,281.78) | (72,918.20) | - | (72,918.20) |
▶ Watch: QBO import, tie-out, mapping, and adjustments
Screens on this page are illustrative: Hudson & Vale CPAs and Riverbend Community Services, Inc. are fictional.