This guide walks you through setting up investment accounts in QuickBooks Pro so you can track stocks, bonds, and other securities alongside your regular business finances. You’ll learn how to create the right account types, record buys and sells, and handle dividends and interest. Before you start, make sure you have your brokerage statements handy and know the cost basis of any investments you already own.
What You’ll Need
- QuickBooks Pro installed and open (any recent version)
- Your brokerage account statements showing current holdings and cost basis
- Your QuickBooks company file (the one you use for your business)
- A list of the securities you hold, including ticker symbols or names
Step-by-Step
- Open the Chart of Accounts. Go to the Lists menu and select Chart of Accounts (or press Ctrl+A on Windows). This is where all your accounts live.
- Create an investment account. Click the Account button in the bottom-left corner and choose New. Select Other Account Types, then choose Brokerage Account (or Investment Account if available). Name it something like “Brokerage – Vanguard” or “Investment Account.”
- Set up the account detail. In the New Account window, enter the account number from your brokerage statement (optional but helpful). Leave the tax line mapping as default unless your accountant has specified otherwise. Click Save & Close.
- Add the securities you own. From the Chart of Accounts, double-click your new investment account to open its register. In the register, click the Add New Securities button (or go to the Investing menu and select Securities). Enter each stock, bond, or mutual fund with its ticker symbol and name. QuickBooks Pro may not automatically fetch prices—you’ll enter those manually.
- Record your opening balances. If you already own investments, you need to enter them as an opening balance. In the investment account register, click the Add New Transaction button. Choose the transaction type “Shares Bought” (or “Opening Balance”). Enter the date you acquired the shares, the security, the number of shares, and the cost basis (what you originally paid, including commissions). This creates an offsetting entry to an equity account like “Opening Balance Equity” or a capital account.
- Record a stock purchase. When you buy more shares, go to the Investing menu and select Buy Shares (or click the Buy button in the register). Enter the date, the security, the number of shares, the price per share, and any commission. QuickBooks will calculate the total and ask which account to draw the cash from—usually your checking or money market account. Click Save.
- Record a stock sale. Go to the Investing menu and select Sell Shares. Enter the date, the security, the number of shares sold, the sale price per share, and any commission. QuickBooks will compute the gain or loss automatically and ask where to deposit the proceeds. Choose your checking account or a money market account. Save the transaction.
- Record dividends and interest. When you receive a dividend, go to the Investing menu and select Receive Dividend (or Record Dividend). Enter the date, the security, the amount, and whether it’s a cash dividend or reinvested (DRIP). For cash dividends, QuickBooks will debit your checking account and credit a dividend income account. For reinvested dividends, it will buy more shares automatically. Save.
- Track interest earned. If your brokerage pays interest on cash balances, record it as a regular deposit: go to the Banking menu, select Make Deposits, and choose the investment account as the source. Categorize it as Interest Earned.
- Reconcile regularly. Once a month, compare your QuickBooks investment account balance to your brokerage statement. Use the Reconcile feature (Banking > Reconcile) to match transactions. This catches missing or duplicate entries.
Common Mistakes
- Using a regular bank account instead of a brokerage account. This prevents QuickBooks from tracking cost basis and gains properly.
- Forgetting to enter the opening balance. If you skip this, your investment account starts at zero and your balance sheet will be wrong.
- Mixing personal and business investments. QuickBooks Pro is designed for business use. If you’re tracking personal investments, create a separate company file or use a personal finance tool.
- Entering the total value instead of cost basis. The cost basis is what you paid, not what it’s worth today. Using market value as the opening balance inflates your equity.
- Ignoring reinvested dividends. A DRIP is a purchase and must be recorded as such, or your share count will be wrong.
Tips
- Set up a memorized transaction for monthly dividends if they’re consistent—it saves time.
- Use the Class or Customer fields to track which project or department the investment income belongs to, if relevant.
- Keep your brokerage statements in a folder near your QuickBooks file for easy reference during reconciliation.
- If you have many securities, consider using the QuickBooks Online version with a brokerage feed—Pro doesn’t auto-download prices.
- Review your unrealized gains report (Reports > Investing > Unrealized Gains) quarterly to see how your portfolio is doing.
Troubleshooting
My investment account doesn’t show up in the Investing menu. Make sure you created it as a Brokerage Account, not a regular bank account. If you already created it wrong, you can edit the account type in the Chart of Accounts (right-click > Edit Account).
I can’t find the “Add New Securities” button. In some versions, it’s under the Investing menu > Securities. If it’s missing, close and reopen the company file, or update QuickBooks to the latest release.
The balance doesn’t match my brokerage statement. Run a report of all transactions in the investment account and compare line by line. Look for missing dividends, incorrect share counts, or a wrong opening balance.
I get an error when entering a sale. This usually happens if the security isn’t in the list or the share count is zero. Verify the security name and that you have enough shares recorded.
QuickBooks says “Cannot find security” when I type a ticker. QuickBooks Pro doesn’t have a built-in price feed. You must manually add the security via the Securities window. The ticker is just a label—it won’t fetch prices.
Frequently Asked Questions
Can I track cryptocurrency in QuickBooks Pro? Yes, but only as a generic security. There’s no special crypto type. You’d create a security named “Bitcoin” and record buys/sells manually. Gains/losses will be calculated, but you’ll need to handle valuation manually.
Do I need to enter every dividend or can I lump them? It’s best to enter each dividend separately to keep your records accurate and reconcileable. Lumping them makes it hard to match your statement.
How do I record a stock split? QuickBooks Pro doesn’t have a split transaction type. You can adjust the share count by editing the original purchase transactions, or record a zero-value buy/sell to fix the quantity. Many users simply update the share count in the security’s details.
What if I sell a security I’ve held for years? The gain/loss is calculated from the cost basis you entered. If you didn’t enter the original purchase, the gain will be wrong. You may need to add a manual adjustment to correct the basis.
Can I use QuickBooks Pro to track my 401(k)? Yes, but it’s not ideal. You can set up a brokerage account for it, but you won’t be able to track employer contributions easily. Consider using a separate spreadsheet or your 401(k) provider’s tools.
Does QuickBooks Pro calculate capital gains tax? No. It calculates the gain or loss amount, but it doesn’t apply tax rates. You’ll need to report that number to your accountant or tax software.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Set Up UPI Payments Through WhatsApp
- Pair Oppo Enco Earbuds with Android, iPhone & Windows
- Fix Administrator Account Disabled Error in Windows 11
- How to Play Kodi on Smart TV from PC
- Hogwarts Legacy Microsoft Visual C Runtime Error Fix
- Factory Reset on Samsung Galaxy: What It Erases