Export TPAR information

Create a Taxable Payments Annual Report (TPAR) export file that's preformatted to meet Australian Taxation Office (ATO) requirements. You can then lodge your report by uploading the file to the ATO.

The Export TPAR file 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 TPAR file formats the data to meet ATO specifications for lodging by electronic upload.

Before you begin

Run the TPAR 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 PayableAllTPARExport TPAR file.
  2. Enter a Start date of 1 July of the previous year.
  3. Enter an End date of 30 June of this year.

    The ATO requires a date range of 1 July through 30 June.

  4. For Filters, select a range of suppliers, or Select all suppliers to include all eligible suppliers with TPAR enabled.

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

    • TPAR is enabled in their supplier information record.
    • You made payments to the supplier during the selected date range.
  5. Select the Entity or entity group for which you want to run the report.

    If you are running the report at the entity level, your selection is limited to the current entity.

  6. For Format, select whether you want to sort by Supplier ID or Supplier name.
  7. Select Export and then select Text as the format.
  8. When the export is ready, select Download the file.

Next step: Use the downloaded file to lodge your report online with the ATO.

Validate the export file

If you want to validate your TPAR export file with the ATO before you lodge it, you need to edit the export file to signify that it is a test file.

Validation is an optional step where the ATO checks your file for format compatibility and data quality. If you upload the export file for validation without editing it first, the file will be lodged automatically, instead of being tested.
  1. Open the TPAR export file using a text editor.
  2. In the first line of the file, find the P that follows the Sender Australian Business Number (ABN) and change it to a T.

    This character indicates the Run type for the file:

    • P: Production file.
    • T: Test file.

    First line of TPAR export file with P value called out, immediately following the ABN.

  3. Save the file.
  4. Upload the edited file for validation using the ATO's instructions.
  5. Follow ATO guidance to correct any issues identified with the TPAR export.

Next step: If you plan to lodge the report without regenerating the TPAR export file, edit the first line to change the Run type back to P.