Summary

QuickBooks Online does provide the option to export a General Ledger, however the output document isn't suitable for import into MindBridge which is why we export the Journal instead.

MindBridge also provides the ability to connect directly to QuickBooks Online through our QuickBooks Integration. This allows MindBridge to access the required data without having to go through the process of exporting the journal report, transforming the data and uploading into MindBridge.

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

Common errors related to this Quickbooks export

• MBER1135 - MindBridge cannot read Quickbooks native files. Import a Quickbooks journal report in .xlsx or .csv format and try again. If the issue persists, get help from Customer Support.
  
  

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 your QuickBooks Online account and click Reports on the left menu pane.
   
   
   
2. Scroll down to the section titled For My Accountant and locate the Journal report. Note that by clicking the star icon next to the report you can select it as a favorite. Select Journal.
   
   
   
3. On the Journal page, click Customize.
   
   
   
4. In the Report Period, select Custom from the drop down menu and fill in your desired date range for the report.
   
   
   
5. Click Change Rows/Columns and select the following columns to include in your report:
   • Date
   • Transaction Type
   • No.
   • Memo/Description
   • Account No.
   • Account
   • Debit
   • Credit
   • Created By
   • Created
     
     
     
6. Scroll down the page and click Header/Footer, then deselect the tick boxes to remove the headers and footers from the report. Select Run Report.
   
   
   
7. Scroll to the right of the report and click the Export button. Select Export to Excel from the drop down menu and your report will be downloaded as an Excel Workbook file.
   
   
   

Next Step: QuickBooks Online: 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.