Skip to main content

Track your investments

Securities, holdings, trades and tax lots, on the same ledger as everything else — in the currency each one trades in.

All how-tos

  1. 1

    Create a brokerage account and a securities account

    In Finance, Add account of type Brokerage — or Create financial account in Book setup, under Settings → Books — adds the cash at the broker: the control account it posts through is where that cash sits in the ledger. Beside it a household book's chart already has 1500 · Investments, an asset account of its own — not any bank's or broker's — to carry what the securities cost (in a business book, create one); create another only to keep a broker's securities apart (a code already in the chart is named as you type it). Every trade moves money between the two, so the cash leg and the securities leg stay in balance.

  2. 2

    Record the securities you hold

    Under Investments, Record a security names each instrument once: its name and its kind — equity, fund, debt, derivative, commodity or other. The currency comes with each trade, not the security. A security is recorded once for the book, so two brokerage accounts holding the same fund share one record.

  3. 3

    Open a holding

    A holding is one security in one brokerage account. Open a holding for each pair; a short position is refused unless you allow it on that holding, under More details, so a mistyped sale cannot take a position below zero unnoticed.

  4. 4

    Post a trade

    With the holding selected, Post a trade records a buy or a sale: the currency, the quantity, the price per unit, the gross cash amount, the trade and settlement dates, the brokerage account it settles through and the securities account that carries the cost. The form starts on today's date, settlement the same day, the holding's own brokerage account, the chart's 1500 · Investments and a gross of the quantity times the price; change any of them. It becomes one balanced journal entry — securities on one side, cash on the other — and the holding's quantity follows. An Interactive Brokers Flex connection, under Settings → Connections, brings the account's cash movements in for review like a bank statement; its trades come in flagged, to be posted here. A brokerage account's statement file is imported under Inbox → Statement imports as a bank's is, and keeps its Original file the same way.

  5. 5

    Reverse, never edit

    A trade posted wrongly is reversed from its line under the holding, with a date and a reason, in the period the date falls in — the reversal is a new event, the original stays on record, and the quantity is what the two together say. Each holding also lists its tax lots — the date, the quantity remaining and the basis remaining, from which a sale's gain is taken — but a trade posted here records the quantity and the cost, not tax lots, so the list stays empty.

  6. 6

    A bond's terms and its ladder

    Record a security of kind Debt — its Issuer country with it — open a holding and buy it as above. Then, with the holding selected, Record bond terms takes the date it was Issued on and Matures on, the Face per security and its currency, the Coupon rate and how often Coupons are paid, and shows What each security pays — every coupon and the principal — for you to check before Record terms keeps them. Investments then offers Fixed income: the Next maturity, what is due in the Next 12 months, and the Maturity ladder.

  7. 7

    Record income

    With a holding selected, Record income records a dividend, interest or a coupon paid on it: the Gross amount, the Tax withheld and who it was Withheld by, the Fees, and the account in the book's currency it was Paid into — Received is what is left. Paid into offers only accounts in the book's currency: income paid into an account in another currency cannot be recorded in the app yet. It posts to the books at once, joins the holding's events, and Income & lots then shows what each holding paid.

  8. 8

    Record what it is worth

    Record a market value keeps what a holding was worth on a day: the Quantity held, the Market value and its currency, and Where the value comes from. With a value and an issuer country recorded, Holdings shows the Market value and the Allocation by kind and issuer country — and, for a holding with known tax lots, what is Unrealized.