Perform QuickBooks Export Transactions to Another Company File in No Time!

When it comes to managing your own business, your approach should be smart and sensible. You might wish to take your business to better heights and will be interested in acquisitions or mergers. QuickBooks is a great choice for small and medium-sized businesses. 

With two business units merging, skills related to record keeping is important. Tallying and maintaining both accounts, and updating both companies’ information in one place will be another vital task. This is where QuickBooks will be the best possible solution for your business. As it makes things logically magical with a pinch of quick calculations.

With this, you need to copy all the data in one place. It means you need to export multiple transactions and get them imported into another Company’s file. This smart tool comes in handy if your accountant wishes to update the balance sheets for both companies or work on a profit and loss statement. Both companies’ transactions, invoices, memos, checks, deposits, credit card charges and credits, bill and bill credits etc have to be merged. 

The ease of operation and error-free results will keep things smartly smooth. Long hours of calculation can be done quickly.  For added flexibility, this source and destination company files can be on different QuickBooks versions and even on different machines. But due to cloud storage technology, there are no boundaries of location or devices. We can explore several opportunities to keep this streamlined.

Process of QuickBooks Export Transactions to Another Company File

Step One: Set the Preferences Appropriately to Allow the Export

1. Disable the use of Account Number:
   • Hover your mouse over the Edit menu and choose Preferences
   • Then, select Accounting and choose the Company Preferences tab.
   • Unselect the Use account numbers, and press OK.
2. Disable Sales Tax:
   • From the Edit menu, choose Preferences.
   • Select Sales Tax and choose Company Preferences tab.
   • In the prompt section, select No, then choose OK

Read Also : How to Export an Invoice from QuickBooks?

Step Two: Make a Custom Transaction Detail Report

1. From the Reports menu, choose Custom Reports 
2. Select Transaction Details and Customize Reports:
   • 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)
3. To run the report, select OK.
4. Save the report as PDF if desired.

Step Three: Export the Report in Excel

1. Once the report is opened, select Excel from the drop-down menu.
2. Choose to Create New Worksheet.
3. Then choose Export.

How to Export QuickBooks Customer List in Easy Steps?

All you need to do is to export the QuickBooks reports in Excel and you can either choose to keep it as it is or update it in your Chart of Accounts (COA) as another segregation.

Not only record keeping; but maintenance, updates, and access have become better with the usage of QuickBooks. Your record keeping will never look dull to you as the exporting work is faster and easier.

Copy Transactions From one QuickBooks Company to Another QB Company

The ownership changed mid-year 2020, and now they want to use different Quickbooks companies before and after the change. How do I move all transactions from a specific date to the new Quickbooks company?

Here’s how to download the Customer, Vendor, Inventory, and Payroll lists from your customer’s new QuickBooks company file:

• Open the Customer/Vendor/Inventory/Payroll center in QuickBooks.
• Select the Excel drop-down menu ▼.
• Choose “Export Customer/Vendor/Employee List” if you want to export data such as names, balances, and contact information.
• In the Export window, select whether you want to create a new worksheet or update an existing worksheet.
• Click the “Export” button.
• The data will be exported to Excel. Open the exported file in Excel.
• Edit the information in Excel as needed, such as updating names, balances, or contact details.
• Save the changes you made in Excel.

On the other hand, you can follow these steps to download your transactions list:

• Go to the Reports menu in QuickBooks.
• Scroll down to the Customer and Receivables section.
• Choose the “Transaction List by Customer” report.
• Set the desired date range for the report.
• Click on the Excel drop-down menu from the toolbar.
• Select “Create New Worksheet.”

• Click the “Export” button.
• Follow the on-screen instructions to complete the export process.

Now you can import them into your new company file. Let’s import them now.

• Go to the “File” menu in QuickBooks.
• Select “Utilities.”
• Click on “Import,” and then choose “Excel Files.”
• If you encounter the “Add/Edit Multiple List Entries” window, select “No.”
• Follow the instructions provided by the import wizard to complete the process of importing the file.

Infographic to Copy QuickBooks Transactions from Company File to Another Company File

Need Professional Help?

If you want an ardent techie to help you with QuickBooks export transactions to another company file, get in touch with the QB technical help desk team by calling us through smbaccountants.com.

FAQ

---