Managing Duties and taxes

SOLVED

Hello everyone,

In my business I often have to import products that I am reselling to my customers. The shipping companies I use, such as FedEx, take care of clearing the goods through customs for which they then send me an invoice that looks like the following

GST Canada                            $344.28

Advanced  clearing                 $   10.00

GST for accessories/ANT     $     0.50

QST for accessories/ANT     $     1.00

TOTAL                                       $355.78

Standard invoices are easy enough to manage. but invoices such as the above have got me lost. Reason why is the 1st line is evidently the GST tax, which I pay on imported shipments and am allowed to claim back every quarter.

I have created FedEx as a vendor and I track duty on imported items, which is recorded in account 2115 Import Duty Clearing BUT, anyone know of a way to record invoices like the above mentioned and have the amounts recorded, so they appear in the report when comes time to remit sales taxes?

I'd hate to think Sage 50 (premium edition) can't do this and these type of transactions need to be done manually.

Please advise.

Thanks in advance to all who reply.

Cheers,

Marc

Parents
  • 0

    ok - so I finally figured out how to paste screen shot. The secondary box is the Journal Entry display to show how the GST is calculated. In this case we use the GST Paid on Purchases account nbr and not the GST adjustment account nbr. Also since I am not claiming the PST back it is showing as an expense. But since you are claiming the QST back then you should just enter Gst only tax code and then another line for the QST amount against the QST account nbr.

    Hope this explains it? Let me know.

  • 0 in reply to Smith and Co

    It does yes and the after trying theway I described it also works. Just need to put it in the right account (2315 GST/HST paid on purchase instead of 2325 GST/HST adjustments.

    Thanks for all the help. Greatly appreciated.

    Cheers,

    Marc

  • 0 in reply to MarcDu

    You can also enter the lines as the customs & brokerage fees for 10.00; enter the appropriate tax code to charge GST and QST, then modify the tax amounts by clicking on the magnifying glass beside the tax amount.

  • 0 in reply to AmyGurl

    AmyGurl,

    While that is technically correct and it works just fine, I like process and never teach people to do the same thing two different ways.  If people get used to doing it that way in Purchases, then they do it the same way when necessary in Sales.  Then the invoice indicates a difference when printing so the customer getting the invoice must now add the sales tax line with the Adjustment to the sales tax line to get the final total.  The invoice looks weird but can be presented correctly if the sales tax is adjusted on a line item itself instead.

  • 0 in reply to MarcDu

    Hi there,

    I read all the postings above and they are really helpful. I still have a question here, sorry if its a silly one.

    Our company (at Ontario) has Willson international as the broker, and the GST $99.66 is listed on the Willson intl invoice, but my boss wrote a check paying GST$99.66 directly to the CRA.

    Any advice on how to do this payment entry?

    Thanks for help!

Reply
  • 0 in reply to MarcDu

    Hi there,

    I read all the postings above and they are really helpful. I still have a question here, sorry if its a silly one.

    Our company (at Ontario) has Willson international as the broker, and the GST $99.66 is listed on the Willson intl invoice, but my boss wrote a check paying GST$99.66 directly to the CRA.

    Any advice on how to do this payment entry?

    Thanks for help!

Children
No Data