cancel
Showing results for 
Search instead for 
Did you mean: 
todjenhog
Level 1

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

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.

Solved
Best answer June 19, 2021

Best Answers
RCV
QuickBooks Team
QuickBooks Team

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

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.

View solution in original post

8 Comments 8
Fiat Lux - ASIA
Level 15

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

RCV
QuickBooks Team
QuickBooks Team

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

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.

View solution in original post

todjenhog
Level 1

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

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.

Ryan_M
QuickBooks Team

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

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!

todjenhog
Level 1

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

 
todjenhog
Level 1

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

I would love to export/import my credit card and checking transactions utilizing the IIF files; however, every time I attempt to export them the only options I get is to export lists and addresses.  I'm going to file>utilities>export.  Can you provided step-by-step instructions on how to export those transactions?

CharleneMae_F
QuickBooks Team

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

I know why you're unable to export credit cards and checking transactions, todjenhog.

 

In QuickBooks Desktop, you can only import transactions. To export your transactions, I'd suggest utilizing third-party apps. You can select the best app you'd like to use by going to Intuit Marketplace website.

 

As for importing credit card transactions, you can download and save them on your computer as Webconnect (.QBO) files. Then, you can import them so they become available in your Bank Feeds. I'll show you how. Please ensure your financial institution supports (.QBO) file.

 

  1. From the Banking menu, select Bank Feeds.
  2. Choose Import Web Connect Files.
  3. Select the QBO file you saved, then select Open.
  4. When prompted to Select Bank Account, select:
    • Use an existing QuickBooks account if the account you're importing transactions into is already set up in QuickBooks.
    • Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
  5. Select Continue. You'll see a dialogue box telling you that the data has been successfully read into QuickBooks. Click on OK.
  6. Go to the Bank Feeds Center to review your transactions.

 

For your visual reference, I've attached some screenshots below.

Capture.PNG Capture1.PNG

 

To learn more about the data you can enter and move from QuickBooks, please check our Import and Export Overview.

 

Once you import your transactions, you can now start adding and matching them in QuickBooks Desktop. This ensures your books are accurate. I'd also recommend reconciling your accounts to match them to your bank and credit card statements.

 

Please come back and keep us posted if you have other questions in exporting or importing transactions. We are always here to help.

Fiat Lux - ASIA
Level 15

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

@todjenhog 

You need an exporter tool as I mentioned earlier.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up