The DIY Books Audit — 10 AI prompts to find what your bookkeeper missed

Your books can look fine and still be wrong.

A profit and loss statement that shows a profit, a balance sheet that balances, a bookkeeper who sends reports on time — none of that proves the numbers underneath are right. Most errors hide in places owners never look: unreconciled accounts, duplicate payments, balances frozen for years, deleted transactions. This guide gives you ten copy-and-paste prompts that turn an AI assistant into a first-pass auditor. Each prompt runs a specific screen that professional controllers use when they take over a set of books. You pull a report from QuickBooks Online, upload it, paste the prompt, and read the answer.

Pull these exports

In QuickBooks Online, go to Reports, run each of the following, and export to Excel. Each report is set to the window that actually produces findings.

• Profit and Loss — by month, accrual basis — Last 12 months
• Profit and Loss — by month, cash basis — Same 12 months
• Balance Sheet — by month — Last 24 months
• A/R Aging Detail and A/P Aging Detail — As of today — snapshots, no date range applies
• Transaction Detail by Account — Last 12 months
• Audit Log — Last 24 months · Gear icon → Audit Log → export
• Bank and credit card statements (PDF or CSV) — Last 3 to 6 months per account

The ten audits

Each screen is one prompt, one set of uploads, and a short list of red flags to check in the answer.

• 01. Does your P&L agree with your balance sheet? — The single fastest integrity check. Net income on your P&L must flow into equity on your balance sheet. When the two reports disagree, something was changed after the fact, run on different bases, or is simply broken.
• 02. Frozen and backwards balances — Balances that never move are balances nobody is watching. Balances with the wrong sign (negative accounts payable, negative assets) mean transactions were entered wrong. Both are confession flags: they tell you which accounts your bookkeeper has stopped looking at.
• 03. Do your books match the bank? — Reconciliation is the bedrock. If the QuickBooks balance doesn't tie to the actual bank statement, everything downstream is guesswork — and 'reconciled' status inside QBO can be forced with fabricated adjusting entries.
• 04. Duplicate and double payments — The most common form of silent cash loss. Duplicate vendor payments, double-entered deposits, and re-imported bank feeds inflate expenses or revenue and go unnoticed because each entry looks legitimate on its own.
• 05. Cash vs. accrual: which profit is real? — Your cash-basis and accrual-basis P&Ls tell two different stories, and the gap between them is where problems hide — uncollected revenue, unpaid bills, and QBO's infamous 'Unapplied Cash' accounts.
• 06. Stale receivables: money you'll never see — Old invoices sitting in A/R overstate your assets and your income. Some are collectible with a phone call; some are fiction that should have been written off years ago.
• 07. Payables and phantom bills — The mirror image: A/P that overstates what you owe (bills entered twice, bills paid outside QBO) or understates it (bills never entered), plus vendor credits nobody applied.
• 08. The subscription and recurring-cost sweep — Run against actual bank data, not the books — so it catches charges your bookkeeper miscategorized or lumped together. Most businesses find forgotten subscriptions and price creep the first time they run this.
• 09. Who deleted what? Audit log forensics — QuickBooks records every deletion, void, and edit. Almost nobody reads it. Deleted transactions, un-reconciled months, and heavy after-the-fact editing are the strongest signals of either sloppy work or something worse.
• 10. Owner and related-party balances — Owner draws, shareholder loans, and due-to/due-from accounts between related companies are where personal and business money blur. Left unwatched, they create tax problems and — in multi-entity setups — balances that don't agree with each other.

Frequently asked questions