Questions? We have answers.

Sage 50 (Canada): General Ledger Export

Article author
Jonathon Plowman-Samson

Summary 

Learn about the process of exporting a General Ledger file from Sage 50 (Canada).


Considerations 

At the time of this publication, MindBridge supports two specific exports from Sage 50 (CA). (Other exports may be supported in future releases).

MindBridge doesn't support the Chart of Accounts (COA) export from Sage 50 (CA) at this time. MindBridge is capable, however, of inferring your account list from GL or transaction reports.


Instruction 

General Ledger Report

  1. Open the desired client in Sage 50. You should see a landing page that looks similar to the screenshot below. The names of the options on this page may vary depending on your system language and Sage 50 configuration, but the layout should be familiar. 
    sage 50 Canada screen

  2. From the top bar, click Reports > Financials > General Ledger
    sage 50 Canada Reports menu open with Financials menu open with General Ledger selected
    Note: Depending on your organization's settings, the labels may be different. Sage 50 (CA) can be configured to use plain English or accounting terminology - but the report should be in the same location as the figure above.

  3. Select the desired accounts for General Ledger (GL) report. In this example, all accounts are selected. Select the same report options as in the screenshot below, although the sorting of the export does not matter.
    sage 50 canada transactions by account report screen

    The report that is produced should look like this:
    sage 50 canada exported repor example

  4. Click the Export button, and select your local save location. Under Save as Type, select “Comma-separated (*.csv).” 
    save export as .csv file
 

And that’s it, MindBridge can import the produced file! An example file using the demo Universal Construction company that was used in the above screenshots is included with this package to indicate what the file should look like.


All Transactions Report 

The Sage 50 All Transactions report can also be imported by MindBridge and treated as a General Ledger (GL). Given this report can be produced for different types of sub-ledgers, this can be an alternative method used to get AP or AR data in a "MindBridge-friendly" format from Sage 50. The steps to get this report are outlined below. 

  1. From the top bar, click Reports > Journal Entries > All.
    sage 50 canada reports menu open with Journal Entries open with All highlighted

    Note: Depending on your organization's settings, the labels may be different. Sage 50 (CA) can be configured to use plain English or accounting terminology - but the report should be in the same location as the figure above.


  2. The Report Options dialogue will pop up. The default settings should be correct for an All Transactions report to be exported into MindBridge, although you may limit your export to a specific year if you wish.
    sage 50 all transactions export screen

    The produced report should look like this:
    sage 50 exported report example

  3. Click the Export button, and select where you would like to save the produced file. Under Save as Type, select Comma-separated (*.csv). The Export Selection window should look like this:
    save exported file as .csv
 

And that’s it. MindBridge can import the produced file into its system.

An example file, using the demo Universal Construction company that was used in the above screenshots, is included with this package, helping you to indicate what the file should look like.


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.

Share this:

Was this article helpful?

Comments

1 comment

  • Comment author
    Zakar Hovhannisyan

    I would like to see how we can generate GL that shows amounts allocated by project.

     

    0

Please sign in to leave a comment.