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

Insert variables in Excel from the Onvio Office add-in

You can insert amount variables, text variables, and create formulas based on information that is linked to from Onvio Trial Balance. By using the integrated features within the Onvio Office add-in ribbon, you can simplify your reporting needs in Microsoft Excel.

Amount variables

Use the
Amount Variables
 tab to define variables for specified amount types, accounts, types of accounts, and other values, and insert them into the selected cells of the Microsoft Excel worksheet.
  1. Select the
    Amount Variables
     tab in the
    Insert Variables
     panel.
  2. Select one of the following
    Amount Types
     to insert into the worksheet.
    note
    Selections vary in the
    Amount Variables
     tab based on the selected
    Amount Type
    .
    • GL Account data
      • Account Number
      • Account Description
      • Amounts (Balance, Debit amount, Credit amount)
    • Grouping Schedule data (for example, Account Classification)
      • Code/Subcode
      • Code/Subcode Description
      • Total Amounts (Balance, Debit, and Credit, based on account grouping)
    • Tax Grouping Schedule data
      • Tax Code/Subcode
      • Tax Code/Subcode Descriptions
      • Total Amounts (Balance, Debit, Credit, based on account grouping)
    • Net Income amounts
  3. Select the Insert button to insert the variable into the selected cells of the worksheet.

Text variables

Use the
Text Variables
 tab to define and insert text variables based on the current binder records and contact information that is linked to from Onvio Trial Balance.
  1. Select one of the following
    Sources
     to insert into the worksheet.
    note
    Detail selections will vary in the
    Text Variables
     tab based on the selected
    Source
    .
    • Workpaper Properties (for the Excel file that is currently open)
      • Reference
      • Name
      • Staff Assignment
      • Signoffs (Preparer and Reviewer)
    • Contact name (the contact for which the Excel file is currently open)
    • Binder Properties
      • Binder Name
      • Binder Type
      • Binder Period Ending date
  2. Select the Insert button to insert the variable into the selected cells of the worksheet.

Formulas

Use the
Formulas
 tab to create and apply variable formulas for selected amount variable rows by using the add (
+
), subtract (
-
), multiply (
*
), and divide (
\
) operators.
  1. Select the
    Formulas
     tab in the
    Insert Variables
     panel.
  2. Select
    Add Row
     to insert a row in the
    Formulas
     grid.
  3. In the 1st row of the grid, select an amount type, amount detail (that is, account or code, if necessary), and balance type.
    note
    These parameters are specific to each row.
  4. Select an operator to apply to the next row.
  5. Repeat step 2-4 for the next row and for subsequent rows, if necessary.
  6. In the fields following the Formulas grid, select the period and fiscal year for the current contact.
  7. Select the
    Insert
     button to add the result of the calculation into the selected cell.
note
  • The application prompts you to specify a value for
    Amount Detail
     if it is not included when you attempt to insert a row—unless
    Net Income
     is selected as the
    Amount Type
     value.
  • The application inserts an add (
    +
    ) operator by default if it is not selected when an
    Amount Type
     value is selected.
  • You don't need to include an operator after the last row that has an
    Amount Type
     selected.
  • Amount formulas can be easily copied from a range of cells into another range of cells.
Internal use only
  1. If the add-in doesn't appear in Excel after installing, turn off the Onvio Office Excel add-in. In Excel, select
    File
    Options
    Add-ins
    . In the
    Manage
     field, make sure
    Excel Add-ins
     is selected, and select
    Go
    . Clear the checkbox for
    CS.Accounting.Excel.Automation
    .
    Excel option 1
  2. Go to
    File
    Options
    Add-ins
    . In the
    Manage
     field, select
    COM Add-ins
    , then
    Go
    . Clear the checkbox for
    CS.Accounting.OfficeIntegration.ExcelVstoAddin
    .
    Excel option 2
  3. Close any open Excel spreadsheets.
  4. Sync and close all open items in Onvio Link.
  5. Open an Excel spreadsheet from within the
    Binder
     tab, and verify that the Onvio Office Add-in ribbon is present in Excel. (If the ribbon is present, you should be able to re-enable the CS.Accounting add-in without causing an issue.)
note
  • The user may have to repeat these steps again after updating or reinstalling the add-in.
  • Copy
     and
    Paste
     in Excel stops working after inserting a variable until you double-click a blank cell—which makes the cursor visible in the cell. Development is currently looking into this issue.

This article applies to:

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