How to Record Manufacturing Firm Inventory in QuickBooks 2010
Tracking inventory in a manufacturing firm is more difficult than in other types of businesses. QuickBooks 2010 Premier solves the problem of combining a manufacturer's raw materials items into finished goods items (which means the inventory count and value goes down for some items and up for others).
QuickBooks displays the Item List window.
2
Click the Item button and select New from the drop-down list that appears.
The New Item window appears.
3
Select the Inventory Assembly item from the Type drop-down list.
The Inventory Assembly version of the New Item window appears.
4
From the COGS Account drop-down list, select an account to use for tracking this item’s cost when you sell it.
QuickBooks suggests the Cost of Goods Sold account. If you’ve created other accounts for your COGS, however, select the other appropriate account.
5
In the Description text box, type a description of the item that you want to appear on documents, such as invoices and so on, that your customers see.
QuickBooks suggests the same description that you used in the Description on Purchase Transactions text box as a default.
6
Enter the amount that you charge for the item into the Sales Price box.
Also, indicate whether the manufactured item is subject to sales tax using the Tax Code drop-down list.
7
Select an account from the Income Account drop-down list.
QuickBooks uses this account to track the income from the sale of the item.
8
In the Components Needed list, identify the individual component items and the quantities needed to make the inventory assembly.
Each component item goes on a separate line in the list.
9
Select an account from the Asset Account drop-down list.
Specify the asset account that you want QuickBooks to use for tracking this inventory item’s value.
10
In the Build Point text box, specify the lowest inventory quantity of this item that can remain before you manufacture more.
When the inventory level drops to this quantity, QuickBooks adds a Reminder to the Reminders list, notifying you that you need to make more of the item.
11
Ignore the On Hand and the Total Value text boxes.
If you enter a number in the On Hand text box now, you record an uncategorized transaction, and you don’t want to do that. Go ahead and leave the Total Value field set to zero, too.
12
(Optional) Enter the current date in the As Of text box.
You can also just leave this text box empty.
QuickBooks saves the information you've input.
14
Choose Vendors→Inventory Activities→Build Assemblies.
QuickBooks displays the Build Assemblies window.
15
Select the item that you want to build from the Assembly Item drop-down list.
The table in the Build Assemblies window shows you what goes into your product. Not that you care, but this is a bill of materials.
16
Enter the quantity that you (or some hapless co-worker) have built in the Quantity to Build box.
When you build an item, QuickBooks adjusts the inventory item counts.
17
Click either the Build & Close or Build & New button.
Click the Build & New button if you want to record the assembly of some other items.
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
