Taxable Payment Annual Report - Import from an Excel File
Download Taxable Payment Annual Report Template
The excel file must match the following column contents:
- Type: it must be one of the following:
- Individual choose this option when the supplier is a sole trader
- Non-Individual choose this option when the supplier is a company or corporation
- Non-Individual Supplier Name: enter the business name, applies to non-individual suppliers
- Non-Individual Trading Name: enter the trading name if available, applies to non-individual suppliers (optional)
- Individual First Name: enter the supplier's first name, applies to individual suppliers
- Individual Given Name(s): enter the supplier's given name if available, applies to individual suppliers (optional)
- ABN: enter the supplier's ABN if known
- Address Line 1: enter the supplier's address line 1
- Address Line 2: enter the supplier's address line 2 - optional
- Suburb: enter the supplier's suburb
- State: enter the supplier's state
- Postcode: enter the supplier's postcode
- Country: enter the suppliers country name, leave blank if the address is in Australia
- Contact Number: enter the supplier's phone or mobile number - optional
- Gross Amount: enter the YTD gross amount
- GST Amount: enter the GST amount, leave zero if no GST is collected
- Tax Withheld: enter the tax withheld amount for supplier's whom did not quote an ABN
- BSB Number: enter the supplier's bank BSB number
- Account Number: enter the supplier's bank account number
For suppliers with no ABN "did not quote an ABN", you must hold the appropriate tax rate from the gross amount, add the tax withheld amount to the tax field.
You should make sure to collect the supplier's address details, even though you are able to lodge supplier's details without having to enter the required address fields.
Importing Taxable Payment
Follow the next steps to import:
- Click Taxable Payment on the application toolbar
- Click New
- The Taxable Payment Annual Report window appears, click the Excel Icon
- The File Import window appears, click Browse
- Click Browse
- Select the excel file which contains all the information that you would like to import
- Click Import
- You should a list of all suppliers found in the excel file
Make sure to download the excel template and read the import guidline on top of the page.
Make sure to check the imported data to ensure that the correct information was imported.