Data Migration of GL Account Balances and Line Items: Overview

In this video, I explain the process of data migration of General Ledger Account balances and line items.
🔍 This video answers the below questions:
1️⃣ When do we migrate Balance Sheet accounts only and when do we also migrate Profit & Loss accounts?
2️⃣ Should we transfer balances or line items?
3️⃣ What transfer date should we use?
4️⃣ What's a fiscal year? 📅
5️⃣ How to balance the initial balance offsetting accounts to zero? ⚖️
6️⃣ What's the Retained Earnings account? How does it impact the process? 💼
7️⃣ What are the accounting entries posted in the balance migration? 📝
Support the channel and get access to Member exclusive content:
www.youtube.com/@abdullahgala...

[@kalyanimikkilineni5936]

Your explanation is very clear, we are very lucky to learn data migration from your videos. I am not from an accounting background. If you could provide a separate set of videos on basic accounting concepts, it would be really helpful to upgrade my skills.

[@lokeshp1167]

you explained it so well in such a simple way...amazing

[@lanphuong3628]

Thank you so much for your sharing. It's really easy to understand and helpful. Please share more about Financial Accounting

[@francescocolaiori7311]

Dear Abdullah, having worked in the sector for nearly 20 yr, I have come to appreciate your exceptional talent in delivering knowledge and educational content. I believe the logical continuation of this chapter on GL BS and P&L data migration would be the migration of open GR/IR associated to open Purchase Orders including the explanation on how to match the Invoices Received in S/4 with the open item GR/IR migrated from the legacy ECC.

[@AbdullahGalal]

Thanks a lot for the nice message Frances! I agree with your proposition on how to proceed and will follow

[@christiannyamoutet5802]

Dear Abdullah. That’s a great video indeed. Very clear. I was wondering if you have done such videos for stock inventory balance at hand migration, AR and AP open items migration please. If not , looking very much to watch. You made this one so simple that I feel like a genius after watching this. Definitely a fan. Keep up with the good work.

[@lukagrijak1451]

Hello Abdul - great video as always, thank you. A playlist explaining basic accounting that an SAP FI consultant would need for everyday job would be amazing and very useful!

[@xof2000]

Such a great video for an overview and understanding the approach and concept. Very helpful. Now I was actually trying to find the video that explains how to use the LTMC for migrating balances and line items but I can’t find that in the playlist?

[@Ahmed-fq6si]

Everything is crystal clear as usual. Thank you Sir.

[@AbdullahGalal]

Thank you Ahmed! Don't forget to subscribe to the channel!

[@sireesiree5006]

Your efforts are incredible Abdullah. Thank you for the very knowledgeable video and yes even non accounting people also can understand the process.

[@AbdullahGalal]

My pleasure! thanks a lot for the feedback :)

[@user-ef5gy4ne6b]

great video

[@yingzhu3104]

It is very clear explanation. Thank you very much Abdullah!

[@AbdullahGalal]

You are welcome. Thank you for supporting the content :)

[@DiegoAugustoGallo]

Exelent!!!! thanks

[@AbdullahGalal]

You are very welcome !

[@saibalu4320]

Hi Abdullah, Thank you very much. This video is rally simply superb, you covered everything regarding the GL Balances & line items DM. Appreciated, the way you explained the process.

[@AbdullahGalal]

Glad it was helpful!

[@sanjeeviraman3359]

Hello Abdullah galal - very great video and understand lot of thing. thank u so much.

[@AbdullahGalal]

Very welcome mate! thank you for being a long time member!

[@bilelamri5273]

Sir you are awesome, you're champion and proud for all of us arabs

[@AbdullahGalal]

Thanks a lot Bilel! :)

[@mak-pat]

Great video

[@AbdullahGalal]

Thanks!

[@Aspire-eq6hw]

Conceptual video which has good content. Continue to create videos on Financial accounting basics

[@AbdullahGalal]

Thank you for your feedback and encouragement! I'm glad you found the video valuable. I'll definitely consider creating more content on Financial Accounting basics , If you have any more questions or need further assistance, feel free to let me know.

[@karanpal1544]

👍👍👍👍

[@victabskey]

i am loving all your data migration training. yes, i vote for basic acctg video if ok with you. by the way, i want to be a member so i can watch all your videos. i am not yet making money, so pls suggest cheaper option. which membership should i get?

[@AbdullahGalal]

All the videos are available for gold members www.youtube.com/@abdullahgalal/join

[@abhinavpanda9503]

Hello AG! Could you please make a video on basic accounting also because your explanations are just fab.

[@AbdullahGalal]

Thanks a lot Abhinav. More accounting videos = less SAP videosm and so far I don't have a lot of requests for accounting videos so will stick to SAP :)

[@iFrozenSkull]

Hello Abdul - I have been going through your videos and they are really crisp. Do you happen to have an entire structured course on SAP S4 HANA Finance 2021 or 2022 version? I have been checking around for few courses but I really liked how you explain the concepts in your videos.

[@AbdullahGalal]

I don't have a full course yet. I only explain the complicated topics that I enjoy challenging myself with :) Don't forget to subscribe to the channel 😎

[@user-rb8rs7rd8z]

thank you for sharing all the valuable information and priceless experiences. one question though, how can we get our hand on SAP (or s simulated cloud version) to practice with the real menus?

[@AbdullahGalal]

Well either you use the solution from SAP CAL (check the channel for the video "get free access to S4Hana") or you buy access from someone online

[@RaviKumar-mk4fz]

Hi Abdhllah- am looking for SAP S/4 hana conversion project both FI & CO objects how we can handle in the conversion process E2E if the client converting from ECC EHP6 to S4hana 2023 version. It could be helpful if you have those videos as well, Thanks.

[@Teeheeleelolee]

Very clear explanation :) Are you also posting migration cockpit for AP / AR open item?

[@AbdullahGalal]

That should be the next video in the playlist 👍🏻

[@uttamthakur2016]

I was understanding GL Account migration , Did you implemented using bods or some other ways .please reply

[@kashjawed]

Great video. Is the transfer date during Mock conversion same as the cutover date? or should it be the date of mock conversion?

[@AbdullahGalal]

I don't see any reason to use a different date Don't forget to subscribe to the channel 😎

[@Tharanaprakash]

Thanks for your video. Can we upload multiple GL line items per document using LTMC?

[@AbdullahGalal]

We upload balances, not GL documents. Not sure if that can be done

[@anilsalian-je5kx]

Hi AG, Do we need to zero out balances in legacy system as well or not?

[@AbdullahGalal]

You mean that debits = credits? OFCOURSE! that's the basic sacred accounting rule. If your legacy system has debits not equal credits then you must correct this first eithe in the legacy system or in the excel upload templates

[@yusefma7mud353]

Dear Abdullah, could you please share the link for document library?

[@AbdullahGalal]

For elite members please email [e-mail]

[@rohinimajhi5454]

Hi I have enrolled to elite membership but haven't received access to configuration document

[@AbdullahGalal]

Replied by mail

[@mohamedperviz]

Hi, we migrate data in sap cloud last month and there is balance in offset. Consultant not clearing it

[@AbdullahGalal]

Having balance in offset means the data migration was not done proberly which means your financial reporting will be wrong. Analyse why you have a balance

[@mohamedperviz]

@@AbdullahGalal thanks

[@mohamedperviz]

Can you Make FA migration

[@AbdullahGalal]

Done in the latest videi