Taxable Payments Annual Report (TPAR) CSV file template

GovReports accepts TPAR in CSV file format.  Following is the template to be used for uploading:

TPAR_Template.csv

Mandatory fields:

  • Payee details Either (Title, FamilyName and GivenName) or (ABN, OrganisationalNameType and OrganisationalName) are mandatory
  • BusinessPaymentGrossAmount field is mandatory

Conditional Mandatory fields:

  • When Business name is entered OrganisationNameType is mandatory
  • When Phone number is entered Area code is mandatory
  • When Address is entered, address type is mandatory.
S.No. Item Data Type Max Length Sample Description
  1 ABN string 11 41000003001 Contractor’s Australian Business Number
  2 Title string 13 Mr Contractor’s Title
  3 FamilyName string 30 John Contractor’s Surname or Family Name
  4 GivenName string 15 Smith Contractor’s First Name
  5 OtherGivenName string 15 Peter Contractor’s Other Given Name
  6 OrganisationalNameType string 3 MN Organisation Type of the contractor (Main Trading Name or Main Name)
  7 OrganisationalName string 200 Cellino Private Limited Business Name of the Contractor as shown in the invoice
  8 AddressType string 8 BUS Address Type of the Contractor ( Business or Postal)
  9 Line1 string 38 11 Rosen Street Contractor’s Address Line 1
  10 Line2 string 38 Contractor’s Address Line 2
  11 LocalityName string 27 EPPING Contractor’s suburb, town or locality
  12 Postcode int 4 2121 Contractor’s postcode
  13 StateOrTerritory string 3 NSW Contractor’s state or territory
  14 CountryCode string 20 Australia Contractor’s Country Name
  15 TelephoneAreaCode string 2 2 Telephone Area Code of the contractor
  16 TelephoneNumber string 15 85246368 Mobile phone number or other telephone number of the contractor
  17 BankStateBranchNumber int 6 625483 Contractor’s BSB Number
  18 FinancialInstitutionAccountNumber string 9 11175249 Contractorr’s financial institution account number
  19 BusinessPaymentGrossAmount string 11 5000 Total payments made to the contractor for the financial year
  20 IncomeTaxPayAsYouGoWithholding
TaxWithheldAmount
string 11 150 Total tax withheld
  21 GoodsAndServicesTaxLiabilityAmount  string 11 250 Total GST
  22 Amendment string 1 Y Amendment Indicator – Yes/No

Valid values for type fields:

Title

Code Description
Mr Mr
Miss Miss
Prof Professor
Dr Doctor
Ms Ms

OrganisationalNameType

Code Description
MN Main Name
MTR Main Trading Name

AddressType

Code Description
B or Bus or Business Business
P or Pos or Postal Postal

Note: If manually filling the CSV in an Excel, Please change format of the fields Areacode, Phone number & Postcode fields as text. Otherwise any leading zero will be stripped off by Excel.

Print Friendly

Posted in GovReports and tagged , , , .