The Explorer is a spreadsheet-style data grid for browsing, filtering, and bulk-editing your portfolio data in one place. Instead of opening holdings one at a time, you pick a type of data to view, narrow it with filters, choose the columns you care about, and then read, edit, or export the whole table at once.

Explorer is built from the data you’ve already entered — your holdings, owners, price updates, files, and accounting activity — so it reflects whatever is in your portfolio right now. See Adding Your Data for how that data gets in.

Find what you need#

This page covers the whole Explorer — the data you can browse, the controls in the bar above the table, and what each row lets you do. Almost nobody reads it end to end, so start with the five ideas below and jump to the section that answers your question.

  • You browse one type of data at a time. Explorer opens on a selection screen of tiles, and the tile you pick decides what a row in the table is. Several of the tiles are the same events seen at different grains — one activity is one row on Activities and several rows on the tiles that hold its parts — so switching tiles is how you change the question, not just the view. See Choose what to look at (tiles) and Look at your position movements.
  • Filters and column choice are what make a table usable. Filtering happens on two levels — which holdings the table draws from, and which rows within those holdings — and a separate panel decides which columns show and in what order. Sorting, search, and running totals come for free on top. See Filter the data, Choose and arrange columns, and Read and sort the table.
  • Edits happen in the grid, one cell or many rows at a time. Turn on Edit Mode and editable cells become editable in place; select rows and you can change them all together. Some tiles and some columns are read-only here, which is the usual answer to “why can’t I edit this?”. See Edit and bulk-edit rows.
  • Every row leads somewhere. A row’s actions menu opens the record behind it, the holding it’s filed under, or the related tile — so you can follow a number back to the event that produced it and come back to the same table afterwards. See Drill between related data.
  • A table you’ve set up is worth keeping. The filters, columns, and sort you arranged can be saved as a named view you reopen from the selection screen, and copy and export both take the table exactly as it looks on screen. See Save a view and Copy and export.

I want to change what I’m looking at

I want to change my data

I want to follow a row to what it relates to

I want to get the data out

Something isn’t there, or won’t let me change it

Who can use the Explorer#

The full Explorer is an admin tool, available to portfolio members with the admin role. If you aren’t an admin, you can still open Explorer through links elsewhere in the app that point you at a specific record — a link that shows the activities, postings, lot activities, position movements, or price updates for one holding. Those scoped views work for everyone; opening Explorer on your own without such a link shows an access message instead.

Choose what to look at (tiles)#

When you open Explorer you land on a selection screen. The top of that screen shows the data type tiles — each tile is one kind of data you can browse:

  • Price Updates — the price history you’ve recorded for your holdings.
  • Portfolio Items — your holdings themselves (assets, cash accounts, liabilities, brokerage accounts).
  • Owners — the people and legal entities that hold your assets.
  • Deals — pre-investment holdings that are still in your pipeline (anything with a deal status set), kept separate from your funded positions.
  • Activities — the money activity on your holdings: buys, sells, dividends, transfers, and so on (see Activities).
  • Postings — the individual money lines that make up an activity.
  • Lot Activities — the lot-level changes that make up an activity.
  • Position Movements — the quantity changes that make up an activity: how many units of a holding each activity added or removed (see Look at your position movements below).
  • Files — the documents stored in your portfolio.

Tap a tile to open that data as a table. Below the tiles, the same screen lists your saved views (covered below), so you can jump straight back into a view you set up earlier.

There is no longer a separate Transactions tile — money activity is the Activities tile. Saved views and links that were created against the old Transactions tile open on Activities instead, scoped the same way.

Once a table is open, the Data Type button in the control bar (the database icon) takes you back to this selection screen so you can switch to a different tile. That button is part of the admin Explorer, so it isn’t there when you arrived through a link that pointed you at one record.

Look at your position movements#

Activities, Postings, Lot Activities, and Position Movements are four views of the same events, each one row per part:

  • An activity is the whole event — a buy, a sell, a dividend.
  • Its postings are the money lines: what was debited and credited, and to which account.
  • Its lot activities are the tax-lot changes: which lot gained or lost units, at what cost basis.
  • Its position movements are the quantity changes: the authoritative record of how many units of a holding the event added or removed (the same records you see in the Position Movements section of an activity).

Open the Position Movements tile when the question is “how did my unit count get here?” — for example, to see every movement that built up a share position over a quarter, to check that an imported split changed the unit count you expected, or to find the event behind a holding whose quantity looks wrong.

Each row shows the Portfolio Item whose quantity moved and a Units Delta — positive when the event added units, negative when it removed them. Unit counts are shown to enough decimal places for fractional and crypto-sized positions to read correctly rather than rounding away to zero.

Alongside those, each row carries its parent activity’s details, so you can read a movement without leaving the tile: Activity ID, Activity, Trade Date, Settlement Date, Status, Book, Description, Activity Notes, and a one-line Activity Summary. Rows that came in from a connection also carry an Integration Data ID, which is how you trace an imported movement back to the record it was created from.

Two columns name a holding and they can differ, which is the point of having both:

  • Portfolio Item is the holding whose units actually moved — the movement’s own line item.
  • Portfolio Item ID (Attribution) is the holding the whole activity is filed under.

For a transfer between two holdings, for example, the two movements name different portfolio items while sharing one attribution.

Position Movements is a read-only view: you can filter, sort, arrange columns, save it as a view, copy it, and export it, but there’s no Edit Mode on this tile (see Edit and bulk-edit rows).

Read and sort the table#

Each tile opens as a table of rows. A few things are automatic:

  • Sorting. Tap a column header to sort by it; tap again to reverse the direction. Explorer remembers your sort for each tile separately and restores it the next time you come back. New tables start sorted by date, newest first.
  • Totals. Number, currency, and percent columns show a running total in the header — a sum for amounts and an average for percentages — so you can see the bottom line for the rows currently in view.
  • Search. The search box in the control bar filters the table down to rows matching what you type, on top of any filters you’ve set.

The date-based tiles (Price Updates, Activities, Postings, Lot Activities, and Position Movements) open with the last three months of data already in view, so you start with a manageable window instead of your entire history. Widen or change that range with filters — and if you clear your last filter on one of those tiles, it drops back to the three-month window rather than trying to load everything you own.

Large tables load in batches, so rows keep filling in for a moment after the table first appears.

Filter the data#

Tap the Filters button (the funnel icon) in the control bar to open the filter panel and narrow the table.

There are two layers of filtering, and you can combine them:

  • Holding-level filters narrow which holdings the table draws from — for example, by owner, tags, type, or account.
  • Row-level filters narrow the rows within those holdings — for example, an activity type, a trade date range, or a price-update source.

You don’t have to think about the two layers separately; you just add the filters you want and Explorer applies them to the right level. For example, on the Activities tile you might filter to one owner’s holdings (a holding-level filter) and then to just “Buy” activities in a date range (row-level filters).

Many columns also offer a quick header filter: open a column’s filter to pick from the values that appear in that column. Header filters stack on top of the main filters and are saved with a view.

Choose and arrange columns#

Tap the Columns button (the columns icon) to control what the table shows:

  • Show or hide columns by toggling them on and off.
  • Reorder columns by dragging them into the order you want.
  • Add custom columns (on the Portfolio Items tile only). You can add a holding field, a built-in statistic, or one of your portfolio’s configurable statistics as its own column. Custom columns apply to Portfolio Items; they clear automatically if you switch to another tile.

Each tile offers its own set of columns, so the list in this panel changes when you switch data types.

Your column choices are part of a saved view, so a view can carry its own layout and custom columns.

Activity details on Postings, Lot Activities, and Position Movements#

The three tiles that show the parts of an activity — Postings, Lot Activities, and Position Movements — carry their parent activity’s details on every row: Activity ID, Activity, Trade Date, Settlement Date, Status, Book, Description, Activity Notes, Source Upload ID, and an Activity Summary that puts the activity type, date, holding, and description on one line.

That means you can search, filter, sort, and export these tiles on the activity’s own details without hopping over to the Activities tile — for example, sort every posting by its activity’s trade date, or filter lot activities down to one activity type.

These borrowed columns are read-only everywhere they appear. An activity’s type, dates, status, description, and notes belong to the activity itself, so you change them on the Activities tile and every one of its parts picks the change up.

On Activities, the reverse view is available: each row counts its own parts in the Posting Count, Lot Activity Count, and Position Movement Count columns, and totals its debit legs under Amount — a quick way to spot an event that is missing a leg.

Edit and bulk-edit rows#

Explorer can edit your data in place, not just display it.

Most tiles are editable. Position Movements and Files are read-only — there’s no pencil in the control bar on those two, because there’s nothing on those rows to change from here. To change what a position movement records, edit the activity it belongs to on the Activities tile.

  1. Tap the Edit Mode button (the pencil icon) in the control bar. The pencil turns into a save indicator and the table becomes editable.
  2. Edit a single cell by tapping it and changing the value.
  3. Select rows by tapping their checkboxes. Hold Shift while clicking to select a whole range at once.
  4. To change many rows the same way, open Batch Change, set the fields you want, and apply them to every selected row.
  5. Tap Save (the floppy-disk icon, which replaces the pencil while you have unsaved edits) to write your changes.

Not every column is editable, even on an editable tile. Cells you can change open a text box, a date picker, or a picker list when you tap them in Edit Mode; the rest stay as plain text. Roughly:

  • Activities — the event’s own details: holding, activity type, trade and settlement dates, status, description, notes, source upload, and the Duplicate Of ID column described below.
  • Postings — the money line itself: Account, Amount, Direction, and the posting’s own Notes. (Notes is the posting’s note; Activity Notes is the note on the whole event, and is read-only here.) The account picker only offers accounts in the activity’s book.
  • Lot Activities — the lot line itself: activity type, lot, holding, acquisition date, basis change, proceeds, and units delta.
  • Portfolio Items, Deals, Owners, and Price Updates — their own fields, as you’d expect.

A few things to know while editing:

  • Partial save. If some edited rows have problems (for example, a required value is missing or an activity doesn’t balance), Explorer saves the rows that are valid and keeps the problem rows in edit mode with a warning, so one bad row doesn’t block the rest.
  • The Save button tells you what it will do. Hover it and the tooltip says how many valid rows will be saved and how many are blocked. If nothing can be saved yet, the button is disabled and says what to fix first.
  • Delete. You can delete selected rows from the same batch actions.
  • Unsaved changes are protected. If you try to navigate away with edits still pending, Explorer warns you first.
  • Large edits are handled for you. Big batches are saved in chunks behind the scenes; you just tap Save once.

Editing Postings or Lot Activities updates the activity they belong to, since those rows are parts of a single structured event.

Mark a row as a duplicate#

The Activities tile carries an editable Duplicate Of ID column for marking one row as a duplicate of another — the same duplicate concept covered in Activities. A duplicate is kept for your records but left out of your statistics, so it stops double-counting without losing the history.

The column holds the ID of the original record this row duplicates:

  • Type an ID into the cell (in Edit Mode) to mark the row as a duplicate of that record.
  • Clear the cell to remove the mark and bring the row back into your statistics.

The mark is saved like any other cell edit when you tap Save, and it is checked when you save: an invalid target — the row itself, a missing record, a record in another portfolio, or a record that is already a duplicate — is rejected.

Explorer’s tables stay plain while you work, so a duplicate-marked row is not dimmed or badged in the grid; only the Duplicate Of ID cell shows the mark. The dimmed appearance and Duplicate badge described in Activities appear on the event’s card elsewhere in the app (for example in search results or on a holding), not in this data grid.

Every row has an actions menu, and what it offers depends on the tile:

  • From an Activity — open its Postings, open the activity’s own details in a pop-up without leaving the table, jump to the holding it’s filed under, or — if Tasks is turned on for you — create a task linked to it.
  • From a Posting, Lot Activity, or Position Movement — open the parent activity’s details in a pop-up, open the Activities tile filtered to that one activity, or jump to the holding the row belongs to.
  • From a Portfolio Item or Deal — open the holding’s detail screen, or open its Activities or Price Updates in Explorer.
  • From an Owner — open the owner’s detail screen, or open the Portfolio Items they hold.
  • From a Price Update — jump to the holding it prices.
  • From a File — preview the document in place.

When a row action takes you to a detail screen, coming back returns you to the same Explorer view, with your filters and columns as you left them.

“Go to parent” means slightly different things on different tiles, matching what the row is about: on Postings it opens the holding the whole activity is filed under, while on Lot Activities and Position Movements it opens the holding that row’s own units or lot belong to. If a row has no holding to open — which happens on an event that isn’t filed under one — the action is greyed out rather than taking you nowhere.

Most menus also carry Show Validation Error, which spells out what Explorer has flagged on a row it won’t save.

Save a view#

Once you’ve set up a tile the way you like — its filters, columns, header filters, and any custom columns — you can keep that setup as a saved view so you don’t have to rebuild it.

  1. Set up the tile (choose the data type, apply filters, pick and arrange columns).
  2. Tap Save View (the camera-style button) in the control bar.
  3. Give the view a name (and optionally a description and folder), then save.

Your saved views appear on the Explorer selection screen, below the data type tiles. Open one to return to exactly that data type, filters, columns, and header filters. You can update a view in place or save a new one, and you can delete views you no longer need from the selection screen.

Copy and export#

When you want the data outside Explorer:

  • Copy table (the copy icon) puts the visible table on your clipboard so you can paste it straight into a spreadsheet.
  • Export (the download icon) opens a dialog where you choose a file name (pre-filled with your saved view’s name, or the data type when you’re not in a saved view) and an export type:
    • CSV — a plain data file for spreadsheets.
    • PDF — a formatted document; you can optionally turn on alternating row colors for easier reading.

Both copy and export use the table exactly as you’ve arranged it — the same filters, columns, and sort order you’re looking at.

Refresh#

Tap Refresh (the refresh icon) to reload the current tile from the latest data — useful after you’ve made changes elsewhere in the app and want Explorer to catch up.

Backward Reports Cash Planning Forward
Trac Docs - © 2026 by TKO Productions, LLC