What types of financial statements are there, and can you describe the structure and data of the one you are most familiar with?
For this exercise, use the income statement as the statement you are most familiar with. Return its published Q2 2025 line items with account classifications and section totals.
Output
- One row per income statement line item.
- Columns:
statement_type, fiscal_period, section, account_name, amount, presented_amount, and section_total.
- Include only the published Q2 2025 income statement, ordered by line order.
Output details
- Order rows by ascending line order.
- Set
presented_amount equal to amount for Revenue and Other income, and negate it for every other section.
- Preserve
NULL in presented_amount when amount is NULL.
- Calculate
section_total as the sum of presented_amount for each exact section, ignoring NULL values, and repeat it on every section row.
