Category: Inventory

Closing a Partially Shipped Purchase Order in QuickBooks

| November 23, 2009 | 18 Comments

When you create a purchase order in QuickBooks the quantity that you have on outstanding PO’s will show in several reports. If you receive a partial shipment on that PO and the remaining balance will not be shipped, you need to close the purchase order to remove the outstanding items on these reports. There have […]

Continue Reading

Custom Fields in QuickBooks Enterprise 10

| October 21, 2009 | 59 Comments

I discussed custom fields in QuickBooks in an article last year, and it is one of the most popular articles in my blog. Many users depend on custom fields to add features to invoices, sales orders and estimates (and more). The two most common complaints about custom fields have been there need to be more […]

Continue Reading

Paying a Bill Before Receiving Inventory in QuickBooks

| June 25, 2009 | 70 Comments

Buying inventory is simple in QuickBooks. Create a purchase order, receive the items, enter the bill, pay the bill. Simple! Sometimes things don’t occur in this nice sequence, and it isn’t always obvious what the best procedure would be. What if you have to pay the bill before you have received the items? In this […]

Continue Reading

QuickBooks Inventory Quantity and Value Adjustments

| June 2, 2009 | 186 Comments

If everything is working perfectly in your QuickBooks company you won’t need to worry about making inventory adjustments. You will receive inventory items, sell inventory items, possibly even build inventory items (assemblies), and everything will balance out. If that describes your company, great! For the rest of us, though, there are times when we will […]

Continue Reading

QuickBooks Manufacturing Forecasts: Component Demand

| May 19, 2009 | 9 Comments

Having an adequate supply of component parts is critical to a manufacturer. If you run out of something, you can’t build your assembly. If you can’t build your assembly, you can’t fulfill customer orders. So let’s talk about how to avoid this if you are using QuickBooks.

Continue Reading

Reconciling QuickBooks Inventory Balances

| April 1, 2009 | 47 Comments

An important part of controlling your inventory is to make sure that your company financial statements match your inventory status. The inventory asset balance in your Balance Sheet should match the value in the Inventory Valuation Summary report. Unfortunately, these values don’t always match, and in this article I’ll talk about some reasons why this […]

Continue Reading

Shipping Costs and QuickBooks Inventory

| March 9, 2009 | 115 Comments

What is the “cost” of an inventory item that you purchase? For many businesses we talk about the “landed cost” of the item, which can include not only the purchase cost of the item, but also the shipping cost of the item. In this article I’ll talk about a few ways to handle this in […]

Continue Reading

Understanding QuickBooks Inventory Cost

| January 13, 2009 | 92 Comments

If you are using QuickBooks to manage your inventory, you need to understand how QuickBooks deals with the cost of inventory items. I’ve been answering a lot of questions about this in the Intuit Community Forums lately, so here is a quick rundown of how things work.

Continue Reading

QuickBooks Item List – Columns

| December 24, 2008 | 18 Comments

The Item List in QuickBooks can be modified to show different columns, which can make it more useful for you. There are some odd features here that I’d like to explain, in this quick tip.

Continue Reading

QuickBooks Inventory: Initial Balances

| November 11, 2008 | 18 Comments

When someone is setting up a new company file in QuickBooks a common complaint I see is that they are getting an incorrect quantity on hand for inventory items, or an incorrect average cost for the items. Today I’ll explain why this usually happens, and give you a little tip on how to correct the […]

Continue Reading