Communitygithub.com

cogitopeter/bank-flow-report

A Claude Code skill that turns a bank statement (Excel/CSV) into an interactive analysis website + chart view + full text report

What is bank-flow-report?

The bank-flow-report skill is a specialized tool for Claude Code that automatically analyzes bank statement data (in Excel or CSV format) and generates a comprehensive financial analysis report. It produces an interactive HTML website with dynamic chart views and a full text report, making it easy to visualize and understand transaction patterns, income and expense trends, and account balances over time. This skill is useful for developers, financial analysts, or anyone who needs to quickly transform raw banking data into a clear, shareable, and visually appealing financial summary. It supports Claude Code on any platform and relies on standard Python libraries (pandas, plotly, etc.) to parse data and create the output.

Works with✓Claude Code~Codex CLI~Cursor
npx skills add cogitopeter/bank-flow-report

Ask in your favorite AI

Open a new chat with this agent skill pre-loaded.

Documentation

What does bank-flow-report do?

Bank Statement Financial Analysis Report Generator · A Claude Code skill that turns a bank statement (Excel/CSV) into an interactive analysis website + chart view + full text report

Overview

This skill automatically reads a bank statement file (Excel or CSV), analyzes the transactions, and generates:

  • An interactive HTML page with charts (income, expenses, balance trends)
  • A full text report summarizing key financial metrics

Usage

Ask Claude Code to analyze a bank statement file. For example:

Analyze this bank statement

Claude will prompt you to specify the file path if not provided.

Requirements

  • Python 3.8+
  • pandas
  • plotly
  • openpyxl (for Excel files)

Install dependencies with:

pip install pandas plotly openpyxl

Supported Platforms

  • Claude Code (desktop, CLI, or any platform)

How It Works

  1. Claude reads the bank statement file using pandas.
  2. It cleans and aggregates the data (by month, category, etc.).
  3. It generates an interactive Plotly chart (HTML file).
  4. It produces a markdown text report with key metrics (total income, expenses, net balance, etc.).

Example Output

  • bank_flow_report.html - Interactive chart
  • bank_flow_report.md - Full text report

Related Skills