Simplify payday and set payroll to run automatically on QuickBooks.

Green Circle Icon with Stylized White Letters
QuickBooksHelpIntuit

Copy multiple transactions from one company file to another

by Intuit • Image Alt Text •
Image Alt Text Updated 8/5/2026 05:17

Do you need to copy multiple transactions from a QuickBooks company file to another? This is possible in QuickBooks 2018 or newer (Premier Accountant Edition or Enterprise Accountant Edition) for the following transactions:

  • Checks

  • Deposits

  • Credit Card Charges and Credits

  • Bill and Bill Credits

  • Invoice and Credit Memos

This process works on accountant's copy as long as the transaction date is prior to the dividing date. Get more help with setting up a new QuickBooks Desktop company file.

Step 1: Set the Preferences appropriately to allow the export

  1. Disable the use of Account Number.

    1. From the Edit menu, choose Preferences.

    2. Select Accounting and choose Company Preferences tab.

    3. Uncheck Use account numbers, then select OK.

  2. Disable Sales Tax.

    1. From the Edit menu, choose Preferences.

    2. Select Sales Tax and choose Company Preferences tab.

    3. In "Do you charge sales tax" section, select No, then choose OK.

Step 2: Create a Custom Transaction Detail report

  1. From the Reports menu, choose Custom Reports and select Transaction Detail.

  2. Select Customize Reports and modify the report as follows:

    1. Choose the desired date.

    2. Transaction Type: Choose your desired transaction type.

    3. Detail Level: All Except Summary

    4. Select the following columns depending on the type of transaction:
      Checks

      • Date
      • Num (Check Number)
      • Name (Payee)
      • Account
      • Debit (Amount)
      • Memo

      Deposits

      • Name (Received From)
      • Account (Account From)
      • Memo
      • Num (Check No.)
      • Credit Amount

      Credit Card Charges and Credits

      • Date
      • Name (Payee)
      • Account
      • Debit (Amount)
      • Memo

      Bills and Bill Credits

      • Date
      • Num (Ref No.)
      • Name (Vendor)
      • Terms
      • Debit (Amount)
      • Item Description

      Invoices and Credit Memos

      • Date

      • Number

      • Name (Customer:Job)

      • Terms

      • Debit (Amount)

      • Item Description (Description)

      • Item

      • Qty

      • Sales Price (Rate)

      • Amount (Total)

  3. To run the report, select OK.

  4. Memorize the report and save as PDF if desired.

Step 3: Export the report in excel

  1. While the report is open, select the Excel drop-down.

  2. Choose Create New Worksheet.

  3. Select in a new workbook, then choose Export.

Step 4: Batch Enter Transactions

QuickBooks Desktop Mac PlusQuickBooks Desktop Premier PlusQuickBooks Desktop Pro Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

Sign In / Sign Up

Related Articles