Uploading a Customised Worksheet

Creating a new worksheet

To create a new worksheet, it is recommended you start with the 'Spare Worksheet - Blank'. This will save time setting up the heading items of the worksheet as they will already be set up. Or you can customise one of the Smart Suite Template worksheets by downloading the relevant worksheet and making any customisations required.

See the knowledge articles: Smart Workpaper Customisations for more information on how to create your own workpaper templates.

Uploading a new or customised worksheet

To upload a new worksheet for your firm, go to the Smart Suite Workpapers website and select Templates from the Admin screen.  

Select the product, from the dropdown list, which you would like to add the worksheet to and then click on the Add New Template button.

The following screen will appear to enter the template properties:

Template properties

Product SelectionRefers to the section on the Index that you would like your template to apply to (e.g. Job Management, Income Tax etc).
NameThe name that will appear on the Index tab and the worksheet title.
Short NameThe name that will appear on the tab of the Excel file.
DescriptionDetails of the workpaper template.
ReferenceThe reference will appear in the worksheet title and on the tab name.
Can be left blank
ReconciliationsThis is the number of accounts an individual template can reconcile (e.g. F05 - Trade Debtors template can only reconcile 1 trade debtor account, F10 - Bank template can reconcile up to 6 bank accounts).
Roll Over Option
This allows the rollover option to be limited for each template.
Three options:
- Roll Over 
- Single Instance
- Do Not Roll Over
Entity Types
This allows you to apply this worksheet only to a specific entity type.

CommandsFor advanced users only (see below).
Allow the Auto Suggestion feature to Recommend this Workpaper for Auto Insertion
By checking this box the template is eligible to be automatically inserted into Connected Workpapers upon connection with the client file.

By checking this box the template is available for selection.

Commands (for advanced users only)

The list below specifies the commands which can be entered into the template and what they do.

Note: Only the manually specified commands need to be entered here.

Manually Specified Commands - Specify in each template commands section
LinkCategoryNameLinks the Tm_CategoryList field in the workpaper to a list of names, usually on the Index. For example, FBT has a list of employees on the Index, by using this command, a workpaper such as 'MV FBT', can apportion parts of the FBT to each employee. Each row will have a dropdown with the list of employees as a result of this function. 

Manually set - Links the Tm_WorksheetTitle field in the workpaper to the Title/Notes of the record in the Index. I.e. Allows users to change the name of a worksheet in the Index page and it will flow through to the corresponding cell in the actual worksheet

RecalculateNamedRangeManually set - recalculates all cells within the named range: "Tm_Recalculate"
Automatic Commands - No need to specify
Link References

Links the account name and the account balance to the Tm_TBBalance, TM_TBAccount and Tm_ComparativeBalance.

DefaultReconcilliationFieldPreselects the reconciliation field on the Index if it finds one obvious match.
SetWorkpaperChecklistsLinks the checklist column in the Index to the Tm_ChecklistItems field in the inserted workpapers.

Uploading the template

Once all details are complete, click on the Add Excel Template button. The following popup will appear:

Select whether you would like the workpaper to be available for all periods or a specific date:

  • All Periods - Allows a workpaper to be available for all periods. This is useful for workpapers such as 'GST' and 'Review Points' where there are minimal changes from year to year.
  • Specify Date Allows a workpaper to be available for only a specific financial year onwards (i.e. The 2020 FY workpaper will be available in the 2021 FY, unless a specific 2021 FY workpaper is uploaded, but it will not be available in 2019 FY). This is useful for workpapers such as 'Income Tax Rec' where there are changes every year.

A workpaper can then be uploaded by clicking the Select File button and browsing for the template. Once the file has been uploaded, click Create and then Add. Your template has now been uploaded.

Template customisation service

If you would like customisations made to your firm's workpapers, but don't feel confident doing them yourself, please refer to Business Fitness Customisation Service for more information on our team making the changes for you.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.