Financial Summary report

You can see the financial effects of employee-related costs on a general ledger directly in Workforce Budgeting. Review these costs before they are transferred to the Finance core and included in the main budget.

This report displays salary, pay, and benefit costs by accounting unit. Employee costs by accounting unit become available after these steps are performed:

  1. The configuration set is configured for Workforce Budgeting.
  2. Employee-related metadata is imported from client's source systems.
  3. Calculations are started and allocations are performed.
    Note: To see up-to-date data on the Financial Summary report, we recommend that you re-start allocations. This step ensures that employee costs reflect any changes to the initially imported and calculated data. You can re-start allocations through the Employee Roster or the Allocation Report.

To access the Financial Summary Report, select Home > Module Settings and Budgeting > Reporting > Financial Summary Report.

To configure the report, select these parameters:

  • Configuration set
  • Version
  • Entity
  • Organization
  • Start Period
  • End Period

Report shows how salaries, salary-related actions, and different pay and benefit actions affect the total costs for the selected account. The financial costs are displayed for each period and the total value for the selected date range is provided. The Report Total value at the bottom of each page relates to the sum of cost records per period on all pages and is repeated on every page.

Use the Columns button to switch the Periodicity between Years and Months, or limit the information that is displayed in the report. You can change the display format of Account and Pay and Benefit columns, or hide Pay and Benefit column so that only Total costs per Account are shown.

To filter the accounts or pay and benefits that are displayed in the report, specify a code or account name in the report header, according to the display format. Displayed records can be sorted by the account code or account name, pay and benefit code or name, total column, or value for the selected period.

Use Row button to switch off or on zero suppression and pagination. By default, zero suppression is activated in the report. If deactivated, the report displays all accounts that are activated for Workforce Budgeting and all pays and benefits assigned to the selected account, regardless of whether they include any employee associated costs.

Use Data button to adjust scaling and number of decimals, to clear all previously applied filters, hide or enable column filters.

You can export the report into an Excel or a PDF file.

Reset All Settings option under Views button resets table settings to these default values:
  • Account and Pay and Benefit columns are displayed in ID-Name format.
  • Scaling is set to No.
  • Number of decimals set to 2.
The grid data is reloaded accordingly, but does not affect the context selection.