Entering Bills for Items Already Entered in an Inventory Adjustment
- Author Kc Truby
- Published June 19, 2010
- Word count 503
Occasionally you will go through your inventory and realize that you are showing more or less inventory than QuickBooks reflects. Typically a company will then make an inventory adjustment in QuickBooks to straighten this out. The problem you may encounter is that you will adjust your inventory on hand before you receive a bill from a vendor. This happens when your vendor sends you items before the bill. If you enter the bill as usual, you will end up causing mistakes in your inventory count because you already added the inventory with an inventory adjustment. At the same time however, you really should add the bill so you can track what you owe your vendors. If this is the case do not worry. There is a very simple solution.
First go to your item list in QuickBooks. You can get there by going to Lists from the menu strip and then selecting Item List. Now click Item at the bottom and select New. For type select Inventory Part. Enter Item Clear for Item Name/Number. Do not enter a cost since this number will always be different. Enter in the COGS Account and Income Account that you typically use. Make note of the COGS Account that you use as it will be used again in our final step. You may now click OK and close the Item List.
Now go to Enter Bills from your home screen in QuickBooks. Enter the Vendor Name, Date, Due Date, Ref. No, and Amount Due as shown on your bill. In the Memo field you should make a note saying you already added the inventory via Inventory Adjustment. Now click on the Items tab below. On the first item line select the item we just created, Item Clear. Only enter 1 for the Quantity and enter the cost for all the inventory items as the cost. If the bill contained other charges such as shipping, handling, or anything else you can enter those in the Expenses tab. You may also enter inventory items that you did not add in your prior Inventory Adjustment.
The next step will require you to be in Single User Mode. From the home screen in QuickBooks select Adjust Quantity on Hand. Enter the date from your bill in the Adjustment Date. Enter the same COGS Account that you made note of when you created the Item Clear item for Adjustment Account on this screen. Now find the item in the list below called Item Clear. The Current Qty should only be 1. In the New Qty column enter 0 and click Save & Close.
Basically what we have done is created a bill and used Item Clear as a place holder for our bill. When you made your first inventory adjustment after you checked your inventory the COGS and Inventory Asset accounts were already affected correctly. After entering the bill place holder we immediately adjusted the Item Clear account back to 0, reversing the bill we entered, so that the COGS and Inventory Asset accounts are unchanged.
KC Truby calls himself The Lonesome Cowboy. A business owner on a lonesome trail of trying to create fame and fortune for his family and future by getting rid of all work that does not impact the customer. KC can be contacted at his ranch in Wyoming at kctruby@msn.com http://www.qbexpress.com
Article source: https://articlebiz.comRate article
Article comments
There are no posted comments.
Related articles
- The Advantages of Incorporation for Realtors: Safeguarding Your Financial Future
- 10 essential tax-saving strategies for landlords: Maximise your rental income
- A Comprehensive Guide to Navigating the Process and the Role of Customs Brokers in the UK
- Outsourced Accounting Services for UK Businesses: A Cost-Effective Solution for Financial Management
- Top 8 Self Assessment tax return software
- How to Close a Limited Company in the UK
- Maximizing Your Finances: Unleashing the Power of CPA Services
- VAT penalties – New rules
- TAX-FREE STRATEGIES IN AN UNCERTAIN ECONOMY
- 2022 Energy crisis and failure to connect Reality.
- When Are Corporate and Personal Taxes Due in Canada in 2021?
- You Would Never Have Thought That Having Accounting Internship Could Be So Beneficial
- ACTIVATION OF UAN
- Focal motivations behind getting a Tax direct for Small Business Firms
- Avoiding the flood — tax issues with water rights in agribusiness
- Social security benefits for a family (COVID-19)
- How to use QuickBooks Component Repair Tool?
- Do you want to reduce your taxes for next year?
- Will you be responsible with your tax refund?
- Getting started with QuickBooks Enhanced Payroll in Brief
- Are DSTs Right For Your 1031 Exchange
- Tax Return Makeovers By Kenya Woodard
- Why have all crypto tax attempts failed?
- Are You a Corporation? Know Why Consulting a Tax Accountant Is Vital
- Share capital or share premium for your Dutch company?
- Everything investors should know about 1031 sponsors
- Why is the income tax so high in UK?
- Should I do my own tax return?
- Get More Money Back on Your Tax Return with help from the Tax Cuts and Jobs Act
- Don’t Fall Victim to these 3 Tax Scams in 2018