T5018

Good Morning!!!

Our company deals with a lot of subcontratctors, and and the end of the year, we have to send the T5018 summary to the CRA and the respective one for each subcontractor.
Is there any way in the software to fill out those forms?
Thank you

You need to turn on 1099 processing (the USA equivalent) and then print the forms using the supplied specification.

Thank You Mr.Bates!!!

Hello again!!!

It's semms like the number I obtained in the T5018 do not match with the real total.
Could some body tell me what are the specifications in order to find the total payments for each vendor and see them reflected in the form?

Thank you

The 1099 amount is the amount that has been paid to a vendor in the calendar year - not the amount that the vendor has invoiced. If the amount is not the figure you expect, then you can just edit the amount in the vendor file.

Hi Andrew:

I am trying to put together a T5018 report for the year ending Dec 31, 2010. I am having trouble understanding why the figure for each and every particular supplier shows as 0 when I preview the report. I also do not understand how we can edit the amount reported in the vendor file if we need to change the figures.

Hi,

Do you have the 'Process 1099s?' option enabled in the Company Profile, System/Report Options tab? And, the '1099 Year end' option enabled as well?

Additionally, you need to have the 'Process 1099' option enabled in the vendor record of each vendor you want to gather this information for.

Enabling the above options is necessary to tell the system to start gathering the information.

There is another option in the Company Profile, 'Allow edit of vendor statistics', that when it's turned on/enabled, will allow you to edit the amount reported in the vendor file on the Statistics-YTD tab if you need to change the figures. Normally, this option would be disabled but you can enable it if necessary.

Hello again:

I have enabled all the items. The tab for 1099 year end does not have a tick box - just the calendar to note the date required.

When I set up the maintenance specs I moved items around for T5018 reporting format. The field for V13 vendor YTD actually shows a sample figure of over $5 million and when I preview the 1099 report all vendor show $0. What am I doing wrong?

Thanks

Hi,

Look on that vendor's Accounting tab and reconfirm that the 'Process 1099?' option is turned on. Next, check the vendor's Statistics - YTD tab and ensure there is a value in the 'YTD 1099 Payments' field. This is the value that prints using spec code V13.

Hello again:

Have confirmed that the vendor's Process 1099 option has been turned on. However, there is no value in any of the YTD 1099 vendor payments' field with that option turned on. I notice that the section in the Vendor's stat - YTD tab for invoices paid shows as 0. We switched to Adagio at the end of Oct 2010 so all history for the 2010 year was taken from our old program (simply accounting). I have done a print out from simply accounting for the 10 months of 2010 so that I would have an idea of the figures to work with. Any more suggestions for me? Thanks

Only when Payments are posted in Adagio Payables is the 'YTD 1099' amount field updated. Posted Invoices have no relevance to this 1099 statistic. And only after the option is enabled - it will not automatically be populated with the YTD Payments amount when you first turn it on.

Generally speaking, the YTD 1099 amount should equal the YTD Payments statistic.

If the amount in the YTD 1099 field for the vendor is 0 or some other value you do not believe to be correct, you can edit it, with the instructions provided previously. Should this be necessary to edit for a lot of vendors, these values can be imported using the Import Vendors process.

Hi,

If you know the figures that should be in the vendors' YTD 1099 fields, you could enable the Company Profile option to edit statistics and then enter the amounts in the vendor records. This value can also be imported.

If you decide to import, you should make sure you have a current backup of your data before doing the import. If you are not familiar with importing in Adagio, you should contact your Adagio consultant to assist you or set up and perform the import for you.