top of page
Writer's pictureUmesh Goswami

Copy more than one transaction from one company to other.


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.


2 views0 comments

Recent Posts

See All
bottom of page