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.

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

1. ### sambitMember

Messages:
107
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.

File size:
10.1 KB
Views:
6
2. ### sambitMember

Messages:
107
Waiting for valuable response..............
3. ### NARAYANK991Excel Ninja

Messages:
16,619
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. ### sambitMember

Messages:
107
Narayan Sir,

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

Messages:
107
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. ### NARAYANK991Excel Ninja

Messages:
16,619
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. ### sambitMember

Messages:
107
Narayan Sir,

Please find example of 1 to 13th Case.

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

File size:
16.3 KB
Views:
1
8. ### NARAYANK991Excel Ninja

Messages:
16,619
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

Messages:
107
Narayan Sir,

File size:
16.7 KB
Views:
3
10. ### NARAYANK991Excel Ninja

Messages:
16,619
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. ### sambitMember

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

File size:
17.8 KB
Views:
2

Messages:
107
Sir,
13. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

See if this is correct.

Narayan

#### Attached Files:

File size:
17.4 KB
Views:
5
sambit likes this.
14. ### sambitMember

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

15. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

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

Narayan

Messages:
107
Narayan Sir,
FYIP

File size:
12.3 KB
Views:
1
17. ### NARAYANK991Excel Ninja

Messages:
16,619
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. ### sambitMember

Messages:
107
Narayan Sir,
pl find attached file

File size:
13.1 KB
Views:
5
19. ### sambitMember

Messages:
107
Narayan Sir,
Any Example from my side ?
20. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

I will upload the revised workbook sometime later today.

Narayan
sambit likes this.

Messages:
107
Narayan sir,
22. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

Sorry about the delay ; is tomorrow acceptable ?

Narayan
sambit likes this.

Messages:
107
Thanks.

OK Sir
24. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

See if this is OK.

Narayan

#### Attached Files:

File size:
23.7 KB
Views:
8
sambit likes this.
25. ### sambitMember

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

Again thank you for valuable response.