Questions? We have answers.

Sage 200: General Ledger Export

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn to export General Ledger data from Sage 200 and import into MindBridge.


Instruction

  1. Navigate to the Nominal submenu in the sidebar.
  2. Click Nominal Enquiries.
  3. Click Transaction Audit Trail List.
    Sage-200 with transaction audit trail list selected

  4. Right click on the large table now displayed and select Columns from the menu. You will need to go through and select the relevant columns to ensure they are displayed. We recommend selecting the following columns:
    • Code
    • Entry Source Name
    • Narrative
    • NLAcc Name
    • Nominal Value
    • Posted Date
    • Reference
    • Second Reference
    • Transaction Date
    • Transaction Type
    • Unique Reference Number
    • User Name
    Sage-200 columns with listed columns checked off

    Note: Every client may use the software slightly differently so it is not possible to provide a definitive list of columns to select. It is recommended to look through the data carefully to ensure you are selecting the correct columns based on the entries your client has made and the fields they are using.

  5. Click the Filter icon at the top of the screen.
  6. Click New to create a new filter.
  7. Give your filter a name (eg. Financial Year 2020).
  8. Select column “Financial Year Start Date”.
  9. Select condition “Is Equal To”.
  10. Enter the value to show your required financial year starting date (eg. 01/01/2020).
  11. Click Save.
    Sage-200 maintain filters screen

  12. Right click on the table again and select Export > All to Excel.
  13. The file should automatically open in Excel. Save this to your file to your PC.

 


Importing data into MindBridge

Once exported, your General Ledger is immediately ready to be imported into MindBridge.

During the upload process we recommend mapping your columns as follows within MindBridge:

Sage 200 Column Title MindBridge Suggested Mapping
Code Account ID
NLAcc Name Account Description
Nominal Value Amount
Posted Date Entered Date
Transaction Date Effective Date
Transaction Type Type
Unique Reference Number Transaction ID
User Name User ID
Reference  Memo*
Second Reference Memo*
Narrative Memo*

 

* NOTE: In our experience clients use Sage 200 in different ways so we recommend looking at the columns ‘Reference’, ‘Second Reference’, and ‘Narrative’ yourself to decide which is the most appropriate column to map as the Memo. Select the column with the most relevant useful information.

When asked, we recommend selecting Unique Reference Number as the Transaction ID within MindBridge.

Read more about the standard upload process in our Knowledge Base.


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

0 comments

Please sign in to leave a comment.