Archives: Recent Updates

Summarise rental income and expenses and calculate tax deductible amounts for a property with private use (e.g. Airbnb).  Enter the floor areas of the property and income producing area along with the period or total nights used for private and income producing purposes for automatic calculation of the deductible amounts. Calculations/2020 & 2021

Calculate the profit or loss and capital gain or loss on multiple disposals of cryptocurrency.  Enter unlimited purchases for each sale and select which parcels to sell based on the desired outcome.  Calculate the quantity and cost base of the remaining currencies where there was a partial disposal. Calculations/2020

Calculate and maintain a register of unused concessional superannuation contribution caps.  Calculate increased maximum caps each year where applicable and project expiry date of unused caps. Calculations/2020 and 2021

Analyse personal spending over a period of time by comparing movement in assets and liabilities with income received. Calculations/Financial/Spending Analysis

Calculate deductions claimable over their eligible service periods for prepayments made in either the current or prior financial year(s). Calculations/2019/Prepayment Schedule

New workbook to calculate interest, borrowing costs and end of financial year balances on hire purchase finance with regular weekly payments. Calculations/2019 & 2020/Hire Purchase Weekly

Both workbooks have been updated for 2020 and have an improved layout for easier navigation.   An additional DIY worksheet has been included to enable your own calculations or to insert supporting documents. Calculations/2020/Tax Planning – Company, Tax Planning – Non-Company

Improved layout for easier navigation.  This worksheet now allows entry of unlimited periods of private use or business use of main residence.  Ideal for sale of a property used for mixed purposes, including listing on Airbnb.   An additional DIY worksheet has been included to enable your own calculations or to insert supporting documents. Calculations/2019 &…

This calculation has been updated with the following new features – Option to enter either deductible or private periods; Calculate deductible and private components of multiple amounts; Additionally, further apportion by area if applicable; Sort tables; Protection of the calculation worksheet has been relaxed to allow use of empty cells; and An additional DIY worksheet…

Use this workbook to project possible results under an ATO audit based on asset betterment. Calculations/2018/ATO Audit – Asset Betterment