MCP App Store
by KeenEthics
Zovo AR Aging Report icon

Zovo AR Aging Report MCP Server for ChatGPT

By Zovo

Overview

Make an accounts receivable aging report from your open invoices and see who owes you money, without building a spreadsheet. Zovo AR Aging Report is an AR aging report template that fills itself in. Type or paste your open invoices, or attach a CSV or Excel export from QuickBooks, Xero, FreshBooks or Wave, and it ages each open balance as of the date you choose. Each balance goes into Current, 1-30, 31-60, 61-90 or over 90 days past due, counted from the due date (from the due date column, or from terms such as Net 30, Net 15, Net 30 EOM or Due on receipt). Totals per customer and the grand total are computed in cents and add up to the cent, with the percent of the total in each bucket. Partial payments and credit memos reduce balances; invoices paid in full are skipped and counted. Title lines, section headings and Total rows in accounting exports are left out and listed, and when the export has its own grand total, the result says whether the open items match it. Give credit sales for a period to get DSO (days sales outstanding). Downloads are a printable aging PDF (summary by customer plus detail), an Excel workbook (aging summary, open invoices, reminder emails, rows left out), a CSV, and one-page customer statements as a PDF with the open items, an aging strip and the balance due. Polite past-due reminder email drafts are written from the invoice facts only, ready for you to review and send. Good for small business owners, bookkeepers and office managers who chase unpaid invoices each week or close the month. It ages by days past the due date with fixed 30, 60 and 90 day edges and handles one currency per report. It does not connect to QuickBooks or Xero, send emails or collect payments. Generated files are deleted after 1 hour. Up to 5,000 open items per run.

How to connect

  1. ChatGPT: Open the Zovo AR Aging Report listing in the ChatGPT app directory and choose Connect. ChatGPT listing Zovo AR Aging Report exposes 2 tools here.

Tools

generate_aging_report

ChatGPT
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).

generate_customer_statements

ChatGPT
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).

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/zovo-ar-aging-report"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/zovo-ar-aging-report)