Creating or modifying an income statement template

The Income Statement Template Builder allows anyone with the PR Admin and PR Analyst roles to easily and quickly configure income statements for their organization. The templates created using this wizard display to all Axiom Performance Reporting users in the Income Statement Viewer.

Template building includes five main steps:

  • Step 1: Define the template - Use this page to select the ACCT dimension column in which to pull in data to the income statement. By default, the template includes FSSummary and FSDetail. The FSSummary template only displays summary data to users, while FSDetail includes the line item details. You can include other columns in the template builder, but you need to configure them in the ACCT dimension before they will display as an option. For more information, see Configuring ACCT dimension columns for the Income Statement and Balance Sheet Template Builders.

  • Step 2: Define Sections - This step allows you to name the major sections of your income statement. By default, pre-loaded names are defined, but you can change them to best meet the needs of your organization. This step also displays the filters used to pull in the data for each section.

    NOTE: These filters cannot be changed, even if using a column other than FSSummary or FSDetail. These filters are based on best practices related to creating income statements.

  • Step 3: Determine Subtotal Groups - Within each section, you can group the data that comes in from the filters into subgroups. In the following example, the Inpatient and Outpatient revenue are configured to display in subtotal Group 1, and Other Patient Revenue displays in subtotal Group 2.

  • Step 4: Configure Subtotal Groups - This page allows you to rename the subtotal group as well as the line item detail names from the filter. You can reorder how you want the line item details to display as well as exclude line items, which the system then excludes from the subgroup totals.
  • Step 5: Summary and Preview - From this step, you can preview the template based on the selections and configurations you selected. You can return to the wizard to make any necessary changes. When you are ready to make the template available to users, publish the template, and it will display in the Income Statement Viewer.

At the top of the template builder, the system displays the details about the template, including its publication status.

Templates display as one of the following:

  • Pending - The template has not been selected for editing.

    NOTE: For Pending templates, you must complete and save the configurations for each step in the order they are presented. After you complete and save all of the steps, the template changes to Draft, at which point you can move around the steps freely to make modifications.

  • Draft - Any stage during the creation of the template but before the Publish toggle has been selected.

  • Published - The template has been published to the Income Statement Viewer. If the template is unpublished, the status changes back to Draft until it is published again.

    NOTE: If you make and save changes to a published template, the system automatically changes the template to Draft, at which point you will need to click the Publish toggle to Yes to publish the template again.

To create or modify an income statement template:

  1. In the Mgmt Admin task pane, in the Management Reporting section, double-click Income Statement Template Builder.

  2. Do one of the following:

    To... Then...
    Create a new template
    1. From the Group By Column drop-down, select the column in the ACCT dimension table based on the amount and type of data to show.
    2. Click + Create New Template.
    Modify a template
    1. From the Group By Column drop-down, select the ACCT dimension column in which the template is based.

    2. From the Saved Templates drop-down, type or select the template to modify.

      TIP: After you select the column, the page displays a number next to the Saved Templates title to indicate the number of available templates you can select from.

    3. Click Modify Template Details.

  3. In the Create/Modify Template dialog, complete the following fields, and click Save:

    Field Description
    Display Name

    Type a name for the income statement.

    TIP: This name displays in filter of the Income Statement Viewer as well as the header at the top of the income statement page.
    Description

    Type more information about this template.

    NOTE: This information only displays in the Income Statement Template Viewer.
    View Select how to view the income statement date.
    12-Month

    If you select 12-Month from the View drop-down, select the type of 12-month view to display.
    Target

    Select the budget target.

    NOTE: This drop-down is not enabled when you select 12-Month or Entity from the View drop-down. We recommend, however, that you set a target - even if it is not the default view - because this information is passed on the to the drills in the income statement.

  4. Click Next.

  5. In the Step 2 page, in the Display Name column, modify the names used as section headers in the income statement, as needed, and click Save.

    TIP: If you are building a template based on a column other than FSSummary or FSDetail (especially a customized column), you may want to rename the section headers to best suit the needs of your organization.

  6. Click Next.

  7. In the Step 3 page, from the Subtotal Group column drop-down, you can group individual line item categories into different subtotal groups by selecting a subgroup number, and click Save.

  8. Click Next.
  9. In the Step 4 page, do any of the following, and click Save:
    • To change the name of the subtotal group, edit the name in the Subtotal Group column.
    • To reorder the line item, select the order number from the Order column drop-down.
    • To change the name of the line item, edit the name in the Display Name column.
    • To exclude the line item from displaying in the statement, click the check box in the Exclude column.
  10. Click Next.
  11. In the Step 5 page, do one of the following:

    • To show a preview of the template, click Click to Preview Template. For more information on how to navigate the income statement, see Steps 2-3 in Viewing income statements.

      TIP: To fine tune your template, return to the Income Statement Template Builder and repeat steps 2-10.

    • To publish the template to the Income Statement Viewer, click the Publish toggle to Yes.