Available master templates
Accountants Enterprise only
Template Name | Category | Country | Description |
---|---|---|---|
Accounting for Investment | Assets | Australia | Reconciles investment accounts using purchases and sales over the year, also calculates market value |
Accounting for Investments (Cost) | Assets | Australia | Reconciles investment accounts and calculates the cost summary and realised profit (or loss) |
Annual Trust Distribution Statement | Other | Australia | For preparing a trust distribution statement for beneficiaries |
Assets - GL reconciliation | Assets | Australia | An automated workpaper that compares data from Assets to the GL and provides a variance. You can drill down to the transactions to review the variance. Asset values in this template can be refreshed by clicking the “Refresh Assets data” button |
Bank Loan analysis | Liabilities | Australia/New Zealand | Reconciles the bank loan and calculates the current and non-current portion of the outstanding bank loan amount |
Bank Loans | Liabilities | Australia/New Zealand | Identifies the current and non-current portion of outstanding bank loans |
Bank Reconciliation | Assets | Australia/New Zealand | Substantiates the cash value of the bank balance, i.e. a detailed reconciliation of the actual bank balance against the general ledger |
Bank Reconciliation Foreign Currency | Asset | New Zealand | Convert foreign currency bank accounts to NZ currency at a specified exchange rate |
Bank Reconciliation (simple) | Assets | Australia/New Zealand | Reconciles the actual bank balance against the general ledger in a summary format |
Borrowing Expenses | Expenses | Australia | Amortises borrowing expenses incurred in obtaining finance |
Carried Forward Issues | Review | Australia/New Zealand | Lists issues that are to be carried forward to the next period |
Carried Forward Losses | Other | Australia | Calculates business loses to carry forward to the next financial year |
Client Retention Checklist | Other | Australia/New Zealand | Checklist from Chartered Accountants - compliance with APES 320/ASQC 1. |
Company Information Sheet | Other | Australia | Includes shareholders’ names, number of shares held, incorporation date and other information to be used as a permanent record to roll forward every year. |
Current Account — Interest on Overdrawn Account | Income | New Zealand | Provides a worksheet for calculating interest on overdrawn current account balances |
Current Account Reconciliation — Non-Company | Liabilities | New Zealand | Provides a reconciliation of current account movements and closing balance for non-shareholder current accounts (partners, beneficiaries, etc.) |
Current Account Reconciliation — Shareholders | Liabilities | New Zealand | Provides a reconciliation of shareholder current account movements and closing balance |
Dividend Paid - Net | Equity | New Zealand | Reconciles imputation credits and withholding tax to dividends paid, and allocates the amount due to each shareholder |
Dividends Paid - Shareholder Distributions Statement | Expenses | Australia | Captures distributions to shareholders, including franking credits |
Div 43 write-off | Assets | Australia | Calculates the deduction for capital works under Division 43 |
Dividends Received | Income | Australia/New Zealand | Substantiates the dividends received including the franked amounts and withholding tax |
Dividend Received - Gross | Income | New Zealand | Reconciles the ledger balance with the gross dividends. The existing workpaper that reconciles to the net dividend will allow practices to choose to reconcile with either net dividends or gross dividends. |
Division 7A Loan - Unpaid Loan Balance | Other | Australia | Calculates the repayment and interest on unpaid loan balances |
Division 7A Loan Summary | Other | Australia | Calculates the minimum repayment amount on loans |
Division 7A Loan Summary (10 Years) | Other | Australia | Calculates the minimum repayment amount on loans with a 10 year term |
Donations | Expenses | Australia/New Zealand | Reviews any donations made for tax deductibility |
Employee Contribution (Log Book) | Expenses | Australia | Calculates the amount of employee contribution based on the log book method |
Employee Contribution (Stat Method) | Expenses | Australia | Calculates the amount of employee contribution based on the statutory method |
Entertainment | Expenses | Australia | A detailed breakdown of entertainment expenses including in-house dining, internal and external expenses to determine the deductible and FBT components |
Entertainment - Adjustment required | Expenses | New Zealand | Correctly calculates the GST adjustment that the client needs to be advised to enter into Box 9 of their next GST return. The calculation takes the net non-deductible and calculates GST as if this was the gross in the same way as the GST on FBT contribution is calculated. This is based on the assumption that the client will have claimed 100% of the GST on Entertainment expenses on their GST Return. |
Entertainment – 50% GST Claimed | Expenses | New Zealand | Assumes that the client has only claimed 50% of the GST on each GST return, and that the effect of making a further adjustment in Box 9 would be trivial. |
FBT Contribution on Motor Vehicles | Income | New Zealand | Calculates the amount an employee is required to contribute, in order to ensure that there will be no Fringe Benefit Tax for motor vehicles that are available for private use |
Fixed Assets | Assets | Australia/New Zealand | Summarises the fixed assets and reconcile the depreciation amounts to the asset schedule |
Franking Account | Liabilities | Australia | Summarises the debits and credits affecting the franking account |
General Notes | Other | Australia/New Zealand | A general template for you to record notes or use as a base for creating a new practice template |
Generic Asset Template | Assets | Australia/New Zealand | A workpaper template that can be used as a basis for any new Asset-based workpaper |
Generic Expense Template | Expenses | Australia/New Zealand | A workpaper template that can be used as a basis for any Expense-based workpaper |
Generic Expenses Template (multiple GL Codes) | Expenses | New Zealand | This is the same as the Generic Expense template but can have multiple account codes linked. The red flag icon will not display on the Workpapers homepage when this workpaper is out of balance. |
Generic Income Template | Income | Australia/New Zealand | A workpaper template that can be used as a basis for any new Income-based workpaper |
Generic Income Template (multiple GL Codes) | Income | New Zealand | This is the same as the Generic Income Template but can be linked to multiple account codes. The red flag icon will not display on the Workpapers homepage when this workpaper is out of balance. |
Generic Liability Template | Liabilities | Australia/New Zealand | A workpaper template that can be used as a basis for any new Liability-based workpaper |
Generic Template | Other | Australia/New Zealand | Use this template as a base to create a new practice template. |
GST annual adjustment election | Other | Australia | A document designed to be printed and signed by the client declaring the use of the GST annual election rules for small business entities |
GST BAS Reconciliation | Liabilities | Australia | Reconciles GST paid and GST collected against BAS |
GST BAS Summary | Liabilities | Australia | Provides a monthly schedule of the GST paid and GST received for BAS |
GST Reconciliation | Liabilities | Australia/New Zealand | Reconciles the amount of GST paid and outstanding with the outstanding liability in the accounts |
Hire Purchase | Liabilities | Australia/New Zealand | Calculates net hire purchase liability using the sum-of-digit method |
Home Office Expenses | Expenses | New Zealand | Calculates home office expenses for tax deductibility |
Imputation Credit Account | Other | New Zealand | Reviews movements of Imputation Credit Accounts for the year |
Income Tax Calculation | Expenses | Australia/New Zealand | Calculates the tax payable. Input details on the non-deductible or allowable items. |
Income Tax Calculation (Detailed) - Company | Expenses | Australia | Calculates company tax payable with details on non-deductible or allowable items |
Income Tax Calculation (Detailed) - Trust | Expenses | Australia | Calculates trust tax payable with distribution to beneficiaries with details on non-deductible or allowable items |
Income Tax Calculation (Generic) | Expenses | Australia | A generic income tax calculation allowing you to specify all add back and less items |
Income Tax Expenses21 | Expenses | Australia/New Zealand | Calculates the amount of tax payable for a company based on the movement in tax liability and assets |
Income Tax Integration - Company | Tax | Australia | Maps ledger values to Tax Return fields for a Company. |
Income Tax Integration - Individual | Tax | Australia | Maps ledger values to Tax Return fields for an Individual. |
Income Tax Integration - Trust | Tax | Australia | Maps ledger values to Tax Return fields for a Trust. |
Income Tax Integration - Partnership | Tax | Australia | Maps ledger values to Tax Return fields for a Partnership. |
Intercompany Loans | Liabilities | Australia | Reconciles loan transactions for related entities |
Intercompany Loans Reconciliation | Liabilities | Australia/New Zealand | Allows selection of a balance from a different client workpaper to compare to the current GL |
Interest Expense Apportionment | Expenses | Australia | Calculates the proportion of interest expenses to be apportioned to the business |
Interest Paid | Expenses | Australia/New Zealand | Facilitates analysis of interest paid, allowing for a private (non-deductible) portion based on a percentage |
Interest Received | Income | Australia/New Zealand | Substantiates the balance of the interest received on an account, including withholding tax |
Investment — Interest Bearing | Assets | New Zealand | Lists various interest-bearing investments and provides for a reconciliation of the closing balance against the general ledger |
Investment Property Cost Base | Assets | Australia | Calculates the property cost plus any buying and selling costs, based on the ATO’s different element cost base |
Investments — Shares | Assets | New Zealand | Lists various shares held for investment and calculates the current market value, gain or loss on disposal and gain or loss on shares held. It provides for the reconciliation of closing market value against the general ledger account balance. The closing value will roll-over to Opening value at the start of the next year. |
Investments Summary | Assets | New Zealand | Acts as a lead schedule for the Investments — shares workpaper and Investments — interest bearing workpaper, but also provides a table for entering the closing balance of other types of investment. This summary then allows for the total reconciliation of all investments to a single general ledger account. |
Issues for Client Attention | Review | Australia/New Zealand | Lists issues that are to be brought to the client’s attention |
Issues for Partner Attention | Review | Australia/New Zealand | Lists issues that are to be brought to the partner’s attention |
Job Review Checklist | Review | Australia/New Zealand | A checklist of actions that must be taken into consideration when completing accounting or an audit |
Livestock | Income | Australia | For the valuation of livestock using tax and account values |
Livestock Calculation - Closing Stock | Other | Australia | Performs closing stock calculations |
Loan reconciliation | Liability | Australia | A simple loan summary that allows you to enter the opening balance, interest and fees to reconcile to the loan balance |
MV expenses Schedule | Expenses | Australia | A detailed schedule of motor vehicle expenses including private and business use and log book details |
Other Debtors | Assets | Australia/New Zealand | Lists any other debtors and to substantiate the balance in the general ledger |
Prepayments | Assets | Australia/New Zealand | Identifies a pre-paid amount and the period over which it will be expensed in the profit and loss statement |
Prepayments - Multiple | Assets | Australia/New Zealand | Identifies multiple pre-paid amounts and the period over which they will be expensed in the profit and loss statement |
Prepayments with Rollover | Assets | Australia | Summarises all prepayments for the year |
Provision for Income Tax | Liabilities | Australia/New Zealand | Reconciles the balance of the income tax liability account including the opening balance, this year’s income tax and any instalments paid |
Ratio Analysis | Review | Australia/New Zealand | Calculates different ratios and provides quantitative analysis of information from the company’s financial statement. |
Rental Property | Income | Australia/New Zealand | Provides a 12-month schedule to calculate the amount of rent received and any deductions from monthly rental property statements |
Rent Received Reconciliation | Income | Australia/New Zealand | Provides a facility for calculating and reconciling rent received by multiplying the number of rent payments by the rental rate |
Review Points | Review | Australia/New Zealand | Enables you to create a review list that also attaches to a code and shows against the account |
Service Fee Calculation | Expenses | Australia | Determines the amount of service fee payable for service trusts with a percentage of wages, rent and depreciation |
Schedular Income with GST | Income | New Zealand | Facilitates reconciliation of the gross schedular income and withholding tax deducted (from IRD Summary of Earnings) and calculates GST to show the net amount received |
Stock on Hand | Assets | Australia/New Zealand | Lists stock values with its valuation method |
Term Deposit | Assets | Australia/New Zealand | Calculates term deposit investment balances and interest accrued |
Trade Creditors | Liabilities | Australia/New Zealand | Substantiates the trade creditors account including other payables during the year |
Trade Debtors | Assets | Australia/New Zealand | Substantiates the trade debtors account including any doubtful or bad debts written off during the year |
Trade Debtors Listing (simple) | Assets | Australia/New Zealand | Substantiates the trade debtors account without doubtful or bad debts written off |
Trade Debtors Reconciliation | Assets | Australia/New Zealand | Substantiates the trade debtors account including any doubtful or bad debts written off during the year, which have been captured by separate accounts |
Trust Beneficiary Distribution | Other | Australia | Reconciles accounting distribution with taxable distribution for trust beneficiaries |
Trust Distributions Received | Income | Australia | Splits the income received from trusts into the appropriate income categories according to the trust statements, e.g. foreign income, capital gains and reconciling to the accounting distribution received |
Trust information sheet | Other | Australia | Summarises beneficiary, income distribution and administrative details of a trust account |
Wages Reconciliation | Expenses | Australia/New Zealand | Provides a summary of wages to reconcile to the lodged BAS statements and the general ledger balance |
Wages Reconciliation (Annual) | Other | Australia | Reconciles wages and salary with leave provisions |
Work in Progress | Assets | Australia/New Zealand | Lists work-in-progress values with its valuation method |