Connected Workpapers - Excel

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.  The user guide goes through the features of Smart Workpapers.  Additional features for connected workpapers are listed below.

Connect an Excel 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 selected, a box will appear on the right-hand side of the screen. To import an excel file, click on Excel.

Note: Only the Products available to your account will appear.

Instructions will appear in the right-hand column, please read these and click "connect"

A new tab will open.  Copy and paste the clients excel trial balance as shown below:

Once this has been done, you will need to click on the workpapers ribbon at the top of Excel and select "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 - see adding and deleting worksheets for more information 

Note: That 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 Smart Workpapers Tab (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.

For further information visit our 'learning' pages or to see our latest features click here.

General Ledger Feature

Right-click on an account and select 'View General Ledger' will show the ledger balances and list of transactions.

There is a limitation with the Xero integration where some transactions cannot be received. These will be listed under Other Transactions. The following are listed in the Xero documentation.

  • ADJ: a system-generated minor adjustment where Xero represents one payment for several invoices as individual journals, rather than one journal with multiple payments.
  • EC: Expense claim
  • PR: Wage payable bill

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.