Questions? We have answers.

Sage 50 (US): Export the general ledger

  • Updated


Learn how to export a general ledger file from Sage 50 (US).


The sample company, Bellweather Garden Supply, is being used in this guide.

Extract data

Watch the following video on how to extract data or read the steps outlined below.

Open the video in YouTube for high resolution.


  1. From the top bar, click Reports & Forms >General Ledger.

  2. Double click General Ledger.

  3. The report that is produced should look like this. Click the Options button.

  4. Select Specific Dates from the Date drop-down and specify the dates. You can keep the default options for Sorting and Summary (Sort by: GL Account ID). Make sure the Include accounts with zero amounts box is unchecked. Click OK.

  5. The report now looks like this. Click the Excel button. 5.PNG

  6. Keep the default export options as shown below. Click OK.

  7. The file should automatically open in Excel. Save this file to your PC.
  8. The exported file should look like the image below:

Next step: Sage 50 (US): 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! Let us know if this article was helpful or not below. 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?