C.5.2c Opening Balance Equity - Inventory | Scribe

C.5.2c Opening Balance Equity - Inventory

  • 26 steps
  • QuickBooksQuickBooks
  • AkadianAkadian
alert ordinal icon
Start in the same session of the Sample company from the previous exercise.

Finding the Problem

information ordinal icon
While in the Opening Balance Equity register, you notice 4 items that refer to inventory. How did this happen?
information ordinal icon
Earlier we saw how creating new bank accounts with a starting balance creates an entry in OBE. Creating new inventory products with a starting *quantity* does the same thing. As with the bank account, the correct procedure is to start with a quantity of zero and then add transactions that adjust the amount. If you enter a starting quantity on hand instead, QBO will multiply that initial quantity on hand by the cost and create a starting inventory adjustment in the Inventory Asset account categorized as OBE.
information ordinal icon
This is what happened to Craig, as can be seen when looking at the Inventory Asset register.
information ordinal icon
These starting inventory transactions cannot be deleted or edited, so instead, you'll need to make some adjustments to get them out of OBE.
alert ordinal icon
Remember, when dealing with Inventory, you need to adjust both the quantity and the value, so we'll have to take both of these into account.
information ordinal icon
We'll start by running a report that shows us what we need to know.
1
On the left nav bar, Click "Reports".
2
In the Find report by name field, Start typing "Inventory" and select "Inventory Valuation Detail".
3
Click "All Dates".
4
Click "Run report".
information ordinal icon
The resulting report has everything you need to know to make the adjustments. Keep your report handy for the rest of this exercise and note that your dates will be different than the ones shown.

Canceling the Initial Balances

information ordinal icon
The first thing we will do is take out the initial balances. Since we can't delete or edit the starting balance transactions, we will have to add balancing ones. We'll do this using an Inventory Quantity Adjustment.
5
Click "＋New".
6
Click "Inventory qty adjustment".
7
Enter the date of the initial transaction, as shown on your report. *Remember, your date will be different than what is shown here.*
alert ordinal icon
Note that if you were making adjustments for starting balances with different dates, you would need to create separate Inventory Quantity Adjustments, each with the correct date. In our case, all of the dates are the same, so we can include them all on the same transaction.
information ordinal icon
Next you will need to indicate which account to adjust. Usually for an Inventory Quantity Adjustment, you would indicate a shrinkage account, but in our case, the account we are reducing is Opening Balance Equity.