This article tells you how to copy a transaction from a QuickBooks company file. These steps work only for QuickBooks 2014 or newer (Premier Accountant Edition or Enterprise Accountant Edition) for the following transactions:
Checks / checks deposit
Credit card charges and credits
Bill and Bill Credit
Invoices and Credit Memos
This process works on the copy of the accountant, as long as the date of transaction occurs before the date of partition. Create a QuickBooks Desktop Company File View: Overview for other workflows, you can use to create a new QuickBooks desktop company file.
Step 1: Set appropriate priorities to allow exports.
1. Disable account number usage
From the Edit menu, click Preferences.
Select Accounting and click on the Company Preferences tab.
Use the uncheck Account numbers and click OK.
2. Disable sales tax
From the Edit menu, click Preferences.
Select Sales Tax and click on the Company Preferences tab.
In No, you charge the Sales Tax section and click OK.
Step 2: Create a Custom Transaction Extension Report
1 From the Reports menu, select Custom Report and click on Transaction Detail.
2 Click Customize Report and modify the report as follows:
a Select the desired date
b Transaction type: Choose the type of transaction you want
c Expansion level: all except summary
d Depending on the type of transaction, select the following columns:
Checks / checks
deposit
Credit card charges and credits
Bill and Bill Credits
Invoices and Credit Memos
3. Click OK to run the report
4.Remember to report and save as PDF if desired
Step 3: Export reports in Excel
If the report is open, click on Excel
Select Create New Worksheet
Select a new workbook and click Export.