Calculation Template Name

Purpose

Entity Type

Activity Statement (BAS) workpaper

Prepares a BAS for clients, collating GST, PAYGW, PAYGI, FBT instalment, and fuel tax amounts.

All

Base rate entity eligibility test

Determines whether a company qualifies as a “Base rate entity,” including affiliated entity income considerations.

Company

BAS Summary (Monthly)

Summarises monthly BAS's lodged with the ATO for comparison against that year’s figures in the client’s ledger.

All

BAS Summary (Quarterly)

Summarises quarterly BAS lodged with the ATO for comparison against that year’s figures in the client’s ledger.

All

Borrowing Expenses

Calculates amortisation of borrowing costs incurred on liabilities.

All

Business Income Statement

Prepares a business schedule for individuals.

Individual

Capital Gains Tax

Calculates capital gains after applying losses, the CGT discount, and other relevant concessions.

All

Company Tax Rec

Calculates a company’s income tax expense, income tax provisions, tax return fields, carried forward losses, and franking account balance.

Company

Dividends received

Creates a schedule of franked and unfranked dividends, and franking credits.

All

Division 293 worksheet

Calculates Division 293 tax.

All

Division 7A worksheet

Calculates minimum repayments, interest charges, and Div 7A loan balances for reconciliation.

Company & Trust

Donations

Summarises donations made to Deductible Gift Recipients (DGRs).

All

Foreign income worksheet

Prepares a foreign income worksheet for individual tax returns.

Individual

Formation costs

Calculates amortisation of establishment and formation costs.

Company

Partnership

Sole Trader

Trust

SMSF

Unit Trust

GST Reconciliation for compliance accounts

Compares GST lodged with the ATO against accounts to identify variances.

All

Hire Purchase Loan Worksheet

Calculates principal and interest repayments and balances, split into current and non-current amounts.

All

Interest Received

Details interest received, including any TFN withholding.

All

Livestock reporting

Determines stock movements, gross profit, and closing livestock value.

All

Managed Fund Distributions

Separates components of managed fund distributions for individual tax returns.

Individual

Motor vehicle expense worksheets for individuals

Compares logbook and cents-per-kilometre methods to determine the best deduction for tax returns.

All

Prepayments

Calculates prepayments made at the end of the year.

Company

Partnership

SMSF

Sole Trader

Trust

Unit Trust

Rental property schedule

Prepares workpapers for rental property income and expenses.

All

Salary and wage worksheet

Summarises salary and wages for individual tax returns.

Individual

Superannuation (monthly) payable

Verifies the closing balance of outstanding superannuation for monthly payments.

All

Superannuation payable

Verifies the closing balance of outstanding superannuation for quarterly payments.

All

Taxable income summary for individuals

Calculates assessable income, deductible expenses, taxable income, and tax results.

All

Tax deduction worksheets for individuals

Summarises tax deductions for individual tax returns.

All

Trust and partnership income worksheet

Summarises distributions received from trusts or partnerships.

All

Trust tax reconciliation

Reconciles accounting profits with taxable profits for trusts and distributions to beneficiaries.

Trust

Partnership

Sole Trader

Unit Trust

Uniform Capital Allowances (UCA)

Prepares a schedule for business capital costs (e.g., blackhole expenses).

All

Wages reconciliation and payments to associated persons

Reconciles wages in financial statements with payroll reports.

All