[AU] How to use the Div 7a Calculator record template

Article Objective: To assist users in navigating the Active Platform to effectively use the Div 7a Calculator record template when preparing a standard compliance job.                      

Context: The Div 7a Calculator is designed to calculate the minimum yearly repayments and interest on a shareholders loan.                   


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


TABLE OF CONTENTS


How to access the binder

To use the Div 7A Calculator, create a new binder selecting 'Accounts & Tax' - see the knowledge article: How to create a binder, for more information.      


Note: Ensure you create a binder for the correct financial year that you wish to calculate the loan for. The date selected for the binder will automatically select the correct benchmark interest rate. This will also affect the interest rates used for the minimum repayments.


Using the Accounts & Tax binder

When the binder is opened in Excel, add the Div7A Calculator worksheet against the loan account. To do this, add 'G31 Div 7a Calculator' against the loan directly and select the loan as the reconciliation field


For more information regarding how to add a record template, see the knowledge article: How to link various records to a binder


Note: We recommend you choose to rollover the record template so when you are preparing the work next financial year, the loan balances will automatically rollover into the worksheet. 



If the loan commenced during the current financial year (e.g. year of the loan)

In the worksheet, enter the loan details: 

  • whether the loan is secured or unsecured
  • the income year of the loan
  • the term of the loan (maximum of 25 years or 7 years for any other loan)


Enter the dates and amounts in the 'Transactions for the Year' section in the worksheet. 


Note: No interest is payable and no minimum repayment is required to be paid in the respect of the year the loan is made. 



If the loan commenced in the previous year (e.g. 7 years remaining term)

In the worksheet, enter the loan details:

  • whether the loan is secured or unsecured
  • the income year of the loan
  • the term of the loan (maximum of 25 years or 7 years for any other loan)
  • the sum of the loans made in FY2022 year before any repayments were made (this will automatically prefill if the worksheet was selected to be rolled over the year before) 
  • the lodgement date


Enter the balance of the previous year in the 'Sum of the Loans Made in FY2022 Year Before any Repayments were Made' line (if you did not elect to rollover last year), and any repayments made in the 'Transactions for the Year' section.


Note: It is essential that a lodgement date is input for this scenario. If any repayments are made prior to the lodgement date, while interest will still be charged, it will decrease the balance used to calculate the minimum repayment for the current year, hence reducing this amount.      



If it was the second or subsequent year after the loan was made (e.g. 6 or less years remaining term)

In the worksheet, enter the loan details: 

  • whether the loan is secured or unsecured
  • the income year of the loan
  • the term of the loan (maximum of 25 years or 7 years for any other loan)
  • the amount of the loan not repaid by the end of the prior year (this will automatically prefill if the worksheet was selected to be rolled over the year before) 
  • the lodgement date, if applicable


Enter the balance of the previous year in the 'Amount of the Loan Not Repaid by the End of the Prior Year'  line (if you did not elect to rollover last year), and any repayments made in the 'Transactions for the Year' section.



Minimum repayments

The 'Minimum Repayment Calculator' section of the worksheet gives you the minimum repayment required for the current year, as well as future years based on the current year's interest rate.



WARNING: Each year must have it's own worksheet. You should NOT enter any transactions for the current year if you have entered a balance for any prior years.


Did you find it helpful? Yes No

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