Questions? We have answers.

Sage 200 (UK): Import the general ledger into MindBridge

  • Updated

Summary

Learn how to import a Sage 200 (UK) general ledger into MindBridge.


Notes/Prerequisites

Note that the general ledger column mapping section of this guide is based on data exported using our Sage 200 (UK): Export the general ledger guide and after transforming using our Sage 200 (UK): Transform the general ledger


Import data

  1. Import your general ledger file into MindBridge through the File Manager, or by importing directly to the General Ledger section on the Data page. For step-by-step instructions, follow our Import a general ledger guide until the Map Columns step.
  2. At the Map Columns step, map the Sage 200 (UK) fields as follows:
MindBridge Column Sage 200 (UK) Field Fields used in MindBridge Used in Analytics* Notes
Account ID Code Required  Yes  
Effective Date Transaction Date Required  Yes Appears in format M/D/YYYY
Amount Nominal Value Required  Yes  
Transaction ID Unique Reference Number Recommended** Yes Please refer to our Transaction ID guide if one is not readily available. Also see note ** below this table.
Memo Reference or Second Reference or Narrative Recommended*** Yes This will enable the Empty Text control point and allow you to see the memo field for each transaction/entry
Account Description NLAcc Name Optional No Can be left out as this field will be picked up from the Chart of Accounts
Type Transaction Type Optional Yes  
User ID User Name Optional No Use to sort and filter results for reports
Entered Date Posted Date Optional Yes Appears in format M/D/YYYY
Source Entry Source Name Optional No Use to sort and filter results for reports

* Optional columns, even if not used in the analytics, can be included for filtering and other visualizations, as indicated under Notes.

** Transaction ID is required but does not necessarily need to be in one single column. In the Review Data step of the ingestion process, MindBridge will recommend a transaction ID based on your data, or you can choose and/or combine different columns to create one. For more information: Understand Transaction ID and data integrity.

***In our experience clients use Sage 200 (UK) 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.


Previous step: Sage 200 (UK): Transform the general ledger


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Was this article helpful?