Skip to main content
Glama

InvoiceSnap

Build a receipt spreadsheet

build_receipt_spreadsheet

Turn receipts you have read into an Excel (.xlsx), CSV, Xero or QuickBooks import file, with VAT split into one column per rate. Returns totals per currency and VAT rate, warnings where net + VAT doesn't match the total, and a download link valid for 24 hours. Up to 200 receipts per call.

Input Schema

NameRequiredDescriptionDefault
formatNoxlsx (Excel), csv, xero (bank statement CSV) or quickbooks (bank upload CSV)xlsx
csvStyleNoFor csv only: standard = comma-separated with dot decimals; european = semicolons with comma decimals (Excel in most EU countries)standard
receiptsYesThe receipts you have read, one entry per receipt (1 to 200). Copy amounts as printed; never guess a VAT rate
totalsCurrencyNoAlso convert every total to this currency at the ECB rate of the receipt date, e.g. EUR
includeLineItemsNoxlsx: add a Line items sheet; csv: one row per line item

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed4 schema fields changed
    • addedInput schema / properties / receipts / description
      Added value: +"The receipts you have read, one entry per receipt (1 to 200). Copy amounts as printed; never guess a VAT rate"
    • addedInput schema / properties / receipts / items / properties / lineItems / description
      Added value: +"The receipt's lines, if you need them in the file (see includeLineItems). Leave out otherwise"
    • addedInput schema / properties / receipts / items / properties / lineItems / items / properties / description / description
      Added value: +"The line as printed, e.g. Cappuccino"
    • addedInput schema / properties / receipts / items / properties / lineItems / items / properties / qty / description
      Added value: +"Quantity; 1 if the receipt shows none"
  2. First observed

TDQS

A4.4/5.0
Behavior5/5

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

With no output schema, the description carries the return-value burden and does so well: it discloses totals per currency and VAT rate, data-quality warnings (net + VAT mismatch), and a 24-hour download link expiry. It also states a hard capacity limit of 200 receipts per call, information not derivable from 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.

Conciseness5/5

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

Three dense sentences: capability first, then what comes back including the warning and link expiry, then the capacity limit. Every clause carries operational information with no filler.

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

Completeness4/5

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

For a file-generation tool with five parameters, 100% schema coverage and no output schema, the description covers output contents, validity window and limits. The only minor gap is not clarifying whether earlier generated files remain accessible or how errors on invalid receipt data are surfaced.

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 parameter meaning is already fully documented; the description adds only the VAT-per-column output behavior and the 200-receipt cap (which mirrors the schema's maxItems). Baseline 3 is appropriate given the schema does the heavy lifting.

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

Purpose5/5

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

The description states a specific verb and artifact ('turn receipts ... into an Excel, CSV, Xero or QuickBooks import file') and adds concrete processing detail (VAT split per rate). It clearly distinguishes the tool from scan_receipts_on_website (reading receipts) and convert_currency (a separate conversion step), since it consumes already-read receipts.

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?

The phrase 'receipts you have read' establishes the precondition that receipts must already be extracted, which implicitly routes the agent to VAD/scan-style tools first. It does not explicitly name siblings or state when not to use it, but the context for use is clear.

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