MCP App Store
by KeenEthics
Zovo Bank Reconciliation icon

Zovo Bank Reconciliation MCP Server for ChatGPT

By Zovo

Overview

Reconcile a bank account against your books and see which items do not match. Attach the bank's transaction export (CSV or Excel, or a text PDF statement) and the cash account register or general ledger export from accounting software or a spreadsheet. Zovo Bank Reconciliation matches the two sides and lists the unmatched rows on both sides, each with a reason. Matching runs in clear steps: check number and amount, then the same amount on the same date, then the same amount within a date window (5 days by default; checks can take longer to clear), then one bank deposit that equals several book entries (or one book entry that equals several bank rows), with a bounded search. When an amount appears more than once, the closest date wins, then the closer description, then file order, and the result says so. Unmatched rows are classified: outstanding checks, outstanding payments, deposits in transit, bank fees, interest, NSF or returned items, automatic payments not yet in the books, checks the books do not have, likely duplicate entries, and likely amount typos (transposed digits, one wrong digit, a reversed sign, a decimal slip, or a check number with a different amount). Items that cross the period end are shown as timing differences. The reconciliation uses the standard format: balance per bank plus deposits in transit minus outstanding checks, against balance per books plus bank-only items and corrections. The result is PASS only when the difference is zero to the cent. PASS needs both the statement ending balance and the book balance. Without them the result is "Activity explained, balances needed": the unmatched items are listed, but the reconciliation is not proven. The same file twice is refused. Files with little overlap are refused unless both ending balances are given or read from the files; with both balances, they are reconciled so you can review the unmatched items. If it does not balance, it looks for the smallest set of items that accounts for the difference. Downloads: an Excel workbook (Matched, Bank only, Book only, Suggested adjustments, Summary) and a PDF reconciliation statement. Good for bookkeepers, accountants and small-business owners doing the monthly bank reconciliation. Limitations: text PDFs only for bank statements (scans need OCR first); up to 20,000 rows per file; CSV and text tables have a 2,000,000-cell limit, including empty cells. Account numbers are masked. Files are read once and downloads expire after about an hour. Suggested adjustments are for review, not accounting advice.

How to connect

  1. ChatGPT: Open the Zovo Bank Reconciliation listing in the ChatGPT app directory and choose Connect. ChatGPT listing Zovo Bank Reconciliation exposes 2 tools here.

Tools

explain_reconciliation_difference

ChatGPT
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 does not 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.

reconcile_bank_to_books

ChatGPT
Use this when the user attaches a bank export or statement AND their books (cash account register or general ledger export from accounting software or a spreadsheet) and wants a bank reconciliation: "reconcile my bank statement", "reconcile bank statement against my books", "list what doesn't match", "find outstanding checks and deposits in transit", "match bank transactions to the ledger". Matches rows by check number, amount and date (with a date window), and sums (one deposit = several invoices); lists all unmatched rows on both sides with a classification (outstanding check, deposit in transit, bank fee, interest, NSF, likely duplicate, likely amount typo); builds adjusted bank vs adjusted book balance (PASS only at $0.00); returns an Excel workbook and a PDF reconciliation statement. Does not connect to bank accounts or accounting software, does not post entries, and is not for a single statement without books (use a statement converter for that). 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.

Capabilities

WritesInteractive

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-bank-reconciliation"><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-bank-reconciliation)