Creating a Reconciliation report

To create a Reconciliation report:

  1. Open the Reconciliation Report page.
  2. Select a period. Separate lists display for unmerged Period and Year dimensions.
  3. Select a version.
  4. Select the currency of the posted data. Reference, Reclassification, and Ownership journal adjustments do not display for local currency, because these journals do not post to local currency.
  5. Select a rate set.
  6. Select the accumulation method.
  7. To change these dimension members, click the underlined dimension name, and select members from the dialog box.
    1. Select one or more units.
    2. Select one or more schedules or lines. Selecting a schedule automatically includes its accounts.
    3. Select one or more custom dimension members.
  8. Click Options. These options are available:
    Option Description
    Round to 0 decimal places Select this check box to round database values You can select the decimal precision.
    Suppress Zeroes Select this check box to eliminate lines with null and/or zero database values. Click
    Display Net Totals Per Journal Type Select this check box to display one net amount for each journal type in cases where two or more journal types adjust the same account for the same unit. If the option is cleared (default), only one net amount displays for the line.
  9. Generate Report.