cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
4Beth
Level 1

Importing General Ledger & Journal Entries from QB Online to QB Desktop

I haven't used QuickBooks for about 18 months so forgive my lack of skills. I am importing for a non-profit who is no longer using QB online to QB desktop. Both versions are 2020 pro. I have successfully exported the files from QBO to excel and imported the customers & vendors to the desktop. My questions are the correct mapping of the general ledger and journal entries for the last two imports. I come from a banking background and do not want to mix up debits/credits and want to be sure I map these entries correctly. Has anyone does this before that could make suggestions? I have researched on line and they all tell you how to do it, but do not specify how to look up mapping questions (at least that I can find).  Thanks for any help or direction you could provide. Beth

2 Comments 2
katherinejoyceO
QuickBooks Team

Importing General Ledger & Journal Entries from QB Online to QB Desktop

Hi @4Beth

 

Welcome to the Community. It's great to hear you're using QuickBooks again. I'm here to help things clear for you so you can successfully move over your data from QB Online to Desktop. 

 

You can import your journal entries using the Intuit Interchange Format (.IIF) files. However, for General Ledger, QuickBooks doesn't have a way to directly import  them. Hence, you'll have to import them per transaction type using the same file format

 

To do this, download a sample .IIF file and use it as templates for your data to import them into QuickBooks. You can choose between the two versions of these downloadable .IIF kit by clicking the link below:

 

 

Then: 

  1. Save the file to a convenient location on your computer's hard drive.
  2. Use WinZip or a compatible file compression utility to extract the contents of the downloaded file. 
  3. Open the IIF Import Kit folder to view its contents.

 

Once done, transfer your transactions from the Excel to the template. Then, import them in QuickBooks Desktop. See the steps under Import IIFs outlined in this article: Export, import, and edit IIF files.

 

Should you have tons of transactions to transfer, it would be best if you can find a file converter online that will help convert your Excel file into an .IIF file. 

 

For more insight and further instructions when importing transactions from your general ledger, refer to the Transactions Type, then click the link under the File Name in this help article: IIF Overview: import kit, sample files, and headers. It also contains screenshots for your visual guide. 

 

I'm always around here to help if you have more concerns. Stay safe. 

Fiat Lux - ASIA
Level 15

Importing General Ledger & Journal Entries from QB Online to QB Desktop

@4Beth 

If you are not familiar with IIF, you may utilize a 3rd party migration tool. i.e TP Exporter for Online and TP Importer for Desktop.

https:// transactionpro.grsm.io/qbo

 

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