Brian Dunning's FileMaker Custom Functions

stateSalesTaxRate ( state )

Outputs the tax rate for state that was passed.

  Average rating: 4.1 (39 votes) Log in to vote

Jason P. Scharf   Jason P. Scharf
DB Services, Inc.
http://www.dbservices.com/

Share on Facebook Share on Twitter

  Sample input:
stateSalesTaxRate ( "IN" )
  Sample output:
.07

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This function will provide the state sales tax rate for all 50 states, and D.C.

You can provide a state in one for three formats: full name, standard abbreviation, and postal abbreviation (e.g., Indiana, Ind., IN).

 

Comments

Bruce Robertson   Bruce Robertson
Feb 3, 2011
WA state tax is address-specific, see:

http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBased/ClientInterface.aspx
 
Andy Frazier   Andy Frazier, Mx4Px
Feb 4, 2011
State rates are a good start...but check out NY rates, which have multiple rates per city. Or TN - they have rates which vary by county and purchase amount. Sales tax is a bit of a rabbit hole issue no matter how you slice it. Unless you live in NH ;-)
 
Bert   Bert, Los Angeles, CA
Feb 8, 2011
CA has a base tax rate that is then increased based on the county/city/district rate.
Even within a County we can have more than one final rate.
 
Jason Scharf   Jason Scharf, Sellersburg, IN
Feb 10, 2011
I have to agree that the fucntion falls short! Does anyone have a good idea on how best to account for the tax codes of states like OH, CA, and NY?
 
Sean   Sean, Birmingham
Mar 3, 2011
This should not be a function, but rather a table and have a lookup copy the tax data over.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.