A short video on this feature can be found here.
Connected Workpapers give you the option to import the trial balance for the client from the cloud based software they are using (ie MYOB, Xero or Quickbooks) or from excel. For the import of a cloud trial balance, please see the article on Connected Workpapers - Cloud Based Software.
Connected Workpapers use the same workpapers and have all of the functionality of the Smart Workpapers, with some additional features. The user guide goes through the features of Smart Workpapers. Additional features for connected workpapers are listed below.
You can access the Connected Workpapers by logging into to the How Now Smart Workpapers Website. When you choose your workpaper type, choose connected workpapers and download the starter file for the year you are working on.
To connect the file, click on "Connect File" on the Home tab.
Once clicked, a box will appear on the right hand side of the screen. To import an excel file, click on Excel.
Instructions will appear in the right hand column, please read these and click "connect"
A new tab will open. Copy and paste the trial balance
Once this has been done, you will need to click on the workpapers ribbon on the top, and click on "Refresh Trial Balance".
This will import your trial balance into the index page.
Workpapers are added in the same way as How Now Smart Workpapers.
The excel import will not be able to correctly classify the workpapers as an Asset, Liability, Income or Expense. However there is a search function to search for the type of workpaper you want added.
Workpapers Tab on Excel Ribbon
The workpapers tab on the excel ribbon looks similar to the How Now Smart Workpapers (covered in the User Guide), however with some additional sections. In the Integration section you can refresh your trial balance, and also connect a file. You can also access the add Reconciliation field button.
Refresh Trial Balance
On the Workpapers tab on the excel ribbon, there is a Refresh Trial Balance button. If any changes have been made to the source file, this button will update the trial balance to the most recent figures.
Add Reconciliation Field
To add a reconciliation field, go to the workpapers tab while on the workpaper you want to add a reconciliation field to. Select the cell that you wish to reconcile, and click on the "Add Reconciliation Field" button.
A pop up box will appear. Enter a name for this reconciliation field.
Go back to the index, and on the line for that workpaper, click in the "Reconcile To" column. A drop down box will appear. Select the reconciliation field created for this worksheet.
If the amount reconciles, the link will turn green. If it does not reconcile the link will turn red.