Investment Account Summary

This data model captures essential summary information from investment account statements. It includes details such as the financial institution holding the account, the statement period dates, account currency, and ownership details like the type of ownership and the names of account holders. Key financial figures like the account's value at the beginning and end of the statement period, investment gains or losses, contributions, withdrawals, and fees charged during the period are also included. The model specifies the type of investment account (e.g., IRA, 401k, Annuity) and can include details specific to certain account types, like employee/employer contributions for retirement accounts or annuity types. Beneficiary names may also be captured.

Field nameTypeDescription
financial_institution_namestringName of the bank or financial institution managing the investment account.
statement_period_start_datestringThe first date covered by this statement (Format: YYYY-MM-DD).
statement_period_end_datestringThe last date covered by this statement (Format: YYYY-MM-DD).
account_currencystringThe currency of the account values (e.g., USD, EUR). Defaults to USD if missing.
ownership_typestringHow the account is owned (e.g., individual, joint, trust). See notes.
holdersarrayList of individuals or entities who own the account.
holder_namestringThe name of an individual or entity holding the account.
holder_typestringThe role of the holder (e.g., primary, joint).
starting_balance_periodnumberThe total value of the account at the beginning of the statement period.
ending_balance_periodnumberThe total value of the account at the end of the statement period.
account_typestringThe specific type of investment account (e.g., taxable, IRA, 401k). See notes.
investment_gain_loss_periodnumberThe net gain or loss from investment activities during the period.
contributions_periodnumberTotal amount deposited into the account during the statement period.
withdrawals_periodnumberTotal amount taken out of the account during the statement period.
fees_charged_periodnumberTotal fees deducted from the account during the statement period.
employee_contributions_periodnumberContributions made by the employee during the statement period (if applicable).
employer_contributions_periodnumberContributions made by the employer during the statement period (if applicable).
employee_contributions_ytdnumberTotal contributions made by the employee from the start of the year to date.
employer_contributions_ytdnumberTotal contributions made by the employer from the start of the year to date.
beneficiary_namesstringNames of the designated beneficiaries for the account.
annuity_typestringThe specific type of annuity, if the account is an annuity. See notes.

Field Notes

  • Dates: All date fields (statement_period_start_date, statement_period_end_date) should be in YYYY-MM-DD format.
  • account_currency: Should be the 3-digit ISO currency code (e.g., USD, CAD, EUR). Defaults to "USD" if not found on the document.
  • ownership_type: Extract the value that best matches one of the allowed values: individual, joint_wros (Joint with Rights of Survivorship), joint_tic (Joint Tenants in Common), trust, custodial_utma (Uniform Transfers to Minors Act), custodial_ugma (Uniform Gifts to Minors Act), fiduciary_guardian.
  • account_type: Extract the value that best matches one of the allowed values: taxable_brokerage, traditional_ira, roth_ira, rollover_ira, sep_ira, roth_sep_ira, simple_ira, traditional_401k, roth_401k, traditional_403b, roth_403b, traditional_457b, roth_457b, pension_plan, profit_sharing_plan, keogh, other_retirement, eduction_529, coverdell_esa, other_education, annuity, investment_hsa, other_investment, tsp, roth_tsp.
  • annuity_type: Only applicable if account_type is annuity. Extract the value that best matches one of the allowed values: fixed, variable, indexed.
  • holders: List all account holders. If the type of holder (e.g., primary, joint, custodian) is not specified, it may be inferred from context or left blank.
  • Numeric Fields: Extract numbers with a maximum of 2 decimal places. If a value is explicitly stated as zero (e.g., $0.00 withdrawals), extract it as 0. Do not perform calculations.