Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Trial Balance

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

  1. Select the
    Trial Balance
     tab, then
    Manage Views
    .
  2. In the
    Columns
     section, select
    Add
    . The new column is highlighted.
  3. In the
    Column Details
     section, select
    Workpaper Reference
     from the
    Column Type
     dropdown.
  4. Select a period from the
    Period
     dropdown.
  5. Select
    Save
     to update the trial balance view.
note
  • You can add multiple workpaper reference columns for the same and different periods.
  • The list of periods in the
    Period
     field is based on the periods that have been set up for the contact in the
    Period
     tab of the
    Setup
    Contacts
     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.
  1. Select
    Attach WP Reference
     in the WP Reference column for a selected account in the Trial Balance grid to open the
    Attach Workpaper Reference
     panel.
  2. Go to the folder in the binder and select a document.
  3. Select
    Attach
     to create a link in the workpaper reference column for the selected item.
    note
    You 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.

This article applies to:

  • PRODUCT: Onvio
  • Subject: Trial balance
  • Audiences: Staff