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.

Reply to message

View discussion in a popup

Replying to:
Rea_M
Moderator

Reply to message

Let me share details about exporting general journal entries in QuickBooks Desktop (QBDT) Premier 2020, @zafersh. This way, you'll be able to determine how to get the data you need and effectively manage your transactions.

 

Yes, you're correct. The General Journal isn't available on the list of data that can be exported using the IIF file using QBDT Premier 2020. You can only export the data listed in the Export window (i.e. Chart of Accounts, Customer/Vendor/Employee/Class List). However, it's still possible to acquire the information you need by exporting the Journal report to an Excel file from the Reports menu. Here's how:

  1. Go to the Report menu.
  2. Select Accountant & Taxes, then choose Journal.
  3. Click the Customize Report button to focus on the info you need.
  4. Select the Excel button.
  5. Choose either Create New Worksheet or Update Existing Worksheet.

 

I've attached screenshots below that show the last three steps.

 

The QBDT program provides different reports that cater to your business needs. For the complete list of available reports, kindly check out this article: Understand reports. It also contains details about how QuickBooks generates one.

 

I',m also adding this article to learn more about other ways to import and export info in QBDT: Import and export data in QuickBooks Desktop. It contains related articles and things to keep in mind when importing and exporting data.

 

Please let me know if you have other concerns. I'm just around to help. Take care always.

Need to get in touch?

Contact us