Data brief · 2026
What small-business owners actually ask about their books
We grouped the recurring bookkeeping and admin questions owners post on public Q&A surfaces (the QuickBooks Community, help-center top articles, and bookkeeping subreddits) into 8 patterns, and scored each for how automatable it is with current AI tooling.
Automatability of the sampled questions
Of the 24 recurring question patterns sampled (our scoring; see method)
18 of 24 patterns (75%) are automatable outright or with a review step.
Three-quarters of what owners ask for help with isn't advice. It's recurring work waiting to be done for them.
The 8 question patterns
Composite phrasings of the recurring questions, with our judgment on how automatable each is today
| Pattern | What owners ask | Automatable? |
|---|---|---|
| Reconciliation & bank feeds | "My opening balance changed after I already reconciled. How do I fix it?" | With review |
| "The bank feed imported duplicates of transactions I entered manually." | With review | |
| "Why doesn't my bank balance match my books?" | With review | |
| Reports & exports | "How do I export the reconciliation report to Excel?" (famously not directly exportable) | Automatable |
| "Can I get AR aging by customer emailed to me monthly?" | Automatable | |
| "How do I pull P&L by class or location?" | Automatable | |
| Invoicing & getting paid | "How do I automatically remind customers about overdue invoices?" | Automatable |
| "Can I set up recurring invoices?" | Automatable | |
| "A customer paid two invoices with one short check. How do I apply it?" | With review | |
| Expenses & categorization | "What category does [this purchase] go under?" | With review |
| "How do I capture receipts and match them to transactions?" | Automatable | |
| "I mixed personal and business spending. How do I split it?" | Human judgment | |
| Payroll & contractors | "How do I prepare and file 1099s for my contractors?" | With review |
| "Payroll taxes look wrong this quarter. What happened?" | Human judgment | |
| "Is this worker a contractor or an employee?" | Human judgment | |
| Sales tax & compliance | "Do I need to collect sales tax in another state, and how do I set that up?" | Human judgment |
| "Why did this invoice charge the wrong sales-tax rate?" | With review | |
| "How do I file and pay the sales tax I collected this quarter?" | With review | |
| Data entry between apps | "How do I get my Shopify, Square, or Stripe sales into the books without typing them?" | Automatable |
| "Can invoices be created from my CRM automatically?" | Automatable | |
| "I import a spreadsheet every month. How do I stop creating duplicates?" | With review | |
| Setup, migration & cleanup | "How do I move from Desktop to Online without losing history?" | Human judgment |
| "How do I undo a reconciliation?" | With review | |
| "My books have been miscategorized for two years. Where do I start?" | Human judgment |
What the pattern says
- The "automatable" column is pure busywork: exports, scheduled reports, reminders, recurring documents, cross-app data entry. Nobody wants to do these. They get asked about constantly because owners are still doing them by hand.
- The "with review" column is the real frontier. The work is mechanical, but the edge cases (duplicates, mismatches, odd payments, tax-rate errors) need a human glance. The right division of labor: software does the work, the owner approves it.
- The "human judgment" column clusters around structure and compliance: entity questions, multi-state sales tax, migrations, multi-year cleanups. These stay with humans, often the bookkeeper or accountant the owner already trusts.
Methodology. v0.2, qualitative. We sampled recurring question patterns (not verbatim posts) from public Q&A surfaces in June 2026: the Intuit QuickBooks Community Q&A (highest-traffic categories: Banking, Reconcile, Transactions, Reports, Taxes), QuickBooks help-center most-viewed articles, the US Chamber's common-QuickBooks-questions guide, and bookkeeping subreddits (r/QuickBooks, r/Bookkeeping, r/smallbusiness). Automatability scoring is our editorial judgment of current AI tooling: deterministic and low-risk rates "automatable today"; mechanical with edge cases rates "with review"; structural or compliance questions rate "human judgment." v0.2 (June 2026) adds the sales tax & compliance pattern, sampled from the same sources. A quantitative frequency index (thread counts per pattern, by community) ships in the next edition.