Troubleshoot the Taxable payments annual report (TPAR)
The following topic explains common problems that you might encounter and their solutions.
After you enable TPAR in Configure Accounts Payable, assign Taxable payments annual report: Run permissions to the user who will run the report.
A user with permissions can run the report from Accounts Payable > All > Reports > Taxable payments annual report (TPAR).
If you are not seeing data that you expect to see in the report, verify the following:
- Suppliers that you want to include in the report are enabled for TPAR.
- Payments made to these suppliers were completed within the report time period.
- You have the Australia GST tax solution set up for the entity where you want to run the report.
If your TPAR includes a supplier with an overseas address, the ATO requires specific default values. These values only apply to ATO reporting, so you need to edit this information in the TPAR when you lodge the report.
Solution: If you are using the option to Export TPAR information, make a list of the suppliers with addresses outside of Australia. Then, edit the Payee information for these suppliers in the export file, as follows:
- Change Payee state/territory to OTH
- Change Payee Postcode to 9999
If you are filing manually, make these changes when you file.
For suppliers who are not required to have an ABN, the ATO requires that you report a default tax ID consisting of all zeros.
Solution: In the supplier information record, enter a Tax ID of 00000000000 (11 zeros).
To remove a supplier, turn off TPAR in the supplier information record.
- Go to Accounts Payable > All > Suppliers.
- Find the supplier that you do not want to include in the TPAR.
- Select Edit at the end of the row.
- On the Additional information tab, deselect Enable TPAR.
- Select Save.
- Go to Accounts Payable > All > Suppliers.
- Select Edit next to the supplier that you do not want to include in the TPAR.
- On the Additional information tab, deselect Enable TPAR.
- Select Save.
The supplier will no longer be included when you generate the report.
To meet the reporting requirements of the Australian Tax Office, the following values are adjusted:
- Gross amounts between 0 and 1 are rounded up to 1.
- Decimal values are truncated.
This value represents total amount that you paid to the payee in the reporting period, excluding GST.
The following amounts are included in the Gross amount paid:
- Payments made against AP purchase invoices during the reporting period, not including any credits applied
- Advances paid to the supplier to the supplier during the reporting period, regardless of when they were applied
The following amounts are not included the Gross amount paid:
- AP purchase invoice payments that were voided during the reporting period
- Advances that were voided during the reporting period
- Credits applied to AP purchase invoice payments
- Total tax withheld, as entered in the information record
Voided payments are subtracted from the Gross amount paid only when the amount is voided within the reporting period.
Say you make a payment to a supplier in June, at the end of the 2023 fiscal year. Then, in August, you void the payment you made.
When you run the TPAR for FY23, you'll see that the Gross amount paid still includes the payment in the total for that supplier. That's because this value reflects the total amount paid during the date range that you selected. When you run the TPAR for FY24, the voided payment is subtracted from the FY24 Gross amount paid.
Because credits do not represent funds that you paid to the vendor at the time of the transaction, they are not factored into the Gross amount paid.
Advance payments that you make during the reporting period are included in the Gross amount paid, whether or not they are applied.
Gross amount paid includes all payments that you made to the supplier during the reporting period. This includes advance payments.
Let's say you pay an advance payment to a supplier in June, at the end of the 2023 fiscal year. Then, you apply that advance to a payment in August, at the beginning of the 2024 fiscal year.
When you run the TPAR for FY23, you'll see that the advance payment is included in the Gross amount paid to the supplier. When you run the TPAR for FY24, the advance amount is not included in the Gross amount paid, because no cash was involved in the application of the credit.
The Export option that is available after you run the report in Accounts Payable > Reports >Taxable Payments Annual Report is a direct export of what you see in the report view. If you want to review the report output in Excel, use this export option.
Accounts Payable > TPAR > Export TPAR file generates an export file that is formatted to meet the lodging guidelines set forth by the Australian Tax Office (ATO). For example, some field values might be truncated to meet these guidelines. If you plan to upload your report directly to the ATO, use this export file.
When generating your export file, Sage Intacct checks all fields to make sure they meet the Australian Tax Office (ATO) upload requirements. If the name of your download file begins with ErrorReport file, this means that Intacct identified problems that would prevent the ATO from accepting your TPAR upload.
To resolve these problems, open the error report and review the list of issues at the end of the file. Refer to the list of field IDs to determine where you need to make corrections. After resolving all issues, export the TPAR file again.
Say you receive an error report file when you try to export the TPAR file and it shows the following at the end of the report:
Please fix the issues listed below and retry.
SENDERCONTACTNAME field value is missing for Entity : Eco Habitats (AU)
PAYEECITY field value is missing for Supplier : ABC Construction
STATEMENTBYSUPPLIER field value is missing for Supplier : Webster Drywall
In this example, you need to do the following:
-
Update the entity record for Eco Habitats to add a Legal contact name in the Legal contact section.
-
Edit the ABC Construction supplier record to add a City value to the primary contact.
-
Edit the Webster Drywall supplier record to add an entry to the TPAR tab, to specify that you did not receive a Statement by a supplier.
-
Export the TPAR file again.
| Error field ID | Sage Intacct field name | Field location | Corresponding report column |
|---|---|---|---|
|
SENDERCONTACTADDRESS1 |
Legal address line 1 |
Entity record > Legal contact section |
Payer address line 1 |
|
SENDERCONTACTCITY |
Legal city |
Entity record > Legal contact section |
Payer suburb, town or locality |
|
SENDERCONTACTSTATE |
Legal state or territory |
Entity record > Legal contact section |
Payer state or territory |
|
SENDERCONTACTZIPCODE |
Legal ZIP or postal code |
Entity record > Legal contact section |
Payer postcode |
|
SENDERCONTACTCOUNTRY |
Country |
Entity record > Legal contact section |
Payer country |
|
SENDERCONTACTNAME |
Legal contact name |
Entity record > Legal contact section |
Payer contact name |
|
SENDERCONTACTTELNO |
Legal contact phone |
Entity record > Legal contact section |
Payer contact telephone number |
|
PAYEEAUSBUSINESSNO |
Tax ID |
Supplier record > Supplier tab > Tax ID information section |
Payee Australian business number |
|
PAYEEADDRESS1 |
Address line 1 |
Supplier record > Supplier tab > Primary contact section |
Payee address line 1 |
|
PAYEEADDRESS2 |
Address line 2 |
Supplier record > Supplier tab > Primary contact section |
Payee address line 2 |
|
PAYEECITY |
City |
Supplier record > Supplier tab > Primary contact section |
Payee suburb, town or locality |
|
PAYEESTATE |
State |
Supplier record > Supplier tab > Primary contact section |
Payee state or territory |
|
PAYEEZIPCODE |
ZIP or postal code |
Supplier record > Supplier tab > Primary contact section |
Payee postcode |
|
PAYEECOUNTRY |
Country |
Supplier record > Supplier tab > Tax ID information section |
Payee country |
|
TOTALTAXWITHHELD |
TPAR entry for Total tax withheld, for the selected entity |
Supplier record > TPAR tab |
Total tax withheld |
|
TOTALGST |
Calculated from GST payments made on supplier transactions |
Calculated |
Total GST |
|
STATEMENTBYSUPPLIER |
Statement by supplier entry |
Supplier record, TPAR tab |
Statement by a Supplier (=Y,N) |