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

    I have the same situation as Marc does. However, if I enter Gst charged on imported goods without a tax code, the tax report won't show those GST amount. Therefore, the gst paid on purchase amount is greater than the tax report amount. Is this normal like this?

    For example, the gst paid on imported goods is $100, I have the Gst paid on purchase account $100,but tax report will show $0 Gst paid on purchase.

    Thank you for your help.

  • 0 in reply to MTLFALL

    Hello MTLFALL,

    It shows on my report. I do the following steps:

    - Reports /Financials/Transactions by accounts

    - Enter the dates for the period covered and select

    1. GST/HST charged on sales (Acct# 2310)

    2. GST/HST paid on purchase (Acct# 2315)

    3. QST Charged on sales (Acct# 2340)

    4. QST Paid on purchase (Acct# 2345)

    - Hit OK

    Last amount reported in the balance column indicates what you paid and charged in each category. Substract what you paid from what you charged and voilà.

    When recording GST paid on imported goods, I put Acct# 2315 and no tax code. For advanced clearance fees, I use acct# 5180, put in the amount and GQ (GST and QST) in the tax column.

    Hope this helps.

    Cheers,

    Marc

  • 0 in reply to MarcDu

    Personally I never use the Tax report because if you fail to use a tax code at any time, it doesn't show and if you post something in a previous period, it will not show either.

    This is how I have always done the entry.  On the second line use Ctrl-Y to add the tax amount of $100.  The tax report detail section is below if you really need to use it.  Use an appropriate description for what you want to see in the future to explain the tax.

     

Reply
  • 0 in reply to MarcDu

    Personally I never use the Tax report because if you fail to use a tax code at any time, it doesn't show and if you post something in a previous period, it will not show either.

    This is how I have always done the entry.  On the second line use Ctrl-Y to add the tax amount of $100.  The tax report detail section is below if you really need to use it.  Use an appropriate description for what you want to see in the future to explain the tax.

     

Children
No Data