Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mburhansafi
Level 2

I want to transfer each and every transaction from one company file to another

Hello i want to transfer all my transactions from one company file to another.
i have already tried using the utility option and till now i have imported the Lists but im stuck with the transactions. kindly guide on what to do  ?  im more interested in any free option as i dont want to pay any extra amount to do it.

3 Comments 3
AnneMariee
QuickBooks Team

I want to transfer each and every transaction from one company file to another

Hello there, mburhansafi.

 

Allow me to assist you in moving your transactions from one company file to another.

 

First, you need QuickBooks 2018 or newer (Premier Accountant Edition or Enterprise Accountant Edition) to do so. Additionally, please take note that you can only move the following transactions.

 

  • Checks
  • Deposits
  • Credit Card Charges and Credits
  • Bill and Bill Credits
  • Invoice and Credit Memos

 

To enable exporting, you'll need to adjust your preferences by disabling account numbers and sales tax. Once that's done, create a custom Transaction Detail report to get you the data you need. Here are the steps to follow:

 

  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

 

Afterward, depending on the type of transaction, select the corresponding columns. Please refer to the guide below.

 

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)

 

Then, proceed to run the report. Lastly, export it to Excel to continue to the next step.

 

Once you've exported the report in a new workbook, enter the transactions by batch in the new company file. For detailed instructions, please feel free to browse this article: Enter transactions by batch.

 

QuickBooks Desktop offers different reports to cater to your needs. You might want to generate them to get a comprehensive overview of your business. Here's an article on how: Understand reports.

 

Don't hesitate to post again here if you have other questions or concerns about transferring your transactions to QuickBooks. I'm always around and happy to help. Stay safe and have a good one!

Zed Axis
Level 3

I want to transfer each and every transaction from one company file to another

Hi @mburhansafi  this is really only to add to the answer already give by @AnneMariee .  If you are looking for a way to transfer the other transactions like Journal Entries, Purchase Orders, Sales Orders which are not covered by AnneMariees reply then you should have a look at some of the data import and export utillities that you can find in the Intuit Apps for QuickBooks listing. 

 

With an app like Zed Axis it is possible to batch export out to Excel all transactions types and then import those into another QuickBooks desktop company file. 

 

Hope that helps with your transfer... 

4Gal
Level 11

I want to transfer each and every transaction from one company file to another

@mburhansafi 

im more interested in any free option as i dont want to pay any extra amount to do it.

 

Unfortunately IIF only offers limited functionality to migrate transactions. You should reconsider to use a migration tool. It's $299 one time license and you can get $100 cashback to purchase thru a partner.

https://get.transactionpro.com/qbd

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us