Questions? We have answers.

Microsoft Dynamics Great Plains (GP): Export the general ledger

  • Updated


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


Depending on your version of Microsoft Dynamics GP, the layout may be different but the reports should be in the same location as the screenshots below.

Extract data

  1. From the Microsoft Dynamics GP menu, select Smart List.image__100_.png

  2. Navigate to Financial → Account Transactions and select the first sub-group marked with the asterisk (*).image_-_2021-01-06T160858.822.png

  3. Add additional columns if required.image_-_2021-01-06T160942.627.pngimage_-_2021-01-06T162219.110.pngimage_-_2021-01-06T162421.268.png

  4. Select the date range.image_-_2021-01-06T162650.108.png

  5. When you have the results, Export to Excel.image_-_2021-01-06T162822.711.png

  6. The exported file should look like this:Capture.JPG

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 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.

Was this article helpful?