Zovo AR Aging Report
Make an accounts receivable aging report from your open invoices and see who owes you money.
¿Debería usar esto?
Calidad y seguridad
Basado en el análisis automatizado de las definiciones de herramientas y el cumplimiento del protocolo.
Costo de contexto
Este es el número aproximado de tokens que se consumen cada vez que las herramientas del servidor se cargan en el contexto de un modelo. Los recuentos más altos reducen la atención disponible para otras tareas.
Instalar
Instalación con un clic
Agrega esto a tu archivo `claude_desktop_config.json`:
{
"mcpServers": {
"ar-aging": {
"url": "https://ar-aging.zovo.one/mcp"
}
}
}Puntos de conexión remotos
https://ar-aging.zovo.one/mcpstreamable-httpQué puede hacer
Inventario de herramientas
Herramientas (2)
🟢generate_aging_report(invoices, file, as_of_date, default_terms, currency, ...)
Use this when the user wants an accounts receivable aging report (AR aging report, aged receivables, 'who owes me money and how late', ar aging report template filled in) from open invoices typed in chat, pasted as CSV/TSV, or attached as a CSV/XLSX export from QuickBooks, Xero, FreshBooks or Wave. Buckets each open balance into Current, 1-30, 31-60, 61-90 and over 90 days past due as of a date (default today in New York), with per-customer and grand totals that add up to the cent, partial payments and credit memos, optional DSO from credit sales, polite past-due reminder email drafts from invoice facts, and aging PDF, Excel and CSV downloads. Does not connect to accounting software, send emails or collect payments. Do not use for accounts payable (bills you owe).
Esquema de entrada
{
"type": "object",
"properties": {
"invoices": {
"description": "Open invoices: an array of objects like {customer:\"Acme Corp\", invoice_number:\"INV-1042\", invoice_date:\"2026-08-01\", terms:\"Net 30\", amount:1200, amount_paid:200}, or pasted CSV/TSV text with a header row, or one line per invoice like \"Acme Corp, INV-1042, 2026-08-01, Net 30, 1200, paid 200\". Give this or file.",
"anyOf": [
{
"anyOf": [
{
"type": "array",
"items": {
"anyOf": [
{
"type": "object",
"properties": {
"customer": {
"description": "Customer name, e.g. \"Acme Corp\".",
"type": [
"string",
"null"
]
},
"invoice_number": {
"description": "Invoice number, e.g. \"INV-1042\".",
"type": [
"number",
"string",
"null"
]
},
"invoice_date": {
"description": "Invoice date, e.g. \"2026-08-01\" or \"Aug 1 2026\".",
"type": [
"string",
"null"
]
},
"due_date": {
"description": "Due date, e.g. \"2026-08-31\". Leave out to use terms.",
"type": [
"string",
"null"
]
},
"terms": {
"description": "Payment terms, e.g. \"Net 30\", \"Net 15\", \"Due on receipt\".",
"type": [
"number",
"string",
"null"
]
},
"amount": {
"description": "Invoice total, e.g. 1200 or \"$1,200.00\". Negative for a credit memo.",
"type": [
"number",
"string",
"null"
]
},
"amount_paid": {
"description": "Amount already paid on this invoice, e.g. 200. Default 0.",
"type": [
"number",
"string",
"null"
]
},
"balance": {
"description": "Open balance if known, e.g. 1000. Used instead of amount minus paid.",
"type": [
"number",
"string",
"null"
]
},
"email": {
"description": "Customer billing email for the reminder, e.g. [email protected].",
"type": [
"string",
"null"
]
}
},
"additionalProperties": {}
},
{
"type": "string"
},
{
"type": "null"
}
]
}
},
{
"type": "string"
}
]
},
{
"type": "null"
}
]
},
"file": {
"type": "object",
"properties": {
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
},
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"mime_type": {
"description": "Media type if known, e.g. application/pdf.",
"type": "string"
},
"file_name": {
"description": "Original file name if known, e.g. statement.pdf.",
"type": "string"
}
},
"required": [
"download_url",
"file_id"
],
"description": "An open invoices or A/R aging export (CSV, TSV or XLSX) from QuickBooks, Xero, FreshBooks, Wave or a spreadsheet, e.g. open_invoices.csv."
},
"as_of_date": {
"description": "Age the invoices as of this date, e.g. \"2026-10-31\". Default today in New York time.",
"anyOf": [
{
"type": "string",
"maxLength": 40
},
{
"type": "null"
}
]
},
"default_terms": {
"description": "Terms for invoices with no due date and no terms, e.g. \"Net 30\" (default) or 15.",
"type": [
"number",
"string",
"null"
]
},
"currency": {
"description": "Currency code, e.g. \"USD\" (default), \"CAD\", \"EUR\". With a mixed-currency file, only this currency is aged.",
"anyOf": [
{
"type": "string",
"maxLength": 12
},
{
"type": "null"
}
]
},
"company_name": {
"description": "Your business name for the report header and email sign-off, e.g. \"Bright Path Design LLC\".",
"anyOf": [
{
"type": "string",
"maxLength": 120
},
{
"type": "null"
}
]
},
"credit_sales": {
"description": "Credit sales for the period, to compute DSO, e.g. 240000 or \"$240,000\".",
"type": [
"number",
"string",
"null"
]
},
"sales_period_days": {
"description": "Days in the credit sales period for DSO, e.g. 365 (default), 90, \"quarter\", \"month\".",
"type": [
"number",
"string",
"null"
]
},
"sender_name": {
"description": "Name to sign the reminder emails with, e.g. \"Dana Lee\". Default the company name.",
"anyOf": [
{
"type": "string",
"maxLength": 80
},
{
"type": "null"
}
]
}
},
"$schema": "http://json-schema.org/draft-07/schema#"
}Esquema de salida
{
"type": "object",
"properties": {
"kind": {
"type": "string"
},
"as_of_date": {
"type": "string"
},
"as_of_note": {
"type": "string"
},
"currency": {
"type": "string"
},
"totals": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"buckets": {
"type": "array",
"items": {}
},
"customers": {
"type": "array",
"items": {}
},
"customers_not_shown": {
"type": "number"
},
"dso": {},
"reminders": {
"type": "array",
"items": {}
},
"reminders_total": {
"type": "number"
},
"file_total_check": {
"type": [
"string",
"null"
]
},
"input": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"assumptions": {
"type": "array",
"items": {
"type": "string"
}
},
"pdf_pages": {
"type": "number"
},
"downloads": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "string"
}
}
},
"required": [
"kind",
"as_of_date",
"as_of_note",
"currency",
"totals",
"buckets",
"customers",
"customers_not_shown",
"dso",
"reminders",
"reminders_total",
"file_total_check",
"input",
"assumptions",
"pdf_pages",
"downloads"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}🟢generate_customer_statements(invoices, file, as_of_date, default_terms, currency, ...)
Use this when the user wants customer statements (customer statement template, statement of account, open item statement) for customers who owe them money, from the same open invoices: typed, pasted CSV/TSV, or an attached CSV/XLSX export. Returns a PDF with one page per customer listing each open invoice with date, due date, amount, paid, open balance and days past due, an aging strip and the balance due, plus polite past-due reminder email drafts. Filter by customer names or overdue_only. Does not send statements or emails, and does not build an aging summary (use generate_aging_report).
Esquema de entrada
{
"type": "object",
"properties": {
"invoices": {
"description": "Open invoices: an array of objects like {customer:\"Acme Corp\", invoice_number:\"INV-1042\", invoice_date:\"2026-08-01\", terms:\"Net 30\", amount:1200, amount_paid:200}, or pasted CSV/TSV text with a header row, or one line per invoice like \"Acme Corp, INV-1042, 2026-08-01, Net 30, 1200, paid 200\". Give this or file.",
"anyOf": [
{
"anyOf": [
{
"type": "array",
"items": {
"anyOf": [
{
"type": "object",
"properties": {
"customer": {
"description": "Customer name, e.g. \"Acme Corp\".",
"type": [
"string",
"null"
]
},
"invoice_number": {
"description": "Invoice number, e.g. \"INV-1042\".",
"type": [
"number",
"string",
"null"
]
},
"invoice_date": {
"description": "Invoice date, e.g. \"2026-08-01\" or \"Aug 1 2026\".",
"type": [
"string",
"null"
]
},
"due_date": {
"description": "Due date, e.g. \"2026-08-31\". Leave out to use terms.",
"type": [
"string",
"null"
]
},
"terms": {
"description": "Payment terms, e.g. \"Net 30\", \"Net 15\", \"Due on receipt\".",
"type": [
"number",
"string",
"null"
]
},
"amount": {
"description": "Invoice total, e.g. 1200 or \"$1,200.00\". Negative for a credit memo.",
"type": [
"number",
"string",
"null"
]
},
"amount_paid": {
"description": "Amount already paid on this invoice, e.g. 200. Default 0.",
"type": [
"number",
"string",
"null"
]
},
"balance": {
"description": "Open balance if known, e.g. 1000. Used instead of amount minus paid.",
"type": [
"number",
"string",
"null"
]
},
"email": {
"description": "Customer billing email for the reminder, e.g. [email protected].",
"type": [
"string",
"null"
]
}
},
"additionalProperties": {}
},
{
"type": "string"
},
{
"type": "null"
}
]
}
},
{
"type": "string"
}
]
},
{
"type": "null"
}
]
},
"file": {
"type": "object",
"properties": {
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
},
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"mime_type": {
"description": "Media type if known, e.g. application/pdf.",
"type": "string"
},
"file_name": {
"description": "Original file name if known, e.g. statement.pdf.",
"type": "string"
}
},
"required": [
"download_url",
"file_id"
],
"description": "An open invoices or A/R aging export (CSV, TSV or XLSX) from QuickBooks, Xero, FreshBooks, Wave or a spreadsheet, e.g. open_invoices.csv."
},
"as_of_date": {
"description": "Age the invoices as of this date, e.g. \"2026-10-31\". Default today in New York time.",
"anyOf": [
{
"type": "string",
"maxLength": 40
},
{
"type": "null"
}
]
},
"default_terms": {
"description": "Terms for invoices with no due date and no terms, e.g. \"Net 30\" (default) or 15.",
"type": [
"number",
"string",
"null"
]
},
"currency": {
"description": "Currency code, e.g. \"USD\" (default), \"CAD\", \"EUR\". With a mixed-currency file, only this currency is aged.",
"anyOf": [
{
"type": "string",
"maxLength": 12
},
{
"type": "null"
}
]
},
"company_name": {
"description": "Your business name for the report header and email sign-off, e.g. \"Bright Path Design LLC\".",
"anyOf": [
{
"type": "string",
"maxLength": 120
},
{
"type": "null"
}
]
},
"customers": {
"description": "Only these customers, e.g. [\"Acme Corp\", \"Globex\"] or \"Acme Corp, Globex\". Default every customer with a balance.",
"anyOf": [
{
"anyOf": [
{
"type": "array",
"items": {
"type": "string"
}
},
{
"type": "string"
}
]
},
{
"type": "null"
}
]
},
"overdue_only": {
"description": "true to make statements only for customers with past-due invoices. Default false.",
"type": [
"boolean",
"string",
"null"
]
},
"company_address": {
"description": "Your address or contact lines for the statement header, e.g. \"12 Main St, Austin TX 78701, [email protected]\".",
"anyOf": [
{
"type": "string",
"maxLength": 300
},
{
"type": "null"
}
]
},
"remit_to": {
"description": "Payment instructions printed on each statement, e.g. \"ACH or check to Bright Path Design, 12 Main St\".",
"anyOf": [
{
"type": "string",
"maxLength": 200
},
{
"type": "null"
}
]
},
"message": {
"description": "Short note printed on every statement, e.g. \"Thank you for your business.\"",
"anyOf": [
{
"type": "string",
"maxLength": 240
},
{
"type": "null"
}
]
},
"sender_name": {
"description": "Name to sign the reminder emails with, e.g. \"Dana Lee\".",
"anyOf": [
{
"type": "string",
"maxLength": 80
},
{
"type": "null"
}
]
}
},
"$schema": "http://json-schema.org/draft-07/schema#"
}Esquema de salida
{
"type": "object",
"properties": {
"kind": {
"type": "string"
},
"as_of_date": {
"type": "string"
},
"as_of_note": {
"type": "string"
},
"currency": {
"type": "string"
},
"statements": {
"type": "array",
"items": {}
},
"statements_count": {
"type": "number"
},
"statements_not_listed": {
"type": "number"
},
"pages": {
"type": "number"
},
"totals": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"reminders": {
"type": "array",
"items": {}
},
"reminders_total": {
"type": "number"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"input": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"downloads": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "string"
}
}
},
"required": [
"kind",
"as_of_date",
"as_of_note",
"currency",
"statements",
"statements_count",
"statements_not_listed",
"pages",
"totals",
"reminders",
"reminders_total",
"notes",
"input",
"downloads"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}Comunidad
Evidencia