Skip to main content
June 19, 2021
Solved

Transfering Transaction from one QB file to another & Pro Advisor Version

  • June 19, 2021
  • 2 replies
  • 0 views

I have Quick Books Desktop Pro 2020.   I own 2 LLCs.  I entered several transactions in the wrong LLC and I need to move them to the other LLC.  I've been trying to determine how to do this without entering all of them manually.  From what I can tell, I need to utilize the accountant tab and perform a batch export/import.  I don't have the account tab.  It seems I need a Pro Version to do this?  Is there another way to preform the batch actions or am I eligible to get a Pro Version being I'm not an accountant?  Bottom line, how can I move the transactions without doing it manually?  Thanks in advance.

Best answer by RCV

Thanks for checking in with us, todjenhog.

 

We can import and export Intuit Interchange Format (IIF) files to and from QuickBooks Desktop for Windows and Mac. The IIF files helps you import and export your lists and transactions to and from QuickBooks Desktop. For QuickBooks Desktop 2019 and later, here’s how to import your lists and transactions with the improved IIF tool. With the use of IIF files, you can do the following:

  • Export lists from one QuickBooks company file and import them into another
  • Import lists or transactions into QuickBooks from another program
  • Export list to and Import data from the QuickBooks Pro Timer.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise, or between Windows and Mac)

 

To learn more about this one, see the Tasks you can do with IIF files article. Also, instead of starting from scratch, you can transfer info to and from QuickBooks. This makes it easy if you need to convert, upgrade, or create a new company file. For the steps and details, check out the Import and export data in QuickBooks Desktop article.

 

Feel free to visit our Bring in your data page for more insights about importing your data.

 

I'd like to know how you get on after trying the steps as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

2 replies

RCVAnswer
June 19, 2021

Thanks for checking in with us, todjenhog.

 

We can import and export Intuit Interchange Format (IIF) files to and from QuickBooks Desktop for Windows and Mac. The IIF files helps you import and export your lists and transactions to and from QuickBooks Desktop. For QuickBooks Desktop 2019 and later, here’s how to import your lists and transactions with the improved IIF tool. With the use of IIF files, you can do the following:

  • Export lists from one QuickBooks company file and import them into another
  • Import lists or transactions into QuickBooks from another program
  • Export list to and Import data from the QuickBooks Pro Timer.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise, or between Windows and Mac)

 

To learn more about this one, see the Tasks you can do with IIF files article. Also, instead of starting from scratch, you can transfer info to and from QuickBooks. This makes it easy if you need to convert, upgrade, or create a new company file. For the steps and details, check out the Import and export data in QuickBooks Desktop article.

 

Feel free to visit our Bring in your data page for more insights about importing your data.

 

I'd like to know how you get on after trying the steps as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

todjenhogAuthor
June 19, 2021

No, your response is not helpful.  I read through all of the articles and they seem circular.  I don't want to export lists or addresses and the articles you referenced only seem to relate to lists and addresses.  I want to export expenses i.e. credit card transactions and checks.  I do not see any information on how to accomplish this task.

June 19, 2021

Thank you for the prompt reply. Allow me to join the thread and handle your query about entering transactions by batch, @todjenhog.

 

The feature you described in your initial post is Batch enter transactions. This is a feature that's exclusive in the QuickBooks Desktop (QBDT) Accountant and Enterprise versions. 

 

What my peer @RCV stated above is correct for your situation. You can utilize IIF files to transfer transactions from one company file to another. Other than lists, it can import credit card transactions as well. 

 

Here's a list of every type of transaction you can import with this feature: 

  • Account beginning balances
  • Cash sales to customers
  • Checks
  • Deposits
  • Invoices
  • Account transfers of funds
  • Vendor bills
  • Cash refunds to customers
  • Credit card transactions
  • Estimates
  • Payments from customers
  • Vendor bill refunds
  • Credit card refunds to customers
  • Credit memos to customers
  • General journal entries
  • Purchase orders

If you want to go a different route, you can also use a migration tool like what @Fiat Lux - ASIA stated above. Or, you can take a look at this page: Apps for QuickBooks Desktop. It's a complete list of third-party apps you can link to your QBDT company.

 

Tag me in a comment below if you have additional questions about importing transactions in QBDT. I'll be around to help you out. Enjoy your weekend!