cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Debit n Credit
Level 1

Moving Transactions from one company file to a new one

Hi,

I having been running 2 companies in QuickBooks Desktop Pro 2020 and now I'm wanting to combine the 2 into one new file, with opening balances from the start of my fiscal year. Is there a way I can transfer all my transactions (Bills, payments, invoices, credit card charges, etc.) since then into the new file? I have been able to import my lists (customers, vendors, etc.) but have not found a way to transfer transactions.

Any help will be appreciated!

5 Comments 5
4Gal
Level 11

Moving Transactions from one company file to a new one

You can use a migration tool. You only need to purchase a single one time license $299 to do so.

https://get.transactionpro.com/qbd

 

Another option, purchase a 3rd party file merge service.

MJ_R
QuickBooks Team

Moving Transactions from one company file to a new one

Hi Debit n Credit,

 

Welcome to the Community! Thank you for reaching out, I'd be happy to provide some assistance with moving your transactions to your new account.

 

To combine your two companies in QuickBooks Desktop Pro 2020 and transfer transactions to a new file, I recommend following these steps:

 

  • Backup Your Existing Company Files:
    Before making any changes, backup both of your existing company files. This ensures you have a safe copy in case anything goes wrong.
  1. Export Transactions from Company A:
     a) Open Company A in QuickBooks Desktop Pro 2020.
    b) Go to the File menu and select Utilities.
    c) Choose Export and then select the Lists to IIF Files option.
    d) Export relevant transactions such as bills, payments, invoices, and credit card charges.
     
  2. Import Transactions into Company B:
    a) Open Company B (the new file) in QuickBooks Desktop Pro 2020.
    b) Go to the File menu and select Utilities.
    c) Choose Import and then select the IIF Files option.
    d) Import the IIF files you exported from Company A. Map the fields correctly during the import process.
     
  3. Review and Adjust:
    a) After importing, review the transactions in Company B.
    b) Ensure that opening balances are correctly set for both companies.
    c) Make any necessary adjustments to match the data accurately.
     
  4. Reconcile and Verify:
    a) Reconcile your accounts in Company B to ensure everything balances.
    b) Verify that all transactions, balances, and opening balances are accurate.
     
  • Consult with an Accountant:
    It’s advisable to consult with an accountant or bookkeeper to ensure compliance and accuracy. They can guide you through the process and provide specific advice based on your unique situation.


Remember to take your time during this process and double-check everything to avoid any discrepancies. If you encounter any issues, consider using third-party tools as mentionned in the reply above.

 

If you have any other questions, don't hesitate to reach out. I am here to help.

 

The Chic CPA
Level 1

Moving Transactions from one company file to a new one

Is it the same process for 2 QuickBooks Online companies?

Alex M
QuickBooks Team

Moving Transactions from one company file to a new one

Hi there The Chic CPA,

 

Thanks for reaching out about importing transactions. QuickBooks Online is a great tool able to assist you in keeping track of sales and expenses so you know the profitability of your books. I can provide some information as to what can be imported.

 

There is a list of information that can be imported from files in QuickBooks Online, including lists and transactions included in this article. There's also some more information regarding common questions about the import processes.

 

If you have any other questions, feel free to reach out here.

4Gal
Level 11

Moving Transactions from one company file to a new one

@The Chic CPA 

Do you need to migrate data from one QBO account to another one, or merge 2 QBO accounts into one account?

Need to get in touch?

Contact us