This calculator has replaced the annual calculators of the same name. Find it in Calculations/Financial Calculations. Features include –

• Use for any period and multiple years. (new)
• Amortise a related party (unstructured) loan.
• Calculate interest and closing balances for each financial year.
• Calculate the payout amount at any time during the life of the loan.
• Change interest rates as many times as needed (new).
• Sort date columns automatically.
• Automatically add 30 June entries for each financial year needed (new).
• Filter entries by financial year (new).

Find it at Calculations/Related Party Loan

Use this calculator to help complete question 20 on the 2025 individual return. It replaces Foreign Income Tax Offset (FITO). The handy features of this workpaper include –

• In-built monthly and annual average exchange rates for 18 countries.
• The ability to add your own exchange rate for any country and period.
• It’s Excel, so you can copy in any source data to the data table to save time.
• Filter the data table by income type, country or period.
• Produce a summary for the return form labels, including calculating the foreign income tax offset.

Find it at Calculations/2025/Foreign Income – Individual

Records checklists and interview notes for personal returns for 2025 are now available for download.

Send the records checklists to clients to make sure you get all the information you need to prepare their return and avoid time wasting requests for missing information. There are two records checklist options; a simple one-page checklist and a six-page checklist on which the client can record information. Choose the version that best suits the needs of your practice.

Use the interview notes when you are only collecting information for the client’s return. This form lists each return item alongside which you can make any relevant notes to help with the preparation of the return at a later time.

Click on the links below to preview and download each of these forms.

Records Short
Forms/Records – Personal Return Short

Records Long
Forms/Records – Personal Return Long

Interview
Interview – Tax Return

This handy worksheet will help you calculate gross income and net assets for a sophisticated investor certificate.

Find it at Calculations/Financial/Sophisticated Investor

Our trust distributions calculator has been designed to help you calculate tax-effective distributions by your discretionary trust clients. You can use it for both non-streaming and streaming distributions.

The process involves estimating net income of the trust for tax purposes, calculating tax-effective distributions to beneficiaries and converting those amounts to accounting distributions for the resolution.

You can view the marginal tax rates for all beneficiaries based on their non-trust income. The calculator will then show how much income is available at those marginal tax rates, allowing you to use the lowest tax rates first.

Once distributions for tax purposes have been determined and the corresponding accounting distributions calculated, you can complete the trustee resolution which is part of the file.

And when it comes to preparing the trust tax return, you input actual figures to the worksheet and the various components of those distributions will be calculated for each beneficiary and return form item.

Find it at Calculations/2025/Trust Distributions

Our new Tax Money calculator is designed to help your small business clients keep a real-time estimate of future BAS, income tax and payroll related payments.

Identifying these amounts at their taxing point will help clients avoid spending funds that aren’t truly available. And, they could be “parked” in a separate high-interest savings account, or even a mortgage offset account in the case of a sole trader with a mortgage, until the payment is due.

Cashflow is the lifeblood of any business and tax payments are a significant part of cashflow. A recent CreditorWatch analysis revealed that 33% of businesses (1,715 out of 5,097) with tax debts over $100,000 had become insolvent or voluntarily closed over the previous 12 months.

Many small business clients lack the necessary resources, time or know-how to project their future tax payments and need your help.

If you already do the client’s bookkeeping, then using this calculator would fit in nicely with your services. Othewise the client could feed you the information on a regular basis or you could set up the calculator with opening balances and give it to the client for data entry.

These would be the ideal client types who would benefit from having their tax payments managed –

• New businesses without a PAYG instalment rate.
• Growing businesses.
• Clients who generally struggle to meet their ongoing tax obligations.

This is the process followed by the calculator in tracking tax payments –

1. Enter Opening Balances of unpaid amounts at the start date.
2. Enter summarised transactions from the start date to produce Estimates
3. Enter Actuals when the forms are prepared and they replace the Estimates
4. Enter Payments when made and the balance of “Tax Money” is calculated to compare with available funds.

Find it at Calculations/Budgets & Projections/Tax Money

This calculator has been updated with the latest ATO benchmarks from 2023 returns published in 2025.

Find it at Calculations/2024/Benchmarks

Whether you need to prepare an FBT return, or simply calculate the value of benefits for an employee contribution, our FBT files have you covered. The full set of working papers can be used for all employer and benefit types. These are the files for 2025 which are now available for download –

Excel Files
(a) FBT 2025. Full set of working papers.
(b) FBT Cars. Stand-alone calculator for cars only.
(c) FBT Reportable Benefits. Stand-alone calculator for reportable benefits only.

Letters
(a) FBT Return. Request details for FBT return and send with Forms (a) and (b).
(b) FBT Accounts. Request details for accounts only and send with Form (a).
(c) FBT Return Sign. Covering letter to send with the client’s FBT return for signature

Forms
(a) FBT All Benefits Checklist. List of potential taxable benefits. Send with Letters (a) and (b).
(b) FBT Car Benefits Schedule. Details of car benefits only. Send with Letter (a).

Our tax planning calculator for 2025 is now available for download. And you can view a video demonstration on YouTube here.

Use this workbook to help with tax planning opportunities for your clients. The important features of this calculator include –

• Analyse part year accounts and where they were prepared by your client, adjust for any errors to arrive at a true profit for the period.
• To calculate projected annual profit use 3 options –
  • Annualise YTD profit; or
  • Enter details of projected income and expenses to the end of the year; or
  • Enter a summary of projected income and expenses to the end of the year.
• Adjust the projected annual profit for tax reconciliation items and calculate taxable/net income.
• Calculate projected marginal tax rates (MTRs) and income available at those rates for both the client and all related parties, including partners and beneficiaries where applicable.
• Project allocations of taxable/net income and/or make deductible payments to related parties tax-effectively using the lowest MTRs and income available at those rates.

Find it at Calculations/2025/Tax Planning

Updated – User Request

New columns have been added to this calculation to enable identification of franking credits that are not claimable under the holding period rule. You have the option of showing or hiding these new columns. Also enter franking credits received through partnerships and trusts to compare the client’s total franking credits with the small shareholder exemption threshold. Data entry has been streamlined to assume that all dividends qualify for the exemption and simply enter holding dates for the exception(s) to the rule.

Note: this calculator is not compatible with Excel versions 2021 and prior.

Calculations/2024/Dividend Calculations