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.
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 › NewRecord the buy: an expense or check from the bank account, with the investment account as the category, for what you paid.
+ New › ExpenseRecord 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 depositRecording a holding from the day you buy to the day you sell
- 1
Create the investment account
Chart of accounts › NewPick 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
Record the purchase at cost
+ New › ExpensePay 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
Book cash dividends as income
+ New › Bank depositWhen 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
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
Split the sale deposit
+ New › Bank depositDeposit 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.
| 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
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.