Last post we discussed how Enhanced Inventory receiving (EIR) works in QuickBooks Enterprise. Since once turned on, the feature cannot be disables, it’s an important decision for a QuickBooks user to make. This post – some of the cautions.

balance sheet w inventory offset

The balance sheet shown illustrates the entry made by an item receipt. Those entries affect the balances in the two highlighted accounts.

When the bill is created, the amount in Inventory Offset Account should be moved to Accounts Payable.

bill added freight item

The problem occurs when the bill is created and additional amounts are added to it through the use of items. In the above example, an item is used to record the amount of freight on the bill. This line did not exist on the item receipt or purchase order.

bal sh negative inventory offset

QuickBooks reverses the amounts, posting to the Inventory Offset Account, even though that amount never posted into that account in the first place. We now have this odd balance that will not only stay indefinitely; it will most likely increase as additional transactions are processed in the same way.

There are two ways to deal with this issue and still use EIR. Neither are ideal, but they will work.

alternative item receipt

One solution is to add a line to each purchase order, which then carries to the item receipt, a freight charge item. Since no amount needs to be entered, this is a simple solution that could be implemented each time a purchase order is created.

alternative bill

The second solution would be to expense freight to an account on the Expenses tab of the bill form rather than using an item.

Either of these solutions should eliminate the mounting balance in the Inventory Offset Account.

Hector Garcia, CPA
Certified Advanced QuickBooks ProAdvisor
12401 Orange Drive #136
Davie, FL 33330
954-414-1524
hector@garciacpa.com

Avatar

Hector Garcia

Hector Garcia is a CPA and QuickBooks Consultant.

More Posts - Website

Share →

Leave a Reply

Your email address will not be published. Required fields are marked *



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net