Agent♥︎Age
Catalog

io.github.theluckystrike/bank-statement-csv-categorize-reconcile-ledger

Official15 toolsLive

by theluckystrike · JavaScript

Import a bank CSV, categorise it, summarise it per currency and reconcile it against your expenses.

MCP Bank Statement CSV Categorize & Reconcile Ledger

This MCP server imports a bank-export CSV, locates the header row even when it appears after a bank-specific preamble, and determines which columns represent the date and the money direction. It reads amounts using the file’s locale so values like 1 234,56 and 1,234.56 are normalized, then stores debits as negative and credits as positive.

🛠️ Key Features

  • Import bank CSV exports
  • Detect header row under arbitrary preamble text
  • Identify the date column and the money/amount column(s)
  • Parse amounts in the CSV’s own locale
  • Normalize transaction sign (debit negative, credit positive)
  • Summarize per currency and reconcile against expenses

🚀 Use Cases

  • Turn a monthly bank CSV export into a readable local ledger
  • Categorize transactions from different bank formats
  • Reconcile bank activity against an existing expense set

⚡ Developer Benefits

  • Consistent numeric representation after import
  • Less downstream logic required because sign is applied once
  • Handles locale differences between mBank and US-style exports

⚠️ Limitations

  • Limited to CSV bank exports as described in the readme excerpt

Topics

claudecursorinvoicemcpmcp-servermodel-context-protocolspreadsheetaccountingai-toolsbookkeepingclaude-desktopfreelanceinvoicinglocal-firstmcp-serverspdfself-hostedtime-trackingvatproductivity