![QuickBooks Help](https://uxfabric.intuitcdn.net/web-app/sh-exp-sbg-app-experience/sbg_ohh_icon.19f2ae89.png)
Copy multiple transactions from one company file to another
by Intuit• Updated 1 month ago
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
- Disable the use of Account Number.
- From the Edit menu, choose Preferences.
- Select Accounting and choose Company Preferences tab.
- Uncheck Use account numbers, then select OK.
- Disable Sales Tax.
- From the Edit menu, choose Preferences.
- Select Sales Tax and choose Company Preferences tab.
- In "Do you charge sales tax" section, select No, then choose OK.
Step 2: Create a Custom Transaction Detail report
- From the Reports menu, choose Custom Reports and select Transaction Detail.
- Select Customize Reports and modify the report as follows:
- Choose the desired date.
- Transaction Type: Choose your desired transaction type.
- Detail Level: All Except Summary
- 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)
- To run the report, select OK.
- Memorize the report and save as PDF if desired.
Step 3: Export the report in excel
- While the report is open, select the Excel drop-down.
- Choose Create New Worksheet.
- Select in a new workbook, then choose Export.
Step 4: Batch Enter Transactions
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Unmatch downloaded bank transactions or move them to another accountby QuickBooks•1185•Updated June 25, 2024
- Merge duplicate accounts, customers, and vendors in QuickBooks Onlineby QuickBooks•3508•Updated 1 day ago
- Create recurring transactions in QuickBooks Onlineby QuickBooks•2077•Updated May 28, 2024
- Manually upload transactions into QuickBooks Onlineby QuickBooks•3367•Updated 3 days ago
- Create or add another company file to QuickBooks Onlineby QuickBooks•4938•Updated May 30, 2024