Importing Opening Balances

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.

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