Portfolio intelligence and reporting
8 minute readFoxgold
A private workspace for Australian and US portfolios, connecting broker evidence, holdings, source-backed research, saved daily reports and historical monthly reviews.
Overview
The project at a glance
The problem Investment records arrive in different forms and at different times. Broker statements describe recorded positions; quotes describe a market session; issuer reports and adviser emails provide evidence. A useful overview needs to bring them together while keeping those differences visible.
What I built I designed and developed FOXGOLD, a private Next.js and Supabase workspace for AU and US holdings, broker imports, statement history, source-backed due diligence, a portfolio copilot, saved daily email reports and historical monthly reviews. A separate landing-page preview introduces the product and invitation-only access.
What needed care Current prices cannot reconstruct the quantities held in the past. Report dates, trading sessions, evidence windows and delivery status need separate meanings. Deterministic calculations, source links, frozen review evidence and workspace access controls keep the numbers and their interpretation traceable.
What it makes possible Users can move from an overview to individual holdings, recorded activity and supporting documents, then revisit the exact context of a saved report. The application supports investigation and understanding; investment decisions remain with the user. All case-study holdings, prices, assessments and figures are demonstration data.
Brief
Bring the portfolio and its evidence into one workspace
FOXGOLD is a private portfolio intelligence application for Australian and US investments. Its purpose is to make a portfolio easier to understand: what is held, how its value has moved, what the records support and which research deserves a closer look.
I built the interface and the connected data workflows, from broker evidence and holdings reconciliation through to source-backed research and reporting. Portfolio Overview provides the daily entry point; specialist views handle holdings, transactions, statement history, due diligence, monthly reviews and documents.
The important distinction is between a useful summary and the evidence needed to explain it. A current quote, a broker statement and a historical review can all be valid while describing different dates and scopes. The application keeps those contexts visible as the user moves between them.
- A private workspace for AU and US portfolio information
- Connected holdings, statement evidence, research and reports
- Dates and source context carried through the experience
- A clear path from the daily overview into specialist views
Landing
Explain the product before asking for access
The landing-page preview at /landing introduces FOXGOLD through the questions a prospective user is trying to answer: where their investments stand, which research supports an assessment and how to review the information later.
An illustrative workspace gives the product a recognisable shape without exposing a client account. The page connects portfolio visibility, source-backed research, regular reviews and document history, then explains the path from bringing records together to investigating the detail.
Access is invitation only. The enquiry asks for a name, email, optional organisation and the workflow the person wants to improve. Submitting it requests a conversation; it does not create a trading account or workspace. The preview is presented here as the product’s introduction, separately from the populated application screens that follow.
- An illustrative product preview alongside the working application
- An invitation request with useful workflow context
- Matching light and dark presentation
- Invitation-only access explained before an enquiry is submitted
Holdings
Start with the wider picture, then inspect a position
Portfolio Overview combines invested market value, recorded cost, unrealised profit or loss and current holding movement. Charts show recorded value or clearly labelled estimates, while contributors and allocation help identify where the portfolio’s exposure sits.
The Holdings view makes that summary inspectable. A position has a quantity, cost base, dated price, market value, portfolio weight and movement figures. Search, gain/loss filters and category views help the user find a company or compare groups before opening a holding’s analysis.
AU and US market selections retain their own currency, exchange, benchmark and timezone context. The application does not produce a meaningful combined total by simply adding Australian and US dollar balances. Current-holdings price movement is also kept distinct from an account return that would need cash, income and trading flows.
- Move from portfolio totals to the holdings behind them
- Search and compare cost, value, weight and movement
- Preserve market, currency and quote-date context
- Keep current price movement distinct from account returns
Statements
Make changes explainable through broker evidence
Broker statements establish recorded positions at a point in time. Import and reconciliation workflows bring that evidence into the application so the current portfolio can be checked against supplied records rather than rebuilt from guesses.
Portfolio History compares statements within an explicit evidence window. The timeline highlights material quantity changes, additions or removals, and gives access to the statement library and individual position records. Transactions retain dated buys, sells, income, fees and other recorded activity as a separate ledger.
A change in statement value is not automatically an investment return: purchases, disposals, deposits or withdrawals can contribute. The interface calls out that boundary. Source files, statement dates and recorded transactions give the user a practical way to investigate why one period differs from another.
- A statement library with dated positions and source references
- A timeline of material holding changes
- Transaction activity kept separate from price movement
- Check differences against the original statement files
Research
Keep the assessment close to its supporting sources
Due Diligence presents published company assessments with their date, review type, evidence coverage and outstanding gaps. A review inbox makes it possible to move between holdings without losing the structure of the assessment.
The scorecard breaks the result into criteria such as operating performance, financial resilience and cash generation. Evidence notes retain report and page references; the evidence view carries the accompanying narrative and limitations. Informational recommendations are governed by the recorded evidence and applicable rules rather than displayed as unexplained AI opinions.
Source-backed facts and financial validation have a different role from generated interpretation. The system helps organise and assess the material, while missing evidence remains a visible limitation. The case-study example uses fictional companies and a scripted assessment solely to show how a populated review is read.
- Dated assessments with explicit evidence coverage
- Criteria and source notes behind the headline score
- Evidence gaps remain visible instead of becoming certainty
- Report and page references support closer investigation
Monthly
Revisit a completed month on its own terms
Monthly Review brings the period’s portfolio evidence, holding assessments, activity, reporting dates and source register into one web presentation. The overview places the performance table beside recorded allocation, with deeper sections for investigating individual holdings and transactions.
Historical reviews retain their captured evidence. A later price refresh or newly uploaded document does not silently turn a closed month into a different report. Benchmark comparisons require matching period dates, and older reviews show explicit unavailable fields when their original format did not capture a metric.
The monthly area in Documents uses the same web presentation, so a review has a consistent reading experience wherever it is opened. PDF output is available as a separate reporting format. This keeps the narrative, figures and underlying evidence connected while preserving the meaning of the original period.
- A compact overview with performance and recorded allocation
- Searchable holding assessments, activity and sources
- Frozen historical evidence and period-aligned comparisons
- A consistent web review with a separate PDF format
Daily
Save the report before sending the email
Daily reporting is designed to leave a record the user can reopen. A scheduled digest is saved before delivery, and Performance → Daily opens its captured holdings, prices and movement figures. The trading session, capture time, timezone and delivery status are shown separately.
The digest covers the latest available session, holding movement, gainers and declines, source-linked headlines and upcoming reporting dates. Weekends use the latest available trading session and label it. Missing comparable quote coverage stays unavailable; it does not become a fabricated zero or a ranked performer.
Stored report content is separate from email-delivery metadata and the dated inputs used for financial calculations. A saved report therefore does not by itself mean the email was delivered. Users can also create an explicit report capture without sending email, while current portfolio PDFs remain on-demand exports.
- Reopen the figures associated with a particular daily report
- Distinguish report date, market session and capture time
- Keep immutable report content separate from delivery status
- Capture a report explicitly without sending an email
Library
Give original documents and reporting dates a clear home
Documents opens with four areas: monthly reviews, original company reports, FOXGOLD research and broker originals. The layout gives each kind of evidence its own entry point instead of mixing source files and generated interpretations into one undifferentiated list.
An upcoming-reporting timeline sits alongside the library on desktop and moves below it on smaller screens. Confirmed reporting dates and estimated windows are labelled differently, with issuer-source links where available. A forthcoming date is a reason to follow up; it is not evidence that the result has already been published or analysed.
The application also preserves dated broker commentary as third-party material. Holding pages link to their latest original document and completed assessment. Together, these routes make it easier to trace a portfolio observation back to the document, period or reporting event that gives it context.
- Separate original files, generated research and monthly reviews
- Confirmed and estimated reporting dates labelled distinctly
- Source context accessible from the portfolio and holding views
- Link each holding to its latest original report and assessment
Copilot
Ask questions without leaving the portfolio context
Portfolio Copilot can be opened from across the application. It is designed to inspect relevant portfolio records, explain comparisons and help the user find the next source or view worth checking.
Its tools cover holdings, transactions, performance, statements, reporting events, research and operational report context. The current market, currency, position weights and dated figures provide scope for the conversation. The prompt and tool boundaries require gaps to be called out and distinguish recorded facts from unsupported explanations for a price move.
For example, a concentration question can identify the largest recorded positions and explain what additional evidence would be needed to assess overlap. The screenshot uses a scripted demo conversation with fictional holdings; it demonstrates the actual chat interface without presenting an invented live AI run as a verified result.
- A portfolio-scoped assistant available from the working screen
- Tools for inspecting relevant records and their context
- A clearly labelled scripted conversation for the case study
- Call out missing evidence and unsupported explanations
Trust
Build the records, calculations and access boundaries together
FOXGOLD uses Next.js and React for the application, with Supabase authentication, workspace membership and row-level policies controlling access to private data. Financial writes are role restricted and validated on the server. External quote and research sources enrich the workspace without becoming authority to rewrite broker evidence.
Financial calculations and import validation remain deterministic. AI supports document interpretation and investigation, while dated evidence and report snapshots preserve what was available at the time. The application is informational; it does not place trades on the user’s behalf or require the client to operate the legacy order and approval concepts found in older parts of the codebase.
The images use actual source components with synthetic API fixtures. Companies, positions, prices, statements and assessments are fictional, and the Copilot conversation is scripted. Real operational API responses and external requests were blocked during capture. Light and dark versions show the same examples, not different client accounts.
- Workspace access enforced beyond the visible interface
- Deterministic arithmetic alongside AI-assisted interpretation
- Private client records excluded from every demonstration image
- Role-restricted financial writes validated on the server
The result
Users can move from an overview to individual holdings, recorded activity and supporting documents, then revisit the exact context of a saved report. The application supports investigation and understanding; investment decisions remain with the user. All case-study holdings, prices, assessments and figures are demonstration data.
Good work starts with the right conversation.
Let's talk about your projectGallery
The project in pictures
A different challenge. The same care.
View all work