Automatic rounding for balance sheets in Management Reporter

When amounts are rounded to whole dollars, thousands, or millions, totals may be out of balance. The following table shows how amounts are rounded.

Row Code

Amounts without rounding

Amount with rounding to whole thousands










In this table, the total of rows 100 and 200 differs when rounding is turned on. When you use the rounding option in a balance sheet report, you can use the rounding adjustment in the row definition to balance the amounts in balance sheets when the report definition specifies rounding.

Adjust rounding in balance sheet reports

  1. Open the row definition that you want to adjust.

  2. On the Edit menu, click Rounding Adjustment.

  3. In the Rounding Adjustments dialog box, enter the following values:

    • Rounding adjustment row

      The row code for the row that will be adjusted to balance the balance sheet.

    • Total assets row

      The row code for the row in the balance sheet that contains the total assets.

    • Total liabilities and equity row

      The row code for the row in the balance sheet that contains the total liabilities and equity.

    • Adjustment amount limit

      The limit (expressed as a positive whole number) on automatic adjustments. Microsoft Office PerformancePoint 2007 Management Reporter compares this amount with the absolute value of the actual rounding difference.

      Note: These row codes must be linked directly to your financial data. In other words, the row must have a segment or dimension value in its Link to Financial Data Source cell.Do not reference a description, calculated, or totaled row.

The amounts in your balance sheet will balance even when rounding is turned on.

Note: Management Reporter applies the adjustment limit based on the Rounding precision option that is specified for the report definition. For example, if you select to round your report to thousands and enter 2 in the Adjustment amount limit box, Management Reporter displays a warning message when the value identified in the Rounding adjustment row box increases or decreases by more than $2,000.

For more information about rounding, see Specifying rounding.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!