wa_tax_rate_update
Tool to update city/district sales tax rates in cust_main_county from the Washington State Department of Revenue website.
Creates, or updates, a FS::cust_main_county row for every tax district in Washington state. Some cities have different tax rates based on the address, within the city. Because of this, some cities have district.
If tax classes are enabled, a row is created in every tax class for every district.
Customer addresses aren't classified into districts here. Instead, when a Washington state address is inserted or changed in FS::cust_location, a job is queued for FS::geocode_Mixin::process_district_update, to ask the Washington state API which tax district to use for this address.
Options:
-f <filename>: Skip downloading, and process the given excel file
-t <taxname>: Updated or created records will be set to the given tax name.
If not specified, conf value 'tax_district_taxname' will be used
-y <year>: Specify year for tax table - defaults to current year
-q <quarter>: Specify quarter for tax table - defaults to current quarter
-l <lookup>: Attempt to look up the tax district classification for
unclassified cust_location records in Washington. Will
notify of records that cannot be classified
The state of Washington makes data files available via their public website. It's possible the availability or format of these files may change. As of now, the only data file that contains both city and county names is published in XLSX format.
https://dor.wa.gov
https://dor.wa.gov/find-taxes-rates/sales-and-use-tax-rates/downloadable-database
https://dor.wa.gov/sites/default/files/legacy/Docs/forms/ExcsTx/LocSalUseTx/ExcelLocalSlsUserates_19_Q1.xlsx
https://dor.wa.gov/sites/default/files/legacy/downloads/Add_DataRates2018Q4.zip
When this tool updates the tax tables, any additional tax table rows with a district set, where the 'source' column is not 'wa_sales', will have the country, state, county, and city values kept updated to match the data provided in the state tax tables
http://webgis.dor.wa.gov/webapi/AddressRates.aspx?output=xml&addr=410 Terry Ave. North&city=&zip=98100
Hey! The above document had some coding errors, which are explained below:
'=item' outside of any '=over'
=over without closing =back