It Worked!

"I just wanted to provide you with the link to the blog post I did today for our company's blog: in which I talked about the Quickbooks 14500 club. I have happily decreased my customer master file by half - thanks to you and your wonderful program. Thanks again for your help."
Benecia Beyer - Accountant
DiVita & Associates, Inc.

Thanks Mark. We have a lot of repeat customers whose information we probably lost but we were able to cut our customer list down by thousands. I'm glad I found your program!
Regards Jack & Debbie LaBrake - LaBrake's Garden Path & Pond LLC -
ANSWER: No Information was lost in this process - Check the "Retail" account and you'll see that everything's there. Besides, you've got your backup.


Note: Some browsers will report that this is a dangerous file because it contains a "keyboard script." Call me if you have concerns. Check the Tips for a successful demo below. Demo limits you to 10 merges at a time.

Quickbooks 14500 Solution

Quickbooks 14500 Solution will allow you to continue using Quickbooks after the 14,500 limit has been reached.The demo version demonstrates how this works by merging up to 10 customers, items, and vendors.

Note: Your computer may give you a VIRUS WARNING when downloading this. This is because this program uses a "keyboard macro" and makes Quickbooks think you are hand-typing the "merge" commands into the keyboard. This is the only way Quickbooks will allow it.  In any case, if it was a virus and hacked into your computer to steal $3,000.00 -- oh wait, you already HAVE that virus. It's Called Quickbooks!



Quickbooks 14500 Solution C Quickbooks 14500 Solution  Free Trial

Merges up to 10 Customer, Vendors, or Items. Free Support to get it working



See below for:

1 - Tips for a Successful Demo

2 - Quickbooks changes "All Customer" view to "Active Customers" after each Merge.

3 - Troubleshooting Steps


1 - Tips for a successful Demo

This is NOT the correct Customer screen. See next photo.

This is NOT the correct Customer screen


This is the correct customer screen.

1. Display "All Customers" with

2. the inactives sorted at the top of the list (see the X with the down-pointing triangle)

inactives sorted at the top of the list


In Edit->Preferences, Uncheck "Press Enter Moves Between Fields"



Make sure thare are no date warnings or Date Password for closed years. You'll need to be logged on as an administrator.

Don't worry, merging past year transactions will not change any financial data.

No Warnings, No closeing Date


2 - Quickbooks changes "All Customer" view to "Active Customers" after each Merge.

This is a squirrely little problem that a few users have reported. This has been discussed on the Quickbooks forum and is an admitted bug in Quickbooks (the only one?). Sometimes, inexplicably, the sorting order changes after merging. Often, it can be fixed by re-sorting the list, changing the view, then changing it back (doesn't make sense to me, either). Click View, change the view from Left to Top. Try a Manual Merge and verify that the "All Customers" box stays the same. Now, you can change it back to Left Hand view. Also, Re-Sort the list. If that doesn't work then this program will not work for you and I can't tell you why.

Sort Order Changes in Quickbooks

3 - Troubleshooting Steps:

This program is called a "Keyboard Script". It works by simulating they keystrokes needed to merge Customers, Vendors, and Item.

If you can type these commands from the keyboard and successfully merge, then the program should work. If not, determining which keystroke is NOT working as intended identifies the problem. Please type these keystrokes:

Note, there are some other keystrokes that are entered on certain conditions, like if a window does not close, but these basics will provide us the troubleshooting we need.



Highlight the first customer

<Ctrl> e                  ;Brings up the customer edit screen
000Retail <Enter>    ;Changes the name of the customer
Y                           ; Answer Y to Merge Question
Y                           ; If there is a duplicate shipping address, answer Y
<DownArrow>         ;Next Name
...and Repeat


Items (Inventory Parts and Non-Inventory Parts):
Highlight Inventory Assembly or Service
<Ctrl> e                     ; Edit Item Window should appear with cursor in the TYPE field
<tab>                        ; Move cursor to the name field
000MrgItem <Enter>    ; Enter the new name
Y                                ; Answer Y to Merge Question
<DownArrow>              ; Next Item highlighted
... and repeat
Items (Inventory Assemblies and Service):
Highlight Inventory Assembly or Service
<Ctrl> e                       ; Edit Item Window should appear with cursor in the TYPE field
000MrgItem <Enter>      ; Enter the new name
Y                                 ; Answer Y to Merge Questi
... and repeat
Highlight the vendor
<Ctrl> e
MergedVendor <Enter>
... and repeat

Your program worked PERFECTLY! Thank you so much for having the smarts and making the effort to build this program. We upgraded all our software and computers, only to have the POS integration fail because of our 10,000 customers + vendors and items exceeding the 14,500 limit. All Quickbooks said was too bad, upgrade to Enterprise, which was totally unnecessary for us...a small chocolate/candy store that uses Quickbooks Point of Sale and never should have been transferring customers to Quickbooks in the first place...totally not needed. Thanks again. Probably the best $75 this store has ever spent!

- Tim Downey

You are a GENIUS!! Thank you for coming up with that script. I have successfully merged all my customers so I can now import new orders into QB. This has been a tremendous help.
Discount Catholic Store, Inc, Charlotte, NC 28273
[Thanks, but if I'm so smart how come I'm using Quickbooks?]

  Hi Mark,
I just finished using your program to reduce the size of my Quickbooks customer list and would like to say that it works exactly as you advertise. I would recommend it to anyone that runs into the 14500 Quickbooks customer limit. I was not about to spend $3,000 to upgrade to Enterprise just because I am unable to remove old customers. I own a rapidly growing company ( and can find other more important places to spend $3,000. Thank you for a great solution to a problem that many Quickbooks users will eventually face.
Best regards, Rob WagnerPresident - LandAirSea Systems, Inc