Skip to main content
E
EveNB
January 5, 2023
Solved

Adjust HST in journal

  • January 5, 2023
  • 1 reply
  • 0 views

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?

 

 
Best answer by LeithG

Thanks, I wish it was that simple... I receive totals. So they could be 20 different items at different prices with different promos applied to them or not (I don't see that) and they could have been shipped and taxed to 4 different province rate....

Same as my other software that on the exportation file with my quarterly or monthly sales, tells me the sale and tax that was charged (that one I can itemize) but there's no commun on the spread sheet with the province it was sent to. So I have totals and taxes. I can't go through them one by one (no business would do that) and figure out which entries are not HST and which rate were they charged...

I really need a way to enter:

Sale

GST Payable -and have that amount commiting to my remittance report,

or to be able the change the get amount that the program comes with on an invoice...

There must be a way, I can't be the only small buisess that sells across the country 😭

 

Thank you SO much for trying to trouble shoot here, I really appreciate!


OK, how about this then -

Enter your total, and manually edit the tax amount on the invoice?

 

 

1 reply

LeithG
LeithG
January 5, 2023

Hi Eve

 

How do you get this information - is it an integration file that you upload, or are you just trying to do an entry for the total of the transactions for that day/period?

 

Leith

E
EveNBAuthor
January 6, 2023

I am trying to do an entry for the total of the transaction of the period. For TheBay, they send me a report, and I download the summary from my program for the other ones.

Thanks!

LeithG
LeithG
January 6, 2023

You should just be able to enter it as an invoice, no?

 

 

Terms & ConditionsAccessibility statement