Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Copy multiple transactions from one company file to another

You can export certain types of transaction from one file to another without using a third party application.

To do this you must meet the following criteria:

  • The transactions are either checks, deposits, credit card charges, or credit card credits. (For QuickBooks 2014 you can also do invoices, credits, bills and bill credits.)
  • You are importing the data into QuickBooks 2013 or newer (Accountant's Edition or Enterprise Accountant ONLY).




Detailed instructions

Step 1:   Create a Custom Transaction Detail report for each type of transaction you want to copy to the new company file.

  1. From the Reports menu, select Custom Reports>Transaction Detail.
  2. Click Customize report and modify the report as follows:
    1. Select the Filters tab.
    2. In the Filters scroll box select Transaction type.
    3. From the Transaction type drop-down, select the type of transaction you want to show on the report:
    4. This must be either Checks, Deposits, or Credit Card or CCard Credit.
    5. From the Transaction Type drop-down, select Detail Level
    6. From the Detail Level drop-down, select All Except Summary
    7. Click the Display tab.
    8. Select desired date range.
    9. Select the following columns depending on which transaction type you are creating the report for:
      • Checks: Date, Num (Check Number), Name (Payee), Account, Debit (Amount), Memo
      • Deposits: Date, Name (Received From), Account (Account From), Memo, Num (Check No.), Credit (Amount)
      • Credit Card Charges and Credits: Date, Name (Payee), Account, Debit (Amount), Memo
  3. Click OK to show the report.  
  4. Memorize the report with an appropriate name, if desired.
  5. Save the report as PDF.
  6. Repeat as needed for other transactions types.

Step 2:   Export the report to Excel.

Step 3:  Enter transactions into new company file using the Batch Enter Transactions screen.


If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.



KB ID# HOW19934
4/18/2014 1:01:19 AM
QYPPRDQBKSWS01 9102 Pro 2013 2a55d6