Let’s look at details of QuickBooks 2018 in the areas of security, QuickBooks Payroll, QuickBooks Payments, and QuickBooks Accountant. This is the second of my series of articles on QuickBooks 2018, which includes:
- QuickBooks 2018 Has Arrived! An overview of all the new features and changes, and details on features that apply to QuickBooks Pro, Premier and Enterprise.
- QuickBooks 2018 Additional Details: This article, with details on QuickBooks security improvements as well as updates to QuickBooks Payments, QuickBooks Payroll and QuickBooks Accountant.
- QuickBooks Enterprise Order Fulfillment with Barcode Scanning: This is an exciting, major new feature for Enterprise inventory users!
- QuickBooks Enterprise Order Fulfillment – Part 2: There is so much to talk about here, it will take me two articles!
This provides you with the ability to merge up to 4 vendors at a time.
This is a feature that will be found only in certain editions of QuickBooks:
- QuickBooks Accountant (Client Data Review menu)
- QuickBooks Pro/Premier if you log in as the External Accountant and use the Accountants Toolbox
- QuickBooks Enterprise if you log in either as the Admin user or External Accountant
This is a change that will save you time and effort if you find that you need to merge multiple vendor records often. It isn’t something that I come across often (since I don’t do “cleanup” work), but apparently it is something that many accounting professionals have requested.
Of course, you don’t need this upgrade to be able to merge vendors. You already have the ability to do this. What is changed in this release is that you can now merge up to four vendor records at a time (instead of just two), and you can manage how the data is merged in greater detail than before.
You will find Merge Vendors in the Accountant/Client Data Review menu.
You can locate vendors by searching for text in vendor name, company name, or billed from fields. This search will look for any occurrence of the text, not just search from left to right, which is good.
Select the vendor records (maximum of four) by checking the box in the right column. When you’ve made your selections, click Next.
Specify which of the selected vendor records will be the Master Vendor. The other vendor records will be merged into this one. Several of the fields that are listed will become editable text boxes just for the Master Vendor. This allows you to either edit those fields, or to copy information from the other vendor records. The fields that you can edit are:
- Company Name
- Billed From
- Main Phone
- Account No.
- Vendor Tax ID
- Shipped From
- Main Email
- Print name on check as
- Vendor type
When you are ready to perform the merge you can click either the Merge or Backup & Merge buttons in the lower right. I highly recommend using the Backup & Merge button for the first vendor merge you do in a session, so that you have a good backup in case you don’t like the results. You cannot “undo” a merge other than by restoring a backup.
The merge is going to move all of the transactions for the source vendors over to the Master Vendor. It will not (for the most part) move information from the source vendor records themselves (such as addresses, tax IDs, etc.) to the Master Vendor by itself.
Some things do not get merged into the Master Vendor, such as:
- To Do’s
- Sent Email List
I really would like this feature to be available for Customers as well. In fact, I think it is more common to want to merge customers than it is to merge vendors. If you are importing transactions from a web store (for example), often you will find that the importing software will just create a new customer rather than use an existing customer record. Your customer count can explode, and you may rapidly reach the limit of the number of customers in QuickBooks Pro and Premier. Merging customers will help with that problem. However, I think that merging vendors is a simpler task, technically, so Intuit probably decided to start with the simpler vendor merge task to see how it is accepted.
Details and Issues with Merge Vendors
Let’s look at a few details. I’m not thrilled with some aspects of this feature, but this is an early release of the feature, so there may be improvements in later releases.
- This function only works in single-user mode.
- You cannot merge vendors that are federal/state tax agencies, vendors that have online transactions, vendors with direct deposits, or QuickBooks Payroll Service payroll vendors.
- You cannot merge vendors while there is an accountant copy in use, or if you are logged into an accountant copy.
- You must be logged into the field as the Admin or External Accountant.
- Merging can’t be done if you are using the multi-currency feature.
Keep in mind that this could be altering your financial statements, so be careful. If any of the source vendor records have transactions that occur in a closed financial period you will need the closing date password. Be careful if this is the case! You will receive a warning prior to the merge:
If any of the vendors that you are merging are marked as being 1099-eligible vendors, you will be warned that you will not be able to access any 1099 forms that you filed earlier.
Clunky Copy/Paste: If you want to move information from one of the editable vendor fields into the Master Vendor, there is a copy/paste feature that I find a bit clunky. There isn’t a “drag and drop” option, which would be nice. To move information into the editable field, take the following actions: Highlight the information in the source field, right-click on that information to get a popup menu, select Copy from that menu, highlight the text to replace in the target field, right click, and select Paste. There are no keyboard shortcuts. This is very clunky.
The function does not print a report when done, which I would like to see. At the very least this merge should be listed in the Audit Trail report, but it isn’t.
I’m still playing with the way that this merge handles the user-definable vendor fields. I’m not sure how many people actually use this feature, though. Here’s a blank vendor record that has the user-definable fields set to the default values.
In one test I changed the Main Email field for one of the source vendors to be one of the alternate fields, such as “URL 1.” I didn’t change the fields in the target vendor. When I view the vendors in the Merge Vendor window, the fields that are listed are the default fields. You won’t see any of those alternate field names. In some cases, after the merge, I found that the Master Vendor record would show the alternate field names from one of the target vendors, even if that alternate field wasn’t used in the original Master Vendor. This is something that I need to look at in more detail.