Export T5018 information

Create a T5018 export file that is preformatted to meet the Canada Revenue Agency (CRA) requirements. You can then file your report by uploading the file to the CRA.

The Export T5018 form option is different from the export option available on the report page. The report export option formats the report for viewing outside of Sage Intacct. Export T5018 form formats the data to meet CRA specifications for filing by electronic upload.

Before you begin

Run the T5018 from the Reports section of the Accounts Payable menu. Verify supplier amounts and make any adjustments necessary.

Generate the export file

  1. Go to Accounts PayableAllT5018Export T5018 form.
  2. Select a Start date and End date, or a Calendar ending date.
  3. For Filters, select a range of suppliers, or Select all suppliers to include all eligible suppliers with T5018 enabled.

    The file includes a supplier when both of these criteria are met:

    • T5018 is enabled in their supplier information record.
    • You made payments to the supplier during the selected date range.
  4. Select the Entity or entity group.

    If you are exporting the file at the entity level, your selection is limited to the current entity.

  5. Enter the Minimum amount of payments that is required for a supplier to receive a T5018.

    This value is pre-populated with 500, the current year's minimum amount.

  6. Enter the Filer identification number.

  7. Select Export and then select XML as the format.
  8. When the export is ready, select Download the file.

    Use the downloaded file to file your report online with the CRA through Internet File Transfer.

Next step: File with the Canada Revenue Agency using Internet File Transfer.