Site Updates


Personal Tax Returns

Records Checklists

New records checklists for 2024 returns have now been uploaded to Forms.  One constant challenge when preparing personal returns is getting all of the information you need up front.  Delays in completing returns breeds inefficiency, increases the time you spend on the job and ultimately affects cashflow.  There are two versions of these checklists.

A short one page version is a checklist that the client can use to either get ready for their meeting with you or to be reminded of the information you need if there will be no meeting.  Send this checklist to your clients before the job commences to ensure that there are no missing records.

The longer six page version is a fillable form that will allow the client to record all relevant information and send it to you without the need for a formal meeting.  Be selective about which clients receive this longer version.

Interview Notes

This form will serve as a checklist of the items to be considered when you prepare a personal return face to face.  One important use of this form is to ask the client to complete the “income” section of the form, with a Yes or No answer, while they wait in reception for your meeting. This will remind them of income they may have received and importantly be confirmation of their instructions to you about their income for the preparation of their return.

All forms are available for download from our site as either a Microsoft Word document, to allow you to edit the form to suit the particular needs of your practice, or as a PDF document.


23 June 2024

Asset Acquisition 2024  Updated

Change to layout.  All calculations can now be viewed on one screen.

Calculations/2024/Asset Acquisition

16 June 2024

Property Investment Analysis   New Layout,  New Video

Analyse a proposed rental property acquisition by your client and advise on –

  • Pre and post tax cashflow
  • Weekly cost to the client for affordability
  • Gross and net rental yield
  • Equity at any point in the analysis period
  • Investment return over the ownership period (whether still held or sold)

Or in the case of a negatively-geared property, use hypothetical information to profile an ideal property to match the client’s excess cashflow.  Tax rates have been updated for the 2025 financial year.

Calculations/Budgets & Projections/Property Investment Analysis

1 June 2024

PAYG Withholding Variations

This handy calculator will help you estimate rental income and deductions, interest on investment loans, motor vehicle expenses and depreciation on related assets for 2025 for a PAYG withholding variation. This year, all calculations are now in this one file.

Calculations/2025/PAYG Withholding Variations

19 May 2024

Division 7A Loans

You can now start using this calculator part way through the term of the loan by entering a start year and balance at the beginning of that year. This update will help users move existing loans across from a different calculator.

Calculations/Division 7A Loans

18 May 2024

Trust Distributions

Save precious time and use our trust distribution workbook for your discretionary trust distributions for the year ended 30 June 2024.

Using projected net (taxable) income for the year, you can view the marginal tax rates and income available at those rates for each beneficiary to make tax-effective distributions. The worksheet will convert those taxable distributions to accounting distributions for the trustee resolution.  The resolution forms part of this workbook.

And when the time comes to prepare the trust tax return, you can enter actual accounting distributions to calculate the individual (taxable) amounts to be shown at each return label for the beneficiaries on the trust return.

Click here to watch a video.

Calculations/2024/Trust Distributions

8 May 2024

Hire Purchase Calculators – Video

Click here to view an updated video on these calculators.

24 Apr 2024

Hire Purchase Calculators

All HP calculators are no longer date dependant and have been moved to Calculations/Financial.

The journal worksheet in our HP schedules now includes a journal for acquisition of the asset.


21 April 2024

FBT JobPapers for 2024  New

The 2024 version of our working paper file for FBT jobs is now available for download.  Updates to the calculator this year include –

  • Protection over all sheets has been minimised to include just our formulas and labels or text, giving you more flexibility in adding your own data or comments;
  • You can now import Excel or CSV data to any unprotected cell in this workbook with just a few clicks on that option in the Accountants menu, consistent with our other JobPaper files;
  • A new Table group in the Accountants menu now allows you to work better with our tables.  Options in this group include insert or delete multiple rows, sort columns and fill down data (the latter can also be performed outside tables);
  • Insert pictures, shapes, icons or screen shots in all sheets to make it easier for you to follow or review your work;
  • New items in the Tools menu group include clear formats and fit or reset column widths to allow more flexibility in managing your data; and
  • If you need help or would like to provide feedback, click on the Email Support button in the Tools group to open a new email using your default email program and our address and the exact file name/version will be inserted in your email.

And just a reminder that this JobPaper can be used for all employer types (taxable, exempt or rebatable) and has worksheets to calculate all benefits to be shown on the FBT return form.

You can access a video on this calculator at Main Menu/Videos or click on this link to view it on our YouTube channel.


10 Apr 2024

Hire Purchase Calculators (2023 and later)

With the exception of the Hire Purchase Summary and Hire Purchase Payout calculators, each calculator can now be used for any contract date on or before the year end of that calculator.  e.g. For a contract beginning on 15/02/19 you can now use the 2023 or 2024 calculator.  Previously you had to navigate back to the file for the financial year during which the contract began (2019 in our example).  The Journal worksheet now reconciles journals with the schedule.

Calculations/2023 & 2024/Hire Purchase etc

3 Feb 2024

Tax Planning 2024  New

Our tax planning workbook for 2024 is now available for download.  With this calculator you can –

  1. Update YTD profit to include missing items and to exclude non P&L items.
  2. Project YTD profit to the end of the financial year using one of three options.
  3. Make tax reconciliation adjustments to that projected profit to calculate taxable/net income.
  4. Explore tax planning opportunities and calculate tax payable by all entities and individuals in the client group.
  5. Account for tax on deductible payments by client to associated entities or individuals.
  6. Account for contributions tax and Division 293 tax on deductible super contributions where applicable.
  7. For discretionary trusts, view the marginal tax rate for beneficiaries and income available at that rate.
  8. Calculate tax saved or deferred from tax planning.

For a demonstration of this calculator in action go to the video on our YouTube channel.  Make sure that your quality setting in YouTube is HD.

Calculations/2024/Tax Planning

25 Jan 2024

BAS JobPapers 2024  Updated

The formulas and protection have been removed from the opening balance cells in the reconciliation sections for GST and Payroll to enable use of this working paper part-way through the year and to allow the entry of an opening balance for clients with a quarterly cycle at the quarterly section (previously had to enter at the July sheet).

Calculations/2024/JobPapers BAS

19 Jan 2024

Rental Income Calculators  Updates

This calculator has been updated to add an “Other” column for expenses paid directly by the owner rather than via their agent –

Calculations/2023/Rental Income – Foreign

These calculators have been updated to include descriptions for borrowing expenses, capital allowances, capital works (interest was already included) and when these amounts are added to the “Other” column, you can now reconcile net rent in our calculator with the clients’ rental income schedule on their return –

Calculations/2023/Rental Income – Foreign
Calculations/2023/Rental Income – Private Use
Calculations/2023/Rental Income – Standard
Calculations/2024/Rental Income – Private Use
Calculations/2024/Rental Income – Standard

12 Jan 2024

Effective Tax Rate – User Request  New

Calculate the effective tax rate for your client group.  This calculator can be used for any year so you will find it under Financial Calculations.

Calculations/Financial/Effective Tax Rate

8 Jan 2024

Small Business Boosts – User Request   New

Calculate the bonus deductions claimable under the Small Business Technology Investment Boost and the Small Business Skills & Training Boost.

Calculations/2023/Small Business – Technology Boost and Small Business – Skills Boost

27 Oct 2023

BAS – 2024   Updated

Just one file now and select the entity type at the dashboard.  New features include –

  • New reconciliations for GST, wages, PAYGW & super;
  • Import Excel worksheet or any user-selected range in that sheet; and
  • Draft copy of activity statements now produced.


6 Oct 2023

Rental Income – Foreign – User Request

Summarise rental income and expenses in a foreign currency and convert to AUD.  Add your own exchange rates for any country not listed.

Calculations/2019 – 2023/Rental Income – Foreign

27 Aug 2023

Lodgement Manager – Returns (2023)

Take control of your ATO lodgements with this interactive lodgement dashboard.   Import your lodgement report from the ATO portal and a client report from your practice software to produce a dashboard showing –

  • your overall lodgement performance for the year to date;
  • the quantity and percentage of entity types that make up your client base;
  • your lodgement performance by entity type for the year to date;
  • current year lodgements by due dates showing the number due, the number already lodged and that percentage;
  • an estimate of your 85% on-time lodgment requirements for future dates; and
  • a lodgement summary for the prior 3 years showing clients with all 3 years outstanding, clients with the immediate 2 years outstanding, clients with just 1 prior year outstanding and the balance with no outstanding lodgements.

Using our new practice import wizard, import up to 3 levels of reporting data for each client from your practice software.  Reporting levels may include Accountants, Partners, Office Locations or whatever you need.

These are just 3 examples of the questions that this lodgement manager can answer for you instantly –

  1. From a list of staff responsible for lodging returns, how do they rank and which of those staff members are behind and need help;
  2. How many company returns need to be lodged by your Sydney office by 31 October and who are the staff members responsible for lodging; and
  3. How many clients have not lodged all of their 3 prior year returns.

Calculations/2023/Lodgment Manager – Returns

21 Aug 2023

Working papers for individual returns for a client and their partner (2023)

This new addition to our JobPaper collection has been requested by a number of our users.  Keep all of your supporting records, reports and calculations for both returns together in this file and make use of the handy job management tools and Accountants Desktop templates included with the workbook.

Calculations/2023/Returns – Individual

4 Aug 2023

Working From Home Expenses (2023) 

This calculation is the Home Office Expenses workbook from 2022 but updated with an improved layout and expanded help.  It calculates the running expenses claimable where your client works from home, using the revised fixed rate and/or actual costs methods.  If applicable, it calculates occupancy (place of business) deductions for those self-employed or business owner clients or for those employee clients without an employer provided place to work.  It also inlcudes a handy business use calculator to calculate the proportion of expenses deductible based on floor area and time used.

Calculations/2023/Working From Home

26 Jul 2023

Property Investment Analysis

Thanks to a request from one of our users, this calculator now allows you to analyse a potential property investment over any period from 1 to 10 years.

Calculations/Budgets & Projections/Property Investment Analysis

23 Jun 2023

FBT – Cars (2023)

Our existing calculator has been updated to include the following new features –

  • There are now 2 options for calculating the cost price of a car for FBT purposes.  Calculate from the contract price and make reductions or enter the individual components;
  • The OWDV of a car and accessories added after purchase are now automatically calculated but you still have the option of entering your own calculation;
  • A new “days available for private use” calculator has been added; and
  • Information about calculating the benefit and using the workbook has been expanded.

Calculations/2023/FBT – Cars

6 April 2023

Tax Planning (2023)

April is a good time to do some tax planning with your clients.  The 2023 version of our tax planning workbook has now been uploaded to the Calculations module.  Features include –

  • Project YTD profit to the end of the financial year using one of 3 options;
  • Explore tax planning measures to reduce the client’s taxable/net income;
  • View the marginal tax rates and income available at those rates for all related parties for tax-effective allocation of projected profit; and
  • Automatic calculation of tax payable by a large range of taxpayer types including Residents, Non-Residents and Minors, all with a combinations of MLS and/or HELP where applicable, as well as Seniors, Companies (standard & base rate), Super Funds (accumulation and pension phases) and Trusts.

Calculations/2023/Tax Planning

6 April 2023

Rental Income – Reconciliation

Reconcile rental income and deductions from agent and client records with multiple rental income schedules on the client’s tax return.

Calculations/2022/Rental Income – Reconciliation

6 Mar 2023

JobPapers for Annual Accounts – Company, Trust, Partnership or Sole Trader

A new template calculation, Loan – Related Party, has been added to these JobPapers.


5 Dec 2022

Loan – Related Party

Amortise a related party loan, calculate daily interest, closing balance and payout amount.
Replaces Interest – Related Party.

Calculations/2022 & 2023/Loan – Related Party

3 Dec 2022

Foreign Income Tax Offset

Convert foreign income, deductions and tax paid to AUD, calculate the offset limit and amount claimable.

Calculations/2022/Foreign Income Tax Offset

30 Nov 2022

Lodgement Manager – Returns 

Now manage lodgement of client returns in an interactive dashboard using up to 3 user-defined reporting levels.

Calculations/2022/Lodgement Manager – Returns

23 Oct 2022

Interest – Related Party

Calculate interest on a related party loan.

Calculations/2022 & 2023/Interest – Related Party

10 Oct 2022

CGT – Discount

Calculate the CGT discount percentage for an individual with periods of foreign ownership.  This is a stand-alone version of the calculation in CGT – Property.

Calculations/2022 & 2023/CGT – Discount

1 Aug 2022

CGT – Property

Now calculating the CGT discount for periods of non-residency.

Calculations/2022 and later/CGT – Property

13 July 2022

CGT – Small Business Concessions

Determine your client’s eligibility for the small business CGT concessions and calculate the gain.  This Q & A style workbook includes the following –

  • Answer questions to test basic eligibility as well as eligibility for each of the 4 concessions
  • Calculate aggregated turnover
  • Calculate net asset values
  • Identify CGT concession stakeholders
  • Show results for the significant individual and 90% tests
  • Calculate the gain
  • Use your own order for claiming each concession
  • Handy tracing calculator

Use this calculator either before the event for tax planning purposes or after the event to complete the client’s income tax return.

Calculations/2021 and later/CGT – Small Business

13 June 2022

Tax Planning 2022

For any entity type –

  • Project annual profit from part-year accounts
  • Adjust profit for tax reconciliation items and calculate taxable/net income
  • Deduct tax planning measures
  • Add names and other income of all related parties
  • Calculate marginal tax rates (MTR) and income available at that rate for both the client and related parties
  • Allocate taxable/net income and/or make deductible payments to related parties tax effectively using MTRs and income available at that rate

Video (13:08)
Calculations/Year/Tax Planning

7 March 2022

FBT – Cars

Use this calculator in place of FBT JobPapers if you just want to calculate the taxable value of a car fringe benefit.

Calculations/2021/FBT – Cars
Calculations/2022/FBT – Cars

25 November 2021

PAYG, GST & FBT Instalment Variations

Calculate and keep together all variations to PAYG, GST or FBT instalments for the year.  These are stand-alone versions of the sheets included with our new BAS Jobpapers below.

Calculations/2022/FBT Instalment Variation
Calculations/2022/GST Instalment Variation
Calculations/2022/PAYGI Variation – Company
Calculations/2022/PAYGI Variation – Individual

20 November 2021

BAS Jobpapers

All new Jobpapers for activity statements are now available for the year ended 30 June 2022.  Their features include –

  • Same look and feel as the annual accounts jobpapers;
  • Same job management tools as the above for each period during the year;
  • Keep all BAS reports and working papers for the entire year in one file;
  • Prepare GST reconciliations;
  • Calculate variations to GST, PAYG & FBT instalments;
  • The BAS summary included is automatically updated as you go along; and
  • At EOFY, just 2 clicks to copy the BAS summary from there to the Annual Accounts Jobpaper file.

Calculations/2022/Jobpapers – BAS

14 Nov 2021


New video demonstrating our CGT worksheets covering the sale of property, shares and cryptocurrency.

Main Menu/Videos

25 Oct 2021

Hire Purchase

See our video demonstrating the different hire purchase calculators available.

Main Menu/Videos

22 Sep 2021

Query Sheet

This new Microsoft Word version of our query sheet now contains a table for queries and responses which can be copied directly into your email to the client.

Forms/Query Sheet

20 Sep 2021

Lodgement Manager

New video uploaded showing how to use these calculators

Calculations/2021/Lodgement Manager – Returns & BAS

26 Aug 2021

Account Summary

Summarise and reconcile any bank, credit card or loan account.

Calculations/2021/Account Summary

14 Aug 2021

Updated Lodgement Manager – Returns

Now import an ATO “All Clients” return lodgement report along with a client manager report from your system to manage practice obligations for lodgement of client income tax returns. With just 3 clicks to load the information to the dashboard, you will be able to slice and dice the data to view all desired combinations of returns and managers.

Calculations/2021/Lodgement Manager – Returns

9 Aug 2021

Updated Lodgement Manager – BAS

Now import an ATO not-lodged activity statement report along with a BAS manager report from your system to manage practice obligations for lodgement of client activity statements.  With just 3 clicks to load the information to the dashboard, you will be able to slice and dice the data to view all desired combinations of activity statements and managers.  Now comparing BAS manager performance.

Calculations/2021/Lodgement Manager – BAS

4 Aug 2021

Division 7A Loan Register

If you have a company with multiple year loans to multiple borrowers and want a summary to reconcile with your general ledger, use this register to paste the relevant figures in the amortisation summary from each file and all loans will be displayed in an interactive dashboard.

Calculations/Division 7A

25 Jul 2021

JobPapers Update

We have commenced progressively releasing our new JobPaper collection of Excel workbooks, all included under your current annual subscription.

A JobPaper is an Excel workbook with multiple worksheets, template calculations and a dashboard designed for use in a specific job type in your practice. Each JobPaper has its own built-in menu for easy navigation.

When used in conjunction with a PDF copy of client records and a PDF editor, a JobPaper forms an essential part of a paperless platform for managing and completing a job in your practice, all contained in one file and saved in your document management system for easy retrieval.

In addition to including the relevant Accountants Desktop template calculations for the job type, each workbook also comes with checklists for job procedures and pre and post job admin tasks (all customisable), a to do list, a queries sheet, sheets for file notes and job-related communications, a dedicated records sheet, as well as several worksheets for specific tax and accounting reports and calculations. All in one file!  At the end of the workbook there are blank worksheets to use for any other purpose.

The following JobPapers have now been released –

* 2020 annual accounts for a company
* 2020 annual accounts for an SMSF
* 2020 annual accounts for a partnership or sole trader
* 2020 annual accounts for a trust
* 2021 FBT
* Sundry job (any other job not covered by a specific JobPaper)

The final stage of our JobPaper collection is expected to be released in May/June and will include the following 2021 JobPapers:

* BAS for a company
* BAS for a trust
* BAS for a partnership
* BAS for a sole trader

If you want some suggestions on working without paper in an accounting practice and see how JobPapers can form an integral part of that process, check out our short video on YouTube here.  Links to videos with Adobe and Excel tips will be released with the JobPapers.

Blackhole Expenditure

Use this workbook to write off over 5 years certain business capital expenditure (“blackhole expenditure”) not denied by some other provision. See immediate deductions for small & medium businesses below.

Eligible Costs
1. Establishing a company or other business structure
2. Converting your business structure to a different structure
3. Raising equity for your business
4. Defending your business against a takeover
5. Unsuccessfully attempting a takeover
6. Stopping carrying on business (including liquidating a company).

Small & Medium Businesses
Note that from 1 July 2015, a start-up company, trust or partnership can immediately deduct a range of professional expenses associated with starting a new business, such as professional, legal and accounting advice.


18 May 2021

Rental Income – Private Use

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

19 February 2021

Tax Planning Workbooks Rolled Forward to 2021

Project annual profit, estimate taxable income and calculate tax payable by the business and their owners for 2021. Explore ways to defer or save tax.  Separate workbooks for companies and non-companies.


19 February 2021

CGT – Cryptocurrency

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 and later years

10 October 2020

Superannuation – Unused Concessional Contributions Cap Register

Calculate, and maintain a register of, unused concessional superannuation contribution caps. Calculate increased maximum caps each year where applicable and project expiry year of unused cap amounts.

Calculations/2020 and later years

23 August 2020

Personal Tax Return Checklists (3)

The 2020 versions of these checklists have now been uploaded to the “Forms” module.

28 June 2020

Spending Analysis

Analyse personal spending over a period of time by comparing movement in assets and liabilities with income received.

Calculations/Financial/Spending Analysis

15 June 2020

Prepayment Schedule

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

Calculations/2019 and later years

24 January 2020

Hire Purchase Weekly

New workbook to calculate interest, borrowing costs and end of financial year balances on hire purchase finance with regular weekly payments.

Calculations/2019 and later years

18 January 2020

Tax Planning Workbooks for 2020

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

9 January 2020

CGT – Property

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 and later years

3 January 2020

Apportion by Date

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

2 January 2020

ATO Audit – Asset Betterment

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

Calculations/2018/ATO Audit – Asset Betterment

18 March 2019

Lodgement Manager – BAS

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 and later years

6 January 2019

Company Tax Rate

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 and later years

16 December 2018

Livestock – Forced Disposal

Calculate tax profit on the forced disposal or death of livestock.  Show profit to be spread across 5 years under option 1 and alternatively allow entry of replacement livestock for automatic calculation of reduction to those costs to absorb the deferred profit under option 2.


8 November 2018

Lodgement Manager – Returns

Download an ATO lodgement status report for your practice and import it into this workbook for an in-depth analysis of your practice lodgement program.  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 current year returns on your client list by lodgement status, client type and due date;
  • See the percentage of returns lodged by your practice to the date of the ATO report;
  • View your 85% on-time lodgement targets for each of the due dates;
  • The Dashboard also has a last year lodged analysis, revealing how far behind some clients are in their lodgement obligations;
  • An optional Manager Dashboard will allow you to import client managers from your practice software and analyse client manager performance by lodgement status, client type and due date;
  • The Manager Dashboard also displays weekly lodgement targets for each manager and due date as well as showing a last year lodged and return not necessary analysis by manager;
  • Along with client 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 return 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 returns 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 and later years

12 October 2018

Defined Benefit Income Cap Tool

This is a link to the ATO website to calculate the defined benefit income cap, the assessable amount to be included in the tax return and the amount of the tax offset that may be allowable.

Calculations/2018/Defined Benefit Income Cap Tool

27 September 2018

Personal Budget

This is a non-expiring monthly budget for use by your clients in managing their personal finances.  The workbook has been protected but without a password.  We recommend that you review this budget, make any changes to accommodate your preferences, including adding your practice name and/or logo and then use a password to protect the budget worksheet before giving it to your clients.

The features of this budget include –

  • A flowchart demonstrating best practice in managing personal finances;
  • Inbuilt formulas for payment patterns will enable automatic allocation of income and expenses across the twelve months;
  • Income or expenses with erratic frequency can be entered directly to the months involved;
  • Separate tracking of bills and personal spending;
  • Calculation of a weekly spend amount to help contain out of control spending;
  • Projection of the balance of the “Bills” account to reveal any shortfalls in monthly funds;
  • The actual balance of the “Bills” account for any month can be entered to make projections for future months more meaningful;
  • The ability to add a buffer (based on a multiple of your monthly provision) to provide for any interruption to your income or to cover individual monthly shortfalls;
  • A completed annual budget can be copied within the workbook for future reference and the current budget can then be updated with details for the new year; and
  • When customising this workbook for your practice, you can change the colour theme (Page Layout/Themes) to match your logo or practice colours.  You will need to unprotect both worksheets to change the colour theme and it is important that both sheets are then protected again with a password.

Calculations/Budgets & Projections/Budget – Personal

25 September 2018

Franking Credit – Convert to Loss 

For a company tax return, convert excess non-refundable franking offsets to an equivalent tax loss.

Calculations/2018 and later years

12 August 2018

Stock – Private Use

This workbook calculates the amounts that the ATO will accept as estimates of the value of goods taken from trading stock for private use by taxpayers in named industries.

Calculations/2018 and later years

11 August 2018

Depreciation – Balancing Adjustment & Capital Gain/(Loss)

This workbook will calculate the assessable or deductible balancing adjustment, and if applicable the capital gain/(loss), on disposal of an asset depreciated under the uniform capital allowance system.  It will also calculate the reductions to be made to the cost and termination value if the asset is a car and its cost exceeded the car limit and calculate the reductions to the balancing adjustment and capital gain/(loss) to reflect private use of the asset.  Notional calculations are also shown for use in client accounting if applicable.

You can use this workbook to calculate the required figures when preparing a client’s tax return should your software not perform these calculations.  You can also use the workbook before the financial year has ended to advise your client on the tax implications of disposing of the asset.

Calculations/2018 & 2019

8 July 2018

Apportion by Value

This handy calculator will allow you to enter a set of values to calculate the total value and relative proportion of each component and enter an amount for apportionment.  Examples of how this workbook could be used include –

  • Calculate the amount of land tax for each property included in a single assessment for multiple properties; and
  • Calculate the deduction for home office (place of business) expenses based on floor areas used for business and private purposes.


17 May 2018

Workplace Rights & Obligations for Small Business

The Fair Work Ombudsman’s (FWO) new Small Business Showcase is a virtual hub containing a wealth of tools and resources to help you meet your workplace responsibilities.

The Showcase helps you understand and deal with key workplace issues like hiring, minimum wages and keeping accurate records.

It also includes:

  • short instructional videos on how to use their tools and resources
  • an interactive checklist to check your knowledge of key workplace concepts
  • online polls so you can share your insights and opinions on key workplace issues.


12 May 2018

Charge-out Rate Calculator

Calculate the charge-out rate for a small business service provider.

Calculations/Budgets & Projections/Charge-out Rate Calculator

28 Apr 2018

Break-even Analysis

Calculate the revenue required from either the sale of goods or services to break even.  Features include –

  • Enter gross profit ratio and fixed costs to an expandable table to calculate sales or fees required to break even;
  • Enter the average sale amount to calculate the number of sales required to break even;
  • Enter the average hourly charge-out rate to calculate the number of hours to charge to break even;
  • Enter desired profit to calculate revenue and the number of sales or billed hours to achieve that profit; and
  • Enter notes about your calculations.

Calculations/Budgets & Projections/Break-even Analysis

27 Apr 2018

Vary Quarterly PAYG Instalments for an Individual

Estimate the quarterly PAYG instalment amount or rate for a variation for an individual.  Prepare up to 4 variations for a client and retain a full record of their PAYG instalment variations in the one file.  Features include –

  • Estimate gross income and deductions related thereto for each category of income.
  • Account for reconciliation items on the return to convert profit to taxable income.
  • Enter details of student debts (HELP, TSL, SFSS) for automatic calculation of repayments.
  • Estimate income tax, medicare levy and medicare levy surcharge on taxable income and account for tax offsets and other credits.
  • Automatic calculation of PAYG withholding on wages entered.
  • Separate “Projections” worksheet to allow estimates of income and expenses for any category of income.

Calculations/2018 and later years

18 Apr 2018

Apportion by Date

This handy calculator will allow you to enter a date range and compare excluded periods within that range with the full period, giving total days, excluded days and percentage thereof and enter an amount for apportionment.  Examples of how this workbook could be used include –

  • Calculate days that a rental property was used for private purposes to apportion expenses;
  • Calculate days that a company vehicle was available for private use by an employee for FBT purposes;
  • Calculate days a main residence was used for income producing purposes for CGT calculations; and
  • Calculate days travelling on business to apportion expenses between business and private.


31 Mar 2018

FBT 2018

Fringe benefits tax calculations, letters and forms for 2018 are now available on our site.

19 Mar 2018

Retirement Planner

Use this workbook to help your clients plan for their retirement by projecting growth in their investments and superannuation balances to determine whether the accumulated funds will provide them with a comfortable retirement.  See more information at the workbook page and Calculations/About Each Workbook.

Calculations/Budgets & Projections/Retirement Planner

16 Mar 2018

ATO Small Business Benchmarks

The 2017 version of this calculation (now shown under Calculations/2017) has been updated to include the latest benchmarks released by the ATO on 21 February 2018 from 2016 returns.

Calculations/2017 and later years

21 Feb 2018

Profit Manager

Analyse your client’s Trading/Profit & Loss Statement and explore the various options for improving their bottom line.  Enter changes (up or down) to the following performance indicators for clients with either trading or services income (or both) and view the effect on their profit –

  • Average sale or fee amount
  • Repeat business
  • Turnover or productivity
  • Sales prices or charge-out rates
  • Cost of sales
  • Direct costs
  • Operating expenses

It will only take a few minutes to enter the summarised data from your client’s most recent financial report and you can then consider the various options in a meeting with your client.

Calculations/Budgets & Projections/Profit Manager

15 Feb 2018

Fee Schedule

Use our new schedule of fees template (in Microsoft Word) to set up a schedule for your practice.  Providing new or existing clients with this information is a good way to manage their expectations in relation to the fees you charge for your services.

Forms/Fee Schedule

7 Feb 2018

BAS Workpapers – Cashbook Quarterly (2018)

This workbook can be used where the client provides bank and credit card account statements and you want to enter transactions and reconcile with closing balances for up to six separate accounts.  As with other BAS workpapers, this workbook produces a summary of GST collected and paid for quarter for the preparation of Business Activity Statements, along with an annual summary of transactions for the preparation of the client’s income tax return.

Calculations/2018 and later years

4 Feb 2018

Tax Planning (2018)

Two separate tax planning workbooks (for companies and non-companies) for 2018 are now available to project annual profit, estimate taxable income & tax payable and devise ways to defer or save tax.

Calculations/2018/Tax Planning Company/Non-Company

16 Jan 2018

PAYG Withholding – Pay Estimate – Fortnightly Wages

Calculate fortnightly gross wages and PAYGW based on variable net wages of business owners.

Calculations/2018/PAYGW – Pay Estimate Fortnightly

17 Nov 2017

PAYG Withholding Variations

Four workbooks have been rolled forward to 2018 to assist with projections for PAYG Withholding Variations for the year ended 30 June 2018.  They include projections for rental income and expenses, depreciation of fixtures and fittings, interest on investment loans and motor vehicle expenses.

2 May 2017


We have added our fringe benefits tax calculator for use with all employer and fringe benefit types for the year ended 31 March 2017.  The workbook includes calculation of FBT payable where applicable, calculation of the value of benefits for an employee contribution and a summary of all benefits by type and employee.

6 April 2017

Fixed Price Agreement

Calculate fees and periodic payments for a client entering into a fixed price agreement with your practice.  This workbook provides for multiple jobs spread across multiple related client entities and includes automatic calculation of fees based on the prior year fee and a markup or enter your own fee.  Payments are calculated on either a weekly, fortnightly or monthly basis.

22 Feb 2017

Profit & Tax Projections for 2017

Two separate versions of this workbook (for companies and other entities) have been rolled forward to 2017.

8 Feb 2017

CGT – Shares

The 2016 and 2017 versions of this workbook have been updated to include cost per share.

14 Nov 2016

Hire Purchase Fortnightly

Calculate interest, borrowing expenses and end of year balances on a standard hire purchase contract with regular fortnightly payments.

14 Oct 2016

Tax & Super Debt – Company

Enter a weekly or monthly summary of income, expenses with GST, wages and PAYG withholding to calculate amounts to be set aside for subsequent payment of GST, PAYG Withholding, PAYG Instalments (or Income Tax), Superannuation and FBT.   This workbook will also estimate the client’s annual tax liability and allow the use of separate (updated) quarterly rates for PAYGI and separate quarterly amounts for Superannuation and FBT instalments.

If you are maintaining a separate bank account for these future liabilities, the workbook allows entry of all transactions and will reconcile those figures and the calculated balance with bank statements.

This is an essential resource for your small business clients or investors who are struggling to pay their tax and superannuation debts.  Use this workbook as a consulting tool in your practice (or even for your practice) or give it to your client after calculating and entering a PAYG instalment rate for each quarter.

10 Oct 2016

New Site Launched

There has been a complete rebuild of the site with the following new features –

  • Larger screen space and font size, along with an improved layout, for easier viewing.
  • Calculations, Forms & Letters are now displayed in tables which can be sorted and searched.
  • Each Calculation, Form or Letter is assigned to a category and can be displayed as a group in the table when sorted or on their own when you search for the category name.
  • ATO News can now be searched.
  • Calculations for each year are now displayed in a compressed format with one line per calculation.
  • Full details about each calculation and suggestions for use are now shown in “About Each Workbook” in the Calculations menu.
  • Letters are now contained in a downloadable Microsoft Word file.
  • Foreign exchange rates are now shown in a table which can be searched to display that country’s rates only.
  • The Library and Websites modules have been given a makeover with easier access via an alphabetical index of links.

20 Sept 2016

Hire Purchase Calculations

Three hire purchase workbooks have been rolled forward to 2017 –

Calculations/2017/Hire Purchase Payout
Calculations/2017/Hire Purchase – Standard
Calculations/2017/Hire Purchase – Structured

8 Sep 2016

Primary Producer Trading Accounts

Prepare trading accounts for a primary producer, including separate worksheets for Livestock (with quantities), Produce and Other income.  A separate sheet summarises the figures for the client’s tax return.

Calculations/2016/Primary Producer Trading

31 Aug 2016

2016 Personal Tax Checklists

Three checklists have been added for personal tax returns for the year ended 30 June 2016.  Each checklist is available in both PDF and Microsoft Word format. They are –

Records Checklist Short – Forms/Records
Records Checklist Long – Forms/Records
Return Checklist – Forms/Interviews

13 Jun 2016

2016 Trust Distributions

Estimate trust accounting distributions required for the trustee resolution by 30 June to achieve a desired taxable distribution for each beneficiary and prepare the resolution itself which forms part of the workbook.

Calculations/2016/Trust Distributions – Resolution

1 Jun 2016

Present Entitlement Register – Private Company Beneficiary

For those discretionary trust ledgers which have not separated the present entitlements of a private company beneficiary each year into sub-accounts, this workbook will track those entitlements and automatically allocate payments and offsets against the appropriate years.  It will also identify any UPEs which will be subject to the deemed dividend rules under Division 7A.  To speed up data entry, export data from the ledger into a spreadsheet and copy and paste into this workbook.

Calculations/2015/Present Entitlement Register

24 May 2016

BAS Summary & Reconciliations

The latest version (2016) of this workbook includes a sheet which reconciles the FBT Expense and Liability shown in the accounts with instalments paid to the ATO and the FBT return itself.

Calculations/2016/BAS Summary & Reconciliations

17 May 2016

ATO Small Business Benchmarks

All ATO benchmarks now come in one workbook and the client’s industry can be selected from a drop down list.  These latest figures were recently published by the ATO from information contained in 2014 income tax returns and activity statements.

Calculations/ATO Benchmarks

10 May 2016

FBT Calculator

This 2016 workbook will calculate the taxable value of  the full range of fringe benefits.  It also includes a separate summary for the FBT return with calculations for all employer types and a summary of benefits by employee, including calculation of reportable fringe benefits to be shown on payment summaries.

The 2015 workbook has been updated with the new style and smaller file size.

Calculations/2016/FBT Calculator
Calculations/2015/FBT Calculator – Excel Version 2007 or Later

29 Mar 2016

Tax Planning Workbooks for 2016

Project annual profit from part-year accounts (practice software or client accounting systems such as Xero, MYOB, QuickBooks, etc), estimate taxable income and tax payable by the company, individual owner, partners or beneficiaries as applicable and calculate tax savings using tax planning measures.

Calculations/2016/Profit & Tax Projection (Companies and Others)

2 Jan 2016

Age Based Contribution Limits

We have added a handy reference table to quickly determine the effect of a client’s age on their ability to contribute to super.

Rates/Superannuation/Contribution Limits by Age

1 Dec 2015

Business Income Schedule

Worksheet to prepare figures for up to 5 separate businesses with consolidated figures to input to the business income schedule on a personal return. Allows separation of non-commercial losses into deferred and non-deferred (and identification of primary producer and non primary producer amounts) where current tax return software (no names mentioned) does not provide separate worksheets.


12 Nov 2015

PAYG Instalment Calculator

Link to the new ATO calculator to work out a varied PAYG instalment rate or amount.


29 Oct 2015

Retirement Planner

This online calculator is found on ASIC’s MONEYSMART website.  It will help you work out –

  1. What income you are likely to have from super and the Age pension after you retire;
  2. How contributions, investment options, fees and retirement age affect your retirement income from super; and
  3. What actions you can take to boost your super and retirement income

Calculations/Budgets & Projections

14 Oct 2015

Return Checklist – Personal for 2015

The 2015 checklist for preparing a personal income tax return is now available for download in PDF and Microsoft Word format, the latter for customisation purposes.

Forms/Interviews/Personal Return

22 Jun 2015

Records Checklists for 2015

Short and long versions of our records checklists for 2015 personal income tax returns now available to send to clients.  Both versions are available in PDF and Microsoft Word format, the latter for customisation purposes.

Forms/Records/Personal Return (Short or Long)

10 Jun 2015

ATO Benchmarks

All workbooks updated to include benchmarks issued by the ATO in April 2015 from 2013 returns.

Calculations/ATO Benchmarks

8 Jun 2015

FBT 2015

The 2015 FBT workbook will calculate the taxable value of all fringe benefit types.  It also includes a separate summary for the FBT return with calculations for all employer types and a summary of benefits by employee, including calculation of reportable fringe benefits to be shown on payment summaries.

Calculations/2015/FBT – Full Calculator

6 Apr 2015

2015 Profit & Tax Projection

Project annual profit from part-year accounts (practice software or client accounting systems such as MYOB, QuickBooks, etc), estimate taxable income and tax payable and calculate tax savings using tax planning measures.  Separate workbooks for companies and other business entities.

Calculations/2015/Profit & Tax Projection (Companies & Others)

28 Jan 2015

ATO Benchmarks – New Layout

New improved layout now shows –

  1. Client ratios;
  2. ATO benchmark ratios;
  3. Expected expense range ($) based on client turnover and ATO ratios;
  4. Amounts by which actual expenses vary from expected range;
  5. Expected turnover range ($) based on the relevant client expense for the key benchmark ratio and variance therefrom;
  6. Expected turnover range ($) based on total expenses and the ATO ratio of total expenses/turnover and variance therefrom where the client does not report the key ratio or only reports a small amount; and
  7. Covering letter now included in Letters/Accounts Letter/ATO Benchmarks.

Calculations/ATO Benchmarks

14 Oct 2014

Stock Estimate

Estimate closing stock from sales, opening stock and purchases by using one of the following five cost of sales to turnover ratio options –

  1. Immediate prior year;
  2. Average of all prior years entered;
  3. Enter own ratio;
  4. Lower inbuilt ATO ratio where available; and
  5. Higher inbuilt ATO ratio where available.

Calculations/Year/Stock Estimate

30 Sep 2014

Tax & Super Debt Management

Calculate amounts to be set aside on a weekly or monthly basis for subsequent payment of GST, PAYG Withholding, PAYG Instalments (or Income Tax), Superannuation Guarantee and a user definable liability (e.g. FBT).  This is an essential resource for your small business clients who are struggling to meet their tax and superannuation liabilities.  Use this workbook as a consulting tool in your practice (or even for your practice) or give it to your client after calculating and entering a PAYG instalment rate.


31 Jul 2014

2014 Return Forms

Forms/Return Forms

11 Jul 2014

2014 Return Schedules

Forms/Return Schedules

11 Jul 2014

2014 Guides & Instructions

Home Page/Lookup
Library/P-R/Return & Schedule Guides

11 Jul 2014

Job Budget & Job Register

Existing workbooks rolled forward to 2015.  Data in the prior year workbook can be copied and pasted to the new workbook.


1 July 2014

2014 Personal Tax Returns

Personal tax return checklist for 2014 added.

Forms/Interviews/Personal Return

Records checklists (short and long versions) for 2014 personal returns added.

Forms/Records/Personal Return

23 Jun 2014

Profit & Tax Projections

Both worksheets (companies and others) have been updated to allow more options for entering projected profit for the remainder of the year. The 3 options are –

  1. Annualise part-year profit;
  2. Enter total projected income and expenses only: or
  3. Complete the attached worksheet which allows projections for each item of income and expenditure.  This latter sheet can be completed by your practice or sent to your client.

Calcs/2014/Profit & Tax Projection – Companies
Calcs/2014/Profit & Tax Projection – Others

14 May 2014

PAYG Withholding Variations

PAYG withholding variation worksheets rolled forward to help with estimates for 2015 applications.  Worksheets include –

  1. Car expenses
  2. Depreciation
  3. Interest paid
  4. Rental income and expenses

Calculations/ 2015/PAYG Withholding Variations

3 May 2014

FBT – Full Calculator

Whether you need to prepare an FBT Return or calculate the employee’s contribution needed to reduce the value of a benefit to zero, this workbook will calculate the taxable value of all fringe benefit types. It also includes a separate summary for the FBT return for a taxable employer and a summary of benefits by employee, including calculation of reportable fringe benefits to be shown on payment summaries. Worksheets include –

  1. Cars (incorporating base value calculations)
  2. Loans
  3. Debt Waiver
  4. Expense Payments
  5. Housing
  6. Living Away from Home Allowances
  7. Board
  8. Property
  9. Residual
  10. Car Parking
  11. Meal Entertainment

This calculator comes in two Excel versions, Excel 2003 or Earlier and Excel 2007 or Later. Due to the size of the workbook, the later version (2007) is a much smaller file and will be quicker to download and save.  It is recommended that this later version is used wherever possible.

Calculations/2014/FBT – Full Calculator

8 April 2014

Tax Provision and Franking Account

The existing workbook has been updated to allow accrual and reversal of PAYG instalments in the Provision for Tax balance without affecting the Franking Account balance.

Calculations/2013 & 2014/Tax Provision & Franking Account


Job Budget

Estimate fees for a job for quoting or fixed price agreement purposes.  This workbook comes pre-filled with a comprehensive list of activities and job categories which are fully customisable, allowing you to change existing, or enter your own, descriptions to suit the individual needs of your practice or the particular job.  Use this workbook to set up a practice template, including names and hourly rates of fee earners, which will automatically fill the budget when selected from a list.  Enter actual hours and fees to compare with the budget and calculate variances.

Calculations/2014/Job Budget


Salary Packaging – Superannuation

The existing workbook has been updated to include the following new features –

  1. Add other taxable income (e.g. net capital gains) or subtract deductions (e.g. revenue losses brought forward) to/from annual salary to take into account your client’s individual circumstances when projecting the tax savings arising from packaging super during the tax year; and
  2. Calculate Division 293 tax and account for the amount payable in projecting these tax savings.

Calculations/Budgets & Projections/Salary Packaging – Superannuation


Service Fees

Calculate service fees payable by a professional firm to a related service entity using either Comparable Market Rates or ATO Indicative Rates contained in the ATO guide to service entity arrangements. The maximum service fee based on ATO recommendations for low audit risk arrangements is automatically calculated but users can determine and use a fee which they consider to be more appropriate to their client’s circumstances.

Calculations/Year/Service Fees


CGT – Property, CGT – Shares

2014 versions rolled forward.

Calculations/2014/CGT – Shares and CGT – Property


PAYG Withholding – Gross Pay Estimate – Weekly

Calculate the weekly amount of gross wages and PAYG withholding based on variable net wages paid to business owners and their associates at random.

Calculations/2013 and 2014/PAYG Withholding – Gross Pay Estimate – Weekly

17 Feb 2014

Wages & Super Reconciliation

Existing workbooks for 2013 and 2014 have been updated to allow entry of the employer’s ABN and the employees’ TFN, DOB and period of employment.

Calculations/2013 and 2014/Wages & Super Reconciliation

14 Feb 2014

BAS Working Papers – Taxi Drivers

Monthly version of the workbook described in more detail below.

Calculations/Year/BAS Working Papers – Taxi Drivers

24 Jan 2014

SMSF Pension Payments

Existing workbooks have been updated to allow entry of actual pension payments made during the year to compare with minimum required and maximum allowed.

Calculations/Year/SMSF Pension Payments

10 Jan 2014

BAS Working Papers – Taxi Drivers

This workbook follows the format in the ATO form titled “Taxi Driver Takings & Expenses Worksheet”.  A copy of that form can be found in the Forms Module under Records.

The workbook produces a summary of GST collected and paid for the preparation of the client’s quarterly BAS, along with an annual summary of transactions for the preparation of the client’s income tax return. Monthly version coming soon.

Also, driver takings are compared with the Small Business Benchmark for Taxi Drivers, which is calculated by multiplying the number of kilometres entered to the worksheets (or your own estimate) by the rate per kilometre set by the ATO.

Calculations/Year/BAS Working Papers – Taxi Drivers

9 Jan 2014

BAS Summary & Reconciliations

Existing workbooks updated to include GST and PAYG Instalment worksheets for those practices which lodge activity statements using the ATO Portal.  Worksheet totals can optionally be transferred to the Summary sheet.

Calculations/Year/BAS Summary & Reconciliations

Business Valuations – Discounted Cash Flow

The existing workbook has been updated to allow manual entry of Sales for each of the ten forecast years.  The standard method of automatically forecasting Sales (base year Sales times revenue growth percentage per annum) has been retained as the default option.

Calculations/Business Valuations

BAS Summary & Reconciliations

Existing workbooks updated to identify if an activity statement (AS) either includes a correction to an earlier AS, contains an error which is corrected in a later AS or is a revision of a previous AS for the relevant period.

Calculations/Year/BAS Summary & Reconciliations


Copyright 2024 Accountants Desktop, Designed and Developed by Web Bird Digital