Format: Downloadable list/statement based on selected date range
Data: All cash and investment transaction data
File: CSV (optional PDF would be good, but CSV first)
Example format: As an example see Vanguards report generator for āclient transaction dataā
A CSV of all data I think would provide the most value for return on development work as its the most versatile format. But it is potentially more complicated for some investors to use. I recon it would be of more benefit than not however. A PDF that could be generated would also be valuable for me, however, a CSV allows everyone to generate their own reports in any way they wish.
CSV / PDF example
Example from Vanguard of their PDF generates transaction data
CSV example from Vanguard of this includes a tab for each account type with the following tables
Cash Transactions
- Date
- Details
- Amount
- Balance
These fields encompass, deposits, withdrawals, dividends, fees, buy/sell from/to cash/investments. anything related to cash changes.
Investment Transactions
- Date
- Investment Name
- Transaction Details
- Quantity
- Price
- Cost
Additional fields that would be useful
These fields encompass all trade/investment related data for each buy/sell
Of the two table types, I think the investment transactions are the most important ones
Example from the spread sheet (partial investment transactions)
Example of the cash transaction table
UI Example
I included some screenshots of the Starling bank UI for statement generation which I think is probably one of the better ones Iāve seen imo. Something like this would be very nice to allow us to specify date ranges for CSV downloads or statement downloads.
Additionally the other thread also links to other related topics that im sure youāve already seen Documents & Reporting