Investment Portfolio Tracker preview
Holdings register sheet with columns for asset, class, region, currency, units, cost basis, market value, gain/loss, return percentage, target allocation, and drift tracking. 1/4

About this investment portfolio tracker spreadsheet template

This Investment Portfolio Tracker spreadsheet gives individual investors and advisors a structured four-sheet system for monitoring holdings, rebalancing alerts, asset allocation, and periodic portfolio reviews. The Holdings Register captures every position with cost basis, market value, gain/loss, return percentage, and drift from target weights. The Risk & Alerts sheet flags allocation gaps with owner assignments and review dates, while the Allocation Dashboard provides a high-level snapshot of market value and weight distribution across equity, bond, real estate, commodity, and cash classes.

Every sheet is fully editable in WPS Office, Microsoft Excel, Google Sheets, or Apple Numbers. Replace the sample tickers (VTI, VEA, BND, VNQ), update prices manually, adjust target allocations, and customize the review checklist to match your investment policy. The template uses manual closing prices with no external links, keeping your data portable and private.

4 structured sheets

Holdings register, risk alerts, allocation dashboard, and review guide in one workbook.

Fully editable

Replace sample tickers, update prices, adjust targets, and customize the review checklist.

Clean dashboard style

Clear tables and summary views designed for quick portfolio oversight.

Standard XLSX

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Investment Portfolio Tracker template is designed for tracking investment holdings, monitoring asset allocation drift, managing rebalancing alerts, and conducting periodic portfolio reviews. Customize the sample text, layout, and other editable elements in WPS Office for your own project.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the text and structure in a Notion page; for branded visual documents, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder text, tickers, prices, target allocations, and other editable elements with your own portfolio data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for client portfolio reporting, investment advisory presentations, and personal wealth management. It is available for personal and commercial projects, subject to the applicable template license.