Learn how to export a general ledger file from Sage Intacct.
- 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.
- CSV files can be imported into MindBridge; however, if you would like to view your CSV export in Excel, please see our article: Converting Text Files (delimited or fixed width) to Excel.
- Alternatively, you can use our direct Sage Intacct integration.
Watch the following video on how to extract data or read the steps outlined below.
Open the video in YouTube for high resolution.
- From the homepage, click the Applications drop-down in the top of the page. Click Reports - Custom Reports.
- 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.
- 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
- Once all the columns are selected, click Next in the top right corner of the page.
- The Step 3 of 11 "Add calculated columns" is not required for this particular report.
Click Run Report.
- Specify the date range for your report.
- Select CSV from the drop-down and click Go in the top right corner of this page.
- Click Download the file. Your file will download to your computer's default download location.
- The exported file should look like this:
Next step: Sage Intacct: 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! Please contact us at email@example.com. 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.