AI Bookkeeping in Practice

Analyze a QuickBooks Profit and Loss Report with Claude or ChatGPT

Published by DeepLedgerPublished on September 20, 2026

A verified demo P&L walkthrough: compare months, check cash or accrual basis, trace variances to transactions, and avoid misleading percentage changes.

Two paper reports with abstract teal and mint charts stand over a ledger beside an amber magnifying glass.

To analyze a QuickBooks P&L with Claude or ChatGPT, retrieve two reports with explicit dates and the same accounting basis, compare the totals, and trace important changes to transaction detail. Ask for evidence behind each explanation. A fluent summary is useful only when the figures and report settings match QuickBooks.

The example below uses read-only results retrieved through DeepLedger from our designated Demo company on September 20, 2026. These are demonstration records, not customer performance or a claim about DeepLedger's financial results. We did not create or change transactions to produce this article.

1. Confirm what you are comparing

Use the Claude connection guide or ChatGPT guide if you have not connected your AI client. You can also provide exported reports; label them as snapshots and include the same settings.

Before asking why profit changed, record:

SettingThis example
QuickBooks companyDemo company
Reporting currencyUSD
Earlier periodJuly 1–31, 2026
Later periodAugust 1–31, 2026
Accounting basisAccrual for both reports
FiltersEntire company; no class, location or customer filters
SourceQuickBooks P&L and matching P&L Detail through DeepLedger

Both periods have 31 calendar days. That makes the date windows easy to compare, but does not make this sparse demo dataset representative of a real business. In live books, also consider seasonality, missing postings and whether either period is incomplete.

In QuickBooks Online, you can run Profit and Loss Comparison, set the dates and accounting method, and choose a comparison period plus dollar or percentage changes. Verify the actual displayed dates rather than trusting the default year-to-date comparison. See Intuit's comparison-report instructions.

2. Start with a prompt that fixes the scope

Copy this and substitute your company and completed reporting periods:

Use DeepLedger for read-only P&L analysis. Do not create or change records.

First show the active QuickBooks company and home currency. If it is not
my intended company, stop and ask which company to use.

Retrieve Profit and Loss for July 1–31, 2026 and August 1–31, 2026,
both on the accrual basis, with no class, location or customer filters.
State the settings and retrieval date. If either report fails or is
incomplete, explain that before drawing conclusions.

Compare income, cost of goods sold, gross profit, operating expenses
and net income. Show August minus July in dollars. Do not calculate
percentage growth from a zero baseline; flag negative baselines too.

Retrieve matching P&L Detail for material changes. Include dates,
transaction types, account names, document references where available,
and amounts. Read every required page of the results.
Separate observed entries from explanations that need more evidence.
Finish with the questions I should review, not journal entries to post.

DeepLedger's relevant tools are qbCompanyProfile for identity and currency, and qbReports with ProfitAndLoss or ProfitAndLossDetail. Specify startDate, endDate and accountingMethod for each report. Check the company on each result if you work across multiple companies. A read-only prompt states your intent; use tool-level restrictions as well where your client supports them.

3. Check the returned totals and arithmetic

The two P&L responses returned these figures. Amounts are USD; change means August minus July.

P&L lineJulyAugustDollar change
Income0.003,400.00+3,400.00
Cost of goods sold0.00183.50+183.50
Gross profit0.003,216.50+3,216.50
Operating expenses20.002,290.00+2,270.00
Net income-20.00926.50+946.50

July's report contained no COGS section; income and gross profit were both zero. The table displays zero COGS for that empty section, not a separately returned COGS total.

The August arithmetic is 3,400.00 − 183.50 = 3,216.50 gross profit, then 3,216.50 − 2,290.00 = 926.50 net income. No other income or expense section appeared in this example. If your report has those sections, include them when reconciling net income.

The net-income bridge also ties: −20.00 + 3,400.00 − 183.50 − 2,270.00 = 926.50. This explains the numerical movement without claiming why the underlying business changed.

Do not describe income as growing by a percentage: July's baseline is zero. Net income crosses from a loss to a profit, so the dollar improvement is clearer than a percentage calculated from a negative denominator. August's gross margin is approximately 94.6% and net margin 27.3%, calculated against August income. Those are demo calculations, not benchmarks or forecasts.

4. Trace the change to actual entries

The August P&L Detail response matched the summary. These selected demo entries explain the amounts:

AccountSupporting entriesAugust total
Professional Services & ImplementationAug 21 invoice 1,800; Aug 22 invoice 900; Aug 23 credit memo −100; Aug 24 sales receipt 3002,900.00
ServicesAug 26 invoice500.00
Cloud Hosting & InfrastructureAug 20 bill150.00
Payment Gateway & Interchange CostsAug 25 deposit fee line33.50
Developer Tools & SoftwareAug 20 bill 350, less Aug 22 vendor credit 75275.00
Engineering & Product SalariesAug 31 journal entry2,000.00
Bank & Merchant Charges (Operating)Aug 18 expense15.00

The salary journal entry is the largest operating-expense line. The software account increases from July's 20.00 to August's 275.00, a 255.00 change. Together with the salary entry and bank fee, that accounts for the 2,270.00 operating-expense increase.

The correct explanation is that the report includes a 2,000.00 salary accrual entry. It does not prove the company hired someone, paid that cash, or approved the accrual. Likewise, the 75.00 vendor credit reduces the software expense here; it does not establish that a cash refund arrived. Names and personal details are omitted from this demonstration.

5. Turn the analysis into review questions

A useful final response should say what is known and what still needs support:

  • Confirm whether the salary accrual agrees with the period's payroll or supporting calculation.
  • Check the software bill and vendor credit against their source documents.
  • Confirm that all expected income and expenses have been posted before treating August as complete.
  • Review account classification if a line looks unusual. The example follows the demo chart of accounts; it is not a recommendation to use those categories for every business.

If the AI and QuickBooks disagree, first compare company, dates, accounting basis, filters and retrieval time. Then inspect missing detail pages or records changed since the earlier report. Do not post a correcting entry simply to force two outputs to agree.

For uncategorized entries, use the transaction cleanup guide. For Desktop data, read the compatibility guide before trying an Online connector. The deliverable here is a checked analysis and a review list; it does not certify the books, reconcile bank accounts or authorize changes.

Frequently asked questions

Can Claude or ChatGPT analyze a QuickBooks P&L?

Yes, with a supported connection or a complete report you provide. Confirm the company, currency, dates, accounting basis and filters, then verify the analysis against the source report.

Why might the AI's P&L totals differ from QuickBooks?

Check the company, date range, cash or accrual basis, filters and retrieval time. Also check for omitted rows or changed records. Resolve the difference before relying on the explanation.

Can AI explain a percentage change from zero income?

There is no defined percentage growth rate when the prior value is zero. Show the dollar change and label the percentage not meaningful instead of inventing a growth rate.

Ready to get started?

Give your firm the leverage of an AI agent. Try the integration today.

Create an Account