Level 3

Better Method for Recording Inventory Returns & Preorders

When entering an inventory return or inventory pre-order, QBO does not give you the flexibility to choose which account to post these transactions to. So, if you want to have these transactions go to different accounts you have to do work-arounds or additional journal entries.

 

This could easily be fixed by adding additional fields to the Inventory Item setup and edit screen in QBO as I've drawn out in the attached image (please see attached image).

 

For example, for each type:

 

Returns: When you want to enter a return, you can enter a Credit Memo that has the inventory item, along with the quantity and amount, you want returned. QBO will apply the credit and associated transactions to the G/L accounts assigned to that inventory item during it's setup which is usually "Revenues" and "Cost of Goods Sold" accounts. However, what if you wanted to apply the (net of the) transactions to a "Discounts/Refunds" account instead? The only options are to enter a reclass journal entry or to setup associated, but a second set of separate inventory items that are assigned to the "Discounts/Refunds" (as well as a few other steps). Both options are not preferred and cumbersome.

 

Preorders: When you want to enter an inventory pre-order with a Sales Receipt (or Invoice) that has the inventory item, along with the quantity and amount, pre-ordered and QBO will apply the pre-order and associated transactions to the G/L accounts assigned to that inventory item during it's setup which is usually "Revenues" and "Cost of Goods Sold" accounts. This would be incorrect, because pre-orders are "Unearned/Deferred Revenues" which is a liability. The only options are to (again) enter a reclass journal entry or (as normally suggested by other QBO articles) to setup associated, but a second set of separate inventory items that are assigned to the "Unearned/Deferred Revenues" (as well as a few other steps). Again, both options are not preferred and cumbersome.

 

I have a suggestion that would be a better way to handle both the inventory returns and inventory pre-order scenarios. It requires QBO to make an enhancement or add additional features. 

 

When adding or editing Inventory items, in addition to selecting the "Income account" and "Expense account" options, I request that QBO please also add the following:

 

1) For returns/refunds, for Inventory items, add an "Income account for returns/funds" option under the sales information section and an "Expense account for returns/funds" under the expense information section.

2) For pre-orders, for Inventory items, add an "Asset or deposit account for pre-orders" option under the sales information section and a "Liability account for pre-orders" under the expense information section.

 

Then, of course, in the background apply the appropriate transactions. 

 

How can we get this done? Do others agree so we can get Intuit to do this tomorrow? =)