# GST calculation

This topic is 6173 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I'm in the mist of completing a financial tracking system which talks directly with our default accounting system.

I'm trying to create a caluclation within a table to do the following.

If "GST status" = Yes, then divide "Amount" by 8 .

The good thing about FM is I can ask small questions and apply them to many other situations I get myself into. I have just finished a automated client database for a treatment centre.

I'd apprecitate any advice for the calculation I'm trying to achieve.

Regards, Topaz

##### Share on other sites

CalcField = If (GST_Status = "Yes", Amount/8, "")

I must be missing something, that was too easy.

##### Share on other sites

If GST is a tax, then this is not a good approach. Tax rates change, and they should not be hard-coded into calculation fields.

P.S. Divide by 8? Who has a tax rate of 14.2857142857%?

##### Share on other sites

If topaznz is in NZ then you should divide by 9.

100 / 12.5 = 8 but as you have already added the GST component you need to use 112.5 / 12.5 which is 9.

hope that makes cents!

Edited by Guest
##### Share on other sites

LOL yes yes, I'm a little bit of a simple novice with all this still - some may say thick but we won't go there. Thank you all for your help, will go take a crack at it!

Your right Kiwi; divide by 9, for some stupid reason I was thinking I was entering GST exclusive figures. Thanks.

bcooney; This is most likely 1 of several silly questions that will tap out of my finger-tips over time. Thank you for the calculation!

Cheers everyone for your valuable assistance!

Topaz

##### Share on other sites

You guys have 12.5% gst? And you get charged on the basics - at least we only pay like 10% and don't get charged on our "non-luxury" items - like bread lol.

But then you guys don't have Capital Gains Tax do you... hmmm, good place to make some money me thinks.

##### Share on other sites

I'd like to chime in with comment. I didn't realize this is a tax rate calculation. You should take the rate part out of this calculation and reference it instead. Store it in a Pref table. Then when the rate changes, you just change the pref value, not the calculation.

##### Share on other sites

LOL, if you're going to chime in with me, then suggest doing a lookup of the current rate and referencing the lookup, not the current rate.

##### Share on other sites

Ahh, of course, comment. Kinda assumed the lookup didn't I? Just thought that your point of separating out the rate was lost in the discussion.

##### Share on other sites

This topic is 6173 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account