What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Record Stock Investments in QuickBooks Online
QuickBooks Online

Stock Investments in QuickBooks Online: How to Record the Buy, the Dividends and the Sale

Shares the business owns are an asset, so buying them doesn't touch your profit and loss. Give the investment its own asset account, move what you paid into it from the bank, and let only dividends and the gain or loss on a sale reach income. QuickBooks Online won't track the share price, so the account holds what you paid.

The three entries

Set up the account: type Other Current Asset if you expect to sell within a year, Other Asset if not, named for the holding or the brokerage.

Chart of accounts New

Record the buy: an expense or check from the bank account, with the investment account as the category, for what you paid.

+ New Expense

Record the sale: a bank deposit for the proceeds, split between the investment account (the cost) and a gain or loss account (the rest).

+ New Bank deposit

Recording a holding from the day you buy to the day you sell

  1. 1

    Create the investment account

    Chart of accounts New

    Pick the asset type and name it clearly, such as "Investments - Brokerage". Holding several stocks? Make one parent account and a sub-account per holding, so each one's cost is visible. Which type suits your holdings is generally your accountant's call.

  2. 2

    Record the purchase at cost

    + New Expense

    Pay from the bank account that funded the trade and choose the investment account as the category. Use the total cost from the trade confirmation. Whether commissions go into that cost is generally something to confirm with your accountant.

    Watch for: the category. Picking an expense account here puts the whole purchase on your profit and loss.

  3. 3

    Book cash dividends as income

    + New Bank deposit

    When a dividend lands in the bank, deposit it to an income account such as Dividend Income, usually set up as other income. It doesn't change the investment account.

  4. 4

    Reinvested dividends need a journal entry

    No cash reaches the bank, but the business now owns more shares. A journal entry that debits the investment account and credits Dividend Income records both sides.

  5. 5

    Split the sale deposit

    + New Bank deposit

    Deposit the proceeds. On one line, take the cost of the shares sold out of the investment account. On a second, put the difference in a gain account such as Realized Gain on Investments, or a loss account if you sold below cost.

    Watch for: partial sales. Only the cost of the shares you sold comes out, and with several purchases at different prices, the broker's cost basis report tells you which figure that is.

One sale deposit, taken apart

The bank sees one amount. QuickBooks needs to know how much was your own money coming back.

Example: 100 shares bought for $5,000 and sold for $6,200, figures for illustration only
Sale proceeds deposited (From the broker, after its fees) $6,200
Line 1: investment account (The original cost, taking the account back to zero) − $5,000
Line 2: Realized Gain on Investments (The only part that reaches income) $1,200

Sold for $4,300 instead? Line 1 still removes $5,000, and Line 2 becomes a $700 loss. In a deposit that's a negative amount on the gain account, or a positive one on a loss account if you keep them separate.

Which entry each brokerage event calls for

On the brokerage statement In QuickBooks Online Watch for
Shares bought Expense or check to the investment account Not an expense account, whatever the bank feed suggests
Cash dividend paid out Deposit to Dividend Income Interest on cash in the account is income too, often kept separate
Dividend reinvested Journal entry: investment account up, income up Easy to miss, since no cash moves
Shares sold Deposit split between cost and gain or loss Partial sales of several purchases
Account fee or margin interest Expense Check the tax treatment with your accountant
Market value up or down Nothing, unless your accountant asks for it It's unrealized until you sell

Owner's money, value changes and where investments sit

What is owner's investment in QuickBooks, and is it the same as what this page covers?

It's different. Owner's investment is you putting your own money or property into the business, so it's an equity entry, usually to an owner's contribution or paid-in capital account. This page is about the business buying shares with its own cash, which moves money from one asset (the bank) to another (the investment). One changes equity, the other changes what the business owns.

How do I record a change in the value of an investment in QuickBooks?

QuickBooks Online doesn't do it for you, and many small businesses leave the account at cost until they sell. If your accountant wants year-end values shown, it's generally a journal entry between the investment account and an unrealized gain or loss account, kept apart from the realized gains you book on actual sales.

How do I categorize investments in QuickBooks?

The investment sits in an Other Asset or Other Current Asset account on the balance sheet, never an expense account. Dividends and interest go to income accounts when they're received, and a sale's gain or loss goes to its own account, so the investment account only ever shows cost.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.