Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have created inventory items for my investments in shares with the appropriate inventory / revenue / cogs accounts to track ACB. I have looked at several options and have not found a way to automatically book an a DRIP (increase in quantry and value). I have tried a sales receipt and negative inventory. This does not work. Ideally I would like to memozie an inventory transaction but that does not appear to be possible.
Hi there, @darkjohn. We're unable to schedule or memorize inventory adjustments. What we can do is use the Adjust Quantity/Value on Hand option to manually enter those quantity and value changes. Before you start, ensure that you’ve created a specific adjustment account to maintain accurate tracking.
When you're entering the changes, record the quantity difference as a positive number for any increases and link it to that new adjustment account. Check out this article for a clear, step-by-step guide: Adjust your inventory quantity or value in QuickBooks Desktop.
I'd also definitely recommend avoiding sales receipts or negative inventory for this, as they don't actually track increases properly. Apart from that, it’s a good idea to consult with a tax professional to make sure those quarterly updates are keeping your investment records on track.
We'll be here if you have further questions about inventory management.
That is what I have been doing for the past ten years. My tax accountant was very impressed with my solution. Can I not do a memorized PO / receipt amd payment stream or a shorten combination.
Hi there, @darkjohn. My colleague is right. QuickBooks doesn't allow memorize Adjustments and since you’ve already found a clever way to track your Adjusted Cost Base (ACB) using inventory items, you might want to consider using $0.00 Memorized Bill. This creates an automated entry that mimics a purchase receipt. You can achieve the exact same result—increasing both quantity and value.
To automate your DRIP, you can create a recurring receipt by going to Vendors > Enter Bills and selecting your Broker as the Vendor. On the Items tab, enter your Share item along with the new quantity and cost to increase your asset value, then flip to the Expenses tab and enter your "Dividend Income" account with that same total as a negative number (example: -100).
Then, let's offset with income by going to the Expenses tab and choose your Dividend Income account and enter the total cost as a negative number (example: -100). This brings the bill total to $0.00 since the dividend effectively "paid" for the shares.
To memorize it, Press Ctrl + M then name it "Quarterly DRIP," and select Automated Transaction Entry with a Quarterly frequency to let QuickBooks handle the entries for you from now on.
This keeps your records accurate and saves you from having to do all that manual work every quarter.
Let us know if you have further questions as you set this up.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here