Questions? We have answers.

SAP S4/HANA Cloud: Import the general ledger into Mindbridge

  • Updated

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

  1. 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.

    mceclip0.png

  2. 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.

 

MindBridge Column

SAP S4/HANA Cloud Field

Notes

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

 

Transaction ID

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.

Was this article helpful?