Skip to main content
2,200+ contractors in the research universe benchmarked. Do you know your gross profit per labor hour? See where you stand →
Level

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.

Personal & Non-Commercial License v1.0Free for business owners, CPAs & academic review. Commercial AI labs & vendors must license via sam@levelcfo.com.
Request Commercial License →
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.

Filter by Role:
Showing 10 of 40 cases
AccountingFood & Beverage / Specialty Roastery· 2 Close Tasks · 16 Grading Checks

Case 1 · Multi-Entity Coffee Roastery & Cafes

Roast & Co. Coffee Group (3 Entities) · $103,650 Revenue Overstatement + $36,000 Deleted Payroll Entry

Systems:QuickBooks Online (3 Entities)Chase Commercial BankingPayroll Subledger

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.

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.
Accounting · Multi-Entity Accounting Close
Part A: Three-Entity Intercompany & Wholesale Deposit Misattribution
8 / 8 Checks Verified
Prompt Given to AI Models:Audit the Q3 2026 three-entity general ledger (`qbo_three_entity_gl_2026_Q3.xlsx`) and the temp bookkeeper's memo (`bookkeeper_memo_sept_2026.txt`) for Roast & Co. Coffee Corp, Roast & Co. Downtown LLC, and Roast & Co. Northside LLC. Identify any misattributed wholesale customer collections, evaluate whether the September 2026 wire discussed in the bookkeeper's memo is a vendor rebate or an intercompany transfer, and specify the required correcting journal entries.
Grading Checklist (8 Checks)
CheckRequired Accounting or CFO OutputCategory
cw101a_01Identifies the $84,250.00 Metro Foodservice Group ACH deposit (DEP-901) booked to 4100 Wholesale Revenue in Roast & Co. Coffee Corp.Reasoning (numerical)
cw101a_02Identifies 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_03Reports 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_04Rejects 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_05Quantifies 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_06Proposes 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_07Proposes 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_08Reports GreenSprout Wholesale (DT-4419) as the sole remaining open Downtown AR balance at $31,200.00.Reasoning (numerical)
Verified Solution
Accounting · Multi-Entity Accounting Close
Part B: Staged vs. Deleted synced accounting ledger Split Drift & Two-Account Landlord Guard
8 / 8 Checks Verified
Prompt Given to AI Models:Audit the 2026 Roastery/Retail 80/20 payroll split schedule (`qbo_staged_vs_mirror_payroll_splits_2026.csv`) and the Harbor Properties LLC lease charges (`qbo_three_entity_gl_2026_Q3.xlsx` and `bookkeeper_memo_sept_2026.txt`). Determine whether all 6 months (Apr-Sep 2026) are actually booked in the live synced accounting ledger, quantify any missing split adjustment, and evaluate whether Harbor Properties LLC should be flagged as an inconsistent account-flip error.
Grading Checklist (8 Checks)
CheckRequired Accounting or CFO OutputCategory
cw101b_01Identifies 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_02Quantifies 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_03Reports 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_04States 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_05Reports 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_06Determines 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_07Reports total Apr-Sep 2026 gross payroll across the 6 months as $273,000.00.Reasoning (numerical)
cw101b_08Recommends 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)
Verified Solution
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.
CaseClient Case & IndustrySoftware StackAccounting / CFO TrapChecksWorkbook
#1
Accounting · Food & Beverage / Specialty Roastery
QuickBooks Online (3 Entities), Chase Commercial Banking, Payroll Subledger$103,650 Revenue Overstatement + $36,000 Deleted Payroll Entry16.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 Deposit24.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 Error16.xlsx ↓
#4
Fractional CFO · Biotech & Medical Devices
QuickBooks Online, Excel 3-Statement Model (.xlsx), Executive Board Deck473 bps Board Deck Margin Drift + $15,000 Opening Cash Plug16.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-Count16.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 Cash8.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 Checks8.xlsx ↓
#8
Fractional CFO · Biotech Clinical Trials & Cross-Border Ops
QuickBooks Multi-Currency, Wise Business FX, Gusto PayrollEUR 8,761 Credit Note Double-Count + Closed-Period QuickBooks Lock16.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 Error16.xlsx ↓
#10
Accounting · E-Commerce Retail & Commercial Fleet
Shopify Balance, Square Payroll, QuickBooks Online43 Overlapping Shopify Rows + $46,830 Net Payroll + Unsplit Truck Loan16.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 Flip14.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 Error16.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 Error16.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 Misclassification16.xlsx ↓
#15
Accounting · Field Contracting & Medical Devices
QuickBooks Online, Roofr CRM Subledger, Bank Deposit Ledger$78,858 Deleted CRM Invoices + $12,335 Deposit Offset Entries8.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 Files8.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 Bill10.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 Expenses16.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 Split16.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 Fees16.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 Error16.xlsx ↓
#22
Accounting · Hardware Tech & Robotics
QuickBooks Online, Gusto Contractor & W-2 Payroll, Supplier PO ScheduleTwin $5,125 Gusto Runs + Unbacked Manual JE + $16,000 Tooling Deposit16.xlsx ↓
#23
Fractional CFO · Multi-Entity International Manufacturing
QuickBooks Multi-Currency (3 Entities), FX Spot/Avg Rate Table, IC Inventory LogEUR 100K Loan Spot Drift + Unrealized Intercompany Inventory Profit16.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 Holdback16.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 Expensed16.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 Books16.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 116.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 Expensed16.xlsx ↓
#29
Accounting · Specialty Manufacturing & Labs
QuickBooks Online, Gusto Regular & Off-Cycle Runs, Timekeeping ExportTwin $11,480 Gusto Runs Misrouted by Auto-Rule + Straddle Cohort Cutoff16.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 Expensed16.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 Risk16.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-Accrual16.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 Credits16.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 Account16.xlsx ↓
#35
Fractional CFO · Digital Marketing & Media Agencies
QuickBooks Online, Plaid Bank Feeds, Client Ad-Spend ReimbursementsClient Ad Spend Counted as Agency Revenue + $55,400 Unexplained Equity Plug16.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 Twice16.xlsx ↓
#37
Fractional CFO · AI Startups, DeepTech & Biotech
QuickBooks Online, IRS Form 8974 Schedule, Payroll FICA LedgerNegative $1,809 October Payroll Tax From 4-Month $9,921 R&D Credit Lump16.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 Rule14.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 Match8.xlsx ↓
#40
Accounting · Multi-Unit Hospitality & Retail
QuickBooks Online, Monthly Comparative P&L, Corporate Card StatementsNegative $2,150 Single-Month Tax Line + $18,450 9-Month Catch-Up Lump6.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

Close Task Prompt10 / 100 Grading Checks

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.

Level Playbook Used: Prior-Bookkeeper JE Cross-Check + Paper-Check Hold Playbook
Anonymized Client Profile & Software Stack

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)

Connected Software & Evidence Sources:
QuickBooks OnlineChase Business BankingCheck Register PDFsSlack Onboarding Notes
Files Included in Close Package:
qbo_general_ledger_sep2026.csv (1,420 rows)
prior_bookkeeper_manual_jes.csv (JE-0899 reclass)
chase_bank_feed_export.csv (12 uncategorized outflows)
check_images/check_1084_missing_stub_notice.pdf
onboarding_call_transcript_sep2026.txt
Sample Grading Checks10 total checks in this workflow
Grading CheckRaw AI AloneWith 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 settlementsPass ($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 expensesPass (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.

2,200+ businesses benchmarked$13.25B in revenue analyzedWeekly action cadence

No credit card. Start with a 15-min call. We only follow up if we can actually help.

No commitment. Real numbers, not generic advice.