Logo

Lodgeit

Sign in Sign up
Home Solutions
New support ticket
Check ticket status
  • What's New
  • User Guide
  • Practice Settings
  • Billing and Payments
  • Individual Tax Return
  • Company Tax Return
  • Trust Tax Return
  • Partnership Tax Return
  • Superannuation Fund Tax Return (SMSFAR)
  • Other Forms
    • Activity Statement (BAS)
      • Preparation of Activity Statement (BAS)
      • Manage Activity Statement (BAS)
      • Card Payments for Activity Statements
      • BAS / Activity Statement Forms and Description
      • Pull new Activity Statement (AS)
      • Collecting and Filling Activity Statements (AS) from the ATO Systems
      • 'QuickBooks Online' BAS Import
      • Switch-Off Auto Produce Activity Statement (AS)
      • Activity Statement (AS) preloaded from ATO
      • How to Amend an Activity Statement (AS)
      • Bulk Import of Activity Statement / Installment Activity Statement (AS/IAS)
      • Collecting Activity Statement (AS) - not showing in Lodgeit
      • Importing Activity Statements (AS) lodged indirectly
      • Cash Flow Boost - Activity Statement (AS)
      • NIL BAS
      • "Lodged" BAS
      • Branch Code
      • How to show BPAY Details in BAS Form?
      • Access to Activity Statements Not Available
      • BAS "Instalment Amount" T7 (PAYGI)
      • BAS - Line G11
      • Xero BAS Import
      • Error: "QuickBooks BAS reporting period is different to this BAS. Please make sure BAS periods are equal and try again"
      • BAS Status: "Lodged-Processed"
      • Error: "GST on purchases cannot be negative"
      • Import BAS Values from QuickBooks
      • QuickBooks BAS Output different to Lodgeit BAS Value
      • Disable Manage Activity Statement (AS) - each client and mass update
      • BAS missing tabs / CMN.ATO.AS.EM141
      • "No unlodged activity statements were found"
      • How to update the BAS Entity Details?
      • ERROR: "The form cannot be marked as lodged. Remove the form instead and pull lodged activity statements."
      • QuickBooks BAS report cannot be imported
      • Missing BAS / Activity Statement
      • Bank Details for Company BAS Refunds
      • CMN.ATO.AS.EM059
      • Rollover for "Does the amount shown at G1 include GST?" (QuickBooks import)
      • BAS - 8B
      • Activity Statement: Varying PAYGI
      • Multiple GST Branch Code for Activity Statements
      • Activity Statement Not Displaying After Pull Attempt
      • What does "Activity Statement not revisable" mean in the activity statement?
      • CMN.ATO.AS.EM98065
      • Duplicate Activity Statement Forms in Dashboard
      • Change the "GST Option"
      • CMN.ATO.AS.EM59099
      • CMN.ATO.AS.EM98060
    • FBT Tax Return Form (Fringe Benefit Tax)
      • Preparation of Fringe Benefit Tax Return Form (FBT)
      • FBT Worksheet and Calculation
      • Amount of Rebate (Label 18) - FBT
      • The sum of Type 1 and Type 2 aggregate amounts must equal the total taxable benefits
      • NIL Fringe Benefits Tax Returns
    • PAYG Payment Summary Tax Return
      • Preparation of PAYG Payment summary (PS)
      • How to Import Empdupe to Payment Summary Form (PS)
    • TPAR Tax Return Form (Taxable Payments Annual Report)
      • Preparation of Taxable Payments Annual Report Form (TPAR)
      • How to Import Excel Template to Taxable Payments Annual Report (TPAR)
      • OLD Taxable Payments Annual Report Preparation (TPAR)
      • How to Lodge NIL TPAR?
      • How to import TPAR from QuickBooks?
      • TPAR Amendment
      • How to Update the Payment Date in an Amended TPAR
      • TPAR: Report is disabled or you don't have permissions to access the report
    • CGNFT ( Consolidated Groups Notification of Formation and Member Entrance-Exit )
      • Preparation of Consolidated Groups Notification of Formation and Member Entrance/Exit Form (CGNFT)
    • FTER ( Family Trust Election
      • Preparation of Family Trust Election, Revocation or Variation Form (FTER)
    • IEE ( Interposed Entity Election and or Revocation )
      • Preparation of Interposed entity election and or revocation form (IEE)
      • CMN.ATO.IEE.410235
      • Revocation of IEE (Interposed Entity Election)
    • RNN Tax Return Form ( Return Further Returns Not Necessary)
      • Preparation of Non Lodgement Advice (NLA)
    • Not for Profit
      • Chart of Account for Not for Profit Organisation (NFP)
      • "Not-For-Profit" Tax Form
    • AMIT Attribution Managed Investment Trust Tax Return (TRTAMI)
      • Preparation of AMIT Attribution Managed Investment Trust Tax Return (TRTAMI)
  • Financial Report
  • Integrations
  • Importing Financials
  • General Accounting & Tax Knowledge
  • Lodgeit Tools and Storage
  • Resources
  • Lodgeit Labs
Solution home Other Forms TPAR Tax Return Form (Taxable Payments Annual Report)

How to Import Excel Template to Taxable Payments Annual Report (TPAR)

Modified on: Tue, 29 Sep, 2026 at 12:15 PM

User can copy paste data from source excel to Lodgeit template (see attached Template).

Once done, You can now Import the spreadhseet to TPAR Form -

Go to "Forms", press "Add Form" and Select "TPAR"

Top right side of the form, press the 3 little dots and select "Import"

Choose a "source"



Related article:

How to import TPAR from QuickBooks?

OLD TPAR Preparation 

Preparation of TPAR Form

Attachments


xlsx
TPAR Templat...
(16.4 KB)
xlsx
TPAR Example...
(15.1 KB)

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
Home Solutions Sign in Sign up
Article views count