This is a real financial health assessment of ACME Technology Solutions — a million-dollar IT company. Walk through the entire pipeline — from 12 uploaded documents to AI-generated executive summaries, risk matrices, and corrective action plans. Everything you see here was created by the platform. No templates. No editing.
The AI wrote these. Every word.
Read what the platform actually produces.
12 financial documents in. Two complete reports out. No human editing. No templates. Every finding traced to its source document with specific dollar amounts.
The comprehensive report covers cash flow analysis, tax compliance, debt covenants, revenue risk, owner compensation, and a prioritized corrective action plan.
How the research pipeline works
Every research project follows the same flow. The AI handles the heavy lifting at every stage — you guide the investigation and validate the conclusions.
Your source material — financial statements, tax returns, bank statements, aging reports. The platform ingests everything, classifies it, and makes it searchable. From a single page to hundreds of documents.
🔬 Scenarios
Analysis instructions written in plain English. "Analyze the cash flow crisis" or "Review tax compliance gaps." The AI reads your entire corpus and produces targeted analysis. Run multiple scenarios to examine data from different angles.
🔍 Findings
Concrete, verifiable conclusions extracted from scenario analysis. Each finding is scored by confidence level and traced back to its source document. Proposed by AI, validated by the researcher.
🧩 Synthesis
Cross-cutting analysis that connects findings from multiple scenarios. Scorecards, risk matrices, corrective action plans — synthesis turns individual data points into strategic intelligence.
📝 Reports
AI-generated documents created from your research data. Not a data dump — the AI performs additional analysis to produce a coherent, professional report. Executive summaries or 50-page deep dives.
📊
ACME Technology Solutions LLC — Financial Health Assessment
IT Managed Services | Columbus | $1M Revenue | LLC (Partnership) | Tax Year 2025
12
Source Documents
6
Analysis Scenarios
5
Syntheses
2
Full Reports
This project demonstrates a complete financial health analysis for a million-dollar IT services company. The document corpus includes balance sheets, income statements, cash flow analysis, tax returns (federal and Ohio), bank statements, accounts receivable aging, debt schedules, client revenue breakdowns, contractor payment records, and insurance summaries.
Every document was ingested and classified automatically. The AI reads all 12 documents, then runs targeted analysis scenarios and synthesis operations to produce strategic financial intelligence — from cash flow crisis identification to tax compliance gaps to revenue concentration risk.
No coding or technical knowledge was used at any point. Every scenario, synthesis, and report was created using plain English instructions.
Source documents
12 financial documents covering the complete picture — income, expenses, assets, liabilities, taxes, banking, clients, contractors, and insurance.
📄Balance Sheet — Assets, liabilities, and equity as of 12/31/2025
📄Profit & Loss 2025 — Current year income statement with quarterly breakdown
📄Profit & Loss 2024 — Prior year comparison with year-over-year trends
📄Cash Flow Statement — Operating, investing, and financing activities with quarterly cash position
📄A/R Aging Report — Accounts receivable by customer with aging buckets and notes
📄Debt Schedule — All loans, credit lines, and obligations with utilization history
📄Federal Tax Return (1065) — Partnership return with K-1 summaries and deduction schedules
📄Bank Statements Q4 — Three months of transaction detail (October–December 2025)
📄Client Revenue Breakdown — Revenue by client with concentration analysis and MRR trend
📄Contractor Payments (1099) — Subcontractor payments with 1099 filing reconciliation
📄Insurance Summary — All active policies with coverage gap analysis
Analysis scenarios
Six targeted analysis scenarios examine the financial documents from different angles. Each one reads the entire 12-document corpus and extracts specific intelligence. Written in plain English — no code, no query language.
1
Document Completeness & Data Integrity
Before analyzing anything, verify the foundation. Are all 12 documents present, readable, and covering the right time period? Do the numbers reconcile across documents — does the balance sheet match the P&L, does the cash flow match the bank statements, do the tax returns match the income statement? Every discrepancy found here becomes a thread to pull in later scenarios.
What we told the AI
Review all 12 uploaded documents and assess completeness and internal consistency. For each document, confirm it's present, readable, and covers tax year 2025. Then cross-reference: Does the Balance Sheet equity match the P&L net income flow-through? Does the Cash Flow ending balance match the Balance Sheet cash? Does the A/R aging total match the Balance Sheet accounts receivable?
Review all 12 uploaded documents and assess completeness and internal consistency.
For each document, confirm:
- Is it present and readable?
- Does it cover the expected time period (tax year 2025)?
- Are there any obvious gaps, missing pages, or incomplete sections?
Then cross-reference between documents:
- Does the Balance Sheet total equity match the P&L net income flow-through?
- Does the Cash Flow ending balance match the Balance Sheet cash?
- Does the A/R aging total match the Balance Sheet accounts receivable?
- Does the Debt Schedule match the Balance Sheet liabilities?
- Does the P&L revenue match the Client Revenue Breakdown total?
- Do the tax return income figures reconcile to the P&L?
- Do the bank statement ending balances reconcile to the Balance Sheet cash?
- Do contractor payments on the P&L match the 1099 summary?
Output:
1. Document inventory table: Document | Present | Period | Complete | Issues
2. Cross-reference reconciliation table: Items Compared | Match? | Variance | Significance
3. List of all discrepancies found, ranked by severity
4. Missing documents that SHOULD be present for a complete financial review
# ACME Technology Solutions LLC — Document Completeness & Data Integrity Assessment
Prepared for: Financial Health Assessment — Analysis Level 1
Entity: ACME Technology Solutions LLC
Assessment Period: Tax Year 2025 (January 1 – December 31, 2025)
Documents Reviewed: 12 of 12 uploaded files
All 12 documents are present, readable, and cover the expected period. However, cross-referencing reveals several material discrepancies — the Balance Sheet equity doesn't fully reconcile with the P&L net income flow-through, contractor payments on the P&L don't match the 1099 summary, and the tax return income figures show variances against the P&L. These discrepancies become investigation threads for the remaining scenarios.
[... continued in full report ...]
AI AnalysisData Validation
2
Cash Flow Crisis Assessment
The cash position tells the real story. This scenario maps every dollar in and out — when does cash go negative, how often, what triggers it? How dependent is the company on its line of credit? Are the owners taking money the business doesn't have? The output is a month-by-month cash position with specific overdraft events and a runway calculation.
What we told the AI
Analyze the cash position and cash flow trajectory using the Cash Flow Statement, Bank Statements Q4, Balance Sheet, and Debt Schedule. Examine cash balance trends, overdraft frequency, LOC utilization, owner distributions vs available cash, and timing mismatches between revenue and obligations.
Analyze the cash position and cash flow trajectory using the Cash Flow Statement, Bank Statements Q4, Balance Sheet, and Debt Schedule.
Examine:
- Cash balance trend: beginning of year vs end of year, quarterly trajectory
- Bank statement transaction patterns: when does cash go negative? How often? What triggers it?
- Overdraft frequency and amounts — how dependent is the company on the line of credit?
- LOC utilization trend over the year — is it being used as working capital or emergency funding?
- Owner distributions vs available cash — are the owners taking money the company doesn't have?
- Timing mismatches: when does revenue arrive vs when do obligations hit?
- Payroll as a percentage of available cash on payroll dates
Output:
1. Monthly cash position chart data (beginning balance, inflows, outflows, ending balance)
2. Every overdraft event with date, amount, and what caused it
3. LOC dependency analysis: what percentage of monthly operating costs are funded by the LOC?
4. Cash runway calculation: at the current burn rate, when does the company run out of cash and LOC availability?
5. Specific recommendations to stop the cash hemorrhage, ranked by impact and urgency
# ACME Technology Solutions — Cash Flow Crisis Assessment
This assessment evaluates the cash position and cash flow trajectory of ACME Technology Solutions LLC. The analysis identifies trends, issues, and recommendations to address the company's cash flow crisis.
The company ended 2025 with a cash balance significantly below where it started. LOC utilization has been climbing steadily, with the line being used as de facto working capital rather than emergency funding. Overdraft events correlate directly with owner distribution dates and quarterly tax payments. At the current burn rate, the company exhausts available cash and LOC availability before the March 2026 bank review.
[... continued in full report ...]
AI AnalysisCrisis Assessment
3
Revenue & Client Concentration Risk
Revenue grew 2.4% on the surface — but what's underneath? This scenario breaks down revenue by category, maps client concentration risk, analyzes MRR trends, and models what happens if any top-5 client leaves. The result: a concentration risk matrix with industry benchmarks and a specific diversification strategy.
What we told the AI
Analyze revenue composition, client concentration, and growth trends. What percentage comes from the top 1, 3, 5, and 10 clients? Is MRR growing, flat, or declining? What happens to the company if Pinnacle Group or Midwest Logistics leaves? Build a revenue concentration risk matrix with industry benchmarks.
Analyze revenue composition, client concentration, and growth trends using the P&L statements (2024 and 2025), Client Revenue Breakdown, and A/R Aging Report.
Examine:
- Revenue by category (managed services, project work, hardware): trends, margins, and sustainability
- Client concentration: what percentage comes from the top 1, 3, 5, and 10 clients?
- MRR (monthly recurring revenue) trend: is it growing, flat, or declining?
- New client acquisition rate: how many new clients were added and at what revenue?
- Client tenure analysis: are long-term clients generating more or less revenue over time?
- Hardware resale margins: is this business worth the effort?
- Project work trend: why did it decline 15.4% year-over-year?
- Single-client risk: what happens to the company if Pinnacle Group, Midwest Logistics, or Central Ohio Pediatrics leaves?
Output:
1. Revenue concentration risk matrix with industry benchmarks
2. Client dependency analysis — if each top-5 client left, what's the revenue and cash impact?
3. MRR growth analysis with specific recommendations to restart growth
4. Hardware resale profitability analysis — keep, restructure, or drop?
5. Revenue diversification strategy with specific actionable steps
# ACME Technology Solutions — Revenue & Client Concentration Risk Analysis
Financial Health Assessment | Analysis Level 1
ACME Technology Solutions generated $1,042,000 in total revenue for 2025, a modest 2.4% increase over 2024's $1,018,000. Beneath that surface-level growth, however, the company carries serious structural vulnerabilities: revenue is dangerously concentrated among a small number of clients, its largest client is currently non-paying, and project work — historically a growth driver — declined 15.4% year-over-year with no replacement pipeline.
[... continued in full report ...]
AI AnalysisRisk Modeling
4
Tax Compliance & Risk Review
A compliance-focused review covering 1099 filing gaps, worker classification risk, unsupported deductions, Ohio sales tax variances, and owner compensation tax optimization. The AI identifies specific penalties, quantifies exposure, and produces an audit risk score with justification.
What we told the AI
Review all tax-related documents for compliance issues, missed deductions, and audit risk. Check 1099-NEC filing compliance, worker classification risk, vehicle and meals deduction support, Ohio sales tax reconciliation, and owner compensation structure optimization. Produce an audit risk score.
Review all tax-related documents for compliance issues, missed deductions, and audit risk: Federal Tax Return (1065), Ohio Tax Returns, Contractor Payments (1099), P&L statements, and Bank Statements.
Examine:
- 1099-NEC filing compliance: are all contractors over $600 reported? Quantify the gap.
- Worker classification risk: any contractors who might be misclassified employees under IRS and Ohio tests?
- Vehicle deduction: is the business use percentage supported by mileage logs?
- Meals deduction: are all entries properly documented with receipts and business purpose?
- Ohio sales tax: reconcile tax collected vs tax remitted — explain the $180 variance
- Ohio CAT: is the company near the threshold?
- Owner compensation structure: are guaranteed payments vs distributions optimized for self-employment tax?
- Estimated tax payments: are both owners current or will they owe penalties?
- Any red flags that would increase audit risk with the IRS or Ohio Department of Taxation?
Output:
1. Compliance issue table: Issue | Risk Level | Potential Penalty | Recommended Action
2. 1099 gap analysis with specific contractors and amounts
3. Vehicle deduction risk assessment
4. Owner compensation tax optimization analysis
5. Estimated penalty exposure if current issues are not corrected
6. Audit risk score (low/medium/high) with justification
# ACME Technology Solutions LLC — Tax Compliance & Risk Review
Tax Year 2025 | Analysis Level 1
ACME Technology Solutions LLC presents multiple tax compliance vulnerabilities spanning federal 1099 filing gaps, worker classification exposure, unsupported deductions, a documented sales tax variance, and suboptimal owner compensation structuring. The company's overall audit risk is assessed as MEDIUM-HIGH. While the filing infrastructure appears professionally maintained (Morrison & Associates CPA), several quantifiable compliance gaps exist that require immediate corrective action.
[... continued in full report ...]
AI AnalysisCompliance Audit
5
Debt & Covenant Analysis
Every debt obligation analyzed — the line of credit approaching its March 2026 renewal, credit card debt at 22.99% APR, equipment and vehicle loans. Financial ratios calculated against covenant minimums. The critical question: does the company meet the Huntington covenant minimum of 1.25x DSCR, and what happens if the LOC isn't renewed?
What we told the AI
Analyze all debt obligations using the Debt Schedule, Balance Sheet, Bank Statements, and Cash Flow Statement. Calculate debt-to-equity, current ratio, quick ratio, and DSCR. Assess LOC renewal risk for March 2026. Model what happens if the bank doesn't renew.
Analyze all debt obligations using the Debt Schedule, Balance Sheet, Bank Statements, and Cash Flow Statement.
Examine:
- Total debt load relative to equity, revenue, and cash flow — standard financial ratios
- Line of credit: utilization trend, how close to the limit, what happens if the bank doesn't renew in March 2026?
- Debt service coverage ratio: does the company meet the Huntington covenant minimum of 1.25x? How close to breach?
- Credit card debt at 22.99% APR: how much is this costing annually? Should it be consolidated?
- Equipment loan and vehicle loan: are these appropriate for the company's size and cash flow?
- Total annual debt service (principal + interest) as a percentage of revenue and cash flow
- What would happen if interest rates increase on the variable-rate LOC?
- Ability to take on additional debt if needed for growth
Output:
1. Debt summary table with all obligations, rates, payments, and maturity dates
2. Financial ratio analysis: debt-to-equity, current ratio, quick ratio, DSCR — with benchmarks
3. LOC renewal risk assessment — what does the company need to show Huntington in March 2026?
4. Debt restructuring recommendations — what to pay off, what to refinance, what to keep
5. Worst-case scenario: if the LOC is not renewed, what happens? Survival plan.
# ACME Technology Solutions LLC — Debt & Covenant Analysis
Comprehensive Assessment | As of December 31, 2025
This assessment analyzes all debt obligations including the Huntington line of credit, credit card debt at 22.99% APR, equipment loan, and vehicle loan. Financial ratios are calculated against industry benchmarks and covenant minimums. The critical finding: DSCR is approaching the covenant minimum of 1.25x, and the LOC renewal in March 2026 requires demonstrable improvement in cash flow and debt management to avoid non-renewal.
[... continued in full report ...]
AI AnalysisFinancial Ratios
6
Owner Compensation & Profitability Assessment
The owners increased their total compensation by $25,000 (8.9%) while net income dropped 38%. This scenario quantifies total owner draws against available cash, compares to industry benchmarks for IT MSPs, models the impact of reduced draws, and runs the numbers on an S-Corp election for tax savings.
What we told the AI
Analyze owner compensation relative to company performance. Total comp including salaries, guaranteed payments, and distributions. Compare to industry benchmarks. Model what happens if draws are reduced. Run S-Corp election analysis with specific tax savings numbers.
Analyze owner compensation relative to company performance using the P&L statements (2024 and 2025), Balance Sheet, Cash Flow Statement, and Bank Statements.
Examine:
- Total owner compensation: salaries + guaranteed payments + distributions — what's the real number?
- Owner comp as a percentage of revenue: how does this compare to industry benchmarks for IT MSPs?
- Year-over-year: owners increased total compensation by $25,000 (8.9%) while net income dropped 38% — is this sustainable?
- Are the owners taking more than the company can afford? Compare owner draws to available cash on draw dates.
- What would happen if owner draws were reduced to match the company's actual cash generation?
- Partnership split (60/40): is this equitable given roles and contributions?
- Self-employment tax optimization: would an S-Corp election save money? Run the numbers.
- Impact on cash flow: if owner draws had stayed at 2024 levels, how much better would the cash position be?
Output:
1. Owner compensation breakdown table: component | Patterson | Whitfield | Total | % of Revenue
2. Year-over-year comparison showing compensation vs company performance
3. Industry benchmark comparison for IT MSP owner compensation
4. Cash flow impact analysis: current draws vs sustainable draw level
5. S-Corp election analysis: potential tax savings with specific numbers
6. Recommended compensation structure going forward
# ACME Technology Solutions LLC — Owner Compensation & Profitability Assessment
Financial Health Analysis — Analysis Level 1
Several compensation figures vary across documents, which is itself a finding. The P&L shows owner distributions of $185,000. The tax return shows guaranteed payments of $183,000 + $122,000 = $305,000 — a material discrepancy requiring explanation. This analysis works from each document's stated figures and flags inconsistencies. The core finding: owner compensation increased 8.9% year-over-year while net income dropped 38%, a trajectory that is unsustainable and directly contributes to the cash flow crisis.
[... continued in full report ...]
AI AnalysisProfitability
Synthesis operations
Syntheses connect findings across all six scenarios to produce the strategic intelligence that drives decisions — scorecards, survival timelines, risk matrices, and prioritized action plans.
S
🎯 Financial Health Scorecard
A single-page scorecard scoring every aspect of the company's financial health on a 1-10 scale. Cash position, revenue health, debt management, client diversification, tax compliance, owner compensation, insurance, and growth trajectory — each with a one-sentence justification and a red/yellow/green status indicator.
Using findings from ALL scenario analyses, produce a Financial Health Scorecard for ACME Technology Solutions.
Score each area on a scale of 1-10 (10 = excellent, 1 = critical) with a one-sentence justification:
| Area | Score | Status | Key Finding |
|---|---|---|---|
| Cash Position | ? | 🔴🟡🟢 | one sentence |
| Revenue Health | ? | 🔴🟡🟢 | one sentence |
| Debt Management | ? | 🔴🟡🟢 | one sentence |
| Client Diversification | ? | 🔴🟡🟢 | one sentence |
| Tax Compliance | ? | 🔴🟡🟢 | one sentence |
| Owner Compensation | ? | 🔴🟡🟢 | one sentence |
| Insurance & Risk | ? | 🔴🟡🟢 | one sentence |
| Growth Trajectory | ? | 🔴🟡🟢 | one sentence |
Then provide:
1. OVERALL HEALTH SCORE (weighted average)
2. Top 3 strengths (what's working)
3. Top 3 critical risks (what will hurt them if not addressed)
4. 90-day survival assessment: will this company be solvent in 90 days without changes?
Cross-Scenario SynthesisScorecard
S
📈 Cash Flow Forecast & Survival Timeline
Three forward-looking scenarios projected month by month for 6 months: no changes (current trajectory), moderate corrections (reduced draws, suspend non-paying client), and aggressive turnaround (major restructuring). Which path keeps the company alive past the March 2026 LOC renewal?
Using cash flow data, bank statements, debt schedule, and A/R aging from the scenario analyses, project ACME's cash position forward.
Build three scenarios:
1. NO CHANGES — current trajectory continues (same owner draws, same collection rates, same expenses, Pinnacle doesn't pay)
2. MODERATE CORRECTIONS — owner draws reduced 30%, Pinnacle service suspended, credit card consolidated, no new equipment purchases
3. AGGRESSIVE TURNAROUND — owner draws reduced 50%, Pinnacle collected or written off, LOC paid down, hardware resale dropped, 2 new managed services clients added
For each scenario, project month by month for 6 months:
| Month | Revenue | Expenses | Owner Draws | Debt Service | Net Cash | LOC Balance | Ending Cash |
End with:
- Which scenario keeps the company alive past the March 2026 LOC renewal?
- What's the minimum owner draw that keeps the company solvent?
- What's the break-even monthly revenue to sustain current operations?
Cross-Scenario SynthesisForecasting
S
🎯 Corrective Action Plan — Prioritized
Every finding from all six scenarios distilled into a single prioritized action plan. Organized by urgency: immediate (this week), short-term (30 days), medium-term (90 days), and long-term (6-12 months). Each action item has an owner, impact estimate, risk if not done, and estimated savings or recovery amount.
Using ALL scenario findings, build a prioritized corrective action plan for ACME Technology Solutions.
Organize by urgency:
IMMEDIATE (this week):
- Actions that prevent imminent harm (cash, collections, compliance)
SHORT-TERM (30 days):
- Actions that stabilize operations and stop the bleeding
MEDIUM-TERM (90 days):
- Actions that restructure for sustainability
LONG-TERM (6-12 months):
- Actions that position for growth
For each action item:
| Priority | Action | Owner | Impact | Risk if Not Done | Estimated Savings/Recovery |
End with:
- Total potential savings/recovery if all actions are implemented
- The single most important thing Patterson and Whitfield need to do tomorrow morning
- Honest assessment: is this company saveable without outside capital?
Cross-Scenario SynthesisAction Plan
S
🔍 Audit Readiness Assessment
If the IRS audits, if Ohio examines, if Huntington reviews the books for the LOC renewal — is ACME ready? This synthesis assesses readiness for each audit type, identifies what they'd ask for, what ACME can produce, what red flags they'd find, and the worst-case exposure for each issue.
Assess ACME Technology Solutions' readiness for a financial audit, tax audit (IRS or Ohio), or bank examination (Huntington LOC renewal).
For each audit type, identify:
1. What an auditor/examiner would ask for
2. Whether ACME can produce it from the available documents
3. Red flags the auditor would immediately identify
4. Exposure — what's the worst case if each issue is found?
Specific areas to assess:
- 1099 compliance (3 missing filings)
- Worker classification (Mike Reeves — former employee now 1099)
- Vehicle deduction documentation (incomplete mileage logs)
- Meals documentation (receipts and business purpose)
- Sales tax reconciliation ($180 variance)
- LOC covenant compliance (DSCR approaching minimum)
- A/R allowance adequacy ($3,200 on $127,840 with $47K at 90+ days)
- Related party transactions (owner draws, personal vehicle on business insurance)
Output:
1. Audit readiness matrix: Area | Ready? | Risk | Exposure | Fix Effort
2. Estimated total penalty/tax exposure across all issues
3. Priority fixes to complete BEFORE any audit or bank review
4. Honest assessment: if Huntington audits the books for the March 2026 LOC renewal, do they renew?
Cross-Scenario SynthesisAudit Prep
S
⚠️ Comprehensive Risk Matrix
Every risk identified across all six scenarios, scored by probability and impact, categorized (Financial, Compliance, Operational, Client, Market, Legal), with mitigation steps and cost to fix. Sorted by risk score descending. Includes the 3 existential risks and the 3 quick wins.
Build a comprehensive risk matrix for ACME Technology Solutions using findings from all scenarios.
For every risk identified across all analyses:
| Risk | Category | Probability | Impact | Risk Score | Mitigation | Cost to Fix |
Categories: Financial, Compliance, Operational, Client, Market, Legal
Probability: 1-5 (1=unlikely, 5=almost certain)
Impact: 1-5 (1=minor, 5=existential)
Risk Score: Probability × Impact
Sort by Risk Score descending.
Then provide:
1. Risk heat map summary: how many risks in each quadrant (high/high, high/low, low/high, low/low)
2. The 3 existential risks — things that could kill the company
3. The 3 quick wins — risks that can be eliminated fast and cheap
4. Total estimated exposure across all quantifiable risks
Cross-Scenario SynthesisRisk Assessment
Want to see this with your company's data?
Upload your financial documents and get the same level of analysis — customized to your business, your industry, your questions. What takes an accounting firm weeks, the platform delivers in minutes.