The import process
Where you have used Smart Workpapers in the prior year, you have the ability to rollover those worksheets. The worksheets used in the prior year will be added to the current year workpapers and, where available, closing balances and lists from the prior year will also be included in the current year workpapers.
Note: the rollover function only works correctly if you are using the same type of starter file (i.e. a 2020 Accounts and Tax workpaper cannot be used to as a rollover option for a 2021 Connected Workpapers starter file).
To use this function, click on the Import Opening Balances button in the top right of the Index sheet.
Once clicked, a pane will appear on the right of the screen. The easiest way is to open the prior year workpaper and then it will be available from the dropdown list to select, or you can also use the Browse for file button.
Once you have selected the file, click Proceed. A list of workpapers that can be inserted will be displayed. To exclude a workpaper from the rollover function, click on the X button next to it.
Note: If a workpaper is a template worksheet, the latest version will be downloaded and last year's data will be rolled over. If a workpaper is a non-template worksheet, last year's workpaper will be copied over in its entirety.
A full list of the workpapers which have the Rollover Opening Balances feature enabled is located in the next section.
Below is a list of the different types of worksheets that can be added to the Index and their expected behaviour when a file is rolled over.
|Smart Links||Smart link will rollover (from 2018 onwards)|
|Hyperlinks||Hyperlink will rollover (from 2018 onwards)|
|Comments||Comment will rollover (from 2017 onwards)|
|Non-template worksheet||Worksheet will rollover in it's entirety|
(i.e. uploaded to the cloud as a firm template)
|Searches for the most current firm version. Data will roll over if customised for the correct named ranges.|
|Modified Smart Suite template|
(i.e. changed for one job)
|Searches for the most current Smart Suite template version (no customisations will be rolled over)|
|Smart Suite templates|
('Blank' and 'List')
|Worksheet will rollover in it's entirety. However, points to the file location where prior year file is saved. Warning message will appear when file is subsequently opened (Excel limitation).|
|Various other worksheets||Some data will roll over on selected worksheets. The most up to date workpaper for the current year is searched for and imported.|
Firm worksheets can be customised to roll over specific data. Help on using this function can be found in the Smart Workpaper Customisations User Guides.
Templates available for rollover
|Template Reference||Template Name|
Salaries and Wages
|13B||Partnership and Trust Distributions|
|21B||Rental Property Summary|
|D01||Motor Vehicle Expenses|
|D05||Other Work Related Deductions|
|D07||Div 7A Calculator|
|D07||Interest and Dividend Deductions|
|D08||UPE Repayment Calculator|
|D10||Cost of Managing Tax Affairs|
|FB03||Car Parking Fringe Benefits|
|FB07||Housing Loan Fringe Benefits|
|FB09||Loan Fringe Benefits|
|FB10||Car Fringe Benefits|
|FB11||Residual Motor Vehicle Fringe Benefits|
|G10||Fixed Assets Depreciation|
|H11||Loan Repayment Schedule|
|H24||Loan Repayment Schedule|
|H39||Provisions - Long Service Leave|
|H40||Provisions - Annual Leave|
|K05||Company Capital Accounts|
|K06||Discretionary Trust Capital|
|K07||Partners & Sole Traders Capital|
|K08||Unit Trust Capital|
|M07||Distributions - Simplified|
|M11||Dividends - Comprehensive|
|M26||Rental Property Summary|
|M35||Sales Trading Account|
|N45||Motor Vehicle Expenses|
|PHI||Private Health Insurance Details|
|PP06||Produce Trading Account|
|SF33||Fixed Assets Deprecation|
|SF49||Transfer Balance Account|
|SF56||Rental Property Summary|
|SF58||Managed Fund Distributions|
|SF61||Changes in Market Value|