I filed my T5018 for my fiscal year end. My year is from April 1 2018 to March 31 2019. Somehow the XML file does not match the report from the Supplier.

SUGGESTED

My accountant phoned me to tell me that I had filed the T5018 report 2x for 2018. But I did not. When I am in the Import Export file in the file menu, the box that says Fiscal year/ Calendar Year and there is also a tick box for 2019 or 2018. If I tick the 2019 box and the Fiscal year end, the amounts in each Subcontractors line are wrong. However, if I go through Reports/ Suppliers/ T5018 Prior year/ Fiscal year, then the amounts are correct.  I phoned CRA and they told me that the date on the file I submitted to them is December 2018.  This does not work. What do I do? The printed forms are ok and have the right amounts of payment per Subcontractors. And it says the right year end date of March 31 2019.

However I can't get the right amount of payment on the XML file if I tick 2019 fiscal year.

I think there is a glitch with the program. I have been on hold for a level 2 support for 1 hour and a half!

HELP

  • 0

    Hi MDeschenes:

    If I remember correctly CRA only uses the calendar year for the T5018's not your company's fiscal year. That may be your dilemma!

    Hope this helps!

  • 0 in reply to Agate

    I have to disagree with Agate.  T5018's can be filed based on either calendar or fiscal year.  I have no insight into what is happening with MDeschene's T5018's.

  • 0 in reply to C White
    SUGGESTED

    I apologize, I was mistaken. T5018's can be filed either on a fiscal year basis or a calendar year basis. However, CRA doesn't like it when you switch up from fiscal to calendar year or vice versa from one year to the next. As per your issue with Sage 50 the only thing that comes to mind is the GST/HST taxes which are included in the T5018 but not included in your expense line for subcontractors because the GST/HST is entered as an input tax credit.

    Hope this helps!

  • 0 in reply to Agate

    No I added all the totals, the correct totals is the ones showing if I select Fiscal year 2018 even though it's for my year end 2019. It is a Sage glitch. However I also made a mistake, because while I was trying to find a work around and make sure the totals were correct, I ticked Calendar year 2018. That's why my filing with CRA was flagged as incorrect by my accountant. So in fact to efile the correct amounts for my year end of March 31 2019, I had to tick Fiscal year end 2018. It's all fixed with CRA now, but it was a huge demand of my time, hours of waiting on hold while agents tried to understand what was going on,

    Please Sage fix this bug.