MCP App Store
by KeenEthics
Tallyproof Bank Statements icon

Tallyproof Bank Statements

By Zovo

Get New App Alerts

Overview

Turn a bank or credit card statement into a spreadsheet of transactions and check that it balances to the cent. Attach a bank or credit card statement (a text PDF from your bank's website, or its CSV or Excel export) and Tallyproof Bank Statements extracts each transaction: date, description, signed amount (money out negative), running balance when printed, and a suggested category. The key step is reconciliation. It finds the opening and closing balance on the statement and checks opening + money in - money out = closing to the cent. You see PASS, or the difference in dollars and cents and the rows to look at: where the running balance breaks, a likely missing deposit or withdrawal, a duplicated row, or a reversed sign. Deposit and withdrawal totals are compared with the statement's own totals. It handles real statement layouts: one signed amount column, separate withdrawal and deposit columns, separate deposit and withdrawal sections, CR/DR suffixes, negatives in parentheses, thousands separators, multi-page statements with repeated headers, descriptions that wrap onto a second line, and dates without a year (placed inside the statement period, including December to January). Bank CSV and Excel exports are cleaned into the same format, newest-first or not. Downloads: an Excel workbook (transactions, reconciliation, totals by month and by category), a clean CSV, and a QuickBooks-ready CSV (Date, Description, Amount). You can also paste or list transactions to reconcile them or total money in and out by month and category. Good for bookkeepers, freelancers and small businesses doing monthly books or taxes, and anyone preparing statements for a loan application. Limitations: text PDFs only (scanned or photographed statements need OCR first); up to 60 pages and 20,000 transactions per file. Account numbers are masked to the last 4 digits. Files are read once and downloads expire after about an hour. Categories are keyword suggestions, not accounting or tax advice.

Tools

convert_bank_statement

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

summarize_transactions

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

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps