Washington Destination-Based Sales Tax and Online Stores
May 11th, 2008If you’re a Washington state business and you ship/deliver goods within Washington state, you need to collect sales tax based on the destination starting in July 2008. This is very different from the current way we do it, which is based on whether the business is based in Washington. It’s quite confusing, and I don’t have it all sorted out, but will be updating this article as I learn more.
Here are the official links from the WA Dept of Revenue:
The Washington State Department of Revenue “Destination-bases sales tax” page.
Another Washington State DOR “Destination-based sales tax” page.
A nice video on Destination-based sales tax.
And the DOR email contact form if you have questions.
But look at this…an ONLINE RETAILERS SURVEY…if you have an online store..please take this (I took it and submitted my own opinion)
And some unofficial online discussions:
Online Merchant Network Thread
Lots of folks are worried about how to implement this way of calculating taxes in their online stores. Currently most of the online stores I’m familiar with do not support this kind of tax calculation. I founds lots of speculation, nothing that came directly from the WA DOR.
So I decided to contact the Washington State Department of Revenue and ask for myself.
Here’s what I sent:
I do website design, and have several clients who operate online stores. Currently, all the online store applications I’m familiar with calculate tax based on settings inside the online store application that determine the customer’s state.
For online stores in WA, this is typically set to 9%. In order to comply with the June requirement (and just to clarify, this is not voluntary, right?) all online stores in WA that ship to WA, now need to determine which location code the customer is in, to properly charge the right amount for sales tax.
I’ve seen nothing on your website regarding online store database integration – meaning, that DOR would maintain a database that, in real time, my online store would connect to to determine, again, in real time, what the appropriate tax rate to charge a particular customer.
This would be similar to how online stores calculate shipping costs, on the fly, by connecting to USPS, or FedEx or UPS. I would assume that DOR would be the same way – because it’s not possible to have an online store with someone sitting around manually looking up these codes.
I received this on April 04, 2008 from “DOR Streamlined Sales Tax”:
Ms. Olkoski,
The Department is considering providing a web service that would allow online sellers to connect to in order to determine the appropriate tax rate for their buyer’s address. However, we have run into concerns with that approach.In the meantime, we ask that sellers do what they can to collect the Washington sales tax.
If they have no control over the settings and they can only use the one rate, then we ask that they adjust, after the fact, for purchasers that request a refund of overpaid sales tax.
Of course, they would also adjust their reporting to reflect actual collections and refunds or credits.
Please write again if you have any questions.
TAXPAYER SERVICES
So the Washington State Department of Revenue gave me a nice speedy response to my question, and I recommend that if you have questions, you email them as well.
UPDATE: 5/16/08
I received a voicemail from the Washington State Department of Revenue – and you simply have to be really impressed with their customer service – telling me that the response they emailed to me should be considered a work in progress. They said that they would be sending me a more complete response in a few weeks, and I’ll post it here as soon as I get it. They are actively working on a more formal solution for us online business owners, and we need to just sit tight and see what they come up with.
Jill--------------
J. Olkoski
Aldebaran Web Design, Seattle
Jill Olkoski has a BS in Engineering, a BS in Computer Science and an MA in Clinical Psychology. She delights in using her advanced technical and psychological skills to help small business owners develop cost-effective and successful websites.
May 15th, 2008 at 7:44 pm
Last week I also had a conversation with a DOR staffer who basically told me that they do not have a solution for online shopping carts and have no idea as to how they (or anyone else) would implement this – hence their online survey. I have talked several times to one of their “certified” providers, Avalarra, who also has no solution to working with a Yahoo or online store in real time. The staff repeated several times we are just looking for people to make a good faith effort.
May 15th, 2008 at 7:47 pm
Hi June,
Thanks very much for your comment – it’s great to see that the DOR staff is at least consistently sending out the same “do the best you can” message. Also, very interesting to know that their “certified” provider can’t do it either. Again, thanks for sharing!
May 22nd, 2008 at 12:06 pm
Greetings,
I have some thoughts to share but wish first to inform you that I am neither an attorney nor a psychic. My comments were hastily prepared, but I think are pretty close; I look forward to your opinions. The first part of this was from a message I sent to a group (cfif.org) to get an outside take on the constitutional issues. I am not affiliated with nor do I endorse this (or many other groups). The latter part of this is from an e-mail I sent and have edited slightly. This is a long read, but I think it worthwhile đ
On 1 July, 2008 the State of Washington launches the “destination based sales tax”. As a small business owner, I am responsible to ‘comply’ with this change in how the State wants to deal with the collection and reporting of sales tax.
Currently, if we sell and deliver a product to someone in Washington State, we charge the tax rate for the location where our business is. As of 1 July, we will be required to charge tax based on the destination (within the state). This means that every business that takes the occasional phone order will have to determine tax based on either; 1) a location by name list of approximately 360 different areas/combined tax rates, or 2) through the use of an address verification tool, determining tax rate by the destination zip+4 (over 33,000 differrent codes).
This change in our State tax law was requested by Governor Christine Gregoire who previously was our State Attorney General . The Washington State Legislature drafted the legislation and sent it to the Washington State Department of Licensing (they perform accounting and analysis functions as well) for review. Washington State Department of Licensing sent it back to the legislature noting that it would cost the State of Washington more to implement than it would recoup in any additional revenues and more importantly, that businesses would have a very hard time complying with the law.
My belief is that Governor Gregoire in alliance with the other member states of the Streamlined Sales Tax Project (SST), is setting the stage to challenge the U.S. Supreme Court decisions “Quill Corp v North Dakota” and “Hess v. Department of Revenue” by countering the statement that “State taxation falling on interstate commerce . . . can only be justified as designed to make such commerce bear a fair share of the cost of the local government whose protection it enjoys.” becomes null when a contingency of states band together and reciprically collect each others’ sales taxes. In this model, the member states get past the test(s) of Complete Auto Transit v Brady (1977) – through the argument that the tax is fairly apportioned (reciprocal tax collections), does not discriminate against interstate commerce (reciprocal tax collections) and the tax is fairly related to services the state provides the taxpayer.
Additionally by keeping it ‘in-state’ first, Governor Gregoire is coercing businesses in Washington to create a solution to calculate and account for an excessive number of different tax locations. Since this is intra-state, it falls outside the protections provided under the interstate commerce clause. If this additional recordkeeping burden can be demonstrated to be performed by businesses and determined that it is not causing harm to businesses , it follows that a group of states can argue that it wouldn’t be cumbersome to calculate different rates for ALL the member states. The Washington State Department of Revenue (WA-DOR) has contacted concerned businesses and stated that they expect only a ‘good faith’ attempt to follow the new law – meaning 1) the WA-DOR is not likely to penalize businesses that make some attempt to follow the law, 2) since any difference in calculation would be due to the small differences in city or certain local tax rates since the State sales tax is the same, WA-DOR is unlikely to invest the time and money to audit businesses for small amounts that do not directly benefit the state (unless my assertion above is valid) but rather cities and municipalities and 3) it buys the state time while developers of software revise their programs if possible to deal with all the additional tax locations without forcing businesses to bring an action against the state – they are focusing on blindly persuing a solution to the immediate problem without understanding the precedent they will ultimately create for the SSTI member states to use against them.
From my e-mail message –
I spoke with an attorney (specializes in small business tax issues) regarding this; the attorney’s take is that 1) WA-DOR is unlikely to deal with more than a 90-day window IF they even consider auditing. 2) (as I interpret) The cost of auditing is pretty high and a relatively low ROI – the average for combined tax is 0.082 (0.070-0.090) so, let’s say for example; you have a local tax rate of 0.085 and continued to charge your local rate and totally blew off this destination based crap…
Example:
IF you had all your ‘destination based sales’ sent to King County (0.090) and charged 0.085, the difference would be 0.005. For every $100,000.00 in sales you inadvertently erred in computing tax’, this would result in $500 in lost tax revenue (for King County) – the State still gets it’s 0.065; the question arises – “is it reasonable to assume that the State of Washington is likely to spend state tax dollars to audit (costing more than $100/hr) any business when it is improbable to recoup the cost?” – I think NOT.
Another suggestion (that I didn’t agree with) was to charge and document the cost for calculating the tax rate and pass that on to the consumer much like the fee for using a debit card or having a fee to use VISA/MC for an amount under $5 (i.e. passing on the cost for using a 3rd party provider like AVALARA, not that I have anything against Avalara). The idea being that the consumer would be irritated enough to contact their legislators and complain. In my estimation, it would lead to the loss of more business to out-of-state businesses and ultimately cause WA state businesses to lose more revenue -and- when did our elected folk ever listen to the folks who pay their salary?
After all my discussions, I have come away with a very simple idea (I won’t call it a plan yet)…
Let’s say you have a business in unincorporated Skamania County (0.070 is the lowest combined rate in WA) and you do a little bit of mail order or e-trade. If your average sale is $100 and you calculate the difference between 0.070 and 0.090 tax rates, you get $2 in tax difference (state average would be about $0.82). The DOR is asking businesses to act in good faith (which I don’t think the State is) and issue refunds to customers who are overcharged (I wonder if the State will start calling customers and demand the difference if UNDERCHARGED?).
So hypothetically speaking, I would add 2% to a s/h charge (it’s legal to charge a documented s/h charge still). One additional handling charge is much easier to deal with than 360. IF audited, I would have additional funds to offset the tax difference, it would be UNLIKELY to receive any real penalty from DOR, and if you did this, you would have the satisfaction of having the AUDITOR do the calculations at the State’s expense! What would happen next is the big question…
How many of you retired during that read? đ Dan
May 28th, 2008 at 3:34 pm
I’m with a Tacoma software developer (we do retail point-of-sale systems). We’re in the process of releasing a web services version of our Tax Link program for Washington, in large part because of the uncertainty regarding exactly what the state might provide.
Jill, I don’t want to spam your blog comments with commercial stuff, so I won’t include any further details unless you say it’s OK to.
May 31st, 2008 at 11:58 am
For those trying to implement a solution into their shopping carts…there IS a flat file available from DOR that shows tax details by ZIP+4. DOR will update this file on their site every quarter.
Link: http://dor.wa.gov/content/FindTaxesAndRates/SalesAndUseTaxRates/stdownloads.aspx
Steve
http://www.inandoutgifts.com
June 3rd, 2008 at 2:33 pm
Edge Technologies has a stand alone program and one that will work with shopping carts to calculate the destination sales tax.
June 4th, 2008 at 2:43 pm
Sorry, forgot the website:
http://www.profit-plus.com
June 5th, 2008 at 1:56 pm
Jill,
I too am a web designer with e-commerce clients. Thanks for your post–it’s valuable information for those of us who are trying to help find solutions for our clients.
I’m intrigued with Daniel White’s suggestion of a handling fee to cover the local tax portion of the sales tax. This might be a workable solution–hopefully a temporary one! It’s amazing that the legislature passed this law without providing _any way_ for merchants to implement it. Is this an example of technological illiteracy?
This thread might be of interest as well:
http://www.onlinemerchantnetwork.com/inform/board/message?board.id=OnlinePayments&message.id=2220
I have sent an inquiry to the company mentioned in the last post of that thread, Profit Plus.com. Their Tax Link solution may be worth looking into.
Thanks again, I’ll be following this post for updates. If I come up with more info of my own I’ll try to let y’all know as well.
June 12th, 2008 at 4:03 pm
I am a small business owner – we write software targeting other small businesses. Just as a note regarding solutions providers – Avalara and the other CSPs (by the SST governing board – not WA State) are simply huge faceless corporations that got their application into SST at the right time in order to become a CSP. This does absolutely nothing for other small businesses who can’t afford their uber-expensive, enterprise-level solutions. My partner and I have developed a set of inexpensive solutions for SST – and because we are a small business, we’re also able to adapt and respond quickly to the needs of others. I urge anyone to take a look at our products available now & if you have another need – just let us know & we can do whatever we can to accomodate that – it’s our business. Online shopping carts are a difficult problem, because there are hundreds of them. Our own “buy now” feature on our website uses paypal – and we’ve successfully integrated our sales tax calculator product with that in order to charge the correct sales tax to WA customers at the time of purchase & download. There’s no reason we shouldn’t be able to do the same for others. If you have other shopping carts you would like us to look at, please post a comment on our forum.
Thanks for checking it out – Josh.
June 27th, 2008 at 12:57 pm
I am interested in Josh’s solution (June 12th) but there is no website or email link in this post. Can you send one or include it in the post?
June 27th, 2008 at 1:51 pm
Hi Joseph,
If you hover your mouse over Josh’s name, it will give you the URL he put in. It’s http://www.gotsst.com/
If you find it useful, please let us know – I haven’t verified it at all.
July 4th, 2008 at 7:39 pm
Thanks Jill for pointing out our URL (on my name) – by the time I was available to respond – you already had – so thank you.
In case people are still wondering (for WA state), the DOR just sent an email out this past week announcing a solution for shopping carts! It’s a URL-based lookup query (as opposed to a webservice) that returns a XML dataset for results. It’s actually pretty awesome & seems to be very very fast in returning results. The link to it is: http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBased/ClientInterface.aspx
This has definitely put a damper on the WA-only business for our webservice (not that big of a deal, because our other products are the strong ones), but it’s an easy solution for businesses with shopping carts to adapt to and I definitely urge businesses to take a look at it – it’s probably the best tool the DOR has available for SST. Just beware this is only for WA state (which should be just fine for most of us).
Josh @ Snowcap
July 7th, 2008 at 11:42 am
Thanks for the update Josh. This is definitely progress, but still requires a major hack to all of our shopping carts.
I wouldn’t call it “easy” because most small online store owners have no idea how to implement this into their online stores.
If you have recommendations as to how to implement with PHP based stores, I’d love to hear it.
July 17th, 2008 at 10:45 am
If you’re a PHP programmer, it’s fairly simple. I only just learned about the DoR service from your blog comments, but I’m just today putting essentially the same idea online here internally.
Assuming you’re a complete novice (well, a complete novice shouldn’t be doing this,really):
There’s a library of PHP extensions called PEAR. The basic PEAR library ships with PHP. There’s an extension in PEAR called HTTPRequest. You’ve heard of AJAX? HTTPRequest is the way the modern servers and clients communicate with each other without loading a separate page.
Basically, your PHP program builds a HTTPRequest, ships it to the URL as shown on the DoR site, and receives back an XML string. You process that XML data to get your tax rate. PHP has XML functions to handle it, or you can just ignore the XML and ask for plain text and do some pattern matching on that instead.
Anyway, it’s relatively simple and painless from the standpoint of programming it if you’re already experienced with PHP programming. It’s not plug and play but it’s not tough either.
July 17th, 2008 at 1:08 pm
Hi Scott,
Thanks very much for the detailed explanation. I’ve been doing some PHP coding for the past few years, but haven’t heard of this, and so I’ll have to do more research in order to determine the ease of implementation in the WA online stores I use for my clients. But I’ll also use your response to make a request to my online store builder (eCommerceTemplates) to see if they would consider adding this in the future. Again, thanks very much for the information.
July 17th, 2008 at 1:20 pm
Another thought on Scott’s comments…that while from the eyes of an experienced PHP programmer, the task of creating a custom hack for someone’s online store might seem simple, view this from the store owner’s perspective.
You have an online store and have zero programming skills. You’re supposed to go out and hire a free lance programmer – and then trust this person to create a hack in your store – your source of livelihood – in which you’re taking sensitive information like other people’s credit cards. Someone who can make a hack to perform the tax info gathering can certainly make a hack to divert the credit card numbers.
So while to a reputable programmer, this seems simple, to a store owner, this is a formidable issue, and not without some financial risk involved. It’s hard enough for folks out there to find a reputable web designer, much less a reputable PHP programmer and give them complete access to their online revenue stream – it’s really asking online store owners to take a huge risk it seems to me. All to collect accurate tax which might be the difference in cents for an order.
July 17th, 2008 at 1:50 pm
I have mixed feelings about the whole thing. I’d just as soon it wasn’t neccesary, but the pennies today thing is really the predecessor to the dollars tomorrow when those other 21 states start collecting WA state sales tax on orders sent to Washington.
That also means that any solution for Washington today needs to be extensible to the entire country tomorrow or next year when we are required to reciprocate to the rest of the SSUTA.
I hope that the DoR is planning to make their online request server compatible with members states when that day comes. I surely wouldn’t want to be explaining to every small online business in the state that they have to change their software again.
July 17th, 2008 at 2:00 pm
Amen…completely agree!
July 18th, 2008 at 7:35 am
All of our online products utilize our one webservice – giving our customers automatic access to all states (once we get them all online) – and giving businesses a central point of determining the tax code/rate. We’re slowly getting more states online – there’s no real rush for it (so far) until the whole inter-state thing comes up. I doubt the DOR will update theirs to include multiple states – right now it seems to be very basic – not even any address correction involved, so if you spell “Street” instead of “ST” – it won’t be accurate – whereas ours goes through normal address standardization methods before processing. This is another reason we feel we have a good set of products for small businesses, but for right now if businesses are strapped for cash and don’t fall into the credit offered by the DOR, the free service they offer is a great step – provided you can implement it in your billing software!
July 18th, 2008 at 12:23 pm
The DoR XML spec suggests that they ought to be returning a standardized address, even though they don’t. The fact that they can create a reasonably accurate tax rate value from a street address and a five-digit zip suggests that they ARE doing standardization behind the scenes. I double-checked them using 98012, which has three different rates depending on the zip+4. It pulled out the correct rates for addresses in different tax zones based just on the street and five-digit zip. The only way to do that is if it figured out the zip+4 from the street/zip combo.
My take on this is that they intended to perform standardization as well, but somebody realized that the license on their address processing software didn’t allow it (the CASS software we use internally has such a license – it can serve unlimited users as long as the info doesn’t leave the firm), or someone just decided it would be bad for the government to effectively be competing with the private sector in the area of address correction.
This is the kettle of fish that small businesses are in. To do it right, you really need to invest in an address standardization system, subscribe to regular updates, and keep a database of the tax rates and locations, also updated regularly.
You’re also depending on the DoR site to be working correctly 24/7. At the moment, that doesn’t seem to be the case. After some discussion here, I decided to code in a call to the DoR service as a backup in case the internal server is down or can’t resolve the address. Starting around 2:00, the DoR service stopped responding correctly. This morning, it was fine again.
I guess it’s a good thing that they’re supplying some sort of solution for businesses but I’d a bit leery about having to rely on it. Of course, until SSUTA actually goes online, you could really just ignore the whole issue, charge everyone 9%, and deal individually with anybody who wants a refund of the pennies they might have lost due to being overcharged on their sales tax.
July 21st, 2008 at 6:38 pm
The D.O.R. should just charge a flat internet sales tax rate for the state. It will work out for everyone in the end.
July 21st, 2008 at 9:08 pm
James,
I couldn’t agree more.
Jill
July 21st, 2008 at 9:51 pm
From what I understand, the only other SST state anywhere close to the complexity of Washington is Kansas. Some of the others are a flat-rate for the entire state (no local taxes), and the ones with local taxes are easier to compute – like based on zipcode or county, etc…
I personally like the flat-rate model.
July 22nd, 2008 at 4:53 pm
Well I think that the flat rate model will serve both sides of this monster fairly, business and consumer. Have you looked at how many counties there are in WA State? I did yesterday trying to figure out how I was going to accomplish this task. You would be a long time in getting them done in the first place, and they could change each quarter.
The flat rate is the best system. Some may argue that they pay a lower sales tax where they live and itâs not fair. To them I ask, âWhen you go out of your town or county, do you expect to pay a lower tax?â I donât think so; you pay what the next town or county charges.
One rate for the Internet State Tax, the average works out to 8 %. A little higher for some, and a little lower for others. In the end the State of WA gets there monies, and does away with my headache.
October 27th, 2008 at 5:22 pm
If anyone is still struggling with this we strictly use a .NET based ecommerce program called AspDotNetStorefront and have created a customization utilizing the Tax Rate Library provided by the State. If any one out there is using this program and needs assistance in implementing the code we would be more than happy to oblige, it only takes a couple of minor changes.
Check us out – Bright Spectrum (www.brightspectrum.net)
November 18th, 2008 at 8:15 pm
WA DOR just told me to make an effort. In my case I use Cyberstrongs eShop software, which is an ASP coded cart system. DOR said I could do it by Zip +4 but my cart system does not do the +4. By using extended tax rules available in the cart system,I manually entered the name of every municipality in the State of WA into the cart, It now looks up by City in WA. Of course there can be several different tax rates in each City , not to mention the County and various transit zones etc. I just picked at random, 1 tax code for each municipality. This took me about 12 hrs. Then when I went to do Qtr. 3 WA tax online, What used to take maybe 15 mins. at most took almost 2 full work days, and for what purpose? Just plain pure and simple legislative Stupidity. I have been trying to get a solution out of WA DOR for over a year prior to this thing taking effect. I’m no programmer and I like the cart system I have, but even their developer could not come up with a solution as they said it would take a re-design of the entire cart and is beyond what they would be able to do. I sent off countless emails and phone calls to my WA State legislators as well As the Governor’s office and never once ever received a reply except from DOR whom basically just said, do the best you can, no problem. What a bunch of crap.
November 18th, 2008 at 8:36 pm
Hi David,
Wow, what a nightmare. I also gave it a try with the online store I install for my clients. I was not going to attempt to fully integrate it, but just see if I could have some kind of add on that clients could use afterwards. Well, much like you, after a few hours of effort, I gave up. Most of my clients may be lucky because they’re in Seattle, and so the bulk of their orders come from one city. I think some of my clients will simply export a spreadsheet, sort by city, and for all the non-Seattle cities, just do the math by hand using their manual lookup. But I completely agree, it’s a bunch of crap. To spend hours and hours and maybe days of effort just for pennies, is insane.
January 18th, 2009 at 11:16 am
This “not-very-well-thought-out” destination-based sales tax nightmare has forced me to quit shipping products within Washington State.
The State is telling us, “you figure it out the best you can, at your expense, then send us whatever tax money you collect!”
Any software that may be developed to solve these issues won’t help me, because I don’t have a shopping cart on my website. Oddly, a large percentage of people ordering my products don’t know what they want in the first place… so how can they “add to cart” before getting answers to at least a dozen questions. When I ask customers what their sales tax rate is – most of them don’t know, so I rely on the DOR website to calculate it for me. This is a huge nuisance.
If a customer wants my products, he/she will now have to drive down to my shop and pick up their order. Simple as that. 99% of my internet-based sales are to out-of-state destinations, so it won’t hurt me that much.
I feel sorry for all the people wasting their resources to try to comply in good faith with the Washington State’s “experiment” that is going to end up costing everybody a lot of time and worry. Not me! Enough’s enough!
I wonder how many of the Legislators who voted to implement this stupid arrangement even know what it entails. If I had my say on the subject, here’s what I would vote YES for: Going back to the “origin-based sales tax”, with only one sales tax rate in the State; that rate being set for the entire year without all the changes each quarter. That’s too simple – but how happy it would make all Washington Retail businesses!
February 17th, 2009 at 1:40 am
hi.. this may not be the height of bureaucracy… but i can see pretty far down.
I’m building a site for someone in WA in joomla/virtuemart… can anyone help me integrate this… um… brilliant technology?
February 17th, 2009 at 10:42 am
Hi John – I don’t work with Joomla or Virtue Mart – but wish you luck!
February 17th, 2009 at 1:59 pm
Thanks anyway Jill… I will post anything else i find out here for joomla guys as i have found it to be the most informative info for this subject
January 12th, 2010 at 5:35 pm
I wished I had found this site earlier. Here it is 2010 and I’m wondering if anythng has imporved. From looking over the DOR site it seems to me all they’ve basically done is updated their tax rate charts.
Has anyone taken the appoach to look at each zip code group and then just apply the highest rate of that group to just that zip code and drop the +4?
January 17th, 2010 at 12:09 pm
We are brand new to online retail sales. We are using a turnkey website because we have no programming or website design experience. Our website payments are all processed through PayPal. It all seemed so straightforward until I it the sales tax hurdle. I was told by my website vendor that I need to set up the taxes in PayPal. But, PayPal only has an option for one state sales tax. Or I’m just missing how to do this.
Has anyone used PayPal to process payments? How do you collect the right WA sales tax? We have not gone live yet so haven’t had any sales. I’m totally overwhelmed with how to do this.
Any suggestions on how to incorporate this via PayPal?
January 19th, 2010 at 11:07 am
Hate to say it,Melanie, but the right way to do it would be to hire someone to add a module to your website that would look up the tax before you submit the total to PayPal.
Your shopping cart is written in PHP, so adding the functionality shouldn’t be a problem, though I say that without having actually seen any of the code behind your shopping cart. *heh*
There are two issues that have to be dealt with. The first is that you can’t rely on the customer. What I mean is that the tax rates can vary based on the Zip+4. Sometimes, it varies a lot, based on which side of a city or county boundary a house lies on. If your customer doesn’t know his full Zip+4, then you need to be able to look it up based on his address.
That will probably involve a post office database and associated address normalization. Honestly, if you’ve got a mail order business, you should be doing that already, anyway. (This is going to cost you a periodic subscription fee.)
Second, when you have the full Zip+4, you do a lookup in the DOR database to find the appropriate tax rates. They have tools that let you do this over the internet nowadays, or you can setup a local database (your web host probably allows mysql if they allow PHP) and then you just have to update it quarterly.
All of this back-end stuff would happen BEFORE submitting to PayPal.
It gets worse. The forms you submit to the DOR monthly require you to break down your payments based on zip code groupings (location codes). That means you’re going to want some kind of reporting utility also, unless your volume of orders is small enough that you don’t mind going through your orders database by hand once a month and adding them up yourself.
The best solution of all would be to contact the vendor of your shopping cart and see if they offer a module that handles all of this for you. If not, then you’re left with hiring someone to custom code a solution for you and integrate it with your shopping cart.
Though one simple way to handle it is to figure out the highest rate in the state, charge everyone that, and hope that nobody notices that some people are being overcharged… đ
I’ve done this for my employer’s website; the caveat being that we own and control all of the servers in-house. We’re not hosted by an ISP, so I was able to do some things that might be more difficult if you aren’t able to easily add software to your web server.
My email address is scott@cjhunter.com if you have specific questions you’d like answered about how I solved this problem for our setup.
Scott Schultz
January 19th, 2010 at 8:37 pm
Hi Melanie,
Iâm going to start with a quick plug for my companyâs product offering and then just give you some general advice on your problem.
My company offers a line of products (http://www.gotsst.com) specifically designed to solve the problem of calculating and charging the correct sales tax rate for the Washington State Streamlined Tax requirement. All of our solutions are designed for very low cost implementations. Specifically, we offer a web service based solution that is very easy (for a programmer) to integrate into your existing website â this product takes an address as input and return the correct tax code and tax rate for further processing. The web service starts at a cost as low as $60/quarter, but that doesnât actually cover the programming required to get this integrated with your shopping cart. We also offer a series of products that integrate with common small business accounting packages (like Intuitâs QuickBooks) â these products are designed to calculate the correct sales tax rate for invoices or sales receipts that are entered manually by you.
Now for the general advice on addressing your problem: The Washington DOR put on a whole series of public meetings prior to the adoption of the streamlined sales tax in an attempt to educate the business community. I attended many of these meetings throughout the state (mainly to plug our products). The recurring theme throughout all of these meetings was that many small online retailers simply donât have the technology (or resources) available to correctly calculate and charge the correct sales tax rate. The DOR clearly understands this issue and even indicated that they had been trying to work with companies like PayPal to help them solve this problem â but to no avail. Anyways, all of that said, if you donât have the resources available to solve this problem via programming, then I strongly recommend that you simply contact the WA DOR and ask them for an evaluation of your situation (they may do this over the phone or onsite). The result of the evaluation will almost certainly be a compromise â something along the lines of charging a flat tax rate for your WA purchases and then calculating the correct rate and paying the difference when you file your taxes. I really believe that the DOR will work with you on this problem â particularly if youâre proactive about it.
A couple of other notes:
-The State of Washington used to have (not sure if it is still available) a $2000 tax credit that was available for businesses to cover either implementation or service costs associated with moving over to the new streamlined sales tax. Should you decide to tackle this problem yourself, you should check to see if this credit is still available.
-If youâd like, you can send me some information about your shopping cart application. Iâd be happy to contact your shopping cart vendor to see if they have an interest in integrating their product with my companyâs service.
Sorry for the long response â hopefully some of this information is useful to you. Donât hesitate to shoot me an email with any questions.
Regards,
Ken
ken@snowcapsoft.com
January 21st, 2010 at 10:29 pm
Thank you both for your replies. I am going to call DOR tomorrow and see what they suggest. I also have an appointment on Monday to talk to my website provider to see what they can do to help. I’m not ready to give up on this (gulp).
January 22nd, 2010 at 1:19 pm
I had someone make me a solution for Virtuemart about a year ago.. it is a single file and i am willing to share it with anyone who wants it. It has no support and i am not sure if it will work with anything higher than virtuemart 1.1.3
email me at john@johnchristensenwebdesign.com
December 9th, 2010 at 8:49 pm
Wow, This is a good thread. I’m so glad I’m not alone. Just setting up my GoDaddy Quick Shopping Cart and hit a brick wall with the sales tax options. Called DOR….same responses as earlier posted, called GoDaddy “We can’t speak directly with our developers”…wha?
I’m not sure what to do. I have at least $600 invested in my cart and SSL cert…and I haven’t even begun to populate the cart (another $1200-1600 worth of my time.
As a small business attempting to get bigger with an online retail presence (and create more tax revenue!) this is a huge stumbling block.
I sent an email to snocap, we’ll see. I don’t think they are compatible with GoDaddy.
As a possible ($$$$) workaround; Amazon.com has an online store that you can subscribe to. Them being from Seattle, they HAVE to have all of the zip stuff figured out. Not sure if its available to their cart customers though….
The big downfall is their “Referral Fee”…JEEZUS! They want to charge a 12% fee per transaction + a monthly 39.99!!
Good luck to all.