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.
To start the import process, select Insert. Once the import is complete, you will get a message letting you know it has been successful, click Close.
Rollover availability
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.
Worksheets | Expected result |
Index sheet | |
Smart Links | Smart link will rollover (from 2018 onwards) |
Hyperlinks | Hyperlink will rollover (from 2018 onwards) |
Comments | Comment will rollover (from 2017 onwards) |
Worksheets | |
Non-template worksheet | Worksheet will rollover in it's entirety |
Customised template | Searches for the most current firm version. Data will roll over if customised for the correct named ranges. |
Modified Smart Suite template | Searches for the most current Smart Suite template version (no customisations will be rolled over) |
Smart Suite templates | |
Spare Worksheets | 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 |
01 | Salaries and Wages |
10 | Interest Received |
11 | Dividends Received |
13B | Partnership and Trust Distributions |
21A | Rental Property |
21B | Rental Property Summary |
A02 | Items Forward |
C05 | Franking Accounts |
C15 | Losses |
C20 | Tax Reconciliation |
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 |
D15 | Supplementary Deductions |
F20 | Livestock |
FB03 | Car Parking Fringe Benefits |
FB07 | Housing Loan Fringe Benefits |
FB09 | Loan Fringe Benefits |
FB10 | Car Fringe Benefits |
FB11 | Residual Motor Vehicle Fringe Benefits |
G05 | Borrowing Costs |
G10 | Fixed Assets Depreciation |
G15 | Intangibles |
G20 | Investments |
G25 | Other Assets |
G31 | Division 7A |
H08 | Superannuation Liability |
H09 | Chattel mortgage |
H10 | Hire Purchase |
H11 | Loan Repayment Schedule |
H20 | Leases |
H24 | Loan Repayment Schedule |
H30 | Other Liabilities |
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 |
K10 | Reserves |
M03 | Interest Apportionment |
M05 | Distributions |
M07 | Distributions - Simplified |
M10 | Dividends |
M11 | Dividends - Comprehensive |
M15 | Interest Received |
M2 | Borrowing Costs |
M20 | Other Income |
M25 | Rental Property |
M26 | Rental Property Summary |
M30 | Revenue |
M35 | Sales Trading Account |
M40 | FBT Contributions |
N10 | Donations |
N20 | Expenses |
N35 | Interest Apportionment |
N45 | Motor Vehicle Expenses |
PHI | Private Health Insurance Details |
PP04 | Livestock |
PP06 | Produce Trading Account |
PP07 | Deferred Income |
SF28 | Bank |
SF33 | Fixed Assets Deprecation |
SF34 | Investments |
SF35 | Other Assets |
SF49 | Transfer Balance Account |
SF53 | Interest Received |
SF54 | Dividends Received |
SF55 | Rental Property |
SF56 | Rental Property Summary |
SF58 | Managed Fund Distributions |
SF61 | Changes in Market Value |