How to Adjust Inventory in QuickBooks 2010
You can store inventory numbers in QuickBooks 2010. In order to record changes to inventory, you periodically physically count your inventory and then adjust your QuickBooks records with the results of your physical counts.
1
Select the Adjust Quantity/Value on Hand command.
This command is available to you in two different places. If you display the Item list, click the Activities button (which appears at the bottom of the Item List window) and select Adjust Quantity/Value on Hand from the pop-up menu that appears. You can also choose Vendors→Inventory Activities→Adjust Quantity/Value on Hand.
Choosing either command displays the Adjust Quantity/Value on Hand window.
2
In the Adjustment Date text box, enter the date of your physical count.
In other words, you want to adjust your quantities as of the day you took or completed the physical inventory count.
3
From the Adjustment Account drop-down list, select an expense account.
Choose the account that you want to use to track your inventory shrinkage expense.
4
(Optional) Identify the customer or job, and the class.
If it’s appropriate, select this information from the Customer:Job text drop-down list and the Class drop-down list (which identifies the class that you want to use for tracking this inventory shrinkage).
5
In the New Qty column, provide the correct physical count quantity of the item.
After you’ve entered the new quantity, QuickBooks calculates the quantity difference and shows this value in the Qty Difference column.
Alternatively, you can enter a value in the Qty Difference column to make QuickBooks calculate the New Qty.
6
(Optional) Select the Value Adjustment check box.
QuickBooks displays an expanded version of the Adjust Quantity/Value on Hand window.
7
Enter the physical count quantity in the New Qty column and the new updated value in the New Value column.
You probably use this version of the Adjust Quantity/Value on Hand window only if you’re using a lower-of-cost or market inventory valuation method. For example, both financial accounting standards and tax accounting rules allow you to mark down your inventory to the lower of its original cost or its fair market value.
8
If you want to further describe the quantity or value adjustment, enter it in the Memo text box.
For example, you may want to reference the physical count worksheets, the people performing the physical count, or the documentation that explains the valuation adjustment.
9
Click either the Save & Close button or the Save & New button to save the adjustment transaction.
Save & Close saves the transaction and closes the window. Save & New saves the transaction but leaves the window open in case you want to make additional changes.
Accounting Glossary
accounting equation
The equation Assets = Liabilities + Equity, which demonstrates the two-sided nature of accounting and is useful for explaining the concept of double-entry accounting (or double-entry bookkeeping).
Accounting Glossary
accounting period
The time period for which financial information is being tracked in a business, such as monthly, quarterly, or annually.
Accounting Glossary
accounts receivable
An account that records the amounts that customers owe to a business.
Accounting Glossary
adjusting entry
A correction made to a bookkeeping account that adjusts for accounting errors or other necessary changes at the end of the accounting period.
Accounting Glossary
cash flows
Used to describe the source or sources of cash or how cash is used.
Accounting Glossary
Chart of Accounts
A list of all the accounts used by a business, including what types of transactions go into each account.
Accounting Glossary
debit
An accounting entry that increases an asset or expense account, and decreases a liability or income account.
Accounting Glossary
dividends
A portion of a company’s profits paid by share of common stock on a quarterly or annual basis.
Accounting Glossary
FASB
Financial Accounting Standards Board. FASB is the highest-ranking authority in the private (non-government) sector of the U.S. for making pronouncements on GAAP and for keeping accounting standards up-to-date.
Accounting Glossary
Federal Unemployment Tax
In the U.S., the fund that used to be known simply as Unemployment. Employers contribute to the fund, and states also collect taxes to fill their unemployment fund reserves. (The acronym FUTA means Federal Unemployment Tax Act.)
Accounting Glossary
fidelity bonds
A type of insurance — typically carried by employers for their employees — that helps guard against theft and reduce the risk of loss.
Accounting Glossary
FIFO
First-in, first-out. A method for costs of goods sold in which a business charges out product costs to cost of goods sold expense in the chronological order in which the goods were acquired.
Accounting Glossary
fungible
Describes a product that is interchangeable and virtually indistinguishable from another product.
Accounting Glossary
General Ledger
A summary of all of a business’s accounts and transactions.
Accounting Glossary
IASB
International Accounting Standards Board. The IASB (based in London) is the main authoritative accounting standards setter outside the U.S.
Accounting Glossary
Journals
The location in which bookkeepers keep records (in chronological order) of daily company transactions.
Accounting Glossary
LIFO
Last-in, first-out. A method for costs of goods sold that selects the last item you purchased first, and then works backward until you have the total cost for the total number of units sold during the period.
Accounting Glossary
LLP
Limited liability partnership. A legal structure that state laws offer to qualified professionals in which all the partners have limited liability.
Accounting Glossary
PC
Professional corporation. A legal structure that state laws offer to qualified professionals who otherwise would have to operate as an unlimited partnership liability.
Accounting Glossary
petty cash
A cash account that businesses keep on hand for unexpected expenses.
Accounting Glossary
revenue
Monies that are collected in the process of selling a company’s goods and services.
Accounting Glossary
salvage value
The amount that an asset is worth after it has been fully depreciated.
Accounting Glossary
statement of cash flows
A financial statement that summarizes a business’s cash inflows and outflows during an accounting period.
Accounting Glossary
transactions
Economic exchanges between a business or other entity and the parties with which the entity interacts and makes deals.
Accounting Glossary
worker’s compensation insurance
A type of insurance carried by employers that covers its employees in case they are injured on the job.
Share This
