以下为本文档的中文说明financial-statements 是一个专门用于生成财务报表的技能涵盖利润表损益表、资产负债表和现金流量表的生成支持跨期比较和差异分析。该技能适用于多个财务工作场景月度或季度的损益表准备、结账时需要标记重大差异、实际数据与预算的对比分析、为管理层审阅构建财务摘要、以及查询 GAAP通用会计准则的列报要求和期末调整事项。该技能以/financial-statements命令的形式使用接受期间类型和期间参数自动生成结构化的财务报表。核心工作流程包括首先获取指定期间的财务数据然后按照 GAAP 要求进行分类和汇总接着计算跨期的变动额和变动百分比最后输出完整的报表。利润表方面遵循 ASC 220 准则的要求资产负债表遵循 ASC 210现金流量表遵循 ASC 230。该技能特别强调差异分析的自动化——系统会自动计算本期与上期或预算之间的差异并从财务角度标记显著差异项帮助财务人员快速定位需要关注的变化。使用该技能时需要注意它提供的是财务工作流的辅助不提供财务建议所有报表在使用于报告或备案前应当由合格的财务专业人士复核。该技能还包含了常见期末调整事项的参考材料如应计项目、递延项目和预提项目的处理方式。/financial-statementsIf you see unfamiliar placeholders or need to check which tools are connected, see CONNECTORS.md.Important: This command assists with financial statement workflows but does not provide financial advice. All statements should be reviewed by qualified financial professionals before use in reporting or filings.Generate financial statements with period-over-period comparison and variance analysis. The workflow below walks through income statement generation; balance sheet and cash flow statement reference formats, GAAP presentation requirements (ASC 220/210/230), and common period-end adjustments are included as supporting reference material.Usage/financial-statements period-type periodArgumentsperiod-type— The reporting period type:monthly— Single month PL with prior month and prior year month comparisonquarterly— Quarter PL with prior quarter and prior year quarter comparisonannual— Full year PL with prior year comparisonytd— Year-to-date PL with prior year YTD comparisonperiod— The period to report (e.g.,2024-12,2024-Q4,2024)Workflow1. Gather Financial DataIf ~~erp or ~~data warehouse is connected:Pull trial balance or income statement data for the specified periodPull comparison period data (prior period, prior year, budget/forecast)Pull account hierarchy and groupings for presentationIf no data source is connected:Connect ~~erp or ~~data warehouse to pull financial data automatically. You can also paste trial balance data, upload a spreadsheet, or provide income statement data for analysis.Prompt the user to provide:Current period revenue and expense data (by account or category)Comparison period data (prior period, prior year, and/or budget)Any known adjustments or reclassifications2. Generate Income StatementPresent in standard multi-column format:INCOME STATEMENT Period: [Period description] (in thousands, unless otherwise noted) Current Prior Variance Variance Budget Budget Period Period ($) (%) Amount Var ($) -------- -------- -------- -------- -------- -------- REVENUE Product revenue $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Service revenue $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Other revenue $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX -------- -------- -------- -------- -------- TOTAL REVENUE $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX COST OF REVENUE [Cost items] $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX -------- -------- -------- -------- -------- GROSS PROFIT $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Gross Margin XX.X% XX.X% OPERATING EXPENSES Research development $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Sales marketing $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX General administrative $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX -------- -------- -------- -------- -------- TOTAL OPERATING EXPENSES $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX OPERATING INCOME (LOSS) $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Operating Margin XX.X% XX.X% OTHER INCOME (EXPENSE) Interest income $XX,XXX $XX,XXX $X,XXX X.X% Interest expense ($XX,XXX) ($XX,XXX) $X,XXX X.X% Other, net $XX,XXX $XX,XXX $X,XXX X.X% -------- -------- -------- TOTAL OTHER INCOME (EXPENSE) $XX,XXX $XX,XXX $X,XXX X.X% INCOME BEFORE TAXES $XX,XXX $XX,XXX $X,XXX X.X% Income tax expense $XX,XXX $XX,XXX $X,XXX X.X% -------- -------- -------- NET INCOME (LOSS) $XX,XXX $XX,XXX $X,XXX X.X% $XX,XXX $X,XXX Net Margin XX.X% XX.X%3. Variance AnalysisFor each line item, calculate and flag material variances.Variance CalculationFor each line item, calculate:Dollar variance:Current period - Prior period (or current period - budget)Percentage variance:(Current - Prior) / |Prior| x 100Basis point change:For margins and ratios, express change in basis points (1 bp 0.01%)Materiality ThresholdsDefine what constitutes a “material” variance requiring investigation. Common approaches:Fixed dollar threshold:Variances exceeding a set dollar amount (e.g., $50K, $100K)Percentage threshold:Variances exceeding a set percentage (e.g., 10%, 15%)Combined:Either the dollar OR percentage threshold is exceededScaled:Different thresholds for different line items based on their size and volatilityExample thresholds (adjust for your organization):Line Item SizeDollar ThresholdPercentage Threshold $10M$500K5%$1M - $10M$100K10% $1M$50K15%Variance DecompositionBreak down total variance into component drivers:Volume/quantity effect:Change in volume at prior period ratesRate/price effect:Change in rate/price at current period volumeMix effect:Shift in composition between items with different rates/marginsNew/discontinued items:Items present in one period but not the otherOne-time/non-recurring items:Items that are not expected to repeatTiming effect:Items shifting between periods (not a true change in run rate)Currency effect:Impact of FX rate changes on translated resultsInvestigation and NarrativeFor each material variance:Quantify the variance ($ and %)Identify whether favorable or unfavorableDecompose into drivers using the categories aboveProvide a narrative explanation of the business reasonAssess whether the variance is temporary or represents a trend changeNote any actions required (further investigation, forecast update, process change)4. Key Metrics SummaryKEY METRICS Current Prior Change Revenue growth (%) X.X% Gross margin (%) XX.X% XX.X% X.X pp Operating margin (%) XX.X% XX.X% X.X pp Net margin (%) XX.X% XX.X% X.X pp OpEx as % of revenue XX.X% XX.X% X.X pp Effective tax rate (%) XX.X% XX.X% X.X pp5. Material Variance SummaryList all material variances requiring investigation:Line ItemVariance ($)Variance (%)DirectionPreliminary DriverAction[Item]$X,XXXX.X%Unfav.[If known]Investigate6. OutputProvide:Formatted income statement with comparisonsKey metrics summaryMaterial variance listing with investigation flagsSuggested follow-up questions for unexplained variancesOffer to drill into any specific variance with/fluxGAAP Presentation RequirementsIncome Statement (ASC 220 / IAS 1)Present all items of income and expense recognized in a periodClassify expenses either by nature (materials, labor, depreciation) or by function (COGS, RD, SM, GA) — function is more common for US companiesIf classified by function, disclose depreciation, amortization, and employee benefit costs by nature in the notesPresent operating and non-operating items separatelyShow income tax expense as a separate lineExtraordinary items are prohibited under both US GAAP and IFRSDiscontinued operations presented separately, net of taxCommon presentation considerations:Revenue disaggregation:ASC 606 requires disaggregation of revenue into categories that depict how the nature, amount, timing, and uncertainty of revenue are affected by economic factorsStock-based compensation:Classify within the functional expense categories (RD, SM, GA) with total SBC disclosed in notesRestructuring charges:Present separately if material, or include in operating expenses with note disclosureNon-GAAP adjustments:If presenting non-GAAP measures (common in earnings releases), clearly label and reconcile to GAAPBalance Sheet (ASC 210 / IAS 1)Distinguish between current and non-current assets and liabilitiesCurrent: expected to be realized, consumed, or settled within 12 months (or the operating cycle if longer)Present assets in order of liquidity (most liquid first) — standard US practiceAccounts receivable shown net of allowance for credit losses (ASC 326)Property and equipment shown net of accumulated depreciationGoodwill is not amortized — tested for impairment annually (ASC 350)Leases: recognize right-of-use assets and lease liabilities for operating and finance leases (ASC 842)Cash Flow Statement (ASC 230 / IAS 7)Indirect method is most common (start with net income, adjust for non-cash items)Direct method is permitted but rarely used (requires supplemental indirect reconciliation)Interest paid and income taxes paid must be disclosed (either on the face or in notes)Non-cash investing and financing activities disclosed separately (e.g., assets acquired under leases, stock issued for acquisitions)Cash equivalents: short-term, highly liquid investments with original maturities of 3 months or lessBalance Sheet Reference FormatASSETS Current Assets Cash and cash equivalents Short-term investments Accounts receivable, net Inventory Prepaid expenses and other current assets Total Current Assets Non-Current Assets Property and equipment, net Operating lease right-of-use assets Goodwill Intangible assets, net Long-term investments Other non-current assets Total Non-Current Assets TOTAL ASSETS LIABILITIES AND STOCKHOLDERS EQUITY Current Liabilities Accounts payable Accrued liabilities Deferred revenue, current portion Current portion of long-term debt Operating lease liabilities, current portion Other current liabilities Total Current Liabilities Non-Current Liabilities Long-term debt Deferred revenue, non-current Operating lease liabilities, non-current Other non-current liabilities Total Non-Current Liabilities Total Liabilities Stockholders Equity Common stock Additional paid-in capital Retained earnings (accumulated deficit) Accumulated other comprehensive income (loss) Treasury stock Total Stockholders Equity TOTAL LIABILITIES AND STOCKHOLDERS EQUITYCash Flow Statement Reference Format (Indirect Method)CASH FLOWS FROM OPERATING ACTIVITIES Net income (loss) Adjustments to reconcile net income to net cash from operations: Depreciation and amortization Stock-based compensation Amortization of debt issuance costs Deferred income taxes Loss (gain) on disposal of assets Impairment charges Other non-cash items Changes in operating assets and liabilities: Accounts receivable Inventory Prepaid expenses and other assets Accounts payable Accrued liabilities Deferred revenue Other liabilities Net Cash Provided by (Used in) Operating Activities CASH FLOWS FROM INVESTING ACTIVITIES Purchases of property and equipment Purchases of investments Proceeds from sale/maturity of investments Acquisitions, net of cash acquired Other investing activities Net Cash Provided by (Used in) Investing Activities CASH FLOWS FROM FINANCING ACTIVITIES Proceeds from issuance of debt Repayment of debt Proceeds from issuance of common stock Repurchases of common stock Dividends paid Payment of debt issuance costs Other financing activities Net Cash Provided by (Used in) Financing Activities Effect of exchange rate changes on cash Net Increase (Decrease) in Cash and Cash Equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of periodCommon Adjustments and ReclassificationsPeriod-End AdjustmentsAccruals:Record expenses incurred but not yet paid (AP accruals, payroll accruals, interest accruals)Deferrals:Adjust prepaid expenses, deferred revenue, and deferred costs for the periodDepreciation and amortization:Book periodic depreciation/amortization from fixed asset and intangible schedulesBad debt provision:Adjust allowance for credit losses based on aging analysis and historical loss ratesInventory adjustments:Record write-downs for obsolete, slow-moving, or impaired inventoryFX revaluation:Revalue foreign-currency-denominated monetary assets and liabilities at period-end ratesTax provision:Record current and deferred income tax expenseFair value adjustments:Mark-to-market investments, derivatives, and other fair-value itemsReclassificationsCurrent/non-current reclassification:Reclassify long-term debt maturing within 12 months to currentContra account netting:Net allowances against gross receivables, accumulated depreciation against gross assetsIntercompany elimination:Eliminate intercompany balances and transactions in consolidationDiscontinued operations:Reclassify results of discontinued operations to a separate line itemEquity method adjustments:Record share of investee income/loss for equity method investmentsSegment reclassifications:Ensure transactions are properly classified by operating segment