Browse articles

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. Click 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. Click 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. Click 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. Click the Formulas tab in in the Insert Variables panel.
2. Click Add Row to insert a row in the Formulas grid.
3. In the first row of the grid, select an amount type, amount detail (i.e., account or code, if applicable), 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 below the Formulas grid, select the period and fiscal year for the current contact.
7. Click the Insert button to add the result of the calculation into the selected cell.

Microsoft Excel Onvio Office add-in

Update data in Excel workpapers via the Onvio Office add-in