How to link a cloud source to a binder (Xero, MYOB, etc)

This article assists users in the Setup phase of Active Workpapers.


Linking a source can be performed in either the Excel taskpane or the web. This article will show you how to link a client's cloud based accounting software to your binder.


If you have not yet created your workpaper binder, see the knowledge article: How to create a binder.


Note: Where your firm uses both Active Ledger & Reporting and Active Workpapers, see the knowledge article: How to link an Active Ledger source to a binder.



Linking a cloud data source


Navigate to the Home screen of the binder. If this is the first time you have accessed the binder you will see the option to Connect File in the Connection Details section at the top of the screen.



The following screen will open. Select your cloud file provider. Click Add Source.



Log in to your account as it prompts to do so.



Select the file you wish to use with Active Workpapers. Press Continue.


Graphical user interface, text, application

Description automatically generated



Once returned back to Activeselect the file you wish to use with Active Workpapers. Press Connect, then Add Source.


Graphical user interface, text, application, email

Description automatically generated


Adding Columns to the Binder


Once connected, add columns to the workpapers. The previous financial year will be automatically pre-filled for you.



Graphical user interface, text, application

Description automatically generated


Click + Add Column, which will add the comparative year dataset to your workpapers.



Hint: You can add a calculation column, which can either calculate a variance, percent variance or percent of sales column to compare your current and prior year datasets as indicated below.


Graphical user interface, application

Description automatically generated


Graphical user interface, application, email

Description automatically generated


Once completed, scroll to the bottom of the Home page and click Save and Close.



Your cloud accounting data will now be loaded into the Index screen, ready to complete your workpapers.

 

Next article: How to add a standard workpaper record to a binder.

Did you find it helpful? Yes No

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