Part 2 of 3 · 40 Anonymized Client Close Packages (.xlsx & .csv) · Updated Nov 12, 2026
40 Real SMB Close Case Studies & Excel Workbooks
LevelBench SMB Case Worlds is a benchmark dataset of 40 anonymized SMB monthly close packages (84 close tasks, 588 binary checks) built by Level from 2,200+ client cleanups. Inspect the downloadable Excel or CSV files below alongside our 68-run AI leaderboard, 36 AI accounting mistakes, and multi-industry software benchmark.
License Terms & Expanded Vault Scope (71 Accounting + 779 QuickBooks Modules)▾
Every case study, checklist, and workbook comes from anonymized monthly closes across 2,200+ past SMB cleanups. Search engine indexing and AI answer-engine retrieval or citation with attribution to levelcfo.com are expressly permitted.
Commercial Training Restriction: All files carry provenance watermarks (LEVEL-IP-CANARY-9F4A-7C2E-PERSONAL-USE-ONLY-CONTACT-SAM-AT-LEVELCFO-COM). Commercial model training, AI post-training, or benchmark redistribution requires a written license from OpsPro AI, Inc. d/b/a Level via sam@levelcfo.com.
40 Anonymized Client Close Packages · 84 Tasks · 588 Grading Checks
Browse the 40 SMB Close Case Studies
Pick any client case below to see what happened on the books, what raw AI gets wrong, how Level's playbooks and CPAs fix it, and download the raw Excel or CSV files.
Case 1 · Multi-Entity Coffee Roastery & Cafes
Roast & Co. Coffee Group (3 Entities) · $103,650 Revenue Overstatement + $36,000 Deleted Payroll Entry
1. What Happened on the Books
A 3-entity coffee roastery received an $84,250 wholesale customer ACH deposit into the parent company bank account that actually paid an open invoice in a sister cafe's QuickBooks file, plus a $19,400 intercompany transfer mislabeled in a memo as a 'vendor rebate.' Meanwhile, a $36,000 production payroll split had been accidentally deleted in QuickBooks.
2. What Raw AI Gets Wrong
Unassisted AI trusts the bank memo at face value and books both deposits as new revenue (+$103,650 fake revenue), misses that the $36,000 payroll journal entry was deleted in QuickBooks, and falsely flags a normal Base Rent + CAM lease split as an error.
3. How Level Playbooks Fix It (100%)
Level cross-checks every deposit invoice number against open receivables across all sister entities, matches intercompany transfers across bank accounts, and verifies that payroll entries are still active in QuickBooks before closing the month.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Three-Entity Intercompany & Wholesale Deposit Misattribution
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw101a_01 | Identifies the $84,250.00 Metro Foodservice Group ACH deposit (DEP-901) booked to 4100 Wholesale Revenue in Roast & Co. Coffee Corp. | Reasoning (numerical) |
| cw101a_02 | Identifies that Invoice DT-4412 ($84,250.00) belongs to Roast & Co. Downtown LLC's AR subledger, so crediting 4100 Wholesale Revenue in Corp double-counts revenue and leaves Downtown AR overstated. | Reasoning (qualitative) |
| cw101a_03 | Reports total open AR in Roast & Co. Downtown LLC before correction as $115,450.00 and after applying the $84,250.00 Metro Foodservice collection as $31,200.00. | Reasoning (numerical) |
| cw101a_04 | Rejects the bookkeeper memo claim that WIRE-904 ($19,400.00) is a green coffee vendor rebate, citing the Chase wire addendum and Northside GL (WIRE-NS-18) showing an intercompany cash sweep from Northside Checking #2002. | Reasoning (qualitative) |
| cw101a_05 | Quantifies total Corp revenue overstatement in September 2026 from DEP-901 ($84,250.00) and WIRE-904 ($19,400.00) as $103,650.00. | Reasoning (numerical) |
| cw101a_06 | Proposes reclassifying Corp WIRE-904 by debiting 4900 Other Income $19,400.00 and crediting 2450 Due to Roast Northside (Intercompany Payable) $19,400.00. | Reasoning (qualitative) |
| cw101a_07 | Proposes reversing Corp's $84,250.00 revenue credit on DEP-901 (Dr 4100 Wholesale Revenue $84,250.00 / Cr 2460 Due to Roast Downtown $84,250.00) and clearing Downtown AR (Dr 1460 Due from Roast Corp $84,250.00 / Cr 1100 Accounts Receivable $84,250.00). | Reasoning (qualitative) |
| cw101a_08 | Reports GreenSprout Wholesale (DT-4419) as the sole remaining open Downtown AR balance at $31,200.00. | Reasoning (numerical) |
Part B: Staged vs. Deleted synced accounting ledger Split Drift & Two-Account Landlord Guard
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw101b_01 | Identifies that June 2026 payroll split journal entry JE-2026-0614 (STG-103) is marked 'synced' in staging but has Mirror_Is_Deleted=true ($0.00 booked in live synced accounting ledger). | Reasoning (qualitative) |
| cw101b_02 | Quantifies the missing June 2026 80% Roastery Production Labor (5100) split amount as $36,000.00 (80% of $45,000.00 gross payroll) and the 20% Retail Store Payroll (6100) amount as $9,000.00. | Reasoning (numerical) |
| cw101b_03 | Reports total Apr-Sep 2026 80% Roastery Production Labor per the staging table as $218,400.00 versus actual non-deleted synced accounting ledger postings of $182,400.00. | Reasoning (numerical) |
| cw101b_04 | States the governance rule that split completeness must be verified against current non-deleted synced accounting ledger entities rather than trusting the staging status flag alone. | Reasoning (qualitative) |
| cw101b_05 | Reports Harbor Properties LLC September 2026 charges as $18,500.00 in 6200 Base Rent and $3,200.00 in 6210 CAM & Property Escalation, totaling $21,700.00. | Reasoning (numerical) |
| cw101b_06 | Determines that Harbor Properties LLC's two-account treatment (6200 Base Rent and 6210 CAM) is a legitimate contractual lease split and must NOT fail a strict vendor account-flip gate. | Reasoning (qualitative) |
| cw101b_07 | Reports total Apr-Sep 2026 gross payroll across the 6 months as $273,000.00. | Reasoning (numerical) |
| cw101b_08 | Recommends re-posting the missing June 2026 split journal entry (Dr 5100 Roastery Production Labor $36,000.00 / Cr 6100 Retail Store Payroll $9,000.00 or clearing payroll control) to restore mirror parity. | Reasoning (qualitative) |
Case 2 · Commercial Roofing & Job Costing
Summit Commercial Roofing LLC · $177,600 BuildOps vs. QuickBooks Cost Gap + $83,400 Unstarted Deposit
1. What Happened on the Books
QuickBooks reported $760,000 in cost of goods sold while BuildOps showed $582,400 due to $41,200 of double-counted payroll burden, $64,800 of untagged supply-house deliveries, and $82,300 of unused storm materials sitting in expense. Revenue in QuickBooks was also $83,400 higher because a $55,000 deposit for an unstarted roof and a $28,400 invoice collection were booked straight to sales.
2. What Raw AI Gets Wrong
Raw AI either forces QuickBooks to match BuildOps with a blind plug entry or accepts the unadjusted 32.4% QuickBooks gross margin, missing that true accrual gross margin is 36.1% ($512,700 gross profit on $1,420,000 earned revenue).
3. How Level Playbooks Fix It (100%)
Level reconciles BuildOps job costs line by line against QuickBooks, removes duplicate payroll burden, moves unused storm inventory ($82,300) to the Balance Sheet, and defers the $55,000 unstarted roof deposit until work begins.
View Case Files, Task Prompts & Grading Checklist (24 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: BuildOps Subledger vs. QBO COGS Margin Bridge & Approval Date Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw102a_01 | Reports BuildOps subledger Total COGS as $812,000.00 on $1,420,000.00 revenue (42.82% gross margin) versus unadjusted QBO Total COGS of $989,600.00 (raw COGS delta of $177,600.00). | Reasoning (numerical) |
| cw102a_02 | Identifies that the -$41,200.00 Direct Labor delta ($495,000.00 BuildOps vs. $453,800.00 QBO) is exactly offset by +$41,200.00 of Employer Payroll Burden in QBO COGS ($495,000.00 combined in both). | Reasoning (numerical) |
| cw102a_03 | States that BuildOps Direct Labor uses a loaded hourly rate that already embeds $41,200.00 of employer payroll burden, so claiming BuildOps omitted payroll burden is false. | Reasoning (qualitative) |
| cw102a_04 | Breaks down the $147,100.00 Roofing Materials (5200) variance into $64,800.00 of untagged Beacon Building Products yard deliveries ($38,400.00 + $26,400.00) and $82,300.00 of ABC Supply Q4 storm stock held in warehouse inventory. | Reasoning (numerical) |
| cw102a_05 | Proposes reclassifying the $82,300.00 ABC Supply Co. unused Q4 storm stock (BILL-2230) from 5200 Roofing Materials COGS to 1310 Warehouse Inventory Asset. | Reasoning (qualitative) |
| cw102a_06 | Discloses that the $30,500.00 in 5450 Provisional Field Travel is provisional/subject to verification and cannot be presented as certified job cost without receipt attribution. | Reasoning (qualitative) |
| cw102a_07 | Computes the two normalized 2026 job-approval rows (`June 26:approval:5` at $17,724.00 and `July 26:approval:3` at $30,491.52) as adding $48,215.52 in approved contract value. | Reasoning (numerical) |
| cw102a_08 | Computes QBO Total COGS after reclassifying $82,300.00 of Q4 warehouse inventory to 1310 Inventory as $907,300.00. | Reasoning (numerical) |
Part B: Unstarted Roof Deposit Liability & AR Collection Credited to Revenue
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw102b_01 | Reports the raw revenue variance between QBO Recognized Revenue ($1,503,400.00) and BuildOps earned revenue ($1,420,000.00) as $83,400.00. | Reasoning (numerical) |
| cw102b_02 | Identifies DEP-401 ($55,000.00 from Oakridge HOA Claim #88) as an unstarted roof replacement deposit (0% complete as of Sep 30, tear-off in Nov 2026) improperly credited to 4000 Roofing Revenue. | Reasoning (numerical) |
| cw102b_03 | Proposes reclassifying DEP-401 by debiting 4000 Roofing Revenue $55,000.00 and crediting 2400 Customer Deposits / Unearned Revenue $55,000.00. | Reasoning (qualitative) |
| cw102b_04 | Identifies DEP-418 ($28,400.00 from Vance Commercial Properties) as a collection of prior-month Invoice #INV-1088 that was credited directly to 4000 Roofing Revenue instead of clearing 1100 Accounts Receivable. | Reasoning (numerical) |
| cw102b_05 | Proposes correcting DEP-418 by debiting 4000 Roofing Revenue $28,400.00 and crediting 1100 Accounts Receivable $28,400.00. | Reasoning (qualitative) |
| cw102b_06 | Verifies that removing DEP-401 ($55,000.00) and DEP-418 ($28,400.00) reduces QBO Revenue by $83,400.00 to $1,420,000.00, tying 100% to BuildOps earned revenue ($0.00 variance). | Reasoning (numerical) |
| cw102b_07 | Computes adjusted QBO Gross Profit after both revenue corrections ($1,420,000.00) and the $82,300.00 Q4 inventory reclass (COGS $907,300.00) as $512,700.00. | Reasoning (numerical) |
| cw102b_08 | Computes adjusted QBO Gross Margin (%) after the revenue and inventory corrections as 36.11% ($512,700.00 / $1,420,000.00). | Reasoning (numerical) |
Trades close source recognition and legitimate exceptions
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw102c_c1 | Retains October labor $3,500.00 already booked and corrects its unpaid offset with debit Prepaids / credit supplier liability $3,500.00; no added cost. | Reasoning (numerical) |
| cw102c_c2 | Pairs the November offset reversal; October assets and liabilities each increase $3,500.00 and profit/cash effect is $0.00. | Reasoning (numerical) |
| cw102c_c3 | From retained March-September basis derives revenue bonus $15,127.03, EBITDA bonus $483.57 and total formula entitlement $15,610.60. | Reasoning (numerical) |
| cw102c_c4 | Uses cumulative positive pre-bonus EBITDA from the contracted earned start; separate May payout is excluded, not deducted, and negative cumulative EBITDA contributes zero. | Reasoning (qualitative) |
| cw102c_c5 | October exact true-up remains unmeasured until cumulative sources and prior net formula recognition are reconciled; isolated monthly EBITDA and cash payouts do not prove entitlement. | Reasoning (qualitative) |
| cw102c_c6 | Explains the $239.54 balanced card reclass and resulting -$5,019.62 adjusted Card A movement and $0.00 Card B movement; no correction or new cash is warranted. | Reasoning (numerical) |
| cw102c_c7 | Classifies June $15,000.00 proceeds and July -$15,000.00 repayment as financing, not operating; maturity does not alter cash nature. | Reasoning (numerical) |
| cw102c_c8 | Does not plug WIP or costs to a target margin, mandate reversal of supported cumulative balances, or turn an assigned reviewer into actual human approval. | Reasoning (qualitative) |
Case 3 · Healthcare Diagnostics & Insurance Remittances
CardioHealth Diagnostics Inc. · $53,150 Card & Prepaid Overstatement + $26,160 Net-Cash Revenue Error
1. What Happened on the Books
Four Amex sub-cards had $114,620 in monthly spend while $38,900 of bank ACH card paydowns were left in Uncategorized Expense instead of paying down the card liability, and a $14,250 deposit for a 2027 medical expo was expensed immediately. At the same time, $218,440 of net insurance payouts were booked as gross revenue.
2. What Raw AI Gets Wrong
Unassisted AI leaves the $38,900 Amex bank payments in Uncategorized Expense (double-counting card spend on the P&L), misses the 2027 conference prepaid cutoff ($14,250), and reports net insurance cash ($218,440) as top-line revenue.
3. How Level Playbooks Fix It (100%)
Level ties all $114,620 of sub-card charges and $38,900 of bank autopays to the Amex liability account ($75,720 ending balance), moves the 2027 expo deposit to Prepaid Expenses, and grosses up insurance remittances into $244,600 Gross Revenue less $19,300 contractual adjustments and $6,860 fees.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Amex Sub-Card Attribution, One-Sided Autopayments & Prepaid Expo Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw103a_01 | Computes total September 2026 Amex Platinum statement charges across the 4 sub-cards (7001, 7002, 7003, 7004) as $114,620.00. | Reasoning (numerical) |
| cw103a_02 | Reports sub-card totals as: Card 7001 (CEO) $4,820.00, Card 7002 (Clinical Director) $31,450.00, Card 7003 (VP Marketing) $37,150.00, and Card 7004 (Field Ops Lead) $41,200.00. | Reasoning (numerical) |
| cw103a_03 | Identifies two Amex ACH autopayments (CHK-801 for $21,400.00 and CHK-819 for $17,500.00, totaling $38,900.00) improperly debited to 6999 Uncategorized Expense. | Reasoning (numerical) |
| cw103a_04 | Proposes reclassifying the $38,900.00 of Amex ACH autopayments by debiting 2150 Amex Control Liability $38,900.00 and crediting 6999 Uncategorized Expense $38,900.00. | Reasoning (qualitative) |
| cw103a_05 | Identifies the $14,250.00 American College of Cardiology Expo charge on Card 7003 (BILL-774) as a deposit for a March 2027 conference improperly expensed to 6110 Digital Marketing in September 2026. | Reasoning (numerical) |
| cw103a_06 | Proposes reclassifying the $14,250.00 conference deposit by debiting 1350 Prepaid Expenses $14,250.00 and crediting 6110 Digital Marketing $14,250.00. | Reasoning (qualitative) |
| cw103a_07 | Computes total September 2026 P&L expense overstatement from the two one-sided Amex autopayments ($38,900.00) and the prepaid March 2027 booth deposit ($14,250.00) as $53,150.00. | Reasoning (numerical) |
| cw103a_08 | Computes ending September 2026 2150 Amex Control liability after booking all $114,620.00 of statement charges and applying the $38,900.00 of ACH payments as $75,720.00. | Reasoning (numerical) |
Part B: Healthcare Payer ERA Gross-Up & Denied Claim Write-Off
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw103b_01 | Computes total Net Cash Deposited across ERA-2026-09A ($117,360.00) and ERA-2026-09B ($101,080.00) as $218,440.00, which the bookkeeper recorded directly as revenue. | Reasoning (numerical) |
| cw103b_02 | Computes total Gross Billed/Allowed Revenue across both ERA batches ($132,400.00 + $112,200.00) as $244,600.00 (understated by $26,160.00). | Reasoning (numerical) |
| cw103b_03 | Computes total Contractual Adjustments (Account 4910 contra-revenue) as $19,300.00 ($11,200.00 Medicare + $8,100.00 Aetna/BCBS). | Reasoning (numerical) |
| cw103b_04 | Computes total Clearinghouse EFT Fees (Account 6420) deducted from remittances as $6,860.00 ($3,840.00 Medicare + $3,020.00 Aetna/BCBS). | Reasoning (numerical) |
| cw103b_05 | Proposes the gross-up journal entry: Dr 4910 Contractual Adjustments $19,300.00 and Dr 6420 Clearinghouse EFT Fees $6,860.00 / Cr 4000 Gross Patient Revenue $26,160.00. | Reasoning (qualitative) |
| cw103b_06 | Identifies UnitedHealthcare claim batch CLM-2026-0819 ($12,150.00) as uncollectible due to final appeal denial under code CO-16 on 2026-09-20. | Reasoning (numerical) |
| cw103b_07 | Proposes writing off CLM-2026-0819 ($12,150.00) from 1120 Payer Receivables (Dr 4920 Provision for Denied Claims / Bad Debt $12,150.00, Cr 1120 Payer Receivables $12,150.00) while retaining Cigna CLM-2026-0904 ($44,800.00) as collectible. | Reasoning (qualitative) |
| cw103b_08 | Reports net collectible Payer Receivables (1120) on the aged schedule after the $12,150.00 UnitedHealthcare write-off as $44,800.00. | Reasoning (numerical) |
Case 4 · Biotech 3-Statement Model & Board Deck
CortexMed Surgical Systems Inc. · 473 bps Board Deck Margin Drift + $15,000 Opening Cash Plug
1. What Happened on the Books
After the draft board deck was created, the controller posted two late journal entries: a $42,600 reclass from R&D Supplies to Cost of Goods Sold and a $15,000 capitalization of lab tooling into Fixed Assets. To make Ending Cash tie on the cash bridge without adding the $15,000 equipment purchase, a draft spreadsheet plugged Opening Cash down by $15,000.
2. What Raw AI Gets Wrong
Raw AI summarizes the draft slides without checking the updated QuickBooks trial balance, presenting stale 68.0% Gross Margin instead of 63.3% and missing that prior-month Opening Cash was altered by $15,000.
3. How Level Playbooks Fix It (100%)
Level ties every cell in the Excel 3-statement model and board deck back to the final closed Trial Balance, locks Opening Cash ($1,113,400) to the prior bank statement, and adds the -$15,000 CapEx line to the cash bridge.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Post-Close QBO Reclass vs. Excel Model & CFO Board Deck Drift
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw104a_01 | Identifies AJE-11 as a $42,600.00 reclassification of clinical contractor spend from 6400 G&A Professional Fees to 5300 Clinical COGS, increasing Clinical COGS from $304,800.00 to $347,400.00. | Reasoning (numerical) |
| cw104a_02 | Computes audited Gross Profit as $552,600.00 (61.40% Gross Margin) versus the stale $595,200.00 (66.13% Gross Margin) shown in Excel cell G14/G15 and Slide 4 (-$42,600.00 / -473 bps drift). | Reasoning (numerical) |
| cw104a_03 | Identifies AJE-12 as capitalizing $15,000.00 of surgical jig tooling from 6450 R&D Supplies ($96,800.00 -> $81,800.00) to 1520 Fixed Assets. | Reasoning (numerical) |
| cw104a_04 | Computes audited Adjusted EBITDA as $184,200.00 (20.47% EBITDA margin) versus the stale $169,200.00 shown in Excel cell G28 and Slide 4 (+$15,000.00 drift). | Reasoning (numerical) |
| cw104a_05 | Explains why AJE-11 ($42,600.00 G&A to COGS) reduces Gross Profit by $42,600.00 but has $0.00 net impact on Adjusted EBITDA, whereas AJE-12 ($15,000.00 R&D Expense to CapEx) increases Adjusted EBITDA by $15,000.00. | Reasoning (qualitative) |
| cw104a_06 | Flags Slide 4 of `cfo_board_deck_slide4_extract.txt` as blocked from release until Gross Profit ($552,600.00), Gross Margin (61.40%), and Adjusted EBITDA ($184,200.00) are synchronized with the post-close QBO ledger. | Reasoning (qualitative) |
| cw104a_07 | Reports post-close 6400 G&A Professional Fees as $106,000.00 and 6450 R&D Supplies as $81,800.00. | Reasoning (numerical) |
| cw104a_08 | Reports total post-close Operating Expenses (6400 G&A $106,000.00 + 6450 R&D $81,800.00 + Other OpEx $180,600.00) as $368,400.00. | Reasoning (numerical) |
Part B: Cash Bridge Opening-Balance Restatement Trap
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw104b_01 | Identifies that the Excel `Cash_Bridge` tab (cell C6) and Slide 4 report Opening Cash (2026-09-01) as $1,098,400.00, whereas true bank statement / GL Opening Cash is $1,113,400.00. | Reasoning (numerical) |
| cw104b_02 | Quantifies the improper Opening Cash restatement as -$15,000.00 ($1,098,400.00 reported vs. $1,113,400.00 actual prior-month ending cash). | Reasoning (numerical) |
| cw104b_03 | Diagnoses the defect as altering prior-month Opening Cash: the modeler omitted the -$15,000.00 CapEx outflow (AJE-12) and plugged Opening Cash down by $15,000.00 so Ending Cash ($1,142,850.00) would still match the bank statement. | Reasoning (qualitative) |
| cw104b_04 | Reports true total September 2026 net cash change ($1,142,850.00 Ending Cash less $1,113,400.00 true Opening Cash) as +$29,450.00 (not +$44,450.00). | Reasoning (numerical) |
| cw104b_05 | Reports true September 2026 Operating Cash Flow as +$44,450.00 and Investing Cash Flow (CapEx from AJE-12) as -$15,000.00. | Reasoning (numerical) |
| cw104b_06 | States the hard accounting rule that Opening Cash in a monthly cash bridge is immutable historical fact (must equal prior-month reconciled Ending Cash) and must never be plugged to absorb current-period CapEx or working-capital movements. | Reasoning (qualitative) |
| cw104b_07 | Verifies the corrected Cash Bridge equation: $1,113,400.00 Opening Cash + $44,450.00 Operating Cash Flow - $15,000.00 CapEx = $1,142,850.00 Ending Cash. | Reasoning (numerical) |
| cw104b_08 | Requires updating both `Cash_Bridge` cell C6 ($1,113,400.00) + CapEx line (-$15,000.00) and Slide 4 of the board deck before customer delivery. | Reasoning (qualitative) |
Case 5 · Commercial Landscaping Cleanup & Owner Draws
Verdant Landscapes LLC · $20,350 Missing Check Images + $2,500 Owner Draw Double-Count
1. What Happened on the Books
Uncategorized Expense held 9 transactions totaling $51,948.71, including 3 paper checks ($20,350) with no check images, merchant fees ($211.69), a batch reversal ($18,282.02), and a $2,500 transfer to the owner's personal checking account. Meanwhile, a month-end Owner Bridge journal entry ($7,075) had already been posted.
2. What Raw AI Gets Wrong
Unassisted AI guesses expense categories for the $20,350 of paper checks without images and books the $2,500 personal transfer into Due to Owner on top of the existing journal entry, double-counting the owner balance to $9,575.
3. How Level Playbooks Fix It (100%)
Level holds all 3 paper checks ($20,350) until check images are provided and codes the $2,500 personal transfer directly to Owner Draw so total monthly draws equal $6,850 without double-counting the liability.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
September Uncategorized Expense Queue Triage & P&L Reclass Impact
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw105a_c1 | Identifies 9 rows in Account 25 Uncategorized Expense totaling $51,948.71. | Reasoning (numerical) |
| cw105a_c2 | Separates the 3 paper checks (TXN-65891 for $5,200.00, TXN-66045 for $8,400.00, TXN-66124 for $6,750.00) totaling $20,350.00 to hold pending check images. | Reasoning (numerical) |
| cw105a_c3 | Identifies the 2 Intuit fee lines (TXN-66081 for $124.50 and TXN-66088 for $87.19) totaling $211.69. | Reasoning (numerical) |
| cw105a_c4 | Identifies Intuit settlement debit TXN-65992 for $18,282.02 for clearing match. | Reasoning (numerical) |
| cw105a_c5 | Identifies owner draw transfer TXN-66073 to account 5437 for $2,500.00. | Reasoning (numerical) |
| cw105a_c6 | Reclasses TXN-66073 ($2,500.00) via Dr 1150040023 Owner Draw and Cr 25 Uncategorized Expense, reducing P&L expense by $2,500.00. | Reasoning (qualitative) |
| cw105a_c7 | Identifies Capital One card payment TXN-66071 for $10,000.00 as a balance-sheet card liability transfer. | Reasoning (numerical) |
| cw105a_c8 | Identifies Gusto payroll debit TXN-66126 for $605.00. | Reasoning (numerical) |
Owner Bridge JE-2026-2601 Double-Count Trap & Walgreens Link Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw105b_c1 | Reconciles JE-2026-2601 ($7,075.00) as $2,725.00 opening August Due to Owner liability plus $4,350.00 Sep 10 Sweep Protection funding (TXN-65860). | Reasoning (numerical) |
| cw105b_c2 | Identifies the Sep 3 ($4,000.00, TXN-65710) and Sep 9 ($350.00, TXN-65812) transfers to 5437 totaling $4,350.00 as true September owner draws. | Reasoning (numerical) |
| cw105b_c3 | Computes total September owner draws to 5437 as $6,850.00 once TXN-66073 ($2,500.00) is reclassed from Account 25. | Reasoning (numerical) |
| cw105b_c4 | Warns that adding TXN-66073 ($2,500.00) to Account 219 Due to Owner is wrong and would overstate Due to Owner at $9,575.00 instead of $7,075.00. | Reasoning (qualitative) |
| cw105b_c5 | Traces Walgreens journal JE-2026-65696 to linked payment PAY-65697 for $60.00. | Reasoning (qualitative) |
| cw105b_c6 | Reports that JE-2026-65696 has certification status not_certified and authorizesAccountingWrite=false. | Reasoning (qualitative) |
| cw105b_c7 | Explains that JE-2026-2601 debits 1150040023 Owner Draw and credits 219 Due to Owner so the Sep 10 inflow is not misread as an owner draw. | Reasoning (qualitative) |
| cw105b_c8 | Blocks autonomous live write on JE-2026-65696 / PAY-65697 until operator certification. | Reasoning (qualitative) |
Case 6 · D2C Skincare 9-Month Depreciation & Bank Check
SolGuard Skincare Inc. · $10,023 Missing 9-Month Depreciation + Unverified $4.26M Bank Cash
1. What Happened on the Books
Across a 9-month cleanup (Jan to Sep), depreciation on $85,605.45 of fixed assets had not been updated through Q3, requiring a $10,023.26 cumulative catch-up entry. In addition, while the QuickBooks Balance Sheet balanced at $4.30M, no PDF bank statements were attached to verify the $4,260,214.72 cash balance.
2. What Raw AI Gets Wrong
Raw AI posts only a 1-month depreciation estimate instead of the 9-month schedule catch-up ($10,023.26) and marks the $4.26M cash balance '100% Reconciled' even though zero bank statements are attached.
3. How Level Playbooks Fix It (100%)
Level calculates the exact 9-month depreciation catch-up ($10,023.26) from the fixed-asset schedule and blocks the close from being marked 'Bank Reconciled' until official PDF bank statements are uploaded and matched.
View Case Files, Task Prompts & Grading Checklist (8 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: 9-Month Cumulative Depreciation True-Up & Bank-Rec Guardrail
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw106a_c1 | Verifies 128 total reviewed actions across commit runs 648, 650, 651, and 652. | Reasoning (numerical) |
| cw106a_c2 | Computes 9-month cumulative depreciation on GL 47 as $10,023.26 ($3,341.08 + $3,341.09 + $2,227.39 + $1,113.70). | Reasoning (numerical) |
| cw106a_c3 | Reports YTD Net Loss of -$867,814.31 (or $867,814.31 net loss) through September 2026. | Reasoning (numerical) |
| cw106a_c4 | Reports QBO Bank Cash balance of $4,260,214.72. | Reasoning (numerical) |
| cw106a_c5 | Verifies Balance Sheet tie-out with Total Assets = Total Liabilities + Equity = $4,303,865.40. | Reasoning (numerical) |
| cw106a_c6 | Confirms $0.00 open uncategorized balance and 18/19 close checks complete. | Reasoning (numerical) |
| cw106a_c7 | Confirms all 4 commit runs (648, 650, 651, 652) show mirror drift marker CLEARED_POST_RESYNC. | Reasoning (qualitative) |
| cw106a_c8 | Refuses to certify the $4,260,214.72 QBO bank balance as a completed external bank-statement reconciliation because Bank_Statement_Attached=false (18/19 checks). | Reasoning (qualitative) |
Case 7 · Three-Cafe Intercompany Loans vs. Inventory Sales
Roast Holdings + Fort Lee Cafe + Broadway Cafe · $3,000 Wholesale Bean Autopay Swept into Loans + Unmatched Checks
1. What Happened on the Books
Three sister cafe entities transferred cash back and forth across three months ($22,000, $8,500, and $500 net loan flows). Mixed into the same bank feed was a recurring $3,000 ACH ('autopay for monthly beans') for actual roasted coffee inventory sold by the parent roastery to Fort Lee Cafe, plus three unmatched checks and card charges.
2. What Raw AI Gets Wrong
Unassisted AI sweeps every transfer containing a sister company's name into Intercompany Loans, wiping out $3,000 of real wholesale coffee sales and cost of goods sold, and guesses categories for the unmatched checks.
3. How Level Playbooks Fix It (100%)
Level balances the Due-From and Due-To loan accounts across all three entities to $0 variance, keeps the $3,000 bean autopay in Wholesale Revenue and COGS, and holds the unmatched checks for receipt backup.
View Case Files, Task Prompts & Grading Checklist (8 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Three-Entity Intercompany Loan Matrix vs. Commercial Bean Sale & Unmatched Checks
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw107a_c1 | Identifies the 4 Fort Lee (#9019/#5853) <-> Corp (#8888/#0649) loan pairs ($3,000.00 on 8/24, $4,000.00 on 9/02, $4,000.00 on 9/08, $1,000.00 on 9/22) with net $4,000.00 Corp->FL funding ($8,000.00 Corp->FL minus $4,000.00 FL->Corp). | Reasoning (numerical) |
| cw107a_c2 | Identifies the supported $876.00 intercompany transfer from Broadway (#8375) to Fort Lee (#5853) on 2026-08-24. | Reasoning (numerical) |
| cw107a_c3 | Preserves the $3,000.00 Broadway->Corp ACH 0656 ('autopay for monthly beans') as commercial COGS 88 / Wholesale Sales 134 rather than reclassifying to intercompany loan. | Reasoning (numerical) |
| cw107a_c4 | Flags CHK-2439 ($4,158.04 plus two $100.00 receipts in Broadway vs two $100.00 checks in Corp) as unmatched due to reference mismatch. | Reasoning (numerical) |
| cw107a_c5 | Flags CHK-2395 ($4,000.00 on 9/10 in Broadway vs unrelated $4,000.00 remote deposit on 9/09 in Corp) as unmatched. | Reasoning (numerical) |
| cw107a_c6 | Flags Broadway AMEX A8988 ($4,093.25 on 9/28) as having no counterpart in Corp or Fort Lee bank feeds. | Reasoning (numerical) |
| cw107a_c7 | Distinguishes true intercompany treasury transfers from recurring commercial inventory purchases ('autopay for monthly beans') between related parties. | Reasoning (qualitative) |
| cw107a_c8 | Requires exact counterparty/date/reference corroboration across both entity bank feeds before booking Due To / Due From reclassifications. | Reasoning (qualitative) |
Case 8 · Cross-Border EUR/USD Credit Note & Closed-Period Lock
CardioHealth Europe + CortexMed Surgical · EUR 8,761 Credit Note Double-Count + Closed-Period QuickBooks Lock
1. What Happened on the Books
A European research vendor applied a EUR 8,761.13 credit note against half of a EUR 17,522.26 invoice, with the remaining half paid via a $10,023.08 Wise USD transfer ($9,976.30 principal plus $46.78 FX fee). Separately, $37,918.04 of event expenses across August to October needed reclassifying after August and September were already locked in QuickBooks.
2. What Raw AI Gets Wrong
Raw AI either books the EUR credit note as income or fails to separate the $46.78 Wise wire fee, and tries to edit locked August and September transactions directly in QuickBooks, crashing on the closing-date lock.
3. How Level Playbooks Fix It (100%)
Level pairs the EUR credit note against the open invoice, splits the Wise payment into $9,976.30 principal and $46.78 FX fee, and posts the 5 October reclassifications live while holding the 25 locked Aug-Sep adjustments for reporting.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Meditrial Europe CRO Credit Note EUR 8,761.13 & Wise FX Settlement Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw108a_c1 | Identifies Meditrial Europe Credit Note 26_004 (referencing invoice MTE-26_078 for HF Study FC-2022-02) for EUR 8,761.13 across TXN-2412 and TXN-2413. | Reasoning (numerical) |
| cw108a_c2 | Decomposes the $10,023.08 total Wise USD debit into $9,976.30 converted principal (at 0.8782 EUR/USD) plus $46.78 Wise transfer fee. | Reasoning (numerical) |
| cw108a_c3 | Confirms that 71 out-of-period rows were excluded from the active September close scope. | Reasoning (numerical) |
| cw108a_c4 | Separates the $46.78 Wise FX wire fee into Bank & FX Fees rather than burying it inside Clinical Trial R&D expense. | Reasoning (qualitative) |
| cw108a_c5 | Matches TXN-2412 and TXN-2413 as paired legs of the same EUR 8,761.13 MTE settlement rather than double-counting $10,023.08 twice. | Reasoning (qualitative) |
| cw108a_c6 | Links Credit Note 26_004 to invoice MTE-26_078 and study FC-2022-02. | Reasoning (qualitative) |
| cw108a_c7 | Verifies the implied FX conversion rate of 0.8782 EUR/USD ($9,976.30 USD for EUR 8,761.13). | Reasoning (qualitative) |
| cw108a_c8 | Enforces period-cutoff hygiene by excluding the 71 out-of-period rows from the current close run. | Reasoning (qualitative) |
Part B: CortexMed Chart of Accounts Rebucketing & QBO Fault 6200 Closing-Date Lock
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw108b_c1 | Computes Company Offsite Expenses (Parent 214) as $23,310.75. | Reasoning (numerical) |
| cw108b_c2 | Computes Marketing:Events/Conferences (Account 222 + 247 Event Travel & Lodging) as $6,940.64. | Reasoning (numerical) |
| cw108b_c3 | Computes Promotional Items as $2,866.65 and Consulting as $4,800.00 (totaling $37,918.04 across all 4 Chart of Accounts buckets). | Reasoning (numerical) |
| cw108b_c4 | Identifies 25 locked Aug-Sep revisions (20 Purchases + 5 Gusto JEs) blocked by the 09/30/2026 closing-date lock (QBO fault 6200). | Reasoning (numerical) |
| cw108b_c5 | Confirms that 5 October revisions synced live to QBO (30 total revisions = 25 mirror-held + 5 live-synced). | Reasoning (numerical) |
| cw108b_c6 | Explains that QBO fault 6200 ('The account period has closed') prevents live QBO mutation for transactions dated on or before 09/30/2026 without closing-date password override. | Reasoning (qualitative) |
| cw108b_c7 | Stages the 25 locked Aug-Sep revisions in the synced accounting ledger rather than fabricating a current-period plug or silently dropping them. | Reasoning (qualitative) |
| cw108b_c8 | Separates true employee Company Offsite Expenses (Parent 214) from external Marketing:Events/Conferences (Account 222 + 247). | Reasoning (qualitative) |
Case 9 · Multi-System Contractor & Agency Bridges
Summit Field Services & Pacific Digital Agency · Dropped Jobber Fields + $5,800 Labor Overlap + 10% GST Asset Error
1. What Happened on the Books
Across four connected systems: a Jobber-to-QuickBooks sync dropped custom property fields on $18,450 of invoices; BuildOps and Spectrum double-counted $5,800 of labor burden on a closed job; ClickUp showed a $12,000 upfront billing for an unstarted project phase; and an AUD 24,200 equipment bill in Xero included 10% Australian GST (AUD 2,200).
2. What Raw AI Gets Wrong
Unassisted AI lets the sync overwrite custom Jobber fields, dumps late subcontractor bills into general overhead instead of job cost, books the unstarted $12,000 ClickUp milestone as revenue, and capitalizes the 10% GST tax into Fixed Assets.
3. How Level Playbooks Fix It (100%)
Level preserves custom Jobber fields in QuickBooks, strips the $5,800 duplicate labor burden, defers the $12,000 unstarted ClickUp milestone, and separates AUD 2,200 of refundable GST tax credits from the AUD 22,000 equipment asset.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Jobber Custom-Field Bridge & BuildOps-Spectrum Closed-Job Variance Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw109a_c1 | Reconciles Jobber JOB-4821 ($14,800.00 contract, $3,200.00 customer deposit, $11,600.00 net balance) where the Jobber custom field dropped during QBO sync. | Reasoning (numerical) |
| cw109a_c2 | Links Jobber JOB-4829 ($9,450.00 revenue) to unlinked QBO parts bill BILL-8812 for $4,120.00 (yielding $5,330.00 job gross profit). | Reasoning (numerical) |
| cw109a_c3 | Explains the $5,800.00 labor variance on BuildOps WO-9914 ($42,600.00 BuildOps loaded labor vs. $36,800.00 Spectrum base labor plus $5,800.00 in Spectrum's separate payroll burden pool). | Reasoning (numerical) |
| cw109a_c4 | Identifies late subcontractor bill BILL-9041 for $2,450.00 posted to Spectrum on closed work order WO-9921 (raising job cost from $18,900.00 to $21,350.00). | Reasoning (numerical) |
| cw109a_c5 | Warns that QBO's native Jobber connector drops custom job-number fields on deposits and vendor bills unless bridged via memo/PO parsing. | Reasoning (qualitative) |
| cw109a_c6 | Prohibits double-counting the $5,800.00 burden on WO-9914 when comparing BuildOps loaded labor ($42,600.00) against Spectrum. | Reasoning (qualitative) |
| cw109a_c7 | Requires reopening or posting a cost-pickup adjustment for late vendor bills (BILL-9041) arriving after a work order is marked closed in BuildOps. | Reasoning (qualitative) |
| cw109a_c8 | Computes combined Jobber gross revenue across JOB-4821 and JOB-4829 as $24,250.00. | Reasoning (qualitative) |
Part A/B: ClickUp Milestone Cutoff & Xero 10% Australian GST Capitalization Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw109b_c1 | Decomposes QBO invoice INV-7710 ($28,000.00 billed Sep 29) into $15,500.00 earned September retainer revenue and $12,500.00 uncompleted ClickUp milestone deferred to 2410 Unearned Revenue. | Reasoning (numerical) |
| cw109b_c2 | Decomposes Xero bill BILL-AU-304 ($68,200.00 GST-inclusive capital purchase) into $62,000.00 ex-GST Fixed Asset basis and $6,200.00 refundable GST Input Tax Credit. | Reasoning (numerical) |
| cw109b_c3 | Explains that because the ClickUp milestone on INV-7710 was not completed until October 2, recognizing the full $28,000.00 in September violates accrual cutoff (Dr Revenue $12,500.00 / Cr 2410 Unearned Revenue $12,500.00). | Reasoning (qualitative) |
| cw109b_c4 | Explains that under Australian GST rules in Xero, the 1/11th GST component ($6,200.00 on $68,200.00) is a recoverable Input Tax Credit in Account 820 GST and must NOT be capitalized into depreciable machinery cost. | Reasoning (qualitative) |
| cw109b_c5 | Computes the exact 10% GST math: $68,200.00 / 1.10 = $62,000.00 ex-GST asset cost and $68,200.00 - $62,000.00 = $6,200.00 GST credit. | Reasoning (qualitative) |
| cw109b_c6 | Identifies the overstatement of Fixed Assets ($6,200.00) and future depreciation if the GST-inclusive total ($68,200.00) is capitalized. | Reasoning (qualitative) |
| cw109b_c7 | Verifies ClickUp operational delivery timestamps against QBO invoice dates before certifying monthly agency revenue. | Reasoning (qualitative) |
| cw109b_c8 | Provides the exact Xero correcting entry on BILL-AU-304: Dr 820 GST Input Tax Credit $6,200.00 / Cr Fixed Assets - Plant & Equipment $6,200.00. | Reasoning (qualitative) |
Case 10 · Shopify Balance Overlaps, Square Payroll & Fleet Loans
Harbor Goods D2C & Metro Fleet Services · 43 Overlapping Shopify Rows + $46,830 Net Payroll + Unsplit Truck Loan
1. What Happened on the Books
An 80-row Shopify Balance export across two sub-accounts contained 43 duplicate overlapping rows when filtered by transaction date versus posted date. On the bank feed, a $46,830 net Square payroll withdrawal arrived without the payroll tax breakdown, and a $2,485 Ford truck loan check was expensed 100% to Truck Expense.
2. What Raw AI Gets Wrong
Raw AI imports all 80 Shopify rows without removing the 43 date overlaps, books the $46,830 net cash debit as total wages (missing employer taxes and withholdings), and expenses the entire $2,485 truck loan payment.
3. How Level Playbooks Fix It (100%)
Level deduplicates Shopify Balance exports by posted date ($1,033.24 true net movement), holds the $46,830 net Square debit until the full payroll register arrives, and splits the truck check into $1,940 loan principal and $545 interest.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Shopify Balance Source Intake Overlap & Native Payout Identity Guardrail
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw110a_c1 | Reports Account 3345 (sourceDocumentId 11088, importId 7) with 67 source rows, $979.67 net movement, and 36 overlapping rows. | Reasoning (numerical) |
| cw110a_c2 | Reports Account 3446 (sourceDocumentId 11096, importId 8) with 13 source rows, $53.57 net movement, and 7 overlapping rows. | Reasoning (numerical) |
| cw110a_c3 | Computes combined Shopify Balance intake totals across 3345 and 3446 as 80 source rows, $1,033.24 combined net movement, and 43 overlapping rows. | Reasoning (numerical) |
| cw110a_c4 | Confirms both imports have 0 payoutLinks and receiptState=retained_source_only. | Reasoning (qualitative) |
| cw110a_c5 | Enforces the guardrail that legacy candidate_count=1 cannot prove native payout identity for staging. | Reasoning (qualitative) |
| cw110a_c6 | Refuses to certify endingBalancesVerified or payoutIdentityVerified while receiptState is retained_source_only. | Reasoning (qualitative) |
| cw110a_c7 | Requires immutable exact-calendar reimport with explicit overlap tracking (36 and 7 overlapping rows) rather than silent deduplication. | Reasoning (qualitative) |
| cw110a_c8 | Separates posted-date accounting calendar basis from raw transaction-date timestamps. | Reasoning (qualitative) |
Part B: Square Partial Bank-Feed Observation Hold & Fleet Note Principal/Interest Split
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw110b_c1 | Identifies the 7 matched Square bank purchases ($48,250.00) and 1 offset deposit ($1,420.00) netting to $46,830.00. | Reasoning (numerical) |
| cw110b_c2 | Refuses to treat the 7 Square bank debits and 1 offset deposit ($46,830.00 net) as a complete gross/net/tax payroll register before acquiring the tenant Square payroll register. | Reasoning (qualitative) |
| cw110b_c3 | Identifies fleet note payment CHK-7741 for $2,485.00 erroneously expensed in full to 6310 Auto Loan Expense. | Reasoning (numerical) |
| cw110b_c4 | Splits CHK-7741 ($2,485.00) into $1,940.00 principal reduction (2610 Notes Payable - Vehicles) and $545.00 interest expense (7110 Interest Expense). | Reasoning (numerical) |
| cw110b_c5 | Quantifies the P&L expense overstatement from expensing theCHK-7741 principal reduction as $1,940.00. | Reasoning (numerical) |
| cw110b_c6 | Provides the correcting journal entry for CHK-7741: Dr 2610 Notes Payable - Vehicles $1,940.00, Dr 7110 Interest Expense $545.00, Cr 6310 Auto Loan Expense $2,485.00. | Reasoning (qualitative) |
| cw110b_c7 | Explains that an account balance alone does not establish fixed-asset depreciation terms without source asset schedules. | Reasoning (qualitative) |
| cw110b_c8 | Preserves operator review holds on unverified payroll and asset schedules rather than fabricating synthetic live supporting rows. | Reasoning (qualitative) |
Case 11 · $45M Apparel Year-over-Year P&L & Marketing Bridge
Heritage Menswear & Apparel Co. · $1.78M Sales Tax Netted in Revenue + $2.06M Google Ads Account Flip
1. What Happened on the Books
On a $45.3M apparel brand, a prior bookkeeper changed how accounts were grouped between 2024 and 2025: netting $1.78M of collected sales tax directly against 2025 Gross Sales, lumping $465K of import tariffs into Freight, and moving $2.06M of Google Ads between two marketing accounts mid-year. A QuickBooks auto-rule also stamped the wrong vendor name onto outgoing factory wires.
2. What Raw AI Gets Wrong
Unassisted AI checks only that bottom-line Net Income ties, missing that year-over-year revenue, gross margin, and CAC comparisons are completely distorted and trusting the wrong vendor names created by the QuickBooks bank rule.
3. How Level Playbooks Fix It (100%)
Level scans all 109 Chart of Accounts lines to catch mid-year account flips and sales-tax netting, bridges cash marketing dashboards to accrual GAAP ($45.31M revenue), reconciles $17.09M of factory PO wires to warehouse receipts, and restores true wire payees.
View Case Files, Task Prompts & Grading Checklist (14 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Multi-Period YoY P&L Line-Item Comparability & Within-Section Asymmetric Rollup Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw111a_c1 | Identifies $1,781,163.32 of YTD 2025 customer sales tax contra-revenue parked in Row 8 ($2,160,387.25) and nets it into Row 6 ($28,011,330.30 vs $44,908,260.42) so Row 8 reflects pure returns ($379,223.93 vs $441,309.31). | Reasoning (numerical) |
| cw111a_c2 | Identifies $465,200.00 of YTD 2025 Joyful Ability DDP freight/tariff wires lumped in Row 12 ($6,206,160.09) and reclassifies them to Row 13 so Row 12 is $5,740,960.09 vs $8,837,451.74 and Row 13 is $751,281.13 vs $2,475,012.68. | Reasoning (numerical) |
| cw111a_c3 | Identifies CHK-10442 ($200,818.47 to Stolze Printing Company, total $200,864.39 in Office:Printing) sitting in Row 38 ($278,896.63) and moves it to Row 28 ($935,238.79 vs $510,568.44 YTD 2025 before full-COA scan), reducing Row 38 to $78,032.24 vs $34,726.10. | Reasoning (numerical) |
| cw111a_c4 | Identifies $242,081.68 of 2026 Arizona 3PL (Wild West) checks (CHK-10118 through CHK-10519) in Row 36 ($504,327.17) and moves them to Row 33 ($4,381,208.20 vs $3,069,924.01 YTD 2025), reducing Row 36 to $262,245.49 vs $19,984.66. | Reasoning (numerical) |
| cw111a_c5 | Explains why single-period trial balance and section-total gates missed these 4 defects: each misbucketing occurred within the same statement section (Income, COGS, or OpEx), leaving Total Income, Total COGS, Total Expenses, and Net Income unchanged ($0.00 bottom-line impact). | Reasoning (qualitative) |
| cw111a_c6 | Enforces R49 within-section YoY comparability check across contra-revenue netting, bank-rule COGS sub-bucket lumping, and multi-3PL / same-vendor OpEx splits. | Reasoning (qualitative) |
Part B: Cash-Basis BI Tool (Marketing Dashboard) to Accrual GAAP Bridge & 21-Month PO Conservation Proof
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw111b_c1 | Reconciles Marketing Dashboard cash revenue ($47,012,519.65) less Shopify sales tax collected ($2,403,261.26) plus gateway fee gross-up and cutoff ($701,466.93) to GAAP Net Revenue of $45,310,725.32 ($0.00 unreconciled delta). | Reasoning (numerical) |
| cw111b_c2 | Reconciles Marketing Dashboard cash OpEx ($33,382,972.66) less Avalara sales tax liability remittances ($2,201,711.96) and working-capital card/payroll timing ($2,523,352.30) to GAAP Recurring OpEx of $28,657,908.40 ($0.00 unreconciled delta). | Reasoning (numerical) |
| cw111b_c3 | Proves 21-month factory PO cash-to-SKU conservation: $17,088,275.57 incurred factory purchases vs $16,834,890.20 accounted for ($13,182,818.70 shipped COGS + $3,652,071.50 inventory build), a 98.52% match with $253,385.37 (1.48%) normal shrinkage. | Reasoning (numerical) |
| cw111b_c4 | Explains that customer sales tax collected and remitted via Avalara is a Balance Sheet fiduciary pass-through (2150 Sales Tax Payable) and never P&L revenue or OpEx. | Reasoning (qualitative) |
Part C: Full-Population COA Scan, Cross-Year Marketing Regime Flip (<60% Dominance), Unpopulated Payees & Bank-Rule Cloning
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw111c_c1 | Identifies 87 Google Ads Purchase transactions ($1,309,396.44 YTD 2025, $2,059,657.36 FY 2025, $30,955.14 YTD 2026) booked to Acct 12 (Row 24 Paid Social) instead of Acct 258 (Row 26 Paid Search), aligning Row 24 to $7,313,479.68 vs $6,197,872.07 (-15.25% YoY) and Row 26 to $2,135,992.21 vs $2,971,758.84 (+39.13% YoY). | Reasoning (numerical) |
| cw111c_c2 | Identifies 2 unpopulated-Payee Stolze Printing Bill Pay checks (TXN-43261 $61,005.91 in Mar 2025 and TXN-52821 $82,161.48 in Apr 2026) sitting in Acct 258 (Row 26 SEM) plus 3 unpopulated-Payee Arandell Corporation checks (TXN-46670 $49,253.00, TXN-48385 $45,909.10, TXN-50732 $69,190.78, totaling $164,352.88 FY 2025) sitting in Acct 12, moving them to Acct 248 so Row 28 is $620,827.35 YTD 2025 ($1,056,499.39 FY 2025) vs $1,017,400.27 YTD 2026 (+63.88% YoY). | Reasoning (numerical) |
| cw111c_c3 | Identifies 2 unpopulated-Payee Klaviyo BofA compact ACH debits (TXN-52676 $1,566.75 and TXN-52717 $92,916.51, totaling $94,483.26 in Apr 2026) sitting in Acct 12 and moves them to Acct 223 so Row 27 is $366,392.87 vs $895,327.59 (+144.36% YoY), while Row 29 Total Advertising & Marketing remains $15,780,823.64 YTD 2025 and $18,134,882.22 YTD 2026 ($0.00 section-total change). | Reasoning (numerical) |
| cw111c_c4 | Diagnoses all 4 R50 root causes: (1) reactive spot-checking only reviewer-flagged rows instead of scanning 100% of active COA accounts (109/109), (2) <60% multi-year dominance blind spot (42.8% Acct 12 vs 57.2% Acct 258) combined with 'Google Advertising' vs 'GOOGLE *ADS' naming split, (3) unpopulated EntityRef on Bill Pay checks and BofA compact ACH ('ORIG_CO_NAME DES:... INDN:... CO ID:...'), and (4) QBO bank-rule wire Payee/DATE:240207 cloning poisoning ('ADTOK LTD' stamped over 'BNF:JOYFUL ABILITY'). | Reasoning (qualitative) |
Case 12 · 3PL Warehouse Count vs. Stale Shopify Export & Gift Cards
Heritage Menswear 3PL & Summit Field Ops · $10.15M Phantom Shopify Inventory + $170.4K Gift Card Cutoff Error
1. What Happened on the Books
A stale Shopify export reported 752,000 units ($13.84M) because discontinued product bundles were never zeroed out, whereas the physical 3PL warehouse count showed 200,452 units ($3.69M) plus $684K of paid factory deposits for unshipped goods. Separately, a Jan 15 ACH of $170,366 was actually the settlement for December holiday gift-card redemptions.
2. What Raw AI Gets Wrong
Raw AI books the $13.84M Shopify export onto the Balance Sheet (overstating inventory by $10.15M), books the Jan 15 gift-card payout as January sales instead of December activity, and flags a contractor job as over-billed because an approved $14,200 change order wasn't linked.
3. How Level Playbooks Fix It (100%)
Level anchors Balance Sheet inventory to the certified 3PL physical warehouse count ($3.69M), puts the $684K of unreceived factory deposits into Prepaid Inventory, accrues the $170,366 holiday gift-card payout in December, and links the $14,200 change order.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: 3PL Physical Inventory vs. Stale Shopify Export & Factory PO Advance Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw112a_c1 | Identifies that the unadjusted 9/28 Shopify export reports 752,000 units ($13,836,800.00 at $18.40 SKU cost), inflated by 230,000 phantom units at closed PP-AZ Warehouse ($4,232,000.00) and 493,000 unadjusted cumulative units at Maryland Warehouse ($9,071,200.00). | Reasoning (numerical) |
| cw112a_c2 | Computes verified GAAP Ending Inventory as 200,452 units and $3,688,521.00 ($3,154,921.00 across 171,452 sellable units at Eastern Fulfillment MD 3PL plus $533,600.00 across 29,000 active retail store units). | Reasoning (numerical) |
| cw112a_c3 | Quantifies the $10,148,279.00 inventory overstatement (551,548 phantom units) avoided by using the Eastern Fulfillment 3PL physical count ($3,688,521.00) instead of the raw Shopify export ($13,836,800.00). | Reasoning (numerical) |
| cw112a_c4 | Computes total September unreceived factory PO deposits as $684,062.62 (WIRE-9901 for $220,000.00 to KNT, WIRE-9904 for $325,000.00 to Bohao, and WIRE-9909 for $139,062.62 to Spring Air & Henrial). | Reasoning (numerical) |
| cw112a_c5 | Retains the $684,062.62 of Spring 2027 / Q4 factory advances in 1310 Prepaid Inventory Deposits rather than expensing to COGS or adding to on-hand 3PL inventory because goods were unreceived and Bohao's final balance was not paid until 2026-10-05. | Reasoning (qualitative) |
| cw112a_c6 | Explains why raw Shopify inventory exports cannot be booked directly to the Balance Sheet without 3PL physical warehouse reconciliation and unit-cost mapping. | Reasoning (qualitative) |
| cw112a_c7 | Separates on-hand sellable 3PL/store inventory ($3,688,521.00) from in-production vendor deposits ($684,062.62) on the CFO/COO Balance Sheet. | Reasoning (qualitative) |
| cw112a_c8 | Enforces the COO inventory conservation gate before locking YTD landed COGS. | Reasoning (qualitative) |
Part B: Gift Card SPV (CRST Gift Card SPV LLC) Prior-Period ACH Cutoff & COO Contract-Adjusted Job Velocity
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw112b_c1 | Identifies TXN-51989 ($170,366.01 on 2026-01-15 with ACH memo 'DES:CASH CONC ID:CRST_M_251231') as a prior-period December 2025 holiday gift card settlement sweep to Retail Gift Card Clearing SPV (CRST Gift Card SPV LLC). | Reasoning (numerical) |
| cw112b_c2 | Identifies that CRST Gift Card SPV LLC had $244,500.00 of 2026 ACH outflows misbooked to 6210 Brand Marketing and $29,523.94 of Feb/Mar net redemption inflows misbooked as credits to COGS. | Reasoning (numerical) |
| cw112b_c3 | Reclassifies CRST Gift Card SPV LLC gift card issuance sweeps ($170,366.01 on TXN-51989 and $244,500.00 total outflows) and net redemption inflows ($29,523.94) to 2420 Gift Card Liability / Clearing rather than P&L Brand Marketing or COGS. | Reasoning (qualitative) |
| cw112b_c4 | Computes the contract-adjusted job_amount on JOB-9104 as $82,700.00 ($68,500.00 original contract plus $14,200.00 approved change order CO-2). | Reasoning (numerical) |
| cw112b_c5 | Computes the true collection rate on JOB-9104 ($74,430.00 collected) as 90.00% against the $82,700.00 contract-adjusted job_amount, versus the distorted 108.66% rate against the unadjusted $68,500.00 base contract. | Reasoning (numerical) |
| cw112b_c6 | Enforces the January prior-period ACH memo cutoff detector ('251231' / 'CRST_M_251231') on outflows >= $10,000.00 so prior-year liabilities are not expensed in the new fiscal year. | Reasoning (qualitative) |
| cw112b_c7 | Enforces the cross-section counterparty split detector when the same counterparty (CRST Gift Card SPV LLC) hits Marketing, COGS, and Uncategorized Income across months. | Reasoning (qualitative) |
| cw112b_c8 | Requires linking approved change orders ($14,200.00) into job_amount across COO payment and sales velocity tables so collection % never exceeds 100% on active jobs. | Reasoning (qualitative) |
Case 13 · NY/NJ Restaurant Sales Tax & Delivery App Double-Count
Roast & Ritual NY/NJ Cafes LLC · $11,985 Double-Paid Delivery App Tax + $9,120 Cross-Quarter Tax Error
1. What Happened on the Books
Across a NY/NJ cafe group, Stream POS pushed $142,800 of UberEats, DoorDash, and Grubhub orders into QuickBooks with $11,985.40 of sales tax attached to Sales Tax Payable, even though the delivery apps already remit that tax to the state by law. In addition, a $9,120.50 Q4 tax payment that cleared the bank in January was misposted against Q1 taxes.
2. What Raw AI Gets Wrong
Unassisted AI reconciles sales tax by bank clearing date instead of tax filing quarter, misses a $100.20 portal overpayment credit, and double-pays the $11,985.40 of UberEats, DoorDash, and Grubhub sales tax to the state.
3. How Level Playbooks Fix It (100%)
Level separates delivery-app Marketplace Facilitator tax ($11,985.40) from in-store POS sales tax ($18,420.15) so delivery tax is never paid twice, matches the $9,120.50 January bank debit to Q4's tax return, and tracks NY and NJ filings separately by store.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: State Sales Tax Portal Cross-Quarter Misposting, Transposition Credit & Statutory Cadence
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw113a_c1 | Verifies that every Q3 2026 month at Palisades NJ stayed under the $2,200.00 monthly benchmark ($2,190.67 July, $2,160.15 August, and $1,735.64 September, with $6,070.46 Q3 Form ST-50 total tax due after the Q3 TapMango adjustment). | Reasoning (numerical) |
| cw113a_c2 | Identifies that TXN-26232 ($2,242.24 paid on 2026-08-21 for July ST-51) contained a $100.20 transposition overpayment above July's $2,142.04 POS tax collected and was credited in full against Q3. | Reasoning (numerical) |
| cw113a_c3 | Explains that the $3,828.22 Q3 ST-50 balance paid on TXN-26294 (2026-10-21) equals $6,070.46 total Q3 tax less the $2,242.24 July credit, covering two months combined ($3,879.79 net for August + September less the July overpayment) because no August ST-51 was paid in September. | Reasoning (numerical) |
| cw113a_c4 | Reconciles Q1 2026 ($4,585.02 calculated vs. $4,585.03 paid) and Q2 2026 ($6,564.21 calculated vs. $6,564.25 paid) within pennies ($0.01 in Q1 and $0.04 in Q2). | Reasoning (numerical) |
| cw113a_c5 | Identifies that TXN-26051 ($1,525.45 paid on 2026-02-23 for January) was misposted to Q2 2026 on the NJ portal, leaving only TXN-26079 ($1,263.07) in Q1 and forcing TXN-26107 (2026-04-20 Q1 return) to pay $3,321.96 at once for January + March. | Reasoning (numerical) |
| cw113a_c6 | Identifies that the $1,525.45 cross-quarter credit sitting in Q2 reduced TXN-26139 (2026-05-20) to $471.02 (totalling $1,996.47 for April), followed by TXN-26169 ($2,316.65) and TXN-26201 ($2,251.13). | Reasoning (numerical) |
| cw113a_c7 | Proves that 2025 full-year Palisades NJ sales tax of $25,106.98 (on $497,461.48 POS net sales) is below New Jersey's $30,000.00 prior-year threshold (N.J.A.C. 18:24-11.2) for mandatory monthly ST-51 prepayments. | Reasoning (numerical) |
| cw113a_c8 | Requires 3-way reconciliation across POS calculated tax, bank EFT debits, and state portal period-detail credits rather than matching by bank cash date alone, and transitions the entity to quarterly-only ST-50 filing going forward. | Reasoning (qualitative) |
Part B: Multi-State 3rd-Party Delivery (Stream POS) Marketplace Facilitator Bifurcation & Location Isolation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw113b_c1 | Verifies that Harbor Wall St NY (LOC-WALL-NY) July POS net sales of $52,272.15 ($157,813.56 Q3 total) contain $0.00 of Uber Eats, DoorDash, Grubhub, or ClassPass marketplace orders. | Reasoning (numerical) |
| cw113b_c2 | Computes Palisades NJ (LOC-PAL-NJ) Q3 Form ST-50 Line 1 Gross Receipts as $111,787.31 ($39,815.72 July + $39,188.78 August + $32,782.81 September). | Reasoning (numerical) |
| cw113b_c3 | Computes total Q3 Line 2 Non-Taxable Deductions as $20,157.79 ($6,541.15 zero-tax Stream Uber Eats NJ sales plus $13,616.64 of exempt packaged coffee beans, unheated off-premises pastries under the 75% rule, and eco bags/classes), leaving $91,629.52 Taxable Receipts. | Reasoning (numerical) |
| cw113b_c4 | Verifies from the May and June payout statements that Uber Eats NJ withheld $410.83 of NJ Marketplace Facilitator Tax ($227.26 in May and $183.57 in June) and rang into Square Stream at $0.00 tax. | Reasoning (numerical) |
| cw113b_c5 | Proves that deducting 100.00% of the $6,541.15 zero-tax Stream sales ($2,652.50 July, $1,975.25 August, $1,913.40 September) on Line 2 prevents double-paying sales tax on Uber Eats NJ. | Reasoning (numerical) |
| cw113b_c6 | Identifies that DoorDash and Grubhub in NJ (and Uber Eats in NY) withheld $0.00 tax on their payout statements and passed collected tax to the merchant, leaving $3,952.80 of taxed Stream orders ($1,472.90 July, $1,345.35 August, $1,134.55 September) in Palisades NJ taxable receipts. | Reasoning (numerical) |
| cw113b_c7 | Prohibits treating an order-router/aggregator channel label (Stream) as blanket proof that all routed orders are marketplace-facilitator remitted without platform-by-state payout statement verification. | Reasoning (qualitative) |
| cw113b_c8 | Enforces location-level POS isolation so delivery channel deductions at routed stores (Palisades NJ and Bayside Queens NY) are never extrapolated to non-routed stores (Harbor Wall St NY). | Reasoning (qualitative) |
Case 14 · D2C Inventory Freight Double-Count & Return Credit Audit
Crestline Menswear & Apparel D2C · $2.19M Freight Double-Count in COGS + $340K Check Misclassification
1. What Happened on the Books
When a D2C brand switched from periodic inventory ($17.87/unit) to automated Shopify perpetual COGS ($21.40/unit across 621,480 physical units), gross margin appeared to drop by $2.19M (546 bps) because ~$4.11/unit of inbound freight was baked into Shopify's SKU cost table while freight bills were also expensed directly on the P&L. A broken Excel VLOOKUP also mapped 215 warehouse postage checks ($339,987) into packaging COGS and subtracted return credits twice.
2. What Raw AI Gets Wrong
Raw AI accepts the inflated $21.40/unit Shopify COGS at face value (double-counting $2.19M of freight), trusts the broken VLOOKUP on the $339,987 of postage checks, includes 53,417 virtual non-physical items in unit counts, and misses that refurbished return credits were subtracted twice (179.6% of returned cost).
3. How Level Playbooks Fix It (100%)
Level anchors unit cost to prior-year physical inventory ($17.87/u) and factory PO invoices ($17.76/u) to remove the $2.19M freight double-count, reclasses the $339,987 of warehouse checks to Outbound Postage, strips virtual SKUs, and caps return inventory recovery credits properly.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Prior-Year Periodic Inventory Unit-Cost Anchor vs. Shopify Embedded Shipping Double-Count
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw114a_c1 | Computes YTD Sep 2025 GAAP Periodic Inventory delivered unit cost as $17.87/u ($1,650,000.00 Beg Inv + $7,606,340.76 Net Purchases - $3,457,874.00 End Inv = $5,798,466.76 Product COGS + $693,774.46 Freight/Tariffs = $6,492,241.22 across 363,235 physical units) and FY 2025 delivered cost as $19.69/u ($11,163,158.87 across 566,965 physical units). | Reasoning (numerical) |
| cw114a_c2 | Identifies that provisional YTD Sep 2026 COGS ($16.72/u Shopify SKU base + $4.68/u separate Freight/Tariffs = $21.40/u, or $11,312,464.42) double-counts ~$4.11/u of embedded shipping already baked into legacy Polos ($15.00) and Sweaters ($23.00) in Shopify's item master. | Reasoning (numerical) |
| cw114a_c3 | Aligns YTD Sep 2026 to management's verified ex-shipping PO base cost of $12.61/u ($6,664,296.73 in Row 12 across 528,493 physical units) plus $5.15/u inbound shipping & DDP tariffs ($2,721,738.95 in Row 13) for $17.76/u Delivered Garment COGS ($9,386,035.68, matching YTD 2025 $17.87/u within $0.11/u) and $8,647,410.99 Sep 30, 2026 Ending Inventory. | Reasoning (numerical) |
| cw114a_c4 | Explains why the 12 monthly 2025 periodic inventory JEs (COL25-PERINV-01..12) sum to $0.00 across Full-Year 2025 (pure monthly smoothing) and why 2025 periodic inventory unit economics ($17.87/u YTD) serves as an automatic self-catching anchor against 2026 Shopify landed-cost double-counting. | Reasoning (qualitative) |
Part B: Customer Workbook VLOOKUP Formula Contamination & Sequential Check-Series COGS Drift
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw114b_c1 | Identifies 57 Apr-May 2026 Maryland warehouse (WH2) fulfillment worker checks (Check 10187..10283 totaling $70,769.25) where manual label 'Warehouse Labor' was misrouted by a broken customer spreadsheet VLOOKUP ('Boxes/Mailers') into Acct 222 Packaging COGS, plus 158 WH2 checks (Check 10166..10593 totaling $269,217.76) in Acct 95 Cost of labor - COGS. | Reasoning (numerical) |
| cw114b_c2 | Reclassifies all 215 WH2 warehouse fulfillment checks ($339,987.01 total) out of COGS into OpEx Acct 279 Freight Out (P&L Row 33 Outbound Shipping, Postage & 3PL Fulfillment), reducing Row 15 Packaging COGS to $149,584.64 (0.33% of Net Revenue vs 0.35% YTD 2025) and Row 16 Labor COGS to $0.00 (matching $0.00 in 2025). | Reasoning (numerical) |
| cw114b_c3 | Verifies post-reclass YTD Sep 2026 Total COGS (Row 17) is $9,535,620.32 (21.04% of Net Revenue), Gross Profit (Row 19) is $35,787,031.34 (78.96% Gross Margin), Row 33 Outbound Shipping, Postage & 3PL Fulfillment is $4,790,810.04 (10.57% of Net Revenue, matching FY 2025 $4,848,901.32 = 10.57% to the basis point), Total Expenses (Row 42) is $29,690,425.97, and Net Operating Income ($6,096,605.37) / Net Income ($6,095,011.60) / Normalized EBITDA ($6,849,264.89) have $0.00 change. | Reasoning (numerical) |
| cw114b_c4 | Enforces R51 / R57 customer data hygiene: never blindly trust derived VLOOKUP columns in client spreadsheets when raw manual labels ('Warehouse Labor') and payment mediums (sequential paper checks Check 10xxx) contradict the target account ('Packaging'). | Reasoning (qualitative) |
Part C: Counterparty Top-Down COGS % of MSRP vs. Retained Pre-Discount MSRP & Physical Unit Bridge
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw114c_c1 | Reconciles raw YTD Sep 2026 Shopify units: 674,897 gross units ordered (620,850 physical garments + 54,047 virtual items) less 92,987 returned units (92,361 returned physical garments = 14.88% return rate) equals 581,910 net items sold (528,493 net physical garments + 53,417 virtual items: 16,666 Swap Protect, 33,900 Digital Style Guides, and 2,851/2,855 Gift Cards). | Reasoning (numerical) |
| cw114c_c2 | Proves that Baxter's 16.7% COGS rate equals $17.76/u delivered garment cost divided by ~$106.35 full retail MSRP, and that multiplying 16.7% by pre-return Gross Sales ($64,711,606.69 -> $10,806,838.32) overstates COGS by +$1,239,231.95 by charging COGS on 92,361 returned physical garments (-$7,420,550.60 returns). | Reasoning (numerical) |
| cw114c_c3 | Shows that applying 16.7% to Retained Pre-Discount MSRP ($57,291,056.09 = $64,711,606.69 Gross Sales - $7,420,550.60 Returns) yields $9,567,606.37, reconciling within $31,986.05 (0.3%) of bottom-up Total Landed COGS ($9,535,620.32 = $9,386,035.68 delivered garments + $149,584.64 packaging). | Reasoning (numerical) |
| cw114c_c4 | Explains why any COGS % benchmarked against full pre-discount MSRP ($17.76 / $106.35 = 16.7%) must be applied to Retained Pre-Discount MSRP (Gross Sales less Returns) rather than pre-return Gross Sales or post-discount Net Sales ($47,997,651.07). | Reasoning (qualitative) |
Part D: Double-Subtracted Refurbished Return Credits & Cross-Year Return Disposal Write-Off Accrual Parity
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw114d_c1 | Detects that subtracting Row 21 (-$986,723.68 for 70% restocked returns: 88,834 returned units x 70% x $95 AUR x 16.7% COGS) below Row 20 ($9,567,606.37 = 16.7% x ($64,711,606.69 Gross Sales - $7,420,550.60 Returns)) double-subtracts return COGS (-$1,239,231.95 + -$986,723.68 = -$2,225,955.63, or 179.6% of return COGS = $25.05/returned shirt), understating COGS at $8,580,882.69 and overstating EBITDA by +$986,723.68. | Reasoning (numerical) |
| cw114d_c2 | Proves that if Row 21 (-$986,723.68 for 70% restocked returns) is retained as a separate line, Row 20 must be 16.7% x Gross Sales ($64,711,606.69 = $10,806,838.32) so net COGS equals $9,820,114.64 ($9.82M), which is +$252,508.27 (+$284,494.32 vs $9,535,620.32 P&L COGS) higher than 100%-restock COGS because the remaining 30% of un-restockable/disposed returns stay in COGS as an immediate inventory write-off under GAAP ASC 330-10-35. | Reasoning (numerical) |
| cw114d_c3 | Audits Acct 152 (Sales Returns & Allowances = -$432,309.31 YTD 2026: EasyPost $166,000.00, Happy Returns $158,955.75 at $2.60/item refurbishment fee, Loop Returns $98,603.84, allowances $8,749.72) and proves that 2025 periodic COGS ($9,978,035.44 anchored to the Dec 31, 2025 physical count) already captured $316,608.51 (~18,580 disposed/shrinkage units = ~19.5%-20% of 95,186 FY 2025 returned units) whereas 2026 YTD COGS ($9,535,620.32 = 528,493 net kept units x $17.76 + $149,584.64 packaging) currently assumes 0% return disposal (100% restock). | Reasoning (numerical) |
| cw114d_c4 | Enforces R51 / R59 return restock vs. disposal parity: (1) never subtract both 100% of returns in the base COGS formula and a separate 70% refurbished-return credit, and (2) when prior-year physical inventory count captured ~20% return disposal write-offs ($316.6K in 2025), flag the missing current-year return disposal write-off accrual (~$253K-$328K at 20%-30% disposal) under GAAP ASC 330-10-35. | Reasoning (qualitative) |
Case 15 · Restoring Deleted CRM Invoices & Reconciling Payments
Summit Roofing & CortexMed Surgical · $78,858 Deleted CRM Invoices + $12,335 Deposit Offset Entries
1. What Happened on the Books
Eight historical customer invoices totaling $78,857.71 were active in the Roofr CRM subledger but had been accidentally deleted from QuickBooks during an earlier cleanup, leaving $19,092.24 of open receivables missing and four customer deposits ($12,335.12) offset by temporary manual journal entries.
2. What Raw AI Gets Wrong
Unassisted AI re-imports the 8 deleted Roofr invoices ($78,857.71) into QuickBooks without reversing the 4 temporary deposit journal entries ($12,335.12) or re-linking prior customer payments, double-counting revenue and overstating open receivables.
3. How Level Playbooks Fix It (100%)
Level restores all 8 deleted CRM invoices ($78,857.71), reverses the 4 temporary deposit offset entries ($12,335.12), and re-links historical customer payments across month-end cutoffs to arrive at the exact $19,092.24 open receivable balance.
View Case Files, Task Prompts & Grading Checklist (8 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Historical Subledger Invoice Restoration, Offset JE Linking & Cross-Period Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw115a_c1 | Computes total gross revenue across the 8 restored Roofr subledger invoices (RF-545650 through RF-545687 across commit runs CR-3667, CR-3679, CR-3680) as $78,857.71, bifurcated into $1,850.00 August 2026 (RF-545650 $1,200.00 + RF-545651 $650.00) and $77,007.71 September 2026. | Reasoning (numerical) |
| cw115a_c2 | Computes total remaining open Accounts Receivable balance across the restored invoices as $19,092.24, consisting of RF-545685 ($8,964.10 open on $11,952.13 billed) and RF-545673 ($10,128.14 open on $13,504.18 billed). | Reasoning (numerical) |
| cw115a_c3 | Computes total offsetting Journal Entries across all 4 linked payment adjustments as $12,335.12, and isolates the September 2026 offset JEs (JE-3550 $4,941.46 -> PAY-3551, JE-3581 $3,504.74 -> PAY-3582, JE-3583 $3,376.04 -> PAY-3584) at $11,822.24 vs. October 2026 JE-3579 ($512.88 -> PAY-3580 on 2026-10-09). | Reasoning (numerical) |
| cw115a_c4 | Enforces the period-cutoff and AR payment-linking guardrail: JE-3579 ($512.88 dated 2026-10-09) must be recognized in October 2026 rather than backdated into the reopened September 2026 close, and each offset JE must be linked to its corresponding ReceivePayment (PAY-3551, PAY-3580, PAY-3582, PAY-3584) so Customer AR and Roofing Revenue are not double-counted. | Reasoning (qualitative) |
Part B: Commit-Run Ledger-Activity Diff Audit: JE-Neutralized Inbox Holds & Period-Lock Chart of Accounts Split
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw115b_c1 | Reconciles the 210-item September close posting batch into 197 direct QBO-synced postings (93.81%) and 13 offsetting-JE-resolved rows (6.19%), and requires rejecting the 13 JE-neutralized inbox decisions so suspense accounts are not double-cleared. | Reasoning (numerical) |
| cw115b_c2 | Reconciles the 30 historical Chart of Accounts ledger revisions into 5 October 2026 open-period revisions synced live to QBO and 25 Aug-Sep 2026 revisions (20 Purchases + 5 Gusto JEs) applied in the synced accounting ledger and held from live QBO write due to the 09/30/2026 QBO closing-date lock (fault 6200). | Reasoning (numerical) |
| cw115b_c3 | Computes total rebucketed leaf Chart of Accounts spend across the 4 forensic buckets as $37,918.04 ($23,310.75 Company Offsite Expenses 214 + $6,940.64 Event Travel & Lodging 247 + $2,866.65 Promotional Items 222 + $4,800.00 Marketing Consulting), leaving $0.00 in Uncategorized Expense and $0.00 in generic parent Office Expenses. | Reasoning (numerical) |
| cw115b_c4 | Enforces the Mirror-DB-first and period-lock governance rule: never bypass QBO fault 6200 by mutating closed-period history without accountant unlock; persist the 25 Aug-Sep revisions in the mirror ledger for accurate CFO reporting while syncing the 5 October open-period revisions live. | Reasoning (qualitative) |
Case 16 · Medical Device Batch Manufacturing & Lab-Test Billing
Precision MedDevice Contract Manufacturing LLC · Unbilled Sterile Lab Tests + Missing $0 Scrap Lines Across 11,044 Files
1. What Happened on the Books
Across two finished medical-device batches (17 units at $285 and 24 good units plus 3 scrapped units at $310), extra sterile lab test samples ($145 endotoxin test and $275 sterility test) were written only on paper batch logs rather than added to the customer invoice, while an 11,044-file quality folder mixed 6,586 real release packets with temporary scan files.
2. What Raw AI Gets Wrong
Raw AI bills only the summary finished-goods count, misses the paper-logged lab test charges and material pass-throughs, drops required $0 scrap tracking lines, and counts temporary scan files as shippable batches.
3. How Level Playbooks Fix It (100%)
Level ties every customer invoice back to the batch production logs (including $0 scrap lines and sterile lab test add-ons) before sending the bill and filters the 11,044-file folder down to the 6,586 complete release packets.
View Case Files, Task Prompts & Grading Checklist (8 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Medical Device CMO LHR-to-Invoice Quantity, Testing Add-On & Sub-Lot Material Reconciliation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw116a_c1 | Reconciles Lot 011926B (NeuroVasc Corp): 17 FG units at $285.00 ($4,845.00) plus paper-only LHR testing pulls of 3 LAL samples at $145.00 ($435.00) and 2 LotRT samples at $210.00 ($420.00) for a true billable total of $5,700.00, catching an $855.00 (15.00%) ERP under-billing variance. | Reasoning (numerical) |
| cw116a_c2 | Reconciles Lot 070826H (VentricFlow Inc): 24 Good FG units at $310.00 ($7,440.00), 3 Scrap units on a mandatory $0.00-rate line (27 total build units), plus $1,323.00 of billable CMO-supplied sub-lot materials (RJ-45110-1 54 units at $18.50 = $999.00 and RJ-45110-2 27 units at $12.00 = $324.00) while excluding $1,215.00 of customer-consigned CMP-99012 hubs, for a total invoice of $8,763.00. | Reasoning (numerical) |
| cw116a_c3 | Reconciles Lot 031826A (SinglePass Med) across base LHR and Rework PD 157: 18 initial good FG + 1 rework-recovered FG = 19 net billable FG units at $260.00 ($4,940.00) and 1 final scrap unit, catching a -$260.00 over-billing adjustment versus the 20-unit ($5,200.00) unadjusted ERP draft. | Reasoning (numerical) |
| cw116a_c4 | Enforces the CMO source-packet governance rule: never certify or release a customer invoice from ERP headline quantities alone without pinning the SHA-256 LHR/CoC packet, reading sibling sub-lot material packets (RJ-45110-1/2), and reconciling companion Rework/PD packets. | Reasoning (qualitative) |
Part B: QC Server Archive Hygiene, Partial-Temp & IFU Exclusion, and Lot-Locator Governance
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw116b_c1 | Audits the 11,044-file QC server index into 4,433 primary Work Order packets (40.14%) and 2,153 Receiving Inspection / Sub-Lot Material packets (19.49%), totaling 6,586 core manufacturing evidence packets. | Reasoning (numerical) |
| cw116b_c2 | Identifies and excludes 1,161 non-LHR noise files across the QC server: 590 partial rsync temp files (.part.) and 571 Instructions-for-Use (IFU) product insert PDFs (10.51% combined noise rate across the 11,044 files). | Reasoning (numerical) |
| cw116b_c3 | Quantifies the 431 special-routing lot packets across the archive: 286 alpha-prefixed Bosstent lots (C-shape), 120 OQ/PQ/First-Article validation lots, and 25 Rework/Planned Deviation companion packets. | Reasoning (numerical) |
| cw116b_c4 | Enforces fail-closed lot-locator hygiene: exclude .part. temp files so valid lots do not fail with false-positive duplicate ambiguity, block IFU inserts from invoice attachments, restrict year-folder pruning to 20xx so 4-digit part folders (3001) are never skipped, and require human review when a Rework/PD packet is present. | Reasoning (qualitative) |
Case 17 · Employee Stock Comp, Card Transfers & Negative Vendor Balances
Aether MedTech Systems Inc. · $888.6K Non-Cash Stock Comp Treated as Cash + -$7,883 Negative Vendor Bill
1. What Happened on the Books
October non-cash employee stock option expense ($33,310.14 monthly; $888,590.41 year-to-date) and a $15,000 internal shift between Prepaid Expenses and Corporate Cards ($0 actual bank cash impact) threw off the cash-flow report, while Accounts Payable showed a -$7,882.69 negative balance on one supplier.
2. What Raw AI Gets Wrong
Unassisted AI treats non-cash employee stock options or internal card-to-prepaid transfers as real cash leaving the bank, and blindly moves the -$7,882.69 negative supplier balance into Prepaid Expenses without checking if a vendor bill was simply missing.
3. How Level Playbooks Fix It (100%)
Level keeps non-cash stock compensation ($888,590.41 YTD) and internal card shifts at $0 bank cash impact, and checks negative supplier balances against missing vendor invoices and credits before moving anything.
View Case Files, Task Prompts & Grading Checklist (10 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Cash Flow Intra-Operating Clearing Conservation & Zero-Net Equity SBC Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw117a_c1 | Preserves the -$15,000.00 prepaid and +$15,000.00 card operating reconciliation effects; combined cash effect is $0.00. | Reasoning (numerical) |
| cw117a_c2 | Derives October compensation $33,310.14 and YTD compensation $888,590.41 from the compensation journals. | Reasoning (numerical) |
| cw117a_c3 | Eliminates the $770.00 phantom non-cash equity add-back and -$770.00 Common Stock financing offset caused by a same-month reversed compound entry. | Reasoning (numerical) |
| cw117a_c4 | Explains that intra-section Operating balance-sheet clearings (such as credit card payment clearing into AmEx and Prepaid Expenses) must not be stripped as cross-section non-cash reclassifications. | Reasoning (qualitative) |
| cw117a_c5 | Excludes the balanced no-cash financing packet without account-period netting that could erase genuine compensation in another journal. | Reasoning (qualitative) |
Part B: Negative Vendor AP Investigation (Sign Is Not Prepaid Evidence), Remittance Cutoff & Itemized Accruals
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw117b_c1 | Investigates negative vendor AP $7,882.69 using invoices, credits and payments; its sign does not establish a prepaid asset. Other balances total $21,380.00. | Reasoning (numerical) |
| cw117b_c2 | Excludes the $9,000.00 vendor invoice already paid on October 27 (Purchase 12071) from month-end accrued expenses. | Reasoning (numerical) |
| cw117b_c3 | Derives invoice candidates $122,095.61 versus ending accrued GL $123,692.61 and retains unexplained inherited $1,597.00; candidate totals are not a final supported close balance. | Reasoning (numerical) |
| cw117b_c4 | Admits vendor invoices containing 'email the payment confirmation to' remittance instructions and separates non-P&L patent accruals so unpaid patent invoices do not distort Investing cash outflows. | Reasoning (qualitative) |
| cw117b_c5 | Requires formula-based subledger totals, source period review and an actual separate review receipt; an assigned reviewer remains pending rather than fabricated as complete. | Reasoning (qualitative) |
Case 18 · Biweekly Payroll Crossing Month-End & Owner Withdrawals
Ironwood Mechanical & Trades LLC · $12,312 Payroll Reversal Used Twice + $5,050 Personal Owner Spend in Expenses
1. What Happened on the Books
Two October 2 payroll runs paid $19,710.00 for work crews actually performed in late September ($18,250 wages + $1,460 employer tax) alongside a $12,312.00 prior-month payroll accrual reversal, while $5,050.00 of personal owner withdrawals sat inside Travel and Uncategorized Expenses.
2. What Raw AI Gets Wrong
Raw AI subtracts the $12,312.00 prior-month payroll reversal twice across both October pay runs (understating labor cost) and leaves the $5,050.00 of personal owner withdrawals inside business operating expenses.
3. How Level Playbooks Fix It (100%)
Level applies the prior-month payroll reversal strictly once to record the exact $7,398.00 September labor adjustment and moves all $5,050.00 of personal withdrawals out of expenses into Owner Draws.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Cross-Month Payroll Service-Period Cutoff, Single-Use Estimate Consumption & Provider Funding Reconciliation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw118a_c1 | Identifies prior-period reversal pair JE-2026-0930 / JE-2026-1001 ($12,312.00 total: $11,400.00 wages in 5110 and $912.00 employer tax in 5130) and consumes it once against PR-2026-1002A (8 of 10 Mon-Fri weekdays = 80.00% in 2026-09). | Reasoning (numerical) |
| cw118a_c2 | Computes combined 2026-09 service-period payroll across PR-2026-1002A and PR-2026-1002B as $18,250.00 wages and $1,460.00 employer tax ($19,710.00 total), isolating the unaccrued $7,398.00 2026-09 share on PR-2026-1002B ($6,850.00 wages and $548.00 employer tax). | Reasoning (numerical) |
| cw118a_c3 | Refuses to reuse JE-2026-0930 across both overlapping runs and records the comparative prior-period cutoff true-up (2026-09: Dr 5110 $6,850.00, Dr 5130 $548.00, Cr 2120 $7,398.00; 2026-10: Dr 2120 $7,398.00, Cr 5110 $6,850.00, Cr 5130 $548.00) to remove $7,398.00 of overstated 2026-10 payroll expense. | Reasoning (qualitative) |
| cw118a_c4 | Derives the 60.00% (6 of 10 Mon-Fri weekdays: Oct 23 and Oct 26-30 vs. Nov 2-5) 2026-10 service-period proration on straddling run PR-2026-1104 ($28,500.00 gross wages and $2,450.00 employer tax). | Reasoning (numerical) |
| cw118a_c5 | Records the 2026-10 straddling payroll accrual on PR-2026-1104 via Dr 5110 Direct Field Labor $17,100.00, Dr 5130 Employer Payroll Taxes $1,470.00, and Cr 2120 Accrued Payroll & Payroll Taxes $18,570.00. | Reasoning (numerical) |
| cw118a_c6 | Excludes the $4,120.00 employee tax withholding on PR-2026-1104 from employer tax expense so total run employer cost is $30,950.00 rather than $35,070.00. | Reasoning (numerical) |
| cw118a_c7 | Verifies that run employer tax expense on PR-2026-1104 is $2,450.00 rather than the $6,570.00 combined tax draft. | Reasoning (numerical) |
| cw118a_c8 | Treats provider notice PAY-2026-1104 ($30,950.00 scheduled 2026-11-06 funding) as an unpaid month-end accrual paired with a 2026-11-01 reversal rather than a settled 2026-10 bank cash debit. | Reasoning (qualitative) |
Part B: Client-Precedent Owner Draw Classification, Unstarted Deposit Liability & Unbilled WIP Recognition
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw118b_c1 | Reclassifies TXN-88410 ($3,400.00 from 6999, 8 of 8 = 100.00% precedent) and TXN-88425 ($1,650.00 from 6420, 6 of 6 = 100.00% precedent) totaling $5,050.00 via Dr 3100 Owner Draws $5,050.00, Cr 6999 $3,400.00, and Cr 6420 $1,650.00. | Reasoning (numerical) |
| cw118b_c2 | Preserves TXN-88440 ($4,280.00 on JOB-4102) in 5210 Job Materials COGS based on 14 of 14 (100.00%) prior approved job-material purchases. | Reasoning (numerical) |
| cw118b_c3 | Keeps 2190 Due to Owner at $5,800.00 (JE-2026-0915) instead of $9,200.00 by routing TXN-88410 ($3,400.00) to 3100 Owner Draws. | Reasoning (numerical) |
| cw118b_c4 | Reclassifies unstarted mobilization deposit DEP-5501 on JOB-4105 (0.00% complete on an $84,000.00 contract) via Dr 4100 Commercial HVAC Revenue $42,000.00 and Cr 2450 Customer Deposits & Unearned Revenue $42,000.00. | Reasoning (numerical) |
| cw118b_c5 | Accrues earned unbilled revenue on completed JOB-4108 (WO-7781 completed 2026-10-29, invoiced on INV-9012 on 2026-11-03, $11,700.00 cost) via Dr 1180 Unbilled AR / Contract Asset (WIP) $19,500.00 and Cr 4100 Commercial HVAC Revenue $19,500.00 (reversing 2026-11-01). | Reasoning (numerical) |
| cw118b_c6 | Computes the net revenue adjustment across JOB-4105 and JOB-4108 as -$22,500.00 (+$19,500.00 earned WIP accrual less $42,000.00 unearned deposit deferral). | Reasoning (numerical) |
| cw118b_c7 | Refuses to plug WIP revenue to a target margin on open job JOB-4111 ($14,800.00 incurred cost with unmeasured completion census). | Reasoning (qualitative) |
| cw118b_c8 | Discloses the open-job WIP limitation on JOB-4111 with a 2026-11-30 true-up trigger under POL-CLOSE-STATE and reports the close state as closed with estimates rather than certified. | Reasoning (qualitative) |
Case 19 · Omnichannel Shopify Payout Clearing, EUR FX & Sales Tax
Lumina Home & Goods Inc. · $48,637 Direct Bank-Feed Double-Count + $75,300 Marketplace Tax Split
1. What Happened on the Books
One $48,637.20 Shopify bank settlement bypassed Account 1070 Shopify Payout Clearing and posted straight to Product Revenue (inflating October D2C sales from $142,400.00 to $191,037.20), while $215,300.00 of 5-channel gross sales included $75,300.00 of exempt and Marketplace Facilitator deductions.
2. What Raw AI Gets Wrong
Unassisted AI leaves the $48,637.20 bank deposit in top-line revenue while Shopify's order sync also books the sale, and overpays state sales tax by failing to deduct the $75,300.00 of marketplace-remitted and exempt sales.
3. How Level Playbooks Fix It (100%)
Level routes all processor deposits through 1070 Shopify Payout Clearing (restoring true $142,400.00 D2C revenue), remeasures EUR intercompany balances at closing spot rates, and deducts all $75,300.00 of marketplace/exempt sales before filing.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Shopify Processor Payout Clearing vs. Duplicate Bank-Feed Revenue & EUR/USD FX Intercompany Loan Mirror
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw119a_c1 | Computes October 2026 tax-exclusive Gross D2C Product Revenue (4010) across PAY-8841, PAY-8892, and PAY-8905 as $142,400.00 (vs. $191,037.20 unadjusted GL), Sales Returns & Refunds (4090) as $3,920.00, Merchant Processing Fees (6430) as $4,192.80, and Processor Reserve Hold (1090 asset) as $5,500.00. | Reasoning (numerical) |
| cw119a_c2 | Identifies that bank deposit DEP-8892 ($48,637.20 on 2026-10-30 for PAY-8892) bypassed 1070 Shopify Payout Clearing and was credited directly to 4010 D2C Product Revenue after JE-2026-1028 had already recognized gross revenue. | Reasoning (numerical) |
| cw119a_c3 | Reconciles 1070 Shopify Payout Clearing ($0.00 opening balance per OPEN-1070 and POL-PAYOUT-TAX) from $67,522.60 unadjusted down to the $18,885.40 October 31 deposit-in-transit balance (PAY-8905, settled on DEP-8905 on 2026-11-03) via Dr 4010 D2C Product Revenue $48,637.20 and Cr 1070 Shopify Payout Clearing $48,637.20. | Reasoning (numerical) |
| cw119a_c4 | Decomposes Wise EUR settlement WIRE-FX-401 ($16,038.50 total USD debit for AlpenFlora INV-AF-912 of EUR 14,500.00 at 0.9080 EUR per 1 USD) into $15,969.16 converted principal and $69.34 Wise wire fee, and computes the $164.16 realized FX loss against open AP bill BILL-AF-912 ($15,805.00). | Reasoning (numerical) |
| cw119a_c5 | Provides the correcting entry for WIRE-FX-401 and BILL-AF-912: Dr 2000 Accounts Payable $15,805.00, Dr 7210 Realized FX Loss $164.16, Dr 6440 Bank & FX Fees $69.34, Cr 5120 Botanical Raw Materials COGS $16,038.50. | Reasoning (qualitative) |
| cw119a_c6 | Reconciles the $34,900.00 intercompany balance on Lumina Botanics Corp (1350 Due from Lumina Soho LLC) by restoring deleted September entry JE-2026-0929 ($6,400.00 on 2026-09-29) and reclassifying October wire DEP-IC-702 / WIRE-IC-702 ($28,500.00) on Lumina Soho Retail LLC. | Reasoning (numerical) |
| cw119a_c7 | Provides period-separated Lumina Soho Retail LLC intercompany entries per POL-IC-PARITY: restore 2026-09-29 Audit Log pre-image Dr 1410 Retail Merchandise Inventory $6,400.00 / Cr 2350 Due to Lumina Corp $6,400.00, and record 2026-10 reclassification Dr 4900 Other Miscellaneous Income $18,500.00, Dr 3200 Member Contributions $10,000.00, Cr 2350 Due to Lumina Corp $28,500.00. | Reasoning (qualitative) |
| cw119a_c8 | Enforces processor reserve asset classification (keeping the $5,500.00 rolling reserve in 1090 Processor Reserve Hold rather than expensing it) and holds close sign-off pending post-posting read-back confirming two-sided clearing and 1350 = 2350 ($34,900.00) intercompany parity. | Reasoning (qualitative) |
Part B: Multi-State Sales Tax Portal Cutoff, Prepayment Split & Marketplace Facilitator Bifurcation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw119b_c1 | Computes total October 2026 omnichannel Gross Sales across all 5 channels as $215,300.00, total Non-Taxable & Marketplace Facilitator Deductions as $75,300.00 ($14,400.00 exempt direct sales + $60,900.00 marketplace facilitator sales), and Net Merchant-Taxable Sales as $140,000.00 ($80,000.00 NY + $60,000.00 NJ). | Reasoning (numerical) |
| cw119b_c2 | Computes October 2026 merchant-liable sales tax collected as $11,075.00 ($7,100.00 on CH-SHOPIFY-NY at 8.875%, $3,180.00 on CH-SHOPIFY-NJ at 6.625%, and $795.00 on CH-INSTA-DIRECT at 6.625%). | Reasoning (numerical) |
| cw119b_c3 | Identifies that CH-AMAZON-MKT ($42,500.00 sales, $3,411.88 tax) and CH-TIKTOK-MKT ($18,400.00 sales, $1,472.00 tax) had $4,883.88 total tax withheld and remitted by marketplace facilitators, and reverses the erroneous $3,411.88 Amazon tax credit from 2180 Sales Tax Payable against 1075 Amazon Marketplace Clearing. | Reasoning (numerical) |
| cw119b_c4 | Catches the false marketplace exclusion on CH-INSTA-DIRECT ($12,000.00 NJ direct checkout sales where Platform_Tax_Remitted_Flag = NO, $0.00 platform tax withheld, and $795.00 collected tax settled to merchant), restoring $12,000.00 to NJ taxable sales and $795.00 to NJ tax due. | Reasoning (numerical) |
| cw119b_c5 | Identifies that bank EFT payment TXN-9041 ($9,840.00 total across TXN-9041-L1 and TXN-9041-L2 on 2026-10-20) was erroneously expensed to 6810 Licenses & Taxes Expense instead of debiting 2180 Sales Tax Payable. | Reasoning (numerical) |
| cw119b_c6 | Splits TXN-9041 ($9,840.00 under Portal Confirmation NJ-20261020-881) into $7,700.00 settling the opening Q3 2026 liability (OPEN-Q3-2180) and $2,140.00 applied as an October 2026 NJ ST-51 prepayment. | Reasoning (numerical) |
| cw119b_c7 | Reconciles 2180 Sales Tax Payable from the $22,186.88 unadjusted October 31 GL balance down to the $8,935.00 adjusted ending balance ($7,100.00 NY October tax due + $1,835.00 net NJ October tax due after applying the $2,140.00 ST-51 prepayment against $3,975.00 total NJ tax). | Reasoning (numerical) |
| cw119b_c8 | Provides the correcting journal entries (Dr 2180 Sales Tax Payable $3,411.88 / Cr 1075 Amazon Marketplace Clearing $3,411.88 and Dr 2180 Sales Tax Payable $9,840.00 / Cr 6810 Licenses & Taxes Expense $9,840.00) and prohibits treating social-commerce channel tags as marketplace-facilitator exempt without payout tax-withholding proof. | Reasoning (qualitative) |
Case 20 · Annual SaaS Subscriptions Billed Early & Unfinished Setup Fees
Northstar Cloud Software Inc. · $92,400 Annual SaaS Billed Upfront + Unfinished Customer Setup Fees
1. What Happened on the Books
October QuickBooks sales ($92,400.00) lumped active October software service ($9,600.00 actually earned) together with 12-month contracts that did not start until November and setup fees where the customer had not signed off on go-live testing yet, plus a $16,800.00 upfront equipment deposit.
2. What Raw AI Gets Wrong
Raw AI books the entire 12-month invoice as October revenue before software access even starts, counts setup fees before customer go-live approval, and expenses the $16,800.00 equipment deposit immediately.
3. How Level Playbooks Fix It (100%)
Level recognizes annual SaaS revenue month by month over the service period (ASC 606), holds unapproved setup fees in Deferred Revenue until go-live, and keeps the $16,800.00 deposit in Prepaid Expenses until delivered.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: ASC 606 SaaS Ratability, Pre-Commencement Subscription Cutoff & Uncompleted UAT Milestone Deferral
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw120a_c1 | Computes unadjusted October 2026 GL revenue across INV-8803, INV-8810, and INV-8824 as $92,400.00 ($69,600.00 in 4100 SaaS Subscription Revenue and $22,800.00 in 4200 Implementation Revenue). | Reasoning (numerical) |
| cw120a_c2 | Verifies that INV-8803 (DEP-6094, $14,400.00 total) requires $0.00 deferral because $9,600.00 October SaaS service (2026-10-01 to 2026-10-31) was delivered and $4,800.00 implementation milestone JOB-911 achieved signed customer UAT acceptance on 2026-10-19. | Reasoning (numerical) |
| cw120a_c3 | Splits the $36,000.00 12-month SaaS line on INV-8810 (DEP-6102, 2026-10-01 to 2027-09-30) into $3,000.00 (1 month) earned in 2026-10 and $33,000.00 (11 months) deferred to 2410 Deferred Revenue - Current. | Reasoning (numerical) |
| cw120a_c4 | Defers 100.00% ($18,000.00) of uncompleted implementation milestone JOB-914 on INV-8810 ($0.00 earned in 2026-10) to 2420 Deferred Revenue - Uncompleted Milestones because staging failed UAT on 2026-10-29 and customer sign-off is scheduled for 2026-11-12. | Reasoning (numerical) |
| cw120a_c5 | Defers 100.00% ($24,000.00) of pre-billed annual contract INV-8824 (paid on DEP-6119 on 2026-10-30 for service term starting 2026-11-01) to 2410 Deferred Revenue - Current ($0.00 earned in 2026-10). | Reasoning (numerical) |
| cw120a_c6 | Computes total October 2026 revenue deferral of $75,000.00 (81.17% of unadjusted booked revenue deferred) and adjusted recognized revenue of $17,400.00 ($12,600.00 in 4100 SaaS Subscription Revenue and $4,800.00 in 4200 Implementation Revenue). | Reasoning (numerical) |
| cw120a_c7 | Provides the exact ASC 606 correcting journal entry: Dr 4100 SaaS Subscription Revenue $57,000.00, Dr 4200 Implementation Revenue $18,000.00, Cr 2410 Deferred Revenue - Current $57,000.00, Cr 2420 Deferred Revenue - Uncompleted Milestones $18,000.00. | Reasoning (qualitative) |
| cw120a_c8 | Refuses to recognize partial percentage-of-completion revenue on JOB-914 from internal staging deployment before customer UAT acceptance and confirms cash collected prior to term start on INV-8824 is a contract liability under ASC 606. | Reasoning (qualitative) |
Part B: Prepaid Vendor Advance vs. Unscheduled Insurance, Negative AP Sign, Equipment Loan Split & Paid Receipt Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw120b_c1 | Retains BILL-4402 / PAY-4402 ($16,800.00 under PO-719 for 2026-11-25 tooling delivery) in 1350 Prepaid Expenses as a verified provisional paid vendor advance ($0.00 October expense) with a bounded 2026-11-30 true-up check. | Reasoning (numerical) |
| cw120b_c2 | Refuses to accept the preparer's vendor_advance workpaper tag on CHK-5108 ($14,400.00 Sentinel Specialty Insurance) and holds $14,400.00 as an unscheduled insurance policy with unmeasured 2026-10 amortization rather than inventing an unsupported 12-month schedule without the declaration page. | Reasoning (qualitative) |
| cw120b_c3 | Reconciles 2000 Accounts Payable at $32,230.00 net ($38,650.00 open bills on BILL-4410 plus -$6,420.00 negative balance on CloudScale Hosting Inc. from unapplied payment PAY-3912) and refuses to reclassify -$6,420.00 to 1350 Prepaid Expenses from negative AP sign alone. | Reasoning (numerical) |
| cw120b_c4 | Splits equipment loan payment CHK-7820 ($4,365.00 booked to 6320 Equipment Loan Expense under statement STM-LN-7820-202610) into $3,620.00 principal reduction ($118,400.00 opening less $114,780.00 ending principal) and $745.00 interest expense, reconciling 2620 Equipment Notes Payable to $114,780.00. | Reasoning (numerical) |
| cw120b_c5 | Provides the correcting journal entry for CHK-7820: Dr 2620 Equipment Notes Payable $3,620.00, Dr 7110 Interest Expense $745.00, Cr 6320 Equipment Loan Expense $4,365.00. | Reasoning (qualitative) |
| cw120b_c6 | Excludes paid corporate card receipt PUR-8904 ($8,750.00 Stratos Security Labs, already paid 2026-10-26 and booked in 6410 Security Testing Expense) with $0.00 accrual so a paid receipt in the close folder is never double-accrued. | Reasoning (numerical) |
| cw120b_c7 | Accrues unpaid October legal invoice BILL-4490 ($5,400.00 received 2026-11-03 for 2026-10 MSA redlines) via Dr 6420 Legal & Professional Fees $5,400.00 and Cr 2110 Accrued Expenses $5,400.00 (paired with a 2026-11-01 reversal of $5,400.00), yielding a net +$1,780.00 pre-tax expense increase from measured adjustments prior to pending CHK-5108 policy-declaration amortization. | Reasoning (numerical) |
| cw120b_c8 | Discloses the $14,400.00 unscheduled CHK-5108 policy declaration hold and the -$6,420.00 PAY-3912 missing-bill investigation with 2026-11-30 true-up triggers, reports close disposition as closed with estimates rather than certified under POL-PREPAID-AP, and never credits 1350 Prepaid Expenses for unpaid accruals. | Reasoning (qualitative) |
Case 21 · Same-Bank Account Resemblance, Card Refunds & Estimates
Aether Diagnostics Lab Corp. · $14,800 Second Bank Account Zeroed Out + $19,250 Day-1 Reversal Error
1. What Happened on the Books
The company held two separate First Commercial Bank accounts (#8162 with $64,250.00 and #2473 with $14,800.00 = $79,050.00 total cash), Day-1 reversals (-$12,400 and -$6,850 = -$19,250.00) clearing September estimates, and merchant card customer refunds mixed with processing fees.
2. What Raw AI Gets Wrong
Unassisted AI assumes the two First Commercial Bank accounts are duplicate feeds and zeroes out $14,800.00 of real cash, flags legitimate Day-1 accrual reversals as negative-expense errors, and flips card refund signs.
3. How Level Playbooks Fix It (100%)
Level verifies last-4 bank account numbers (#8162 vs #2473) to preserve all $79,050.00 of reconciled cash, pairs Day-1 reversals against September accruals, and separates customer refunds from processor fees.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Bank Institution Resemblance Guard, Unmeasured Negative-Bank Disclosure & Card Refund vs. Processor Fee Direction
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw121a_c1 | Preserves both First Commercial Bank accounts 1010 ($64,250.00) and 1020 ($14,800.00) for $79,050.00 combined reconciled positive cash. | Reasoning (numerical) |
| cw121a_c2 | Refuses to zero or remap 1020 ($14,800.00) as a duplicate bank feed solely from shared institution name because account numbers 8162 and 2473 and account types are distinct. | Reasoning (qualitative) |
| cw121a_c3 | Computes net 2026-10 book cash across 1010, 1020, and 1030 (-$8,420.50) as $70,629.50 while retaining the -$8,420.50 book balance without an unsupported plug. | Reasoning (numerical) |
| cw121a_c4 | Discloses 1030 (-$8,420.50) as an unmeasured bank statement reconciliation item with a 2026-11-30 true-up rather than certifying a verified bank overdraft. | Reasoning (qualitative) |
| cw121a_c5 | Preserves native Credit=true corporate card annual-fee refund TXN-CC-901 ($695.00) as a credit to 6435 rather than dropping or retiring it as interest. | Reasoning (numerical) |
| cw121a_c6 | Sums the 5 merchant deposit processor fee deductions DEP-4401 through DEP-4405 ($182.90, $160.15, $208.60, $144.45, and $149.10) as debits to 6435 totaling $845.20 against $28,570.00 gross deposits ($27,724.80 net cash). | Reasoning (numerical) |
| cw121a_c7 | Refuses to flip DEP-4401 through DEP-4405 labeled CREDIT CARD PROC FEE into fee reversals, keeping all 5 lines as positive processor fee charges. | Reasoning (qualitative) |
| cw121a_c8 | Computes audited 2026-10 net expense in 6435 Bank & Card Fees as $150.20 ($845.20 processor fee charges less $695.00 annual-fee refund credit) with $0.00 reclassification required. | Reasoning (numerical) |
Part B: Day-1 Reversals of Prior-Period Controlled Estimates, Unbilled CRO Accrual & Close Status Classification
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw121b_c1 | Identifies JE-2026-1001A (-$12,400.00 reversing JE-2026-0930A) and JE-2026-1001B (-$6,850.00 reversing JE-2026-0930B) as $19,250.00 gross prior-period estimate reversals. | Reasoning (numerical) |
| cw121b_c2 | Refuses to include the $19,250.00 gross 2026-10-01 reversals as new 2026-10 estimated expense exposure, preventing a $28,650.00 overstated estimate register. | Reasoning (qualitative) |
| cw121b_c3 | Isolates actual 2026-10 controlled-estimate exposure as $9,400.00 solely from unbilled CRO accrual JE-2026-1031C (debit to 6240 and credit to 2110, reversing 2026-11-01). | Reasoning (numerical) |
| cw121b_c4 | Reconciles 2026-10 R&D wage expense in 6110 across JE-2026-1001A (-$12,400.00), PR-2026-1005 ($24,800.00), PR-2026-1019 ($24,800.00), and PR-2026-1031 ($22,600.00) to $59,800.00 with $0.00 prior-estimate variance. | Reasoning (numerical) |
| cw121b_c5 | Computes the +$270.00 prior-estimate true-up delta on PO-771 between BILL-5012 ($7,120.00) and JE-2026-1001B (-$6,850.00) without netting unrelated P&L accounts. | Reasoning (numerical) |
| cw121b_c6 | Reconciles 2026-10 lab consumables expense in 5210 across JE-2026-1001B (-$6,850.00), BILL-5012 ($7,120.00), and BILL-5048 ($14,300.00) to $14,570.00. | Reasoning (numerical) |
| cw121b_c7 | Classifies the 2026-10 close state as closed with estimates with a 2026-11-30 true-up deadline rather than certified. | Reasoning (qualitative) |
| cw121b_c8 | Refuses to certify the 2026-10 books as finalized with no open items while unbilled CRO estimate JE-2026-1031C ($9,400.00) and missing-statement account 1030 remain open for true-up. | Reasoning (qualitative) |
Case 22 · Identical-Dollar Gusto Runs & Prepaid Tooling Custody
Harmonic Robotics & Hardware Inc. · Twin $5,125 Gusto Runs + Unbacked Manual JE + $16,000 Tooling Deposit
1. What Happened on the Books
Two legitimate $5,125.00 Gusto contractor ACH debits cleared the bank alongside a third manual journal entry for $5,125.00 with zero bank trace, while $16,000.00 of paid CNC and foundry tooling deposits ($9,200 + $6,800) sat in Prototype COGS.
2. What Raw AI Gets Wrong
Raw AI either deduplicates one of the two real $5,125.00 bank-settled Gusto runs or leaves the unbacked $5,125.00 manual journal entry on the books, and expenses the $16,000.00 of unreceived tooling deposits.
3. How Level Playbooks Fix It (100%)
Level matches each $5,125.00 Gusto run 1-to-1 against bank ACH trace IDs, reverses only the unbacked manual journal entry, and capitalizes the $16,000.00 of paid supplier deposits into Prepaid Tooling.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Equal-Dollar Gusto Payroll Splits, Micro-Leg Ordinal Bijection & Transfer-Rail Supplier Classification
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw122a_c1 | Verifies from the Gusto register and bank statement that ACH-PR-501 ($5,125.00 on 2026-10-15 for Contractor Run GUSTO-RUN-88A in 6140) and ACH-PR-502 ($5,125.00 on 2026-10-15 for Off-Cycle Engineer Run GUSTO-RUN-88B in 6110) are two distinct settled runs totaling $10,250.00 and must not be deleted as duplicates. | Reasoning (numerical) |
| cw122a_c2 | Identifies from Source_Ref_ID=GUSTO-RUN-88A and Bank_Trace=NONE_MANUAL that manual entry JE-2026-1019 ($5,125.00 on 2026-10-19 with $0.00 separate bank outflow) duplicates settled ACH-PR-501, overstating combined payroll and contractor expense at $15,375.00 (with 6140 R&D Contractor Compensation overstated at $10,250.00 vs $5,125.00 actual) and leaving $5,125.00 in 2140 Payroll Clearing. | Reasoning (numerical) |
| cw122a_c3 | Provides the reversing journal entry for JE-2026-1019: Dr 2140 Payroll Clearing $5,125.00 / Cr 6140 R&D Contractor Compensation $5,125.00, reconciling 2140 Payroll Clearing to $0.00 and 6140 R&D Contractor Compensation to $5,125.00. | Reasoning (qualitative) |
| cw122a_c4 | Verifies the 1-to-1 trace and ordinal bijection across all 4 micro-verification debits on 2026-10-06 (ROW-1 to JE-2026-1006A, ROW-2 to JE-2026-1006B, ROW-3 to JE-2026-1006C, ROW-4 to JE-2026-1006D), retaining $4.00 ($1.00 each) in 6440 Bank & Verification Fees with $0.00 duplicate deletion. | Reasoning (numerical) |
| cw122a_c5 | Reconciles complete settled 2026-10 bank outflows on 1000 Operating Checking across all workbook schedules as $43,504.00 ($10,250.00 Gusto ACHs + $4.00 micro-verification debits + $6,450.00 PUR-9910 + $26,800.00 paid tooling deposit and insurance ACH bill payments), bringing ending 1000 Operating Checking from $245,000.00 opening ($0.00 October inflows) to $201,496.00. | Reasoning (numerical) |
| cw122a_c6 | Reclassifies bank purchase PUR-9910 ($6,450.00 on 2026-10-22 with memo 'Online transfer to Mercer IP Law') from 6999 Uncategorized Expense to 6610 Legal & IP Professional Fees based on custodied October patent invoice INV-MIP-204 (debit 6610 $6,450.00 / credit 6999 $6,450.00, clearing 6999 Uncategorized Expense to $0.00 and refusing to treat PUR-9910 as a transfer). | Reasoning (numerical) |
| cw122a_c7 | Refuses to classify PUR-9910 as an own-account bank transfer to 1020 Mercury Treasury Savings solely from 'Online transfer' memo text, confirming $0.00 matching transfer activity on 1020 on 2026-10-22. | Reasoning (qualitative) |
| cw122a_c8 | Refuses to merge PUR-9910 with same-date equipment journal entry JE-2026-1022 ($6,450.00), preserving JE-2026-1022 (Dr 1520 Lab Robotics Equipment $6,450.00 / Cr 2610 Equipment Finance Note $6,450.00) as a separate non-cash acquisition. | Reasoning (qualitative) |
Part B: Paid Tooling Deposit Bill-to-JE Custody vs. Relabeled Workers-Comp Policy Amortization & Close Sign-Off Guard
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw122b_c1 | Verifies paid supplier deposit bills BILL-3101 ($9,200.00 Precision CNC Dynamics) and BILL-3102 ($6,800.00 Harmonic Drive Foundry), confirming $16,000.00 total paid vendor deposits originally posted to 5110 Prototype COGS. | Reasoning (numerical) |
| cw122b_c2 | Validates balanced capitalization journal entry JE-2026-1014 (Dr 1320 Prepaid Tooling Deposits $16,000.00 / Cr 5110 Prototype COGS $16,000.00 under PO-KR-401 and PO-KR-402), must not reverse JE-2026-1014, and retains $16,000.00 in 1320 Prepaid Tooling Deposits ($0.00 net October 5110 COGS) with the close policy's 2026-11-30 true-up deadline. | Reasoning (numerical) |
| cw122b_c3 | Refuses to admit BILL-3109 ($10,800.00 Pacific Industrial Mutual) as a deposit-only unamortized item despite Bookkeeper_Classification_Tag='Security_Deposit_No_Amort', because Policy #WC-2026-8841 Annual Workers Comp (2026-10-01 to 2027-09-30) is a 12-month insurance policy. | Reasoning (qualitative) |
| cw122b_c4 | Computes 2026-10 straight-line 1/12 amortization on BILL-3109 ($10,800.00 across 12 months) as $900.00 in 6320 Insurance Expense and $9,900.00 (11 remaining months) in ending 1310 Prepaid Insurance. | Reasoning (numerical) |
| cw122b_c5 | Provides the adjusting journal entry for BILL-3109: Dr 6320 Insurance Expense $900.00 / Cr 1310 Prepaid Insurance $900.00. | Reasoning (qualitative) |
| cw122b_c6 | Reconciles combined prepaid assets (1310 Prepaid Insurance + 1320 Prepaid Tooling Deposits) from $26,800.00 unadjusted down to $25,900.00 audited ($9,900.00 in 1310 + $16,000.00 in 1320). | Reasoning (numerical) |
| cw122b_c7 | Refuses to accept preparer self-attestation on CHKLIST-PREP-10 because Workpaper_Target_Formula='=GL_Balance' compares the $26,800.00 unadjusted GL balance against itself and Reviewer_Signoff_Receipt is null, assigning close status closed_with_estimates rather than certified. | Reasoning (qualitative) |
| cw122b_c8 | Confirms that balanced Bill-to-JE capitalization lineage (BILL-3101 and BILL-3102 linked on JE-2026-1014) must not be reversed as an unsupported manual JE or double-capitalized when paid bills, document hashes, and the 2026-11-30 close-policy true-up deadline are verified. | Reasoning (qualitative) |
Case 23 · US/Germany/Canada FX Intercompany Loans & Inventory Profit
Helios Global Group (US, GmbH & Canada) · EUR 100K Loan Spot Drift + Unrealized Intercompany Inventory Profit
1. What Happened on the Books
Across US, German (EUR), and Canadian (CAD) entities, a EUR 100,000 intercompany loan required October 31 spot remeasurement (1.1000 USD/EUR), while $60,000 of components (costing $45,000) shipped to Canada still had 40% (320 of 800 units) sitting unsold in Canadian inventory at month-end.
2. What Raw AI Gets Wrong
Unassisted AI translates intercompany loans at monthly average FX rates instead of month-end spot rates (leaving Due-To/Due-From out of balance) and fails to eliminate the $6,000 of unrealized intercompany profit still sitting in ending inventory.
3. How Level Playbooks Fix It (100%)
Level remeasures monetary intercompany loans at closing spot rates under ASC 830, translates management fees at average rates, and eliminates the exact 40% ($6,000) unrealized intercompany margin on unsold inventory.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Monetary IC Loan Remeasurement, Management Fee Avg-vs-Spot Translation & Day-31 Wire-in-Transit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw123a_c1 | Translates Helios GmbH's EUR 100,000.00 short-term loan receivable IC-LOAN-401 in 1350 Intercompany Due From at the 2026-10-31 closing spot rate of 1.1000 to $110,000.00, identifying a $2,000.00 discrepancy against Helios US Inc.'s unadjusted 2350 Intercompany Due To balance of $108,000.00 booked at the 2026-10-01 historical spot rate of 1.0800. | Reasoning (numerical) |
| cw123a_c2 | Provides the 2026-10-31 ASC 830 monetary remeasurement journal entry on Helios US Inc. for IC-LOAN-401: Dr 7910 Foreign Currency Remeasurement Gain/Loss $2,000.00 / Cr 2350 Intercompany Due To $2,000.00, remeasuring Helios US Inc.'s 2350 liability to $110,000.00. | Reasoning (qualitative) |
| cw123a_c3 | Verifies that monthly management fee INV-IC-1026 ($32,550.00 billed by Helios US Inc. in 4800 Intercompany Management Fee Revenue and EUR 30,000.00 booked by Helios GmbH in 6800 Intercompany Management Fee Expense at the 1.0850 October monthly average rate) translates to $32,550.00 in consolidated P&L with $0.00 revenue-vs-expense elimination variance, whereas unadjusted EUR 30,000.00 in GmbH 2350 translates at the 1.1000 closing spot rate to $33,000.00 ($450.00 overstatement). | Reasoning (numerical) |
| cw123a_c4 | Remeasures Helios GmbH's unpaid $32,550.00 USD-denominated payable on INV-IC-1026 at the 2026-10-31 closing spot rate of 1.1000 to EUR 29,590.91, recognizing an FX remeasurement gain of EUR 409.09 on Helios GmbH's books (Dr 2350 Intercompany Due To EUR 409.09 / Cr 7910 Foreign Currency Remeasurement Gain/Loss EUR 409.09) that translates at the 1.0850 monthly average rate to $443.86 in consolidated P&L and aligns GmbH's translated 2350 balance to $32,550.00. | Reasoning (numerical) |
| cw123a_c5 | Computes net consolidated 2026-10 P&L expense in 7910 Foreign Currency Remeasurement Gain/Loss across Helios US Inc. ($2,000.00 loss) and Helios GmbH ($443.86 translated gain) as $1,556.14 net FX remeasurement loss. | Reasoning (numerical) |
| cw123a_c6 | Decomposes Helios Canada Ltd.'s 2026-10-31 outgoing bank debit WIRE-IC-1031 ($15,045.00 debited entirely to 2350 Intercompany Due To) into $15,000.00 intercompany wire principal and $45.00 bank wire fee, providing the reclassification entry on Helios Canada Ltd.: Dr 6440 Bank & Wire Fees $45.00 / Cr 2350 Intercompany Due To $45.00 (restoring Canada's 2350 balance from $44,955.00 unadjusted to $45,000.00). | Reasoning (numerical) |
| cw123a_c7 | Records the 2026-10-31 wire in transit on Helios US Inc. for WIRE-IC-1031 (settled at US bank on 2026-11-02): Dr 1360 Cash in Transit $15,000.00 / Cr 1350 Intercompany Due From $15,000.00, reducing Helios US Inc.'s 1350 receivable from Canada from $60,000.00 to $45,000.00 while retaining $15,000.00 in consolidated 1360 Cash in Transit. | Reasoning (qualitative) |
| cw123a_c8 | Reconciles total three-entity intercompany balances at 2026-10-31 from $202,550.00 unadjusted 1350 vs. $185,955.00 unadjusted 2350 ($16,595.00 pre-audit imbalance) to $187,550.00 audited 1350 ($77,550.00 US + $110,000.00 GmbH) and $187,550.00 audited 2350 ($110,000.00 US + $32,550.00 GmbH + $45,000.00 Canada), eliminating $187,550.00 to $0.00 in consolidation. | Reasoning (numerical) |
Part B: ASC 810 Intercompany Inventory Profit Elimination, ASC 830 Non-Monetary Basis & Worksheet Tautology Guard
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw123b_c1 | Computes embedded intercompany profit on shipment INV-IC-880 ($60,000.00 billed in 4810 Intercompany Component Sales less $45,000.00 manufacturing cost in 5100 Component COGS across 800 units) as $15,000.00, representing a 25.00% gross margin on intercompany sales and a 33.33% markup on cost. | Reasoning (numerical) |
| cw123b_c2 | Determines from the 480 units resold externally and 320 units on hand out of 800 units that Helios Canada Ltd. sold 60% ($36,000.00 transfer price in Canada's 5100 Component COGS, realizing $9,000.00 of intercompany profit) and retains 40% ($24,000.00 transfer price = CAD 32,000.00 at the 0.7500 historical spot rate) in ending 1250 Inventory containing $6,000.00 of unrealized intercompany profit. | Reasoning (numerical) |
| cw123b_c3 | Provides the ASC 810 consolidation elimination journal entry for INV-IC-880: Dr 4810 Intercompany Component Sales $60,000.00 / Cr 5100 Component COGS $54,000.00 / Cr 1250 Inventory $6,000.00, eliminating 100.00% of intercompany component sales. | Reasoning (qualitative) |
| cw123b_c4 | Reconciles consolidated ending 1250 Inventory from $24,000.00 standalone down to $18,000.00 true group manufacturing cost (40% of $45,000.00) and consolidated 5100 Component COGS across US ($45,000.00) and Canada ($36,000.00) from $81,000.00 combined standalone down to $27,000.00 true group cost of the 60% sold externally. | Reasoning (numerical) |
| cw123b_c5 | Enforces ASC 830 temporal remeasurement for USD-functional Helios Canada Ltd., confirming that non-monetary 1250 Inventory (CAD 32,000.00) must not be revalued at the 0.7200 October 31 closing spot rate to $23,040.00 and must not recognize a false $960.00 FX loss in 7910. | Reasoning (qualitative) |
| cw123b_c6 | Also confirms consolidated P&L management fee elimination on INV-IC-1026 (Dr 4800 Intercompany Management Fee Revenue $32,550.00 / Cr 6800 Intercompany Management Fee Expense $32,550.00) and intercompany balance sheet elimination (Dr 2350 Intercompany Due To $187,550.00 / Cr 1350 Intercompany Due From $187,550.00) so consolidated 4800, 4810, 6800, 1350, and 2350 all equal $0.00. | Reasoning (numerical) |
| cw123b_c7 | Identifies the consolidation worksheet defect on CONSOL-CHK-10 where Elimination_Check_Formula='=US_1350_IC_Due_From - US_1350_IC_Due_From' compares Helios US Inc.'s $92,550.00 unadjusted 1350 balance against itself to report a false $0.00 variance while omitting GmbH and Canada 1350 and 2350 balances and hiding the $16,595.00 pre-audit three-entity imbalance. | Reasoning (qualitative) |
| cw123b_c8 | Refuses to accept preparer self-attestation Preparer_Status='ELIMINATED' on CONSOL-CHK-10 because Reviewer_Signoff_Receipt is null, the worksheet check formula is self-referential, and $15,000.00 in 1360 Cash in Transit awaits November bank settlement read-back (2026-11-30 true-up deadline), assigning 2026-10 close status closed_with_estimates rather than certified. | Reasoning (qualitative) |
Case 24 · Construction Progress Billing & 10% Holdbacks (AIA G702/G703)
Civic Mechanical & Sheetmetal Contractors · $34,000 Boxed Warehouse Parts Counted as Built + $9,000 Missing Holdback
1. What Happened on the Books
On an $850,000 hospital chiller install ($800K contract + $50K signed change order), $34,000 of parts still sitting unopened in the warehouse were counted as 'installed job cost' (making the project look further along than it really was), and a $90,000 subcontractor bill was recorded at the $81,000 check amount, leaving off the 10% ($9,000) holdback owed upon inspection.
2. What Raw AI Gets Wrong
Raw AI counts boxed warehouse materials as completed construction progress (recognizing revenue too early under ASC 606) and understates job costs and payables by $9,000 by recording only the net $81,000 subcontractor check.
3. How Level Playbooks Fix It (100%)
Level removes uninstalled warehouse parts ($34,000) from construction progress math and records the full $90,000 subcontractor cost ($81,000 paid + $9,000 in 10% Subcontractor Retainage Payable).
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: AIA G702/G703 Cost-to-Cost POC, Uninstalled Stored Materials Reclass, Unsigned Change Order Exclusion & Customer Retainage Gross-Up
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw124a_c1 | Determines the ASC 606 approved contract price on JOB-401 (Civic Hospital Chiller Plant) as $850,000.00 ($800,000.00 executed base contract BASE-401 plus $50,000.00 signed change order CO-401-1) with $680,000.00 total estimated contract cost, excluding unsigned pending change order CO-401-2 ($40,000.00 with Customer_Signoff='PENDING_UNSIGNED') from the $890,000.00 PM spreadsheet total. | Reasoning (numerical) |
| cw124a_c2 | Identifies that October 2026 postings in 5100 Direct Job Labor & Installed Materials COGS on JOB-401 ($170,000.00 unadjusted) include $34,000.00 of generic copper pipe bundles under PO-MAT-908 (BILL-MAT-908 delivered 2026-10-30 to the off-site warehouse with Site_Install_Status='UNINSTALLED_YARD_STOCK') alongside $136,000.00 of site-installed labor and piping, and excludes $34,000.00 from the POC cost numerator. | Reasoning (numerical) |
| cw124a_c3 | Provides the reclassifying journal entry for PO-MAT-908 (BILL-MAT-908): Dr 1260 Uninstalled Stored Materials Inventory $34,000.00 / Cr 5100 Direct Job Labor & Installed Materials COGS $34,000.00, reducing October 2026 installed COGS on JOB-401 to $136,000.00. | Reasoning (qualitative) |
| cw124a_c4 | Computes cumulative installed cost on JOB-401 through 2026-10-31 as $408,000.00 ($272,000.00 prior cumulative installed cost through 2026-09-30 plus $136,000.00 true October 2026 installed cost), exact cost-to-cost POC as 60.00% ($408,000.00 / $680,000.00), cumulative earned revenue as $510,000.00 (60.00% of $850,000.00), and October 2026 earned revenue as $170,000.00 ($510,000.00 less $340,000.00 prior cumulative earned revenue). | Reasoning (numerical) |
| cw124a_c5 | Identifies that INV-401-04 recorded only $189,000.00 net current progress AR from AIA-401-04 ($210,000.00 gross progress billing less 10% retainage of $21,000.00), records Dr 1220 Customer Retainage Receivable $21,000.00 / Cr 4100 Construction Contract Revenue $21,000.00, and reconciles JOB-401 October gross progress billings to $210,000.00 and cumulative gross AIA billings to $560,000.00 ($350,000.00 prior plus $210,000.00 October). | Reasoning (numerical) |
| cw124a_c6 | Compares JOB-401 cumulative earned revenue ($510,000.00) against cumulative gross AIA progress billings ($560,000.00) to determine a -$50,000.00 overbilled WIP position at 2026-10-31, requiring a $50,000.00 ending credit balance in 2420 Billings in Excess of Costs and Estimated Earnings (Contract Liability). | Reasoning (numerical) |
| cw124a_c7 | Accounts for the $10,000.00 Day-1 reversal JE-2026-1001-REV on 2026-10-01 (which reversed the $10,000.00 2026-09-30 overbilling from $340,000.00 prior earned vs $350,000.00 prior gross billed by debiting 2420 and crediting 4150 $10,000.00) and books the 2026-10-31 overbilling deferral Dr 4150 Over/Under-Billing WIP Revenue Adjustment $50,000.00 / Cr 2420 Billings in Excess of Costs and Estimated Earnings (Contract Liability) $50,000.00, reconciling net October 2026 recognized revenue on JOB-401 to $170,000.00 ($210,000.00 in 4100 + $10,000.00 Oct 1 credit in 4150 - $50,000.00 Oct 31 debit in 4150). | Reasoning (numerical) |
| cw124a_c8 | Pairs the $50,000.00 2026-10-31 overbilling deferral on JOB-401 with a 2026-11-01 Day-1 reversing entry (Dr 2420 $50,000.00 / Cr 4150 $50,000.00) and refuses to inflate POC progress with uninstalled generic yard inventory or recognize revenue on unsigned change order CO-401-2. | Reasoning (qualitative) |
Part B: Subcontractor Retainage Gross-Up, Unbilled Field Ticket Cutoff, Underbilled WIP Asset & Gross Balance Sheet Presentation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw124b_c1 | Identifies that Apex Sheetmetal Inc. AIA progress bill SUB-402-01 ($90,000.00 gross completed duct fabrication, 10% retainage withheld = $9,000.00, $81,000.00 net payable) was booked on BILL-402-SUB1 at only $81,000.00 in 5120 Subcontractor COGS, omitting $9,000.00 of subcontractor retainage and understating JOB-402 cost. | Reasoning (numerical) |
| cw124b_c2 | Provides the adjusting journal entry for SUB-402-01: Dr 5120 Subcontractor COGS $9,000.00 / Cr 2020 Subcontractor Retainage Payable $9,000.00, bringing recognized SUB-402-01 subcontractor cost to $90,000.00 while preserving $81,000.00 current trade AP in 2000. | Reasoning (qualitative) |
| cw124b_c3 | Accrues unbilled October 30-31 crane rigging field ticket FT-402-19 ($8,000.00 Titan Crane & Rigging LLC signed by the site superintendent on 2026-10-31, vendor invoice received 2026-11-04 and unbooked at 2026-10-31) via Dr 5120 Subcontractor COGS $8,000.00 / Cr 2110 Accrued Subcontractor Job Costs $8,000.00, paired with a 2026-11-01 Day-1 reversing entry of $8,000.00. | Reasoning (numerical) |
| cw124b_c4 | Computes true October 2026 installed job cost on JOB-402 (Metro Data Center Cooling Loop, $500,000.00 approved contract price and $400,000.00 total estimated contract cost, $0.00 prior activity) as $160,000.00 ($62,000.00 direct labor/materials in 5100 + $90,000.00 gross SUB-402-01 + $8,000.00 FT-402-19 accrual), exact cost-to-cost POC as 40.00% ($160,000.00 / $400,000.00), and October 2026 earned revenue as $200,000.00 (40.00% of $500,000.00). | Reasoning (numerical) |
| cw124b_c5 | Verifies that JOB-402 AIA Pay App AIA-402-01 was properly split at $165,000.00 gross ($148,500.00 in 1200 Progress Accounts Receivable and $16,500.00 in 1220 Customer Retainage Receivable) and computes a $35,000.00 underbilled WIP position ($200,000.00 cumulative earned revenue minus $165,000.00 cumulative gross AIA billed). | Reasoning (numerical) |
| cw124b_c6 | Provides the 2026-10-31 underbilling WIP adjusting entry on JOB-402: Dr 1280 Costs and Estimated Earnings in Excess of Billings (Contract Asset) $35,000.00 / Cr 4150 Over/Under-Billing WIP Revenue Adjustment $35,000.00 (paired with a 2026-11-01 Day-1 reversal), bringing total company-wide adjusted October 2026 recognized revenue across JOB-401 ($170,000.00) and JOB-402 ($200,000.00) to $370,000.00 and total installed job COGS to $296,000.00 ($72,500.00 total ending 1220 Customer Retainage Receivable). | Reasoning (qualitative) |
| cw124b_c7 | Refuses the bookkeeper's proposal on CHKLIST-WIP-10 (Workpaper_Target_Formula='=Net_WIP_Balance') to net JOB-402's $35,000.00 Contract Asset (1280) against JOB-401's $50,000.00 Contract Liability (2420) into a single $15,000.00 net liability, presenting $35,000.00 gross in 1280 Current Assets and $50,000.00 gross in 2420 Current Liabilities under ASC 606-10-45-1. | Reasoning (numerical) |
| cw124b_c8 | Refuses preparer self-attestation on CHKLIST-WIP-10 (Reviewer_Signoff_Receipt is null and Workpaper_Target_Formula='=Net_WIP_Balance') and assigns close status closed_with_estimates rather than certified because open POC estimated total contract costs ($680,000.00 on JOB-401 and $400,000.00 on JOB-402) and the unbilled FT-402-19 cutoff accrual (2026-11-30 true-up) remain open. | Reasoning (qualitative) |
Case 25 · Stripe Chargeback Win Double-Counts & Amex Rolling Reserves
Vanguard Consumer Direct LLC · $1,944 Won Chargeback Booked Twice + $8,640 Amex Rolling Reserve Expensed
1. What Happened on the Books
When the merchant won a prior-month $1,944.00 Stripe chargeback already held on the Balance Sheet in Account 1290 Chargeback Dispute Receivable, the bookkeeper credited Sales Revenue again. Meanwhile, Amex withheld a 10% rolling reserve ($8,640.00 on $86,400.00 gross charges) that was expensed to Merchant Processing Fees.
2. What Raw AI Gets Wrong
Unassisted AI books won chargeback payouts as new revenue (leaving the Dispute Receivable stranded on the Balance Sheet), fails to recover sales tax on lost disputes, and expenses the $8,640.00 refundable Amex rolling reserve.
3. How Level Playbooks Fix It (100%)
Level clears won dispute payouts against 1290 Chargeback Dispute Receivable, separates lost-dispute principal from recoverable sales tax, and moves the $8,640.00 Amex holdback into Processor Rolling Reserve Receivable.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Won Prior-Period Dispute Revenue Double-Count, Lost Dispute Tax/Contra-Revenue Split & Open Provisional Chargeback Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw125a_c1 | Verifies opening 1290 Chargeback Dispute Receivable on 2026-10-01 as $3,024.00, consisting of two September 2026 disputes whose underlying sales and 8.00% collected sales tax were already booked in 2026-09: DSP-901 ($1,944.00 gross = $1,800.00 product + $144.00 8.00% tax on Stripe) and DSP-902 ($1,080.00 gross = $1,000.00 product + $80.00 8.00% tax on Shopify Payments). | Reasoning (numerical) |
| cw125a_c2 | Identifies that on 2026-10-12 won dispute reversal DSP-901 ($1,944.00 principal remitted in Stripe payout PAY-STR-1012 via JE-DSP-901-WIN), the bookkeeper's payout rule improperly credited 4000 Gross Product Sales, and refuses to recognize $1,944.00 as October 2026-10 revenue because it was already recognized in 2026-09 (while confirming the non-refundable September $15.00 dispute fee remains in prior-period expense with $0.00 October fee refund). | Reasoning (qualitative) |
| cw125a_c3 | Provides the correcting journal entry for won prior-period dispute DSP-901: Dr 4000 Gross Product Sales $1,944.00 / Cr 1290 Chargeback Dispute Receivable $1,944.00. | Reasoning (numerical) |
| cw125a_c4 | Identifies from the 2026-10-18 final loss adjudication on prior-period Shopify dispute DSP-902 ($1,080.00 gross left stranded in 1290 with $0.00 October cash movement) that 1290 must be cleared by bifurcating $1,000.00 ex-tax product principal to 4090 Chargebacks & Sales Allowances and $80.00 embedded 8.00% collected sales tax to 2210 Sales Tax Payable. | Reasoning (numerical) |
| cw125a_c5 | Provides the adjusting journal entry for lost dispute DSP-902: Dr 4090 Chargebacks & Sales Allowances $1,000.00 + Dr 2210 Sales Tax Payable $80.00 / Cr 1290 Chargeback Dispute Receivable $1,080.00, refusing to debit the $80.00 sales tax component to 4090 contra-revenue. | Reasoning (qualitative) |
| cw125a_c6 | Identifies that October dispute DSP-1004 ($663.00 deducted on 2026-10-25 from 1070 Stripe Clearing via JE-DSP-1004, comprising $648.00 gross order = $600.00 product + $48.00 8.00% tax plus a $15.00 non-refundable Stripe dispute fee) is OPEN_UNDER_REVIEW (Evidence_Submitted_2026-10-27), and refuses to recognize $663.00 in 4090 Chargebacks & Sales Allowances while under review. | Reasoning (numerical) |
| cw125a_c7 | Provides the reclassifying journal entry for open dispute DSP-1004: Dr 1290 Chargeback Dispute Receivable $648.00 + Dr 6240 Merchant Processing & Dispute Fees $15.00 / Cr 4090 Chargebacks & Sales Allowances $663.00. | Reasoning (qualitative) |
| cw125a_c8 | Reconciles ending 1290 Chargeback Dispute Receivable at 2026-10-31 from $3,024.00 unadjusted to $648.00 audited ($3,024.00 - $1,944.00 - $1,080.00 + $648.00 = $648.00, matching sole open dispute DSP-1004) and reconciles October 4090 Chargebacks & Sales Allowances from $663.00 unadjusted to $1,000.00 audited. | Reasoning (numerical) |
Part B: Amex 10% Rolling Reserve Reclass, Duplicate Bank-Feed Stripe Payout, Oct 30-31 Shopify Batch Cutoff & Checklist Guard
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw125b_c1 | Audits October 2026-10 Amex OptBlue settlement BATCH-AMX-1030 ($86,400.00 gross charges = $80,000.00 in 4000 Gross Product Sales + $6,400.00 in 2210 Sales Tax Payable at 8.00%, with $75,254.40 cash remitted to 1000 Operating Checking), identifying that JE-AMX-1030A debited $11,145.60 to 6240 Merchant Processing & Dispute Fees by combining $2,505.60 (2.90% processing fees) with $8,640.00 (10.00% rolling 90-day reserve holdback). | Reasoning (numerical) |
| cw125b_c2 | Provides the reclassifying journal entry for the Amex rolling reserve: Dr 1078 Processor Rolling Reserve Receivable $8,640.00 / Cr 6240 Merchant Processing & Dispute Fees $8,640.00, refusing to expense recoverable rolling reserve holdbacks in 6240 and leaving $2,505.60 true Amex fees in 6240. | Reasoning (qualitative) |
| cw125b_c3 | Identifies from single bank deposit trace TRC-STR-1028 ($24,300.00 on 2026-10-28) that native payout entry JE-STR-1028 (Dr 1000 Operating Checking $24,300.00 / Cr 1070 Stripe Clearing $24,300.00) already recorded cash settlement, so bank-feed auto-rule deposit DEP-STR-1028 (Dr 1000 Operating Checking $24,300.00 / Cr 4000 Gross Product Sales $24,300.00) overstates both 1000 cash and 4000 revenue by $24,300.00. | Reasoning (numerical) |
| cw125b_c4 | Provides the reversing journal entry for duplicate bank-feed deposit DEP-STR-1028: Dr 4000 Gross Product Sales $24,300.00 / Cr 1000 Operating Checking $24,300.00, reconciling ending 1000 Operating Checking from $406,471.68 unadjusted down to $382,171.68 ($180,000.00 opening + $202,171.68 settled bank deposits, $0.00 outflows) with ending 1070 Stripe Clearing at $0.00. | Reasoning (qualitative) |
| cw125b_c5 | Identifies unbooked Shopify Payments Oct 30-31 captured batch in transit BATCH-SHP-1031 ($12,960.00 gross = $12,000.00 ex-tax sales + $960.00 8.00% sales tax less $375.84 2.90% processing fees, settled $12,584.16 net on 2026-11-02), and provides the 2026-10-31 cutoff journal entry Dr 1072 Shopify Payments Clearing $12,584.16 + Dr 6240 Merchant Processing & Dispute Fees $375.84 / Cr 4000 Gross Product Sales $12,000.00 + Cr 2210 Sales Tax Payable $960.00, reconciling ending 1072 to $12,584.16. | Reasoning (numerical) |
| cw125b_c6 | Reconciles October 2026-10 4000 Gross Product Sales from $226,244.00 unadjusted to $212,000.00 audited ($226,244.00 - $1,944.00 DSP-901 - $24,300.00 DEP-STR-1028 + $12,000.00 BATCH-SHP-1031) and total audited October GAAP Net Revenue (4000 less 4090) from $225,581.00 unadjusted ($226,244.00 - $663.00) to $211,000.00 ($212,000.00 - $1,000.00). | Reasoning (numerical) |
| cw125b_c7 | Reconciles October 2026-10 6240 Merchant Processing & Dispute Fees from $15,109.32 unadjusted to $6,860.16 audited ($15,109.32 + $15.00 DSP-1004 fee - $8,640.00 Amex reserve + $375.84 BATCH-SHP-1031 fee) and ending 2210 Sales Tax Payable from $21,400.00 unadjusted to $22,280.00 ($5,400.00 opening + $16,960.00 October tax - $80.00 DSP-902 tax credit). | Reasoning (numerical) |
| cw125b_c8 | Refuses to accept preparer self-attestation on CHKLIST-PROC-10 because Workpaper_Target_Formula='=GL_Balance' compares the $3,024.00 unadjusted GL receivable balance against itself (versus $21,872.16 audited combined 1070/1072/1075/1078/1290 processor and dispute receivables: $12,584.16 in 1072 + $8,640.00 in 1078 + $648.00 in 1290) and Reviewer_Signoff_Receipt is null, assigning close status closed_with_estimates rather than certified pending open dispute DSP-1004 resolution. | Reasoning (qualitative) |
Case 26 · Import Tariffs, Ocean Freight & Goods Owned at Sea
Alpine Outdoor Gear Co. · $15,000 Tariffs Expensed Upfront + $14,000 Container at Sea Left Off Books
1. What Happened on the Books
On 2,000 imported jackets ($60,000 factory price + $15,000 Section 301 customs tariffs and ocean shipping) where 60% (1,200 jackets) were still unsold in the warehouse, all $15,000 of tariffs and shipping was expensed in Month 1. Separately, a $14,000 container whose legal ownership transferred to the buyer when the ship left port on Oct 28 (FOB Shipping Point) was left off the October books.
2. What Raw AI Gets Wrong
Raw AI expenses 100% of customs tariffs and ocean freight immediately (understating inventory and gross profit by $9,000 on the 1,200 unsold jackets) and ignores the $14,000 container at sea until it docks in November.
3. How Level Playbooks Fix It (100%)
Level includes $9,000 (60%) of inbound tariffs and ocean freight in unsold inventory value (ASC 330) and records the $14,000 container in Goods in Transit Inventory as soon as legal ownership transfers at port.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: ASC 330 Container Landed Cost Capitalization, Embedded SKU Freight Double-Count & Outbound 3PL Reclassification
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw126a_c1 | Computes capitalizable inbound landed add-on costs for container CONT-884 (PO-884, 2,000 alpine jackets received 2026-10-05 with $60,000.00 ex-factory PO cost at $30.00/u in 1210 Merchandise Inventory) as $15,000.00 ($9,000.00 Section 301 customs duty on BILL-8841 + $4,200.00 ocean freight on BILL-8842 + $1,800.00 port drayage on BILL-8843), or $7.50/u, establishing full ASC 330 landed cost of $37.50/u ($75,000.00 across 2,000 units). | Reasoning (numerical) |
| cw126a_c2 | Determines from 800 physical alpine jackets sold in 2026-10 (40%) and 1,200 jackets on hand at 2026-10-31 (60%) that expensing 100% of the $15,000.00 inbound duty, ocean freight, and port drayage to 5120 Freight-In & Duty COGS overstated October COGS by $9,000.00 (60% unsold share = 1,200 units at $7.50/u), leaving $6,000.00 (40% sold share = 800 units at $7.50/u) properly recognizable in October 5120. | Reasoning (numerical) |
| cw126a_c3 | Provides the 2026-10-31 ASC 330 landed-cost capitalization journal entry for the 1,200 unsold CONT-884 jackets: Dr 1210 Merchandise Inventory $9,000.00 / Cr 5120 Freight-In & Duty COGS $9,000.00. | Reasoning (qualitative) |
| cw126a_c4 | Identifies the embedded SKU cost double-count on JE-2026-1031 where the preparer booked $26,800.00 to 5110 Product COGS for the 800 physical jackets using the $33.50/u Shopify SKU cost table rate, which embedded $3.50/u ($2,800.00) estimated freight on top of the $30.00/u ($24,000.00) factory PO cost while separate customs and freight bills were also booked in 5120. | Reasoning (numerical) |
| cw126a_c5 | Provides the adjusting journal entry to reverse the $2,800.00 double-counted embedded freight on JE-2026-1031: Dr 1210 Merchandise Inventory $2,800.00 / Cr 5110 Product COGS $2,800.00, refusing to retain both the $3.50/u Shopify estimated freight adder in 5110 and actual inbound duty/freight bills in 5120. | Reasoning (qualitative) |
| cw126a_c6 | Identifies $6,600.00 of domestic outbound 3PL fulfillment costs ($4,650.00 ShipBob pick-pack fulfillment on BILL-1031 plus $1,950.00 UPS Ground outbound parcel shipping on BILL-1032) misbooked in 5120 Freight-In & Duty COGS. | Reasoning (numerical) |
| cw126a_c7 | Provides the reclassifying journal entry for domestic outbound fulfillment: Dr 6320 Outbound Shipping & Fulfillment $6,600.00 / Cr 5120 Freight-In & Duty COGS $6,600.00, refusing to capitalize outbound customer shipping into 1210 Merchandise Inventory or retain it in 5120. | Reasoning (qualitative) |
| cw126a_c8 | Reconciles 2026-10 COGS and fulfillment accounts from unadjusted balances ($26,800.00 in 5110, $21,600.00 in 5120, $48,400.00 combined COGS, and $0.00 in 6320) to audited balances: $24,000.00 in 5110 Product COGS ($30.00/u), $6,000.00 in 5120 Freight-In & Duty COGS ($7.50/u), $30,000.00 combined landed COGS ($37.50/u across 800 sold units), and $6,600.00 in 6320 Outbound Shipping & Fulfillment. | Reasoning (numerical) |
Part B: FOB Shipping Point vs. Destination Cutoff, Virtual SKU Denominator Guard & Ending Inventory Sign-Off
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw126b_c1 | Evaluates PO-901 (500 glacier packs at $28.00/u = $14,000.00 shipped FOB Shipping Point Busan on 2026-10-28, arrived LA on 2026-11-06 with $0.00 booked in 2026-10), determining that legal title transferred at Busan on 2026-10-28 so $14,000.00 must be recognized as Goods in Transit at 2026-10-31. | Reasoning (numerical) |
| cw126b_c2 | Provides the 2026-10-31 cutoff accrual journal entry for PO-901: Dr 1220 Goods in Transit Inventory $14,000.00 / Cr 2010 Accrued Inventory Purchases $14,000.00. | Reasoning (qualitative) |
| cw126b_c3 | Evaluates PO-902 (BILL-9020 for 300 trekking poles at $20.00/u = $6,000.00 under FOB Destination Seattle warehouse terms, shipped 2026-10-29 and delivered 2026-11-04, prematurely booked on 2026-10-29), determining that title had not passed at 2026-10-31 so $6,000.00 must be excluded from October 1210 Merchandise Inventory and 2000 Accounts Payable. | Reasoning (numerical) |
| cw126b_c4 | Provides the 2026-10-31 reversing journal entry for premature FOB Destination booking BILL-9020 (PO-902): Dr 2000 Accounts Payable $6,000.00 / Cr 1210 Merchandise Inventory $6,000.00, reconciling 2000 Accounts Payable from $87,600.00 unadjusted to $81,600.00 audited. | Reasoning (qualitative) |
| cw126b_c5 | Audits the 1,050 total net Shopify order line-item units against secondary preparer schedule COGS-SCH-10 ($31,500.00 draft at $30.00/u), isolating 250 non-physical virtual units (190 Route Package Protection units + 60 Digital Trail Gift Card units) multiplied by $30.00/u ($7,500.00 excess COGS = $5,700.00 + $1,800.00 in 5110), verifying 800 true physical units sold (1,050 - 250) and refusing to book virtual SKU COGS. | Reasoning (numerical) |
| cw126b_c6 | Reconciles 2026-10-31 ending inventory from $39,200.00 unadjusted ($39,200.00 in 1210 and $0.00 in 1220) to $45,000.00 audited 1210 Merchandise Inventory (1,200 alpine jackets at $37.50/u: $39,200.00 + $9,000.00 CONT-884 landed cost + $2,800.00 embedded freight reversal - $6,000.00 PO-902 reversal) plus $14,000.00 audited 1220 Goods in Transit Inventory (PO-901) = $59,000.00 total ending inventory ($19,800.00 net understatement corrected). | Reasoning (numerical) |
| cw126b_c7 | Identifies the close worksheet defect on INV-CHK-10 where Worksheet_Formula_Text='=GL_1210_Balance - GL_1210_Balance' compares the $39,200.00 unadjusted 1210 GL balance against itself to report a false $0.00 variance while omitting CONT-884 landed costs, embedded freight double-counts, PO-901 goods in transit, and PO-902 FOB Destination cutoff. | Reasoning (qualitative) |
| cw126b_c8 | Refuses to accept preparer self-attestation Preparer_Status='TIED_READY_TO_CERTIFY' on INV-CHK-10 because Reviewer_Signoff_Receipt is null, the worksheet check formula is self-referential, and provisional Section 301 customs liquidation on CONT-884 plus 2026-11 3PL receiving read-backs on PO-901 and PO-902 remain pending (2026-11-30 true-up deadline), assigning 2026-10 close status closed_with_estimates rather than certified. | Reasoning (qualitative) |
Case 27 · Mid-Year SaaS Seat Upgrades & Salesperson Commissions
CloudPulse Enterprise SaaS Inc. · $12,000 Double-Counted SaaS Upgrade + $14,400 Commission Expensed in Month 1
1. What Happened on the Books
When a customer on a $144,000 annual software contract ($12,000/mo) added extra seats mid-year, September's $12,000 base fee was accidentally counted a second time in October, and a $14,400 salesperson closing commission was expensed 100% in October instead of spread across the contract.
2. What Raw AI Gets Wrong
Unassisted AI recalculates year-to-date contract revenue without checking what was already booked last month (double-counting $12,000) and takes the entire $14,400 sales commission hit in Month 1.
3. How Level Playbooks Fix It (100%)
Level schedules mid-year seat upgrades cleanly from the upgrade date forward (ASC 606), reverses the $12,000 September double-count, and spreads the $14,400 closing commission across the contract life (ASC 340-40).
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: SaaS Cumulative Ratable Ceiling Trap, ASC 606-10-25-12 Prospective Modification & Uncompleted UAT Milestone
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw127a_c1 | Audits enterprise subscription SAAS-401 (Northstar Bio, 12-month $144,000.00 contract from 2026-09-01 to 2027-08-31 at $12,000.00 per month with $12,000.00 recognized in 2026-09 and $132,000.00 opening 2400 Deferred Revenue on 2026-10-01), identifying that JE-1041 booked the 2-month cumulative elapsed amount of $24,000.00 to October 2026-10 4100 Subscription Revenue (overstating cumulative recognized revenue at $36,000.00 and reducing SAAS-401 unadjusted 2400 to $108,000.00). | Reasoning (numerical) |
| cw127a_c2 | Provides the correcting journal entry on SAAS-401 to reverse the double-recognized September revenue: Dr 4100 Subscription Revenue $12,000.00 / Cr 2400 Deferred Revenue $12,000.00, restoring October 2026-10 revenue on SAAS-401 to $12,000.00 and ending 2400 Deferred Revenue on SAAS-401 to $120,000.00 across 10 remaining months. | Reasoning (qualitative) |
| cw127a_c3 | Evaluates Vanguard Logistics contract SAAS-402 ($72,000.00 original 12-month subscription from 2026-07-01 to 2027-06-30 at $6,000.00 per month, $18,000.00 recognized Jul-Sep, and $54,000.00 opening 2400 Deferred Revenue on 2026-10-01) and 2026-10-01 modification MOD-402-01 ($27,000.00 incremental billing for integrated seat and tier expansion discounted below standalone selling price across the 9 remaining months 2026-10-01 to 2027-06-30), computing an $81,000.00 prospective unrecognized revenue pool and a $9,000.00 per month prospective recognition rate under ASC 606-10-25-12. | Reasoning (numerical) |
| cw127a_c4 | Identifies that October 2026-10 postings on SAAS-402 recognized $33,000.00 in 4100 Subscription Revenue ($6,000.00 base amortization on JE-1042 plus $27,000.00 upfront modification cash on DEP-402-MOD, leaving $48,000.00 unadjusted in 2400), overstating October revenue on SAAS-402 by $24,000.00 relative to the $9,000.00 earned rate ($6,000.00 base plus $3,000.00 expansion). | Reasoning (numerical) |
| cw127a_c5 | Provides the ASC 606-10-25-12 adjusting journal entry for SAAS-402: Dr 4100 Subscription Revenue $24,000.00 / Cr 2400 Deferred Revenue $24,000.00, restoring SAAS-402 October 4100 Subscription Revenue to $9,000.00 and ending 2400 Deferred Revenue to $72,000.00 across 8 remaining months (refusing immediate upfront recognition or retrospective catch-up to closed Jul-Sep periods). | Reasoning (qualitative) |
| cw127a_c6 | Identifies that Aegis Health custom HIPAA SSO integration milestone IMP-403 ($18,000.00 billed and collected on 2026-10-15 via DEP-403-IMP in 4200 Implementation Revenue) had 0.00% customer delivery in 2026-10 because signed Production UAT acceptance occurred on 2026-11-12, requiring 100.00% deferral ($18,000.00) with $0.00 October implementation revenue. | Reasoning (numerical) |
| cw127a_c7 | Provides the adjusting journal entry for uncompleted milestone IMP-403: Dr 4200 Implementation Revenue $18,000.00 / Cr 2400 Deferred Revenue $18,000.00, refusing partial over-time recognition prior to signed customer UAT acceptance. | Reasoning (qualitative) |
| cw127a_c8 | Reconciles CloudPulse Analytics Inc. October 2026-10 revenue from $75,000.00 unadjusted ($57,000.00 in 4100 Subscription Revenue and $18,000.00 in 4200 Implementation Revenue) down by $54,000.00 total deferrals to $21,000.00 audited ($21,000.00 in 4100 and $0.00 in 4200), and reconciles ending 2400 Deferred Revenue at 2026-10-31 from $156,000.00 unadjusted to $210,000.00 audited ($120,000.00 SAAS-401 + $72,000.00 SAAS-402 + $18,000.00 IMP-403). | Reasoning (numerical) |
Part B: ASC 340-40 Commission Capitalization & Churn Impairment, Paid Hosting Double-Accrual & Checklist Guard
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw127b_c1 | Identifies that $14,400.00 incremental AE closing commission COMM-401 on Northstar Bio (vested and paid 2026-10-01 via PAY-COMM-401) was expensed 100.00% upfront to 6140 Sales Commissions Expense rather than capitalized under ASC 340-40 over the 24-month expected customer benefit period ($600.00 per month amortization rate). | Reasoning (numerical) |
| cw127b_c2 | Provides the ASC 340-40 capitalization and October 2026-10 amortization entries for COMM-401: Dr 1450 Deferred Contract Acquisition Costs $14,400.00 / Cr 6140 Sales Commissions Expense $14,400.00 and Dr 6150 Sales Commission Amortization $600.00 / Cr 1450 Deferred Contract Acquisition Costs $600.00, reducing 6140 to $0.00 and establishing $13,800.00 ending 1450 on COMM-401 (23 remaining months). | Reasoning (qualitative) |
| cw127b_c3 | Identifies on COMM-388 (Zenith Retail, $5,400.00 opening unamortized balance in 1450 Deferred Contract Acquisition Costs on 2026-10-01) that the customer terminated for cause effective 2026-10-25 with $0.00 recoverable future cash flows, while JE-1088 booked only the $300.00 scheduled monthly amortization and left $5,100.00 stranded in 1450. | Reasoning (numerical) |
| cw127b_c4 | Provides the ASC 340-40-35-4 impairment write-off entry for churned contract COMM-388: Dr 6150 Sales Commission Amortization $5,100.00 / Cr 1450 Deferred Contract Acquisition Costs $5,100.00, reducing COMM-388 ending 1450 to $0.00 and bringing total audited October 2026-10 6150 Sales Commission Amortization to $6,000.00 ($600.00 COMM-401 + $300.00 scheduled COMM-388 + $5,100.00 impairment COMM-388) and total audited ending 1450 to $13,800.00 (up from $5,100.00 unadjusted). | Reasoning (qualitative) |
| cw127b_c5 | Identifies that AWS Cloud October hosting receipt DOC-7741 ($8,250.00) was already paid and recorded via direct auto-debit native Purchase qbo:purchase:4412 on 2026-10-30 in 5210 Hosting COGS and was double-accrued on 2026-10-31 in JE-1099 (Dr 5210 Hosting COGS $8,250.00 / Cr 2110 Accrued Expenses $8,250.00), while unpaid Snowflake telemetry meter estimate MTR-1031 ($1,450.00 in JE-1098) is a valid provisional October accrual. | Reasoning (numerical) |
| cw127b_c6 | Provides the reversing journal entry for duplicate hosting accrual JE-1099 on DOC-7741: Dr 2110 Accrued Expenses $8,250.00 / Cr 5210 Hosting COGS $8,250.00, reconciling October 2026-10 5210 Hosting COGS from $17,950.00 unadjusted down to $9,700.00 audited ($8,250.00 paid AWS DOC-7741 plus $1,450.00 provisional Snowflake MTR-1031) and 2110 Accrued Expenses from $9,700.00 unadjusted down to $1,450.00 audited. | Reasoning (qualitative) |
| cw127b_c7 | Identifies the close worksheet control defect on CHKLIST-SAAS-10 where Subledger_Tie_Formula='=GL_1450_Balance - GL_1450_Balance' subtracts the $5,100.00 unadjusted 1450 GL balance from itself to report a false $0.00 variance (masking the $8,700.00 net understatement in 1450 vs. $13,800.00 audited and omitting 2400 Deferred Revenue) while Reviewer_Signoff_Receipt is null. | Reasoning (qualitative) |
| cw127b_c8 | Refuses preparer self-attestation Preparer_Status='certified' on CHKLIST-SAAS-10 and assigns governed 2026-10 close status closed_with_estimates rather than certified, citing the pending signed November customer UAT completion on IMP-403 (2026-11-12) and the $1,450.00 provisional cloud usage meter true-up on MTR-1031 due by 2026-11-30. | Reasoning (qualitative) |
Case 28 · Landlord Buildout Reimbursements & Clinic Equipment
Apex Multi-Site Dental & Orthodontics · $120,000 Landlord Buildout Cash Booked as Profit + $18,000 X-Ray Expensed
1. What Happened on the Books
When opening a new dental office, the landlord wired $120,000 in Tenant Improvement (TI) buildout cash that was booked as 'Other Income' on the P&L, buildout depreciation stretched past the lease end date, and an $18,000 3D X-ray machine was expensed as a repair.
2. What Raw AI Gets Wrong
Raw AI leaves the $120,000 landlord buildout wire in P&L Income (making the clinic look $120,000 more profitable than it really is), depreciates buildouts past the lease term, and misses the $18,000 X-ray equipment asset.
3. How Level Playbooks Fix It (100%)
Level applies the $120,000 landlord reimbursement to reduce the lease asset over the lease term (ASC 842), caps buildout depreciation at the remaining lease years, and capitalizes the $18,000 X-ray unit ($300/mo depreciation).
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: ASC 842 Operating Lease Commencement, Landlord TI Lease Incentive & Leasehold Amortization Life Cap
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw128a_c1 | Identifies that the $120,000.00 cash Landlord Tenant Improvement (TI) Allowance received on 2026-10-02 (WIRE-TI-1002 / DEP-TI-1002 under LEASE-2026-HQ) is a lease incentive under ASC 842-20-30-5 rather than other income, reducing initial 1650 Operating Lease ROU Asset from $491,392.83 to $371,392.83 while retaining the gross $180,000.00 lessee-owned clinic buildout (INV-BLD-201 / WIRE-BLD-201) in 1540 Leasehold Improvements. | Reasoning (numerical) |
| cw128a_c2 | Provides the 2026-10-02 ASC 842-20-30-5 adjusting journal entry for WIRE-TI-1002 (DEP-TI-1002): Dr 4900 Other Income $120,000.00 / Cr 1650 Operating Lease ROU Asset $120,000.00, and explains that Apex Dental owns the clinic buildout improvements (must not credit 1540). | Reasoning (qualitative) |
| cw128a_c3 | Computes total net lease cost over the 60-month noncancelable term of LEASE-2026-HQ as $450,000.00 ($570,000.00 gross contractual cash rent at $9,500.00/mo across 60 months less the $120,000.00 landlord TI lease incentive) and single straight-line monthly lease cost in 6210 Operating Lease Expense as $7,500.00 ($2,000.00 lower than the $9,500.00 cash rent check CHK-4101). | Reasoning (numerical) |
| cw128a_c4 | Computes Month-1 (2026-10) operating lease liability interest accretion at the 0.50% monthly discount rate on $491,392.83 as $2,456.96, principal reduction from the $9,500.00 cash rent payment as $7,043.04, ending 2650 Operating Lease Liability as $484,349.79, Month-1 ROU asset amortization after TI reduction as $5,043.04 ($7,500.00 straight-line lease cost less $2,456.96 accretion), and ending 1650 Operating Lease ROU Asset as $366,349.79. | Reasoning (numerical) |
| cw128a_c5 | Provides the 2026-10-31 ASC 842 operating lease adjusting entry for CHK-4101: Dr 2650 Operating Lease Liability $7,043.04 / Cr 1650 Operating Lease ROU Asset $5,043.04 / Cr 6210 Operating Lease Expense $2,000.00. | Reasoning (qualitative) |
| cw128a_c6 | Applies ASC 842-20-35-12 to the $180,000.00 lessee-owned clinic buildout (INV-BLD-201) in 1540 Leasehold Improvements, capping the amortization period at the 60-month remaining noncancelable lease term rather than the 180-month physical life (renewal not reasonably certain), requiring $3,000.00 monthly amortization instead of the $1,000.00 booked ($2,000.00 understatement). | Reasoning (numerical) |
| cw128a_c7 | Provides the 2026-10-31 leasehold improvement amortization adjusting entry: Dr 6520 Depreciation & Amortization $2,000.00 / Cr 1545 Accumulated Amortization - Leasehold Improvements $2,000.00, bringing ending 1545 to $3,000.00 and net 1540/1545 carrying value to $177,000.00. | Reasoning (qualitative) |
| cw128a_c8 | Quantifies the combined 2026-10 pre-tax net income overstatement from the three Task A lease and buildout errors as $120,000.00 (-$120,000.00 from reversing 4900 Other Income, +$2,000.00 from reducing 6210 Operating Lease Expense from $9,500.00 to $7,500.00, and -$2,000.00 from increasing 6520 Depreciation & Amortization on 1540 from $1,000.00 to $3,000.00). | Reasoning (numerical) |
Part B: Equipment Capitalization vs Repair Whipsaw, Noncash Autoclave Disposal & Cash-Flow Bridge Governance
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw128b_c1 | Identifies that the $18,000.00 3D CBCT X-ray sensor unit (INV-EQP-501 / CHK-4105, placed in service 2026-10-01 with a 60-month useful life) exceeds the $2,500.00 and 12-month capitalization policy threshold and was erroneously expensed to 6410 Repairs & Maintenance, providing the capitalizing entry Dr 1520 Clinical Equipment $18,000.00 / Cr 6410 Repairs & Maintenance $18,000.00. | Reasoning (numerical) |
| cw128b_c2 | Computes Month-1 (2026-10) straight-line depreciation on the $18,000.00 3D CBCT X-ray sensor unit (INV-EQP-501, 60-month useful life, $0.00 salvage) as $300.00 and provides the adjusting entry Dr 6520 Depreciation & Amortization $300.00 / Cr 1525 Accumulated Depreciation - Clinical Equipment $300.00. | Reasoning (numerical) |
| cw128b_c3 | Identifies that the $1,850.00 routine dental handpiece sterilization tune-up (INV-MNT-509 / CHK-4112, 6-month recurring maintenance below the $2,500.00 capitalization threshold) was erroneously capitalized to 1520 Clinical Equipment and provides the reclassifying entry Dr 6410 Repairs & Maintenance $1,850.00 / Cr 1520 Clinical Equipment $1,850.00. | Reasoning (qualitative) |
| cw128b_c4 | Reconciles 2026-10-31 Clinical Equipment balances from $226,850.00 unadjusted 1520 and $78,750.00 unadjusted 1525 to $243,000.00 audited 1520 Clinical Equipment (+$16,150.00 net adjustment), $79,050.00 audited 1525 Accumulated Depreciation - Clinical Equipment, $163,950.00 net Clinical Equipment carrying value, and $1,850.00 audited 6410 Repairs & Maintenance. | Reasoning (numerical) |
| cw128b_c5 | Verifies the 2026-10-20 disposal of retired autoclave DISP-104 ($15,000.00 original cost in 1520 less $10,500.00 accumulated depreciation in 1525 = $4,500.00 net book value scrapped for $0.00 cash proceeds in 7810 Loss on Disposal of Fixed Assets) and diagnoses that omitting the $4,500.00 noncash loss ($0.00 add-back) from Operating Cash Flow on SCF-OCT-26 left a $4,500.00 cash-flow reconciliation gap ($251,150.00 implied SCF ending cash vs. $255,650.00 actual 1000 Operating Cash). | Reasoning (numerical) |
| cw128b_c6 | Requires a +$4,500.00 noncash operating add-back for DISP-104 (7810 Loss on Disposal of Fixed Assets) on the Statement of Cash Flows (SCF-OCT-26) and reconciles audited 2026-10 cash flows ($72,650.00 audited Net Income, +$7,050.00 total 6520 D&A, +$4,500.00 noncash disposal loss, +$118,000.00 net ASC 842 ROU/liability and TI incentive operating cash adjustment, and +$1,450.00 2110 accrual = $203,650.00 Operating Cash Flow; -$198,000.00 Investing CapEx; +$5,650.00 net cash increase to $255,650.00 ending 1000 Operating Cash). | Reasoning (numerical) |
| cw128b_c7 | Rejects the preparer's self-referential worksheet check on SCF-OCT-26 where Cash_Tie_Check_Formula='=Implied_SCF_Ending_Cash - Implied_SCF_Ending_Cash' subtracts the $251,150.00 draft SCF ending cash figure from itself to report a false $0.00 gap instead of comparing against $255,650.00 actual 1000 Operating Cash. | Reasoning (qualitative) |
| cw128b_c8 | Refuses to certify the 2026-10 close and rejects preparer self-attestation Preparer_Status='RECONCILED' on SCF-OCT-26 (Reviewer_Signoff_Receipt is null), assigning 2026-10 close status closed_with_estimates rather than certified pending the final contractor lien waiver on INV-BLD-201 and the $1,450.00 utility/landlord CAM estimate true-up by 2026-11-30. | Reasoning (qualitative) |
Case 29 · Multi-Cycle Payroll Cutoff & Off-Cycle Gusto Rule Error
Cleanroom Precision Labs Inc. · Twin $11,480 Gusto Runs Misrouted by Auto-Rule + Straddle Cohort Cutoff
1. What Happened on the Books
Two equal $11,480.00 Gusto bank ACH debits hit on October 15 (one regular payroll and one off-cycle bonus run), and a QuickBooks bank rule auto-coded the second $11,480.00 off-cycle payroll run to Office Supplies while an October 19 to November 1 hourly straddle run crossed month-end.
2. What Raw AI Gets Wrong
Unassisted AI trusts the QuickBooks bank rule that coded $11,480.00 of off-cycle Gusto wages into Office Supplies and misses the straddle wage accrual across hourly versus salaried cohorts.
3. How Level Playbooks Fix It (100%)
Level matches every Gusto bank debit to its exact payroll run ID (regular vs off-cycle), reverses the bank-rule misclassification, and accrues the exact October days on straddle hourly runs.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Split Payroll Completeness Horizon (Supplement vs. Measured-Through) & Multi-Cohort Service-Period Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw130a_c1 | Determines from QBO_Completeness_Supplement (sync 2026-11-07T15:00:00Z) that although qbo_ledger_completeness reports measured_through='2026-11-30', GL_Detail_Supplement_And_Billable_Lines reports verified_through='2026-11-07' (status='incomplete_after_2026-11-07' across 1,918 API-unavailable detail rows), bounding the effective verified ledger completeness horizon at 2026-11-07 rather than 2026-11-30. | Reasoning (qualitative) |
| cw130a_c2 | Verifies that Cleanroom Hourly Cohort A straddle run PR-2026-21 (service 2026-10-19 to 2026-11-01, check date 2026-11-05 <= 2026-11-07 verified horizon) has $0.00 native QBO payroll journal entries through 2026-11-07 (only raw bank debit ACH-1105 for $27,456.00 in 2140 Payroll Clearing) and computes the exact October 19-31 slice across 10 scheduled cleanroom shifts (1,200.0 hours at $32.00/hr out of 1,320.0 total run hours / $42,240.00 total gross wages, excluding Sunday 2026-11-01 shift of $3,840.00 wages and $293.76 employer tax) as $38,400.00 gross wages plus $2,937.60 employer payroll taxes at 7.65% = $41,337.60 total October employer accrual. | Reasoning (numerical) |
| cw130a_c3 | Excludes PR-2026-21 employee withholdings totaling $14,784.00 ($6,336.00 employee 401(k) and medical withholdings plus $8,448.00 employee income and FICA tax withholdings, which reduce $42,240.00 run gross wages to the $27,456.00 net direct deposit ACH-1105) from employer payroll expense, confirming must not include $14,784.00 employee withholdings in employer expense. | Reasoning (numerical) |
| cw130a_c4 | Provides the 2026-10-31 cutoff accrual journal entry for PR-2026-21: Dr 6110 Gross Wages $38,400.00 and Dr 6120 Employer Payroll Taxes $2,937.60 / Cr 2130 Accrued Payroll & Taxes $41,337.60, paired with the 2026-11-01 Day-1 auto-reversal entry Dr 2130 Accrued Payroll & Taxes $41,337.60 / Cr 6110 Gross Wages $38,400.00 and Cr 6120 Employer Payroll Taxes $2,937.60. | Reasoning (qualitative) |
| cw130a_c5 | Verifies Cohort A prior-period reversal JE-0991 on 2026-10-01 (Dr 2130 $15,286.30 / Cr 6110 $14,200.00 and Cr 6120 $1,086.30 against PR-2026-18's $20,400.00 wages and $1,560.60 employer tax on JE-1018, leaving $6,200.00 wages and $474.30 employer tax for October 1-4) plus mid-month PR-2026-20 on JE-1062 ($41,000.00 wages and $3,136.50 employer tax) and PR-2026-21's October accrual ($38,400.00 wages and $2,937.60 employer tax), reconciling Cohort A full-month October expense to $85,600.00 in 6110 Gross Wages and $6,548.40 in 6120 Employer Payroll Taxes ($92,148.40 total Cohort A employer cost). | Reasoning (numerical) |
| cw130a_c6 | Evaluates Lagged Semimonthly R&D Cohort B prior-period reversal JE-0992 on 2026-10-01 (Dr 2130 $20,991.75 / Cr 6110 $19,500.00 and Cr 6120 $1,491.75, which nets against PR-2026-17's JE-1034 on 2026-10-12 to $0.00 October impact) alongside first-half October run PR-2026-19 on JE-1071 ($46,000.00 wages and $3,519.00 employer tax) and second-half October run PR-2026-22 (service 2026-10-16 to 2026-10-31, $46,000.00 gross wages plus $3,519.00 employer tax = $49,519.00 candidate employer accrual). | Reasoning (numerical) |
| cw130a_c7 | Identifies that PR-2026-22's scheduled check and posting date of 2026-11-12 falls past the 2026-11-07 verified supplement completeness horizon (2026-11-12 > 2026-11-07), rendering absence of a native QBO payroll journal on 2026-11-12 unmeasured despite qbo_ledger_completeness reporting measured_through='2026-11-30'. | Reasoning (qualitative) |
| cw130a_c8 | Fails closed by placing PR-2026-22 on a named completeness_horizon_hold for $49,519.00 ($46,000.00 wages + $3,519.00 employer tax), refusing both unverified accrual posting and silent omission until GL_Detail_Supplement_And_Billable_Lines is synced and verified through at least 2026-11-12. | Reasoning (qualitative) |
Part B: Equal-Dollar Gusto ACH Pool Capacity, Unverified Off-Cycle Run Hold, Staged Draft Queue Governance & October Close Status
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw130b_c1 | Audits the two equal-dollar $11,480.00 Gusto bank ACH debits on 2026-10-15 (ACH-1015A 'GUSTO PAY 991042 REG' and ACH-1015B 'GUSTO PAY 991088 OFF-CYCLE', $22,960.00 combined cash outflow on 1000 Operating Checking) and binds native payroll journal JE-1055 (doc_num='GUSTO-991042' for PR-2026-30: Dr 6110 $15,000.00, Dr 6120 $1,147.50, Cr 2140 $11,480.00, Cr 2150 $4,667.50) exclusively 1-to-1 to ACH-1015A, exhausting JE-1055's pool capacity of 1 so JE-1055 cannot double-claim ACH-1015B. | Reasoning (numerical) |
| cw130b_c2 | Identifies that Purchase PUR-6012 ($11,480.00 on 2026-10-15 for ACH-1015B 'GUSTO PAY 991088 OFF-CYCLE') was wrongly auto-categorized by a QBO bank rule to 6180 Office Supplies, inflating 6180 from $1,250.00 actual Staples invoice PUR-6004 to $12,730.00 unadjusted, and provides the reclassifying entry Dr 2140 Payroll Clearing $11,480.00 / Cr 6180 Office Supplies $11,480.00. | Reasoning (numerical) |
| cw130b_c3 | Confirms that no provider payroll export exists in Payroll_Provider_Run_Register for off-cycle Gusto run 991088 and places ACH-1015B ($11,480.00 in 2140 Payroll Clearing) on a named unverified_payroll_run_hold, refusing to guess or extrapolate a gross-wage, employer-tax, and employee-withholding split from regular run 991042 until the authoritative Gusto run 991088 register is ingested. | Reasoning (qualitative) |
| cw130b_c4 | Evaluates pending staged payroll draft STG-301 (2026-10-22, $44,136.50: Dr 6110 $41,000.00 + Dr 6120 $3,136.50 / Cr 2130 $44,136.50 for mid-month run PR-2026-20) within the verified 2026-11-07 completeness horizon, confirming native payroll journal JE-1062 ($41,000.00 wages + $3,136.50 employer tax) is already synced on 2026-10-22 and withdrawing STG-301 as redundant to prevent a $44,136.50 double-count. | Reasoning (numerical) |
| cw130b_c5 | Evaluates pending 2026-11-01 Day-1 reversal draft STG-302 (auto-inverse of PR-2026-21's $41,337.60 October 31 cutoff accrual with Requested_Lookahead_End='2026-12-31'), clamping the withdrawal lookahead window end from 2026-12-31 to the 2026-11-07 verified supplement horizon rather than failing or trusting unmeasured dates, and retaining STG-302 ($41,337.60: Dr 2130 $41,337.60 / Cr 6110 $38,400.00 + Cr 6120 $2,937.60) on 2026-11-01 because $0.00 native QBO payroll journal entries exist for PR-2026-21 through 2026-11-07. | Reasoning (qualitative) |
| cw130b_c6 | Reconciles October 2026 P&L accounts on posted-audited items prior to held runs from unadjusted balances ($108,200.00 in 6110 Gross Wages, $8,277.30 in 6120 Employer Payroll Taxes, and $12,730.00 in 6180 Office Supplies) to $146,600.00 in 6110 Gross Wages (+$38,400.00 PR-2026-21 accrual), $11,214.90 in 6120 Employer Payroll Taxes (+$2,937.60 PR-2026-21 accrual), and $1,250.00 in 6180 Office Supplies (-$11,480.00 PUR-6012 reclassification, retaining only PUR-6004). | Reasoning (numerical) |
| cw130b_c7 | Reconciles October 31, 2026 payroll liability and clearing balances prior to held runs from $0.00 unadjusted 2130 Accrued Payroll & Taxes ($36,278.05 opening balance cleared by $15,286.30 JE-0991 and $20,991.75 JE-0992) and $0.00 unadjusted 2140 Payroll Clearing to $41,337.60 credit in 2130 Accrued Payroll & Taxes (PR-2026-21 cutoff accrual) and $11,480.00 debit balance in 2140 Payroll Clearing (held ACH-1015B / PUR-6012 reclassification pending Gusto run 991088). | Reasoning (numerical) |
| cw130b_c8 | Refuses to assign close status certified or closed_with_estimates for 2026-10 and assigns blocked_on_completeness_and_source_holds until both completeness_horizon_hold on PR-2026-22 ($49,519.00 candidate R&D payroll accrual past the 2026-11-07 supplement horizon) and unverified_payroll_run_hold on ACH-1015B ($11,480.00 off-cycle Gusto run 991088 lacking a provider register) are resolved. | Reasoning (qualitative) |
Case 30 · Profit First Multi-Bank Sweeps & IRS Form 1040-ES Draws
Catalyst B2B Advisory Corp. (S-Corp) · $40,000 Phantom Sweep Revenue + $16,500 Personal Tax Payment Expensed
1. What Happened on the Books
Using a 5-account Relay 'Profit First' setup ($160,000 true client retainers), a 50% internal bank allocation transfer ($40,000) from Income Checking to OpEx Checking was booked as new revenue, and a $16,500 IRS Form 1040-ES personal estimated tax ACH was expensed on the S-Corp P&L.
2. What Raw AI Gets Wrong
Raw AI counts internal Profit First percentage transfers between Relay sub-accounts as customer revenue ($200,000 instead of $160,000) and deducts the owner's personal Form 1040-ES tax payment as corporate tax expense.
3. How Level Playbooks Fix It (100%)
Level pairs all multi-bank Profit First percentage sweeps to $0 net P&L impact, keeps W-2 officer salary ($10,000 gross + $765 FICA) in payroll, and moves the $16,500 Form 1040-ES payment to Shareholder Distributions.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Profit First Multi-Bank Sweep Revenue/Expense Elimination, Duplicate Feed Transfer & Month-End In-Transit Cutoff
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw132a_c1 | Reconciles October 2026 true customer retainer collections in 1010 Relay Income Checking to $160,000.00 ($80,000.00 Oct 10 batch from DEP-1001 $48,000.00 + DEP-1002 $32,000.00; $60,000.00 Oct 25 batch from DEP-1003 $35,000.00 + DEP-1004 $25,000.00; and $20,000.00 Oct 31 batch from DEP-1005) and verifies the 5% / 30% / 15% / 50% Profit First sweep allocations totaling $160,000.00 ($8,000.00 Profit, $48,000.00 Owner's Comp, $24,000.00 Tax Hold, and $80,000.00 OpEx). | Reasoning (numerical) |
| cw132a_c2 | Eliminates the $40,000.00 phantom retainer revenue and uncategorized asset on the 2026-10-10 50% OpEx sweep TXN-PF-10A (FEED-1010-10A and FEED-1050-10A) via Dr 4100 Agency Retainer Revenue $40,000.00 / Cr 1099 Uncategorized Asset $40,000.00, reducing 4100 Agency Retainer Revenue from $200,000.00 unadjusted to $160,000.00 audited and clearing 1099 Uncategorized Asset from $40,000.00 to $0.00. | Reasoning (numerical) |
| cw132a_c3 | Eliminates both phantom P&L legs on the 2026-10-10 15% Tax Hold sweep TXN-PF-10B (FEED-1010-10B and FEED-1040-10B) via Dr 4900 Other Income $12,000.00 / Cr 6820 Taxes & Licenses $12,000.00, reducing both 4900 Other Income and 6820 Taxes & Licenses from $12,000.00 unadjusted to $0.00 audited. | Reasoning (numerical) |
| cw132a_c4 | Identifies that the 2026-10-25 5% Profit sweep TXN-PF-25P ($3,000.00) was added twice as separate bank-feed transfers (JE-XFER-25A and JE-XFER-25B, booking $6,000.00 total) and reverses the duplicate transfer via Dr 1010 Relay Income Checking $3,000.00 / Cr 1020 Relay Profit Hold Checking $3,000.00. | Reasoning (numerical) |
| cw132a_c5 | Records the 2026-10-31 month-end straddling sweep cutoff for TXN-PF-31S ($20,000.00 cleared on 1010 statement on 2026-10-31 across $1,000.00 #0102, $6,000.00 #0103, $3,000.00 #0104, and $10,000.00 #0105, settling destination accounts on 2026-11-02) via Dr 1095 Cash in Transit - Interbank Sweeps $20,000.00 / Cr 1010 Relay Income Checking $20,000.00, with $0.00 premature destination bank debits on 2026-10-31. | Reasoning (numerical) |
| cw132a_c6 | Reconciles 1010 Relay Income Checking from $17,000.00 unadjusted to $0.00 audited (+$3,000.00 duplicate transfer reversal less $20,000.00 TXN-PF-31S sweep) and 1020 Relay Profit Hold Checking from $19,000.00 unadjusted to $16,000.00 audited (-$3,000.00 duplicate transfer reversal), tying 100% to their October 31, 2026 Relay statement ending balances. | Reasoning (numerical) |
| cw132a_c7 | Confirms $0.00 bank-balance adjustments on 1030 Relay Owner's Comp Checking ($18,235.00), 1040 Relay Tax Hold Checking ($17,200.00), and 1050 Relay OpEx Checking ($52,300.00), reconciling all five Relay checking accounts ($103,735.00 combined October 31 statement ending cash) plus 1095 Cash in Transit - Interbank Sweeps ($20,000.00) to $123,735.00 consolidated cash and cash in transit. | Reasoning (numerical) |
| cw132a_c8 | Quantifies the net Task A interbank sweep P&L adjustment as -$52,000.00 total reported income (from $212,000.00 unadjusted across 4100 $200,000.00 + 4900 $12,000.00 to $160,000.00 true revenue), -$12,000.00 in 6820 Taxes & Licenses, and -$40,000.00 net reduction in pre-Task-B Net Income, while preserving all matched interbank transfers (JE-XFER-10P, JE-XFER-10C, JE-XFER-25A, JE-XFER-25C, JE-XFER-25T, JE-XFER-25X). | Reasoning (qualitative) |
Part B: S-Corp Owner's Comp Off-Payroll Draws vs W-2 Wages, IRS Form 1040-ES vs Elected CA PTET & Post-Close Balance Sheet
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw132b_c1 | Distinguishes Gusto W-2 officer payroll PR-1015 ($10,000.00 gross officer wages in 6110 + $765.00 employer FICA in 6120 = $10,765.00 cash draft) from off-payroll shareholder Zelle/ACH draws PAY-OC-101 ($14,000.00 on 2026-10-12) and PAY-OC-102 ($14,000.00 on 2026-10-27), reclassifying Dr 3310 Shareholder Distributions $28,000.00 / Cr 6110 Officer Wages & Salaries $28,000.00 so 6110 reconciles from $38,000.00 unadjusted to $10,000.00 audited W-2 wages. | Reasoning (numerical) |
| cw132b_c2 | Reclassifies the 2026-10-15 $16,500.00 IRS EFTPS Form 1040-ES individual estimated tax payment (ACH-IRS-1040ES, applied to the sole shareholder's personal SSN) via Dr 3310 Shareholder Distributions $16,500.00 / Cr 6890 Corporate Income Tax Expense $16,500.00, reducing 6890 from $16,500.00 unadjusted to $0.00 audited. | Reasoning (numerical) |
| cw132b_c3 | Recognizes the 2026-10-15 $9,300.00 California FTB Form 3893 Pass-Through Entity Tax payment (ACH-CA-PTET, Entity FEIN, timely 2026 AB 150 / IRS Notice 2020-75 entity-level state income tax election) as an entity-level expense, reclassifying Dr 6895 State Pass-Through Entity Tax (PTET) Expense $9,300.00 / Cr 3310 Shareholder Distributions $9,300.00. | Reasoning (numerical) |
| cw132b_c4 | Preserves the 2026-10-03 $3,000.00 Profit Hold shareholder bonus distribution (ACH-PF-DIST) in 3310 Shareholder Distributions ($0.00 adjustment) and preserves third-party operating expenses in 6310 ($38,500.00 across PUR-5501 $32,000.00 media and PUR-5503 $6,500.00 Gusto 1099 contractor) and 6410 ($14,200.00 PUR-5502 SaaS) with $0.00 reclassification. | Reasoning (qualitative) |
| cw132b_c5 | Reconciles 3310 Shareholder Distributions from $12,300.00 unadjusted ($3,000.00 ACH-PF-DIST + $9,300.00 misposted ACH-CA-PTET) to $47,500.00 audited ($12,300.00 unadjusted + $28,000.00 off-payroll 1030 draws + $16,500.00 IRS Form 1040-ES - $9,300.00 CA PTET reclass = $47,500.00, comprising $28,000.00 + $16,500.00 + $3,000.00; net +$35,200.00 increase). | Reasoning (numerical) |
| cw132b_c6 | Reconciles total October 2026 expenses from $119,965.00 unadjusted (6110 $38,000.00 + 6120 $765.00 + 6310 $38,500.00 + 6410 $14,200.00 + 6820 $12,000.00 + 6890 $16,500.00) to $72,765.00 audited (6110 $10,000.00 + 6120 $765.00 + 6310 $38,500.00 + 6410 $14,200.00 + 6895 $9,300.00; net -$47,200.00 reduction). | Reasoning (numerical) |
| cw132b_c7 | Reconciles October 2026 Net Income from $92,035.00 unadjusted ($212,000.00 unadjusted income less $119,965.00 unadjusted expenses) to $87,235.00 audited ($160,000.00 audited 4100 revenue less $72,765.00 audited total expenses; net -$4,800.00 change = -$40,000.00 Task A sweep fixes + $35,200.00 Task B draw/tax reclassifications). | Reasoning (numerical) |
| cw132b_c8 | Proves the post-close October 31, 2026 Balance Sheet tie-out: Total Assets $123,735.00 ($103,735.00 across the five Relay checking accounts + $20,000.00 1095 Cash in Transit - Interbank Sweeps + $0.00 1099) equals Total Liabilities $6,500.00 (2000 Accounts Payable) plus Total Stockholders' Equity $117,235.00 ($77,500.00 3100 Common Stock & Retained Earnings + $87,235.00 audited Net Income - $47,500.00 3310 Shareholder Distributions). | Reasoning (numerical) |
Case 31 · Two-Owner S-Corp Personal Card Spend & 60/40 Payout Rules
Ridgeline Custom Builders Inc. (60/40 S-Corp) · $22,000 Personal Card Spend in Expenses + Unequal 60/40 S-Corp Payout Risk
1. What Happened on the Books
In a 60%/40% two-owner S-Corp, Owner A put $18,200 of personal kitchen cabinets and family travel on the company Amex while Owner B charged a $3,800 personal watch, on top of unequal cash draws ($15,000 and $10,000) that did not match their 60/40 ownership split.
2. What Raw AI Gets Wrong
Unassisted AI either leaves personal kitchen cabinets and watches inside business expenses or books unequal owner draws that risk breaking IRS S-Corp tax rules (which require owner payouts to match ownership percentages).
3. How Level Playbooks Fix It (100%)
Level removes all $22,000 of personal card charges from P&L expenses, aligns owner distributions to the exact 60%/40% ownership split, and tracks any temporary imbalance in a formal Due From Shareholder note.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: S-Corp Personal Card Commingling, Unsubstantiated Cash Withdrawals & >2% Shareholder Health Insurance
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw133a_c1 | Identifies $18,200.00 of personal Corporate Amex charges by 60% Shareholder A (AMEX-401 $11,400.00 residential kitchen cabinets in 5210, AMEX-404 $4,850.00 family Hawaii trip in 6410, and AMEX-409 $1,950.00 country club dues in 6420) plus $6,000.00 of unsubstantiated cash withdrawals (CHK-WDR-01 $3,500.00 and CHK-WDR-02 $2,500.00 in 6290), totaling $24,200.00 for Shareholder A. | Reasoning (numerical) |
| cw133a_c2 | Identifies AMEX-412 ($3,800.00 personal luxury watch in 6450 Promotional Gifts) as personal spend by 40% Shareholder B while retaining AMEX-415 ($2,400.00 FallTech OSHA roof harnesses delivered to Job #26-44) in 5210 Job Materials COGS. | Reasoning (numerical) |
| cw133a_c3 | Computes total disguised personal spend removed from COGS and operating expenses as $28,000.00 ($24,200.00 Shareholder A + $3,800.00 Shareholder B), reducing 5210 Job Materials COGS from $68,400.00 to $57,000.00. | Reasoning (numerical) |
| cw133a_c4 | Reconciles audited expense sub-accounts after personal-spend removal to $3,200.00 in 6290 Shop Supplies, $1,300.00 in 6410 Business Travel, $800.00 in 6420 Client Meals, and $500.00 in 6450 Promotional Gifts. | Reasoning (numerical) |
| cw133a_c5 | Identifies $3,500.00 of >2% S-corporation shareholder medical premiums (ACH-MED-A $2,100.00 for 60% Shareholder A and ACH-MED-B $1,400.00 for 40% Shareholder B) improperly posted to tax-free 6135 Employee Health Benefits alongside $5,400.00 of non-owner crew medical. | Reasoning (numerical) |
| cw133a_c6 | Reclassifies Dr 6115 Officer >2% Health Insurance $3,500.00 / Cr 6135 Employee Health Benefits $3,500.00 (leaving $5,400.00 in 6135 and $0.00 net P&L change). | Reasoning (numerical) |
| cw133a_c7 | Flags a mandatory payroll compliance hold requiring the >2% shareholder health insurance premiums ($2,100.00 SH-A and $1,400.00 SH-B) to be included in W-2 Box 1 wages (and Box 14) before year-end under IRC Section 162(l) and IRS Notice 2008-1 to preserve corporate deductibility. | Reasoning (qualitative) |
| cw133a_c8 | Reconciles October 2026 total COGS and operating expenses from $157,000.00 unadjusted to $129,000.00 audited (-$28,000.00) and October 2026 Net Income from $38,000.00 unadjusted to $66,000.00 audited on $195,000.00 revenue. | Reasoning (numerical) |
Part B: S-Corp 60/40 Pro-Rata Distribution Equalization, Shareholder Loan Split, Zero-W2 Officer Risk & Stock Basis Excess
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw133b_c1 | Demonstrates that booking all $24,200.00 (SH-A) and $3,800.00 (SH-B) directly to shareholder distributions on top of $15,000.00 and $10,000.00 cash distributions would yield $39,200.00 (73.96%) vs $13,800.00 (26.04%) on $53,000.00 total, violating the executed 60%/40% Corporate Bylaws (Section 7.4) and requiring corrective equalization under NOTE-2026-A to align with governing pro-rata stock rights. | Reasoning (numerical) |
| cw133b_c2 | Applies Section 7.4 Corporate Bylaws (NOTE-2026-A) by matching Shareholder B's $3,800.00 (40%) to establish an incremental 60%/40% pro-rata distribution pool of $9,500.00 ($5,700.00 to 3310 Distributions - Shareholder A and $3,800.00 to 3320 Distributions - Shareholder B). | Reasoning (numerical) |
| cw133b_c3 | Records Shareholder A's non-pro-rata excess of $18,500.00 ($24,200.00 less $5,700.00 pro-rata distribution slice) as a formal receivable Dr 1380 Due from Shareholder A $18,500.00 under promissory note NOTE-2026-A. | Reasoning (numerical) |
| cw133b_c4 | Verifies audited October 2026 cumulative distributions of $20,700.00 in 3310 (60.00%) and $13,800.00 in 3320 (40.00%) totaling $34,500.00, preserving exact 60.00% / 40.00% pro-rata parity. | Reasoning (numerical) |
| cw133b_c5 | Flags critical IRS reasonable-compensation payroll tax exposure on active full-time officer Elena Rostova (SH-B, 45 hrs/wk VP Field Ops) receiving $0.00 YTD W-2 wages while taking $77,800.00 in YTD S-corp distributions. | Reasoning (qualitative) |
| cw133b_c6 | Computes Shareholder B's pre-distribution stock basis ceiling as $70,000.00 ($58,000.00 Jan 1, 2026 stock basis + $12,000.00 allocable YTD net income share, with $0.00 shareholder loan basis). | Reasoning (numerical) |
| cw133b_c7 | Computes Shareholder B's audited YTD distributions through 2026-10-31 as $77,800.00 ($64,000.00 prior Jan-Sep + $13,800.00 audited October) and identifies $7,800.00 of distributions in excess of stock basis taxable as capital gain under IRC Section 1368(b)(2) with $0.00 ending stock basis. | Reasoning (numerical) |
| cw133b_c8 | Places a named close/tax governance hold (scorp_pro_rata_and_reasonable_comp_hold) preventing final tax/equity certification until W-2 officer payroll, Box 1 medical inclusion, and NOTE-2026-A repayment terms are attested. | Reasoning (qualitative) |
Case 32 · Undeposited Funds Equity Plug & Vested PTO vs. Sick Leave
Pacific Coast Engineering Services · $38,450 Undeposited Funds Plug + $3,816 Non-Vesting Sick Leave Over-Accrual
1. What Happened on the Books
A prior bookkeeper cleared -$38,450.00 of stale Undeposited Funds with an improper Opening Balance Equity plug while double-counting a $29,700.00 mobile check batch ($18,500 + $11,200). At month-end, HR exported both vested vacation hours (after an Oct 1 pay raise) and 84 hours ($3,816) of non-vesting statutory sick leave.
2. What Raw AI Gets Wrong
Raw AI accepts the -$38,450 Opening Balance Equity plug, leaves the $29,700 check batch double-counted in revenue, values PTO at old pre-raise pay rates, and accrues non-vesting statutory sick leave onto the Balance Sheet.
3. How Level Playbooks Fix It (100%)
Level reverses the Opening Balance Equity plug, links the $29,700 mobile deposit to the two open customer payments, values vested vacation at current Oct 31 pay rates under ASC 710, and excludes non-vesting sick time.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Undeposited Funds Opening Balance Equity Plug Reversal, Double-Counted Bank-Feed Revenue, Stripe Fee Netting & Deposit in Transit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw134a_c1 | Identifies JE-UF-99 (-$38,450.00 credited to 12000 Undeposited Funds against Dr 3900 Opening Balance Equity $38,450.00) as an improper equity cleanup plug and reverses it via Dr 12000 Undeposited Funds $38,450.00 / Cr 3900 Opening Balance Equity $38,450.00, restoring 3900 to $0.00 and pre-cleanup 12000 to $47,850.00. | Reasoning (numerical) |
| cw134a_c2 | Matches mobile check deposit batch DEP-1010 ($29,700.00 on 2026-10-10) to customer payments PMT-801 ($18,500.00) and PMT-802 ($11,200.00) and eliminates the duplicate bank-feed revenue via Dr 4100 Product Sales $29,700.00 / Cr 12000 Undeposited Funds $29,700.00. | Reasoning (numerical) |
| cw134a_c3 | Matches net Stripe payout DEP-1020 ($8,750.00 net cash on 2026-10-20) to customer payment PMT-803 ($9,000.00 gross less $250.00 Stripe fee) and records Dr 4100 Product Sales $8,750.00 and Dr 6540 Merchant Processing Fees $250.00 / Cr 12000 Undeposited Funds $9,000.00. | Reasoning (numerical) |
| cw134a_c4 | Explains why the bookkeeper's $38,450.00 net-cash plug misstated 12000 Undeposited Funds at $9,400.00 by $250.00 (omitting the $250.00 Stripe fee withheld from PMT-803's $9,000.00 gross receipt). | Reasoning (numerical) |
| cw134a_c5 | Retains PMT-804 ($9,150.00 physical check received 2026-10-31 and cleared bank 2026-11-03) in 12000 Undeposited Funds as a genuine month-end deposit in transit, verifying audited 12000 Undeposited Funds = $9,150.00. | Reasoning (numerical) |
| cw134a_c6 | Computes total duplicate bank-feed revenue removed from 4100 Product Sales as $38,450.00 ($29,700.00 DEP-1010 + $8,750.00 DEP-1020), reconciling 4100 Product Sales from $278,450.00 unadjusted to $240,000.00 audited. | Reasoning (numerical) |
| cw134a_c7 | Reconciles audited 6540 Merchant Processing Fees from $410.00 unadjusted to $660.00 (+$250.00 Stripe fee on PMT-803) while keeping 1010 Operating Checking unchanged at $164,200.00 ($0.00 bank-statement variance). | Reasoning (numerical) |
| cw134a_c8 | Computes the net Task A pre-accrual P&L impact as -$38,700.00 (-$38,450.00 duplicate revenue reversal and +$250.00 merchant fee expense). | Reasoning (numerical) |
Part B: ASC 710 Vested PTO Rollforward with Pay-Rate Raise & FICA, Non-Vesting Sick Exclusion & Audited-Revenue Bonus Accrual
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw134b_c1 | Values 2026-10-31 vested vacation hours at October 31 pay rates (including EMP-01's 2026-10-01 raise from $45.00/hr to $50.00/hr across all 160.0 hours = $8,000.00, EMP-02 150.0 hrs = $6,600.00, and EMP-03 100.0 hrs = $3,800.00) for $18,400.00 gross vested vacation wages. | Reasoning (numerical) |
| cw134b_c2 | Excludes all 84.0 non-vesting California statutory sick-leave hours ($3,816.00 gross wages across EMP-01 $2,000.00, EMP-02 $1,056.00, and EMP-03 $760.00) from the 2145 Accrued PTO liability under ASC 710-10-25-7 because sick hours do not vest or pay out at termination. | Reasoning (numerical) |
| cw134b_c3 | Adds 7.65% employer FICA ($1,407.60 on $18,400.00 gross vested vacation) to establish an audited 2026-10-31 ending 2145 Accrued PTO liability of $19,807.60. | Reasoning (numerical) |
| cw134b_c4 | Records the October 2026 PTO rollforward adjustment against the $15,953.73 opening carryforward ($14,820.00 wages + $1,133.73 FICA) via Dr 6118 PTO Wage Expense $3,580.00 and Dr 6120 Employer Payroll Taxes $273.87 / Cr 2145 Accrued PTO $3,853.87. | Reasoning (numerical) |
| cw134b_c5 | Computes the formulaic shop output bonus under PLAN-BON-01 as 2.00% of audited October 4100 Product Sales of $240,000.00 (not unadjusted $278,450.00), yielding $4,800.00 bonus wages plus 7.65% employer FICA of $367.20 = $5,167.20 total. | Reasoning (numerical) |
| cw134b_c6 | Records Dr 6119 Bonus Expense $4,800.00 and Dr 6120 Employer Payroll Taxes $367.20 / Cr 2135 Accrued Bonuses $5,167.20, bringing audited 6120 Employer Payroll Taxes from $4,896.00 to $5,537.07 (+$641.07 total FICA accrued across PTO and bonus). | Reasoning (numerical) |
| cw134b_c7 | Accrues $0.00 for MEMO-DISC-02 ($25,000.00 uncommunicated discretionary CEO pool subject to Q1 2027 Board approval) because no legal or constructive present obligation exists at 2026-10-31 under ASC 710 / ASC 450. | Reasoning (qualitative) |
| cw134b_c8 | Computes total October 2026 P&L adjustments across Tasks A and B as -$47,721.07 (-$38,450.00 revenue and +$9,271.07 expenses: $250.00 Stripe fee + $3,853.87 PTO & FICA + $5,167.20 bonus & FICA), reconciling October 2026 Net Income from $68,644.00 unadjusted to $20,922.93 audited ($240,000.00 revenue less $219,077.07 audited COGS and expenses). | Reasoning (numerical) |
Case 33 · Corporate Card Parent-Account Credits & Duplicate Autopays
Meridian Commercial Services LLC · $25,000 Duplicate Card Autopay + Missed Parent-Account Rebate Credits
1. What Happened on the Books
In a multi-card Amex hierarchy (Account 2150), -$1,200 of annual rebate credits and +$550 of annual fees posted directly to the parent account rather than sub-cards, $3,490 of Nov 1-4 charges bled into the export, and a $25,000 card autopay plus a $15,000 cash replenishment were each recorded twice in Checking.
2. What Raw AI Gets Wrong
Unassisted AI sums only employee sub-cards (missing parent-level rebates and fees), includes post-cutoff November card charges in October, and misses the duplicate $25,000 autopay and $15,000 transfer.
3. How Level Playbooks Fix It (100%)
Level reconciles the full parent + sub-card hierarchy to $29,680.00 as of October 31, strips November post-cutoff charges, and reverses the duplicate autopay and transfer to restore $148,250.00 of true Operating Checking cash.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Consolidated 2150 Corporate Card Hierarchy Tie-Out, Post-Cutoff Feed Exclusion, Deleted Charge Restoration & Missing Bank Statement Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw135a_c1 | Computes the implied October 31, 2026 Amex corporate card bank-feed proxy liability as $29,680.00 by backing out $3,490.00 of post-cutoff November 1 - 4 settled feed charges ($2,850.00 FEED-AMEX-N1 on 2026-11-02 and $640.00 FEED-AMEX-N2 on 2026-11-03) from the November 4, 2026 live running feed balance of $33,170.00. | Reasoning (numerical) |
| cw135a_c2 | Includes standalone parent-account postings directly on 2150 Corporate Card Master (-$1,200.00 CC-2150-REB Carrier rebate credit and +$550.00 CC-2150-FEE annual fee, net -$650.00 before payments) alongside child subaccounts 2151 and 2152, avoiding the $30,330.00 leaf-minus-payment error that omits standalone parent activity. | Reasoning (numerical) |
| cw135a_c3 | Identifies that the October 20, 2026 $25,000.00 Amex autopayment (FEED-1010-05 / FEED-AMEX-06) was posted twice in QuickBooks Online via CCP-408 and EXP-912 (-$50,000.00 combined debit), requiring reversal of EXP-912 via Dr 1010 Operating Checking $25,000.00 / Cr 2150 Corporate Card Master $25,000.00. | Reasoning (numerical) |
| cw135a_c4 | Identifies from AUD-4409 and FEED-AMEX-01 that cleared October 3, 2026 Trane Commercial Supply charge TXN-8841 ($2,340.00 on 2151) was deleted on October 22, 2026, requiring restoration via Dr 5120 HVAC Parts & Refrigerant COGS $2,340.00 / Cr 2151 Card - Field Lead #9014 $2,340.00. | Reasoning (numerical) |
| cw135a_c5 | Reconciles unadjusted October 31, 2026 card GL balances (-$50,650.00 standalone 2150 + $29,080.00 2151 + $23,910.00 2152 = $2,340.00 consolidated) to audited balances (-$25,650.00 standalone 2150 + $31,420.00 2151 + $23,910.00 2152 = $29,680.00 consolidated), tying 100.00% ($0.00 variance) to the $29,680.00 October 31 bank-feed proxy. | Reasoning (numerical) |
| cw135a_c6 | Refuses to mark 2150 Corporate Card Master as statement_certified because statement_doc_id is NULL and no October 2026 PDF card statement is custodied, placing a named bank_feed_proxy_hold / preliminary_bank_feed_proxy disclosure pending statement retrieval. | Reasoning (qualitative) |
| cw135a_c7 | Verifies October 2026 gross card charge subtotals by cardholder subaccount: $18,420.00 on 2151 (#9014: $2,340.00 restored TXN-8841 + $16,080.00 CC-2151-01) and $14,910.00 on 2152 (#9022: $9,400.00 CC-2152-01 + $3,110.00 CC-2152-02 + $2,400.00 CC-2152-03), on top of the $22,000.00 combined October 1 opening liability ($13,000.00 + $9,000.00). | Reasoning (numerical) |
| cw135a_c8 | Confirms post-cutoff November 2 - 3 feed charges FEED-AMEX-N1 ($2,850.00) and FEED-AMEX-N2 ($640.00) represent November 2026 purchases and must not be accrued into October 2026 COGS or expenses ($0.00 October accrual). | Reasoning (qualitative) |
Part B: 1010/1020 Cash Tie-Out, Asymmetric Transfer+Deposit Reversal, Unposted For Review Queue & Post-Close Balance Sheet
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw135b_c1 | Reconciles 1010 Operating Checking from $123,250.00 unadjusted QBO book balance to $148,250.00 audited by reversing duplicate $25,000.00 card autopay EXP-912, tying 100.00% ($0.00 variance) to custodied Chase PDF statement DOC-OCT-1010 ($148,250.00, statement_certified). | Reasoning (numerical) |
| cw135b_c2 | Catches the asymmetric cross-entity-kind double-booking on the $15,000.00 replenishment transfer (FEED-1020-02) posted both as native Transfer TRF-801 and duplicate Deposit DEP-809 to 4100 Commercial HVAC Service Revenue, reversing DEP-809 via Dr 4100 Commercial HVAC Service Revenue $15,000.00 / Cr 1020 Field Emergency Checking $15,000.00. | Reasoning (numerical) |
| cw135b_c3 | Identifies $4,400.00 of unposted October 2026 bank-feed For Review charges in 1020 (FEED-1020-RV1 $3,150.00 United Refrigeration on 2026-10-26 and FEED-1020-RV2 $1,250.00 Sunbelt Towing on 2026-10-29), booking Dr 5120 HVAC Parts & Refrigerant COGS $3,150.00 and Dr 6210 Fleet Fuel & Maintenance $1,250.00 / Cr 1020 Field Emergency Checking $4,400.00. | Reasoning (numerical) |
| cw135b_c4 | Rejects the junior bookkeeper's $53,800.00 statement_certified register self-tie on 1020 (where statement_doc_id is NULL), reconciling 1020 from $53,800.00 unadjusted to $34,400.00 audited ($53,800.00 - $15,000.00 DEP-809 - $4,400.00 For Review items) and capping 1020 at preliminary_bank_feed_proxy / bank_feed_proxy_hold. | Reasoning (numerical) |
| cw135b_c5 | Reconciles October 2026 4100 Commercial HVAC Service Revenue from $110,000.00 unadjusted ($95,000.00 INV-1001 + $15,000.00 duplicate DEP-809) to $95,000.00 audited (-$15,000.00 adjustment). | Reasoning (numerical) |
| cw135b_c6 | Reconciles October 2026 total COGS and operating expenses from $83,290.00 unadjusted (5120 $24,280.00 + 5140 $6,200.00 + 6110 $46,750.00 + 6210 $3,110.00 + 6420 $2,950.00) to $90,030.00 audited (+$6,740.00 = +$2,340.00 TXN-8841 in 5120 + $3,150.00 FEED-1020-RV1 in 5120 + $1,250.00 FEED-1020-RV2 in 6210, bringing 5120 to $29,770.00 and 6210 to $4,360.00). | Reasoning (numerical) |
| cw135b_c7 | Reconciles October 2026 Net Income from $26,710.00 unadjusted ($110,000.00 revenue less $83,290.00 expenses) to $4,970.00 audited ($95,000.00 revenue less $90,030.00 expenses; net -$21,740.00 change). | Reasoning (numerical) |
| cw135b_c8 | Proves the post-close October 31, 2026 Balance Sheet tie-out: Total Assets $207,650.00 ($148,250.00 1010 + $34,400.00 1020 + $25,000.00 1100) equals Total Liabilities $47,680.00 ($18,000.00 2000 + $29,680.00 consolidated 2150) plus Total Stockholders' Equity $159,970.00 ($155,000.00 3100 Retained Earnings + $4,970.00 audited Net Income), with close status held pending 1020 and 2150 PDF statements. | Reasoning (numerical) |
Case 34 · Cloud Warehouse Software Setup Costs & Prepaid Insurance
Cascade Distribution & Logistics Inc. · $24,000 Software Setup Expensed Upfront + Insurance Posted to Wrong Account
1. What Happened on the Books
An invoice for new cloud warehouse software bundled $24,000 of one-time system setup with staff training and monthly subscription fees, while a draft entry subtracted $4,500 of monthly insurance from Accrued Liabilities instead of Prepaid Insurance.
2. What Raw AI Gets Wrong
Raw AI either expenses the entire software setup bill in Month 1 or capitalizes employee training costs that must be expensed, and posts the $4,500 insurance entry to the wrong Balance Sheet account.
3. How Level Playbooks Fix It (100%)
Level separates one-time cloud setup ($24,000 spread over the contract under ASC 350-40) from training and monthly fees, and deducts the $4,500 monthly insurance directly from Prepaid Expenses.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Prepaid Rollforward, ASC 350-40 Cloud Implementation Split, Draft Rejection & Disclosed vs Undisclosed Unscheduled Carryforward
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw136a_c1 | Computes October 2026 insurance amortization from 1350 as $3,000.00 on POL-2026-GL ($27,000.00 carrying -> $24,000.00 ending) and $1,500.00 on POL-2026-CYBER ($18,000.00 paid Oct 1 -> $16,500.00 ending), totaling $4,500.00 Dr 6310 Insurance Expense / Cr 1350. | Reasoning (numerical) |
| cw136a_c2 | Rejects unposted junior draft DRAFT-JE-409 ($4,500.00 crediting 2190 Accrued Expenses with $0.00 prior liability instead of 1350), explaining that both policies were already paid upfront into 1350 and crediting/releasing 2190 would leave 1350 overstated and distort 2190. | Reasoning (qualitative) |
| cw136a_c3 | Retains the $12,000.00 Arctic Rack Systems wire advance (BILL-PMT-712, 0% delivered in October 2026) in 1350 at $12,000.00 ($0.00 October P&L expense) under a provisional_with_true_up trigger upon December 2026 racking delivery and installation. | Reasoning (numerical) |
| cw136a_c4 | Splits CloudCold WMS arrangement INV-WMS-901 ($54,000.00) under ASC 350-40 into (1) $18,000.00 Year-1 hosted SaaS subscription ($1,500.00 Oct amortization, $16,500.00 ending in 1350), (2) $24,000.00 capitalizable application-development configuration reclassified to 1370 and amortized over the 36-month hosted term ($666.67 Oct amortization, $23,333.33 ending net 1370), and (3) $12,000.00 non-capitalizable data migration ($7,200.00) and training ($4,800.00) expensed 100% in October 2026. | Reasoning (numerical) |
| cw136a_c5 | Computes the October 31, 2026 scheduled active carrying balance in 1350 as $69,000.00 ($24,000.00 POL-2026-GL + $16,500.00 POL-2026-CYBER + $12,000.00 BILL-PMT-712 advance + $16,500.00 INV-WMS-901 Year-1 SaaS). | Reasoning (numerical) |
| cw136a_c6 | Retains the full $17,850.00 unscheduled carryforward in 1350 without fabricating a 12-month amortization schedule or writing it off unsupported, decomposing it into $3,240.00 disclosed utility deposit (LEGACY-DEP-01) and $14,610.00 undisclosed prior-CPA migration lump sum (LEGACY-LUMP-02). | Reasoning (numerical) |
| cw136a_c7 | Applies snapshot-lineage carryforward rules to confirm DISC-1350-UTIL ($3,240.00 in close_disclosed_items) remains validly disclosed across snapshot bump 10447 -> 10555 because its account_activity_sha256 (9f4b2c81e0a3) is unchanged, whereas UNDISC-1350-LUMP ($14,610.00) lacks disclosure and triggers an unscheduled_balance close hold. | Reasoning (qualitative) |
| cw136a_c8 | Reconciles total 1350 Prepaid Expenses & Vendor Advances from $128,850.00 unadjusted on October 31, 2026 ($44,850.00 opening + $84,000.00 October additions) to $86,850.00 audited ($69,000.00 scheduled + $17,850.00 unscheduled carryforward; -$42,000.00 net credit adjustment), alongside $23,333.33 net in 1370. | Reasoning (numerical) |
Part B: Adjusting Journal Entries, October P&L Prepaid/ASC 350-40 Recognition, Balance Sheet Tie-Out & Close-Readiness Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw136b_c1 | Provides the October 2026 insurance and SaaS amortization entries: Dr 6310 Insurance Expense $4,500.00 / Cr 1350 $4,500.00 ($3,000.00 POL-2026-GL + $1,500.00 POL-2026-CYBER) and Dr 6420 Software, Cloud SaaS & CCA Amortization $1,500.00 / Cr 1350 $1,500.00 (Year-1 WMS subscription). | Reasoning (numerical) |
| cw136b_c2 | Provides the ASC 350-40 reclassification and October recognition entries for INV-WMS-901: Dr 1370 Capitalized Cloud Implementation $24,000.00 and Dr 6430 Training & Data Migration Expense $12,000.00 / Cr 1350 $36,000.00, plus Dr 6420 $666.67 / Cr 1370 $666.67 (1/36 of $24,000.00). | Reasoning (numerical) |
| cw136b_c3 | Computes total October 2026 P&L recognition from prepaids and ASC 350-40 as $18,666.67 ($4,500.00 in 6310 + $2,166.67 in 6420 [$1,500.00 SaaS + $666.67 CCA amortization] + $12,000.00 in 6430), +$14,166.67 higher than the junior bookkeeper's rejected $4,500.00 DRAFT-JE-409. | Reasoning (numerical) |
| cw136b_c4 | Reconciles total October 2026 COGS and operating expenses from $116,000.00 unadjusted ($72,000.00 5100 + $44,000.00 6110) to $134,666.67 audited (+$18,666.67 adjustment). | Reasoning (numerical) |
| cw136b_c5 | Reconciles October 2026 Net Income on $160,000.00 of 4100 Revenue from $44,000.00 unadjusted ($160,000.00 less $116,000.00) to $25,333.33 audited ($160,000.00 less $134,666.67; -$18,666.67 change). | Reasoning (numerical) |
| cw136b_c6 | Verifies 2190 Accrued Expenses ends October 31, 2026 at $0.00 after rejecting DRAFT-JE-409. | Reasoning (numerical) |
| cw136b_c7 | Proves the post-close October 31, 2026 Balance Sheet tie-out: Total Assets $365,183.33 ($160,000.00 1010 + $95,000.00 1100 + $86,850.00 1350 + $23,333.33 1370) equals Total Liabilities $29,850.00 ($29,850.00 2000 + $0.00 2190) plus Total Stockholders' Equity $335,333.33 ($310,000.00 3100 Retained Earnings + $25,333.33 audited Net Income). | Reasoning (numerical) |
| cw136b_c8 | Determines close status is held (not ready) due specifically to the undisclosed $14,610.00 LEGACY-LUMP-02 unscheduled_balance pending prior-CPA support, while confirming the $3,240.00 DISC-1350-UTIL disclosed slice does not block on snapshot bump 10447 -> 10555. | Reasoning (qualitative) |
Case 35 · Agency Pass-Through Client Ad Spend & QuickBooks Plug Cleanup
Velvet Growth & Performance Agency LLC · Client Ad Spend Counted as Agency Revenue + $55,400 Unexplained Equity Plug
1. What Happened on the Books
A bank connection created a $25,000 duplicate entry in Opening Balance Equity (QuickBooks' catch-all plug account), and someone hid $55,400 of unexplained balance differences in Retained Earnings. Meanwhile, client Google/Meta ad money passing through the agency was counted as the agency's own Gross Revenue.
2. What Raw AI Gets Wrong
Unassisted AI counts client ad budgets passing through the agency as agency revenue (making the agency look far larger while crushing its profit margin %) and accepts the $55,400 plug into Retained Earnings.
3. How Level Playbooks Fix It (100%)
Level nets pass-through client ad budgets against ad bills (ASC 606) so revenue reflects true agency fees, reverses the $25,000 bank-connection duplicate, and holds historical equity plugs until matched to the CPA tax return.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: 3900 Opening Balance Equity Unwinding, Bank-Feed Duplicate Reversal, Check #1842 Reclassification & Pending CPA TB Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw137a_c1 | Identifies and reverses the unauthorized October 28 cosmetic OBE zero-out JE-OBE-229 ($55,400.00 swept into 3200 Retained Earnings without a CPA trial balance) via Dr 3200 Retained Earnings $55,400.00 / Cr 3900 Opening Balance Equity $55,400.00, restoring 3200 from $185,400.00 to $130,000.00. | Reasoning (numerical) |
| cw137a_c2 | Identifies and reverses the October 4 Plaid bank-feed auto-opening entry JE-OBE-201 ($25,000.00 duplicating October 2 funding transfer TRF-104) via Dr 3900 Opening Balance Equity $25,000.00 / Cr 1020 High-Yield Sweep Checking $25,000.00. | Reasoning (numerical) |
| cw137a_c3 | Reconciles 1020 High-Yield Sweep Checking from $50,000.00 unadjusted QBO balance to $25,000.00 audited, tying 100.00% ($0.00 variance) to the custodied October 31 Mercury PDF statement ($25,000.00). | Reasoning (numerical) |
| cw137a_c4 | Reclassifies the October 15 forced cash-reconciliation plug JE-OBE-214 ($4,200.00 for cleared Check #1842 to Vanguard Print Vendor, Invoice INV-VP-882) out of 3900 via Dr 6150 Marketing & Trade Shows $4,200.00 / Cr 3900 Opening Balance Equity $4,200.00. | Reasoning (numerical) |
| cw137a_c5 | Verifies 1010 Operating Checking ties 100.00% ($0.00 variance) at $112,400.00 to the custodied October 31 Chase PDF statement ($140,000.00 opening - $25,000.00 TRF-104 - $4,200.00 Check #1842 + $190,000.00 PMT-7010 - $160,000.00 BILL-PMT-7020 - $28,400.00 EXP-7030). | Reasoning (numerical) |
| cw137a_c6 | Reconciles 3900 Opening Balance Equity from $0.00 unadjusted (cosmetically masked) to $34,600.00 audited ($0.00 + $55,400.00 JE-OBE-229 reversal - $25,000.00 JE-OBE-201 reversal + $4,200.00 JE-OBE-214 reclass = $34,600.00 2026-01-01 cutover balance). | Reasoning (numerical) |
| cw137a_c7 | Retains the $34,600.00 unattributed 2026-01-01 cutover balance in 3900 Opening Balance Equity under a mandatory named close hold (pending_cpa_trial_balance) because 2025 cpa_signed_tb_status is MISSING_PENDING_EXTERNAL_CPA. | Reasoning (qualitative) |
| cw137a_c8 | Refuses to sweep the remaining $34,600.00 cutover OBE into 3200 Retained Earnings without the signed 2025 CPA adjusted trial balance and Form 1065 K-1 capital rollforward, explaining that silent OBE-to-RE plugs corrupt prior-year tax-to-book equity tie-outs. | Reasoning (qualitative) |
Part B: ASC 606 Principal-vs-Agent Gross-to-Net Adjustments, Gross Margin % Bridge, Balance Sheet Tie-Out & Close Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw137b_c1 | Evaluates STREAM-1 (Velvet Home ad-spend management) as Agent under ASC 606-10-55-36..40 (client owns ad accounts, zero inventory risk, zero pricing discretion), netting $100,000.00 pass-through media spend via Dr 4100 Agency Media Revenue $100,000.00 / Cr 5100 Media Pass-Through Cost COGS $100,000.00 to report $15,000.00 GAAP Net Agency Fee Revenue ($0.00 5100 COGS). | Reasoning (numerical) |
| cw137b_c2 | Evaluates STREAM-2 (Harbor Grocers custom POP displays) as Principal under ASC 606-10-55-36..40 (Beacon contracts factory production in its own name, warehouses inventory, bears transit/damage risk, and sets standalone price), retaining gross $68,000.00 Revenue in 4110 and $41,500.00 COGS in 5110. | Reasoning (numerical) |
| cw137b_c3 | Evaluates STREAM-3 (third-party brand drop-ship marketplace) as Agent under ASC 606-10-55-36..40 (brands set retail prices, ship directly from brand warehouses, and bear return/inventory risk), netting $70,400.00 brand remittances via Dr 4120 Drop-Ship Marketplace Revenue $70,400.00 / Cr 5120 Drop-Ship Brand Remittance COGS $70,400.00 to report $9,600.00 GAAP Net Commission Revenue ($0.00 5120 COGS). | Reasoning (numerical) |
| cw137b_c4 | Reconciles total October 2026 Revenue from $263,000.00 unadjusted gross ($115,000.00 + $68,000.00 + $80,000.00) to $92,600.00 GAAP Net Revenue (-$170,400.00 agent netting = $15,000.00 + $68,000.00 + $9,600.00). | Reasoning (numerical) |
| cw137b_c5 | Reconciles total October 2026 COGS from $211,900.00 unadjusted ($100,000.00 + $41,500.00 + $70,400.00) to $41,500.00 GAAP COGS (-$170,400.00 agent netting), conserving $51,100.00 Gross Profit while correcting Gross Margin % from 19.43% distorted to 55.18% ($51,100.00 / $92,600.00). | Reasoning (numerical) |
| cw137b_c6 | Reconciles October 2026 Operating Expenses from $28,400.00 unadjusted (6110) to $32,600.00 audited (+$4,200.00 Check #1842 in 6150 Marketing & Trade Shows), reconciling Net Income from $22,700.00 unadjusted to $18,500.00 audited (-$4,200.00 change). | Reasoning (numerical) |
| cw137b_c7 | Proves the post-close October 31, 2026 Balance Sheet tie-out: Total Assets $260,400.00 ($112,400.00 1010 + $25,000.00 1020 + $123,000.00 1100) equals Total Liabilities $77,300.00 (2000 AP) plus Total Members' Equity $183,100.00 ($130,000.00 3200 Retained Earnings + $34,600.00 3900 Opening Balance Equity + $18,500.00 audited Net Income). | Reasoning (numerical) |
| cw137b_c8 | Reports October 2026 close status as held under pending_cpa_trial_balance until Keller & Associates CPAs delivers the signed 2025 Form 1065 and final adjusted trial balance to clear the $34,600.00 cutover 3900 balance. | Reasoning (qualitative) |
Case 36 · LLC Owners Paid on W-2 Payroll & Net Stripe Deposits
Ironwood Commercial Landscaping LLC (Partnership) · LLC Partner Put on W-2 Payroll + $9,680 Net Stripe Deposit Counted Twice
1. What Happened on the Books
An LLC taxed as a partnership paid an owner through Gusto W-2 employee payroll (which IRS Rev. Rul. 69-184 prohibits for partnership owners), put $2,870 of business sod supplies into Partner Draws, and counted a $9,680 net Stripe deposit ($10,000 customer invoice minus $320 fee) as a second sale.
2. What Raw AI Gets Wrong
Raw AI leaves LLC owners inside W-2 employee wages and payroll taxes, leaves the $2,870 sod purchase in Partner Draws, and misses the $320 Stripe fee connecting the $9,680 bank deposit to the $10,000 invoice.
3. How Level Playbooks Fix It (100%)
Level moves LLC partner pay out of W-2 wages into Guaranteed Payments and Partner Draws (per IRS Rev. Rul. 69-184), puts the $2,870 sod cost back in job expenses, and matches the $9,680 Stripe payout plus $320 fee to the open invoice.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Precedent-Based Partner Draws Audit & Form 1065 Gusto Payroll Unbundling under Rev. Rul. 69-184
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw138a_c1 | Identifies $2,870.00 of commercial operating debit-card spend misclassified in 3120 Partner Draws with zero personal precedent ($1,840.00 EXP-3101 Apex Turf, $620.00 EXP-3102 Regional Fleet Fuel, and $410.00 EXP-3103 Metro Commercial Hardware), reclassifying Dr 5200 Job Materials COGS $2,250.00 and Dr 6180 Vehicle Fuel & Fleet $620.00 / Cr 3120 Partner Draws $2,870.00. | Reasoning (numerical) |
| cw138a_c2 | Preserves the October 21, 2026 $1,500.00 Lakeside Country Club charge (EXP-3104) inside 3120 Partner Draws based on 9 prior confirmed personal partner golf-dues postings, rather than reclassifying personal club dues into operating expense. | Reasoning (numerical) |
| cw138a_c3 | Applies IRS Rev. Rul. 69-184 and Operating Agreement Section 5.2 to determine that Managing Partner Marcus Vance cannot be treated as a W-2 employee of a Form 1065 partnership, requiring his fixed $8,700.00 monthly compensation to be classified as an IRC Section 707(c) guaranteed payment in 6120 rather than 6110 W-2 Crew Wages. | Reasoning (qualitative) |
| cw138a_c4 | Unbundles the $31,100.00 Gusto wages summary debit (JE-GUSTO-1025) out of 6110 W-2 Crew Wages via Dr 6120 Partner Guaranteed Payments $8,700.00, Dr 5300 Subcontractors COGS $2,500.00 (Canyon Stoneworks 1099 ACH), and Dr 3120 Partner Draws $1,500.00 (Elena Cho partner draw) / Cr 6110 W-2 Crew Wages $12,700.00, leaving $18,400.00 of true W-2 crew wages in 6110. | Reasoning (numerical) |
| cw138a_c5 | Reclassifies $665.55 of erroneous employer FICA remitted on Partner Marcus Vance's non-W-2 guaranteed payment out of 6130 Employer Payroll Taxes into 1390 Payroll Tax Refund Receivable pending Form 941-X (Dr 1390 $665.55 / Cr 6130 $665.55), leaving $1,407.60 of true employer FICA in 6130. | Reasoning (numerical) |
| cw138a_c6 | Reconciles 3120 Partner Draws from $4,370.00 unadjusted ($1,840.00 + $620.00 + $410.00 + $1,500.00) to $3,000.00 audited ($4,370.00 less $2,870.00 commercial spend plus $1,500.00 Elena Cho Gusto draw = $1,500.00 Lakeside Country Club + $1,500.00 Elena Cho draw). | Reasoning (numerical) |
| cw138a_c7 | Reports audited Task A P&L and receivable balances: $18,400.00 in 6110 W-2 Crew Wages, $8,700.00 in 6120 Partner Guaranteed Payments, $1,407.60 in 6130 Employer Payroll Taxes, $2,500.00 in 5300 Subcontractors COGS, and $665.55 in 1390 Payroll Tax Refund Receivable. | Reasoning (numerical) |
| cw138a_c8 | Explains why Gusto's payroll setup must be remediated (removing partner Marcus Vance from W-2 payroll and filing Form 941-X to recover the erroneous FICA) so future runs do not generate invalid W-2s or overpay FICA. | Reasoning (qualitative) |
Part B: Custom Clearing Fee-Netted Duplicate Revenue, Equity True-Up Plug, Advance-Netted Sod & Neutralized Estimate Register
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw138b_c1 | Matches the October 25, 2026 $9,680.00 fee-netted Stripe payout DEP-66602 (+7 days, net of 3.20% = $320.00 processing fee) against the $10,000.00 Crestview payment PMT-4410 stranded in custom clearing account 1095 Client Remittance Holding, booking Dr 4100 Landscaping Revenue $9,680.00 and Dr 6450 Merchant Processing Fees $320.00 / Cr 1095 Client Remittance Holding $10,000.00 (clearing 1095 to $0.00). | Reasoning (numerical) |
| cw138b_c2 | Catches the $14,200.00 Harbor View HOA winterizing retainer check DEP-EQ-901 posted to 3110 Partners' Capital with memo 'equity true-up' (0% performed in October 2026), reclassifying Dr 3110 Partners' Capital $14,200.00 / Cr 2310 Unearned Winterizing Retainers $14,200.00 (restoring 3110 to $170,560.00). | Reasoning (numerical) |
| cw138b_c3 | Applies the $2,560.00 September vendor advance sitting in 1360 Vendor Deposits against Valley Sod Farms invoice INV-9042 ($5,000.00 gross sod delivered October 28 less $2,440.00 net cash paid via PUR-12091) via Dr 5200 Job Materials COGS $2,560.00 / Cr 1360 Vendor Deposits $2,560.00 (bringing 1360 to $0.00 and total INV-9042 recognized cost to $5,000.00). | Reasoning (numerical) |
| cw138b_c4 | Determines that October 31 duplicate estimate JE-12128 ($2,440.00) and same-month reversal JE-12190 (-$2,440.00) cancel 1-for-1 to $0.00 and must both be excluded from the active month-end controlled estimate register, reporting $9,000.00 of active controlled estimates (EST-1088 Timberline Mulch only) and rejecting the inflated $11,440.00 register total. | Reasoning (numerical) |
| cw138b_c5 | Reconciles October 2026 4100 Landscaping Revenue from $134,680.00 unadjusted ($125,000.00 INV-4010 + $9,680.00 duplicate DEP-66602) to $125,000.00 audited (-$9,680.00 adjustment). | Reasoning (numerical) |
| cw138b_c6 | Reconciles total October 2026 COGS and operating expenses from $80,493.15 unadjusted to $84,077.60 audited (+$3,584.45 net adjustment: 5200 $42,250.00 + 5300 $2,500.00 + 6110 $18,400.00 + 6120 $8,700.00 + 6130 $1,407.60 + 6180 $4,000.00 + 6410 $6,500.00 + 6450 $320.00). | Reasoning (numerical) |
| cw138b_c7 | Reconciles October 2026 Net Income from $54,186.85 unadjusted ($134,680.00 less $80,493.15) to $40,922.40 audited ($125,000.00 less $84,077.60; net -$13,264.45 change). | Reasoning (numerical) |
| cw138b_c8 | Proves the post-close October 31, 2026 Balance Sheet tie-out: Total Assets $271,682.40 ($209,016.85 1010 + $0.00 1095 + $62,000.00 1100 + $0.00 1360 + $665.55 1390) equals Total Liabilities $63,200.00 ($40,000.00 2000 + $9,000.00 2110 + $14,200.00 2310) plus Total Partners' Equity $208,482.40 ($170,560.00 3110 Partners' Capital less $3,000.00 3120 Partner Draws plus $40,922.40 audited Net Income). | Reasoning (numerical) |
Case 37 · IRC Section 41 (Form 8974) R&D Payroll Tax Credit Cutoff
Helios BioPhotonics & AI Systems Inc. · Negative $1,809 October Payroll Tax From 4-Month $9,921 R&D Credit Lump
1. What Happened on the Books
When the payroll provider applied $9,921.01 of cumulative July-to-October IRC Section 41(h) Form 8974 R&D FICA tax credits in a single October entry against $8,111.75 of October payroll tax, October Payroll Tax Expense turned negative (-$1,809.26), over-crediting October by $9,480.82 of Q3 credits.
2. What Raw AI Gets Wrong
Unassisted AI sees a balanced Trial Balance and positive YTD payroll taxes, completely missing that October's monthly P&L carries -$1,809.26 of negative payroll tax and understates October burn by $9,480.82.
3. How Level Playbooks Fix It (100%)
Level allocates Form 8974 R&D payroll tax credits strictly to the payroll months in which the employer Social Security and Medicare taxes were incurred (July, August, September, and October), eliminating the negative October expense spike.
View Case Files, Task Prompts & Grading Checklist (16 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Wrong-Month Form 8974 R&D Payroll-Tax Credit Diagnosis & July - October Monthly Expense Reconciliation
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw140a_c1 | Diagnoses unadjusted October 2026 6120 Payroll Tax Expenses as -$1,809.26 ($8,111.75 gross TAX-10 less $9,921.01 cumulative Jul-Oct FICA credit in JE-2018-A) and unadjusted October 6110 Salaries & Wages as $45,171.28 ($45,555.90 PAY-10 less $384.62 July credit in JE-2018-B). | Reasoning (numerical) |
| cw140a_c2 | Computes the prior-month (July-September 2026) R&D credit over-applied in October as $9,480.82 ($9,096.20 prior-month 6120 FICA credits [$1,858.59 Jul + $3,597.56 Aug + $3,640.05 Sep] + $384.62 July 6110 supplemental credit), leaving only $824.81 earned in October 2026. | Reasoning (numerical) |
| cw140a_c3 | Reconciles audited July 2026 6120 Payroll Tax Expenses to $3,217.58 ($5,076.17 less $1,858.59) and audited July 6110 Salaries & Wages to $43,615.38 ($44,000.00 less $384.62). | Reasoning (numerical) |
| cw140a_c4 | Reconciles audited August 2026 and September 2026 6120 Payroll Tax Expenses to $0.00 ($3,597.56 less $3,597.56) and $0.00 ($3,640.05 less $3,640.05), respectively. | Reasoning (numerical) |
| cw140a_c5 | Reconciles audited October 2026 6120 Payroll Tax Expenses to $7,286.94 ($8,111.75 gross less $824.81 October Form 8974 credit) and audited October 6110 Salaries & Wages to $45,555.90. | Reasoning (numerical) |
| cw140a_c6 | Proves cumulative July-October 2026 6120 Payroll Tax Expenses are conserved at $10,504.52 ($3,217.58 Jul + $0.00 Aug + $0.00 Sep + $7,286.94 Oct = $20,425.53 gross less $9,921.01 total Form 8974 FICA credits). | Reasoning (numerical) |
| cw140a_c7 | Explains that IRC §41(h) / Form 8974 R&D payroll-tax credits offset employer payroll tax in the payroll periods in which the qualified R&D wages and FICA liabilities were incurred rather than dumping 4 months of retroactive credits into October. | Reasoning (qualitative) |
| cw140a_c8 | Verifies QBO BookCloseDate is unset (open across Jul-Oct 2026) and originalPeriodCorrectionAuthorization=true permits in-place prior-month reallocation without ever mutating QBO closing dates. | Reasoning (qualitative) |
Part B: Four-Month Reallocation Journal Entries, October P&L & Balance Sheet Conservation, and September Post-Close Disclosure
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw140b_c1 | Provides the October 31, 2026 removal entry: Dr 6120 Payroll Tax Expenses $9,096.20 and Dr 6110 Salaries & Wages $384.62 / Cr 2180 Payroll Clearing $9,480.82. | Reasoning (numerical) |
| cw140b_c2 | Provides the three prior-month reallocation entries: (a) 2026-07-31 Dr 2180 $2,243.21 / Cr 6120 $1,858.59 and Cr 6110 $384.62; (b) 2026-08-31 Dr 2180 $3,597.56 / Cr 6120 $3,597.56; and (c) 2026-09-30 Dr 2180 $3,640.05 / Cr 6120 $3,640.05. | Reasoning (numerical) |
| cw140b_c3 | Proves the 4 entries net to $0.00 cumulative impact on 2180 Payroll Clearing ($9,480.82 Oct credit exactly offset by $2,243.21 + $3,597.56 + $3,640.05 = $9,480.82 Jul-Sep debits), keeping ending October 31, 2026 2180 at $1,906.25. | Reasoning (numerical) |
| cw140b_c4 | Reconciles October 2026 total operating expenses (6110 + 6120 + 6210) from $55,172.31 unadjusted to $64,653.13 audited (+$9,480.82 increase), changing October Net Income from -$55,172.31 to -$64,653.13. | Reasoning (numerical) |
| cw140b_c5 | Proves cumulative July-October 2026 total expenses and cumulative Net Loss are unchanged at $199,486.09 (-$199,486.09 cumulative Net Income), because October's +$9,480.82 expense increase equals July-September's -$9,480.82 expense reductions. | Reasoning (numerical) |
| cw140b_c6 | Computes October 31, 2026 1010 Operating Checking as $280,513.91 ($480,000.00 opening less $209,791.72 Jul-Oct gross cash outflows plus $10,305.63 ACH-8974 refund). | Reasoning (numerical) |
| cw140b_c7 | Proves the October 31, 2026 Balance Sheet tie-out: Total Assets $280,513.91 equals Total Liabilities $1,906.25 (2180 Payroll Clearing) plus Total Stockholders' Equity $278,607.66 ($478,093.75 Jun 30 3100 less $199,486.09 cumulative Jul-Oct Net Loss). | Reasoning (numerical) |
| cw140b_c8 | Requires staging a post-close customer-context disclosure note for previously closed September 2026 (books_close_runs:17) documenting the $3,640.05 retroactive Form 8974 R&D credit adjustment. | Reasoning (qualitative) |
Case 38 · Former Employees Still on Health Insurance & 401(k) Deposits
Summit Workforce & Benefits Group · $5,238/Mo Health Bills for Former Staff + Domestic Partner Tax Rule
1. What Happened on the Books
Monthly health insurance bills ($29,184.11) were still charging $5,238.39 every month for former employees who had already left the company ($31,430.88/yr in wasted employer cost), domestic partner health coverage was deducted pre-tax against IRS rules, and employee 401(k) withholdings sat unpaid in Accounts Payable.
2. What Raw AI Gets Wrong
Raw AI pays the $29,184.11 insurance bill in full without comparing the roster to active payroll, misses the IRS post-tax rule on domestic partner health coverage, and misses late 401(k) trust deposits.
3. How Level Playbooks Fix It (100%)
Level matches insurance carrier bills to active payroll every month (saving $31,431/yr in employer premiums), applies proper IRS tax treatment on domestic partner benefits, and verifies timely 401(k) deposits.
View Case Files, Task Prompts & Grading Checklist (14 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Employee Benefits Roster Section 125 Post-Tax Domestic Partner Gap & Medical Details Bridge
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw471a_c1 | Reconciles raw medical $29,184.11 less -$4,272.68 voluntary drops and -$965.71 terminations to $23,945.72 across 34 active enrollees ($5,390.85 ER and $5,661.02 EE per pay period). | Reasoning (numerical) |
| cw471a_c2 | Computes modeled employer medical savings of $2,619.24 per month ($31,430.88 annualized) from the 6 voluntary drops and 2 Details-tab terminations. | Reasoning (numerical) |
| cw471a_c3 | Identifies the $291.11 per-pay-period ($630.74 monthly / $7,568.86 annual) post-tax domestic partner deduction omitted when EDI syncs only $207.66 pre-tax out of $498.77 total EE ($706.43 total with $207.66 ER). | Reasoning (numerical) |
| cw471a_c4 | Explains that under IRC Section 125 non-tax-dependent domestic partner medical coverage cannot be deducted pre-tax and requires a separate post-tax payroll deduction code or imputed income mapping. | Reasoning (qualitative) |
Part B: Asymmetric Summary-Tab Termination Clearance & Mid-Plan-Year Dependent Shift
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw471b_c1 | Identifies $846.21 per pay period ($330.61 ER + $515.60 EE, or $1,833.46 monthly) of residual terminated medical rows still Active on the Summary tab and $389.02 per pay period of open payroll MDCL deductions. | Reasoning (numerical) |
| cw471b_c2 | Computes clean employer Guardian costs of $671.95 per pay period ($1,455.89 monthly) for Dental and $94.75 per pay period ($205.29 monthly) for Vision across 27 active enrollees. | Reasoning (numerical) |
| cw471b_c3 | Quantifies the 50% to 100% employee-paid dependent shift from $215.82 per pay period ($195.29 Dental + $20.53 Vision, $467.61 monthly) to $431.74 per pay period ($390.61 Dental + $41.13 Vision, $935.44 monthly), saving $5,613.92 annually. | Reasoning (numerical) |
| cw471b_c4 | Verifies that mid-plan-year dependent contribution changes respect the 2026-04-01 to 2027-03-31 Section 125 plan year and that terminated employees stop ongoing post-termination deductions and W-2 Box 12 Code DD employer accruals while preserving valid YTD coverage. | Reasoning (qualitative) |
Part C: Biweekly Hourly + Salaried Batch Merge, ERISA 401(k) Remittance Cutoff & Carrier Portal vs. Placeholder AP Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw471c_c1 | Reconciles unmerged TimeImprt + 1.Regular gross $152,799.07 less -$5,636.50 (72.00h salaried PTO base offset) to $147,162.57 clean gross and $140,082.87 total cash required across 43 paid employees. | Reasoning (numerical) |
| cw471c_c2 | Computes $23,452.31 of unremitted October 2026 401(k) withholdings ($11,656.28 from 10/16 + $336.64 from 10/23 = $11,992.92 masked by pre-booked uncleared QBO checks, plus $11,459.39 from 10/30), reaching $34,393.99 cumulative with $10,941.68 on the 11/13 draft. | Reasoning (numerical) |
| cw471c_c3 | Identifies that QBO Nov 1 placeholder medical bill $47,755.71 exceeds actual November carrier portal invoice $24,709.02 by $23,046.69 (-$23,046.69 adjustment), leaving $72,464.73 combined October + November carrier balance due. | Reasoning (numerical) |
Part D: Multi-Lever CFO Workforce & Benefits Cost-Reduction Bridge & Hidden Carrier Roster Leak Audit
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw471d_c1 | Computes $22,434.35 per-biweekly-run employer payroll + tax cost reduction ($179,822.69 to $157,388.34, or $48,607.76 monthly / $583,293.10 annualized) and reconciles the $25,446.13 payroll EFT wire reduction ($22,434.35 employer cost reduction + $3,011.78 higher withheld employee deductions). | Reasoning (numerical) |
| cw471d_c2 | Computes steady-state monthly employer medical reduction from $44,113.26 ($47,755.71 less $3,642.45 EE) to $9,302.25 ($20,806.71 steady-state less $11,504.46 pre+post-tax EE), saving $34,811.01 monthly ($417,732.12 annualized) plus $5,613.92 dependent Dental/Vision shift = $1,006,639.14 total annualized run-rate savings while excluding the -$8,027.21 one-time retroactive DELSUB credit. | Reasoning (numerical) |
| cw471d_c3 | Identifies $674.44 per month ($8,093.28 annualized) of hidden carrier roster items ($544.61 on zero-hour unpaid-leave employee with $0 paycheck deduction + $129.83 on non-payroll Excluded enrollee) requiring explicit CEO confirmation before cancellation. | Reasoning (numerical) |
Case 39 · Roofing GreenSky & Service Finance Draws + Property LLC Checks
Desert Crest Roofing & Solar LLC · $26,430 Un-Invoiced Lender Draws & Dealer Fees + Commercial LLC Address Match
1. What Happened on the Books
Out of $67,435.36 in pending bank deposits, $41,005.36 matched customer invoices once property-holding LLC checks were tied by job street address, while two consumer-lender wires ($17,500 GreenSky 50% progress draw on an un-invoiced $35,006 signed proposal and $8,930 Service Finance wire net of 5%-6% dealer fees) had zero QuickBooks invoices.
2. What Raw AI Gets Wrong
Unassisted AI books the $17,500 GreenSky progress draw directly to Sales (causing duplicate revenue when the job is later invoiced) and records the net $8,930 lender wire without accounting for the 5%-6% ($470-$570) dealer financing fee.
3. How Level Playbooks Fix It (100%)
Level matches commercial LLC checks to homeowner CRM invoices via service-property street addresses, holds the $17,500 progress draw in Customer Deposits until invoiced, and grosses up lender wires for exact dealer financing fees.
View Case Files, Task Prompts & Grading Checklist (8 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Commercial LLC Property-Address Check Tie-Out & Pre-Match Missing CRM Invoice Sync
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw472a_c1 | Reconciles the 6 customer-identifiable bank-feed deposits totaling $41,005.36 ($500.00 + $2,996.75 + $7,880.60 + $5,000.00 + $10,544.10 + $14,083.91) across 8 invoices with $0.00 variance. | Reasoning (numerical) |
| cw472a_c2 | Matches BF-1106A ($10,544.10 from Desert Oasis Prop I LLC) via normalized street address 1440 South Revere to W. Zheng invoices RF-545685 ($8,964.10) and RF-545698 ($1,580.00), disambiguating BF-1103A ($500.00) to RF-545747 over RF-545670. | Reasoning (numerical) |
| cw472a_c3 | Requires staging and syncing unsynced November CRM invoice RF-545751 ($20,458.32 for F. Navarro) before matching multi-check batch BF-1106B ($14,083.91 = $4,006.87 on RF-545661 + $10,077.04 on RF-545751, leaving $10,381.28 open on RF-545751). | Reasoning (numerical) |
| cw472a_c4 | Refuses to auto-add customer check or processor deposits directly to Sales revenue, which would double-count invoiced Accounts Receivable. | Reasoning (qualitative) |
Part B: Un-Invoiced Won Proposal 50% Consumer Financing Draw & Round-Loan Dealer-Fee Hold
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw472b_c1 | Holds the 2 third-party financing wires totaling $26,430.00 ($17,500.00 BF-1104B GreenSky Custodial + $8,930.00 BF-1106C Service Finance) out of the $67,435.36 total pending bank-feed deposits. | Reasoning (numerical) |
| cw472b_c2 | Identifies BF-1104B ($17,500.00) as a 49.99% (~50% Stage 1 progress draw, $3.14 rounding delta vs. $17,503.14) against T. Denham's un-invoiced signed Won Proposal on JOB-11870848 ($35,006.28, 0 CRM invoices). | Reasoning (numerical) |
| cw472b_c3 | Computes the exact round-loan dealer-fee hypotheses on BF-1106C ($8,930.00): 6.00% fee ($570.00) on a $9,500.00 gross loan or 5.00% fee ($470.00) on a $9,400.00 gross loan. | Reasoning (numerical) |
| cw472b_c4 | Explains that operations must generate the official CRM invoice on JOB-11870848 before matching (never fabricating an un-numbered QBO invoice or booking directly to Sales, which would duplicate $35,006.28 when nightly CRM sync imports the invoice). | Reasoning (qualitative) |
Case 40 · Monthly P&L Negative-Expense Catch & Zero-Activity Card Continuity
Roast & Bloom Multi-Unit Cafes · Negative $2,150 Single-Month Tax Line + $18,450 9-Month Catch-Up Lump
1. What Happened on the Books
Year-to-date Taxes & Licenses looked normal (+$3,839.88), hiding a -$2,149.56 negative expense column in September alongside an unallocated 9-month $18,450.00 payroll-tax catch-up lump. Meanwhile, an automated close bot kept emailing the owner for 'missing' February and August card statements on a $0-activity card (#6968).
2. What Raw AI Gets Wrong
Unassisted AI reviews only YTD totals (missing single-month negative expense lines), dumps 9 months of prior payroll taxes ($18,450) into September's P&L, and pesters the client for unissued bank statements on $0-balance months.
3. How Level Playbooks Fix It (100%)
Level scans every individual monthly P&L column for negative expenses, spreads multi-month catch-ups to their true periods of origin, and proves $0-activity statement continuity mathematically from surrounding January/March and July/September statements.
View Case Files, Task Prompts & Grading Checklist (6 Checks)Includes downloadable Excel/CSV workbooks, exact prompts given to AI models, and verified journal entries.
Part A: Cross-Month Negative Expense Detection, Multi-Month Catch-Up Refusal & Cash-Basis Accrual Reversal
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw474a_c1 | Flags September -$2,149.56 negative Taxes & Licenses column despite positive +$3,839.88 YTD total. | Reasoning (numerical) |
| cw474a_c2 | Refuses unallocated 9-month $18,450.00 payroll-tax catch-up lump in September ($2,050.00 monthly run-rate across $20,500.00 10-month total) without period-of-origin schedule. | Reasoning (numerical) |
| cw474a_c3 | Reverses the $1,957.71 October 31 payroll accrual on the pure cash-basis Downtown branch and blocks client PDF generation while monthly distortions remain. | Reasoning (numerical) |
Part B: Zero-Activity Statement Continuity Proof & Stale Missing-Statement Email Block
| Check | Required Accounting or CFO Output | Category |
|---|---|---|
| cw474b_c1 | Proves $0.00-activity unissued February and August statement continuity on card 6968 ($1,420.50 Jan ending less $1,420.50 Feb payment = $0.00 Mar opening; $612.40 Jul ending less $612.40 Aug payment = $0.00 Sep opening). | Reasoning (numerical) |
| cw474b_c2 | Verifies master account 7897 already has 443 synced QuickBooks transactions and card 6968 has 84 synced transactions. | Reasoning (numerical) |
| cw474b_c3 | Fails closed on any outbound client email draft requesting statements for accounts 6968 or 7897 when continuity and live QBO sync prove zero missing statement gaps. | Reasoning (qualitative) |
Quick-Scan Directory Table: All 40 SMB Case Studies & 1-Click DownloadsScan every industry, software stack, accounting trap, and downloadable Excel or CSV package in a single table.
| Case | Client Case & Industry | Software Stack | Accounting / CFO Trap | Checks | Workbook |
|---|---|---|---|---|---|
| #1 | Accounting · Food & Beverage / Specialty Roastery | QuickBooks Online (3 Entities), Chase Commercial Banking, Payroll Subledger | $103,650 Revenue Overstatement + $36,000 Deleted Payroll Entry | 16 | .xlsx ↓ |
| #2 | Operations & Tax · Commercial Trades & Contracting | QuickBooks Online, BuildOps Job Costing, Beacon & ABC Supply Feeds | $177,600 BuildOps vs. QuickBooks Cost Gap + $83,400 Unstarted Deposit | 24 | .xlsx ↓ |
| #3 | Accounting · Healthcare & Medical Diagnostics | QuickBooks Online, Amex Corporate Platinum (4 Cards), Insurance ERA Remittances | $53,150 Card & Prepaid Overstatement + $26,160 Net-Cash Revenue Error | 16 | .xlsx ↓ |
| #4 | Fractional CFO · Biotech & Medical Devices | QuickBooks Online, Excel 3-Statement Model (.xlsx), Executive Board Deck | 473 bps Board Deck Margin Drift + $15,000 Opening Cash Plug | 16 | .xlsx ↓ |
| #5 | Accounting · Commercial Landscaping & Grounds | QuickBooks Online, Intuit Merchant Feeds, Gusto Payroll, Capital One Card | $20,350 Missing Check Images + $2,500 Owner Draw Double-Count | 16 | .xlsx ↓ |
| #6 | Fractional CFO · D2C Skincare & Consumer Brands | QuickBooks Online, Fixed Asset Schedule (.xlsx), Monthly Close Checklist | $10,023 Missing 9-Month Depreciation + Unverified $4.26M Bank Cash | 8 | .xlsx ↓ |
| #7 | Accounting · Multi-Entity Hospitality & Retail | QuickBooks Online (3 Entities), Intercompany Loan Schedule, Amex & Check Feeds | $3,000 Wholesale Bean Autopay Swept into Loans + Unmatched Checks | 8 | .xlsx ↓ |
| #8 | Fractional CFO · Biotech Clinical Trials & Cross-Border Ops | QuickBooks Multi-Currency, Wise Business FX, Gusto Payroll | EUR 8,761 Credit Note Double-Count + Closed-Period QuickBooks Lock | 16 | .xlsx ↓ |
| #9 | Operations & Tax · Commercial Trades & Professional Services | Jobber, BuildOps, Spectrum ERP, ClickUp, Xero (Australian GST) | Dropped Jobber Fields + $5,800 Labor Overlap + 10% GST Asset Error | 16 | .xlsx ↓ |
| #10 | Accounting · E-Commerce Retail & Commercial Fleet | Shopify Balance, Square Payroll, QuickBooks Online | 43 Overlapping Shopify Rows + $46,830 Net Payroll + Unsplit Truck Loan | 16 | .xlsx ↓ |
| #11 | Fractional CFO · Omnichannel D2C Apparel ($45M+ Scale) | QuickBooks Online (109 Accounts), Marketing BI Dashboard, Avalara Sales Tax | $1.78M Sales Tax Netted in Revenue + $2.06M Google Ads Account Flip | 14 | .xlsx ↓ |
| #12 | Operations & Tax · 3PL Warehouse Operations & Contracting | 3PL Warehouse WMS, Shopify Inventory Export, Gift Card Clearing, Job Change Orders | $10.15M Phantom Shopify Inventory + $170.4K Gift Card Cutoff Error | 16 | .xlsx ↓ |
| #13 | Accounting · Multi-State Restaurants, POS & Delivery | QuickBooks Online, Stream POS, UberEats / DoorDash / Grubhub, NY & NJ Tax Portals | $11,985 Double-Paid Delivery App Tax + $9,120 Cross-Quarter Tax Error | 16 | .xlsx ↓ |
| #14 | Fractional CFO · High-Volume D2C Apparel ($38M+ Scale) | Shopify Plus (674K Rows), QuickBooks Online, Warehouse Check Register, Unit-Cost Workbook | $2.19M Freight Double-Count in COGS + $340K Check Misclassification | 16 | .xlsx ↓ |
| #15 | Accounting · Field Contracting & Medical Devices | QuickBooks Online, Roofr CRM Subledger, Bank Deposit Ledger | $78,858 Deleted CRM Invoices + $12,335 Deposit Offset Entries | 8 | .xlsx ↓ |
| #16 | Operations & Tax · Medical Device Manufacturing & QC | QuickBooks Online, ClickUp Batch Release, Batch Production Logs (.xlsx) | Unbilled Sterile Lab Tests + Missing $0 Scrap Lines Across 11,044 Files | 8 | .xlsx ↓ |
| #17 | Fractional CFO · Medical Devices & Diagnostics | QuickBooks Online, Stock Option Schedule, Vendor Payables Ledger | $888.6K Non-Cash Stock Comp Treated as Cash + -$7,883 Negative Vendor Bill | 10 | .xlsx ↓ |
| #18 | Accounting · Commercial Trades & Field Services | QuickBooks Online, Biweekly Payroll Register, Field Job Schedule | $12,312 Payroll Reversal Used Twice + $5,050 Personal Owner Spend in Expenses | 16 | .xlsx ↓ |
| #19 | Accounting · Omnichannel E-Commerce & Retail | Shopify Payments, QuickBooks Multi-Currency, 5-Channel Sales Tax Filings | $48,637 Direct Bank-Feed Double-Count + $75,300 Marketplace Tax Split | 16 | .xlsx ↓ |
| #20 | Accounting · B2B SaaS & AI Software | QuickBooks Online, Stripe Billing, SaaS Contract Schedule, Equipment Loan | $92,400 Annual SaaS Billed Upfront + Unfinished Customer Setup Fees | 16 | .xlsx ↓ |
| #21 | Accounting · Healthcare Labs & Biotech | QuickBooks Online, First Commercial Bank (2 Accounts), Merchant Card Feed | $14,800 Second Bank Account Zeroed Out + $19,250 Day-1 Reversal Error | 16 | .xlsx ↓ |
| #22 | Accounting · Hardware Tech & Robotics | QuickBooks Online, Gusto Contractor & W-2 Payroll, Supplier PO Schedule | Twin $5,125 Gusto Runs + Unbacked Manual JE + $16,000 Tooling Deposit | 16 | .xlsx ↓ |
| #23 | Fractional CFO · Multi-Entity International Manufacturing | QuickBooks Multi-Currency (3 Entities), FX Spot/Avg Rate Table, IC Inventory Log | EUR 100K Loan Spot Drift + Unrealized Intercompany Inventory Profit | 16 | .xlsx ↓ |
| #24 | Fractional CFO · Commercial Mechanical Construction | QuickBooks Online, AIA G702/G703 Pay Apps, Job Cost WIP Schedule | $34,000 Boxed Warehouse Parts Counted as Built + $9,000 Missing Holdback | 16 | .xlsx ↓ |
| #25 | Accounting · High-Volume E-Commerce & Consumer Services | Stripe Disputes, Amex OptBlue Settlements, QuickBooks Online | $1,944 Won Chargeback Booked Twice + $8,640 Amex Rolling Reserve Expensed | 16 | .xlsx ↓ |
| #26 | Fractional CFO · Imported Consumer Goods & Wholesale | QuickBooks Online, Customs Entry Form 7501, Ocean Shipping Docs, 3PL Warehouse | $15,000 Tariffs Expensed Upfront + $14,000 Container at Sea Left Off Books | 16 | .xlsx ↓ |
| #27 | Fractional CFO · Enterprise B2B SaaS | QuickBooks Online, Salesforce / Stripe Contracts, Commission Payroll | $12,000 Double-Counted SaaS Upgrade + $14,400 Commission Expensed in Month 1 | 16 | .xlsx ↓ |
| #28 | Accounting · Multi-Site Dental & Healthcare Clinics | QuickBooks Online, Clinic Lease Schedule, Fixed Asset Register | $120,000 Landlord Buildout Cash Booked as Profit + $18,000 X-Ray Expensed | 16 | .xlsx ↓ |
| #29 | Accounting · Specialty Manufacturing & Labs | QuickBooks Online, Gusto Regular & Off-Cycle Runs, Timekeeping Export | Twin $11,480 Gusto Runs Misrouted by Auto-Rule + Straddle Cohort Cutoff | 16 | .xlsx ↓ |
| #30 | Accounting · Professional Services & Agencies | QuickBooks Online, Relay 5-Account Profit First Banking, Gusto W-2 Payroll | $40,000 Phantom Sweep Revenue + $16,500 Personal Tax Payment Expensed | 16 | .xlsx ↓ |
| #31 | Fractional CFO · Residential & Light Commercial Construction | QuickBooks Online, Amex Corporate Cards, S-Corp Owner Payout Ledger | $22,000 Personal Card Spend in Expenses + Unequal 60/40 S-Corp Payout Risk | 16 | .xlsx ↓ |
| #32 | Accounting · Engineering & Field Technical Services | QuickBooks Online, Mobile Check Deposits, HRIS PTO & Wage Ledger | $38,450 Undeposited Funds Plug + $3,816 Non-Vesting Sick Leave Over-Accrual | 16 | .xlsx ↓ |
| #33 | Accounting · B2B Commercial Maintenance | QuickBooks Online, Amex Parent/Sub-Card Hierarchy, Operating Bank Feed | $25,000 Duplicate Card Autopay + Missed Parent-Account Rebate Credits | 16 | .xlsx ↓ |
| #34 | Fractional CFO · Wholesale Distribution & 3PL | QuickBooks Online, Cloud Warehouse Software Contract, Prepaid Insurance Schedule | $24,000 Software Setup Expensed Upfront + Insurance Posted to Wrong Account | 16 | .xlsx ↓ |
| #35 | Fractional CFO · Digital Marketing & Media Agencies | QuickBooks Online, Plaid Bank Feeds, Client Ad-Spend Reimbursements | Client Ad Spend Counted as Agency Revenue + $55,400 Unexplained Equity Plug | 16 | .xlsx ↓ |
| #36 | Accounting · Commercial Landscaping Partnership | QuickBooks Online, Gusto Payroll, Stripe Clearing (Account 1095) | LLC Partner Put on W-2 Payroll + $9,680 Net Stripe Deposit Counted Twice | 16 | .xlsx ↓ |
| #37 | Fractional CFO · AI Startups, DeepTech & Biotech | QuickBooks Online, IRS Form 8974 Schedule, Payroll FICA Ledger | Negative $1,809 October Payroll Tax From 4-Month $9,921 R&D Credit Lump | 16 | .xlsx ↓ |
| #38 | Fractional CFO · Multi-State Service Employer (34+ Employees) | Employee Benefits Roster, Medical/Dental/Vision Bills, 401(k) & Payroll | $5,238/Mo Health Bills for Former Staff + Domestic Partner Tax Rule | 14 | .xlsx ↓ |
| #39 | Accounting · Residential & Commercial Roofing | QuickBooks Online, GreenSky & Service Finance, Roofing CRM Proposals | $26,430 Un-Invoiced Lender Draws & Dealer Fees + Commercial LLC Address Match | 8 | .xlsx ↓ |
| #40 | Accounting · Multi-Unit Hospitality & Retail | QuickBooks Online, Monthly Comparative P&L, Corporate Card Statements | Negative $2,150 Single-Month Tax Line + $18,450 9-Month Catch-Up Lump | 6 | .xlsx ↓ |
Inspect 4 Additional QuickBooks Cleanup Scenarios (12 Monthly Close Workflows)View our 4 multi-file QuickBooks cleanup scenarios (HVAC, Dental Group, Precision Manufacturing, Multi-Entity HoldCo) and their 100 grading checks.
4 Sample QuickBooks Cleanups · 12 Monthly Close Workflows
QuickBooks Cleanup Scenarios & Grading Checklists
Messy Bank-Feed Takeover, JE-Neutralized Inbox Rows & Paper-Check Holds
Clean up and classify the 12 September bank outflows for Summit Climate Mechanical (QBO + ServiceTitan). Reconcile against any prior-bookkeeper manual journal entries already posted to the GL, separate Intuit merchant fees from gross batch deposits, and hold any paper check over $250 that lacks a check stub or vendor invoice.
Summit Climate Mechanical & Landscaping LLC
Field Services & Commercial Contracting · QuickBooks Online + Field Service CRM (BuildOps / LMN) · Accrual (migrating from hybrid cash-basis QBO after bookkeeper turnover)
| Grading Check | Raw AI Alone | With Level Playbooks |
|---|---|---|
| Detect that prior bookkeeper already neutralized $3,400 insurance row via manual JE-0899 (do not double-count) | Fail (Reclassified & double-counted) | Pass (Matched to JE-0899) |
| Hold paper checks #1084 ($14,500), #1089 ($3,800) & #1092 ($1,900) missing check stub images ($20,200 total) | Fail (Guessed COGS / Subcontractor) | Pass (Held for operator review) |
| Separate two Intuit merchant fee outflows ($52.40 + $182.60 = $235.00) from $19,450.00 customer batch settlements | Pass ($235.00 fee separated) | Pass ($235.00 fee separated) |
| Exclude August prior-period check ($1,200.00) and voided check ($0.00) from September operating expenses | Pass (Excluded from Sep OPEX) | Pass (Excluded from Sep OPEX) |
Closed-Month QuickBooks & Subledger Diagnostic
Recognize one of these 40 close issues on your own QuickBooks or field software books?
Our controllers and fractional CFOs run one closed month of your ledger and subledgers against these exact playbooks.
Frequently asked questions
Each of the 40 public anonymized case studies includes a downloadable Excel workbook (.xlsx) or CSV ledger bundle and client notes (.txt). Every package also ships with binary grading rubrics (.json; 84 tasks and 588 checks) distilled from 2,200+ past SMB cleanups.
The 40 packages span commercial construction AIA retainage (BuildOps, Roofr, GreenSky), field services (Jobber, Gusto, Xero), and restaurants (Stream POS, UberEats, DoorDash). They also cover Shopify 3PL inventory, B2B SaaS ASC 606 and Form 8974 R&D credits, dental ASC 842 leases, and S-Corp basis.
Yes. All 40 public workbooks (.xlsx, .csv) and checklists (.json) are free for personal, CPA, or academic review, and search indexing or AI retrieval citation with attribution is expressly permitted. Commercial AI labs can email sam@levelcfo.com to license our held-out private 334-company (5,335-check) close vault.
Grow without losing control of the numbers
Drop your info and we’ll show your real margin across jobs, crews, products, and customers, where profit leaks to rework or hidden costs, and how much cash is sitting in unbilled work or inventory.
No commitment. Real numbers, not generic advice.