ATO Division 7A Calculator: Inputs and Results

The ATO Division 7A calculator works out the minimum yearly repayment on a complying loan from its balance, term and repayment details. Use the decision tool for the transaction questions, then reconcile the calculator’s results with your client’s loan records.

What the ATO Calculator Does

The ATO Division 7A calculator and decision tool has separate decision and calculation components. Searches for an ATO Div 7A calc lead to this same official tool.

The decision component asks questions about direct private-company payments, loans and debt forgiveness involving a shareholder or associate, other than a private company. Its answers help determine whether the transaction produces an unfranked deemed dividend. Resolve the underlying facts through your Division 7A exposure review before answering.

The calculator component works out a complying loan’s minimum yearly repayment, interest payable and closing balance. It covers repayment income years after the loan was made, through the current income year. It does not calculate future income years whose benchmark rates are unpublished. For example, 2026-27 has a published benchmark rate, while later years require assumptions in a forecast.

Open the official entry page and follow its link to the calculator. Choose the decision component for a transaction assessment or the calculator component for an existing complying loan. A private company using a substituted accounting period cannot use this calculator.

Gather the Loan Inputs

Prepare a reconciled loan record before entering the calculator’s details. The selected calculation needs the loan’s income year, amount outstanding at the previous income year-end, actual term and repayment amounts with their dates.

1. Identify the lender company and borrower, then select the income year in which the loan was made. Use the loan’s originating year, even when you are calculating a later repayment.
2. Select the repayment income year. It must follow the originating year and fall within the tool’s supported period.
3. Enter the actual term from the complying agreement. Confirm the loan prerequisites before using a secured term. A property reference alone does not establish eligibility.
4. Reconcile the opening balance to the previous year’s closing schedule and the company’s loan account. Investigate differences before carrying a balance forward.
5. Gather each repayment’s amount and date from bank records or supporting offset documents. Keep different loans separate so a repayment is attributed to the correct loan.
6. Compare the calculation year with the ATO benchmark interest rate table. The benchmark is year-specific. Do not reuse the originating year’s rate for every later calculation.

The benchmark rate supports your cross-check. It is not a freely chosen assumption for the official calculation. If the agreement charges a higher rate, retain a separate contractual calculation for interest and the closing balance.

Read the Calculation Results

Read the minimum yearly repayment as the amount that must be met for the selected income year. It includes interest and principal repayment. The interest result is the lender’s interest for that year under the tool’s benchmark-rate calculation. The closing balance is the amount carried into the next year.

Repayment timing affects interest and the closing balance. Entering only an annual total can lose that timing. The ATO says its interest and closing balance match the agreement’s obligations only when the agreement uses the benchmark rate.

Consider this hypothetical historical example. A complying unsecured loan made in 2024-25 has a seven-year term and a $100,000 opening balance for 2025-26. Assume no earlier repayments and one repayment at that income year’s end. The published 2025-26 benchmark is 8.37%.

Item	Illustrative amount	What you check
Opening balance	$100,000.00	Previous closing balance agrees
Minimum yearly repayment	About $19,450.97	Seven years remain in the term
Interest	$8,370.00	No repayment reduces the balance earlier
Actual repayment	$19,450.97	Payment belongs to this loan and income year
Closing balance	About $88,919.03	Opening balance plus interest less repayment

These are illustrative figures under the stated assumptions. If the borrower pays only $15,000, the repayment shortfall is about $4,450.97. A shortfall can produce an unfranked deemed dividend, subject to the applicable exceptions and distributable-surplus limit. It does not extinguish the outstanding loan.

Save the calculation with its inputs. Confirm that the closing balance reconciles and that eligible repayments meet the minimum. For the annual calculation and reconciliation rules, use the minimum yearly repayment guide.

Excel Schedules and Calculator Limits

An Excel schedule keeps a continuing loan history, while the ATO calculator answers the selected calculation from the details you enter. A saved spreadsheet does not become an official ATO result because it uses the benchmark rate.

When the two disagree, compare the repayment year and opening balance first. Then compare the remaining term, each repayment date and the rate. Retain cents during calculations and round displayed amounts consistently. A forecast using an assumed future rate must identify that assumption separately from years with published rates.

The calculator cannot establish the borrower’s associate relationship, the agreement’s validity or whether a repayment is genuine. Under section 109R, certain repayments funded by company reborrowing are disregarded. Review the transaction before counting it, including the statutory exceptions.

A successful calculation therefore leaves classification work with the practice. If a required income year is unavailable, use the legislation and that year’s published benchmark to prepare the calculation separately. Keep its basis with the loan records.

Tax Genie’s Loan Schedules

Tax Genie builds a full-term schedule from the loan details and published benchmark rates your practice records. Staff enter dated advances, a seven-year unsecured or 25-year secured term, or a starting balance for an existing loan.

The schedule shows opening balance, interest, minimum yearly repayment and closing balance. Recording cash repayments, dividend offsets or other reductions updates it. The overview flags repayment shortfalls and missing benchmark rates, so staff can investigate the affected year.

Keep the saved loan record for ongoing management and use the official ATO tool for its decision questions and calculation cross-checks. Staff enter and review information in each separately. Reconcile the repayment dates and closing balance before completing the year’s loan review.