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

Пікірлер: 55

  • @kalyanimikkilineni5936
    @kalyanimikkilineni59362 ай бұрын

    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
    @lokeshp11677 ай бұрын

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

  • @lanphuong3628
    @lanphuong36286 ай бұрын

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

  • @francescocolaiori7311
    @francescocolaiori731111 ай бұрын

    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

    @AbdullahGalal

    10 ай бұрын

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

  • @christiannyamoutet5802
    @christiannyamoutet580210 ай бұрын

    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
    @lukagrijak145110 ай бұрын

    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
    @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
    @Ahmed-fq6si11 ай бұрын

    Everything is crystal clear as usual. Thank you Sir.

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

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

  • @sireesiree5006
    @sireesiree50064 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    4 ай бұрын

    My pleasure! thanks a lot for the feedback :)

  • @user-ef5gy4ne6b
    @user-ef5gy4ne6b10 ай бұрын

    great video

  • @yingzhu3104
    @yingzhu31044 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    4 ай бұрын

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

  • @DiegoAugustoGallo
    @DiegoAugustoGallo2 ай бұрын

    Exelent!!!! thanks

  • @AbdullahGalal

    @AbdullahGalal

    11 күн бұрын

    You are very welcome !

  • @saibalu4320
    @saibalu43209 ай бұрын

    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

    @AbdullahGalal

    9 ай бұрын

    Glad it was helpful!

  • @sanjeeviraman3359
    @sanjeeviraman33593 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    3 ай бұрын

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

  • @bilelamri5273
    @bilelamri527311 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

    Thanks a lot Bilel! :)

  • @mak-pat
    @mak-pat11 ай бұрын

    Great video

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

    Thanks!

  • @Aspire-eq6hw
    @Aspire-eq6hw3 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    11 күн бұрын

    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
    @karanpal154410 ай бұрын

    👍👍👍👍

  • @victabskey
    @victabskey9 ай бұрын

    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

    @AbdullahGalal

    8 ай бұрын

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

  • @abhinavpanda9503
    @abhinavpanda950310 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    10 ай бұрын

    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
    @iFrozenSkull11 ай бұрын

    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

    @AbdullahGalal

    11 ай бұрын

    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
    @user-rb8rs7rd8z10 ай бұрын

    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

    @AbdullahGalal

    10 ай бұрын

    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
    @RaviKumar-mk4fz13 күн бұрын

    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
    @Teeheeleelolee8 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    8 ай бұрын

    That should be the next video in the playlist 👍🏻

  • @uttamthakur2016
    @uttamthakur2016Ай бұрын

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

  • @kashjawed
    @kashjawed11 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

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

  • @Tharanaprakash
    @Tharanaprakash3 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    3 ай бұрын

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

  • @anilsalian-je5kx
    @anilsalian-je5kx8 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    8 ай бұрын

    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
    @yusefma7mud35310 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    10 ай бұрын

    For elite members please email agelitemembers@gmail.com

  • @rohinimajhi5454
    @rohinimajhi545411 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

    Replied by mail

  • @mohamedperviz
    @mohamedperviz11 ай бұрын

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

  • @AbdullahGalal

    @AbdullahGalal

    11 ай бұрын

    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

    @mohamedperviz

    11 ай бұрын

    @@AbdullahGalal thanks

  • @mohamedperviz
    @mohamedperviz11 ай бұрын

    Can you Make FA migration

  • @AbdullahGalal

    @AbdullahGalal

    10 ай бұрын

    Done in the latest videi

Келесі