Upload Journal in S/4HANA

Before we get started, here is an example of the General Journal Entry Excel file, using 80 as the amount, which was configured in the Preparation lesson.

Note : If you havent already downloaded the excel file above, please follow the link and perform steps 1 - 3. https://academy-journey-preview.cfapps.eu10.hana.ondemand.com/learning-journey/modularintegration/prep

1. First we will go back to S/4HANA system by choosing the tab.
   

2. In the Search field type in Balance Sheet and select the Search icon, then click on Balance Sheet/Income Statement to open the application.

   

3. In the Company Code field, enter 1710 and select 1710 (BestRun US) when it appears.

   

4. In the Statement Version field, enter FPA1 and select it when it appears.

   

5. Leave the Statement Type field as Normal (Actual - Actual).

6. Enter 12 2024 as the End Period.

   

7. Click Go.

8. You will see the content has been generated below in the All Accounts tab.

   

9. Click on the Profit & Loss tab then click on the “Expand All” arrow.

   

10. Scroll down to Operating Expense > Employee Expense > Office Expense > Office Supplies then click on the Period Balance for this item. In the pop-up menu that appears, click on Display Line Items in General Ledger.

    
    

11. At the top of the screen, click on the Search icon and type Upload General Journal Entries to open up the application.

    

12. Click Browse.

    

13. Search for the Excel file that you updated in the earlier exercise: JE_Office_Supplies and select Open.

14. Once the file has been uploaded, click on its temporary ID in the table (for example: UPLD_ 2025-01-17 16:07:02(1138200)_001) then click the ID again in the pop-up menu that appears.

    

15. There are two Line Items shown. Expand the dropdown arrow for the first item.

    

16. Click on the menu icon for the Tax Jurisdiction field.

    

17. Click on Tax Jur.: CA00000000 Description: California and press return key.

    

18. Scroll back up and click on the minimize arrow to minimize this Line Item.

    

19. In the bottom-right corner, click Post.

    

20. You will get a confirmation message saying the document was posted successfully. Click Display.

    

21. You should be brought to the Display Line Items in General Ledger App. If not, search for it like you did previously in the main banner at the top of the screen.

    

22. Ensure that the fields reflect the following filters:

• Ledger 0L: (Ledger 0L)
• Company Code: 1710 (BestRun US)
• G/L Account: 65100000
• Status: All Items
• Posting Date: Blank
• Fiscal Year of Ledger: 2024
• Fiscal Period: 0…12.

23. Then Click Go.
    
    

25. Scroll down to find your line item Journal Entry.

    

26. Go back to your SAC Story and click Overview NOTE: It may take some time for the data to replicate. Please wait some moments.

    

27. Drill down into Operating Income > Operating Expense > Employee Expense > Office Expense > Office Supplies and select Jan 2024 for Actual.

    

28. Perform a data refresh from the S/4 system by clicking the Import Action Data from S/4 (Local Currency button).

    

29. You will see the data changes implemented once the table refreshes.

    

Summary

Congratulations you have uploaded a journal based on a pre-downloaded template, then refreshed the data in SAC to show the integration between SAC and S/4HANA.