Skip to main content

Polars-first financial statement Sankey visualization library

Project description

FinFlow Sankey

Polars-first financial statement Sankey visualization library.

Features

  • Polars-first: Native support for pl.DataFrame and pl.LazyFrame
  • Accounting-aware validation: Period/currency checks, reconciliation validation
  • Role-based color palette: Revenue, costs, profit, cash flow each have distinct colors
  • Customizable themes: default, monochrome, colorblind-safe, minimal, dark, plus custom YAML palettes
  • Runtime palette override: Change colors via dict or YAML without modifying source
  • Account mapping: Map raw account names to standard sections via dict or YAML
  • Consistent line styles: Link widths proportional to values, but stroke widths uniform
  • Node layout: Level-based horizontal positioning, including reconciliation side-by-side view
  • Rich hover metadata: Original accounts, validation status, period, currency
  • HTML export: One-line export helper
  • Multi-period comparison: Compare two periods in a single Sankey
  • Plotly renderer: Returns plotly.graph_objects.Figure for Jupyter, Streamlit, Dash, HTML export

Quickstart

import polars as pl
from finflow_sankey import FinancialSankey

df = pl.DataFrame({
    "account": ["Revenue", "Cost of Revenue", "Operating Expenses", "Tax", "Net Income"],
    "value": [100_000_000.0, -40_000_000.0, -30_000_000.0, -10_000_000.0, 20_000_000.0],
    "period": ["FY2025"] * 5,
    "currency": ["USD"] * 5,
    "statement": ["income_statement"] * 5,
    "section": ["revenue", "cost_of_revenue", "operating_expenses", "tax", "profit"],
})

fig = (
    FinancialSankey
    .income_statement(df, period="FY2025", currency="USD")
    .validate()
    .render(title="FY2025 Income Statement Flow")
)

fig.show()

Cash Flow Statement

df = pl.DataFrame({
    "account": [
        "Beginning Cash",
        "Operating Cash Flow",
        "Investing Cash Flow",
        "Financing Cash Flow",
        "FX Effect",
        "Ending Cash",
    ],
    "value": [50_000_000.0, 25_000_000.0, -10_000_000.0, -5_000_000.0, 2_000_000.0, 62_000_000.0],
    "period": ["FY2025"] * 6,
    "currency": ["USD"] * 6,
    "statement": ["cash_flow_statement"] * 6,
    "section": [
        "beginning_cash",
        "operating_cash_flow",
        "investing_cash_flow",
        "financing_cash_flow",
        "fx_effect",
        "ending_cash",
    ],
})

fig = (
    FinancialSankey
    .cash_flow_statement(df, period="FY2025", currency="USD")
    .validate()
    .render(title="FY2025 Cash Flow Bridge")
)

Balance Sheet Reconciliation

df = pl.DataFrame({
    "account": [
        "Current Assets",
        "Non-current Assets",
        "Current Liabilities",
        "Non-current Liabilities",
        "Equity",
    ],
    "value": [60_000_000.0, 40_000_000.0, 30_000_000.0, 20_000_000.0, 50_000_000.0],
    "period": ["2025-12-31"] * 5,
    "currency": ["USD"] * 5,
    "statement": ["balance_sheet"] * 5,
    "section": [
        "current_asset",
        "non_current_asset",
        "current_liability",
        "non_current_liability",
        "equity",
    ],
})

fig = (
    FinancialSankey
    .balance_sheet_reconciliation(df, as_of="2025-12-31", currency="USD")
    .validate()
    .render(title="Balance Sheet Reconciliation")
)

Multi-Period Comparison

df = pl.DataFrame({
    "account": ["Revenue", "Revenue", "Operating Expenses", "Operating Expenses"],
    "value": [100_000_000.0, 120_000_000.0, -40_000_000.0, -50_000_000.0],
    "period": ["FY2024", "FY2025", "FY2024", "FY2025"],
    "currency": ["USD"] * 4,
    "statement": ["income_statement"] * 4,
    "section": ["revenue", "revenue", "expense", "expense"],
})

fig = (
    FinancialSankey
    .multi_period_compare(df, currency="USD")
    .validate()
    .render(title="FY2024 vs FY2025")
)

Account Mapping

Map raw account names to standard sections via dict or YAML:

mapping = {
    "revenue": ["Net Sales", "Sales Revenue"],
    "cost_of_revenue": ["COGS", "Cost of Goods Sold"],
    "operating_expenses": ["SG&A", "R&D"],
    "tax": ["Income Tax Expense"],
    "profit": ["Net Income"],
}

fig = FinancialSankey.income_statement(df, mapping=mapping).validate().render()

Themes & Palettes

# Built-in theme
fig = FinancialSankey.income_statement(df).validate().render(theme="colorblind_safe")

# Dark mode
fig = FinancialSankey.income_statement(df).validate().render(theme="dark")

# Custom YAML palette
fig = FinancialSankey.income_statement(df).validate().render(palette="./my_palette.yaml")

# Runtime dict override
fig = FinancialSankey.income_statement(df).validate().render(
    palette={"revenue": "#0055FF", "profit": "#00AA55"}
)

HTML Export

(
    FinancialSankey
    .income_statement(df)
    .validate()
    .export_html("income_statement.html", title="FY2025 Income Statement")
)

Installation

pip install finflow-sankey

Development

pip install -e ".[dev]"

Development

python -m pytest tests/ -v
ruff check finflow_sankey tests

Project Structure

finflow_sankey/
  core/           # schema, validation, normalization, graph, palette, mapper
  templates/      # income_statement, cash_flow, balance_sheet, multi_period
  renderers/      # plotly renderer
  palettes/       # YAML color palettes
  mappings/       # YAML account mappings
  examples/       # usage examples
tests/            # pytest suite

License

MIT

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

finflow_sankey-0.1.12.tar.gz (27.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

finflow_sankey-0.1.12-py3-none-any.whl (33.3 kB view details)

Uploaded Python 3

File details

Details for the file finflow_sankey-0.1.12.tar.gz.

File metadata

  • Download URL: finflow_sankey-0.1.12.tar.gz
  • Upload date:
  • Size: 27.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for finflow_sankey-0.1.12.tar.gz
Algorithm Hash digest
SHA256 76db8000a92fef80b1ed17cf8bf6217401dcd332feca1c48afb78374df2dd6d4
MD5 e6f0b5f7dde6372c1e2738de4ccbc33a
BLAKE2b-256 9ad7ab750a1263e135f686efa41954d14bcf3a4e89b86fe66302db1048ce49c1

See more details on using hashes here.

Provenance

The following attestation bundles were made for finflow_sankey-0.1.12.tar.gz:

Publisher: publish.yml on min9lin9/finflow-sankey

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file finflow_sankey-0.1.12-py3-none-any.whl.

File metadata

  • Download URL: finflow_sankey-0.1.12-py3-none-any.whl
  • Upload date:
  • Size: 33.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for finflow_sankey-0.1.12-py3-none-any.whl
Algorithm Hash digest
SHA256 544bbf52f1b305f88d2492eca34528fd59ca9922106a328fe02b0bee53f5d94c
MD5 69af066678ecf716f9e1c330d8a64ad5
BLAKE2b-256 0621ed80c954290c31064776ac984f6f04df299f72d7f84dde0bb6b9fae5846e

See more details on using hashes here.

Provenance

The following attestation bundles were made for finflow_sankey-0.1.12-py3-none-any.whl:

Publisher: publish.yml on min9lin9/finflow-sankey

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page