Reconciling Taxes with State in Transaction Log

[dram777]

We're selling several intangible products and have implemented the feature that charges sales tax for the states required. The taxes are being charged correctly--that function works just fine. But we have a need to reconcile by state the total amount of taxes charged each month. Our transaction log doesn't provide a column for zip code or state. Is there a way to do this without having to require a ship-to address to be provided by the customer at check-out (not the most desirable option since we're not shipping anything)? We're not seeing anything in our PayPal transactions either, only the amount of tax charged--not the state.

[dram777]

The more I think about it, my only solution is going to be checking the Shipping/Buyer's Address box in the product configuration section. I was hoping that the required zip code field in the cart would get passed through to the transaction log somehow, but that appears to be unlikely.

[E-junkie_Guru]

While our cart does request the buyer to specify their country and ZIP/postal code when items in their cart have Sales Tax/VAT enabled, we can only use that to calculate a tax amount which gets passed to checkout for their order.



Unfortunately, PayPal provides no way for us to pass non-shipping-related location details to PayPal's checkout site, and they have no way to provide such details (aside from residence country, which we include in our Transaction Log downloads) when they send the order data back to us with their IPNs confirming completed payments.



If you're going to accept checkout payments by PayPal, the only way to get a record of the buyer's location would be, as you've deduced, to enable Shipping/Buyer's Address for every relevant product.

[dram777]

Thanks for the quick response and confirming what I thought I needed to do. Much appreciated.