Review group and account balances in the financial statements

You can review group and account balances in the financial statements document to understand how the numbers are calculated. Information about rounding and balance discrepancies is marked in the tables to help you produce reliable, accurate and high-quality financial statements.

View rounding details in financial statements

To view rounding details in a table row, select the asterisk (*) next to the row. A popup displays showing:

  • The total rounding differences for the current year and prior year.
  • The account where rounding differences apply for the current year and prior year.

In this example, a total rounding difference of $3 is added to the balance of 1.2.120.500 Property, Plant and equipment - Accumulated depreciation and impairment for the current year. For the prior year, a total rounding difference of $2 is added to the balance of 1.1.000.050 Cash.

Rounding Details dialog

If you select the balance of the account where rounding differences apply, the Account Details popup displays a highlighted line showing the rounding details.

Account Details popup showing rounding information in financial statements

Note: If a trial balance value is rounded to zero, the table row displays in gray in the financial statements and is not included in print preview or in the PDF print copy. Note that this does not apply to parent level rows which always display in the financial statements and are included in the print preview and the PDF print copy.

To learn more about rounding logic in financial statements, see Rounding in financial statements.

Change the account where rounding differences apply

You can change the account where rounding differences apply to have them added to a financial statements line item that's frequently used in your market, for instance.

To change the account where rounding difference are applied:

  1. Select the row with an asterisk (*).

  2. The Rounding Details popup opens.

    Tip: If the row is an account, then the asterisk (*) denotes that rounding differences are applied in this account. If the row is a group, then it denotes that rounding differences are applied to an account in this group.

  3. Select the account name at Current year.

  4. A list showing the trial balance groups and accounts displays.

  5. Select the desired account from the list.

  6. Select the account name at Prior year then select the desired account from the list.

  7. Rounding differences for the current and prior years are now applied to the balances of the selected accounts respectively.

View balance discrepancies in financial statements

Note: This feature is only available if it's set up in your product.

To help you reconcile account balances, table rows can be compared to each other in the financial statements. For example, to assist accountants in reconciling statement line items with totals in the notes section.

Upon comparison, a stop sign icon () is available at each row where balance discrepancies have been identified.

Note that:

  • You cannot choose the rows that the application compares. They are predefined in your product.

  • The application compares the absolute values of the applicable rows. Sign differences are not flagged as balance discrepancies.

To view balance discrepancies, select the stop sign icon (). A popup displays showing:

  • The rows in other tables within the document that have been compared to the current row.
  • Balances that agree with the current row.
  • Balances that don't agree with the current row.

Tip: You can also select the View Row icon () to go to the specific row of each listed account and view its data.

Balance check showing a discrepancy.

Override balances in financial statements

As you review the balances in the financial statements document, you might need to override trial balance values in the tables. For example, to modify a certain balance in the financial statements to reflect the exact balance that your clients had in their prior year financials.

Note: If you override a trial balance value to zero, the table row displays in gray in the financial statements and is not included in print preview or in the PDF print copy. Note that this does not apply to parent level rows which always display in the financial statements and are included in the print preview and the PDF print copy.

To override an account balance:

  1. Select the balance that you want to change.

  2. Enter the new amount.

  3. A dashed border displays to mark the cell as Balance Overridden.

Trial balance cell with overidden balance in financial statements

To override a group total:

  1. Select the group total that you want to change.

  2. Enter the new amount.

    • If there is one account in the group, the difference automatically applies to this account.

    • If there is more than one account in the group, a dialog displays showing the difference (between the new amount and the old amount). It also prompts you to select the account where you want the difference to apply.

      Dialog to select an account in the group where you want the difference to apply

Note that if you select a cell with overridden balance, the Account Details popup displays a highlighted line showing the original balance for that cell (the trial balance amount).

Tip: To revert to the original amount, select Revert ().

Account Details showing an overridden balance