Tracking inventory overview and set up – QuickBooks desktop Pro Premier Accountant Enterprise

Inventory feature in QuickBooks Desktop can track the current number in stock and the value of your inventory after every purchase and sell the items to your customers. With QuickBooks Desktop Premier or QuickBooks Enterprise versions, you can even keep track of products you assemble and resell (finished goods), adding assembled units to inventory and deducting component units from inventory when you build assembly items.

To start with, you may want to be familiar with these basic steps related to questions about Tracking Inventory in QuickBooks:

1) To turn on Inventory: Go to Edit menu at the top > select Preferences > choose Inventory & Items > Company Preferences > checkbox “Inventory & Purchase Orders are active” > click OK.

Turn Inventory On

 

2) Create Inventory Items: Go to Lists menu at the top > Items List > Select Item tab at the bottom > click Item (or drop-down arrow) and select New > Type = Inventory Part and create a new item.
These three fields are important to set up inventory items. See screenshot sample.
For COGS Account field = Cost of Goods Sold account type from the Chart of accounts
For Income Account field = Income account type from the Chart of Accounts
For Asset Account field = Inventory Asset account which is part of the Other Current Asset on the Chart of Accounts

You do not want to put in On Hand/Total Value info here.

Create Inventory Item

 

3) For adding purchased Inventory items: Use Enter Bills under Vendor menu at the top or Write Checks menu under Banking at the top. Always use ITEMS tab, never Expenses tab.
4) For selling Inventory items: Create Invoice (or Sales Receipt). Use ITEM Code in the sales form. This will also automatically post COGS to P&L by reducing inventory counts.

Enter Bill or Check Use Items tab

Create Sales

Inventory Stock Report

 

If you need more info, you can always click HELP menu at the top and select QuickBooks Desktop Help and type INVENTORY HELP in the search field. If interested, you can also watch my famous how to inventory video tutorials on YouTube.

QuickBooks Desktop Part 10: Inventory – All you need to know about QuickBooks Inventory

Do attachments slow down QuickBooks? Wondering if having all the PDFs in QuickBooks will make it slower

Attaching documents in QuickBooks desktop shouldn’t affect the performance of the software. They are saved on the computer hard drive in a separate folder, and they are not included in a back up of the QuickBooks company file either so that backup file does not grow either. All attaching does in QuickBooks, is to enter a pointer to the hard drive location for the attachment folder.

If you experience slowness with QuickBooks, there may be other reasons like due to a large company file or network issues.

Here’s an article that’ll guide you:

https://community.intuit.com/articles/1019690

 


 
[wpedon id=”615″ align=”center”]


QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE




Import items into your company data file from an Excel spreadsheet

Import items into your company data file from an Excel spreadsheet
QuickBooks Help
From the article: If you are importing existing inventory items, you cannot update their Quantity On Hand (QOH), value on hand (VOH) or average cost. For new inventory items you are importing, you can set up a Quantity On Hand (QOH) and a Value on Hand (VOH) and establish an average cost. QuickBooks enters an Adjust Quantity/Value on Hand debiting the item’s asset account and crediting Opening Balance Equity …


 

[wpedon id=”615″ align=”center”]

QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE


Amazon Buy QuickBooks Desktop 2017

QuickBooks Desktop Pro 2017 Small Business Accounting Software [PC Download] by Intuit

QuickBooks Desktop Premier 2017 with Industry Editions Small Business Accounting Software [PC Download] by Intuit

TRY QUICKBOOKS ONLINE FOR FREE

TRY XERO ACCOUNTING FOR FREE


Resolve A/R or A/P on the cash basis Balance Sheet with journal entries

Resolve A/R or A/P on the cash basis Balance Sheet with journal entries
QuickBooks Help
Cash basis financial reports should not display Accounts Receivable (A/R) or Accounts Payable (A/P) balances. However, QuickBooks is a bookkeeping program and must balance, so for accrual-based business that reports on cash basis, QuickBooks will display AR and AP …


[wpedon id=”615″ align=”center”]

QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE


Amazon Buy QuickBooks Desktop 2017

QuickBooks Desktop Pro 2017 Small Business Accounting Software [PC Download] by Intuit

QuickBooks Desktop Premier 2017 with Industry Editions Small Business Accounting Software [PC Download] by Intuit

TRY QUICKBOOKS ONLINE FOR FREE

TRY XERO ACCOUNTING FOR FREE


Switch between banking modes in QuickBooks Desktop

Switch between banking modes in QuickBooks Desktop
QuickBooks Help
From the article: QuickBooks online banking lets you match transactions using an Express Mode (Side-by-side in QuickBooks 2013) that is more of a graphical interface, or a more classic view called Register Mode …


[wpedon id=”615″ align=”center”]

QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE


Amazon Buy QuickBooks Desktop 2017

QuickBooks Desktop Pro 2017 Small Business Accounting Software [PC Download] by Intuit

QuickBooks Desktop Premier 2017 with Industry Editions Small Business Accounting Software [PC Download] by Intuit

TRY QUICKBOOKS ONLINE FOR FREE

TRY XERO ACCOUNTING FOR FREE


Error OL-332: Invalid customer ID or PIN when using online banking

Error OL-332: Invalid customer ID or PIN when using online banking
QuickBooks Help
From the article:You submit an online banking transaction and enter your personal identification number (PIN). The following error message displays: Invalid customer ID or PIN. Please try again. If the problem continues, please call customer service for your financial institution [OL-332] …

[wpedon id=”615″ align=”center”]

QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE


Amazon Buy QuickBooks Desktop 2017

QuickBooks Desktop Pro 2017 Small Business Accounting Software [PC Download] by Intuit

QuickBooks Desktop Premier 2017 with Industry Editions Small Business Accounting Software [PC Download] by Intuit

TRY QUICKBOOKS ONLINE FOR FREE

TRY XERO ACCOUNTING FOR FREE


Error OL-200, OL-202, OL-206, or OL-226: Your last online connection was not completed

Error OL-200, OL-202, OL-206, or OL-226: Your last online connection was not completed
QuickBooks Help
From the article: When attempting to perform online activities such as sending bill payments from the Online Bank Feeds center or downloading an online statement the following error occurs: …

[wpedon id=”615″ align=”center”]

QuickBooks Pro 2017 and QuickBooks Premier 2017 - Buy Now and Save!
TRY QUICKBOOKS ONLINE (QBO) FOR FREE
TRY XERO ACCOUNTING FOR FREE


Amazon Buy QuickBooks Desktop 2017

QuickBooks Desktop Pro 2017 Small Business Accounting Software [PC Download] by Intuit

QuickBooks Desktop Premier 2017 with Industry Editions Small Business Accounting Software [PC Download] by Intuit

TRY QUICKBOOKS ONLINE FOR FREE

TRY XERO ACCOUNTING FOR FREE