← Files Public Equity InvestingARCHIVED FILE

skills/financials-normalizer/references/qa-rules.md

6.34 KB · Oct 2, 2026 · 00:03 UTC

↓ Download file

# QA rules

Use these checks before any normalized financials are handed to modeling, memo, deck/report, equity-model-update, scenario, risk, ETF/index, or earnings skills.

## Required QA outputs

Create `QA_Flags` with: `flag_id`, `severity`, `entity`, `period`, `area`, `issue`, `impact`, `recommended_fix`, `source_id`, and `status`.

Create `Validation_Checks` for checks actually performed, with: `check_id`, `area`, `period`, `test`, `expected_value`, `observed_value`, `variance`, `result`, `source_id`, and `notes`. Do not report a number of passed checks unless those checks are preserved here or in an equivalent audit output.

When disclosure definitions or presentation bases changed, create `Disclosure_Comparability_Bridge` before downstream handoff. Preserve the legacy and current bases, identify any recast comparable series, and state which lines are loadable, historical/audit-only, directional-only, or missing required source.

Severity:
- `blocker`: cannot use downstream until resolved.
- `high`: materially affects valuation, rating/target support, investment memo, earnings interpretation, equity risk, or public-equity reporting.
- `medium`: should be reviewed before senior/client/committee use.
- `low`: documentation, labeling, or immaterial cleanup.

## Source checks

- Every material value has a source ID and source location.
- Every source ID exists in `Source_Index`.
- Every source has source date, period coverage, and source type.
- User, management, provider, calculated, adjusted, estimated, and inferred values are separately labeled.
- Issuer guidance is labeled `issuer_management_claim` in `kpi_schedule`; `consensus_estimate` is reserved for externally sourced estimates labeled `estimate_consensus`.
- A user-supplied provenance note or source-support file is classified as `uploaded_file`, not `user_prompt`.
- Conflicting source values are retained in `Conflict_Log`.
- Stale or preliminary values are flagged but not automatically discarded.

## Period checks

- Fiscal year-end is identified or marked unknown.
- Annual, quarter, month, YTD, LTM/TTM, budget, forecast, estimate, and pro forma periods are labeled distinctly.
- Period end dates align with fiscal labels.
- Fiscal period-end dates are sourced explicitly; do not assume calendar quarter ends from labels such as `Q1 FY2027`.
- Stub periods are not mixed with full periods without disclosure.
- Restated values supersede prior values when restatement status is clear.

## Scale, unit, and currency checks

- Currency and units are identified for every value.
- Source units and normalized units are preserved.
- Factor-of-1,000 / 1,000,000 differences are flagged.
- Per-share, percentage, bps, count, and dollar values are not mixed.
- FX conversions include rate, date, and source.

## Income statement checks

- Revenue - COGS ties to gross profit when all values are available.
- Gross profit - operating expenses ties to operating income when all values are available.
- Pretax income - tax expense ties to net income when all values are available.
- EPS directionally ties to net income and share counts when available.
- Non-GAAP values are not treated as GAAP facts.
- Discontinued operations, minority interest, preferred dividends, and non-operating items are isolated when material.

## Balance sheet checks

- Total assets tie to total liabilities plus equity when available.
- Current assets and current liabilities tie to component sums when available.
- Ending cash ties to cash-flow statement ending cash when available.
- Debt, leases, preferred stock, and noncontrolling interest are not hidden inside generic liabilities/equity without notes.

## Cash flow checks

- CFO + CFI + CFF + FX effect ties to net change in cash when available.
- Beginning cash + net change ties to ending cash when available.
- Capex sign is explicit.
- FCF formula is explicit and not assumed to match company definition.
- Working-capital cash-flow signs preserve source convention unless clearly converted and documented.

## KPI and segment checks

- KPI definitions are captured or marked missing.
- Segment totals tie to consolidated totals when source provides reconciliations.
- Company-defined metrics are labeled company-defined.
- Sector metrics include units and definition: ARR, NRR, RPO, GMV, AUM, NIM, loss ratio, NOI, production, reserves, bookings, backlog, cohort data, and similar.
- New, renamed, regrouped, discontinued, or recast KPIs/segments appear in `Disclosure_Comparability_Bridge` with both available disclosure bases and a model treatment.
- Use `comparable_rounded` for a retained same-definition series available across periods in rounded narrative units; reserve `directional_only` for data that cannot support a comparable series.
- Narrative growth rates or rounded current-period disclosures do not silently become exact historical model inputs.

## Presentation-change checks

- Apply `recast_comparable` only to rows changed or re-presented on a comparable basis; do not apply a changed cash-and-securities presentation to unrelated balance-sheet lines.

## Downstream readiness

Mark readiness as `ready`, `partial`, or `not_ready` for relevant downstream skills.

For standalone model-ready requests, state readiness by schedule or series as well as overall. A consolidated actuals schedule may be `ready` while a recast segment driver schedule is `partial`; do not label the full package model-ready without this distinction.

- Valuation/DCF: revenue, margins/EBIT/EBITDA, tax, D&A, capex, working capital, cash, debt, shares, and forecast basis.
- Public valuation/modeling: historicals, revenue, EBITDA/EBIT, EPS, FCF, capex, working capital, cash/debt, tax, share count, and forecast drivers.
- Normalization adjustments: financials, trial balance/detail where available, management adjustments, add-back support, customer/vendor concentration, and NWC support.
- Earnings: reported financials, guidance/KPIs, transcript/source commentary if requested, and consensus if available.
- Credit Markets handoff / equity-risk context: net debt, cash, liquidity runway, maturity wall summary, rating or CDS/spread signal, refinancing pressure, and common-equity downside drivers. Route covenant disclosures, collateral coverage, recovery, bond/loan/CDS pricing, and debt-security analysis to Credit Markets.
- Internal/source exports: actuals, forecast/estimate, account/cost center mappings, department or segment owners, and refresh timestamp.

SHA-256: 17d699a7e6eba0fe58d5a4dad7b1eea75f7d781e6a9ac95a719970593137379e