Questions? We have answers.

Sage Intacct: Export the general ledger

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn how to export a general ledger file from Sage Intacct.


Notes

  • There is a General Ledger report that can be exported from the General Ledger menu, however this export requires additional data formatting before importing into MindBridge. In this article we will show you a different way of exporting the General Ledger details report that will only require minimal data transformation. 
  • We recommend exporting to CSV because Sage Intacct Excel exports are to XLS (not XLSX) files, which have a 65,536 row limitation.
  • Alternatively, you can use our direct Sage Intacct integration.  


Extract data

  1. From the homepage, click the Applications drop-down in the top of the page. Click Reports - Custom Reports.
    1.PNG

  2. You will be taken the Custom Report Wizard, where you can define the metrics for the exported report. Select General Ledger Detail under the Primary data source drop-down and click Next in the top right corner of the page.
    2.PNG
  3. Add the columns to the report. MindBridge requires the following fields:
    • Account number
    • Account title
    • Amount, or Credit Amount and Debit Amount
    • Entry Date
    • Transaction number
      You may want to include additional fields should you require them for your Analysis:
    • Created date
    • Document description or Document entry memo or Document reference (depending on which one contains the most relevant useful information).
    • Record type
    • User ID
    • any other fields
  4. Once all the columns are selected, click Next in the top right corner of the page.
    3.PNG

  5. The Step 3 of 11 "Add calculated columns" is not required for this particular report.
    Click Run Report.
    4.PNG

  6. Specify the date range for your report.
    5.PNG

  7. Select CSV from the drop-down and click Go in the top right corner of this page.
    6.PNG

  8. Click Download the file. Your file will download to your computer's default download location. 7.PNG

  9. The exported file should look like this:
    8.PNG


Next step: Sage Intacct: Transform the general ledger


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.