Rental Income 2026

Simplify the preparation of your clients’ rental property schedules and tax calculations with our comprehensive Rental Income package, featuring seven practical Excel calculators designed specifically for accountants in public practice.

The package provides an efficient way to calculate and reconcile rental income and deductible expenses for the financial year ended 30 June 2026, including more complex calculations that can otherwise be time-consuming.

The calculators cover a range of rental property requirements, including:

  • Rental income and deductible expense calculations.

  • Adjustments for private use of rental properties.

  • Interest calculations for mixed-purpose loans.

  • Deductible borrowing expenses.

  • Foreign currency conversions.

  • Reconciliations involving multiple rental properties.

The package also includes a PAYG Withholding Variation Calculator for the year ending 30 June 2027, helping you prepare applications to vary withholding amounts for clients with rental property investments.

Seven Excel calculators in one convenient package, helping you save time, improve accuracy and maintain well-documented calculations for your clients.

Explore the individual calculators below to see how they can simplify your rental property work.

Warning: this file cannot be used with the cloud-based version of Excel, or Excel for Mac, or Google Sheets. 

To access all of our content
$1,465.00 P.A. for 5 users!
Monthly plans available

Description

Features

Rent Calculations (4)


Standard Calculator
Calculate rental income and expenses from agent’s monthly statements or from annual statements if more than one agent for the year.

Private Use
Apportion expenses for private use based on both floor area and period used. E.g. holiday homes, AirBnB, etc.

Foreign Rent
Convert foreign rental income and expenses to AUD using in-built monthly exchange rates.

Reconcile Rent
For clients with a large number of rental properties, reconcile totals at item 21 on return.

Mixed Purpose Loans (1)


Enter a summary of monthly transactions to determine interest and closing balances of each component of a single loan used for up to five separate purposes.

Reconcile closing balances with the loan statements.

Interest and regular repayments are apportioned on the basis of the component loan’s proportionate use of capital each month. 

Allocate any lump sum repayments from the sale of an asset against the balance of that component used to acquire the asset.

Borrowing Expenses (1)


Calculate the annual amounts to claim for up-front borrowing expenses. 

Amortise expenses for up to 10 loans, show unclaimed balances at year-end over the write-off period and amortise unclaimed borrowing expenses brought forward from the previous year.

PAYGW Variations (1)


Project rental income and expenses, estimate deductible interest on property loan(s) and project depreciation for the year.

Standard Calculation

Private Use

Foreign Rent

Reconcile Rent

Apportion Interest on a Mixed Purpose Loan

Borrowing Expenses

PAYGW Variation – Rent Estimate

PAYGW Variation – Interest Estimate

PAYGW Variation – Depreciation Estimate