To compare multiple QuickBooks companies with AI, connect them to DeepLedger once, then ask your AI app to run the same report for each company with the same dates, accounting basis and currency, and lay the results side by side. The result is a table you can trace back to each company's books. This guide walks through a profit and loss comparison, how to investigate a difference, and how to track a multi-entity month-end close across companies.
It is for accountants and finance teams who look after several QuickBooks Online companies. A comparison is not a consolidation: account mappings, currencies and intercompany activity need separate treatment, covered in the guide to QuickBooks multi-entity consolidation.
This walkthrough uses Pinebridge Studio and Pinebridge Services, two fictional companies. The figures are illustrative arithmetic, not customer results.
Before you start
- Each company connected to QuickBooks in DeepLedger: open Companies, select the company, open its Connections tab and choose Connect to QuickBooks. An admin does this once per company.
- Your DeepLedger account assigned to every company you want to compare.
- Your AI app connected to
https://mcp.deepledger.ai/mcp. The QuickBooks MCP server guide covers each app, and the multiple-company connection guide explains switching.
What should the comparison settings be?
Decide what you want to learn. "Which company has a lower gross margin this month?" is a clearer start than "Analyze all my businesses." Then fix one specification for every company:
| Setting | Example |
|---|---|
| Companies | Pinebridge Studio and Pinebridge Services |
| Report | Profit and Loss |
| Period | August 1 to 31, 2026 |
| Accounting basis | Accrual |
| Filters | Entire company, no class or location filters |
| Currency | Verify each company's home currency |
| Output | Separate company columns, then supported observations |
If the companies use different currencies, keep their amounts separate until you agree a translation method. If similar costs sit in differently named accounts, disclose that before interpreting margins.
QuickBooks also offers native multi-entity reporting in eligible Intuit Accountant Suite accounts, with availability varying by region or firm as of November 2026. See Intuit's multi-entity reporting guide if you need that. The workflow here compares source reports through an AI conversation.
How do I compare multiple QuickBooks companies with AI?
Copy this prompt into your AI app:
Use DeepLedger to compare Pinebridge Studio and Pinebridge Services.
This is a reporting task. Do not create or change accounting records.
For each company, one at a time:
1. Switch to the company and read its QuickBooks profile.
2. Record its company name and home currency.
3. Retrieve Profit and Loss for August 1-31, 2026 on the accrual basis,
for the whole company without class, location or customer filters.
4. Keep the company name and report settings with the result.
Show separate columns for income, cost of goods sold, gross profit,
operating expenses and net income. Show other income and expenses
separately if present. Calculate margins only when income makes
them meaningful.
If either report is unavailable or incomplete, show it as unavailable
and explain why. Do not replace missing results with zeros, combine
different currencies or describe a sum as consolidated financials.
Your active company is shared across your AI apps. Run the sequence without another conversation switching companies, and check the company named in each result. Developers running parallel jobs pin each request to a company with an X-Organization-Id header, as the connection guide explains.
Comparisons are read-only. DeepLedger's company write guard adds a second layer: every write must name its company, and DeepLedger refuses a write whose company is missing or differs from the active one. A reporting session that moves between companies cannot post a bill into the wrong one.
How do I check the arithmetic?
Suppose the reports returned these figures in USD:
| P&L line | Pinebridge Studio | Pinebridge Services |
|---|---|---|
| Income | $50,000 | $40,000 |
| Cost of goods sold | $20,000 | $24,000 |
| Gross profit | $30,000 | $16,000 |
| Operating expenses | $18,000 | $10,000 |
| Net income | $12,000 | $6,000 |
| Gross margin | 60% | 40% |
| Net margin | 24% | 15% |
Neither company has other income or expenses in this illustration. Studio's gross profit is $50,000 minus $20,000, and its net income is $30,000 minus $18,000. Gross margin is gross profit divided by income; net margin is net income divided by income.
The table shows that Services has a lower reported gross margin. It does not show why. Different services, cost classifications, missing entries or unusual purchases could contribute.
Never display "0" for a company whose report failed. A zero is a reported amount; missing data is a different condition.
How do I investigate a difference between companies?
Use the first table to narrow the next question:
For Pinebridge Studio and Pinebridge Services, investigate the
difference in August 2026 gross margin using the same accrual basis.
Retrieve the relevant Profit and Loss Detail for income and cost of
goods sold, reading all required pages. Show the largest contributing
accounts and transactions separately for each company. Include dates,
document references and amounts where available.
Check whether similar costs appear under different account categories.
Propose a comparison mapping for review without editing either chart
of accounts. Separate recorded facts from possible explanations and
list any documents or answers needed. Do not post adjustments.
A comparison mapping is an analysis aid. The AI might propose grouping two differently named contractor accounts. You confirm that they hold comparable costs. Keeping the original account names beside the grouping makes that decision easy to review.
Save the agreed mapping where the next comparison can use it. An owner or admin can add a firm-level entry in the AI Brain under Accounting policies, such as "Group Subcontractors and Contract Labor as contractor costs in multi-company comparisons", applies to every client. Ask the AI to read the AI Brain before the next run. For a single-company deep dive, see the P&L analysis walkthrough.
How do I track a multi-entity month-end close?
A multi-entity month-end close is one close per company, tracked together. Each company in DeepLedger has its own Month-end close tab with an approved close checklist and a Close Sheet.
-
Run each company's close. Switch to each company and ask the AI to start that month's close. It prepares reconciliations, runs the close steps and proposes adjusting entries on that company's Close Sheet.
-
Read every close in one pass.
For each company I can access, switch to it and read its September 2026 month-end close. Show one row per company: close status, checks that need action, proposed entries waiting for approval and reconciliations not yet finished in QuickBooks. Do not change anything. -
Compare the results. Once each close is signed off, run the P&L comparison above for the closed month.
-
Sign off company by company. Completing a close creates a sign-off task in that company's Tasks. A person signs off each one; the AI cannot.
| Close item | Where it lives | Who acts |
|---|---|---|
| Close checklist | Each company's Month-end close tab | AI proposes, a person approves |
| Close Sheet checks and entries | Each company's Month-end close tab | AI prepares, a person approves entries |
| Bank reconciliations | Prepared in DeepLedger | A person signs off and finishes them in QuickBooks |
| Sign-off | Each company's Tasks | A person |
Nothing here runs on its own. The AI works through the companies when you ask. The steps for one company are in the accounting month-end close checklist.
Comparison is not consolidation
A company comparison keeps the entity columns. Consolidation adds accounting decisions: intercompany eliminations and any currency translation.
For example, one Pinebridge company could charge the other for services. A plain addition keeps that internal revenue and the matching expense. Do not call the total group revenue unless eliminations have been prepared and reviewed.
Connecting an Intuit Enterprise Suite parent does not mean a report includes every child entity. Check which company the tool returned. The IES connection guide describes what DeepLedger supports.
Keep the prompt, company list and report settings with the reviewed analysis. Ask the AI to create a task in the affected company's Tasks for each unresolved classification or missing document. Next month, change the period and run it again.
Frequently asked questions
Can I compare multiple QuickBooks companies in one report?
Yes, as a side-by-side comparison. An AI connected through DeepLedger can run the same report for each QuickBooks company you can access, with the same dates and accounting basis, and lay the results out in one table. Each column stays traceable to one company's books. A sum of the columns is not a consolidation.
Does comparing companies change anything in QuickBooks?
No. Comparing companies only reads reports. DeepLedger also refuses any write that does not name its company, or that names a different company from the active one, so a comparison cannot record a transaction in the wrong company. Nothing is written unless you ask for a write and name the company.
What is the difference between comparing and consolidating companies?
A comparison keeps each company in its own column. A consolidation combines them into one set of statements after mapping accounts, eliminating intercompany activity and translating currencies. Intuit Enterprise Suite consolidates natively; separate QuickBooks Online companies need a workpaper or Spreadsheet Sync in QuickBooks Online Advanced.
Can AI help with a multi-entity month-end close?
Yes, one company at a time. Each company in DeepLedger has its own Month-end close tab and Close Sheet. When you ask, the AI can run each company's close steps and then read every company's close to list the checks that still need action. A person signs off each company's close.
Why did a report come back for the wrong company?
Your active company is shared across your AI apps, so a switch in another conversation moves it. Ask the AI to confirm the company named in each result. For parallel jobs, developers pin each request with an X-Organization-Id header.
Related guides
- Connect multiple QuickBooks companies with one sign-in
- Intuit Enterprise Suite consolidation with AI
- Accounting month-end close checklist
- Analyze a QuickBooks profit and loss with AI
Connect your AI app on AI Platforms & Integrations, then run the comparison prompt on last month for two companies.