Magento and LightSpeed - syncing zip code-specific tax rates
===

I'm looking for a solution to charging different tax rates based on ZIP code in Magento, then syncing these orders back into LightSpeed.

For our online store, we are required by law in New York State to charge tax based on the ZIP code we ship to. This requires a spreadsheet of roughly 2000 ZIP codes to be imported into Magento to create individual tax rates. 

The law also requires us to waive the New York State 4% tax for clothing under $110 for certain counties, including New York City. This required a second spreadsheet of the same ~2000 ZIP codes and alternate tax rates.

(It may be possible to reduce this number with ZIP code ranges, or wildcards, but I haven't been able to find a solution to dramatically reduce this, so we've been importing the full list as is).

The issue we're having occurs when we need to sync the Magento orders back into LightSpeed, and LightSpeed needs the corresponding tax and tax code in the [LS_Tax_Code]__[LS_Tax_Name]__ format. This requires entering the above 4000 tax rates into LightSpeed.

It feels this is becoming unnecessarily complex, and I have trouble believe this is the best way to handle it. I'd be really interested in hearing from anyone who has found a workable solution to this problem of syncing LightSpeed and Magento so taxes are being charged on a per-ZIP code basis, in New York or any other location that requires you to do so.

Thanks in advance,
Paul