Stuart Wright
Well-known member
This has nothing to do with the software we're using. We're actually using Sage which is comparable with Xero.You are apparently the only VAT-registered organisation that has your exact setup. I've used multiple accounting software in the decade and a half I've been VAT registered, and none of them have had the problems your software has.
I would strongly recommend getting better accounting software that doesn't rely solely on one payment processor. I can personally recommend Xero, alongside this addon by Xon: https://atelieraphelion.com/products/xero-invoice-sync.76/ which automatically pushes itemised invoices into Xero.
This is to do with Paypal not getting VAT information sent through from eCommerce.
To illustrate, here is the order from eCommerce
And here is the transaction in Paypal.
As you can see, the VAT is not sent through to Paypal.
If the tax is not being passed to Paypal, then the integration is incorrect. If you're using the standard Xenforo Paypal integration then @Kier @Chris D please investigate.Not only is it wrong to say the integration is incorrect, but as I pointed out earlier (and provided instructions for), you can add a notice during checkout that says applicable taxes will be added during payment. This is consistent with most online businesses where VAT rate depends on the buyer’s country.
Displaying a notice to the user is irrelevant. It's the Paypal invoice which needs to be correct. Once it is, then when Sage (or Xero or any other similar accounting software) connects to Paypal to reconcile the accounts, it will get the tax correct. It can't as it currently stands.
Really? I'm not convince that's the case, but even it is, that would be better than having an error as significant as this.Lastly, setting the tax rate being passed to PayPal will occasionally introduce rounding errors that prevent payments from being correctly flagged as paid.
You're sounding a bit defensive and I'm sorry if this is coming across as attacking you as I'm not. I'm trying to help you get your already excellent addon improved so that it's correctly interfacing with PayPal and I don't have to run this query to get the information we need directly from the ecommerce tables for our finance department each month.
Code:
SELECT FROM_UNIXTIME(completed_date, '%Y %M %D'), taxable_order_total,sales_tax,cost_amount,currency,business_title,address1,address2,address3,address4,country_code,sales_tax_id
FROM xf_dbtech_ecommerce_order LEFT JOIN xf_dbtech_ecommerce_address ON xf_dbtech_ecommerce_order.address_id = xf_dbtech_ecommerce_address.address_id
WHERE order_state = 'completed'
and sales_tax > 0
ORDER BY order_id desc
Last edited: