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.
- 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
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
Anything else on your mind?