Inventory tracking and accurate accounting are two of the most crucial issues for a retailer. We will discuss how to properly receive inventory in this article. We will discuss some of the problems that QuickBooks Financial (Pro, Premier, or Enterprise) runs into when QuickBooks Point of Sale (POS) is not used properly.
When you log into a new client, you will see money in the expense account labeled “POS Inventory Adjustment” (Document offset in earlier versions). Most clients don’t know how to stop unauthorized entries or how these transactions work.
QuickBooks needs to balance the transaction any time inventory is changed because of a transaction other than receiving, returning, selling, or issuing a credit for an item. The software uses the adjustment account to keep the books balanced because these changes have an impact on the value of the inventory. These kinds of adjustments are sometimes required. For instance, when performing a physical inventory, if there are inventory shortages, the correct entry is to post an expense to lower the value of the inventory. Additionally, you should reduce your inventory and expense an item if it is damaged and you are unable to sell or return it.
What is causing this Issue?
You can enter the number of items you have on hand in QuickBooks Point of Sale from the item screen. Most clients say “Sure, I want to change the value of my inventory as I am adding inventory” and then choose to permanently hide the message, even though it will alert you with an adjustment memo that you are changing the value of your inventory. When the next synchronization with QuickBooks Financial occurs, the inventory adjustment that has been created will post a debit to inventory and a credit to POS Inventory Adjustment. The entry would not be accurate if the client had intended to add inventory and generate a bill for the inventory.
How can I avoid this issue?
Teach your customers to never, ever change the number of items that are currently in stock. If Intuit continues to permit this change, the software ought to notify the client to call their ProAdvisor to fix the issue they are causing and to type “yes” to accept the charge, in addition to displaying the message. Teach the client to go to the Inventory menu and enter a new quantity adjustment if they do need to adjust quantities because they have damaged items that they are unable to return.
Should you enter inventory into the system?
Yes, but do it correctly. If this is a new business, ask the client to enter receiving vouchers for all their inventory, then let QuickBooks Financial generate bills that can be matched to payments. You can choose from a few options if the store is already open. If the customer has previously used QuickBooks Financial to track their inventory and if the inventory item detail is accurate, you could import the items from QuickBooks Financial into QuickBooks Point of Sale. There are additional issues with this that go beyond the scope of the article.
Steps to ‘Process an Inventory Adjustment’ in QuickBooks:
There are times when you need to lower your inventory levels without making any sales. Possibly for:
- Inventory that has been damaged and cannot be sold.
- Inventory that is about to expire or must be discarded.
- Inventory loss because of theft or other illegal activity
- Inventory for internal use is that which you use or consume while conducting business, even though you are not directly selling it to a customer.
Only inventory reductions for a given reason are done using inventory adjustments.
Adding an Inventory Adjustment:
- Go to Catalog -> Products.
- Select the product you want to change by using the filters, if necessary.
- To enlarge the product, click it.
- Select Modify Inventory.
- From the Outlet dropdown menu, choose the outlet for which you will be adjusting inventory.
- Press Next
- From the Adjustment Reason dropdown, choose a justification for the adjustment.
- Fill out the Adjustment Quantity section with the inventory reduction amount. Both the inventory quantity and the adjusted inventory quantity will be shown in the Inventory column.
- Select Modify Inventory.
The level of your inventory is now being updated. Click Inventory Movements View for the product you made changes to see the changes you just made.
Inventory Adjustments reporting:
You must make sure that you record these numbers in your accounting system because inventory adjustments are not automatically passed to accounting integrations and do not appear on reports as separate line item.
The Inventory Movements View shows completed inventory adjustments, but you must manually report on them.
Steps to Fix negative inventory issues in QuickBooks Desktop:
This article explains negative inventions, including their potential causes, effects on your company file, and remedies. It also outlines how to resolve problems brought on by negative inventory.
Selling inventory items that you don’t have in stock results in negative inventory when sales transactions are entered before the corresponding purchase transactions.
When you sell products that are listed in your company file:
- When you use the Items Tab to make a purchase, the inventory is deducted from your account and the accounts payable, cash, or credit card payable is credited.
- On sales receipts or invoices, you can sell items, but you should never sell more than you have on hand.
- Two transactions are recorded in the sales transaction:
- The sales/ receivable transaction, which credits sales and debits accounts receivable
- Crediting Inventory and debiting COGS in the Inventory/COGS transaction.
- Profit & loss and expense reports are run and display the invoices and sales receipts because they track both the income and the expenses.
- You run B/S reports that display item receipts, bills, checks, and credit card charges because they track inventory growth, and they display invoices and sales receipts because they track inventory declines.
When you sell something for which your company file has not been updated:
- The invoice accurately reflects the expected Sales/Receivable transaction.
- QuickBooks makes the following assumptions about the average cost of the items not in stock when processing the Inventory/COGS transaction:
- The average cost was the same as what you already had on hand. OR
- The cost of each item in the item list.
- Using the estimated cost, QuickBooks records the Inventory/COGS transaction.
- To account for the discrepancy, the purchase transaction must record an adjustment to Inventory and COGS if the subsequent purchase is not made at the assumed cost.
- The bill is now reflected on the P&L and other expense-related reports because it has an impact on COGS.
- The Inventory/COGS transaction report is only accessible by running the Transaction Journal report.
- A Cost of Goods Sold (COGS) account’s Transaction Detail by Account and Account Quick Report will show bills, checks, and credit card charges that have Inventory/COGS adjustments.
Steps to View Negative Inventory?
Negative inventory can appear on your Balance Sheet, but it is mostly seen on the following reports:
Report on Inventory Valuation Detail (IVD):
The IVD is the ONLY report that can be used to assess the scope of your negative inventory. Negative inventory appears in the Quantity on Hand (QOH) column as negative numbers.
- Navigate to the Reports menu.
- Choose Inventory, then Inventory Valuation.
Go to Item Listing Report:
The Negative Item Listing report is available in QuickBooks Enterprise 15.0 and later. It is important to note that it displays current negative quantities but NOT previous negative quantities.
- Navigate to the Reports menu.
- Choose Inventory, then Negative Item Listing.
If you don’t have Advanced Inventory and are using QuickBooks Premier or Enterprise 2014 or earlier, you can use your Inventory Centre.
- Access the Vendors menu.
- Then choose Inventory Centre after choosing Inventory Activities.
- Change the filter from Active Inventory to Assembly to QOH = Zero in the Inventory Centre window’s top left corner.
Issues you may face:
The cost of a newly added inventory item is not average.
- You made a brand-new inventory item with an item cost but no initial QOH or VOH.
- As a result, the item is left without an average price.
- Instead of a bill, check, credit card charge, or Adjust Qty/Value on Hand (IAD), an invoice was used as the first transaction to use the item.
- The purchase results in a decrease in inventory.
- The invoice uses the item cost from the item list instead of an average cost to credit inventory and debit COGS.
- You pay a price other than the item’s cost to purchase it.
- The difference between the item cost and the actual purchase cost is adjusted for in the bill’s adjustments to inventory and COGS, which causes it to appear on the P&L report.
Your Quantity On Hand (QOH) has gone negative due to the sale of inventory you did not have, which could result in an incorrect Cost of Goods Sold (COGS) on your P&L report.
- Without an Item Cost, a new inventory item is created.
- You market that product without adding it to your inventory.
- QuickBooks can’t determine the average cost because it lacks the necessary data, so it must give it a value of 0.00.
- Your COGS and inventory are distorted as a result.
- When you use a bill, check, credit card charge, or Adjust Qty/Value On Hand to establish an average cost, the errors are not corrected yet.
On vendor reports, a negative inventory results in multiple errors:
Typically, the invoice includes the Inventory/COGS transaction. Your subsequent bill will include an inventory/COGS adjustment if you sell out-of-stock merchandise. These changes are linked to the vendor and show up on vendor reports.
According to job costing reports, inventory assemblies display incorrect COGS:
If you sell assembly items when you don’t have enough in stock and then build assembly items later at a price that differs from the average price, the build transaction will have an adjusting Inventory – COGS transaction that is typically included in the invoice. So that the adjusting transactions can be included in job costing and class reports, the build transaction does not allow you to enter either a customer: job name or a class.
A negative status for inventory quantities must be avoided to maintain accurate inventory records, including COGS. When there is not enough inventory available, don’t sell assembly items.
Steps to Fix Negative Inventory?
Before beginning the steps, keep the following in mind:
- The QuickBooks company file should be backed up without overwriting any earlier copies. Store these backups in a secure location.
- To ensure that these changes are valid, speak with your accounting specialist. Simply changing the current QOH to a positive value is insufficient. You must get rid of every instance of poor QOH.
- A better choice might be to start a new data file if there is a significant negative inventory that cannot be easily repaired.
Your first purchase transaction(s) are sales:
Make sure that the earliest dated transaction for an item is a bill, check, credit card charge, or Adjust Qty/Value on Hand: If your inventory reports are inaccurate because you haven’t established an average cost, you can get them to show the right values by ensuring that the earliest dated transaction is one of these.
- Choose Inventory, then select Inventory Valuation Summary from the QuickBooks Reports menu.
- By clicking the item name twice, you can QuickZoom an item that is displaying inaccurate values. This displays the item’s Inventory Valuation Detail report. This item’s transactions are listed in chronological order by date.
To launch the Enter Bills window, quickly zoom the first Bill listed.
- Earlier than the first invoice listed on the detail report you opened in Step 2’s step, change the date on the bill.
- To update the bill with the new date, click Save & Close.
- For every wrong item, repeat steps 2 through 5.
- You didn’t record the purchases you made when you sold inventory items.
Maybe you entered bills with accounts instead of inventory items. If so, amend the Bills. rename the entries on the Expenses Tab to the Item. This could change your inventory costs, so be aware of that. Before starting this procedure, speak with a qualified accountant.
- To open the Enter Bills window, quickly zoom the first bill listed.
- A date that is earlier than the first invoice listed on the detail report you opened in Step 2 should be entered as the bill’s new date.
- To add the new date to the bill, click Save & Close.
- Steps 2 through 5 must be repeated for each inaccurate item.
You failed to record purchases when you sold inventory items.
It’s possible that you entered bills using accounts rather than inventory items. Edit the Bills if necessary. the Item entries should be changed to those from the Expenses Tab. Be aware that this might change the cost of your inventory. Before beginning this process, seek advice from a qualified accountant.
Before entering sales, you entered purchases or adjustments.
Adjust the transaction dates so that bills are dated before invoices, if you can do so lawfully:
- Select Reports > Inventory > Inventory Valuation Detail from the menu bar.
- Select All after clicking the Dates drop-down arrow.
- Find an item in the report that has a negative value in the On Hand column by scrolling through the report.
- If it is legal to do so, change the dates of the bills and/or invoices so that the bill dates come first.
- For each item with a negative amount in the On Hand column, repeat steps 2 through 4 once more.
1. How do I fix QuickBooks POS inventory not counting?
To zero the inventory and start over properly would be another and the most thorough solution to the issue. Using QuickBooks POS’s physical inventory feature makes this simple to do. With the entire inventory list visible, select the checkbox labeled “Set all items not counted to zero”.
2. How do you change the value of my inventory in QuickBooks?
Adjustments made in Point of Sale and QuickBooks Desktop Inventory Asset contain transactions that don’t involve any stock items. In Point of Sale, access the Inventory Valuation report. Select Items then Inventory Valuation from the Reports menu. The date should be set to Today. Choose the Apply date.
3. Is the QB in charge of inventory adjustment already?
This part is already being managed by the program. “QB automatically selects an “inventory adjustment” cost of goods account when I make an inventory adjustment in the inventory module.
4. What is the operation of QuickBooks Point of Sale?
You can enter an on-hand quantity from the item screen in QuickBooks Point of Sale. Most clients say “Sure, I want to change the value of my inventory as I am adding inventory” and then choose to permanently hide the message, even though it will alert you that you are doing so with an adjustment case.
Speak to A Specialist about QuickBooks Software
Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1/, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)
--- Support - We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) ---
- Error Support
- Data Import
- Data Conversion
- Payment Solutions
- Payroll Support
- Data Export
- Software Integration
- QuickBooks Printer Support
- Complete QuickBooks Solutions
- Tax-Related Issues
- Data Damage Recovery
- Installation, Activation Help
- QuickBooks Windows Support