Questions? We have answers.

Sage 50 (Canada): Export the general ledger

  • Updated

Summary

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


Notes

  • The sample company Universal Construction is being used in this guide.
  • Depending on your organization's settings, the layout and report names may be different. Sage 50 (Canada) can be configured to use plain English or accounting terminology - but the reports should be in the same location as the screenshots below.
  • We recommend exporting to CSV because Excel exports have row limitations.

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.

Instructions

  1. From the top bar, click Reports > Financials > General Ledger.
    sage 50 Canada Reports menu open with Financials menu open with General Ledger selected

  2. Select the desired accounts for General Ledger (GL) report. In this example, all accounts are selected. Select the dates and the same report options as in the screenshot below, although the sorting of the export does not matter. Click OK.
    13.PNG

  3. The report that is produced should look like the image below.
    Click the Export button. 14.PNG

  4. Select your local save location. Under Save as Type, select “Comma-separated (*.csv).
    save export as .csv file

  5. The exported file should look like the image below: 1.PNG

 


Next step: Sage 50 (Canada): 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?