Exporting TPAR Data from TWFreight

Reporting Requirements can be found here

Prerequsites

Make sure to be updated with the most recent Reports  (Version 4.05 2022_0726) 

Make sure to be updated with the most recent Admin    (Version 4.05 2022_0726)

Admin > Branch must be updated to reflect required address fields to be populated. We have introduce specific fields to ensure everything can be populated correctly. This will become the Reporting Branch (Ie Head Office)

Company Name,

Address,

City(TPAR),

State(TPAR),

Post Code (TPAR)

Navigate to Reports  > Accounts > TPAR Reporting

Company Branch

You will be able to choose Branch = ALL for the data to ATO.

The Reporting Branch will be the branch running the report (Head Office), the address information input to Admin module is used to populate the Sender’s records.

The submission is by TPAR FY (for example reporting due in Aug 2022 relates to year reporting for the period 1/7/21 – 30/6/22).

Creditor Statement checkbox

Each category should be run separately to denote if a creditor issues a statement or not. A creditor that issues statement will need to use Cat 3 to group them.

For example, Cat 3 = S to mark the creditors that issue statements.

They will then have to run TPAR ATO files twice:

1^st run – Category 3 Start = S, End = S, do not check Exclude Selected Cat 3, check Creditor Statement:

2^nd run - Category 3 Start = S, End = S, check Exclude Selected Cat 3, un-check Creditor Statement:

Re-Submission checkbox 

• To check if previous successful submission of the same data criteria to ATO had been done; 
• Uncheck for 1^st submission of the year

Test checkbox 

• Check for Test submission – can be used to ‘validate’ data by submitting Test file to ATO
• Uncheck for actual submission
  (this will show a dialog box to confirm test submission)

Click on [Generate ATO File] to process, it will take a while as it is running the whole year’s worth of creditor invoices/payments records.

As it runs, any “data error” will be displayed in ATO Filing Errors window.

At the end of the run, user will be prompted to save the file. 

File will still be generated even when there is data error, which will fail ATO validation if user still chooses to submit it to ATO.

So user should correct the data according to details in ATO Filing Errors and re-run the ATO file generation.

To complete the process user must then login to ATO website to check and submit final filing.