[AccessD] A2003: Calculating tax amounts (OT)

Darryl Collins Darryl.Collins at coles.com.au
Sun Aug 31 21:15:51 CDT 2008


Yeah, but our personal tax rates are pretty fierce compared to the US.  On the other hand, if you get hit by a Bus here and taken to hospital, you will get fixed up pretty much for free and won't have to sell your house to be the medical bills.

The current personal tax rates if you "Pay as your earn".

$0 - $6,000  Nil
$6,001 - $34,000  15c for each $1 over $6,000
$34,001 - $80,000  $4,200 plus 30c for each $1 over $34,000
$80,001 - $180,000  $18,000 plus 40c for each $1 over $80,000
$180,001 and over $58,000 plus 45c for each $1 over $180,000

plus a 1.5% medicare levy (Plus and additional 1% if you don't have private health ins and the Government think you should).
plus 10% GST (consumption tax) on purchases.  Mind you, the GST is a bit rubbery as some items deemed as essential (such as fresh food) as GST free.

There was a classic "Yes Minister" ho-hah about this when the idea was mooted (it took several attempts before the GST was finally introducted here). Specifically defining what is considered an 'essential' food and what is not, some of the more funny monents were the Cold/Hot Pie debate, and the infamous Birthday cake interview (which is commonly thought of these days as the cause of the opposition losing an unloseable election).

In short, If it is just a cake it was meant to be GST free, but a birthday cake that was decorated had to have GST on it - so did that mean icing? a candle? or?  You can see how the media had a field day with this.  Another great debate was Hot Pie/ Cold Pie - Cold pies were GST free, but a hot pie was to have GST.  Crazy stuff.

http://en.wikipedia.org/wiki/Birthday_Cake_Interview

Taxation - fun fun fun....



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren D
Sent: Monday, 1 September 2008 11:40 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A2003: Calculating tax amounts


Hi Gustav

Yes the tax rate in Oz it is still 10 percent - We have been very lucky. We had
a conservative government introduce it here a bit under 10 years ago. We have
just voted in a socialist government. They have kept the issue of raising the
tax rate off the radar - but who knows. 10 percent (despite me whinging about
it) seems kinda lean when looking at other GST and VAT nations

I had a feeling it was you who provided the solution in the first place
Didn't want to mention names - In case I forgot the correct person. I never
remember to use the archives - I really need to get into the habit
Many thanks for pursuing this - Gustav - Legend be thy name :-)

Many many thanks

Darren
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, 29 August 2008 7:26 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2003: Calculating tax amounts

Hi Darren

Still at 10%?

  http://databaseadvisors.com/pipermail/accessd/2005-January/030788.html

/gustav


>>> darren at activebilling.com.au 29-08-2008 04:07 >>>
Hi team

I have asked this years ago and can't find the answer nor the dB I performed it
on :-(

I need to know the inclusive and exclusive tax components of a given amount

Here in OZ the tax rate on goods and services is 10 percent

So if I have a $150 tax Exclusive amount then the Tax inclusive amount is $165 -
Simple

And whilst ever the tax rate is 10 percent I can divide by one 11th to get the
Tax Exclusive amount - no prob

But I had a formula from some lovely person on this list that allowed this to be
dynamically calculated regardless of the tax rate

Any clues?

Many thanks in advance

Darren


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.





More information about the AccessD mailing list