« November 2015 | Main | January 2016 »

3 posts from December 2015

How to Duplicate an Inventory Part or Assembly in QuickBooks

Did you know that QuickBooks Pro, Premier and Enterprise editions provide a handy feature that will allow you to duplicate an item setup quickly?

Tucked into the Item button at the bottom of the Item List (or accessed by right clicking anywhere in the item list), you will see the "Duplicate Item" option, as shown below:

Duplicate Item Button

Just choose the item you would like duplicated, click the Duplicate Item button and a new item screen will appear with a "DUP" in the item number box.

QuickBooks copies over all the settings and details from the existing item into the new item listing. From there, you can edit, change, and delete information as desired.

This is a huge timesaver when working with inventory assembly items and inventory parts. You don't have to build the item again from scratch - just update the information that has changed!




Merging Files in QuickBooks - Should You? Shouldn't You?

A number of inquiries have come in lately asking about "merging" two or more QuickBooks files together, and whether it could be done or not.

The better question to ask before asking if it could be done is...

"Should it be done?

Should you really merge two QuickBooks files together?"


To make sure we're on the same page here, let's get a few definitions out of the way first (at least how I see them).

  • Merge - to actually combine ALL the contents of separate QuickBooks files together so that one QuickBooks file remains
  • Import - to selectively choose information (i.e. customers, inventory) and extract it from one QuickBooks file and pull it into another QuickBooks file


Over the years, I've heard many different scenarios where someone wants to merge QuickBooks files together.

To my original question about "should" you merge them?

My answer is a resounding NO.

Here's why I say you should NOT merge QuickBooks files together...

  • There is no direct way to accomplish this - no magic button exists within QuickBooks to merge files
  • The integrity of the file that is being merged into is completely lost - I shudder to think about the consequences of smashing two QuickBooks files together into one (try running historical financial reports after the merge - I think your CPA would have cardiac arrest at that point!)
  • Problems will inevitably surface (customer payments not applied correctly, incorrect bank reconciliations and many more potential headaches)


If there is a legitimate need to combine the information from two or more QuickBooks files, my suggestion is to create a brand new QuickBooks file as of a certain point in time (i.e. new fiscal year, beginning of a quarter, etc.). Leave the history in the old files for lookup purposes, and put future transactions in the new file. I think this will save you a ton of grief in the long run.


There are several ways to pull information from one QuickBooks file or external source to another QuickBooks file, including:

Even though these tools exist, it is still absolutely essential that you understand what they do, how they may impact existing information, and make sure that everyone is on board (including your outside accountant) about how your historical information may or may not change as a result of importing information into QuickBooks.


You've read my take on merging QuickBooks files.

What's your take? Do you agree? Disagree?

Please drop your comments in the box below (or if you are reading this via e-mail, click the "view in browser" link to get to the comments box)



QuickBooks Enterprise 2016: Seven Critical Situations When It is a Good Fit

QBES Box Shot (left) copyGet the facts and eliminate the fiction about QuickBooks Enterprise software.

Download my free guide that helps you understand when QuickBooks Enterprise makes
sense, including:

  • When your QuickBooks file gets too big for itself
  • When you need more users working inside QuickBooks at the same time
  • When you have hit the 14,500 limit for customers, vendors, inventory
  • Other critical times in the life of your business and QuickBooks software