Solo CPAs: 5 QuickBooks Audit-Log Queries + 7 Intuit Intelligence Prompts To Run This Friday (May 2026)

Intuit Accountant Suite shipped Books Close + Intelligence Chat. Here are 5 audit-log queries + 7 Monday-morning prompts every solo CPA should bookmark.

The pitch from Intuit this spring is that Intuit Accountant Suite (IAS) — the successor to QuickBooks Online Accountant — plus Intuit Intelligence chat plus Books Close plus Client Insights finally gives solo CPAs and small firms a real firm-wide oversight layer, instead of clicking into 12 separate client files to find the one transaction someone touched on a Friday afternoon.

The honest framing — and the one your competition isn’t writing yet — is this: the firm-wide “consolidated audit log” you’ve been asking about for three years is being built, but it isn’t fully here yet. What ships today is the per-client audit log you already know, plus Books Close anomaly detection, plus Intuit Intelligence chat that can query single-client books on demand. Cross-client portfolio queries are listed as “coming soon” by Intuit’s own marketing copy, not GA.

That’s the truth. Here’s what you can actually do this Friday morning, in 30 minutes.

What changed in May 2026 — what’s real, what’s still beta

Per Intuit’s own pricing and product pages plus the May launch announcement on Insightful Accountant:

  • Intuit Intelligence chat is in beta inside IAS. Available to primary and company admins (your “Firm Admin” role).
  • IAS Core: 200 chat prompts per month. IAS Accelerate: 1,000.
  • Each chat message counts as one prompt. Follow-ups count separately. Hit the cap and chat goes read-only until next billing cycle (you can buy more).
  • IAS Accelerate can query specific client files without you switching books. Cross-client portfolio questions (“show me past-due AR over $5K across all clients”) are flagged “coming soon.”
  • Books Close (beta) and Client Insights are the firm-wide oversight surfaces: AI anomaly detection per client, multi-assignee close tasks, KPI rollups.
  • Multi-tab feature that lets you open Books Close and a client’s QBO side-by-side: announced as in-progress, not GA. No tab limits or tier restrictions published yet.
  • The traditional per-client audit log (Gear → Audit log inside each client’s QBO) is still the authoritative trail. That’s where the queries below live.

If you’re on Core today and don’t ask AI questions weekly, stick with Core; if you’re using chat 5+ times daily, Accelerate’s 1,000-prompt cap pays for itself.

The 5 audit-log queries every solo CPA should bookmark this Friday

These run per-client today. Build the habit on your highest-risk 3 clients, then expand. Every step is in Intuit’s audit-log documentation.

1. Changes to chart of accounts in last 7 days

How: Inside client’s QBO → Gear icon → Audit log → Filter → Date: Last 7 days → Events: select entries that include “Lists” or “Chart of accounts” with Added/Edited/Deleted → Apply.

Red flags it surfaces:

  • New accounts with vague names (“Misc Expense,” “Other Income,” “Adjustment”) that often hide misclassifications.
  • Renamed accounts that break period-over-period comparability.
  • Accounts marked inactive that are still being used in reconciliations.

Next step when something fires: Click into the change to see who made it and why. If the change is wrong, reverse it (restore old name, reactivate). Add “Review COA changes” to the client’s Books Close checklist as a recurring weekly task. If the change came from a sub-user who shouldn’t have access, fix permissions today.

2. Deleted transactions across all clients (per-client today, “across all clients” coming)

How (per-client): Gear → Audit log → Filter → Date: Last 7 or 30 days → Events: Deleted/Voided transactions → Apply.

Red flags:

  • Deletions immediately before reporting dates (month-end, loan covenant reporting, tax deadlines).
  • Repeated deletions from one user.
  • Deleted customer invoices or vendor bills affecting AR/AP aging.

Next step: Drill into the deleted transaction’s detail to see the original values and who deleted. Recreate legitimate errors with corrected entries. For high-risk clients, lock prior periods using the closing-date setting in Company settings to prevent retroactive deletions. Add this as a Books Close task per client.

To approximate firm-wide today: put it in your weekly Books Close template for each client. When Intuit’s cross-client portfolio queries go GA (timing TBD), you’ll be able to ask Intuit Intelligence: “Across my client portfolio, list deleted invoices in the last 30 days above $1,000.”

3. Sub-user activity by name in last 24 hours

How: Gear → Audit log → Filter → Date: Today (or Last 24 hours) → User dropdown: select specific sub-user → Events: All events or Added/Edited/Deleted + Settings → Apply.

Red flags:

  • A junior staffer or external bookkeeper changing tax settings, company settings, or user roles.
  • Someone posting late at night when their normal hours are 9-to-5.
  • Editing or deleting transactions when they should only have view access.

Next step: Sample a handful of their transactions. Open one and check Audit history for the detailed before/after. Adjust their permissions if they have more access than they need. If sub-user activity reveals a training gap, address it before busy season.

4. Anything modified outside business hours

How: Gear → Audit log → Filter → Date: Last 7 days → Events: All → Apply, then visually scan timestamps for entries after 7pm or on weekends.

This one is manual — Intuit’s audit log doesn’t yet support a native time-of-day filter. So you scan. Two minutes per client per week.

Red flags:

  • Large journal entries posted at midnight on a Saturday.
  • Bulk changes outside normal team hours.
  • Repeated settings changes (closing date, user roles) on weekends.

Next step: Open the entry, review Audit history, confirm a legitimate reason. If you can’t get a clean explanation, follow your firm’s internal-control procedure — and document the follow-up. For users with persistent off-hours patterns, consider workflow approvals before transactions post.

5. Edits to historical periods (anything > 30 days old being changed)

How: Gear → Audit log → Filter → Date: Last 30 days (this is the change date, not the transaction date) → Events: Edited transactions → Apply, then scan for transactions where the transaction date is more than 30 days before today.

Red flags:

  • Back-dated journal entries affecting revenue, COGS, or equity.
  • Changes to reconciled bank or credit-card transactions.
  • Vendor or customer transactions being moved between periods without an obvious reason.

Next step: Open each transaction and use Audit history for the pre-/post-change comparison. If the prior period is supposed to be closed, set or tighten the closing date and password. For users who repeatedly request historical edits, switch to a “request-only” change process where they document why before you allow it.

Build all five into a 15-minute Friday-afternoon ritual per client. Or, on Accelerate, ask Intuit Intelligence to surface candidates first (Prompts 4 and 6 below) so the audit log is your verification layer, not your discovery layer.

The 7 Intuit Intelligence prompts to run on Monday morning

These are the questions to type into Intuit Intelligence chat first thing Monday. Where the prompt is fully supported today, that’s flagged. Where it’s “coming soon” cross-client, that’s flagged too.

“Show me cash flow trends for Client X for the current quarter, broken down by month, and highlight any months with negative cash flow. Include links to the underlying cash flow statement.”

What you’ll get: a narrative summary plus the monthly figures, with source links back to the cash flow report.

2. Past-due AR over $5K (✅ per-client today; cross-client coming)

In the client’s books today:

“Which customers have past-due AR over $5,000? Show customer name, balance, and days past due.”

When cross-client portfolio queries go GA:

“Across my client portfolio, list clients with total past-due AR over $5,000.”

3. Expense categories versus last quarter (✅ supported today)

“Compare Client A’s operating expenses by category this quarter versus last quarter. Flag any category that increased by more than 20%, and show the absolute dollar change.”

This is the prompt that gets the most surprise from solo CPAs the first time they run it — it’s the equivalent of pulling the categorized P&L comparison report manually, with the AI doing the variance analysis.

4. What changed on a client’s books last week (✅ supported today)

“Summarize key changes on Client B’s books in the last 7 days — new large transactions, new vendors, and any unusual journal entries. Include links to supporting reports.”

The honest caveat: treat this as a summary, not a substitute for the audit log. If the AI’s summary surprises you, go to Gear → Audit log to verify.

5. Deleted invoices in last 30 days (✅ per-client; cross-client coming)

In a client’s books today:

“List deleted invoices in the last 30 days. Show customer, amount, date deleted, and which user deleted them.”

When cross-client goes GA:

“Across my client portfolio, list clients with deleted invoices in the last 30 days above $1,000.”

6. Abnormal transactions over $1K (✅ supported, pairs with Books Close anomaly detection)

“Identify any transactions over $1,000 in the last 30 days that look unusual compared to this client’s typical spending. Explain why each may be an anomaly and link to the transaction.”

This is the strongest example of where Intuit Intelligence + Books Close anomaly detection genuinely changes the workflow: you get a Monday-morning shortlist of “things to investigate” instead of pulling reports yourself.

7. Tax-deadline preparation status (◐ partially supported)

“For my clients with tax returns due in the next 30 days, summarize their books-to-tax preparation status based on reconciliations, missing information, and open Books Close tasks.”

Intuit hasn’t published this as a canned prompt, but the data exists. Frame it as your firm’s emerging workflow — define what “ready for tax” means (all bank accounts reconciled, AR reviewed, no open Books Close exceptions) in your Books Close templates, then ask Intuit Intelligence to surface that status across clients.

What this means for you

If you’re a true solo CPA on IAS Core (200 prompts/month) — bookmark all 5 audit-log queries today. They cost zero prompts. Save Intuit Intelligence for the highest-leverage questions: Prompts 1, 3, and 6 cover most of what you’d otherwise pull manually.

If you’re on IAS Accelerate (1,000 prompts/month) — turn the 7 Monday prompts into a personal cheat-sheet. Run them in batches Monday morning before your first client meeting; the variance-versus-last-quarter prompt alone will surface 2–3 talking points per client.

If you have 1–3 staff with sub-user access — Audit Log Query #3 (sub-user activity by name) is your insurance. Run it Friday afternoons across all active clients during busy season. It’s the single highest-leverage 5 minutes you’ll spend on internal controls each week.

If your firm has 50+ clients — wait for cross-client portfolio queries to go GA (Intuit hasn’t given a date) before restructuring your workflow around them. Until then, lean on Books Close + Client Insights for the firm-wide rollup. Add the audit-log queries as standardized Books Close tasks so every staff person runs them.

If you’re on the legacy QuickBooks Online Accountant and haven’t migrated to IAS yet — read Intuit’s transition timeline. The May 2026 features (Intuit Intelligence, Books Close enhancements, Client Insights AI) live in IAS, not the legacy product.

What this can’t fix yet

  • Cross-client portfolio queries are still “coming soon” for the AI chat. The headline most coverage runs (“ask AI anything about all your clients at once”) is not here yet. Run the 7 prompts inside individual client books for now.
  • No native time-of-day filter on the audit log. Query #4 is manual scanning. If your clients have a high-volume team, this is where you lose 10 minutes a week. Add it to your Friday closeout, not your daily.
  • Multi-tab feature isn’t fully GA. Intuit’s Tax Pro Center flags it as in-progress for Books Close + client QBO side-by-side viewing. No date, no tab limits published.
  • Intuit Intelligence is not your reviewer. AICPA’s April 2026 ethics guidance (“Ethics, accountancy, and AI-powered tools”) says treat AI as a strong staff assist, not a replacement for professional judgment. Every output it generates needs your sign-off before it leaves your firm. Document that you reviewed.
  • Each prompt counts. A follow-up question is a separate prompt against your monthly cap. Phrase Monday-morning prompts to get the answer in one shot when possible.
  • AICPA is updating professional standards around technological competence, AI documentation, and quality control. Some state CPA societies (Texas in particular) have already issued guidance saying AI must enhance, not replace, professional judgment. Check your state’s most recent ethics-AI guidance before adopting these prompts in regulated work.

The bottom line

You don’t need a $30,000 advisory tech stack to get firm-wide oversight in 2026. You need 30 minutes on Friday afternoon to set up the 5 audit-log queries on your top 3 clients, plus a Monday-morning routine of 5–7 Intuit Intelligence prompts on the same clients.

The “Consolidated Audit Logs across all clients” headline is real — it just hasn’t shipped to GA yet. What’s shipped today (per-client audit log + Books Close + Client Insights + Intuit Intelligence chat) gets you 80% of the value with 20% of the wait.

If you’re scaling your AI-assisted advisory practice systematically, our AI for Solo CPAs Advisory System course covers the full Monday-morning ritual + audit-log discipline + Books Close template design. The companion Accountants & Finance AI Foundations course is the one to assign to a bookkeeper joining your firm.

Sources

Build Real AI Skills

Step-by-step courses with quizzes and certificates for your resume