Questions? We have answers.

Summary

Learn about the process of exporting a general ledger file from NetSuite.

Notes

• NetSuite has limits on the number of rows that can be retrieved per report. Saved searches do not have row limitations like reports, so we recommend creating a saved search, as detailed in the next section.
• We recommend exporting to CSV because NetSuite 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, see Converting text files (delimited or fixed width) to Excel.
  • For more information on NetSuite export formats, see Exporting reports, searches, and lists.

Extract data

1. Navigate to Reports → New Search.

2. Select Transaction.

3. On the next screen, select Create Saved Search.

4. On the Criteria tab, select the Posting, Account Type, and System Notes: Type options.

5. On the Results tab, select the Date, Type, Document Number, Account, Memo, Amount (Debit), Amount (Credit), Source, System Notes: Date, and System Notes: Set by options.

To avoid duplicate Date columns and make columns more readable, set the CUSTOM LABEL for System Notes: Date as Created Date, and System Notes: Set by as Created By

6. Select Save & Run. When the results screen appears, click on the text document (Export - CSV) icon to export to CSV:

Note: We do not recommend exporting to Excel because NetSuite Excel exports to XLS (not XLSX) format, which have a 65,536 row limitation.

7. The resulting CSV file should be in a format like the following:

Next step: NetSuite: Transform the general ledger.