Formula to find GST (Inclusive and Exclusive)

https://aporaclepayables.blogspot.com/2021/08/formula-to-find-gst-amount-from-invoice.html

Formula to Find GST Amount from Total Invoice Amount (If Invoice Amount is inclusive of GST Amount)

A Total Invoice Amount incl. 13% sales Tax 403416.78 B Formula to calculate Invoice Amount from the Total Invoice Amount =403416.78/((100+13)/100) 357006 A-B GST 13%      46,410.78

OR

A	Total Invoice Amount incl. 13% Sales Tax	403,416.78
B	Formula to calculate GST 13% from the Total Invoice Amount =403416.78*(13/(100+13))	46,410.78
A-B	Invoice Amount exclusive of 13% Sales Tax	357,006.00

-----------------------------------------------------------------------------------------------------------------------------

Formula to Find GST Amount from Invoice Amount (If Invoice Amount is Exclusive of GST Amount)

A	Invoice Amount exclusive of 13% Sales Tax	357006
B	GST	13%
C=A*B	Formula to calculate GST from Invoice Amount=357006*13%	46410.78
A+C	Total Invoice Amount incl. 13% Sales Tax	403416.78

-----------------------------------------------------------------------------------------------------------------------------

Formula to find Invoice Amount from GST Amount 

A	GST (13%)	46410.78
B	Invoice Amount exclusive of 13% Sales Tax =46410.78/13%	357006
A+B	Total Invoice Amount incl. 13% Sales Tax	403416.78