Release notes for Onvio Trial Balance

April 29, 2021

Predictive Tax Code Mapping

Tax codes are now predicted based on account descriptions during the spreadsheet import process for Individual, Corporation, S Corporation and Partnership entities.

April 1, 2021

Trial Balance opens to Trial Balance tab

When you open a project, Trial Balance will open to the Trial Balance tab.  It previously opened to the Settings tab.

February 4, 2021

Updated tax exports

We have updated tax exports to ProSystem fx and Lacerte for the 2020 tax year.

January 7, 2021

Tax Grouping Schedules updated for 2020

We updated the Groupings tab to include a Tax Grouping Schedule for integration with UltraTax CS 2020.

Show workpaper references on reports

You can now choose to include a WP Reference column on the Chart of Accounts and Trial Balance reports.

December 10, 2020

Year end close balance distribution

You can now distribute net income/loss to selected equity accounts and add equity accounts on the fly when closing a year. Asset, liability, equity, and memo account balances are automatically carried forward to the new year.

October 29, 2020

Integration with QuickBooks Online

For annual clients, you can import accounts and balances directly from QuickBooks Online into the Trial Balance screen with the flexibility to add new accounts and to map existing accounts. Learn more

September 17, 2020

Adjustments - Add accounts on the fly

You can now add accounts on the fly when entering distributions for an adjustment, instead of needing to go to the Trial Balance tab to add a new account.

August 20, 2020

Spreadsheet import

You can now map accounts in the spreadsheet to existing accounts in Onvio, or add them as new accounts. Your mappings are saved after the first successfully completed import and can be used in subsequent imports.

Note: Onvio will automatically map accounts based on the Account Number and Account Description.

July 23, 2020

Spreadsheet import

When finishing an import from a spreadsheet and the imported unadjusted balance is out of balance, you now have the option to import the out of balance amount into a selected balancing account.

Internal notes


January 9, 2020

Hide zero rows

We have added a Hide zero rows switch above the Trial Balance grid that allows you to hide rows when there are zeros in all the balance columns in the current trial balance view.

Updated tax grouping schedules

We have updated the tax grouping schedules that are available from the Groupings tab for integration with the 2019 version of UltraTax CS.

Updated tax exports

We have updated tax exports to ProSystem fx and Lacerte for the 2019 tax year.

October 3, 2019

Include or exclude adjustments in the trial balance

The following improvements have been made in the Adjustments screen.

September 5, 2019

Import beginning balances in the Trial Balance screen

You can now import and define beginning balance columns from a spreadsheet in the Trial Balance screen.

Edit beginning balances in the Trial Balance screen

You can now edit beginning balances for balance sheet accounts for the current year in the Beginning Balance columns on the Trial Balance screen.

Copy and paste adjustments in the Adjustments screen

You can now copy an adjustment in the Adjustments grid and paste it the same as the original, with the debits and credits reversed, or without any debit or credit values.

Zero beginning balances

You can now zero beginning balances for an account when moving to the next fiscal year for a contact when the contact has accounts with activity and/or adjustments.

August 8, 2019

Re-order adjustment rows in the Distributions grid

You can now select an adjustment row and move it up or down in the Distributions grid on the Adjustments tab. Click any cell in the row, except the one in the Account column, and drag it to the desired location. (A yellow line appears as you drag the row.)

June 13, 2019

Separate or combine debit and credit columns - Trial Balance screen

You can now mark or clear the Display separate debit/credit columns checkbox in the Manage Views screen to make balance columns either combined or separate debit/credit columns.

Prior year unadjusted column - Trial Balance screen

The Unadjusted balance column for the prior year is now read only in the Trial Balance screen. To edit prior year balance amounts, you must revert to the prior year by changing the current period in the Settings tab.

Prior year adjustments - Adjustments screen

Prior year adjustments for a contact in the current year are read only. To edit prior year adjustments, you must revert to the prior year in which the adjustment was made by changing the current period in the Settings tab.

March 21, 2019

Rounding - add on the fly

You can now add accounts on the fly from the Rounding Setup panel after you enable rounding.

Export to Lacerte

You can now export the contact's tax data to Lacerte.

New Tax Grouping report

You can now create a Tax Grouping report that groups the contact's accounts under each tax code/subcode. This report provides a method for you to verify balances before and after importing them into other tax applications.

February 21, 2019

Round balance amounts

You can now turn on rounding for your contacts' account balances and specify the account to use for rounding each account type.

Improvements in the Periods screen

The following improvements have been made to the Periods screen.

  • You can now click the Add New Fiscal Year link to open a separate screen to add a new fiscal year by selecting the Year Begin/Year End dates, Tax year date, and defining the period.
  • You can now define the current period via the Current Period field in the Application Periods section.
  • You can now define the year begin date and year end date from the Edit Periods screen.

Create reversed entries in the Adjustment tab

You can now create reversed entries for accounts in the Adjustments tab so that when you advance the period, those amounts appear as reversed in the Trial Balance tab and Adjustments tab.

January 24, 2019

Export to ProSystem fx

You can now export the contact's tax data to ProSystem fx.

December 27, 2018

Edit periods via the Edit Periods link

You can now edit periods, period frequency, and set the current period for a selected fiscal year via the Edit Periods link in the Periods tab for a selected contact.

Assign grouping codes when adding or editing accounts in the trial balance

You can now select grouping assignments for a selected account when adding or editing accounts in the trial balance.

Updated tax grouping schedules

We have updated the tax grouping schedules that are available from the Groupings tab for integration with the 2018 version of UltraTax CS.

November 29, 2018

Edit grouping codes and subcodes in the Trial Balance grid

You can now select grouping codes and subcodes for a specified grouping schedule from the available drop-down lists in the Account Grouping column of the Trial Balance grid.

November 1, 2018

Add workpaper references in the Adjustments screen

You can now add workpaper references via the Workpaper Reference columns for adjustment and distribution rows in the Adjustments screen.

October 4, 2018

View balance definitions from the Setup menu

You can now choose Setup > Balance Definitions to view (read only) the journal entry types that are included in the calculation of each balance type for the current contact.

Balance type options in the Trial Balance report

You can now select which balance type to run for the Trial Balance report from a list of available balance types.

September 6, 2018

Adjustments

We have updated the look of the Adjustments screen so that the two sections are now divided horizontally instead of vertically, added the ability to filter columns in the Adjustments grid, and added a Total and Difference row to the Distributions grid.

Reports

We have added Reclassifying and Other journal entry types as optional sections to include in the Adjusting Journal Entry report.

August 9, 2018

Reports

You can now create a Grouping Schedule report based on tax schedule.

July 12, 2018

Reports

You can now select additional account balance columns, and optionally separate the debit and credit columns for adjustments in the Trial Balance Worksheet.

June 14, 2018

Reports

You can now create a Grouping Schedule report that includes account balance information and the corresponding adjusting entries organized by grouping schedule.

May 17, 2018

Trial Balance

You can now add the following types of columns to the Trial Balance grid via the Manage Views screen in the Trial Balance tab.

Reports

You can now create a Trial Balance Worksheet report that includes account balance information and the corresponding adjusting entries.

April 19, 2018

Trial Balance

You can now perform the following tasks in the Trial Balance screen.

  • Open the Manage Views screen from the Trial Balance tab to add, delete, modify column details, and freeze columns in the Trial Balance grid.
  • Sort account number columns alphanumerically.
  • Filter and search columns in the Trial Balance grid.

Contact us

Was this article helpful?