n-How to Record Stock Investments in QuickBooks Online
Create an Other Asset account on your chart of accounts to hold the investment, then record the purchase as a transfer from your bank account into that asset account for the amount you actually paid. When you sell, reduce the asset account by its original cost and book the difference between sale proceeds and that cost as a gain or loss.
The full walkthrough
1. Create an asset account for the investment. Go to Settings > Chart of accounts > New. Choose Other Asset (or Other Current Asset if you expect to sell within a year) as the account type, and give it a clear name like "Investments - [Company/Fund Name]."
2. Record the purchase. Use + New > Expense or a bank transfer, with the asset account you just created as the category, for the amount you paid (your cost basis). This moves money out of your bank account and into the investment account, it doesn't post anything to your P&L, since buying an investment isn't an expense.
3. Track the cost basis, not the market value. QuickBooks Online doesn't automatically pull live stock prices or mark the account to market. The balance in that asset account should reflect what you paid, not what it's currently worth.
4. When you sell, record the deposit. Enter the sale proceeds as a deposit into your bank account.
5. Split the deposit between the asset account and a gain/loss account. Reduce the investment asset account by the original cost basis, and record the difference (proceeds minus cost) to an income account like Realized Gain on Investments, or an expense account if it's a loss. This is the step people skip, and it's the one that makes your books actually reflect what happened.
Where this gets harder than it looks
The mechanics above are straightforward for a single, simple purchase and sale. It gets more complicated fast with multiple purchases of the same security at different prices, partial sales, dividends or interest the investment throws off along the way, or unrealized gains you want to reflect at year-end without actually having sold anything yet.
None of that is QuickBooks Online tracking it for you automatically. Every piece, which lot was sold, what the cost basis was, whether a dividend is investment income or something else, is something a person has to work out and enter correctly. For a business holding more than a handful of simple positions, that manual tracking is exactly the kind of thing that quietly eats a bookkeeper's afternoon every quarter.
What we've built on top of QuickBooks investment tracking
Cost-basis tracking outside QuickBooks, synced in
Purchases, partial sales, and lot-level cost basis get tracked in a dedicated spreadsheet or tool, with the resulting gain/loss entries posted into QuickBooks automatically instead of calculated by hand each time.
Automatic gain/loss entries from brokerage data
When a brokerage statement or export shows a sale, the matching QuickBooks entry, split correctly between cost basis and realized gain or loss, gets created without someone doing the subtraction and journal entry manually.
What's the manual part of tracking your investments in QuickBooks?
Cost-basis math, dividend categorization, and year-end gain/loss entries are common pain points, but yours might be something else entirely. Tell us what it is and we'll tell you if it can be automated.
Tracking investments in QuickBooks the manual way?
If cost basis, gains, and losses are living in someone's head or a side spreadsheet instead of syncing cleanly into QuickBooks, that's worth fixing before it becomes a year-end scramble. Tell us how you're tracking it today, and we'll tell you what's worth automating. And this goes well past investments, too: whatever else is manual in your business is fair game.
Let's talk