Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Retirement Accounts (US) Investment Tracker

An investment tracker for US retirement accounts: holdings, cost basis, gain and allocation against your target, with 3 charts. XLSX with a blank copy.

Dashboard tab: Portfolio value $130,882, Total gain $16,782, Contributed this year $7,800, Furthest from your target US stocks; doughnut chart of Allocation by class; bar chart of Your share vs...Holdings tab: columns Account, Holding, Asset class, Units, Cost basis ($), Price ($), Price date, Value (auto), Gain (auto), Gain % (auto), Price age (auto); 7 sample rows.Allocation tab: columns Class, Value ($), Your share, Your target, Difference (pts), Difference ($), Status; 5 sample rows.Contributions tab: columns Date, Account, Amount ($), Note, Month (auto), Year (auto); 12 sample rows.

DashboardPreviews of the Dashboard, Holdings, Allocation and Contributions tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
6 tabs · 3 charts
Version
1.1 · Updated 7 Oct 2026
Licence
Personal What this means
Checked
Checked before it ships
  • retirement-accounts-us-investment-tracker.xlsxXLSX · 56 KB
  • retirement-accounts-us-investment-tracker-blank.xlsxXLSX · 54 KB
  • retirement-accounts-us-investment-tracker.csvCSV · 745 B
  • LICENSE.txtadded to every download

About this item

An investment tracker for US retirement accounts. It has 6 tabs: Start Here, Dashboard, Holdings, Contributions, Allocation, Settings. Type each holding with its units, what you paid and today's price; nothing updates prices by itself, so you type the price and its date. The Dashboard with 3 charts shows your portfolio value ($130,882 in the sample data), your total gain, what you contributed this year and which asset class is furthest from the target you set. Allocation compares your share in each class with your own target and says Above your target, Below your target or Within your band. Allocation also totals your value by account, with the account types listed in Settings. It tracks your numbers; it is not financial advice. You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab