Jump to content
Sign in to follow this  
topaznz

GST calculation

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 this post


Link to post
Share on other sites

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

I must be missing something, that was too easy.

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.