Bank Statement Import Categorise Reconcile

com.bestremotetools由 bestremotetools.com 發布v0.21.0更新於 Oct 24, 2026

Import a bank CSV, dedupe on re-import, categorise, summarise per currency and find subscriptions.

概覽

AI 產生的概覽

將銀行 CSV 匯入本機帳本,重複匯入自動去重,可分類交易、依幣別彙總並找出訂閱項目。

可以做什麼
讀取銀行匯出的 CSV 並存成本機帳本,自動辨識表頭列、日期、金額、幣別以及借方/貸方欄位,並解析檔案本身的數字格式與日期順序。它用日期、金額、幣別與描述的雜湊加上出現序號來避免重複匯入,依使用者規則為交易分類,並依幣別回報收入、支出與淨額。它也能找出週期性訂閱及其頻率與年化費用,把銀行扣款與另一個記帳工具中的收據對帳,並將某段期間匯出成 CSV 或 JSON。
適用情境
適合想在對話中檢視每月銀行交易、又不想使用會計軟體的情況:匯入匯出檔、分類支出、找出訂閱,以及檢查哪些扣款沒有對應收據。適用於希望資料留在本機的個人或小型企業記帳。
執行需求
以本機程序在使用者電腦上執行,僅支援桌面端。npm 套件尚未發布,需透過 .mcpb 一鍵安裝包,或複製原始碼並用 Node.js 建置。可選的 Pro 授權金鑰透過環境變數 MCP_LICENSE_KEY 提供,或呼叫 license_activate 啟用。不使用網路連線。
安裝前請注意
它會處理銀行對帳單資料,資料以純 JSON 檔案存放在本機資料目錄中,刪除該目錄即可重置。可選的 MCP_LICENSE_KEY 是離線驗證的付費 Pro 金鑰。匯出會寫入檔案,且可能覆蓋既有檔案(會回報)。分類規則會重新套用到已儲存的交易,設定分類會修改已儲存的資料。對帳功能只會讀取記帳帳本。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 Bank Statement Import Categorise Reconcile,將其新增到工作區。
  2. 為需要使用其工具的對話啟用該服務。

Desktop only,透過 STDIO。 STDIO 服務會啟動本機處理程序,因此需要 SourceWeft 桌面主機。

其他 MCP 客戶端

參照 儲存庫 中的啟動說明。

README

mcp-bank-statement

In the official MCP Registry (io.github.theluckystrike/bank-statement-csv-categorize-reconcile-ledger).

[bank-statement demo]

Export the CSV from your bank, say "import this", and the month is readable. This MCP server turns a bank export into a local ledger: it finds the header row under whatever preamble the bank prints above it, works out which column is the date, which is the money and which way the money went, and reads amounts in the file's own locale, so 1 234,56 from mBank and 1,234.56 from a US bank both become the same number. A debit is stored negative and a credit positive, once, at import, so nothing downstream has to guess. Re-importing the same export adds nothing: every line carries a hash of its date, amount, currency and description, with an occurrence index, so two identical coffees on one day stay two transactions while a second import of the same file stays zero. Your rules categorise transactions as they arrive, summaries report money in, money out and the net per currency and never mix currencies, recurring_detect finds the subscriptions and what each costs per year, and reconcile_expenses matches bank debits against the receipts in mcp-expense-tracker so you can see which debits have no receipt and which receipts never reached the bank. Everything is a plain JSON file on your own machine; nothing is uploaded anywhere.

Turn a bank CSV into a categorised, reconciled month in chat, no accounting SaaS required.

Bank profiles: Revolut, Wise, mBank, PKO BP, ING, N26, and a generic reader that works from the headers alone.

File shapes it reads without being asked: UTF-8 and UTF-16 (either byte order, as Excel on Windows saves it), CRLF, LF and CR-only line endings, quoted fields holding commas, quotes and newlines, 1.234,56 and 1,234.56, accounting parentheses (12.50) and a trailing minus 12.50- (both negative), and a mixture of currencies inside one file. A cell holding - or nothing is skipped and named in skipped_lines rather than read as zero. When the date column is ambiguous (03/04/2026 with no value above 12 anywhere), the assumed order is stated in the response instead of silently picking one.

60-second install

npm publish for @theluckystrike/mcp-bank-statement is pending. Until then, the .mcpb one-click bundle or a clone+build is the working path, both are verified below.

One-click (.mcpb): download bank-statement.mcpb from the latest release and double-click it in Claude Desktop: https://github.com/theluckystrike/mcp-servers/releases/latest

(claude_desktop_config.json):

json
{  "mcpServers": {    "bank-statement": {      "command": "npx",      "args": ["-y", "@theluckystrike/mcp-bank-statement"]    }  }}

Claude Code:

sh
claude mcp add bank-statement -- npx -y @theluckystrike/mcp-bank-statement

(.cursor/mcp.json):

json
{  "mcpServers": {    "bank-statement": {      "command": "npx",      "args": ["-y", "@theluckystrike/mcp-bank-statement"]    }  }}

The npx form above starts working the moment the package is published. Until then, use the .mcpb bundle above, or build from source with exactly these three commands:

sh
git clone https://github.com/theluckystrike/mcp-servers.git && cd mcp-serversnpm installnpm run build -w packages/mcp-license -w servers/spreadsheet -w servers/bank-statement

Then point your client's command at node with one arg: the absolute path to servers/bank-statement/dist/index.js.

To run in Pro mode set MCP_LICENSE_KEY in the same config block, or call license_activate once with your key.

Tools

ToolWhat it does
statement_importRead a bank CSV into the ledger. Detects the header row under any preamble, the date, description, amount (or debit and credit) and currency columns, the date order and the number locale. Reports what it detected, what it stored, how many lines were duplicates of what is already there, and every line it skipped with the reason
transactions_listList transactions in a date range, filtered by account, category or uncategorized, with totals per currency
transactions_searchFind transactions whose description, counterparty, category or account contains the query. Substring only, never a regex
category_rulesSet or list the rules that categorise transactions. An empty match is refused, because it would stamp one category on the whole ledger. A plain match is a case-insensitive substring; regex: true compiles the pattern only if it cannot backtrack exponentially, and (a+)+ is refused and used as a substring. Setting rules re-applies them to stored transactions
transaction_categorizeSet the category on transactions by id. Nothing changes unless every id exists
statement_summaryMoney in, money out and the net for a range, grouped by category, month, account or counterparty, always per currency
reconcile_expensesMatch bank debits against the receipts in mcp-expense-tracker: same currency, same amount, within a date window. Reports matches, bank lines with no receipt, and receipts that never reached the bank. The expense ledger is only ever read
recurring_detectFind subscriptions and recurring charges: the same counterparty, an amount that barely moves, a steady cadence. Reports the cadence, the typical amount, the next expected date and the annualised cost. Two charges are one interval, so the yearly cost is withheld (cadence_confirmed: false) until a third charge confirms it
statement_exportWrite a range to csv or json and return the path. Written atomically, so a failure never leaves a half file. Replacing an existing file is allowed and reported (overwrote_existing_file)
accounts_listThe imported accounts, with bank, currencies, transaction count, date range and last balance
license_statusShow free or Pro mode
license_activateActivate a Pro key (verified offline)

Resource bank://month returns this month's money in, money out and net, grouped by category, per currency. Prompt monthly_review drives the whole month-end pass: totals, uncategorised lines, subscriptions, reconciliation.

Free vs Pro

FreePro
Accounts2unlimited
History read backlast 12 monthsall of it
Category rules5unlimited
Import, list, search, summariseyesyes
reconcile_expensesyes, 31 days at a timeany date range
recurring_detectyes, last 3 months, 5 chargesfull history, every charge
statement_exportnoyes

Import always stores every row, whatever the tier: silently dropping lines on the way in would make the ledger disagree with the bank. The free limit is on what is read back.

Get Pro: https://mcp.zovo.one/buy/bank-statement, $19 one-time for this server, $39 for every server, lifetime. Keys are verified offline; nothing is sent anywhere.

Pairs with

  • mcp-expense-tracker, log the receipts and the mileage; reconcile_expenses reads that ledger and tells you which bank debits have no receipt behind them.
  • mcp-spreadsheet, this server parses your bank CSV with the spreadsheet server's own RFC 4180 reader and locale number parser, so 1 234,56 means the same thing in both. Use it to slice an exported range.
  • mcp-invoice, the income side: raise the invoice, then watch the payment land in statement_summary grouped by counterparty.

Privacy

Everything stays on your machine. Statements are parsed locally and stored in a plain JSON file under ${XDG_DATA_HOME:-~/.local/share}/mcp-servers/bank-statement/. The server makes no network calls at all, not for licensing, not for parsing, not for anything. Deleting that directory resets it.

Built by theluckystrike. Support: [email protected]

Use these docs as an MCP server

Any MCP client (Claude, Cursor, Windsurf, VS Code) can read this repository's documentation directly via GitMCP - no install:

來源:servers/bank-statement/README.md,提交 1bd9d69

工具

0
SourceWeft 尚未在沙箱中啟動過該軟體包,因此其工具未知。

版本歷史

1
  1. v0.21.0最新Sep 16, 2026

評分

已滿足適用檢查項的 50%

該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通25 分

    請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。

  • 已宣告認證方式10 分

    請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。

  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分