Ask Your Question

how to calculate GST in calc

asked 2017-10-05 10:20:07 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

hello all this is my first post so recently ive been tasked to create a invoice template for a new company and ive downloaded this templatefrom and im trying to replace the Discount % section with GST so we can automatically add the GST to the customers bill. my question is what should i put in place of sections f33 and f34 to add a percent from the line total? thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-10-05 12:22:49 +0100

robleyd gravatar image

In F33 put the GST percentage rate, e.g. for Australia 10 (percent). Simply change F35 to


So you add the amount as GST rather than subtracting a discount.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-05 10:20:07 +0100

Seen: 194 times

Last updated: Oct 05 '17