Overview: At the firm level, administrators are able to create binder templates specific to the firm.
Please refer to the Glossary for definitions of key terms used in this article.
Watch the video
Customise record template recommendations
From the Admin Centre, click on Binder Settings under the Workpapers banner.
The below screen will appear. Click on Record Recommendations.
The Active Platform ships with a standard set of record template recommendations as below.
Select the binder type you wish to customise recommended records for.
Disable existing record template recommendations
The pre-shipped binder type records can be disabled by clicking on the Ignore Inherited Record Templates checkbox.
Add new record template recommendations
Click on + Add Record Template.
A record can be attached as a recommendation to either:
a specific account, such as Plant & Equipment using the account type, or
a section, such as general or tax using the section code.
Account type example – where account type is selected
Choose the account type you wish to add a record template recommendation to. For this example, Plant & Equipment will be used.
Click Next Step.
Select the worksheet you wish to add as a recommendation against a Plant & Equipment account type. Click Next Step.
Tip: If you want to add your own firm worksheet as a recommendation in a binder, you must first have added this worksheet within the Admin Centre. See the support article How to add a firm record template for guidance on how to do this.
Select the level from the options below.
LEVEL | DESCRIPTION |
Optional | A worksheet that may or may not be used as support for a balance at the firm level. |
Recommended | A worksheet that is desired to be used as support for a balance at the firm level. |
Mandatory | A worksheet that must be used as support for a balance at the firm level. Any mandatory worksheets that are not accepted and used will be flagged as such in the QA Centre. |
Edit the default title to call the worksheet if applicable, and write notes as required.
Click Next Step.
Select the entity type you wish this record to be recommended for. For example, if creating a provision for tax record type recommendation, select only tax paying entities in this section (such as companies, superfunds and individuals). Leave blank if the worksheet applies to all entities.
Select a jurisdiction if applicable, or if available to all, leave as is.
Filters
Date filters
Change the date filter where you only want the worksheet to be recommended for a specific time period. For example, for COVID related worksheets, these may only be recommended for binder period dates between 01/07/2019-30/06/2022.
For this example, we will leave as Always.
Balance filters
FILTER | DESCRIPTION |
Balance presence filter | Allows rules to be set as to when the record should be recommended and allows the worksheet to be inserted when there is a balance in any column or only the primary column (current year). For Plant & Equipment, it is assumed that a worksheet would be added to the account if there is a balance in either current or prior year as a manager may wish to inspect why assets no longer exist this year. |
Balance sign filter | Add a balance sign filter if you only wish to recommend the worksheet where there is either a positive or negative balance. If not, leave as Any. |
Lower / upper threshold | Put dollar value thresholds where you only wish to recommend the worksheet where the account balance is above or below a certain amount. If not, leave blank. |
Account filters
In this example, account filters would not need to be applied as the Fixed Asset Depreciation worksheet will be recommended for all accounts that have the Plant & Equipment account type.
Click Save and Close.
The fixed assets depreciation worksheet will now be recommended as an optional worksheet in any binder against any account that has the Plant & Equipment account type, as shown below.
Account type example – where account type is not selected
A recommendation can also be made without selecting a specific account type. For example, for entertainment expense, it would be easier to only filter for specific account terminology rather than account type.
Click + Add Recommendation. Leave the account type selector defaulted as 'Attach to any account type'. Click Next Step.
Search for the worksheet you wish to recommend against an entertainment GL account. Click Next Step.
Select the level from the options below.
LEVEL | DESCRIPTION |
Optional | A worksheet that may or may not be used as support for a balance at the firm level. |
Recommended | A worksheet that is desired to be used as support for a balance at the firm level. |
Mandatory | A worksheet that must be used as support for a balance at the firm level. Any mandatory worksheets that are not accepted and used will be flagged as such in the QA Centre. |
Edit the default title to call the worksheet if applicable, and write notes as required.
Click Next Step.
Select the entity type you wish this record to be recommended for. Entertainment can apply to all entities so leave defaulted as 'Available to all entity types'.
Select a jurisdiction if applicable, or if available to all, leave as is.
Filters
Date filters
Change the date filter where you only want the worksheet to be recommended for a specific time period. Entertainment rules apply to all financial years, so this would be left as 'Always'.
Balance filters
FILTER | DESCRIPTION |
Balance presence filter | Allows rules to be set as to when the record should be recommended and allows the worksheet to be inserted when there is a balance in any column or only the primary column (current year). For Entertainment Expense, it is assumed that a worksheet would be added to the account if there is a balance only in the current year. |
Balance sign filter | Add a balance sign filter if you only wish to recommend the worksheet where there is either a positive or negative balance. If not, leave as Any. |
Lower / upper threshold | Put dollar value thresholds where you only wish to recommend the worksheet where the account balance is above or below a certain amount. If not, leave blank. |
Account filters
Can allow a search by account name, number or account type. In this example, account filters would be used to find any account that has a phrase such as 'Entertain'. The system will search the trial balance for any account with that includes this phrase, which can be any part of a word.
Select the match type to be Account Name.
Match conditions
MATCH CONDITION | DESCRIPTION |
Classification | Allows a match for an account classification, such as assets or expenses. |
Find | Is where you type the phrase, such as 'Entertain', for the system to find the account to recommend the entertainment worksheet against. |
Case sensitive | The find condition can be made case sensitive by clicking the 'Case Sensitive' box. Leave unticked for a more accurate match. |
Search mode | Relates to where in the account name should the system search for your phrase. 'Anywhere' will tell the system to find the phrase anywhere in the account name, whereas 'Begins With' will only recommend the worksheet against an account that begins with the phrase 'Entertain'. |
Click Save and Close.
The entertainment worksheet will now show as a recommended worksheet in any binder that includes an Entertainment GL account, as shown below.
Section code example
A recommendation can also be made in non-account specific scenarios. For example, the worksheets have General and Tax sections above the accounts section. Worksheets can be recommended to users to populate into these sections.
After clicking + Add Recommendation, populate the section code field with the section code you require, using the master list located in the support article here.
Click Next Step.
Search and find the worksheet you wish to recommend in the Overview section for auto insertion.
Click Next Step.
Select the level from the options below.
LEVEL | DESCRIPTION |
Optional | A worksheet that may or may not be used as support for a balance at the firm level. |
Recommended | A worksheet that is desired to be used as support for a balance at the firm level. |
Mandatory | A worksheet that must be used as support for a balance at the firm level. Any mandatory worksheets that are not accepted and used will be flagged as such in the QA Centre. |
Edit the default title to call the worksheet if applicable, and write notes as required.
Click Next Step.
Select the entity type you wish this record to be recommended for. For example, if creating a provision for tax record type recommendation, select only tax paying entities in this section (such as companies, superfunds and individuals). Leave blank if the worksheet applies to all entities.
Select a jurisdiction if applicable, or if available to all, leave as is.
Filters
Date filters
Change the date filter where you only want the worksheet to be recommended for a specific time period. For example, for COVID related worksheets, these may only be recommended for binder period dates between 01/07/2019-30/06/2022.
For this example, we will leave as Always.
Balance filters
If the 'Only recommend based on presence of account' checkbox is selected, then proceed with completing the balance filters and account filters, following the prompts under the 'Account type example – where account type is selected' section above.
As this is a checklist record recommendation, we would not select this checkbox. Click Save and Close.
The Accounts & Tax Checklist worksheet will now be recommended as a mandatory template in any binder that includes a Overview section, as shown below.
