Important! The Brokerage Statement Document skill can extract data for only one account from brokerage statements files containing information on multiple accounts. If your brokerage statements contain information about multiple accounts, you must split them into documents using the Brokerage Statement Splitter skill and extract data from each account.
Countries and Languages
| Countries | Languages |
|---|---|
| USA | English |
Extracted Fields
| Field | Description |
|---|---|
| Account Number | The unique number assigned to an investment account by the broker or investment firm. |
| Statement Start Date | The beginning of the statement period for which the statement was generated. |
| Statement End Date | The end of the statement period for which the statement was generated. |
| Statement Period | The period between the statement start date and the statement end date. |
| Total Portfolio Value | The total value of an investor’s investment holdings within the account as of the statement date. |
| Base Currency | The currency that is used to calculate the value of the account’s holdings and any gains or losses. |
Broker
| Field | Description |
|---|---|
| Name | The name of the broker. |
| Address | The address of the broker. |
| Phone Number | The phone number of the broker. |
Advisor
| Field | Description |
|---|---|
| Name | The name of the advisor. |
| Phone Number | The phone number of the advisor. |
| Address | The address of the advisor. |
Client
| Field | Description |
|---|---|
| Name | The name of the client. |
| Address | The address of the client. |
| Phone Number | The phone number of the client. |
Holdings Level
| Field | Description |
|---|---|
| Account Type | The type of account in which the investor holds the securities listed on the statement. |
| Asset Class | The classification of the investments held in the brokerage account according to their asset class. |
| Description | A detailed description of each investment held in the brokerage account. |
| Symbol | The unique ticker symbol assigned to each investment held in the brokerage account. |
| CUSIP | The unique identifier assigned to each security registered with the Committee on Uniform Securities Identification Procedures (CUSIP). |
| Quantity | The number of shares or units of a security that are held in the investor’s brokerage account. |
| Price | The price per share or unit of a security at the time it was acquired by the investor. |
| Price as of Date | The date on which the price per share or unit of a security was last updated or determined by the broker. |
| Currency | The currency in which the security is denominated or traded. |
| Market Value | The current market value of an investor’s holdings of a particular security. |
| Prior Market Value | The market value of an investor’s holdings of a particular security as of the previous statement date. |
| Cost Basis | The total amount an investor has paid to acquire their current holdings of a particular security. |
| Accrued Value | The value of the investor’s accrued earnings on the security. |
| Estimated Income | The estimated income that includes interest, dividends, and other income that the investor is expected to receive from their holdings. |
| Estimated Yield | The estimated yield that an investor can expect to earn from their holdings of a particular security over a given period of time |
| Current Yield | The actual yield an investor is currently earning from their holdings of a particular security. |
Transactions
| Field | Description |
|---|---|
| Trade Date | The date on which a particular trade was executed. |
| Settlement Date | The date on which the settlement process is complete. |
| Account Type | The type of account associated with a particular trade transaction. |
| Transaction Type | The specific type of transaction that occurred in an investor’s account during the statement period. |
| Description | Additional details about the specific transaction that occurred in an investor’s account. |
| Symbol | The ticker symbol of the security that was involved in a particular transaction. |
| CUSIP | The unique identifier assigned to financial instruments in the United States, particularly for stocks, bonds, and other securities. |
| Quantity | The number of shares, units, or contracts involved in a particular transaction. |
| Price | The price at which a security was bought or sold during a particular transaction. |
| Currency | The currency in which a particular transaction was executed. |
| Amount | The total amount associated with a particular transaction. |
| Taxable Amount | The amount of taxable income associated with specific transactions. |
| Non Taxable Amount | The amount of income or proceeds from tax-exempt transactions. |
| Pending Status | The current status of a transaction that is pending or not yet completed. |
Key Fields
- Account Number
- Broker/Name
- Client/Name
- Total Portfolio Value
- Statement Start Date
- Statement End Date