serenorg/cash-flow-statement
wellsfargo/cash-flow-statement/SKILL.md
Generate operating, investing, and financing cash flow statements from Wells Fargo transaction data stored in SerenDB.
$ install --global
skillsauthnpx skillsauth add serenorg/seren-skills cash-flow-statementInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 29, 2026, 9:10 AM20.6s9 files scanned
SKILL.md
- name:
- cash-flow-statement
- display-name:
- Wells Fargo Cash Flow
- description:
- Generate operating, investing, and financing cash flow statements from Wells Fargo transaction data stored in SerenDB.
Wells Fargo Cash Flow Statement
For Claude: How to Use This Skill
Skill instructions are preloaded in context when this skill is active. Do not perform filesystem searches or tool-driven exploration to rediscover them; use the guidance below directly.
When To Use
- Generate cash flow statements broken into Operating, Investing, and Financing activities.
- Track net cash position changes over configurable periods.
- Produce human-readable Markdown and machine-readable JSON reports.
- Persist cash flow snapshots into SerenDB for downstream analysis.
Prerequisites
- The
bank-statement-processingskill must have completed at least one successful run with SerenDB sync enabled. - SerenDB must contain populated
wf_transactionsandwf_txn_categoriestables.
Safety Profile
- Read-only against SerenDB source tables (
wf_transactions,wf_txn_categories). - Writes only to dedicated
wf_cashflow_*tables (never modifies upstream data). - No browser automation required.
- No credentials stored or transmitted.
- All amounts sourced from already-masked account data.
Workflow Summary
resolve_serendbconnects to SerenDB using the same resolution chain as bank-statement-processing.query_transactionsfetches categorized transactions for the requested date range.classify_activitiesmaps transaction categories to Operating, Investing, or Financing activities usingconfig/activity_map.json.build_statementaggregates activities into a cash flow statement.render_reportproduces Markdown and JSON output files.persist_statementupserts the cash flow snapshot into SerenDB.
Quick Start
- Install dependencies:
cd wellsfargo/cash-flow-statement
python3 -m pip install -r requirements.txt
cp .env.example .env
cp config.example.json config.json
- Generate a cash flow statement for the last 12 months:
python3 scripts/run.py --config config.json --months 12 --out artifacts/cash-flow-statement
- Generate a statement for a specific date range:
python3 scripts/run.py --config config.json --start 2025-01-01 --end 2025-12-31 --out artifacts/cash-flow-statement
Commands
# Last 12 months (default)
python3 scripts/run.py --config config.json --months 12 --out artifacts/cash-flow-statement
# Specific date range
python3 scripts/run.py --config config.json --start 2025-06-01 --end 2025-12-31 --out artifacts/cash-flow-statement
# Skip SerenDB persistence (local reports only)
python3 scripts/run.py --config config.json --months 12 --skip-persist --out artifacts/cash-flow-statement
Outputs
- Markdown report:
artifacts/cash-flow-statement/reports/<run_id>.md - JSON report:
artifacts/cash-flow-statement/reports/<run_id>.json - Activity export:
artifacts/cash-flow-statement/exports/<run_id>.activities.jsonl
SerenDB Tables
wf_cashflow_runs- cash flow statement generation runswf_cashflow_activities- individual activity line items per runwf_cashflow_snapshots- summary totals per run
Reusable Views
v_wf_cashflow_latest- most recent cash flow snapshotv_wf_cashflow_by_month- monthly cash flow breakdown by activity
Related Skills
serenorg/seren-bucks-affiliates
testing
VerifiedTrustedCommunity
Review-first outreach skill for the default Seren Bucks affiliate program. It bootstraps affiliate context via /programs/discover, mines sent-mail history and address books for candidates, persists them into a skill-owned CRM, proposes an editable daily top-10, drafts outbound and reply batches for approval, reconciles affiliate and reply signals, enforces hard DNC, and returns a manual daily digest.
5SKILL.mdUpdated May 6, 2026
serenorg/affiliates
data-ai
VerifiedTrustedCommunity
Lean partner-link distribution skill for the seren-affiliates publisher program portfolio. Operates one publisher program per run. Bootstraps the affiliate profile (registering on first run), caches joined programs in serendb, ingests contacts from a pasted list or from Gmail/Outlook address books, drafts a pitch once per run via seren-models for operator approval, sends approved copy through Gmail (preferred) or Microsoft Outlook, enforces per-program dedupe plus a global unsubscribe list, and reports local plus live conversion and commission stats from seren-affiliates.
5SKILL.mdUpdated May 6, 2026
serenorg/cap-call-notification-workflow
development
VerifiedTrustedCommunity
Family office: Process an incoming GP capital call notice end-to-end — confirm, fund, log, reconcile.
5SKILL.mdUpdated May 6, 2026
serenorg/seren-bounty
development
VerifiedTrustedCommunity
Work with Seren Bounty affiliate bounties: customers create and fund verifier-backed bounties; agents join to receive a referral_code and accrue earnings as qualifying events are verified; a release sweep pays matured earnings out of escrow.
5SKILL.mdUpdated Apr 29, 2026