Using the Bilan Actif et Passif Dashboard

Note:

This dashboard requires your corporate chart of accounts to be France. To view this dashboard correctly, with all GLAs mapped to their respective reporting categories, you must go to General Ledger Accounts in Accounting and ensure there are local balance sheet and local balance sheet order values defined for all GLAs.

The Bilan Actif et Passif dashboard enables you to run your balance sheet reports in Financial Statements and view the resulting data within the dashboard. This dashboard uses the Financial Transactions dataset and contains:

  • Prompts: filter by company, currency, year, and period.
  • Tabs: Actif and Passif.
  • Drill down: select any row and click Voire Détails >. To return to the previous view click < Bilan. This enables you to view an analysis of the individual transactions which sum the total values in that row. This functionality is not available for the two rows titled "TOTAL". If you attempt to drill these rows, a "No Results Found" message is displayed. Drill is possible for the row titled "TOTAL GÉNÉRAL".

To filter the report data:

  1. Use the Enterprise drop-down to select the company you want to see data for.
  2. Use the Devise drop-down to select between home (Locale) or dual (Du Groupe) currency.
  3. Use the Année drop-down to select the year you want to see data for.
  4. Use the Période drop-down to select a period.
  5. Use the Période d'Ajustement 100 drop-down to select if you want to include or exclude period 100. All other special periods up to the year and period selected are always included. For a definition of the special periods, see Financial Balances Fields.
  6. Use the tabs to choose between Actif or Passif data.

Adding GLAs Manually

If you create GLAs manually, you must ensure that your GLA names have a space between the Reporting Code and the GLA name. For example, use "100 Capital", not "100Capital".

Even if your GLAs were loaded automatically using Chart of Accounts Localization, if you want to create a new GLA manually, you must follow the format indicated.

Other suitable examples are:

  • 100 - Capital
  • 100 . Capital

Do not use:

  • 100-Capital
  • 100.Capital