analyze_xero_journal_cleanup
MCP /mcp
Scan a Xero "Manual Journals" CSV export for cleanup issues — unbalanced journals, duplicate journals (same date + same totals), and schema problems (invalid dates, malformed amounts, missing account code/name, missing group key). Input is the raw CSV content the user pastes after exporting from Xero via Accounting → Advanced → Manual Journals → Export. Xero-specific idioms handled: signed Amount column (positive = credit, negative = debit), explicit Debit/Credit fallback shape, Reference-or-Narration+Date grouping, account code preferred over name. Max 5,000 rows; max 5 MB. Returns structured flags with severity, a roll-up summary, parse diagnostics, and a shareable URL at agents.hellobooks.ai/r/{slug}. Use this when a user pastes Xero manual-journal data, asks "check my Xero books", or "find issues in my Xero journal". The funnel CTA routes to /migrate/from-xero for users who want to fix at scale.
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_xero_journal_cleanup",
"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 Xero \"Manual Journals\" report. Export from Xero: Accounting → Advanced → Manual Journals → Export. Paste the file contents directly."
},
"fileName": {
"type": "string",
"maxLength": 200,
"description": "Optional original filename, used only as a label on the share page."
}
},
"required": [
"csvText"
],
"additionalProperties": false,
"$schema": "http://json-schema.org/draft-07/schema#"
},
"call": {
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "analyze_xero_journal_cleanup",
"arguments": {}
}
}
}