Connected Workpapers - Automated Data Population

Several of our Business Fitness templates are able to be prepopulated from the client's original data file. It is also possible to access the client's general ledger information without having to return to the original file.

General ledger detail

You are able to see the transactions in the general ledger by right-clicking on the relevant account balance and selecting View General Ledger.  

A popup window will appear with the general ledger transactions as shown below:

You can refresh this list and copy it to Excel by using the buttons on the top right corner. The copy to Excel function is useful for pasting the data into other worksheets as required.

If connected to our ledger software, Reportance, the transactions displayed will be those in your Reportance file. To show the transactions in your client's file, tick the Include API Ledgers checkbox and then hit the Refresh button.

Prefilled worksheets

When connecting to a Xero file, or to a Reportance file that is using Xero as a source, a number of worksheets will autofill based on the original data in the Xero file. For this to occur, simply click on the Insert button for the relevant account in the Index, click on Workpaper Template and select the relevant template. The worksheets that will auto-populate are:

Next article: Connected Workpapers - Workpaper Items