List income statement facts
Dense account x company x month income-statement rows for Income Statement accounts only, same columns as the income_statement table in your data export. amount is the presentation-signed movement for that calendar month; ytd_amount is fiscal year-to-date through period with the same sign. net_income_impact is always credits - debits so a company/period sum equals Net Income. Amounts are in the entity’s functional currency; no consolidated rates are applied. To translate, join consolidated_rates on (company_id, period_start) and multiply monthly amount by average_rate, then sum months — translating ytd_amount with a single month’s rate does not match consolidated YTD. Subtotals (Gross Profit, Net Income) are not emitted; group on statement_section. Optional company_id, account_id, start_date, and end_date narrow which month rows are returned (start_date / end_date never produce a range total).
Query Parameters
Inclusive lower bound on month periods (period_start). Day is ignored; grain is calendar month. Emit months start no earlier than 15 fiscal years before the company's last posting; an earlier start_date advances to that floor. Does not change ytd_amount (still fiscal year-to-date through period).