How to add your own worksheet to a binder

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


Where standard Business Fitness workpapers/templates are insufficient to complete your job, you can create your own worksheets or use standard firm workpapers where required.


If you have not yet setup your workpaper binder, see Knowledge Article: How to create and access a workpaper binder.


Creating your own worksheet

Once you have created a binder and linked standard workpapers to the accounts in your Trial Balance where possible, you can create your own worksheets to reconcile other balances. Go to your workpapers Index screen.



This example will use Accrued Expenses to illustrate how a non-standard workpaper can be created to reconcile a balance in Active Workpapers.


Click the + to add new sheet inside your excel workpapers.


Hint: You can bring standard firm worksheets into your workpapers by using the move or copy function in excel.

 

 

The following screen will open. Rename Sheet 1 ‘Accrued Expenses’.


Graphical user interface, application, table, Excel

Description automatically generated


Complete your workpaper, and reconcile it to the balance in the Trial Balance.


Graphical user interface, application, table, Excel

Description automatically generated


Make the total Accrued Expenses balance a reconciliation field by clicking in the Active Workpapers add-in and pressing Add Reconciliation Field.



Name the reconciliation field Accrued Expenses in the takspane. Click Save.



Now that your reconciliation field has been added, click on the + button to the right of the Accrued Expenses line.


Graphical user interface, application, table

Description automatically generated


Click Link to Existing Worksheet.



Click on Accrued Expenses.


Graphical user interface, application, email, website

Description automatically generated


Set the reconciliation field to be Accrued Expenses. Press Save.



Your worksheet will now be linked to the Accrued Expenses liability line, and it will show a green tick to indicate that the balance per the workpaper agrees to the balance as per the General Ledger.


Graphical user interface, application

Description automatically generated


Complete the above process for all accounts requiring non-standard worksheets when reconciling their balances.

 

Next articleHow to change workpaper status.

Did you find it helpful? Yes No

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