Learn how to import a Sage 50 (Canada) general ledger into MindBridge.
Note that the General Ledger column mapping section of this guide is based on data exported using our Sage 50 (Canada): Export the general ledger guide and after transforming using our Sage 50 (Canada): Transform the general ledger.
- 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.
- At the Map Columns step, map the Sage 50 (Canada) fields as follows:
|MindBridge Column||Sage 50 (Canada) Field||Fields used in MindBridge||Used in Analytics*||Notes|
|Account ID||Account ID||Required||Yes|
|Effective Date||Date||Required||Yes||Appears in format Mon DD YYYY|
|Debit and Credit||Debits and Credits||Required||Yes|
|Transaction ID||JE#||Recommended**||Yes||Please refer to our Transaction ID guide if one is not readily available. Also see note ** below this table.|
|Memo||Comment||Recommended||Yes||This will enable the Empty Text control point and allow you to see the memo field for each transaction/entry|
|Account Description||Account Description||Optional||No||Can be left out as this field will be picked up from the Chart of Accounts|
|User ID||N/A||Optional||No||Use to sort and filter results for reports|
|Source||Source #||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.
Previous step: Sage 50 (Canada): Transform the general ledger
Anything else on your mind?