Data Analysis
financial-statements avatar

financial-statements

Generate financial statements (P&L, balance sheet, cash flow) with period-over-period comparisons, variance analysis, and GAAP compliance checks.

Introduction

The financial-statements skill empowers financial professionals and operations teams to automate the preparation of standard financial reporting packages. By leveraging direct connections to ERP systems or data warehouses, this skill streamlines the process of generating month-end, quarter-end, and annual income statements, balance sheets, and cash flow reports. It is designed for accountants, financial analysts, and leadership teams who need to reconcile actual performance against budgets, identify material variances, and prepare data for executive review or formal audits.

  • Automated generation of multi-column financial statements including period-over-period comparisons, year-over-year trends, and budget-to-actual variance reporting.

  • Calculation of complex financial metrics such as gross margin percentage, operating income ratios, and variance decomposition (volume, rate, and mix effects).

  • Built-in materiality threshold frameworks to automatically flag discrepancies that require investigation, reducing manual review time during the financial close process.

  • Support for GAAP presentation standards, specifically referencing ASC 220, 210, and 230 to ensure reports align with regulatory requirements.

  • Flexible input handling: connect directly to data sources like Snowflake, Databricks, or BigQuery via MCP, or process uploaded spreadsheets, CSVs, and trial balance data when automated integrations are unavailable.

  • Users should define the period-type (monthly, quarterly, annual, or YTD) and the specific period string (e.g., 2024-Q4) to invoke the analysis workflow.

  • The tool requires accurate trial balance, revenue, and expense data to generate precise reports. Always verify outputs with qualified financial professionals before incorporating them into formal external filings or tax reporting.

  • To optimize variance analysis, configure custom materiality thresholds based on your organization's scale (e.g., setting dollar or percentage triggers for line items like R&D, Sales & Marketing, and G&A).

  • Ensure proper account grouping and hierarchy mapping, especially if the data source is a raw trial balance, to maintain consistency in multi-period presentation.

  • The workflow provides actionable insights for financial planning and analysis (FP&A) tasks, such as identifying expense overruns, investigating revenue fluctuations, and preparing internal management reports.

Repository Stats

Stars
11,659
Forks
1,358
Open Issues
92
Language
Python
Default Branch
main
Sync Status
Idle
Last Synced
Apr 29, 2026, 01:23 PM
View on GitHub