[AU] How to use the Tax Planning binder

Article Objective: To assist users in navigating the Active Platform to effectively use the Tax Planning binder to prepare jobs during tax planning time.

Context: The Tax Planning binder is designed to flow through the different sections to result in a final report that can be used to compare strategies and tax estimates. 

Please refer to the Glossary for definitions of key terms used in this article.     


Creating a binder

For a full guide of how to create and set up a binder, see the knowledge article: How to create a binder. If you want to have the ledger data available to reference, be sure to connect your binder to your client's accounting file in the binder creation process.   

When creating the binder it is also important to select the correct end date. This value can also be edited in 'Binder Details' in the 'Settings & Tools' menu if necessary.

The end date is used to determine at what date you are entering actuals to, as opposed to estimated values. Changing this date changes the number of columns available for estimates.


The 'Worksheets' section of the index allows you to add as many or as little templates as you need to help estimate the projected profit/loss for the year ending 30 June. Simply click on the Accept button to add it to your binder. You can also click on the + Add Record button to search for other templates available.

Choosing the estimate method

There are two methods available to extrapolate your client's data to year end:

  • Proportional estimate (most commonly used) - this method takes your actual figures and extrapolates those amounts out until 30 June based on a projection factor, which is determined by the number of months remaining in the year. 
  • Cashflow estimate - this method is used for manually entering estimates into the various line items, based on what you know about the client's situation. It is particularly useful for those clients that have seasonal businesses.

Note: You are able to copy ledger balances and insert them into the 'Actuals' column. This way your actual figures will update when you refresh the trial balance. Simply right click on the relevant balance in the index (in either Excel or the web) and select Copy Ledger Formula. Then paste this formula into the relevant cell of your worksheet.

Hint: Year-end templates are also available in the binder (by clicking on the + Add Record button) to help you estimate the profit/loss as accurately as possible. For example, the 'H11 Chattel Mortgage Schedule' worksheet can be used to calculate the interest expense on current loans for the year, and then later can be linked to or inserted into a year-end binder if required.

Tax Reconciliation

If your tax planning involves a company, after entering all the income and expenditure projections, click Accept for the 'TP18 Tax Reconciliation' worksheet in the 'Taxation' section of the index. 

This worksheet uses information from the 'TP07 Estimated Business Gross Profit', 'TP14 Estimated Primary Production Income' and 'TP12 Estimated Business Expenses' worksheets to determine the estimated profit or loss of the business.

Note: Do not include non-business income such as interest, dividends, rent, distributions from partnerships and trusts or capital gains in this worksheet. Enter those items on the separate worksheets provided, or directly into the 'Original Projected Taxable Income' worksheet (refer to section below).

You can then enter any reconciliation items that you know are going to impact the business' taxable profit or loss, including prior and current year provisions and prepayments. Any non-deductible expenses that were entered into the 'TP12 Estimated Business Expenses' worksheet will automatically flow through to the reconciliation.

Note: A prior period section has now been added to all relevant worksheets, which will pre-populate when rolling over to tax planning 2025 and beyond.  

Original Projected Tax Estimate

Now that you have a projected taxable profit or loss, this amount will flow through to the 'TP31 Original Projected Taxable Income' worksheet.

In this sheet you are able to choose the number of entities in your group. Click the Display button for the worksheet to update the number of columns required. Name all the entities under the 'Estimated Income' section, including selecting the entity type from the dropdown list.

From here, you can then enter any other values you have available for all entities, such as salaries, dividends and distributions. 

Hint: You are able to simplify your view by clicking on the Hide Inactive Rows button and by using the expand (+) and collapse (-) buttons to the left of each section.

In the 'Tax Estimates' section you are able to add any tax offsets, as well as any PAYGI or PAYGW payments made during the year. 

After completing all relevant line items, the 'Tax Estimates' section will give you an estimated net tax liability for each entity, as well as a total.

You are then able to use the strategy worksheets to determine the best methods for reducing the tax liability.

Tax calculations with recommended strategies

To begin looking at tax reduction scenarios, you will need to import the tax strategy worksheets into the 'Tax Calculations' section on the Index.

Note: It is mandatory to give each strategy a title, so they can be distinguished from one another in the final report.

Simple tax strategies worksheet

The 'TP01 Simple Tax Strategies' worksheet allows you to choose from common tax planning strategies by using the dropdown list. There is also space to manually enter your own.

You can enter as many strategies in combination as you like. As before, use the Hide Inactive Rows and expand and collapse buttons to optimise your view. The total tax saving across all entities is shown in the 'Tax Planning Summary' section on the same worksheet.

Note: If more than one strategy is selected, the final tax saving will be a combination of all scenarios chosen. To compare one simple strategy against another, add a separate simple worksheet and compare the totals.

Complex tax strategies worksheet

The 'TP02 Complex Tax Strategies' worksheet is a direct copy of the 'Original Projected Tax Income' worksheet but allows you to alter figures. You can add as many complex worksheets as required for comparison. Simply change any amounts that are relevant to your strategy and the tax will be recalculated. All cells changed will be shown in bold with a white background.

Tax planning report

To view the outcome of the strategies in a simplified manner that can be used to present to clients, navigate to the 'Reports' section of the index and go to the 'Tax Planning Report with Strategies' worksheet. From here you can select the income strategy to display. If your strategies are not appearing in the dropdown, click on the Refresh Summary button.

Note: The figures shown in the report are the adjusted amounts relevant to the strategy chosen, not the original figures.

The report will outline all the basic information, as well as a summary showing the tax saved. To view the different strategies, simply select a different one from the dropdown list and click on Refresh Summary.

There are also financial statements and a cover page available in the 'Reports' section for you to complete your tax planning reports. 


Please note that there is a binder checklist that can be used to ensure that you have completed everything relevant to your job. This can be inserted in the 'Overview' section of the index.

The checklist items can then be accessed by clicking on the checklist icon next to the record.

Templates Available in the Tax Planning Binder


Tax Planning Checklist - Business ClientsOverview
TR_1Tax RatesTaxationMandatory
TP31Original Projected Taxable IncomeTaxationMandatory
TP18Tax Reconciliation Business IncomeTaxationRecommended
TP01Simple Tax StrategiesTax CalculationsRecommended
TP02Complex Tax StrategiesTax CalculationsRecommended
TP24Tax Planning Report with StrategiesReportsMandatory
TP27Financial Statement Cover SheetReportsOptional
TP25Financial Statement NPPReportsOptional
TP26Financial Statement PPReports
C05Dividends Paid and Franking AccountsWorksheetsOptional
TP06Capital Gains TaxWorksheets
TP07Estimated Business Gross ProfitWorksheetsOptional
TP08Estimated Rental Properties IncomeWorksheetsOptional
TP09Estimated Rental Property DepreciationWorksheets
TP10Estimated Interest IncomeWorksheetsOptional
TP11Estimated Other IncomeWorksheetsOptional
TP12Estimated Business ExpensesWorksheetsOptional
TP13Estimated Interest ExpenseWorksheetsOptional
TP14Estimated Primary Production IncomeWorksheets
TP15Estimated Livestock Trading AccountWorksheets
TP16Forced Sale of LivestockWorksheets
TP17Deferred IncomeWorksheets
TP20Division 7AWorksheets
TP21Borrowing CostsWorksheets
TP22Loan Repayment Schedule

TP23Hire Purchase Schedule
TP28Trust Distribution SummaryWorksheetsOptional
TP29Dividends Paid SummaryWorksheets
TP30Total Super Balance and Transfer BalanceWorksheets

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.