1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

GST ADJUST

Discussion in 'Ask an Excel Question' started by sambit, Aug 30, 2017.

  1. sambit

    sambit Member

    Messages:
    84
    Sir,
    i want to utilize to IGST balance against IGST then CGST after that SGST.
    similarly CGST amount adjust against CGST and then if positive balance in IGST.
    Finally, SGST amount should be first adjust against SGST balance then if positve balance in IGST.

    i have tried in excel, but some wrong figure dispaly.

    please help to resolve the issue.

    Attached Files:

  2. sambit

    sambit Member

    Messages:
    84
    Waiting for valuable response..............
  3. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Can you explain the logic to be followed for each of IGST , CGST and SGST , in English ?

    Only if we can understand the logic can we suggest the appropriate formulas.

    What are the correct values which should be put in D11 , E11 and F11 ?

    Narayan
  4. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    Thanks for reply, plz follow below point.

    1. in IGST Coloum:- suppose positive balance means total amount (opening+ITC-Liability) is appearing in D9, then it should be reflect in D11.

    2. if E9 cell amount is negative then D11 amount adjust for the same because it is positive balance.

    3. after adjustment between E9 and D11 if surplus amount is showing then it should be reflect in D11.

    4. after adjustment between E9 and D11 if balance amount is showing negative then 0 amount is showing in D11.

    5. if D9 amount is negative then surplus amount means E9 amount is adjust for D9 amount. and if D9 is adjust with E9 amount then D11 amount is zero(0).

    6. and balance amount of E9 is reflect in E11.

    7. similarly SGST coloum amount adjust with SGST balance then after balance taken from IGST.

    if any further query please replay............
  5. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    in GST regime,

    IGST balance always adjust with First, IGST balance, 2nd CGST 3rd SGST balance.

    CGST balance always adjust with First CGST then IGST

    SGST balance always adjust with SGST then IGST.

    Hence, IGST balance adjust or utilize with all balance. but CGST & SGST amount adjust with their respective balance or IGST balance.

    CGST amount can't adjust/utilize with SGST

    similarly, SGST amount can't adjust/utilize with CGST.
  6. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Thanks for the detailed explanation ; if you can indicate what the results should be in the various cells , our understanding will be complete.

    Narayan
  7. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,

    Please find example of 1 to 13th Case.

    I am found 7th, 12th and 13th Case Example is wrong.

    Attached Files:

  8. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    In all the cases , I have not found a single case with the following values :

    The totals are both positive.

    The totals are both non-zero.

    The total in column E is less than the total in column D.

    Can you consider one such case , and manually indicate what the adjustments , if any , will be ?

    Narayan
  9. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    please check 14th Case.

    Attached Files:

  10. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Thanks.

    Can we say that when both the totals are 0 or more (positive) , there is no adjustment ?

    Adjustment comes into play only when at least one of the totals is negative.

    What happens when both totals are negative e.g. the total in column D is -1000 and the total in column E is -1500 ? What happens if these values are the other way around i.e. the total in column D is -1500 and the total in column E is -1000 ?

    Narayan
  11. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    plz check 15th and 16th case.

    Attached Files:

  12. sambit

    sambit Member

    Messages:
    84
    Sir,
    Please help to resolve the issue.
  13. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    See if this is correct.

    Narayan

    Attached Files:

    sambit likes this.
  14. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    Really Great. Many Many Thanks.

    Please resolve SGST also.
  15. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Can you upload a workbook with data where all three types are present , along with the manually entered outputs ?

    Narayan
  16. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    FYIP

    Attached Files:

  17. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Can you cover the following cases :

    1. IGST < 0 , CGST > 0 , SGST < 0

    e.g. -1000 , +1500 , -1000

    2. IGST > 0 , CGST > 0 , SGST < 0

    e.g. +1000 , +2500 , -1500

    e.g. +1000 , +1000 , -750

    Narayan
    Last edited: Sep 2, 2017
  18. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    pl find attached file

    Attached Files:

  19. sambit

    sambit Member

    Messages:
    84
    Narayan Sir,
    Any Example from my side ?
  20. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    I will upload the revised workbook sometime later today.

    Narayan
    sambit likes this.
  21. sambit

    sambit Member

    Messages:
    84
    Narayan sir,
    Please help.
  22. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    Sorry about the delay ; is tomorrow acceptable ?

    Narayan
    sambit likes this.
  23. sambit

    sambit Member

    Messages:
    84
    Thanks.

    OK Sir
  24. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,817
    Hi ,

    See if this is OK.

    Please verify thoroughly.

    Narayan

    Attached Files:

    sambit likes this.
  25. sambit

    sambit Member

    Messages:
    84
    Narayan sir,
    Thank you very much.
    I will inform you after properly checking.

    Again thank you for valuable response.

Share This Page