Copy Transactions Between QuickBooks file

The below-given article will explain the steps to copy transactions between QuickBooks files. Walk through the information to save your time:

How multiple transactions are copied from one company file to another?

Solutions we are going to provide will work for the 2014 version of QuickBooks or other newer version for the transactions given below:

  • Cheques
  • Credits and Credit Card charges
  • Deposits
  • Credit and Invoice Memos
  • Bill Credits and Bill

Make sure that you try this process on the accountant’s copy if the transaction date is before the dividing date.

1. Step One: Preferences should be set appropriately in order to allow export

  1. Disabling the Account Number’s use
  2. Go to the Edit menu and then click on Preferences
  3. Choose Accounting and then tap on the tab of Company Preferences
  4. Make sure that the checkmark is removed from Use account numbers and then click on OK
  5. Disabling the Sales Tax
  6. Go to the Edit menu and then click on Preferences
  7. Choose Sales Tax and tap on the tab of Company Preferences
  8. Now in the section of Do, you charge sales tax, select No and then click on OK

2. Step Two: Creating the report of Custom Transaction Detail

  • Go to the Reports menu and then select Custom Reports after that tap on the Transaction Detail
  • Click on the Customize Reports and then make the modifications in the report as given below:
    1. Select desired date
    2. In Transaction Type, choose the transaction type which you want to keep
    3. In Detail, Level choose all except summary
    4. Then choose the columns based upon the transaction type:
      • Cheques/Checks
      • Cheque Number
      • Date
      • Name of the Payee
      • Debit Amount
      • Memo
      • Account


  • Name
  • Date
  • Account
  • Cheque Number
  • Memo
  • Credit Amount
  1. In order to run the report, click on OK
  2. Make sure that report is memorized for you and you can also save it in the form of a PDF

3. Step Three: Exporting the report to the excel

  • Keep the report open and then click on the drop-down of Excel
  • Choose to Create New Worksheet
  • Then choose in a new workbook and then tap on Export

Copying information from one company file to the other one

To copy information from one file to another:

  • Go to the current data file and then tap on File and then Utilities after that on Lists. Choose the lists that you are willing to be copied on the New Data File, keeping the Chart of Account’s exception in mind, will work on it in the next step. Then select the place where you wanted to save the file and also add the name of the file by applying the extension of IIF.
  • In the current data file of yours, tap on File, and then from the company file that is existing, choose New Company. After typing the New Company Name, click on Create Company. By doing this, the Chart of Accounts will be copied excluding data in the New Data file. The data accounts could be deleted only at this time, so make sure the changes which you are willing to make are done at this stage.
  • After that get the New Data File opened and then click on the File then on Utilities then on Import and after that on IIF files. The list which was exported by you will get copied without the balances. You can easily manage your data at this stage, by deleting the items, vendors, and customers that you do not need any longer.
  • Here, you have to get the information of the New Company entered here, for example, Business number, etc. now in the setup, you can get the opening balances added. Remember not to enter the opening balances in the Accounts Payable and Accounts Receivable. In order to create balances, make sure that Vendor Bills and Customer Invoices are created in the New Company only.

Issues or Questions that Users face

You may be using QuickBooks Pro since a long-time as a sole proprietor. For example, you incorporated your account in 2015 and now your account is advising you to create the new Company File. Chart of Accounts is going to remain the same with the Owner’s Equity as an exception being replaced with the Share structure.

What you want to know is whether you will be able to copy the current sales data and customer list to the new file. You want this because you do not want to re-enter the customer addresses of past years and also all your reports are able to show the previous/historical data.

If you are facing such issues/questions or any other situation like this, then without being hesitant get in touch with the SMB QuickBooks technical support team. You can easily get in touch with the SMB QuickBooks tech support helpdesk on


  1. How can I create a copy of an existing company file in QuickBooks?

    💠 Open your QuickBooks Desktop & company file you need to copy
    💠 Hit on the F2 button to display the product information window
    💠 Locate the file info part to know the information related to the company file
    💠 Use the backup file to restore the company file.
    💠 Now rename the file you get after restoring the file.
    💠 It will generate a unique copy of the genuine company file.
    💠 Now save the new file.
    💠 Now you have copies of the company file

  2. How can I delete the transactions from the copied company file in QuickBooks?

    💠 Open the new company files.
    💠 Verify it
    💠 Locate the file option and then hit on Utilities
    💠 Choose to Condense data
    💠 Click on the yes option if you get a message about removing data.
    💠 Choose All transactions in the condensed Data window.
    💠 Hit on the Next button
    💠 Follow the instructions displayed on the screen to delete the copied transactions.

  3. How to check the status of the transaction in the accounts?

    💠 Locate Reports option
    💠 Hit on Reports center
    💠 Discover the Account & Taxes button
    💠 Now open a transaction list through the Date report
    💠 Set the date range for the report so that it begins before the past transaction in the file you copied

You've Reached your Limit of Free Articles. Subscribe to Read Full Article.

Your QuickBooks Help Awaits

Benefits of Subscribing:

Unlimited access to Website Resources, Free Consultation from certified Experts, Latest updates and news for QuickBooks.

No Spams, Guaranteed!