Invoicing

Credit Holds in QuickBooks

It is an unfortunate part of doing business, but sometimes you find that you have to put a customer on credit hold. In QuickBooks it can be difficult to prevent your order entry staff from creating an invoice for a customer who you have placed on hold. Today I’ll talk a bit about ways to manage this.

I’m interested in feedback from you as to how YOU manage credit holds. There are many ways of handling this, and I’ll list a few (one of which I learned from one of my clients).

OK, so you have someone who would like to purchase your product or services, but for some reason you aren’t ready to release the product (etc) to them yet. There are many reasons for wanting to do this – you may want to wait until a credit check is completed, you may be having some problems in collecting past due accounts from them, perhaps you need to confirm that this is a legitimate business and location, and more. For whatever reason, you want to put a hold on this customer so that you cannot release an invoice until you have settled whatever the issue is.

What I would LIKE to see is a way to lock a customer record so that my order clerks cannot release an invoice (or ship a product) to them. But that isn’t easy to do. So what we have to do is to set up notifications of various sorts to let the order clerks know that they should not ship.

Using TERMS

One method is to add a credit hold item to your Terms list.

CHold001

Select this as the default terms for the customer.

CHold002

When you create a new order, the Terms box will show “Credit Hold”, so you know that you should not ship to this customer.

CHold003

This is very passive, you have to pay close attention.

Using CREDIT LIMIT

Your customers have a Credit Limit field. You can enter a value of 0.00 in this field. Not that this is not the same as a blank value. If it is blank then there is no credit limit check. If it is zero then you will get a warning with every invoice that you enter.

CHold004

When you select this customer when creating a new invoice you will get a warning if the customer already has a balance. If the customer doesn’t have a balance, you will get this warning when you try to save the invoice.

CHold005

This is much more obvious than the first option.

Using CREDIT HOLD ITEMS

These methods work to apply “holds” on any invoice activity for a customer. Sometimes you may find that you just want to put a hold on a specific order, not all. One way to handle this is to use a Credit Hold Item.

First, I create a sales and an expense account in the chart of accounts called Credit Hold Sale  and Credit Hold Expense.

CHold006

These help in auditing errors – you should never have a value in either of these accounts. If you do, someone made a mistake that you can correct. Note that you don’t have to do this, I just like to have it as a cross check.

Next, I create a Credit Hold item in the item list. It should be an inventory item, and it should use the two accounts we just created.

CHold007

Make sure that the cost and price are zero.

Now, create your sales order or invoice for this customer, and add the Credit Hold item. If you are using invoices, you should right click on it and mark it as pending, also.

CHold008

Why do I do this? So that I can get reports that show me any pending invoice or sales order that is on credit hold. You want to follow up on these to make sure that the credit check (or other activity) is being done, so that an order doesn’t get stuck in limbo.

To be able to easily see these orders I am going to modify the pending sales report. You should find this in the sales section of your reports. Openthe report, set the date range to all, and click the modify report button in the upper left.

In the Filters tab, select Detail Level and set it to All.

CHold009

Add a filter for Item. Select your Credit Hold item from the item list.

CHold010

You should also change the title of the report to Credit Hold.

Your report will not show all pending invoices AND open sales orders that have the credit hold item listed. Memorize this report for future use.

CHold011

Do you have other tricks that work for you? Let me know!

Share This Article

10 Comments

  • This is a good solution and I plan to share it with the students in my class next week. Perhaps you will see some new people subscribing to your Practical QuickBooks site. I teach Advanced QuickBooks (2009 currently) for the MSU College of Technology, Bozeman, MT. This will be a good one to share with some co-workers and clients as well.

  • We currently use the 00 credit balance as an indication that an account needs approval for an order or that the customer is no longer able to purchase because of historic problems. I would like to see the ability to “red flag” these accounts by changing their name to a different color!! on the screen. If you make the account inactive, inevitably, they will get set up again because we “hide” inactive accounts.

  • Very Informative article for my first time visiting your site. Apart from credit hold, I would have loved the feature in PRO2010 that prevents clerks from changing all system prices even when given selective access

  • Thanks so much! This really helps me. Your blog is so informative and helpful.

  • Thanks for the tip about 0.00 credit limit. I tried all the other methods but my sales people would often miss the credit hold tag. This way you get an message reminder even when entering an Estimate.

  • Those are just workarounds and they are not always the best.am sure the quickbooks team has already thought about this but do not want to come up with a product that solves most of the limitations since they know the future versions after that will be meaningless to customers so they keep producing new versions that dont solve anything at all.

    • Yes, these are workarounds – since I am not in charge of their programming staff, workarounds are all that I can offer. Note that there are a number of add-on products that provide greater control of these issues, although I don’t necessarily have one to recommend…