Tax lots & gain/loss
How Annise tracks each purchase as a tax lot — cost basis, short and long term, realized and unrealized gain or loss, choosing which lots a sale comes from, and editing lots.
Every time you acquire part of a holding, Annise records it as a lot: when you got it, how much, and what it cost. Your cost basis, your unrealized gain or loss, and the gain or loss on each sale all come from a holding's Tax Lots.
How it works
Where lots come from
A lot is created by each transaction that adds to a holding: a buy, the opening balance when an account is first loaded, a transfer in, or a gift received. Its unit cost is the price on that transaction. To change a lot's cost or date, change the transaction that created it.
Selling and which lots are used
When you sell, Annise takes the shares from your oldest lots first (first in, first out). You can choose different lots with Reallocate Shares, below.
Short and long term
A lot held for more than a year is long term. Up to a year, it's short term. A sale's gain or loss takes the term of the lot it came from.
Gain and loss
- Unrealized gain or loss is a lot's value today minus its cost. If there's no market price, the value is blank.
- Realized gain or loss is what you received from a sale minus the cost of the shares sold.
Using it
Seeing tax lots
Open a holding and go to its Tax Lots tab. You can also click a holding's row in Account Holdings to see its lots underneath.
| Column | What it shows |
|---|---|
| Owner | Who owns the lot. |
| Acquired / Tax Term | When it was acquired, and whether it's short or long term. |
| Initial Quantity | How many shares or units it started with. |
| Cost / Unit Cost | What it cost in total, and per share. |
| Current Quantity | How many are left after sales. |
| Current Price | The latest price. |
| Unrealized $ / % | Value minus cost. |
| Value | What the remaining shares are worth. |
For a venture investment, you'll also see Series, # Shares Outstanding and % Bought.
Expand a lot to see its sales: Quantity Sold, Avg. Realized Price, Realized $ / % and Total Proceeds.
Cash, credit cards, lines of credit, mortgages and other liabilities don't have tax lots.
Choosing which lots a sale came from
Under Sell Transactions Data, choose the sale. Under Tax lots to allocate, enter how many shares came from each lot. Allocated and Left to be allocated keep count.
When nothing is left to allocate, click Save. The realized gain or loss and the lots' remaining quantities update.
Editing a lot
For a private asset, you can change a lot's owner and, for a venture investment, its series, directly in the table. Everything else comes from the transaction that created the lot: to change the cost, quantity or date, edit that buy transaction in Transactions. A lot that's had sales can't be edited directly.
Transfers between accounts
When shares move between accounts, you choose which tax lots go with them. The transfer's amount is set to the cost of the lots you chose, so your cost basis and acquired dates carry over.
Troubleshooting
Edit the buy transaction that created it. The lot updates from the transaction.
There's no current price for the holding. For a private asset, add one on its Chart tab or with Price Update.
Use Reallocate Shares to choose the lots yourself.
It appears when the holding has at least one sale and you have Edit.