DeepLedgerTo analyze profit and loss with AI, connect Claude or ChatGPT to QuickBooks Online through DeepLedger's MCP server, retrieve two P&L reports with explicit dates and the same accounting basis, compare the totals, and trace each important change to transaction detail. Ask for evidence behind every explanation. A fluent summary is useful only when the figures and report settings match QuickBooks.
This guide is for accountants, bookkeepers and owners who review monthly results. The same prompts work in any AI app connected to DeepLedger, including Grok.
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.
What do you need before asking AI about a P&L?
Use the Claude connection guide or the ChatGPT guide if you have not connected your AI app. Both add the same address:
https://mcp.deepledger.ai/mcp
You can also attach exported reports; label them as snapshots with the same settings.
Before asking why profit changed, write down what you are comparing:
| Setting | This example |
|---|---|
| QuickBooks company | Demo company |
| Reporting currency | USD |
| Earlier period | July 1–31, 2026 |
| Later period | August 1–31, 2026 |
| Accounting basis | Accrual for both reports |
| Filters | Entire company; no class, location or customer filters |
| Source | QuickBooks 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. Check the displayed dates rather than trusting the default year-to-date comparison. See Intuit's comparison-report instructions.
If the client has accounting policies in DeepLedger's AI Brain, such as a capitalisation threshold of $2,500 for equipment, ask the AI to read them first. It can then tell you whether a large expense line follows the client's own policy. The AI reads the AI Brain when you ask, not automatically.
Which prompt should I use for a QuickBooks P&L analysis?
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. Read the
company's AI Brain accounting policies.
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 several companies. A read-only prompt states your intent; use your AI app's tool permissions as well where it offers them.
How do I check the AI's P&L totals?
The two P&L responses returned these figures. Amounts are USD; change means August minus July.
| P&L line | July | August | Dollar change |
|---|---|---|---|
| Income | 0.00 | 3,400.00 | +3,400.00 |
| Cost of goods sold | 0.00 | 183.50 | +183.50 |
| Gross profit | 0.00 | 3,216.50 | +3,216.50 |
| Operating expenses | 20.00 | 2,290.00 | +2,270.00 |
| Net income | -20.00 | 926.50 | +946.50 |
July's report contained no COGS section; income and gross profit were both zero. The table shows 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.
How do I trace a P&L change to transactions?
The August P&L Detail response matched the summary. These selected demo entries explain the amounts:
| Account | Supporting entries | August total |
|---|---|---|
| Professional Services & Implementation | Aug 21 invoice 1,800; Aug 22 invoice 900; Aug 23 credit memo −100; Aug 24 sales receipt 300 | 2,900.00 |
| Services | Aug 26 invoice | 500.00 |
| Cloud Hosting & Infrastructure | Aug 20 bill | 150.00 |
| Payment Gateway & Interchange Costs | Aug 25 deposit fee line | 33.50 |
| Developer Tools & Software | Aug 20 bill 350, less Aug 22 vendor credit 75 | 275.00 |
| Engineering & Product Salaries | Aug 31 journal entry | 2,000.00 |
| Bank & Merchant Charges (Operating) | Aug 18 expense | 15.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.
To check how an accrual like that was built and posted, see AI journal entries in QuickBooks.
What should the AI hand back?
A useful final response says 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.
Ask the AI to turn each open question into a DeepLedger task, so it appears on the company's Tasks tab for the person who can answer it. Use the same questions in your month-end close checklist. If you run the close in DeepLedger's Month-end close, the AI can prepare checks and statements there, and a person signs off the period.
For future payment timing, build a separate 13-week cash flow forecast. Historical profit is not a forecast of available cash. The deliverable here is a checked analysis and a review list; it does not certify the books, reconcile bank accounts or authorize changes.
Troubleshooting
The AI's totals differ from QuickBooks. Compare company, dates, accounting basis, filters and retrieval time first. Then look for missing detail pages or records changed since the earlier report. Do not post a correcting entry to force two outputs to agree.
The AI quotes a growth percentage from a zero or negative month. The baseline makes the percentage meaningless. Ask for the dollar change and a "not meaningful" label instead.
The AI analyzed the wrong company. Your active company is shared across connected AI apps, so another session may have switched it. Ask "which company am I in?", switch by name and rerun both reports.
Large amounts sit in Uncategorized Expense. The analysis cannot explain what was never classified. Clean those up first with the uncategorized transactions guide.
Frequently asked questions
Can Claude or ChatGPT analyze a QuickBooks P&L?
Yes. Connected to QuickBooks Online through DeepLedger, Claude or ChatGPT retrieves the Profit and Loss and P&L Detail reports, compares periods and traces changes to transactions. Confirm the company, currency, dates, accounting basis and filters, then verify the totals against the same report in QuickBooks.
Why might the AI's P&L totals differ from QuickBooks?
The usual causes are a different company, date range, cash or accrual basis, filters or retrieval time. Omitted detail pages and records changed since the earlier report also cause differences. Resolve the difference before relying on the explanation.
Can AI explain a percentage change from zero income?
No. 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.
Does a read-only prompt stop the AI from changing records?
No. A prompt that says do not change records states your intent, but the connection can still expose write tools. Use the tool permissions in your AI app where it offers them, and check QuickBooks if anything unexpected appears.
Can I analyze a P&L with AI without connecting QuickBooks?
Yes. Export the Profit and Loss and P&L Detail from QuickBooks with the same dates, basis and filters, and attach them to the conversation. Label them as snapshots, because the AI cannot refresh them or look up transactions that are not in the export.
Is an AI P&L analysis a review of the books?
No. The analysis explains what the reports show and lists questions to review. It does not certify the books, reconcile bank accounts or approve adjusting entries; a person does that.
Related guides
- QuickBooks MCP server guide
- AI journal entries in QuickBooks
- Month-end close checklist for QuickBooks
- Build a 13-week cash flow forecast from QuickBooks
Find every AI app DeepLedger works with on AI Platforms & Integrations.