Summary
This guide will cover the process of importing a SAP S4/HANA Cloud General Ledger into Mindbridge.
Configuration details
Note that the General Ledger column mapping section of this guide is based on data exported using our SAP S4/HANA Cloud: Export the general ledger.
Import Data
- Import your General Ledger file into Mindbridge, either through the File Manager, or by importing directly to the General Ledger section on the Data page.
- Follow the steps in the ingestion wizard until you reach the section titled Column Mapping: General Ledger. If you followed the export guide then all the columns that can be mapped within Mindbridge will be included in your general ledger. Below is a table which shows the Mindbridge columns and their corresponding SAP S4/HANA Cloud columns.
Account ID |
G/L Account |
Required |
Yes |
|
Effective Date |
Posting Date |
Required |
Yes |
Appears in format MM/DD/YYYY |
Amount |
Amount in Company Currency |
Required |
Yes |
|
Journal Entry |
Recommended** |
Yes |
Please refer to our Transaction ID guide if one is not readily available. Also see note ** below this table. |
|
Memo |
Journal Entry Item Text |
Recommended |
Yes |
This will enable the Empty Text control point and allow you to see the memo field for each transaction/entry |
Account Description |
G/L Account Long Name |
Optional |
No |
Can be left out as this field will be picked up from the Chart of Accounts |
Type |
Journal Entry Type |
Optional |
Yes |
|
User ID |
Journal Entry Created By |
Optional |
No |
Use to sort and filter results for reports |
Entered Date |
Journal Entry Date |
Optional |
Yes |
Appears in format M/D/YYYY H:M am/pm |
* 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: SAP S4/HANA Cloud: 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.