Brokerage Statement
A brokerage statement is a periodic report generated by a brokerage firm for its clients. It provides an overview of the client's investments, transactions, and account activity during a specific period
API Upload
The type parameter is brokerage_statement for the Upload endpoint.
Field Descriptions:
The model automatically detects data such as:
| Session Name | Field Name | Data Type | Description |
|---|---|---|---|
| Account Information | Account Number | Number | Account number |
| Account Information | Account Type | String | Type of the account (e.g., IRA) |
| Account Information | Client Name | String | Name of the client |
| Account Information | Client Address | String | Address of the client |
| Account Information | Custodian Name | String | Name of the custodian |
| Account Information | Advisor Name | String | Name of the advisor (if available) |
| Portfolio Summary | Deposits | Number | Total deposits |
| Portfolio Summary | Withdrawals | String | Total withdrawals (if available) |
| Portfolio Summary | Total Value | Number | Total value of the portfolio |
| Portfolio Summary | Period Start | Date | Start date of the portfolio period |
| Portfolio Summary | Period End | Date | End date of the portfolio period |
| Asset Allocation | Cash and Equivalents | Number | Amount in cash and equivalents |
| Asset Allocation | Equity | String | Amount in equity |
| Asset Allocation | Crypto | String | Amount in cryptocurrency |
| Asset Allocation | Mutual Fund | String | Amount in mutual funds (if available) |
| Asset Allocation | Others | String | Amount in other assets (if available) |
| Asset Allocation | Index Funds | String | Amount in index funds (if available) |
| Asset Allocation | Money Market | String | Amount in money market (if available) |
| Asset Allocation | Bonds | String | Amount in bonds (if available) |
| Account Activity - Total | Dividends Received | String | Total dividends received (if available) |
| Account Activity - Total | Interest Received | String | Total interest received (if available) |
| Account Activity - Total | Gain or Loss | Number | Total gain or loss |
| Account Activity - Total | Fees | String | Total fees (if available) |
| Account Activity - Total | Employee Before Tax | String | Employee earnings before tax (if available) |
| Account Activity - Total | Employer Match | String | Employer match (if available) |
| Holdings Table | Holdings Table | Table | Table of holdings with |
| Date | String | The date of the transaction (e.g., 01/01/2023) | |
| Description | String | A description or name for the transaction (e.g., Test) | |
| Qty | String | The quantity or number of units involved in the transaction (e.g., 1) | |
| Unit Price | String | The price per unit for the transaction (e.g., 200) | |
| Total | String | The total value or amount of the transaction (e.g., 200) | |
| Buy | String | The amount spent on buying (e.g., 200) | |
| Sell | String | The amount received from selling (e.g., 200) | |
| Deposit | String | The amount deposited (e.g., 200) | |
| Withdrawal | String | The amount withdrawn (e.g., 200) | |
| Transactions Table | Transactions Table | Table | Table of transactions |
| Date | String | The date of the transaction (e.g., 01/01/2023) | |
| Description | String | A description or name for the transaction (e.g., Test) | |
| Qty | String | The quantity or number of units involved in the transaction (e.g., 1) | |
| Unit Price | Number | The price per unit for the transaction (e.g., 200.0) | |
| Total | The total value or amount of the transaction (Not available) |
Coverage
- Majority USA Brokerage froms
- Battle tested on
| Brokerage Froms |
|---|
| JP Morgon |
Version
- Beta
Sample
Sample JSON Output
{
"data": {
"Account Information": {
"Account Number": {
"value": 123,
"position": [
1209,
4534,
1308,
4556
],
"confidence": 1.0,
"review_required": false
},
"Account type": {
"value": "IRA",
"position": [
477,
679,
523,
700
],
"confidence": 1.0,
"review_required": false
},
"Client Name": {
"value": "XYZ ABC",
"position": [
160,
679,
465,
700
],
"confidence": 1.0,
"review_required": false
},
"Client address": {
"value": "7430 HUMBLE, TX",
"position": [
161,
744,
480,
798
],
"confidence": 1.0,
"review_required": false
},
"Custodian Name": {
"value": "TD AMERITRADE CLEARING",
"position": [
161,
711,
542,
734
],
"confidence": 1.0,
"review_required": false
},
"Advisor Name": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
}
},
"Portfolio Summary": {
"Deposits": {
"value": 123.3,
"position": [
997,
5033,
1095,
5058
],
"confidence": 1.0,
"review_required": false
},
"Withdrawals": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Total value": {
"value": 1223.61,
"position": [
1492,
4757,
1618,
4788
],
"confidence": 1.0,
"review_required": false
},
"Period start": {
"value": "01/12/2031",
"position": [
754,
4668,
947,
4696
],
"confidence": 1.0,
"review_required": false
},
"Period end": {
"value": "31/12/2021",
"position": [
1029,
4981,
1097,
5005
],
"confidence": 1.0,
"review_required": false
}
},
"Asset allocation": {
"Cash and equivalents": {
"value": 1234.61,
"position": [
997,
5785,
1095,
5809
],
"confidence": 1.0,
"review_required": false
},
"Equity": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Crypto": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Mutual fund": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Others": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Index Funds": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Money Market": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Bonds": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
}
},
"Account activity- Total": {
"Dividens received": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Interest received": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Gain or Loss": {
"value": 7694.31,
"position": [
1008,
5339,
1095,
5364
],
"confidence": 1.0,
"review_required": false
},
"Fees": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Employee before tax": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Employer match": {
"value": "",
"position": "",
"confidence": 0,
"review_required": true
},
"Holdings Table": [
{
"Date": {
"value": "01/01/2023",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Description": {
"value": "Test",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Qty": {
"value": "1",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Unit Price": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Total": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Buy": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Sell": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Deposit": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Withdrawal": {
"value": "200",
"position": [],
"confidence": 1.0,
"review_required": false
}
}
],
"Transactions Table": [
{
"Date": {
"value": "01/01/2023",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Description": {
"value": "Test",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Qty": {
"value": "1",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Unit price": {
"value": 200.0,
"position": [],
"confidence": 1.0,
"review_required": false
},
"Total": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
}
}
]
}
}
}
Updated about 1 year ago