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 & 2020/CGT – Property

This calculation has been updated with the following new features –

1. Option to enter either deductible or private periods;
2. Calculate deductible and private components of multiple amounts;
3. Additionally, further apportion by area if applicable;
4. Sort tables;
5. Protection of the calculation worksheet has been relaxed to allow use of empty cells; and
6. An additional DIY worksheet has been included to enable your own calculations or to insert supporting documents.

Use this worksheet to analyse the use of an income producing asset, such as a rental property or Airbnb listing, to calculate the deductions claimable against income received over multiple periods of mixed use.

Calculations/Financial Calculations/Apportion by Date

Use this workbook to project possible results under an ATO audit based on asset betterment.

Calculations/2018/ATO Audit – Asset Betterment

Download an ATO not lodged activity statement report for your practice and import it into this workbook for an in-depth analysis of your BAS lodgement obligations.  The features include –

• Once downloaded, it will take you just a few minutes to copy and paste ATO data into this workbook;
• The Dashboard has a summary of the number of outstanding activity statements on your client list by form type, client type and period end date;
• Activity statement statistics are shown in two groups, being those lodged by your practice and those lodged by your client.  You will need to identify this latter group in the data extracted from your practice management software.  Instructions on how to identify this group are incorporated with the workbook;
• The Dashboard also has a list of clients with more than one activity statement outstanding;
• An optional Manager Dashboard will allow you to import BAS managers from your practice software and analyse manager performance by period end date, client type and form type;
• The Manager Dashboard also displays a list of clients with more than one activity statement outstanding;
• Along with BAS managers, you can also optionally import each client’s email address and first name to enable emailing directly from the workbook;
• A further option allows you to import client mobile phone numbers with practice data to enable texting directly from the workbook.  You will need a service provider to use this feature with Microsoft Outlook; and
• You can choose any category of activity statement for email or texting by simply double clicking on any number in either dashboard.  A new sheet will be created with full details of the activity statements included with that number.  Send emails or text messages to these clients from the workbook.

This workbook will quickly put you in control of your ATO lodgement requirements.

Calculations/2018/Lodgement Manager – BAS

Determine the company tax rate for 2018 by analysing base rate entity passive income (BREPI) and aggregated turnover.  Trace passive income received as part of multiple distributions from partnerships or trusts.

Calculations/2018