A
licenseA
qualityD
maintenanceConverts PDF bank statements into structured data (Markdown, JSON, CSV, JSONL) with verified transactions and balance checks, enabling agents to audit numbers.
5
5 npm
MIT
Tallyproof Bank Statements
Server Details
Bank statement to spreadsheet
If you are the author of this connector, you can claim ownership by verifying the domain or GitHub account it belongs to. Claimed connector authors can inspect health checks, view analytics, and manage their listing.
- Status
- Healthy
- Last Tested
- Transport
- Streamable HTTP · MCP 2025-11-25
- URL
TDQS
Score is being calculated.
Available Tools
2 toolsconvert_bank_statementConvert bank statementRead-onlyInspect
Use this when the user attaches a bank or credit card statement (text PDF, or the bank's CSV/Excel export) and wants it converted to Excel or CSV: "convert bank statement to excel", "bank statement pdf to csv", "import my statement into QuickBooks", "does my statement balance". Extracts each transaction (date, description, signed amount, running balance), reconciles opening + transactions = closing to the cent, points to missing or duplicated rows, suggests categories, and returns Excel, CSV and QuickBooks CSV downloads. Does not read scanned images (needs OCR first), does not connect to bank accounts, and is not for non-financial PDFs or general PDF editing.
ParametersJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | The statement to convert: a text PDF downloaded from the bank or card website, or the bank's CSV or Excel (.xlsx) transaction export, e.g. september-statement.pdf. | |
| date_order | No | Order of numeric dates in a CSV/Excel export: MDY (US, 09/02/2026, default) or DMY (02/09/2026). Detected automatically when a day is above 12. | |
| flip_signs | No | Only for CSV/Excel exports that list purchases as positive and payments as negative (common in credit card exports): true flips each amount so money out is negative. Default false. | |
| account_type | No | auto (default): a PDF is classified from its text; pasted rows and CSV/Excel exports count as bank unless the balances or the sign pattern show a credit card (the result says so). bank: checking or savings. credit_card: charges are money out and the statement shows a previous and new balance owed. Example: credit_card. | |
| statement_year | No | Closing year of the statement, used for dates printed without a year when the period is not on the file, e.g. 2026 (a December-January statement uses the January year). | |
| closing_balance | No | Closing (ending or new) balance in dollars, e.g. 5034.47. Used with opening_balance to prove the total to the cent. | |
| opening_balance | No | Opening (beginning or previous) balance in dollars, e.g. 4123.55. Only needed when the file has none, such as a CSV export without a balance column, or to override. |
Output Schema
ParametersJSON Schema
| Name | Required | Description |
|---|---|---|
| note | Yes | |
| months | Yes | |
| period | Yes | |
| source | Yes | |
| account | Yes | |
| preview | Yes | |
| warnings | Yes | |
| downloads | Yes | |
| categories | Yes | Suggested categories from keyword rules; review before filing. |
| transactions | Yes | |
| reconciliation | Yes |
summarize_transactionsSummarize transactionsRead-onlyInspect
Use this when the user pastes or lists bank or credit card transactions (date, description, amount) and wants them reconciled, totaled by month or category, or exported: "does my statement balance", "money in and out by month", "categorize these transactions", "make a QuickBooks CSV from these". Checks opening + transactions = closing to the cent and the running balance row by row, points to the rows that break it, suggests categories, and returns Excel, CSV and QuickBooks CSV downloads. Do not use when a statement file is attached (use convert_bank_statement); does not give tax or accounting advice.
ParametersJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account_type | No | auto (default): a PDF is classified from its text; pasted rows and CSV/Excel exports count as bank unless the balances or the sign pattern show a credit card (the result says so). bank: checking or savings. credit_card: charges are money out and the statement shows a previous and new balance owed. Example: credit_card. | |
| transactions | Yes | The transactions in statement order, e.g. [{"date":"2026-09-02","description":"PAYROLL ACME INC","amount":2450}, {"date":"2026-09-03","description":"GREENLEAF MARKET","amount":-82.17}]. | |
| statement_year | No | Closing year of the statement, used for dates printed without a year when the period is not on the file, e.g. 2026 (a December-January statement uses the January year). | |
| closing_balance | No | Closing (ending or new) balance in dollars, e.g. 5034.47. Used with opening_balance to prove the total to the cent. | |
| opening_balance | No | Opening (beginning or previous) balance in dollars, e.g. 4123.55. Only needed when the file has none, such as a CSV export without a balance column, or to override. |
Output Schema
ParametersJSON Schema
| Name | Required | Description |
|---|---|---|
| note | Yes | |
| months | Yes | |
| period | Yes | |
| source | Yes | |
| account | Yes | |
| preview | Yes | |
| warnings | Yes | |
| downloads | Yes | |
| categories | Yes | Suggested categories from keyword rules; review before filing. |
| transactions | Yes | |
| reconciliation | Yes |
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
2 tool updates
- First observed
convert_bank_statement - First observed
summarize_transactions
Related MCP Connectors
Convert PDF bank statements into Excel and check that the balances add up. Invoices and tables too.
Convert bank statement PDFs to Excel, CSV, OFX or QBO, every row checked against the balances.
Bank statement PDFs become CSV or JSON transactions with dates, amounts and balances.
Turn bank statement PDFs into categorized, balance-checked transactions and reports.
Related MCP Servers
- AlicenseAqualityCmaintenanceEnables AI assistants such as Claude, Cursor and VS Code to turn PDF bank statements into structured transactions or import-ready CSV, OFX, QFX, QBO and Xero CSV files. Handles password-protected, scanned and multi-page statements, returning the data or saving the converted file next to the original PDF.5MIT
- AlicenseNot gradedqualityAmaintenanceParse crypto exchange CSVs (Coinbase, Binance, Kraken, +11 more) and bank statement PDFs (Chase, BofA, +11 more) into Koinly, TurboTax, CoinLedger, or ZenLedger formats. Free tier: 25 files/month, no credit card required.0ISC
- AlicenseAqualityCmaintenanceConverts customer-supplied PDF bank statements into checked Excel, CSV, or JSON with balance validation. Runs locally with your own MainBook API key or against MainBook's hosted endpoint, and it never connects to bank accounts.5MIT
Try in Browser
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd
Glama MCP Gateway
Add one secure layer between your agents and this server.