Agent♥︎Age
Catalog

com.bestremotetools/bank-statement-import-categorise-reconcile

Official

by theluckystrike · JavaScript

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

MCP Server: com.bestremotetools/bank-statement-import-categorise-reconcile

This Model Context Protocol (MCP) server imports a bank CSV, locates the header row despite any bank preamble, and determines the date column plus the money column and direction (debit/credit). It reads amounts in the file’s locale, dedupes on re-import, categorises transactions, and produces summaries per currency, including subscription identification.

🛠️ Key Features

  • Import bank CSV exports and convert them into a local ledger
  • Detect the header row under preamble text
  • Infer date column, money column, and whether funds are debit or credit
  • Parse amounts using the CSV’s locale formats
  • Store debits as negative and credits as positive during import
  • Dedupe on re-import
  • Categorise, summarise per currency, and find subscriptions

🚀 Use Cases

  • Turn bank statement CSV exports into a readable, local month ledger
  • Maintain consistent bookkeeping across banks with different number formats
  • Track and categorise transactions and identify subscriptions from statements

⚡ Developer Benefits

  • Helps normalize varying CSV formats (e.g., 1 234,56 vs 1,234.56) into a single numeric representation
  • Ensures consistent signed amounts (debits negative, credits positive) at import time
  • Enables downstream work without requiring reprocessing for currency summaries or categories

⚠️ Limitations

  • Relies on bank-export CSV structure where a header row exists beneath any preamble printed above it

Topics

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