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 NameField NameData TypeDescription
Account InformationAccount NumberNumberAccount number
Account InformationAccount TypeStringType of the account (e.g., IRA)
Account InformationClient NameStringName of the client
Account InformationClient AddressStringAddress of the client
Account InformationCustodian NameStringName of the custodian
Account InformationAdvisor NameStringName of the advisor (if available)
Portfolio SummaryDepositsNumberTotal deposits
Portfolio SummaryWithdrawalsStringTotal withdrawals (if available)
Portfolio SummaryTotal ValueNumberTotal value of the portfolio
Portfolio SummaryPeriod StartDateStart date of the portfolio period
Portfolio SummaryPeriod EndDateEnd date of the portfolio period
Asset AllocationCash and EquivalentsNumberAmount in cash and equivalents
Asset AllocationEquityStringAmount in equity
Asset AllocationCryptoStringAmount in cryptocurrency
Asset AllocationMutual FundStringAmount in mutual funds (if available)
Asset AllocationOthersStringAmount in other assets (if available)
Asset AllocationIndex FundsStringAmount in index funds (if available)
Asset AllocationMoney MarketStringAmount in money market (if available)
Asset AllocationBondsStringAmount in bonds (if available)
Account Activity - TotalDividends ReceivedStringTotal dividends received (if available)
Account Activity - TotalInterest ReceivedStringTotal interest received (if available)
Account Activity - TotalGain or LossNumberTotal gain or loss
Account Activity - TotalFeesStringTotal fees (if available)
Account Activity - TotalEmployee Before TaxStringEmployee earnings before tax (if available)
Account Activity - TotalEmployer MatchStringEmployer match (if available)
Holdings TableHoldings TableTableTable of holdings with
DateStringThe date of the transaction (e.g., 01/01/2023)
DescriptionStringA description or name for the transaction (e.g., Test)
QtyStringThe quantity or number of units involved in the transaction (e.g., 1)
Unit PriceStringThe price per unit for the transaction (e.g., 200)
TotalStringThe total value or amount of the transaction (e.g., 200)
BuyStringThe amount spent on buying (e.g., 200)
SellStringThe amount received from selling (e.g., 200)
DepositStringThe amount deposited (e.g., 200)
WithdrawalStringThe amount withdrawn (e.g., 200)
Transactions TableTransactions TableTableTable of transactions
DateStringThe date of the transaction (e.g., 01/01/2023)
DescriptionStringA description or name for the transaction (e.g., Test)
QtyStringThe quantity or number of units involved in the transaction (e.g., 1)
Unit PriceNumberThe price per unit for the transaction (e.g., 200.0)
TotalThe 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
                        }
                    }
                ]
            }
        }
    }