I sell my product at TheBay.com. I have to remit the GST they collect on my behalf. When my statement comes, the GST amount does not always match the price x GST ($119+15.47 (ON GST 13%). It will sometimes be like: $119 + $12.38 ON GST, which isn't 13%. Here is the explanation:
"When a customer spends a certain dollar threshold they will get money off their total basket (E.g: $20 off $100, $50 off $200, or $100 off $350)
You do not need to make any pricing offer adjustments in Mirakl for this promotion as Hudson's Bay will be covering the cost of the discount to the customer ($20, $50, or $100). However, please note that you will be responsible to cover the difference in tax from the purchase.
For example:
Your item - $150
Another item - $50
Sale is $200 so customer gets a $50 discount
Your item - $125 (ON tax - $16.25)
Another item - $25 (ON tax - $3.25)
TOTAL CUSTOMER PAYS - $150 + $19.50 tax
I do not see the discount or promo they got. So I am left with a statements that shows the total of my sales and a GST that doesn't match. What I get is something like "$119 /$12.38 GST" . Multiply this by several transactions and different provinces tax rate and you have a full on puzzle to detangle! -Way too much time!!!
I'm trying to do a journal entry with (for example):
Sales: $119
GST Payable: $12.38
Undeposited account: $131.38
but when I do so, the GST does not show in my tax return. It shows that I did not collect tax.
If I do a normal entry, no tax rates fits the GST amount, and I can't find a way to change it.
The same happens when I receive my statement with sales from different provinces and all I get is an amount and a GST amount that is a mixture of 13% and 15% depending on the provinces where the product was shipped. (I can't sort the sales by provinces).
I have spent hours on this and the support team was no help at all! They want me to enter the hundreds of sales individually with their own tax rate... that is absurd!
How can I make a sale entry with a different tax amount??
Anyone?
