Division 7A Loan Summary workpaper (D7L)

The Division 7A Loan Summary (D7L) workpaper summarises every Division 7A director loan the company holds, each sourced from its own per-year Division 7A calculation workpaper (D7L-XX). This workpaper applies only to companies, it should not populate for any other entity type even where an account is mapped to Loans to Directors.

Data extraction

●        Loan name: picked from the Trial Balance, taking the account name mapped under Current or Non-Current Assets for that loan year, with the year itself excluded from the name (for example, "Loans to Directors 2017" becomes just the director's loan name).

●        Year of Loan, Loan Balance as at the prior year end, Repayments, Interest, Principal Repayments, and Loan Balance as at the current year end: each pulled from that loan's own year-specific Division 7A Calculation workpaper (see D7L-XX).

●        Balances per GL: from the Trial Balance, the Non-Current Assets loan-to-director account for that year.

●        Loan withdrawn during the year: only populated for a loan that originated in the current year, not for loans carried forward from prior years.

Related workpapers

●        Division 7A, [Year] Calculation (D7L-XX): one of these exists per loan-start-year and feeds its figures up into this summary.

How to access

●        Go to Jobs and open the relevant job.

●        Click the Workpapers icon or navigate to Job Results then Workpapers.

●        Select D7L on the Workpapers Dashboard.