Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
darkjohn
Level 1

How do you schedule a quarterly inventory adjustment

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.

3 Comments 3
Erika_K
QuickBooks Team

How do you schedule a quarterly inventory adjustment

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.

darkjohn
Level 1

How do you schedule a quarterly inventory adjustment

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.  

ShangY
QuickBooks Team

How do you schedule a quarterly inventory adjustment

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.

Need to get in touch?

Contact us