Zen Cart, GST, PayPal and Xero issue
G'day,
I've just realised that there is a major problem with the way Zen Cart, Paypal and Xero work together in our Australian business.
We use Zen Cart for online sales. 10% GST is included on orders for local delivery. GST isn't included on orders being shipped overseas.
We use PayPal to accept the payments.
We regularly transfer the money sitting in PayPal into our bank account.
In Xero (the online accounting software) we get a data feed from the bank. So the payment from PayPal comes through and is treated as our online sales, inc GST.
Within Xero we have no way of knowing what part of that online sales amount was ex GST. Thus our handling of GST is wrong on all orders delivered overseas. We're reporting that we've collected more GST that we actually have been paid. So we're out of pocket by 10% on all overseas shipments.
How do you resolve this issue? What's the fix, other than turning off overseas shipping?
Best regards, Lloyd Borrett.
Zen Cart 1.5.5e, PHP 5.3.29 MySQL 5.5.42
Bookmarks