10 replies [Last post]
Plecebo's picture
Offline
Joined: 07/16/2008
Juice: 9
Was this information Helpful?

So apparently my state (washington) implemented a destination based sales tax system. (read about it here: http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBa...)

Basically you charge tax based on where the item is shipped, rather then where you ship from. It means you have to have the tax rate for every Zip + 4 combination in order to charge the appropriate tax. That is a heck of a lot of tax rates to input manually.

So far I have not seen any information about a query api that would allow ubercart to lookup the tax rate information based on zip code or address. *sad panda*

Anyone have any ideas, or how are you handling this new tax stuff in Washington?

They have listings of zipcode + 4 and other such info here: http://dor.wa.gov/Content/FindTaxesAndRates/ZIPFldDescripShort.aspx

and a gui based lookup tool here that even gives the rate, and a confirmation code (which would be nice to capture): http://dor.wa.gov/Content/FindTaxesandRates/SalesAndUseTaxRates/LookUpAT...

Ideas?

TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: Washington State destination based sales tax UGH!

Yes, I've done this. Haven't posted it yet since I still need to finish up the code.

<tr>.
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Washington State destination based sales tax UGH!

Sounds like TR is a step ahead... I was trying to find this thread last night but didn't have it bookmarked on my home machine. Sticking out tongue

Plecebo's picture
Offline
Joined: 07/16/2008
Juice: 9
Re: Re: Re: Washington State destination based sales tax UGH!

Thanks for the replies, I'd be VERY interested in helping or testing out your code TR. Any idea on timeframe till you are ready to release (a week? a month?).

Plecebo's picture
Offline
Joined: 07/16/2008
Juice: 9
Re: Re: Washington State destination based sales tax UGH!

TR: I'm sure you have this information, but incase not.

I contacted the Washington Department of Revenue (the agency responsible for the changes in tax) and complained a little bit.

They pointed me in the direction of a webservice they have setup to allow software to pass address via url variables and get the tax information returned in either plain text or xml.

To see the examples they have setup see here:

http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBa...

Thought this might be helpful to those working on this issue, I couldn't find this information anyplace on the site.

TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: Re: Re: Washington State destination based sales tax UGH!

Yes, I have it, thanks. That's what I'm using.

They make it sound like they're so helpful, and are giving you all the tools you need to comply with the law. What they aren't telling you is that a prototype of the web service wasn't released until 6/13/08 - just two weeks before the new calculations became mandatory under the law. And the minimal documentation you link to wasn't even available until after the deadline.

This despite the fact that they've had several years to plan for the change. And the fact that many others, including me, have been complaining since the fall by phone, by e-mail, and by snail mail, begging for a web service, and begging for it to be released well ahead of the deadline so we would have time to implement before the law changed.

By they time they announced the web service, my time was fully committed to a job, so I could not get the Ubercart module finished in the two weeks before the deadline. I've hacked it into my system in the meantime, and I hope to be able to find some time before the end of this month to finish it off.

Can you tell I'm a little annoyed? Judging from last year's sales, the change in the tax law is going to change the amount I have to remit to the state by only a few hundred dollars a year (most of my business is out-of-state, and the rate differences under the new system are measured in tenths of a percent). Yet it's costing me thousands of dollars in billable time to implement this properly, and they're making me drop everything to do it at the last minute due to their poor planning.

Ironically, the change will *decrease* the amount of tax I have to collect, because I'm located in the highest-taxed location in the state. Under the old rules, I collected this high tax based on my location, under the new rules, I collect tax based on the customer's location, which is always an equal or lower rate.

<tr>.
Plecebo's picture
Offline
Joined: 07/16/2008
Juice: 9
Re: Re: Re: Re: Washington State destination based sales tax UGH

I'm in complete agreement here. I heard about the changes after July 1 and I was surprised that the state had so few resources available to help people trying to work through this.

If you need help with getting the project moduled up, like testing or something. Let me know.

Thanks for putting this into a module so others don't have to hack something together.

bowwowadmin's picture
Offline
Bug FinderEarly adopter... addicted to alphas.
Joined: 12/09/2007
Juice: 70
Re: Re: Re: Re: Re: Washington State destination based sales tax

what a pain

jhodgdon's picture
Offline
Getting busy with the Ubercode.
Joined: 12/02/2008
Juice: 87
WA module coming soon

I'm not sure what TR's plans are (tried to contact but no response), so I wrote my own module that uses the WA lookup service to calculate destination-based tax.

It needs some testing. If you'd like to test it, please contact me. I'll release it on this site's contrib area when it's been tested a bit...

CasaDelGato's picture
Offline
Joined: 12/05/2008
Juice: 64
Tax PITA

I just found this thread, and I REALLY hope you get that working.
I'm just about to go live with a website, and hadn't realized the mess the WA legislature had made of the sales tax situation.
blech.

jhodgdon's picture
Offline
Getting busy with the Ubercode.
Joined: 12/02/2008
Juice: 87
Module is working...

I just posted my module to the "contrib" area: http://www.ubercart.org/contrib/8311 -- it is fairly short and sweet, and I think it's working fine. Let me know if you find any problems, of course!