Connected Workpapers give you the option to import the trial balance for the client from the cloud based software they are using (i.e. 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 the functionality of the Smart Workpapers, with some additional features. See the features of Smart Workpapers here. Additional features for connected workpapers are listed below.
Connect a Client File to a Connected Workpaper
Access Connected Workpapers
You can access the Connected Workpapers by logging into to the How Now Smart Workpapers Website. Click on the "Start" button on the left-hand side of the page, when you choose your workpaper type, choose a workpaper under the "Connected' heading and download the starter file for the year you are working on.
Connect a File
To connect the client file, click the "Connect" button on the Home Page.
Once clicked, a box will appear on the right-hand side of the screen. Choose which type of connection you would like to make.
The Add-In box will appear on the right-hand side of the screen. To import an APS file, click on the Reckon APS Logo.
Click on the Select File button and navigate through the Explorer window to find your APS File.
Once you have selected your file, choose the year for the file. Then click on Connect.
Note: When connecting the file, all of the entity details on the 'Home' page will pre-fill. Other sections on the 'Home' page will still need to be completed. See instructions for 'Home Page' for help on completing these items.
By selecting Automatic Suggestions, when connecting a client file, recommended templates will be inserted into your file based on the trial balance accounts.
Note: Only templates which have been selected to 'Allow AI to Recommend this Workpaper for Auto Insertion' will be inserted - see instruction on uploading a customised worksheet to select this.
Importing Opening Balances
Where you have used Connected Workpapers in the prior year, you have the ability to "rollover" worksheets. The worksheets used in the prior year will be added to the current year workpapers as part of the process. Where available, closing balances and lists from the prior year will be included in the current year workpapers.
To import opening balances, either open the prior year workpaper and select it from the drop-down list, or use the browse for the file button to select a file to import opening balances from.
When you select both Automatic Suggestions and Import Opening Balances, only one instance of the template will be inserted.
For more information on Opening Balances see the article Import Opening Balances.
Once a file has been connected, the index page will show the trial balance of that entity.
Note: Additional Workpapers not added in the 'Automatic Suggestions' or 'Import Opening Balances' are added in the same way as How Now Smart Workpapers - see adding and deleting worksheets for more information.
You are able to see the transactions in the general ledger by right-clicking on the account balance and selecting "View General Ledger".
A pop-up window will appear with the general ledger transactions as shown below:
Workpapers Tab on Excel Ribbon
The workpapers tab on the excel ribbon looks similar to the HowNow Smart Workpapers (covered in the Workpapers Tab User Guide), however with some additional sections.
The Integration section enables you to refresh your trial balance and connect a file.
Access to the 'Add Reconciliation Field' button is available for Connected Workpapers.
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
A Reconciliation Field is a cell in a workpaper containing an amount (generally a closing balance or summed total) which when selected from the index page performs a reconciliation calculation to the figure listed in the current year trial balance where the workpaper was inserted.
To add a reconciliation field, go to the workpapers tab in the excel ribbon while on the workpaper you want to add a reconciliation field to. Select the cell that you wish to reconcile the trial balance to and click on the "Add Reconciliation Field" button.
A pop-up box will appear. Enter a name for this reconciliation field and select 'OK'.
Return to the index, and on the line for the workpaper the reconciliation field was added to, click in the "Reconcile To" column. A drop-down box will appear. Select the reconciliation field created for this worksheet in the previous step.
If the amount reconciles, the link will turn green. If it does not reconcile the link will turn red.