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