analyze_journal_variance
MCP /mcp
Compare two periods of journal-entry data (QBO or Xero — source auto-detected from headers) and flag accounts whose movement deviates materially between periods. Aggregates lines per account into a net total for each period, then surfaces accounts where the period-over-period change crosses a materiality threshold (≥5% relative AND ≥$100 absolute; severity high at ≥50%, medium at ≥20%, low at ≥5%). Inputs are two CSV exports — periodACsv (earlier period) and periodBCsv (later period). Optional periodALabel / periodBLabel for human-readable flag messages (e.g. "Q1 FY2024" vs "Q2 FY2024"). Max 5,000 rows per period; max 5 MB each. Use this when a user pastes two periods and asks "what changed?", "show me variances", "what jumped period-over-period". Returns a flag list ordered by largest delta, a roll-up, and a shareable URL. Both periods must be the same source — mixing QBO + Xero in one call returns an error.
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_journal_variance",
"arguments": {}
}
}
Fill arguments using the input schema below.Complete published contract
{
"inputSchema": {
"type": "object",
"properties": {
"periodACsv": {
"type": "string",
"minLength": 1,
"maxLength": 5242880,
"description": "Raw CSV text of the EARLIER period's journal-entry export (QBO Journal Entries or Xero Manual Journals). Source is auto-detected from the headers."
},
"periodBCsv": {
"type": "string",
"minLength": 1,
"maxLength": 5242880,
"description": "Raw CSV text of the LATER period's journal-entry export. Source is auto-detected from the headers (must match periodACsv)."
},
"periodALabel": {
"type": "string",
"maxLength": 80,
"description": "Optional human label for the earlier period — e.g. \"Q1 FY2024\". Used in flag messages."
},
"periodBLabel": {
"type": "string",
"maxLength": 80,
"description": "Optional human label for the later period — e.g. \"Q2 FY2024\"."
}
},
"required": [
"periodACsv",
"periodBCsv"
],
"additionalProperties": false,
"$schema": "http://json-schema.org/draft-07/schema#"
},
"call": {
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "analyze_journal_variance",
"arguments": {}
}
}
}