Skip to main content
Glama

Zovo Bank Reconciliation

Explain reconciliation difference

explain_reconciliation_difference

Use this when the user attaches the bank file and the books file, gives the bank statement ending balance and the book balance, and asks why the bank reconciliation does not balance: "why is my bank reconciliation off", "reconciliation difference", "find the difference between bank and books". Runs the same matching, computes adjusted bank vs adjusted book balance, and finds the smallest set of listed items (up to 4) whose amounts account for the difference, plus checks for a reversed sign, a transposition (difference divisible by 9) and a row with that same amount. Returns the same Excel and PDF downloads. Does not change any file and cannot find items that are missing from both files. Supports up to 20,000 rows per file; CSV and text tables have a 2,000,000-cell limit (including empty cells). Each call saves new Excel and PDF files on the plugin server for 1 hour (private download links), then deletes them.

Input Schema

NameRequiredDescriptionDefault
bank_fileYesThe bank side: the bank's CSV or Excel (.xlsx) transaction export, or a text PDF bank statement, e.g. bank-september.csv.
books_fileYesThe book side: the cash/bank account register or general ledger export from accounting software or a spreadsheet (CSV or .xlsx), e.g. books-september.xlsx.
books_signNoSign of the books file amounts: auto (default) flips only when the amounts clearly match the bank with the opposite sign; as_written keeps them; flip reverses them. Example: auto.
date_orderNoOrder of numeric dates in both files: MDY (US, 09/02/2026) or DMY (02/09/2026). Detected per file when a day is above 12; US is assumed otherwise.
period_endNoStatement / period end date YYYY-MM-DD, e.g. 2026-09-30. Default: the statement end on a PDF, else the month end of the last book entry (capped by the bank file).
bank_columnsNoOptional column names for the bank file when auto-detection picks the wrong column, e.g. {"date":"Post Date","amount":"Amount"}.
books_columnsNoOptional column names for the books file, e.g. {"date":"Date","debit":"Debit","credit":"Credit","check_no":"Num"}.
max_group_sizeNoMost rows combined when one deposit equals several book entries (or the reverse), e.g. 4 (default).
check_clear_daysNoDays a check may take to clear and still match by amount, e.g. 60 (default). Matches by check number allow the same span.
date_window_daysNoDays a bank posting may differ from the book date and still match the same amount, e.g. 5 (default).
bank_ending_balanceYesEnding balance on the bank statement at period end, in dollars, e.g. 48210.55.
book_ending_balanceYesCash account balance in the books at period end, in dollars, e.g. 51022.10.

Output Schema

NameRequiredDescriptionDefault
modeYes
noteYes
filesYes
countsYes
statusYesPASS only when both ending balances are known and the difference is $0.00; BALANCES_NEEDED = activity explained, balances needed.
warningsYes
downloadsYes
period_endYes
explanationYes
top_bank_onlyYes
top_book_onlyYes
reconciliationYes
bank_only_by_classYes
book_only_by_classYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Adds substantial context beyond the annotations: the run is non-destructive to the source files ('Does not change any file'), it writes new Excel and PDF artifacts to the plugin server with private links that expire after one hour, and it discloses scale limits (20,000 rows per file; 2,000,000 cells for CSV/text). This also explains why readOnlyHint=false despite no mutation of user data, so there is no contradiction with the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loaded with the 'Use this when...' trigger and example utterances, then flows into behavior, limits, and side effects. It is one dense run-on paragraph and a few clauses could be split, but nearly every sentence carries information an agent would otherwise have to guess.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 12-parameter, nested-object tool with an output schema, the description covers the missing pieces: what the analysis does, what artifacts come back ('the same Excel and PDF downloads'), retention and privacy of those downloads, and explicit failure boundaries. An agent can decide to call it and predict the effects without opening the schema.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so every parameter, including the sign, date-order, and column-mapping objects, is already documented in the schema. The description adds only a little interpretive detail (the up-to-4 item set maps loosely to max_group_size, and 'divisible by 9' explains the transposition check), so the baseline of 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

Names a specific verb and resource (explain why the bank reconciliation is off) and spells out the mechanics: rerun the matching, compute adjusted bank vs adjusted book balances, and isolate the smallest set of items (up to 4) that explains the difference. It implicitly ties itself to the sibling reconcile_bank_to_books ('Runs the same matching') but never states plainly that the sibling performs the reconciliation while this one only diagnoses the gap.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives a concrete trigger condition (user attaches bank and books files, supplies both ending balances, and asks why the reconciliation does not balance) along with literal user phrasings. It also states what the tool cannot do (find items missing from both files) and its row/cell limits, but does not say when to reach for reconcile_bank_to_books instead.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources