cash-flow-statement

Generate cash flow statements from Wells Fargo transaction data in SerenDB.

2|Updated Feb 25, 2026
One-click install
npx skills add https://github.com/terraleiloa/seren-skills --skill cash-flow-statement
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: cash-flow-statement
Source: https://github.com/terraleiloa/seren-skills/tree/main/wellsfargo/cash-flow-statement
Command: npx skills add https://github.com/terraleiloa/seren-skills --skill cash-flow-statement

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg[binary], python-dateutil, and includes scripts (resource) components.

What problem does it solve?

Wells Fargo transaction data in SerenDB is hard to summarize into clear operating, investing, and financing cash flow statements without manual aggregation and categorization.

Core Features & Use Cases

  • Generates cash flow statements: Computes Operating, Investing, and Financing sections from categorized Wells Fargo transactions.
  • Produces both human and machine outputs: Writes Markdown and JSON reports plus a JSONL export of activity line items.
  • Persists results to SerenDB: Stores run, activity line items, and snapshots in dedicated wf_cashflow_* tables without modifying source data.
  • Example use case: Use it to summarize the last 12 months of cash movement so you can track net cash change by activity section over time.

Quick Start

Ask the agent to generate a cash flow statement for the last 12 months using the Wells Fargo transactions already stored in SerenDB, persisting the results for downstream analysis.

Frequently Asked Questions about cash-flow-statement

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a cash flow statement from Wells Fargo transaction data?

To generate a cash flow statement from Wells Fargo transaction data, the Skill classifies transactions stored in SerenDB into operating, investing, and financing activities, then aggregates inflows and outflows into net totals. It outputs Markdown and JSON reports plus JSONL activity exports.

Can I create cash flow reports for specific date ranges using SerenDB transactions?

Yes, you can create cash flow reports for specific date ranges using SerenDB transactions by configuring the reporting period via months or explicit start and end dates. The tool then computes the operating, investing, and financing sections for that specified timeframe.

Do I need to categorize Wells Fargo transactions before generating a cash flow statement?

Yes, you need categorized Wells Fargo transactions before generating a cash flow statement. The Skill requires a populated SerenDB containing both wf_transactions and wf_txn_categories tables to accurately classify transactions into cash flow activity sections.

Does generating a cash flow statement modify the original Wells Fargo transaction data in SerenDB?

Generating a cash flow statement does not modify the original Wells Fargo transaction data in SerenDB. The Skill only reads from source tables and writes its run results, activity line items, and snapshots to dedicated wf_cashflow_* tables.

How are operating, investing, and financing activities calculated from bank transactions?

Operating, investing, and financing activities are calculated by reading an activity map configuration that classifies categorized bank transactions into specific sections. The system then aggregates the inflows and outflows within each section to produce net totals.

What is the best way to track net cash change by activity section over time?

The best way to track net cash change by activity section over time is to generate cash flow statements across configurable date ranges and persist the results. The tool stores run histories and snapshots in SerenDB for downstream historical analysis.