analyze_profit_loss
MCP /mcp
Take a Profit & Loss / Income Statement CSV export from QuickBooks Online, Xero, Zoho Books, or Wave (source auto-detected from section names) and run three checks: (1) pnl.subtotal_mismatch — each "Total Section" subtotal equals the sum of its preceding line items (catches missing or duplicated rows); (2) pnl.negative_expense — flags expense-section line items with negative amounts (usually sign-flips or refunds posted to the wrong side); (3) pnl.margin_red_flag — gross-profit margin < 5% or > 95%, or negative total revenue. Input is raw CSV text of a P&L report (Reports → Profit and Loss in QBO / Xero / Zoho / Wave). Max 5,000 rows; max 5 MB. Returns flags with severity, a summary with totalRevenue / totalCogs / grossProfit / grossMarginPct / netIncome (when detected), and a shareable URL at agents.hellobooks.ai/r/{slug}. Use this when a user pastes a P&L and asks "does my P&L look right?", "any sign errors?", "what is my gross margin?", or "anything suspicious in my income statement?". For period-over-period comparison use analyze_journal_variance with two periods of journal-entry data; this tool is single-period only.
No account required
Request example
Connect your client to https://agents.hellobooks.ai/mcp, then call:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "analyze_profit_loss",
"arguments": {}
}
}
Fill arguments using the input schema below.Complete published contract
{
"inputSchema": {
"type": "object",
"properties": {
"csvText": {
"type": "string",
"minLength": 1,
"maxLength": 5242880,
"description": "Raw CSV text of a Profit & Loss / Income Statement report. Works with QuickBooks Online (Reports → Profit and Loss), Xero (Reports → Profit and Loss), Zoho Books (Reports → Profit & Loss), and Wave (Reports → Profit & Loss). Source is auto-detected from section names. Statement should include section headers, line items, \"Total X\" subtotals, and a Net Income / Net Profit row at the bottom."
},
"fileName": {
"type": "string",
"maxLength": 200,
"description": "Optional filename for the share-page label."
}
},
"required": [
"csvText"
],
"additionalProperties": false,
"$schema": "http://json-schema.org/draft-07/schema#"
},
"call": {
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "analyze_profit_loss",
"arguments": {}
}
}
}