# Questions? We have answers.

## Summary

Learn about the process of exporting a general ledger file from Microsoft Dynamics NAV.

* * *

## Notes

- If you have Microsoft Dynamics NAV 2013 & Higher you may need to enable the “Print & Send” ribbon to view the fields below.
- For larger files (>1048576 rows) you will need to export to CSV. See the instructions here: [Exporting data from tables to CSV files](https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--exporting-data-from-tables-to-csv-files).
- To export from SQL DB, see the instruction here: [Create queries](https://docs.microsoft.com/en-us/dynamics-nav/how-to--create-queries).

* * *

## Extract data

01. From the Departments tab, select **General Ledger** under Financial Management.   
02. Scroll to the bottom of the list and select **General Ledger Entries**, located in the History section under Archives.   
03. The General Ledger Entries contain opening balances that need to be filtered out.  
04. Click **General Ledger Entries** to open the context menu, and click **Advanced Filter**.   
05. In the column menu, select **Document No** and type **<>START** in the text field.   
06. Press **Enter** and your results will now exclude opening entries.  
07. There are some other columns not in the default column set but are useful to MindBridge analysis. To see more columns, right-click on any **column header** to view the context menu and select **Choose Columns...**   
08. The Customize General Ledger Entries window will open, and from here you will choose additional columns. Be sure to include the columns labeled **Required** in the screenshot below.  
09. Columns labeled Optional are not required but can bring additional insights to the analysis. Columns labeled Additional aren't used in MindBridge but will be included in the Data Table for reference.   
10. Use the **Microsoft Excel** button in the Ribbon's Send To tab and follow the dialog boxes. Be sure to save your results as **XLSX**.

* * *

**Next step: [Microsoft Dynamics NAV: Transform the general ledger](https://support.mindbridge.ai/hc/en-us/articles/6822987680151)**

* * *