Summary

This guide goes through the step by step process of preparing and exporting a journal report from QuickBooks Desktop.

Notes

It's worth noting that QuickBooks Desktop does provide the option to export a General Ledger, however the output document isn't suitable for ingestion into MindBridge which is why we export the Journal instead.

Extract data

Watch the following video on how to extract data or read the steps outlined below.

Open the video in YouTube for high resolution. 

1. Log in to QuickBooks Desktop/Enterprise Solutions. On the menu bar at the top of the screen, click Reports > Accountant & Taxes > Journal.
   
   
   
2. Click Customize Report in the top left.
   
3. Select the desired date range of your report and select the following columns to add to your report, then click OK.
   • Trans #
   • Type
   • Entered/Last Modified
   • Last Modified By
   • Date
   • Num
   • Name
   • Memo
   • Account
   • Debit
   • Credit
     
4. Navigate to the top of the screen and select the drop down menu next to Excel, then click Create New Worksheet. Please note that an excel workbook can display a maximum of 1,048,576 rows. If your report exceeds this, please select to export as a comma separated values (.csv) file. Click Export. This will open the file in Excel and you will be able to save a copy in the desired location.
   

Next step: QuickBooks Desktop/Enterprise Solutions: Transform the general ledger

What do you think of this guide? If you have any feedback, or you think you can help us improve it, then we would love to hear from you! Let us know if this article was helpful or not below. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.

Anything else on your mind? Chat with us or submit a request for further assistance.