cashflow

Call this tool to read a bank CSV into the local ledger. Columns detected from headers (date, description, amount, currency, balance); amounts use the file's locale; stored lines skipped. Returns detected/stored/skipped.

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "maxLength": 4096,
      "description": "Name of a statement uploaded with bank_upload"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Name for this account, e.g. \"business EUR\". Default: the file name without its extension. Later imports of the same account are deduplicated against it"
    },
    "bank": {
      "type": "string",
      "enum": [
        "auto",
        "revolut",
        "wise",
        "mbank",
        "pko",
        "ing",
        "n26",
        "generic"
      ],
      "description": "Bank profile. Default \"auto\": the headers decide. \"generic\" skips profile detection and uses the header heuristics alone"
    },
    "overwrite": {
      "type": "boolean",
      "description": "Delete every transaction already stored for this account before importing, instead of merging. Use it when the bank reissued a corrected export"
    },
    "currency": {
      "type": "string",
      "pattern": "^[A-Za-z]{3}$",
      "description": "Currency for rows where the file names none. Defaults to the shared business profile's default_currency, else EUR; the response says which it used"
    }
  },
  "required": [
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

List stored transactions in a date range, optionally for one account or category, or only the ones no rule has categorised yet. Totals are reported per currency and never added across currencies.

{
  "type": "object",
  "properties": {
    "from": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date YYYY-MM-DD, inclusive. Default: the start of the current month"
    },
    "to": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date YYYY-MM-DD, inclusive. Default: today"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Limit to one account, as named at import"
    },
    "category": {
      "type": "string",
      "maxLength": 500,
      "description": "Only transactions in this category"
    },
    "uncategorized": {
      "type": "boolean",
      "description": "Only transactions with no category yet"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 1000,
      "description": "Rows returned, default 200. Totals always cover the whole range"
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Find transactions whose description, counterparty, category or account contains the query. Case-insensitive substring search, never a regex, so a query with brackets in it cannot hang the server.

{
  "type": "object",
  "properties": {
    "query": {
      "type": "string",
      "maxLength": 200,
      "description": "Text to look for, e.g. \"spotify\" or \"acme\""
    },
    "from": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "to": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 500,
      "description": "Rows returned, default 100"
    }
  },
  "required": [
    "query"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Read the category rules, or pass rules to REPLACE the whole list. A plain match is a substring; a regex compiles only if it cannot backtrack exponentially. An empty match is refused. Free: 5 rules.

{
  "type": "object",
  "properties": {
    "rules": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "match": {
            "type": "string",
            "maxLength": 200,
            "description": "Text to look for in the counterparty or description, e.g. \"spotify\""
          },
          "category": {
            "type": "string",
            "maxLength": 120,
            "description": "Category to set, e.g. \"software\""
          },
          "regex": {
            "type": "boolean",
            "description": "Treat match as a regular expression. A pattern that can backtrack exponentially is refused and used as a substring instead"
          }
        },
        "required": [
          "match",
          "category"
        ],
        "additionalProperties": false
      },
      "description": "The complete rule list; it replaces the stored one. Omit to list the current rules"
    },
    "reapply_all": {
      "type": "boolean",
      "description": "Also overwrite categories set by an earlier rule or by hand. Default false: only uncategorised transactions are touched"
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Set or clear the category on transactions by id, for a one-off no rule is worth writing for. Every id is checked first, so one unknown id refuses the whole call. category_rules matches by text instead.

{
  "type": "object",
  "properties": {
    "ids": {
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 64
      },
      "minItems": 1,
      "description": "Transaction ids, as returned by transactions_list or transactions_search"
    },
    "category": {
      "type": "string",
      "maxLength": 120,
      "description": "Category to set. Pass an empty string to clear it"
    }
  },
  "required": [
    "ids",
    "category"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

What was spent/received in a date range per the BANK ACCOUNT, grouped by category, month, account or counterparty. For "what did I spend in August" once imported. Totals are per currency, never summed or converted.

{
  "type": "object",
  "properties": {
    "from": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive. Default: the start of the current month"
    },
    "to": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive. Default: today"
    },
    "group_by": {
      "type": "string",
      "enum": [
        "category",
        "month",
        "account",
        "counterparty"
      ],
      "description": "Default category"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Limit the summary to one account"
    },
    "top": {
      "type": "integer",
      "minimum": 1,
      "maximum": 200,
      "description": "Groups returned per currency, largest net first. Default 25"
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Match bank debits against mcp-expense-tracker entries: same currency and amount, date within a few days. Reports matches, unmatched bank lines, expenses never hitting the bank. Read-only. Free: 31 days; Pro: any range.

{
  "type": "object",
  "properties": {
    "from": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "to": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Limit to one bank account"
    },
    "window_days": {
      "type": "integer",
      "minimum": 0,
      "maximum": 31,
      "description": "Allowed gap between the expense date and the bank date, default 3. A card payment usually settles a day or two after the receipt"
    }
  },
  "required": [
    "from",
    "to"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Find charges that come back: debits grouped by counterparty and currency with a steady amount and interval, with cadence, typical amount, next due date and annual cost. Free: 3 months, 5 charges.

{
  "type": "object",
  "properties": {
    "months": {
      "type": "integer",
      "minimum": 1,
      "maximum": 60,
      "description": "How far back to look, default 3. Two occurrences are enough to see a cadence, three make it certain"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Limit to one account"
    },
    "min_occurrences": {
      "type": "integer",
      "minimum": 2,
      "maximum": 24,
      "description": "Occurrences required before a charge counts as recurring, default 2"
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Export the BANK transactions of a date range (a month, a quarter, a year) as .csv or .json and return a download link valid for one hour. This is the tool for "export September" once a statement has been imported. Nothing partial is ever written.

{
  "type": "object",
  "properties": {
    "from": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "to": {
      "type": "string",
      "maxLength": 10,
      "description": "ISO date, inclusive"
    },
    "format": {
      "type": "string",
      "enum": [
        "csv",
        "json"
      ],
      "description": "csv for a spreadsheet, json for a program"
    },
    "path": {
      "type": "string",
      "maxLength": 4096,
      "description": "Name for the downloaded file, e.g. september. It comes back as a download link valid for one hour"
    },
    "account": {
      "type": "string",
      "maxLength": 120,
      "description": "Limit to one account"
    },
    "category": {
      "type": "string",
      "maxLength": 500,
      "description": "Limit to one category"
    }
  },
  "required": [
    "from",
    "to",
    "format",
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

List the imported accounts: bank, currencies, transaction count, first and last date, and the closing balance when the file carried one. Start here for the account names transactions_list and statement_export take.

{
  "type": "object",
  "properties": {},
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Report this endpoint's licence state for your token as JSON: the product, the tier free or pro, why it is not Pro, and the checkout URL. Call it to explain a free-tier refusal. No arguments, nothing changes.

{
  "type": "object",
  "properties": {},
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Turn Pro on for this connection with key, an MCPL1.<payload>.<signature> issued at checkout for this server or the bundle. Data under your token stays; a wrong or expired key changes nothing. license_status confirms it.

{
  "type": "object",
  "properties": {
    "key": {
      "type": "string",
      "description": "License key from checkout, MCPL1.<payload>.<signature>"
    }
  },
  "required": [
    "key"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Send a bank export to this hosted endpoint. There is no filesystem here, so instead of a path you upload the file once with bank_upload and then pass its name as `path` to statement_import. Give exactly one of content (the export as text, header row included - this is the normal case for a CSV), content_base64 (the file's bytes, which keeps a UTF-16 export from Excel readable) or url. url: fetch a public file instead of pasting base64 (recommended above about 10 KB): the url is fetched here with a 10 second timeout, at most 3 redirects, public http(s) hosts only, and a 1 MB cap; the fetched file has to be delimited text, so a PDF statement is refused rather than stored. Uploads are kept for your token between calls; bank_files lists them and bank_delete_upload removes one. The request body cap is 256 KB, so a large export pasted as text has to be split by month.

{
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 70,
      "description": "Name to refer to this statement by: 1-64 characters of letters, digits, underscore or dash, e.g. \"september\""
    },
    "content": {
      "type": "string",
      "description": "The export as text, including the header row"
    },
    "content_base64": {
      "type": "string",
      "description": "The file's bytes, base64-encoded, instead of text"
    },
    "url": {
      "type": "string",
      "description": "url: fetch a public file instead of pasting base64 (recommended above about 10 KB). Public http(s) only; private, link-local and this endpoint's own zone are refused"
    }
  },
  "required": [
    "name"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

List the statement files stored for your token, with their sizes.

{
  "type": "object",
  "properties": {},
  "$schema": "http://json-schema.org/draft-07/schema#"
}

Delete one statement file stored for your token. The transactions already imported from it are kept; transactions_list and the summary still see them.

{
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 70
    }
  },
  "required": [
    "name"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}