GSTR2A Reconciliation in Pivot Table Excel | How use Pivot Table in Excel for GSTR 2A Reconciliation

Поделиться
HTML-код
  • Опубликовано: 28 дек 2024
  • #gstreconciliation #gstr_2a #gstitc #pivottableinexcel Join this channel to get access to perks:
    / @smartaccountingrsnr
    Please is Video ko Jayda se Jayda Share kre Thank You So Much

Комментарии • 102

  • @Manasi-c6u
    @Manasi-c6u 6 дней назад +1

    Thank you sir information contained in this video is very useful

  • @santoshprasad5566
    @santoshprasad5566 4 месяца назад +1

    बहुत ही शानदार reco हैं, इसका प्रैक्टिस से काम आसान हो जायेगा

  • @omgupta_25
    @omgupta_25 5 месяцев назад

    Excellent Video Sir, maja aa gya sir, kafi kuchh sikhne ko mila itni asan bhasa mein great learning.

  • @user-vinodkumar143
    @user-vinodkumar143 2 года назад

    Sir bahot easy tarika h ye to best video

  • @biplabchakraborty-qz6ci
    @biplabchakraborty-qz6ci Год назад +4

    ttttrrrrremendous ......excellent sir.what a knowledge

  • @bharatt5096
    @bharatt5096 Год назад

    Sir ji bhut hi bdiya video banai

  • @Teach_learn9169
    @Teach_learn9169 2 года назад

    Sir ye file mil sakti hai practice krne k liye video bhut hi helpful hai hm sbke liye dil se thanks guru ji

  • @c.ranesworld
    @c.ranesworld 2 года назад

    Yahi kaam mujhe kal karna tha
    Aur ye video aaj maine dekh liya
    Big thank you to you sir 🙏🙏

  • @dhirendrarout2926
    @dhirendrarout2926 6 месяцев назад +1

    Thanks for such knowledgeable video keep going sir

  • @Amitk8196
    @Amitk8196 Год назад

    Very nice and simple way to teach thanks so much for your beautiful work🙏

  • @savewatersavelife9480
    @savewatersavelife9480 2 года назад

    बहुत बढ़िया मोहन सर👌🏻👌🏻

  • @vaishnavipodchetti122
    @vaishnavipodchetti122 2 года назад +3

    best guidance for freshers 🤝 thanks want more informative vedios related reconciliation of gst with book

  • @mubashiraafzal7922
    @mubashiraafzal7922 Год назад

    Very useful video learned a lot from it thank you for uploading the video

  • @sansari5514
    @sansari5514 2 года назад +3

    Thank you so much sir helpful 🙏 video
    Sir ek full video ewaybill pr be bna dejia, cancelled kab Kia jata or reject kab Kia jata h.

  • @c.ranesworld
    @c.ranesworld 2 года назад

    Sir
    Kaise aapko shukriya kahoon
    Aap bahut acha kaam kar rahe ho

  • @harshporwal
    @harshporwal Год назад

    Bahot khoob👏

  • @cssachingola
    @cssachingola 2 года назад

    Very smart work 👍👍👍👍 Thanks for ur information

  • @bengalkagamer5320
    @bengalkagamer5320 Год назад

    Thanks a lot ut going to help me today in my work

  • @chalotallysikhe5554
    @chalotallysikhe5554 Год назад +1

    Superb sir ❤️🙏🏾

  • @ravibhoj9587
    @ravibhoj9587 7 месяцев назад +1

    Awesome sir❤

    • @ravibhoj9587
      @ravibhoj9587 7 месяцев назад

      Sir.. ye jo 2 sheet apnw banayi hai.. inki excel file mil sakti hai kya dir

  • @ankitsethi3469
    @ankitsethi3469 2 года назад

    shaandar

  • @sarfealam5364
    @sarfealam5364 Год назад

    One of the best gstr 2b reconciliation

  • @yogeshmehra5083
    @yogeshmehra5083 Год назад

    It's too help full video, aur sir aap iska data provide karbaiye na... Practice ke liye pls🙏

  • @rajkartikrajkartik1943
    @rajkartikrajkartik1943 Год назад

    very mast video sir

  • @StatusMaker01
    @StatusMaker01 Год назад

    Thank You So Much😊

  • @rupilsingla6741
    @rupilsingla6741 Год назад

    Éxcellent video sir

  • @rajunamojwar6142
    @rajunamojwar6142 2 года назад +1

    Thank u verymuch sir very nice for trick

  • @adityabajaj6649
    @adityabajaj6649 Год назад +2

    amazing video.. sir please make a detailed video on how to record/pass "closing" entries of GST in Tally for finalisation of accounts

  • @nageshrathod632
    @nageshrathod632 5 месяцев назад

    Superb

  • @abhinavraj22
    @abhinavraj22 2 года назад +1

    Thanku sir🙏🙏🙏

  • @KumarBighnesh
    @KumarBighnesh Год назад

    Very useful information

  • @thepowerofaccontancy2510
    @thepowerofaccontancy2510 Год назад

    Really good information

  • @aarish2785
    @aarish2785 Год назад

    ❤❤❤thank you ❤ sir

  • @vlogwithyatishkandhari6293
    @vlogwithyatishkandhari6293 2 года назад +1

    Gr8..Thank you Sir..you are 🙂

  • @aniketkhawale99
    @aniketkhawale99 2 года назад +2

    Truly helpful !

  • @yuvrajwadekar7756
    @yuvrajwadekar7756 2 года назад

    very had process explain

  • @princemardiya759
    @princemardiya759 8 месяцев назад

    Superb video

  • @kunalnitin5229
    @kunalnitin5229 2 года назад +2

    Thanks a lot.

  • @vinaydubey40
    @vinaydubey40 9 месяцев назад

    thanky sir osm explnation

  • @satish84894
    @satish84894 2 года назад

    PROPER AND EASY WAY EXPLANATION KEEP IT 👍

  • @manjunathaj7884
    @manjunathaj7884 2 года назад

    Thanks sir. Got learnt few things

  • @aabidmir777
    @aabidmir777 Год назад

    Sir, amazing

  • @arvindagrawal1920
    @arvindagrawal1920 2 года назад +1

    Wonderful 🙏🙏

  • @ayansharma5638
    @ayansharma5638 2 года назад +1

    Thank you sir...

  • @artisahoo24
    @artisahoo24 7 месяцев назад +1

    Tq so much

    • @SMARTAccountingRSNR
      @SMARTAccountingRSNR  7 месяцев назад

      Welcome 😊 please Share This Video To Maximum Person

  • @bantikhan8380
    @bantikhan8380 2 года назад +1

    Thanku sir

  • @bhagwansoni8767
    @bhagwansoni8767 2 года назад

    Very informative thanks

  • @VishalPatil-op2bb
    @VishalPatil-op2bb 2 года назад +1

    Thank you sir

  • @sushovonpaul6225
    @sushovonpaul6225 2 года назад +1

    Time 7:57 me.. Consolidated sheet me hi agar invoice number select karke conditional formatting kr de to bhi kya humlog dhund nhi sakte ki kon kon sa invoice kaha kaha entry nhi hua hai ?

  • @payalkeshri2146
    @payalkeshri2146 2 года назад +1

    It's too helpful sir... thanks a lot

  • @hansrajbugaliys9327
    @hansrajbugaliys9327 Год назад

    Sir ek eway bill pr video bnaye

  • @roopkumar4762
    @roopkumar4762 2 года назад

    Good

  • @kansingh5968
    @kansingh5968 2 года назад +1

    Nice

  • @vivekarya9422
    @vivekarya9422 2 года назад +3

    Thanks sir sir please provide this scenario excel sheet in description 🙏 for practicener students at home 🏡

  • @Jesusvachanbible
    @Jesusvachanbible 10 месяцев назад

    Bhai part m to allg se enter ho skti h Jese koi m/ s se save krta h orr koi direct name se sv krta h
    Apki j system party name v dikt kr skta h

  • @deepakchanotra6064
    @deepakchanotra6064 2 года назад

    Thanks sir

  • @kishorkumarsoni3948
    @kishorkumarsoni3948 2 года назад

    Very nice

  • @shivamdewangan478
    @shivamdewangan478 2 года назад +1

    4000-5000 entry vale reconcilation ke liy koi trick btao na

  • @meenakshisethi1283
    @meenakshisethi1283 2 года назад

    Nice sir

  • @pramodkartatpsl5402
    @pramodkartatpsl5402 Год назад

    Sir thank u

  • @Uday-wl1gh
    @Uday-wl1gh 2 года назад

    Ye sheet practice ke liye de sakte h

  • @ankityogi8027
    @ankityogi8027 2 года назад

    Great job sir Bina inventory k closing stock kese nikalte h

  • @mr.techprofessor7749
    @mr.techprofessor7749 2 года назад

    agar koi credit note issue kre to ITC claim krke debit note issue karna chahiye ya ITC Reversed kre to bhi chal jayega ?

  • @mohanjhanginia3115
    @mohanjhanginia3115 2 года назад

    Very good description 🙏

  • @payelmodak5459
    @payelmodak5459 10 месяцев назад

    Are you use ms office 2010 Or 2013 ?
    Is this pivot table applicable in ms office 2007 ?

  • @soniyabelsare7685
    @soniyabelsare7685 Год назад

    How to prepare format GSTR2A like purchase file because there is single coloumn showing GST rates

  • @ByBit-l2r
    @ByBit-l2r Год назад

    Isme tally mai 2 baar invoice ho or portal per na ho to bhi duplicate value mai hi dikhayega

  • @user-vinodkumar143
    @user-vinodkumar143 2 года назад

    Sir ek help or mujhe ese hi portal se sale check krni h but portal se R1 ki pdf ya json file download hoti h excel nhi plz reply

  • @rajivkumarsingh597
    @rajivkumarsingh597 Год назад

    Sir, I have one question, please advise - yadi supplier ne kisi bill ka entry last month me (example -30 Jan) ko kar diya aur maine us supply ko 5 Feb ko receive Kiya aur, purchase ka entry kar diya to difinetly gstr 2a & tally ke entry me difference aa jayega to usko kaise thik karenge.
    Please advise or make video on this.
    Bahut logo ka problem door ho jayega.
    Thanks

    • @SMARTAccountingRSNR
      @SMARTAccountingRSNR  Год назад

      No problem next month me ITC claim ho jayega
      Books ka ITC 2b se jayada nhi hona chahiye

    • @rajivkumarsingh597
      @rajivkumarsingh597 Год назад

      @@SMARTAccountingRSNR
      Thanks for replying sir,

  • @nandupareek7886
    @nandupareek7886 2 года назад +1

    Sir namaskar, nand lal pareek

  • @understandthewordsfeelthes3036
    @understandthewordsfeelthes3036 2 года назад

    👍

  • @arshmohd1837
    @arshmohd1837 Год назад

    Sir agar books me ledger name me halka sa bhi difference hota h portal se pivot table me do bar ledger show karta hai..iska koi solution h??

  • @nituagarwal8965
    @nituagarwal8965 Год назад +1

    Difference nahi nikalne aa raha Mujeeb samaj

  • @DeepakSaini-mu8hl
    @DeepakSaini-mu8hl 6 месяцев назад

    Sir tally ma 1he bill k 2rate or freight hone k karn data separate aa rha hai or 2a k bhi data alag aa rha hai...aise ma yeh formula apply nhi ho rha kya kre 😢😢

  • @sonus5682
    @sonus5682 2 года назад

    Sir online 2a data kaise le excel par please sir

  • @kunmunranivlogs5509
    @kunmunranivlogs5509 2 года назад

    2a reconciliation last hi hai yah video ya aage ki process aur hai video nahin Ho Paya sir I am confused

  • @Pahadiboy12346
    @Pahadiboy12346 3 месяца назад

    sir practise k liya is file ki pdf da dijiya

  • @orthotools5128
    @orthotools5128 2 года назад

    Hi sir am from Bangalore, pls explain in English then only every body can understand

  • @nileshbhilare1511
    @nileshbhilare1511 2 года назад

    A re bhai books ka data kese Lena hai o bato process

  • @pradipdas4445
    @pradipdas4445 2 года назад

    Pl let me know ur course fees.

  • @laxmanKumar-ep2jo
    @laxmanKumar-ep2jo 2 года назад

    Bhai ise credit note or debit note ke data ko define nhi kiya ..???

  • @ysgaming6074
    @ysgaming6074 2 года назад +3

    Sir ghooma bht rahe h

  • @heeralaldheewar2300
    @heeralaldheewar2300 2 года назад

    सरल तारीके से बताओ

  • @shankarjoshi2567
    @shankarjoshi2567 Год назад

    Sir plz provide practice file

  • @sahyogagrotraderssaradiya4269
    @sahyogagrotraderssaradiya4269 Год назад

    Seets sahiye

  • @luckyahirwar5486
    @luckyahirwar5486 2 года назад

    acche acche accountent ko bhi ye nhi ata

  • @rajibkushari3790
    @rajibkushari3790 Год назад

    Most bogus

  • @ravibhoj9587
    @ravibhoj9587 7 месяцев назад

    Sir ..ye dono excel file.mil sakri hIn kya... please

  • @DivyaArya-nc3hb
    @DivyaArya-nc3hb 5 месяцев назад

    Nice

  • @ajjujackson7138
    @ajjujackson7138 Год назад

    Thank you sir