--- name: reporting-analytics-platform description: Manage financial reporting and analytics platforms including BI dashboards, financial data modeling, KPI development, automated reporting, management reporting packages, and board reporting. Use when developing financial dashboards, building reporting frameworks, creating KPI reports, automating financial reports, or preparing board packs. Triggers on phrases like "financial reporting platform", "BI dashboard", "management reporting", "board reporting", "financial KPIs", "reporting automation", "financial analytics", "data model", "reporting framework", "board pack", "financial scorecard", "performance metrics". --- # Reporting & Analytics Platform Build and maintain financial reporting and analytics infrastructure for data-driven decision-making. ## Financial Reporting Infrastructure ### Platform Architecture ``` REPORTING PLATFORM ARCHITECTURE: ════════════════════════════════ DATA SOURCES: ┌──────────────────────────┬──────────────────────────────────────┐ │ System │ Data Provided │ ├──────────────────────────┼──────────────────────────────────────┤ │ ERP/GL (NetSuite) │ GL balances, JE, AP, AR, fixed assets│ │ CRM (Salesforce) │ Revenue, pipeline, customer data │ │ Billing (Chargebee) │ Subscription revenue, AR, usage data │ │ HRIS (Rippling) │ Headcount, compensation, benefits │ │ Expense (Rippling) │ Expense data, policy compliance │ │ Banking platforms │ Cash balances, transactions │ │ Market data (Bloomberg) │ FX rates, benchmark data │ │ Survey tools │ Employee satisfaction, CSAT │ └──────────────────────────┴──────────────────────────────────────┘ DATA PIPELINE: Source → ETL/ELT → Data Warehouse → Data Model → BI/Analytics → Reports/Dashboards ETL/ELT: Fivetran (automated data replication) Data Warehouse: Snowflake (cloud-based, scalable) Data Model: dbt (transformations, business logic) BI Platform: Tableau (visualization, dashboards) Orchestration: Airflow (pipeline scheduling, monitoring) Refresh frequency: Daily: Transactional data (GL, AR, AP, revenue, expenses) Weekly: Pipeline data, survey data Monthly: Budget/forecast data, headcount snapshot Real-time: Cash position (banking API), critical alerts DATA MODEL STRUCTURE: Star schema design: Fact tables: - Fact_FinancialTransactions (GL detail) - Fact_Revenue (subscription revenue, ARR, MRR) - Fact_Expenses (departmental spending) - Fact_Headcount (employee counts, by department) - Fact_Budget (budget, forecast, actual) Dimension tables: - Dim_Date (date hierarchy: day, week, month, quarter, year) - Dim_Entity (legal entities, reporting units) - Dim_ChartOfAccounts (COA hierarchy, natural accounts) - Dim_Department (organizational structure) - Dim_Product (product lines, offerings) - Dim_Customer (customer segments, industries) - Dim_Geography (regions, countries) - Dim_BudgetScenario (actual, budget, forecast variants) Data quality: Completeness: 99.5% (daily validation checks) Accuracy: 100% (GL reconciliation daily) Timeliness: Data available by 8 AM (previous day) Consistency: Single source of truth (data model) ``` ## Financial KPIs & Dashboards ### KPI Framework ``` FINANCIAL KPI FRAMEWORK: ═════════════════════════ TIER 1 — BOARD / C-SUITE (Strategic): Revenue: - Total revenue ($, $/employee, growth rate) - ARR (Annual Recurring Revenue) - MRR (Monthly Recurring Revenue) - New logo revenue vs. expansion revenue - Net revenue retention (NRR) - Gross revenue retention (GRR) Profitability: - Gross margin (%) - Operating margin (%) - EBITDA margin (%) - Net income margin (%) - Contribution margin (per product) Liquidity: - Cash position ($, trend) - Cash flow from operations (monthly, quarterly) - Cash runway (months) - Burn rate (net) - Working capital ratio Efficiency: - Revenue per employee - Operating expense ratio (%) - CAC (Customer Acquisition Cost) - LTV/CAC ratio - Payback period (months) TIER 2 — VICE PRESIDENT / DIRECTOR (Tactical): Revenue detail: - Revenue by product line - Revenue by geography - Revenue by customer segment - Sales pipeline (weighted, by stage) - Win/loss rate - Deal cycle length Cost detail: - OPEX by department - Headcount by department - Fully loaded cost per employee - Cloud infrastructure cost (as % of revenue) - Customer acquisition spend (marketing + sales) Cash management: - DSO / DPO / DIO - Cash conversion cycle - AR aging - Capex spending (vs. budget) HR finance: - Revenue per employee - Compensation as % of revenue - Turnover rate - Time to fill TIER 3 — MANAGER / ANALYST (Operational): Transactional: - Daily revenue recognition - Daily expense tracking - Open items (AR, AP) - Budget vs. actual (by cost center) - Variance analysis (>5% or >$5K) Process metrics: - Close timeline (actual days vs. target) - JE volume and value - Reconciliation status - Intercompany open items - Exception reports KEY DASHBOARDS: 1. Executive Financial Dashboard (Board/C-Suite): - P&L summary (YTD, QTD, MTD) - Balance sheet snapshot - Cash position + 13-week forecast - Key metrics (ARR, NRR, margins, cash runway) - Budget variance (high-level) - Refresh: Daily (P&L), Real-time (cash) - Access: Board, C-Suite, Executive team 2. FP&A Dashboard (Finance team): - Detailed P&L (all lines, all periods) - Variance analysis (budget, forecast, prior year) - Scenario modeling (what-if analysis) - Headcount vs. budget - Capex tracking - Refresh: Daily - Access: FP&A team, Controller, CFO 3. Revenue Dashboard (Sales + Finance): - Pipeline by stage - Deal velocity - Win/loss analysis - NRR/GRR trends - Churn analysis - Refresh: Daily (CRM data) - Access: Sales leadership, Finance 4. Operations Dashboard (Controllership): - Close status (checklist progress) - Reconciliation status - JE volume and review - Exception reports - Intercompany status - Refresh: Real-time (during close) - Access: Accounting team, Controller 5. Treasury Dashboard (Treasury/CFO): - Cash position (all accounts) - 13-week cash forecast - Investment portfolio - Debt schedule and covenants - FX exposure - Refresh: Real-time (banking API) - Access: Treasury, CFO ``` ## Automated Reporting ### Report Schedule & Distribution ``` AUTOMATED REPORTING SCHEDULE: ══════════════════════════════ DAILY REPORTS: ┌────────────────────────────┬────────────┬─────────────────┐ │ Report │ Time │ Distribution │ ├────────────────────────────┼────────────┼─────────────────┤ │ Cash position summary │ 8:00 AM │ CFO, Treasury │ │ Revenue recognition (day) │ 8:30 AM │ FP&A, Controller│ │ Expense tracking (day) │ 9:00 AM │ Dept heads │ │ Exception alerts │ Continuous │ Approvers │ └────────────────────────────┴────────────┴─────────────────┘ WEEKLY REPORTS: ┌────────────────────────────┬───────────┬─────────────────┐ │ Report │ Day │ Distribution │ ├────────────────────────────┼───────────┼─────────────────┤ │ Week-to-date P&L │ Friday │ C-Suite │ │ Pipeline update │ Wednesday │ Sales + Finance │ │ Cash flow update │ Friday │ CFO │ │ Headcount snapshot │ Friday │ HR + CFO │ └────────────────────────────┴───────────┴─────────────────┘ MONTHLY REPORTS: ┌────────────────────────────┬───────────┬─────────────────┐ │ Report │ Day │ Distribution │ ├────────────────────────────┼───────────┼─────────────────┤ │ Monthly close pack │ Day 15 │ C-Suite │ │ Detailed P&L │ Day 15 │ All managers │ │ Balance sheet + cash flow │ Day 15 │ C-Suite, Audit │ │ Budget variance analysis │ Day 18 │ C-Suite │ │ Headcount + comp analysis │ Day 18 │ HR + CFO │ │ Revenue metrics (ARR/NRR) │ Day 12 │ Sales + C-Suite │ │ KPI scorecard │ Day 12 │ Board │ └────────────────────────────┴───────────┴─────────────────┘ QUARTERLY REPORTS: ┌────────────────────────────┬────────────────────┬───────────┐ │ Report │ Timing │ Distribution│ ├────────────────────────────┼────────────────────┼───────────┤ │ Board pack (full financials)│ 5 days before mtg │ Board │ │ 10-Q package (SEC filing) │ Per SEC deadline │ SEC, │ │ │ │ investors │ │ Forecast update (rolling) │ Q+1, Week 1 │ C-Suite │ │ Tax provision analysis │ Day 20 │ Tax team │ │ Goodwill impairment test │ Q4 only │ Audit │ └────────────────────────────┴────────────────────┴───────────┘ ANNUAL REPORTS: 10-K filing (SEC): Per deadline (typically Feb-March) Annual budget: September (for following fiscal year) Strategic plan: October (3-year outlook) Transfer pricing study: November (external advisor) Audit planning: November (external auditor) REPORT QUALITY METRICS: On-time delivery: 98.5% (target: >95%) Data accuracy: 99.9% (daily validation) User satisfaction: 4.2/5.0 (quarterly survey) Report utilization: 87% (active users / total access) Dashboard refresh SLA: <4 hours (daily reports) ``` ## Board Reporting ### Board Pack Structure ``` BOARD PACK TEMPLATE: ════════════════════ SECTION 1: EXECUTIVE SUMMARY (2 pages) - CEO narrative (business performance, key initiatives) - Financial highlights (revenue, profit, cash) - Key metrics (ARR, NRR, margins, headcount) - Risks and opportunities - Strategic updates SECTION 2: FINANCIAL PERFORMANCE (4-6 pages) - P&L summary (YTD + QTD vs. budget) - Balance sheet summary - Cash flow statement - Variance analysis (significant items >5% or >$500K) - Revenue detail (product, geography, segment) - Expense detail (department, category) SECTION 3: KEY METRICS (2 pages) - Revenue metrics: ARR, MRR, NRR, GRR, churn - Efficiency metrics: Revenue/employee, OPEX ratio, CAC/LTV - Liquidity metrics: Cash position, runway, DSO - Market metrics: Pipeline, deal velocity, win rate SECTION 4: CASH & LIQUIDITY (2 pages) - Cash position trend (12 months) - 13-week cash flow forecast - Capital structure (debt, equity, net debt) - Capex plan (current + planned) SECTION 5: RISK & COMPLIANCE (1-2 pages) - Key risks (operational, financial, compliance) - Internal audit findings - Regulatory updates - Insurance review SECTION 6: OUTLOOK (1-2 pages) - Rolling forecast update - Strategic initiatives status - Headcount plan - Capital allocation priorities BOARD PACK GUIDELINES: - Total length: 12-16 pages - Delivery: 5 business days before meeting - Format: PDF + interactive dashboard (Tableau) - Pre-read: 1-2 day review expected - Discussion: 90 minutes (financials section) - Follow-up: Action items within 24 hours Quality standards: - Data accuracy: 100% (verified by Controller) - Timeliness: On-time delivery 100% - Clarity: Plain language, no jargon - Visuals: Charts/graphs for all trends - Context: Benchmarking, commentary, forward-looking ``` ## Output ### Platform Status Dashboard ``` REPORTING PLATFORM STATUS — Jan 2025 ════════════════════════════════════ Infrastructure: Data sources: 8 (all connected, healthy) Data pipeline: Fivetran → Snowflake → dbt → Tableau Refresh: Daily (8 AM), Real-time (cash) Data quality: 99.5% (validation checks passing) Dashboards: Active: 5 (Executive, FP&A, Revenue, Operations, Treasury) Users: 45 (active), 62 (licensed) Utilization: 87% (target: >80%) Satisfaction: 4.2/5.0 (Q4 survey) Reporting: Daily reports: 4 (all on-time) Weekly reports: 4 (all on-time) Monthly reports: 7 (on-time: 98.5%) Quarterly reports: Board pack, 10-Q, forecast Annual reports: 10-K, budget, strategic plan Board Reporting: Next board meeting: March 15, 2025 Board pack delivery: March 10, 2025 Last board meeting: December 2024 (all items covered) Board satisfaction: 4.5/5.0 (survey) Data Model: Fact tables: 5 Dimension tables: 8 Metrics defined: 120+ Data freshness: T-1 (previous day, by 8 AM) Actions: 1. Q4 board pack preparation (Mar 10) 2. Dashboard optimization (user feedback) 3. New metric development (unit economics) 4. Data pipeline monitoring (monthly audit) 5. Platform cost review (annual) ``` ## Integration Points - ERP/GL (NetSuite, SAP): Primary financial data source - CRM (Salesforce): Revenue, pipeline, customer data - Billing platforms (Chargebee): Subscription data, usage metrics - HRIS (Rippling): Headcount, compensation, benefits - Banking platforms: Cash data, transaction feeds - ETL tools (Fivetran): Data replication, pipeline orchestration - Data warehouse (Snowflake): Centralized data storage - Transformation tools (dbt): Data modeling, business logic - BI platforms (Tableau, Power BI): Visualization, dashboards - Orchestration (Airflow): Pipeline scheduling, monitoring - Alerting platforms (Slack, email): Automated notifications - Board portal (BoardEffect, Diligent): Board pack delivery ## Edge Cases - **System outage**: Backup data model; manual reporting process; SLA impact; communication - **Data quality issue**: Root cause analysis; data correction; validation enhancement; rollback - **Schema change**: Impact assessment; model update; report modification; user communication - **Volume spike**: Scalability; performance impact; cost increase; capacity planning - **Regulatory change**: New reporting requirement; system modification; data validation - **Platform migration**: Parallel run; data validation; user training; cutover planning - **Security breach**: Data access review; breach notification; audit trail; remediation - **M&A data integration**: Entity onboarding; chart of accounts mapping; historical data migration - **Cloud cost overrun**: Usage optimization; reserved instances; data lifecycle management; budget alert - **User access management**: Segregation of duties; least privilege; access review; termination