Jump to content

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

Link to comment
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
Link to comment
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

Link to comment
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.

Link to comment
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.

Link to comment
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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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