Update Status for Groups

All the companies within a group have to be reconciled or ready before a group's status can be set to ready.

For more information, see Company Reconciliation.

Procedure

  1. On the Group menu, click Reconcile/Between Accounts/Opening Balances for Groups. The Reconcile - Between Accounts/Opening Balances for Groups window opens.
  2. Select the reconciliation reports you would like to run:
    • Reconciliation
    • Analyze Differences by Extended Dimension and enter the relevant dimension code in the text box.
    • Analyze Differences by Automatic Journal Type
  3. Enter the actuality, period and submission you want to run the reconciliation for.
  4. If you want to reconcile a group, select the Group option button and enter the consolidation type and group code. If you want to reconcile one or several groups, select the Company option button and enter the group code(s). Select Include Subgroups to include subgroups in the reconciliation. This choice will display all Groups regardless if the Group is connected or not.
  5. Select the relevant reconciliation options:
    • Debit/Credit: Select this option to reconcile between debit/credit accounts within the selected form sets. Accounts defined as A, L, E, I or C are reconciled using a debit/credit reconciliation. When the reconciliation is run, the sum of all type A accounts is compared with type L and E accounts. The net income will not be retrieved from the balance sheet, but the profit and loss, according to the settings in the General Configuration. Debit/Credit reconciliation is carried out on all journal types and for all Automatic Journal Types.
    • Between Accounts: Select this option to reconcile values between accounts. Between Accounts reconciliation is carried out on all journal types or by a specific closing version, and for all Automatic Journal Types.
    • Opening Balances: Select this option to reconcile opening balances. Opening Balances reconciliation is carried out on all journal types or by a specific closing version, and for all Automatic Journal Types.
  6. If you want to perform the reconciliation per journal type, select the Journal Type option button. If you want to perform the reconciliation per closing version, select the Closing Version option button and enter the name of the closing version. The default values for these settings come from the General Configuration, Reconcile tab.
  7. Select the option Only Show Rows with Differences to minimize the report. Default is to include all rows with differences, but if you have selected Differences per Row in the General Configuration, you can also select to see only the rows that exceeds the maximum accepted difference. The maximum accepted difference is set in the General Configuration.
    Note: This is not applicable for the reports Analyze Differences by Extended Dimensionand Analyze Differences by Automatic Journal Type. For these reports, the report will always be displayed with All Differences and not Differences per row.
  8. Click the Preview button to generate the report.

Results

  • If the reconciliation report shows differences between Debit/Credit, even though there are no reported differences, run the Verify Account Structure report to see if any of the accounts in the forms may be defined as Debit or Credit accounts instead of statistical accounts.
  • You can select the Ignore Balance check box in the Define Submission window to disable the debit/credit control. This also enables you to enter journal entries that do not balance.
  • If you would like to use the report options Differences Greater than Accepted Amount, you will need to define a maximum accepted difference in the General Configuration.
  • If you are working with investment adjustments and want to include them in the closing balances values when reconciling between closing and opening balances, select the Enable Reconciliation Between Closing and Opening Balances for Investment Adjustment check box in General 2 tab of the General Configuration window.

Tip: When selecting Company, all Groups are displayed regardless of if the Group is connected or not in the tree structure, whereas Group only presents the connected group to the specified structure.