Financial Analytics Pro

Automate financial analysis, integrate with banks and software, generate reports, forecast cash flow, and analyze investments for businesses and professionals.

Security Scan

The skill's description promises bank/accounting integrations and many components, but the package lacks the listed files, does not declare or request the credentials those integrations would need, and contains mismatches between the documented CLI and the shipped code — these inconsistencies warrant caution.

Purpose & Capability

SKILL.md promises integrations with Plaid, QuickBooks, Xero, Shopify, exchanges, etc., and lists many scripts/templates that would require API keys and a fuller codebase. The actual package only includes a single analysis script, example CSV, and references; there are no declared environment variables, no integration code present, and no homepage/source. Requiring heavy external integrations in the description but not requesting any credentials or providing the corresponding code is disproportionate and inconsistent.

Instruction Scope

The runtime instructions and examples describe a CLI (/financial) and many features (bank connections, report generation, exports) but the provided SKILL.md gives no concrete steps for connecting bank/accounting APIs or where credentials should come from. The included Python script operates on local CSV/Excel files and writes reports/plots — it does not appear to implement remote integrations. The instructions are broad and grant the agent leeway to 'integrate' with external services without specifying which env vars or endpoints to use.

Install Mechanism

There is no install spec (instruction-only skill). SKILL.md lists a pip dependency line including plaid-python and python-dotenv, but there is no automated installer. This is moderate risk because installation is manual: users might be instructed to pip-install packages that enable remote integrations, but the package itself won't install them automatically.

Credentials

The skill promises bank and accounting integrations (which normally require API keys/tokens) but declares no required environment variables or primary credential. That mismatch is worrying: either the skill is incomplete, or it expects the agent/user to supply sensitive credentials later without clear guidance. The pip line includes python-dotenv (commonly used to load env secrets), increasing the chance the skill will ask for or consume secrets, yet none are declared up-front.

Persistence & Privilege

The skill does not request always:true, does not declare privileged config paths, and is user-invocable only. It does not appear to modify other skills or system-wide settings from the provided artifacts. This aspect is within expected bounds.

What to consider before installing

This skill contains contradictory documentation: it advertises bank/accounting integrations and many helper files but only ships a single local-analysis Python script and no declared API keys or install script. Before installing or supplying credentials: 1) Ask the publisher for the full source, a homepage, and an explicit list of required environment variables and where credentials are stored. 2) Verify which files actually implement Plaid/QuickBooks/etc integrations and inspect them for endpoints and credential handling. 3) Do not provide bank or accounting API keys until you confirm how and where they're used/stored; prefer per-service limited-scope keys. 4) If you want to test, run the code in a sandboxed environment with dummy data first. 5) If the skill is paid ($99), request payment/ licensing details and confirm the publisher identity before sharing sensitive data. These inconsistencies could be benign (incomplete packaging) but could also lead to accidental credential exposure if the agent prompts for keys later — proceed cautiously.

Description

A premium skill ($99) for financial professionals, business owners, and analysts to automate financial analysis, generate insights, and create professional financial reports. Integrates with banking APIs, accounting software, and financial data sources for comprehensive financial intelligence.

Target Audience

• Small Business Owners
• Financial Analysts
• Accountants & Bookkeepers
• E-commerce Entrepreneurs (Shopify, Etsy, KDP)
• Investors & Traders
• Startup Founders

Core Features

1. Financial Data Integration

• Bank API Connections: Connect to Plaid, Yodlee, or direct bank APIs
• Accounting Software: QuickBooks, Xero, FreshBooks integration
• E-commerce Platforms: Shopify, Etsy, Amazon KDP, WooCommerce
• Investment Accounts: Brokerage, crypto, retirement accounts
• Manual Data Import: CSV, Excel, Google Sheets import

2. Financial Statement Analysis

• Income Statement Analysis: Revenue trends, expense categorization, profit margins
• Balance Sheet Analysis: Asset management, liability tracking, equity changes
• Cash Flow Analysis: Operating, investing, financing cash flows
• Ratio Analysis: Liquidity, profitability, efficiency, solvency ratios
• Trend Analysis: Year-over-year, quarter-over-quarter comparisons

3. Business Performance Metrics

• Revenue Analytics: Sales trends, customer lifetime value, churn rate
• Cost Analysis: Fixed vs variable costs, cost optimization opportunities
• Profitability Metrics: Gross margin, net margin, ROI calculations
• Cash Flow Forecasting: 30/60/90 day cash flow projections
• Break-Even Analysis: Calculate break-even points for products/services

4. Investment & Portfolio Analysis

• Portfolio Performance: Returns, volatility, Sharpe ratio calculations
• Risk Assessment: Value at Risk (VaR), maximum drawdown analysis
• Asset Allocation: Portfolio diversification analysis
• Investment Screening: Fundamental analysis screening criteria
• Tax Optimization: Tax-loss harvesting, capital gains planning

5. Financial Reporting & Visualization

• Automated Financial Reports: Income statements, balance sheets, cash flow statements
• Executive Dashboards: Key financial metrics at a glance
• Interactive Charts: Revenue trends, expense breakdowns, profit margins
• Export Formats: PDF, Excel, HTML, PowerPoint
• Regulatory Compliance: GAAP/IFRS compliant reporting templates

6. Forecasting & Scenario Planning

• Financial Forecasting: Revenue, expenses, cash flow projections
• Scenario Analysis: Best-case, worst-case, base-case scenarios
• Sensitivity Analysis: Impact of variable changes on financials
• Budget vs Actual: Variance analysis and explanations
• What-If Analysis: Model business decisions and their financial impact

Technical Implementation

Dependencies

pip install pandas numpy matplotlib seaborn plotly scipy scikit-learn yfinance plaid-python python-dotenv

Core Python Libraries

• pandas: Financial data manipulation and analysis
• numpy: Numerical computing for financial calculations
• matplotlib/seaborn/plotly: Financial visualization
• yfinance: Yahoo Finance API for market data
• plaid-python: Bank account integration (optional)
• scipy: Statistical analysis for risk metrics
• scikit-learn: Machine learning for forecasting

File Structure

financial-analytics-pro/
├── SKILL.md
├── scripts/
│   ├── financial_integration.py
│   ├── statement_analyzer.py
│   ├── performance_metrics.py
│   ├── investment_analyzer.py
│   ├── report_generator.py
│   └── forecasting_engine.py
├── templates/
│   ├── income_statement_template.html
│   ├── balance_sheet_template.html
│   ├── cash_flow_template.html
│   ├── executive_dashboard.html
│   └── investor_presentation.pptx
├── examples/
│   ├── sample_financials.csv
│   ├── ecommerce_analysis.ipynb
│   ├── portfolio_analysis.ipynb
│   └── sample_report.pdf
└── references/
    ├── financial_ratios_cheat_sheet.md
    ├── gaap_ifrs_comparison.md
    ├── ecommerce_metrics_guide.md
    └── api_integration_guide.md

Usage Examples

1. Basic Financial Analysis

# Analyze income statement from CSV
/financial analyze income_statement.csv --output analysis_report.html

# Generate balance sheet insights
/financial balance balance_sheet.csv --ratios --trends

# Cash flow analysis and forecasting
/financial cashflow cash_flow.csv --forecast 90

2. Business Performance

# Calculate key business metrics
/financial metrics sales_data.csv --period monthly --kpi revenue,gross_margin,clv

# E-commerce performance analysis
/financial ecommerce shopify_export.csv --platform shopify --metrics aov,conversion_rate,lifetime_value

# Cost optimization analysis
/financial optimize expenses.csv --categories --savings

3. Investment Analysis

# Portfolio performance analysis
/financial portfolio holdings.csv --benchmark SPY --risk --returns

# Stock fundamental analysis
/financial analyze-stock AAPL --financials --ratios --valuation

# Crypto portfolio tracking
/financial crypto portfolio.json --exchanges binance,coinbase --performance

4. Reporting & Visualization

# Generate comprehensive financial report
/financial report all_statements.csv --template executive --output annual_report.pdf

# Create interactive financial dashboard
/financial dashboard financial_data.json --interactive --output dashboard.html

# Export to Excel with formulas
/financial export data.csv --format excel --formulas --output financial_model.xlsx

5. Forecasting & Planning

# 12-month financial forecast
/financial forecast historical.csv --period 12 --scenarios 3 --output forecast.pdf

# Scenario planning for business decisions
/financial scenario base_case.csv --variables "revenue_growth=0.15,cost_reduction=0.10"

# Break-even analysis for new product
/financial breakeven product_costs.csv --price 99 --volume 1000

Value Proposition

For Small Business Owners

• Financial Clarity: Understand business performance without accounting degree
• Time Savings: Automate 80% of financial analysis and reporting
• Better Decisions: Data-driven insights for pricing, hiring, investment
• Investor Ready: Professional financials for fundraising
• Cash Flow Management: Avoid surprises with accurate forecasting

For E-commerce Entrepreneurs

• Platform Integration: Direct Shopify/Etsy/KDP data import
• Product Profitability: Calculate true profit margins per product
• Customer Analytics: Lifetime value, acquisition cost, retention rates
• Inventory Optimization: Cash tied up in inventory analysis
• Marketing ROI: Track advertising spend effectiveness

For Financial Professionals

• Automated Analysis: Reduce manual data crunching time
• Standardized Reports: Consistent formatting and calculations
• Client Presentations: Professional reports and dashboards
• Regulatory Compliance: Built-in GAAP/IFRS compliance checks
• Scalability: Handle multiple clients efficiently

Pricing Strategy

• Premium Skill: $99 one-time purchase
• Target: 10M+ small businesses, e-commerce sellers, freelancers
• ROI: Pays for itself in first month through time savings and insights
• Upsell Potential:
  • Team version: $299 (5 users)
  • Enterprise: $999 (unlimited users + API access)
  • White-label: $2,499 (reseller rights)

Competitive Analysis

Advantages Over Existing Solutions

1. OpenClaw Integration: AI-powered financial insights and recommendations
2. Multi-Platform: Works with banking, accounting, e-commerce data
3. Affordable: $99 vs $1000+/month for similar enterprise tools
4. No Coding Required: Natural language interface for non-technical users
5. Customizable: Adapt to specific business models and industries

Comparison with Alternatives

• QuickBooks/Xero: More analytical, forecasting, and visualization capabilities
• Excel/Sheets: More automated, intelligent, and integrated
• Tableau/Power BI: More financial-specific, affordable, and easy to use
• Hire a Financial Analyst: 1/100th the cost with 24/7 availability

Marketing Points

Key Benefits

1. $99 = Virtual Financial Analyst - Get financial insights worth $5000+/year
2. Automate Monthly Reporting - Save 20+ hours per month on financial tasks
3. Avoid Costly Mistakes - Data-driven decisions prevent financial errors
4. Scale Your Business - Financial intelligence to support growth decisions
5. Sleep Better - Accurate cash flow forecasting reduces financial stress

Use Cases

• Shopify Store Owners: Calculate true profitability after fees, shipping, returns
• KDP Publishers: Track royalty income, printing costs, marketing ROI
• Etsy Sellers: Analyze product performance, seasonality, pricing strategy
• Freelancers/Consultants: Track project profitability, client lifetime value
• Startup Founders: Investor-ready financials, burn rate tracking, fundraising prep

Development Roadmap

Phase 1 (MVP - 4 weeks)

• CSV/Excel data import and basic financial analysis
• Income statement, balance sheet, cash flow analysis
• Key financial ratio calculations
• HTML report generation
• Basic visualization charts

Phase 2 (8 weeks)

• Bank API integration (Plaid/Yodlee)
• E-commerce platform connectors (Shopify, Etsy, Amazon)
• Advanced forecasting models
• Interactive dashboards
• PDF/Excel export with formulas

Phase 3 (12 weeks)

• Accounting software integration (QuickBooks, Xero)
• Investment portfolio analysis
• Tax optimization features
• Multi-currency support
• Team collaboration features

Support & Documentation

• Comprehensive Guides: Step-by-step setup for each platform
• Video Tutorials: YouTube channel with real business case studies
• Template Library: Pre-built templates for different business types
• Community Forum: User discussions, tips, and best practices
• Priority Email Support: 24-hour response time for premium users

Success Metrics

• User Adoption: 1000+ installations in first 6 months
• Customer Satisfaction: 4.5+ star rating on ClawHub
• Time Savings: Average 15+ hours/month saved per user
• Business Impact: Improved profitability/revenue for users
• Revenue Target: $100,000 in first year sales

---

Financial Analytics Pro - Your AI-powered financial analyst for $99. Transform financial data into business growth.