Workpaper reference columns
Before you can add and edit workpaper references in the
Trial Balance
screen, you first need to add a Workpaper Reference column to the grid via the Manage Views
screen.note
If you are licensed for Onvio Trial Balance and have Onvio Link installed, you can create and insert a link to a selected workpaper in the binder.
Add a Workpaper Reference column
- Select theTrial Balancetab, thenManage Views.
- In theColumnssection, selectAdd. The new column is highlighted.
- In theColumn Detailssection, selectWorkpaper Referencefrom theColumn Typedropdown.
- Select a period from thePerioddropdown.
- SelectSaveto update the trial balance view.
note
- You can add multiple workpaper reference columns for the same and different periods.
- The list of periods in thePeriodfield is based on the periods that have been set up for the contact in thePeriodtab of the screen.
- When the current period for a contact is changed, the prior workpaper references for the columns linked to that period are no longer displayed.
- You can select the down arrow button of the Workpaper Reference columns to sort items in ascending or descending order and to filter by condition or value.
- You can add a comment to selected account rows.
Add a workpaper reference
Select
Add WP Reference
in the WP Reference column for a selected account in the Trial Balance grid and enter a workpaper reference.note
You can use any combination of alphanumeric characters or special characters in the WP Reference text.
Insert a workpaper reference as a link
For licensed users of Onvio Trial Balance, you can add a link to a related document in the
Binder
tab for the current contact.You need to have Onvio Link installed to download and view linked documents in the Workpaper Reference column.
- SelectAttach WP Referencein the WP Reference column for a selected account in the Trial Balance grid to open theAttach Workpaper Referencepanel.
- Go to the folder in the binder and select a document.
- SelectAttachto create a link in the workpaper reference column for the selected item.noteYou can select a workpaper link in the Workpaper References column to open the linked document in its native application (for example, Microsoft Word, Excel, or Adobe Reader). If the link is associated with a Guided Assurance workpaper, the document is opened in the Guided Assurance application in a separate browser window.